Clone of UAS2 @ https://github.com/drudgedance/uas2

classc_database.html 34KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591
  1. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  2. <html xmlns="http://www.w3.org/1999/xhtml">
  3. <head>
  4. <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
  5. <title>UAS2: cDatabase Class Reference</title>
  6. <link href="tabs.css" rel="stylesheet" type="text/css"/>
  7. <link href="doxygen.css" rel="stylesheet" type="text/css"/>
  8. </head>
  9. <body>
  10. <!-- Generated by Doxygen 1.6.2 -->
  11. <div class="navigation" id="top">
  12. <div class="tabs">
  13. <ul>
  14. <li><a href="main.html"><span>Main&nbsp;Page</span></a></li>
  15. <li class="current"><a href="annotated.html"><span>Classes</span></a></li>
  16. <li><a href="files.html"><span>Files</span></a></li>
  17. </ul>
  18. </div>
  19. <div class="tabs">
  20. <ul>
  21. <li><a href="annotated.html"><span>Class&nbsp;List</span></a></li>
  22. <li><a href="hierarchy.html"><span>Class&nbsp;Hierarchy</span></a></li>
  23. <li><a href="functions.html"><span>Class&nbsp;Members</span></a></li>
  24. </ul>
  25. </div>
  26. </div>
  27. <div class="contents">
  28. <h1>cDatabase Class Reference</h1><!-- doxytag: class="cDatabase" -->
  29. <p><a href="classc_database-members.html">List of all members.</a></p>
  30. <table border="0" cellpadding="0" cellspacing="0">
  31. <tr><td colspan="2"><h2>Static Public Member Functions</h2></td></tr>
  32. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a28e6f9bb76889a1b5a84acb8e9670cef">AddToInventoryDB</a> (DWORD dwAvatarGUID, <a class="el" href="classc_object.html">cObject</a> *pcObj)</td></tr>
  33. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#aaebd59281d93e6ad63014bd1c2653121">RemoveFromInventoryDB</a> (DWORD dwAvatarGUID, DWORD dwObjectGUID)</td></tr>
  34. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#aad99ea2171588f78c51f97a148a2467e">AddSpell</a> (DWORD dwAvatarGUID, int SpellCount, int SpellID)</td></tr>
  35. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a5fd805d2028347fd2c289208c99b7fae">AddSpellToTab</a> (DWORD dwAvatarGUID, int SpellID, int SpellCount, int TabID)</td></tr>
  36. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a65109daec2fa8fda2569d153c33cd9b2"></a><!-- doxytag: member="cDatabase::AddGeneralItems" ref="a65109daec2fa8fda2569d153c33cd9b2" args="(DWORD dwAvatarGUID)" -->
  37. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddGeneralItems</b> (DWORD dwAvatarGUID)</td></tr>
  38. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aaa5d58620c3aa3b68969a19563a7c692"></a><!-- doxytag: member="cDatabase::AddRaceItemsAluvian" ref="aaa5d58620c3aa3b68969a19563a7c692" args="(DWORD dwAvatarGUID)" -->
  39. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddRaceItemsAluvian</b> (DWORD dwAvatarGUID)</td></tr>
  40. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a35883d7436a5cc671fc3422fb4f53c3a"></a><!-- doxytag: member="cDatabase::AddRaceItemsGharundim" ref="a35883d7436a5cc671fc3422fb4f53c3a" args="(DWORD dwAvatarGUID)" -->
  41. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddRaceItemsGharundim</b> (DWORD dwAvatarGUID)</td></tr>
  42. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a450c6c74f9dae207c2ea86008230b4ea"></a><!-- doxytag: member="cDatabase::AddRaceItemsSho" ref="a450c6c74f9dae207c2ea86008230b4ea" args="(DWORD dwAvatarGUID)" -->
  43. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddRaceItemsSho</b> (DWORD dwAvatarGUID)</td></tr>
  44. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a63d0e18a18c5f1326c0cef5943538b9d"></a><!-- doxytag: member="cDatabase::AddCasterItems" ref="a63d0e18a18c5f1326c0cef5943538b9d" args="(DWORD dwAvatarGUID)" -->
  45. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddCasterItems</b> (DWORD dwAvatarGUID)</td></tr>
  46. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a91ceb713699136cf3e23dddd09096a27"></a><!-- doxytag: member="cDatabase::AddFoci" ref="a91ceb713699136cf3e23dddd09096a27" args="(DWORD dwAvatarGUID, CreateCharacterMessage &amp;ccm)" -->
  47. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddFoci</b> (DWORD dwAvatarGUID, <a class="el" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;ccm)</td></tr>
  48. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a41f60018874714b4d0d4ca1356c844e1"></a><!-- doxytag: member="cDatabase::AddProfessionItems" ref="a41f60018874714b4d0d4ca1356c844e1" args="(DWORD dwAvatarGUID, CreateCharacterMessage &amp;ccm)" -->
  49. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>AddProfessionItems</b> (DWORD dwAvatarGUID, <a class="el" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;ccm)</td></tr>
  50. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a7654e7e59542c86f119ee8c51f3298c9"></a><!-- doxytag: member="cDatabase::SaveCharacterFlags" ref="a7654e7e59542c86f119ee8c51f3298c9" args="(DWORD dwAvatarGUID, DWORD Flags)" -->
  51. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>SaveCharacterFlags</b> (DWORD dwAvatarGUID, DWORD Flags)</td></tr>
  52. <tr><td class="memItemLeft" align="right" valign="top">static float&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a76c81cecb4a67596e8a793f735d17cfc">Hex2Float</a> (DWORD hexValue)</td></tr>
  53. <tr><td class="memItemLeft" align="right" valign="top">static DWORD&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a6eab03e92a2ff5f17fb78a7ef88c33f2">Float2Hex</a> (float floatValue)</td></tr>
  54. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ac049024118fd774ae7ed65ca8f669bec"></a><!-- doxytag: member="cDatabase::ReturnClass" ref="ac049024118fd774ae7ed65ca8f669bec" args="(DWORD dwClass)" -->
  55. static char *&nbsp;</td><td class="memItemRight" valign="bottom"><b>ReturnClass</b> (DWORD dwClass)</td></tr>
  56. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a5c6bb7d15116d91b2cb96af913cf8a7e"></a><!-- doxytag: member="cDatabase::ReturnGender" ref="a5c6bb7d15116d91b2cb96af913cf8a7e" args="(DWORD dwGender)" -->
  57. static char *&nbsp;</td><td class="memItemRight" valign="bottom"><b>ReturnGender</b> (DWORD dwGender)</td></tr>
  58. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a8e28f0a29d3ea87a3d8d06627eb3f486"></a><!-- doxytag: member="cDatabase::ReturnRace" ref="a8e28f0a29d3ea87a3d8d06627eb3f486" args="(DWORD dwRace)" -->
  59. static char *&nbsp;</td><td class="memItemRight" valign="bottom"><b>ReturnRace</b> (DWORD dwRace)</td></tr>
  60. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a40d6422a940bb27b59bd962391d226a7"></a><!-- doxytag: member="cDatabase::ReturnNamePrefix" ref="a40d6422a940bb27b59bd962391d226a7" args="(BYTE bLevel)" -->
  61. static char *&nbsp;</td><td class="memItemRight" valign="bottom"><b>ReturnNamePrefix</b> (BYTE bLevel)</td></tr>
  62. <tr><td colspan="2"><div class="groupHeader">Database Initialization and Loading</div></td></tr>
  63. <tr><td colspan="2"><div class="groupText"><p><a class="anchor" id="amgrp188865b9af4971b04b55c3850dd968a6"></a> Functions to initialize or load objects using database information </p>
  64. </div></td></tr>
  65. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a86d984a2a06e50372e31deb4a719d39c">Load</a> ()</td></tr>
  66. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a88534965abfb9b920c392c3bba7feed9"></a><!-- doxytag: member="cDatabase::Unload" ref="a88534965abfb9b920c392c3bba7feed9" args="()" -->
  67. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>Unload</b> ()</td></tr>
  68. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="adfa3927a6e4714baf82c942b58ab2ab5"></a><!-- doxytag: member="cDatabase::GetError" ref="adfa3927a6e4714baf82c942b58ab2ab5" args="(SQLSMALLINT type, SQLHANDLE *hptr)" -->
  69. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>GetError</b> (SQLSMALLINT type, SQLHANDLE *hptr)</td></tr>
  70. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a51439ceab280bd6314b898161ec73400"></a><!-- doxytag: member="cDatabase::InitializeSQLEnvironment" ref="a51439ceab280bd6314b898161ec73400" args="()" -->
  71. static int&nbsp;</td><td class="memItemRight" valign="bottom"><b>InitializeSQLEnvironment</b> ()</td></tr>
  72. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a75216f7521386fd1aa507d271f5020f7"></a><!-- doxytag: member="cDatabase::FreeSQLEnvironment" ref="a75216f7521386fd1aa507d271f5020f7" args="()" -->
  73. static int&nbsp;</td><td class="memItemRight" valign="bottom"><b>FreeSQLEnvironment</b> ()</td></tr>
  74. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ab7be1da498d03beccb94483738aa0dc0"></a><!-- doxytag: member="cDatabase::InitializeMaxModel" ref="ab7be1da498d03beccb94483738aa0dc0" args="()" -->
  75. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>InitializeMaxModel</b> ()</td></tr>
  76. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ab5ac4312c96a0331110021c3fb9297fc"></a><!-- doxytag: member="cDatabase::LoadModelList" ref="ab5ac4312c96a0331110021c3fb9297fc" args="()" -->
  77. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>LoadModelList</b> ()</td></tr>
  78. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a971d5e17c7bf5072a01e36b4c34c7920">InitializeAvatarGUIDs</a> (DWORD &amp;dwGUIDCycle_Avatar)</td></tr>
  79. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a1ec143c8df2037255b516e90f949502f">InitializeObjectGUIDs</a> (DWORD &amp;dwGUIDCycle_Object)</td></tr>
  80. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#ad391744378d124de24494a89a83c23ea">InitializeAllegIDs</a> (DWORD &amp;dwIDAllegiance)</td></tr>
  81. <tr><td class="memItemLeft" align="right" valign="top">static BOOL&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#ab793d77fb6edfb2842182e89606104e0">VerifyAccount</a> (char *szUserName, char *szPassword, DWORD &amp;dwAccountID, BOOL fCreate)</td></tr>
  82. <tr><td class="memItemLeft" align="right" valign="top">static BOOL&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a3bea15a901555ad5de25cedc8d14fe14">CreateAccount</a> (char *szUserName, char *szPassword, DWORD &amp;dwAccountID)</td></tr>
  83. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#ab084360e7e8ef9151f637c71d7adeff2">LoadAvatarList</a> (DWORD dwAccountID, std::vector&lt; <a class="el" href="structc_avatar_list.html">cAvatarList</a> &gt; &amp;AvatarList)</td></tr>
  84. <tr><td class="memItemLeft" align="right" valign="top">static BOOL&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#afb7edb8a6435462956f24aa9135e71b1">CreateAvatar</a> (DWORD dwAccountID, <a class="el" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;ccm, DWORD &amp;dwNewAvatarGUID)</td></tr>
  85. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a0c3c93587037123bf2765d91f133d5a5">DeleteAvatar</a> (DWORD dwAvatarGUID)</td></tr>
  86. <tr><td class="memItemLeft" align="right" valign="top">static void&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a7fdc554648e537f5e35bdbaa4175f1b0">LoadAvatar</a> (<a class="el" href="classc_avatar.html">cAvatar</a> *pcAvatar)</td></tr>
  87. <tr><td class="memItemLeft" align="right" valign="top">static BOOL&nbsp;</td><td class="memItemRight" valign="bottom"><a class="el" href="classc_database.html#a34968d28bf83bf9e65187458a5e3f8a2">LoadDungeonList</a> (char strName, std::vector&lt; <a class="el" href="structc_dungeon_list.html">cDungeonList</a> &gt; &amp;DungeonList)</td></tr>
  88. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a89555851e5616c04f33bb380728c2c38"></a><!-- doxytag: member="cDatabase::SetupDB" ref="a89555851e5616c04f33bb380728c2c38" args="(int DBType, char *szDBIP, char *szDBNAME, char *szDBUSER, char *szDBPASSWORD)" -->
  89. static void&nbsp;</td><td class="memItemRight" valign="bottom"><b>SetupDB</b> (int DBType, char *szDBIP, char *szDBNAME, char *szDBUSER, char *szDBPASSWORD)</td></tr>
  90. <tr><td colspan="2"><h2>Static Public Attributes</h2></td></tr>
  91. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a6955ae9b5bcfdb731a973f003fb57f9c"></a><!-- doxytag: member="cDatabase::m_hEnv" ref="a6955ae9b5bcfdb731a973f003fb57f9c" args="" -->
  92. static HENV&nbsp;</td><td class="memItemRight" valign="bottom"><b>m_hEnv</b> = 0</td></tr>
  93. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a7dd18be57cd2715df209c884a698424a"></a><!-- doxytag: member="cDatabase::m_hDBC" ref="a7dd18be57cd2715df209c884a698424a" args="" -->
  94. static HDBC&nbsp;</td><td class="memItemRight" valign="bottom"><b>m_hDBC</b> = 0</td></tr>
  95. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a849436ad665d16916d4b4917eb1ca2fe"></a><!-- doxytag: member="cDatabase::m_hStmt" ref="a849436ad665d16916d4b4917eb1ca2fe" args="" -->
  96. static HSTMT&nbsp;</td><td class="memItemRight" valign="bottom"><b>m_hStmt</b> = 0</td></tr>
  97. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a99de3630e5a4dbb586e2ce85fef4a19a"></a><!-- doxytag: member="cDatabase::wMaxModel" ref="a99de3630e5a4dbb586e2ce85fef4a19a" args="" -->
  98. static int&nbsp;</td><td class="memItemRight" valign="bottom"><b>wMaxModel</b> = 0</td></tr>
  99. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a4ab3e7c08e8e2369bac44078900e896a"></a><!-- doxytag: member="cDatabase::szModelName" ref="a4ab3e7c08e8e2369bac44078900e896a" args="[1000][5]" -->
  100. static char&nbsp;</td><td class="memItemRight" valign="bottom"><b>szModelName</b> [1000][5]</td></tr>
  101. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="aee976150876d86772fbef958801ef59e"></a><!-- doxytag: member="cDatabase::szModelNumber" ref="aee976150876d86772fbef958801ef59e" args="[1000][3]" -->
  102. static char&nbsp;</td><td class="memItemRight" valign="bottom"><b>szModelNumber</b> [1000][3]</td></tr>
  103. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a101733f0dd254d9578e0e2cbbf5cf41f"></a><!-- doxytag: member="cDatabase::szDBIP" ref="a101733f0dd254d9578e0e2cbbf5cf41f" args="[16]" -->
  104. static char&nbsp;</td><td class="memItemRight" valign="bottom"><b>szDBIP</b> [16]</td></tr>
  105. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="ac9fcaaa99c555bc30cf9adc1a5a3b4be"></a><!-- doxytag: member="cDatabase::szDBNAME" ref="ac9fcaaa99c555bc30cf9adc1a5a3b4be" args="[20]" -->
  106. static char&nbsp;</td><td class="memItemRight" valign="bottom"><b>szDBNAME</b> [20]</td></tr>
  107. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="abc06d45ef022837c25a63157c49f9226"></a><!-- doxytag: member="cDatabase::szDBUSER" ref="abc06d45ef022837c25a63157c49f9226" args="[20]" -->
  108. static char&nbsp;</td><td class="memItemRight" valign="bottom"><b>szDBUSER</b> [20]</td></tr>
  109. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a4c65f9d9121f2fc4e60bc0eb0cd65493"></a><!-- doxytag: member="cDatabase::szDBPASSWORD" ref="a4c65f9d9121f2fc4e60bc0eb0cd65493" args="[20]" -->
  110. static char&nbsp;</td><td class="memItemRight" valign="bottom"><b>szDBPASSWORD</b> [20]</td></tr>
  111. <tr><td class="memItemLeft" align="right" valign="top"><a class="anchor" id="a7e0e6601c87597a52b335e43dc963b4b"></a><!-- doxytag: member="cDatabase::intDBType" ref="a7e0e6601c87597a52b335e43dc963b4b" args="" -->
  112. static int&nbsp;</td><td class="memItemRight" valign="bottom"><b>intDBType</b></td></tr>
  113. </table>
  114. <hr/><h2>Member Function Documentation</h2>
  115. <a class="anchor" id="aad99ea2171588f78c51f97a148a2467e"></a><!-- doxytag: member="cDatabase::AddSpell" ref="aad99ea2171588f78c51f97a148a2467e" args="(DWORD dwAvatarGUID, int SpellCount, int SpellID)" -->
  116. <div class="memitem">
  117. <div class="memproto">
  118. <table class="memname">
  119. <tr>
  120. <td class="memname">void cDatabase::AddSpell </td>
  121. <td>(</td>
  122. <td class="paramtype">DWORD&nbsp;</td>
  123. <td class="paramname"> <em>dwAvatarGUID</em>, </td>
  124. </tr>
  125. <tr>
  126. <td class="paramkey"></td>
  127. <td></td>
  128. <td class="paramtype">int&nbsp;</td>
  129. <td class="paramname"> <em>SpellCount</em>, </td>
  130. </tr>
  131. <tr>
  132. <td class="paramkey"></td>
  133. <td></td>
  134. <td class="paramtype">int&nbsp;</td>
  135. <td class="paramname"> <em>SpellID</em></td><td>&nbsp;</td>
  136. </tr>
  137. <tr>
  138. <td></td>
  139. <td>)</td>
  140. <td></td><td></td><td><code> [static]</code></td>
  141. </tr>
  142. </table>
  143. </div>
  144. <div class="memdoc">
  145. <p>Adds spells to the avatars spell book.</p>
  146. <dl><dt><b>Parameters:</b></dt><dd>
  147. <table border="0" cellspacing="2" cellpadding="0">
  148. <tr><td valign="top"></td><td valign="top"><em>dwAvatarGUID</em>&nbsp;</td><td>= The Avatar GUID </td></tr>
  149. <tr><td valign="top"></td><td valign="top"><em>SpellCount</em>&nbsp;</td><td>= Total spell count for this Avatar </td></tr>
  150. <tr><td valign="top"></td><td valign="top"><em>SpellID</em>&nbsp;</td><td>= The ID of the spell to add</td></tr>
  151. </table>
  152. </dd>
  153. </dl>
  154. <p>Author: k109 </p>
  155. </div>
  156. </div>
  157. <a class="anchor" id="a5fd805d2028347fd2c289208c99b7fae"></a><!-- doxytag: member="cDatabase::AddSpellToTab" ref="a5fd805d2028347fd2c289208c99b7fae" args="(DWORD dwAvatarGUID, int SpellID, int SpellCount, int TabID)" -->
  158. <div class="memitem">
  159. <div class="memproto">
  160. <table class="memname">
  161. <tr>
  162. <td class="memname">void cDatabase::AddSpellToTab </td>
  163. <td>(</td>
  164. <td class="paramtype">DWORD&nbsp;</td>
  165. <td class="paramname"> <em>dwAvatarGUID</em>, </td>
  166. </tr>
  167. <tr>
  168. <td class="paramkey"></td>
  169. <td></td>
  170. <td class="paramtype">int&nbsp;</td>
  171. <td class="paramname"> <em>SpellID</em>, </td>
  172. </tr>
  173. <tr>
  174. <td class="paramkey"></td>
  175. <td></td>
  176. <td class="paramtype">int&nbsp;</td>
  177. <td class="paramname"> <em>SpellCount</em>, </td>
  178. </tr>
  179. <tr>
  180. <td class="paramkey"></td>
  181. <td></td>
  182. <td class="paramtype">int&nbsp;</td>
  183. <td class="paramname"> <em>TabID</em></td><td>&nbsp;</td>
  184. </tr>
  185. <tr>
  186. <td></td>
  187. <td>)</td>
  188. <td></td><td></td><td><code> [static]</code></td>
  189. </tr>
  190. </table>
  191. </div>
  192. <div class="memdoc">
  193. <p>Adds spells to the avatar's spell tab.</p>
  194. <p>dwAvatarGUID = The Avatar GUID SpellID = The ID of the spell to add SpellCount = Total spell count for this Avatar TabID = ID of the Spell Tab</p>
  195. <p>Author: k109 </p>
  196. </div>
  197. </div>
  198. <a class="anchor" id="a28e6f9bb76889a1b5a84acb8e9670cef"></a><!-- doxytag: member="cDatabase::AddToInventoryDB" ref="a28e6f9bb76889a1b5a84acb8e9670cef" args="(DWORD dwAvatarGUID, cObject *pcObj)" -->
  199. <div class="memitem">
  200. <div class="memproto">
  201. <table class="memname">
  202. <tr>
  203. <td class="memname">void cDatabase::AddToInventoryDB </td>
  204. <td>(</td>
  205. <td class="paramtype">DWORD&nbsp;</td>
  206. <td class="paramname"> <em>dwAvatarGUID</em>, </td>
  207. </tr>
  208. <tr>
  209. <td class="paramkey"></td>
  210. <td></td>
  211. <td class="paramtype"><a class="el" href="classc_object.html">cObject</a> *&nbsp;</td>
  212. <td class="paramname"> <em>pcObj</em></td><td>&nbsp;</td>
  213. </tr>
  214. <tr>
  215. <td></td>
  216. <td>)</td>
  217. <td></td><td></td><td><code> [static]</code></td>
  218. </tr>
  219. </table>
  220. </div>
  221. <div class="memdoc">
  222. <p>Adds items to the avatar's inventory table </p>
  223. </div>
  224. </div>
  225. <a class="anchor" id="a3bea15a901555ad5de25cedc8d14fe14"></a><!-- doxytag: member="cDatabase::CreateAccount" ref="a3bea15a901555ad5de25cedc8d14fe14" args="(char *szUserName, char *szPassword, DWORD &amp;dwAccountID)" -->
  226. <div class="memitem">
  227. <div class="memproto">
  228. <table class="memname">
  229. <tr>
  230. <td class="memname">BOOL cDatabase::CreateAccount </td>
  231. <td>(</td>
  232. <td class="paramtype">char *&nbsp;</td>
  233. <td class="paramname"> <em>szUserName</em>, </td>
  234. </tr>
  235. <tr>
  236. <td class="paramkey"></td>
  237. <td></td>
  238. <td class="paramtype">char *&nbsp;</td>
  239. <td class="paramname"> <em>szPassword</em>, </td>
  240. </tr>
  241. <tr>
  242. <td class="paramkey"></td>
  243. <td></td>
  244. <td class="paramtype">DWORD &amp;&nbsp;</td>
  245. <td class="paramname"> <em>dwAccountID</em></td><td>&nbsp;</td>
  246. </tr>
  247. <tr>
  248. <td></td>
  249. <td>)</td>
  250. <td></td><td></td><td><code> [static]</code></td>
  251. </tr>
  252. </table>
  253. </div>
  254. <div class="memdoc">
  255. <p>Creates a new account. A given account may create several characters on a given server. </p>
  256. </div>
  257. </div>
  258. <a class="anchor" id="afb7edb8a6435462956f24aa9135e71b1"></a><!-- doxytag: member="cDatabase::CreateAvatar" ref="afb7edb8a6435462956f24aa9135e71b1" args="(DWORD dwAccountID, CreateCharacterMessage &amp;ccm, DWORD &amp;dwNewAvatarGUID)" -->
  259. <div class="memitem">
  260. <div class="memproto">
  261. <table class="memname">
  262. <tr>
  263. <td class="memname">BOOL cDatabase::CreateAvatar </td>
  264. <td>(</td>
  265. <td class="paramtype">DWORD&nbsp;</td>
  266. <td class="paramname"> <em>dwAccountID</em>, </td>
  267. </tr>
  268. <tr>
  269. <td class="paramkey"></td>
  270. <td></td>
  271. <td class="paramtype"><a class="el" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;&nbsp;</td>
  272. <td class="paramname"> <em>ccm</em>, </td>
  273. </tr>
  274. <tr>
  275. <td class="paramkey"></td>
  276. <td></td>
  277. <td class="paramtype">DWORD &amp;&nbsp;</td>
  278. <td class="paramname"> <em>dwNewAvatarGUID</em></td><td>&nbsp;</td>
  279. </tr>
  280. <tr>
  281. <td></td>
  282. <td>)</td>
  283. <td></td><td></td><td><code> [static]</code></td>
  284. </tr>
  285. </table>
  286. </div>
  287. <div class="memdoc">
  288. <p>Creates the database information for a newly created avatar.</p>
  289. <p>The following tables are populated: avatar, avatar_skills, avatar_clothing_palettes, avatar_location, avatar_spells. </p>
  290. <p><p>Determine New Avatar Clothing </p>
  291. </p>
  292. </div>
  293. </div>
  294. <a class="anchor" id="a0c3c93587037123bf2765d91f133d5a5"></a><!-- doxytag: member="cDatabase::DeleteAvatar" ref="a0c3c93587037123bf2765d91f133d5a5" args="(DWORD dwAvatarGUID)" -->
  295. <div class="memitem">
  296. <div class="memproto">
  297. <table class="memname">
  298. <tr>
  299. <td class="memname">void cDatabase::DeleteAvatar </td>
  300. <td>(</td>
  301. <td class="paramtype">DWORD&nbsp;</td>
  302. <td class="paramname"> <em>dwAvatarGUID</em></td>
  303. <td>&nbsp;)&nbsp;</td>
  304. <td><code> [static]</code></td>
  305. </tr>
  306. </table>
  307. </div>
  308. <div class="memdoc">
  309. <p>Deletes the database information on a particular avatar.</p>
  310. <p>Entries are deleted from the following tables: avatar, avatar_skills, avatar_location, avatar_spells, avatar_vector_spellbook, avatar_vector_spelltabs, avatar_vector_equipped, avatar_clothing_palettes, items_instance_inventory, avatar_comp_quests. </p>
  311. </div>
  312. </div>
  313. <a class="anchor" id="a6eab03e92a2ff5f17fb78a7ef88c33f2"></a><!-- doxytag: member="cDatabase::Float2Hex" ref="a6eab03e92a2ff5f17fb78a7ef88c33f2" args="(float floatValue)" -->
  314. <div class="memitem">
  315. <div class="memproto">
  316. <table class="memname">
  317. <tr>
  318. <td class="memname">DWORD cDatabase::Float2Hex </td>
  319. <td>(</td>
  320. <td class="paramtype">float&nbsp;</td>
  321. <td class="paramname"> <em>floatValue</em></td>
  322. <td>&nbsp;)&nbsp;</td>
  323. <td><code> [static]</code></td>
  324. </tr>
  325. </table>
  326. </div>
  327. <div class="memdoc">
  328. <p>Converts floating point numbers to 32-bit hexadecimal values.</p>
  329. <p>Expects float input. Returns DWORD. </p>
  330. </div>
  331. </div>
  332. <a class="anchor" id="a76c81cecb4a67596e8a793f735d17cfc"></a><!-- doxytag: member="cDatabase::Hex2Float" ref="a76c81cecb4a67596e8a793f735d17cfc" args="(DWORD hexValue)" -->
  333. <div class="memitem">
  334. <div class="memproto">
  335. <table class="memname">
  336. <tr>
  337. <td class="memname">float cDatabase::Hex2Float </td>
  338. <td>(</td>
  339. <td class="paramtype">DWORD&nbsp;</td>
  340. <td class="paramname"> <em>hexValue</em></td>
  341. <td>&nbsp;)&nbsp;</td>
  342. <td><code> [static]</code></td>
  343. </tr>
  344. </table>
  345. </div>
  346. <div class="memdoc">
  347. <p>Converts 32-bit hexadecimal values to floating point numbers.</p>
  348. <p>Expects hexadecimal input. Returns a float value. </p>
  349. </div>
  350. </div>
  351. <a class="anchor" id="ad391744378d124de24494a89a83c23ea"></a><!-- doxytag: member="cDatabase::InitializeAllegIDs" ref="ad391744378d124de24494a89a83c23ea" args="(DWORD &amp;dwIDAllegiance)" -->
  352. <div class="memitem">
  353. <div class="memproto">
  354. <table class="memname">
  355. <tr>
  356. <td class="memname">void cDatabase::InitializeAllegIDs </td>
  357. <td>(</td>
  358. <td class="paramtype">DWORD &amp;&nbsp;</td>
  359. <td class="paramname"> <em>dwIDAllegiance</em></td>
  360. <td>&nbsp;)&nbsp;</td>
  361. <td><code> [static]</code></td>
  362. </tr>
  363. </table>
  364. </div>
  365. <div class="memdoc">
  366. <p>Initializes the starting allegiance ID value. </p>
  367. </div>
  368. </div>
  369. <a class="anchor" id="a971d5e17c7bf5072a01e36b4c34c7920"></a><!-- doxytag: member="cDatabase::InitializeAvatarGUIDs" ref="a971d5e17c7bf5072a01e36b4c34c7920" args="(DWORD &amp;dwGUIDCycle_Avatar)" -->
  370. <div class="memitem">
  371. <div class="memproto">
  372. <table class="memname">
  373. <tr>
  374. <td class="memname">void cDatabase::InitializeAvatarGUIDs </td>
  375. <td>(</td>
  376. <td class="paramtype">DWORD &amp;&nbsp;</td>
  377. <td class="paramname"> <em>dwGUIDCycle_Avatar</em></td>
  378. <td>&nbsp;)&nbsp;</td>
  379. <td><code> [static]</code></td>
  380. </tr>
  381. </table>
  382. </div>
  383. <div class="memdoc">
  384. <p>Initializes the starting avatar GUID value.</p>
  385. <p>As GUIDs must be unique and persistent, saved avatars are consulted for their GUID values. Database tables consulted: avatar. </p>
  386. </div>
  387. </div>
  388. <a class="anchor" id="a1ec143c8df2037255b516e90f949502f"></a><!-- doxytag: member="cDatabase::InitializeObjectGUIDs" ref="a1ec143c8df2037255b516e90f949502f" args="(DWORD &amp;dwGUIDCycle_Object)" -->
  389. <div class="memitem">
  390. <div class="memproto">
  391. <table class="memname">
  392. <tr>
  393. <td class="memname">void cDatabase::InitializeObjectGUIDs </td>
  394. <td>(</td>
  395. <td class="paramtype">DWORD &amp;&nbsp;</td>
  396. <td class="paramname"> <em>dwGUIDCycle_Object</em></td>
  397. <td>&nbsp;)&nbsp;</td>
  398. <td><code> [static]</code></td>
  399. </tr>
  400. </table>
  401. </div>
  402. <div class="memdoc">
  403. <p>Initializes the starting item GUID value.</p>
  404. <p>As GUIDs must be unique and persistent, saved items are consulted for their GUID values. Database tables consulted: items_instance_inventory and items_instance_ground. </p>
  405. </div>
  406. </div>
  407. <a class="anchor" id="a86d984a2a06e50372e31deb4a719d39c"></a><!-- doxytag: member="cDatabase::Load" ref="a86d984a2a06e50372e31deb4a719d39c" args="()" -->
  408. <div class="memitem">
  409. <div class="memproto">
  410. <table class="memname">
  411. <tr>
  412. <td class="memname">void cDatabase::Load </td>
  413. <td>(</td>
  414. <td class="paramname"></td>
  415. <td>&nbsp;)&nbsp;</td>
  416. <td><code> [static]</code></td>
  417. </tr>
  418. </table>
  419. </div>
  420. <div class="memdoc">
  421. <p>Loads the proper database driver based upon the selected database type. </p>
  422. </div>
  423. </div>
  424. <a class="anchor" id="a7fdc554648e537f5e35bdbaa4175f1b0"></a><!-- doxytag: member="cDatabase::LoadAvatar" ref="a7fdc554648e537f5e35bdbaa4175f1b0" args="(cAvatar *pcAvatar)" -->
  425. <div class="memitem">
  426. <div class="memproto">
  427. <table class="memname">
  428. <tr>
  429. <td class="memname">void cDatabase::LoadAvatar </td>
  430. <td>(</td>
  431. <td class="paramtype"><a class="el" href="classc_avatar.html">cAvatar</a> *&nbsp;</td>
  432. <td class="paramname"> <em>pcAvatar</em></td>
  433. <td>&nbsp;)&nbsp;</td>
  434. <td><code> [static]</code></td>
  435. </tr>
  436. </table>
  437. </div>
  438. <div class="memdoc">
  439. <p>Loads the database information on a particular avatar during login.</p>
  440. <p>Database tables consulted: avatar, avatar_skills, avatar_location, houses_covenants, avatar_vector_spellbook, avatar_vector_spelltab, items_instance_inventory. </p>
  441. </div>
  442. </div>
  443. <a class="anchor" id="ab084360e7e8ef9151f637c71d7adeff2"></a><!-- doxytag: member="cDatabase::LoadAvatarList" ref="ab084360e7e8ef9151f637c71d7adeff2" args="(DWORD dwAccountID, std::vector&lt; cAvatarList &gt; &amp;AvatarList)" -->
  444. <div class="memitem">
  445. <div class="memproto">
  446. <table class="memname">
  447. <tr>
  448. <td class="memname">void cDatabase::LoadAvatarList </td>
  449. <td>(</td>
  450. <td class="paramtype">DWORD&nbsp;</td>
  451. <td class="paramname"> <em>dwAccountID</em>, </td>
  452. </tr>
  453. <tr>
  454. <td class="paramkey"></td>
  455. <td></td>
  456. <td class="paramtype">std::vector&lt; <a class="el" href="structc_avatar_list.html">cAvatarList</a> &gt; &amp;&nbsp;</td>
  457. <td class="paramname"> <em>AvatarList</em></td><td>&nbsp;</td>
  458. </tr>
  459. <tr>
  460. <td></td>
  461. <td>)</td>
  462. <td></td><td></td><td><code> [static]</code></td>
  463. </tr>
  464. </table>
  465. </div>
  466. <div class="memdoc">
  467. <p>Loads the list of avatars for a given account. Used to send the client a list of its current characters. </p>
  468. </div>
  469. </div>
  470. <a class="anchor" id="a34968d28bf83bf9e65187458a5e3f8a2"></a><!-- doxytag: member="cDatabase::LoadDungeonList" ref="a34968d28bf83bf9e65187458a5e3f8a2" args="(char strName, std::vector&lt; cDungeonList &gt; &amp;DungeonList)" -->
  471. <div class="memitem">
  472. <div class="memproto">
  473. <table class="memname">
  474. <tr>
  475. <td class="memname">BOOL cDatabase::LoadDungeonList </td>
  476. <td>(</td>
  477. <td class="paramtype">char&nbsp;</td>
  478. <td class="paramname"> <em>strName</em>, </td>
  479. </tr>
  480. <tr>
  481. <td class="paramkey"></td>
  482. <td></td>
  483. <td class="paramtype">std::vector&lt; <a class="el" href="structc_dungeon_list.html">cDungeonList</a> &gt; &amp;&nbsp;</td>
  484. <td class="paramname"> <em>DungeonList</em></td><td>&nbsp;</td>
  485. </tr>
  486. <tr>
  487. <td></td>
  488. <td>)</td>
  489. <td></td><td></td><td><code> [static]</code></td>
  490. </tr>
  491. </table>
  492. </div>
  493. <div class="memdoc">
  494. <p>Populates a list with the information on the name and location of dungeons. </p>
  495. </div>
  496. </div>
  497. <a class="anchor" id="aaebd59281d93e6ad63014bd1c2653121"></a><!-- doxytag: member="cDatabase::RemoveFromInventoryDB" ref="aaebd59281d93e6ad63014bd1c2653121" args="(DWORD dwAvatarGUID, DWORD dwObjectGUID)" -->
  498. <div class="memitem">
  499. <div class="memproto">
  500. <table class="memname">
  501. <tr>
  502. <td class="memname">void cDatabase::RemoveFromInventoryDB </td>
  503. <td>(</td>
  504. <td class="paramtype">DWORD&nbsp;</td>
  505. <td class="paramname"> <em>dwAvatarGUID</em>, </td>
  506. </tr>
  507. <tr>
  508. <td class="paramkey"></td>
  509. <td></td>
  510. <td class="paramtype">DWORD&nbsp;</td>
  511. <td class="paramname"> <em>dwObjectGUID</em></td><td>&nbsp;</td>
  512. </tr>
  513. <tr>
  514. <td></td>
  515. <td>)</td>
  516. <td></td><td></td><td><code> [static]</code></td>
  517. </tr>
  518. </table>
  519. </div>
  520. <div class="memdoc">
  521. <p>Removes items from the avatar's inventory table </p>
  522. </div>
  523. </div>
  524. <a class="anchor" id="ab793d77fb6edfb2842182e89606104e0"></a><!-- doxytag: member="cDatabase::VerifyAccount" ref="ab793d77fb6edfb2842182e89606104e0" args="(char *szUserName, char *szPassword, DWORD &amp;dwAccountID, BOOL fCreate)" -->
  525. <div class="memitem">
  526. <div class="memproto">
  527. <table class="memname">
  528. <tr>
  529. <td class="memname">BOOL cDatabase::VerifyAccount </td>
  530. <td>(</td>
  531. <td class="paramtype">char *&nbsp;</td>
  532. <td class="paramname"> <em>szUserName</em>, </td>
  533. </tr>
  534. <tr>
  535. <td class="paramkey"></td>
  536. <td></td>
  537. <td class="paramtype">char *&nbsp;</td>
  538. <td class="paramname"> <em>szPassword</em>, </td>
  539. </tr>
  540. <tr>
  541. <td class="paramkey"></td>
  542. <td></td>
  543. <td class="paramtype">DWORD &amp;&nbsp;</td>
  544. <td class="paramname"> <em>dwAccountID</em>, </td>
  545. </tr>
  546. <tr>
  547. <td class="paramkey"></td>
  548. <td></td>
  549. <td class="paramtype">BOOL&nbsp;</td>
  550. <td class="paramname"> <em>fCreate</em></td><td>&nbsp;</td>
  551. </tr>
  552. <tr>
  553. <td></td>
  554. <td>)</td>
  555. <td></td><td></td><td><code> [static]</code></td>
  556. </tr>
  557. </table>
  558. </div>
  559. <div class="memdoc">
  560. <p>Verifies the acount login information. </p>
  561. </div>
  562. </div>
  563. <hr/>The documentation for this class was generated from the following files:<ul>
  564. <li>E:/uas2/Server/<a class="el" href="_data_base_8h_source.html">DataBase.h</a></li>
  565. <li>E:/uas2/Server/<a class="el" href="_database_8cpp.html">Database.cpp</a></li>
  566. </ul>
  567. </div>
  568. <hr size="1"/><address style="text-align: right;"><small>Generated by&nbsp;
  569. <a href="http://www.doxygen.org/index.html">
  570. <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2 </small></address>
  571. </body>
  572. </html>