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

_data_base_8h_source.html 21KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178
  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: E:/uas2/Server/DataBase.h Source File</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><a href="annotated.html"><span>Classes</span></a></li>
  16. <li class="current"><a href="files.html"><span>Files</span></a></li>
  17. </ul>
  18. </div>
  19. <div class="tabs">
  20. <ul>
  21. <li><a href="files.html"><span>File&nbsp;List</span></a></li>
  22. <li><a href="globals.html"><span>File&nbsp;Members</span></a></li>
  23. </ul>
  24. </div>
  25. <h1>E:/uas2/Server/DataBase.h</h1><a href="_data_base_8h.html">Go to the documentation of this file.</a><div class="fragment"><pre class="fragment"><a name="l00001"></a>00001 <span class="comment">/*</span>
  26. <a name="l00002"></a>00002 <span class="comment">* This file is part of UAS2.</span>
  27. <a name="l00003"></a>00003 <span class="comment">*</span>
  28. <a name="l00004"></a>00004 <span class="comment">* UAS2 is free software; you can redistribute it and/or modify</span>
  29. <a name="l00005"></a>00005 <span class="comment">* it under the terms of the GNU General Public License as published by</span>
  30. <a name="l00006"></a>00006 <span class="comment">* the Free Software Foundation; either version 2 of the License, or</span>
  31. <a name="l00007"></a>00007 <span class="comment">* (at your option) any later version.</span>
  32. <a name="l00008"></a>00008 <span class="comment">*</span>
  33. <a name="l00009"></a>00009 <span class="comment">* UAS2 is distributed in the hope that it will be useful,</span>
  34. <a name="l00010"></a>00010 <span class="comment">* but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
  35. <a name="l00011"></a>00011 <span class="comment">* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</span>
  36. <a name="l00012"></a>00012 <span class="comment">* GNU General Public License for more details.</span>
  37. <a name="l00013"></a>00013 <span class="comment"></span>
  38. <a name="l00014"></a>00014 <span class="comment">* You should have received a copy of the GNU General Public License</span>
  39. <a name="l00015"></a>00015 <span class="comment">* along with UASv1; if not, write to the Free Software</span>
  40. <a name="l00016"></a>00016 <span class="comment">* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA</span>
  41. <a name="l00017"></a>00017 <span class="comment">*/</span>
  42. <a name="l00018"></a>00018
  43. <a name="l00024"></a>00024 <span class="preprocessor">#ifndef __DATABASE_H</span>
  44. <a name="l00025"></a>00025 <span class="preprocessor"></span><span class="preprocessor">#define __DATABASE_H</span>
  45. <a name="l00026"></a>00026 <span class="preprocessor"></span>
  46. <a name="l00027"></a>00027 <span class="preprocessor">#include &lt;sql.h&gt;</span>
  47. <a name="l00028"></a>00028 <span class="preprocessor">#include &lt;sqlext.h&gt;</span>
  48. <a name="l00029"></a>00029 <span class="preprocessor">#include &lt;sstream&gt;</span>
  49. <a name="l00030"></a>00030 <span class="preprocessor">#include &lt;vector&gt;</span>
  50. <a name="l00031"></a>00031
  51. <a name="l00032"></a>00032 <span class="preprocessor">#include &quot;<a class="code" href="_account_8h.html">Account.h</a>&quot;</span>
  52. <a name="l00033"></a>00033 <span class="preprocessor">#include &quot;<a class="code" href="_shared_8h.html">Shared.h</a>&quot;</span>
  53. <a name="l00034"></a>00034
  54. <a name="l00035"></a>00035 <span class="keyword">class </span><a class="code" href="classc_avatar.html">cAvatar</a>;
  55. <a name="l00036"></a>00036
  56. <a name="l00037"></a><a class="code" href="classc_database.html">00037</a> <span class="keyword">class </span><a class="code" href="classc_database.html">cDatabase</a>
  57. <a name="l00038"></a>00038 {
  58. <a name="l00039"></a>00039
  59. <a name="l00040"></a>00040 <span class="keyword">public</span>:
  60. <a name="l00041"></a>00041
  61. <a name="l00042"></a>00042 <span class="keyword">static</span> HENV m_hEnv;
  62. <a name="l00043"></a>00043 <span class="keyword">static</span> HDBC m_hDBC;
  63. <a name="l00044"></a>00044 <span class="keyword">static</span> HSTMT m_hStmt;
  64. <a name="l00045"></a>00045 <span class="keyword">static</span> <span class="keywordtype">int</span> wMaxModel;
  65. <a name="l00046"></a>00046 <span class="keyword">static</span> <span class="keywordtype">char</span> szModelName[1000][5];
  66. <a name="l00047"></a>00047 <span class="keyword">static</span> <span class="keywordtype">char</span> szModelNumber[1000][3];
  67. <a name="l00048"></a>00048 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBIP[16];
  68. <a name="l00049"></a>00049 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBNAME[20];
  69. <a name="l00050"></a>00050 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBUSER[20];
  70. <a name="l00051"></a>00051 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBPASSWORD[20];
  71. <a name="l00052"></a>00052 <span class="keyword">static</span> <span class="keywordtype">int</span> intDBType;
  72. <a name="l00053"></a>00053
  73. <a name="l00058"></a>00058 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a86d984a2a06e50372e31deb4a719d39c">Load</a> ( );
  74. <a name="l00059"></a>00059 <span class="keyword">static</span> <span class="keywordtype">void</span> Unload ( );
  75. <a name="l00060"></a>00060 <span class="keyword">static</span> <span class="keywordtype">void</span> GetError ( SQLSMALLINT type, SQLHANDLE *hptr );
  76. <a name="l00061"></a>00061 <span class="keyword">static</span> <span class="keywordtype">int</span> InitializeSQLEnvironment( );
  77. <a name="l00062"></a>00062 <span class="keyword">static</span> <span class="keywordtype">int</span> FreeSQLEnvironment ( );
  78. <a name="l00063"></a>00063 <span class="keyword">static</span> <span class="keywordtype">void</span> cDatabase::InitializeMaxModel( );
  79. <a name="l00064"></a>00064 <span class="keyword">static</span> <span class="keywordtype">void</span> cDatabase::LoadModelList( );
  80. <a name="l00065"></a>00065 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a971d5e17c7bf5072a01e36b4c34c7920">InitializeAvatarGUIDs</a> ( DWORD &amp;dwGUIDCycle_Avatar );
  81. <a name="l00066"></a>00066 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a1ec143c8df2037255b516e90f949502f">InitializeObjectGUIDs</a> ( DWORD &amp;dwGUIDCycle_Object );
  82. <a name="l00067"></a>00067 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#ad391744378d124de24494a89a83c23ea">InitializeAllegIDs</a> ( DWORD &amp;dwIDAllegiance );
  83. <a name="l00068"></a>00068 <span class="keyword">static</span> BOOL <a class="code" href="classc_database.html#ab793d77fb6edfb2842182e89606104e0">VerifyAccount</a> ( <span class="keywordtype">char</span>* szUserName, <span class="keywordtype">char</span>* szPassword, DWORD &amp;dwAccountID, BOOL fCreate );
  84. <a name="l00069"></a>00069 <span class="keyword">static</span> BOOL <a class="code" href="classc_database.html#a3bea15a901555ad5de25cedc8d14fe14">CreateAccount</a> ( <span class="keywordtype">char</span>* szUserName, <span class="keywordtype">char</span>* szPassword, DWORD &amp;dwAccountID );
  85. <a name="l00070"></a>00070 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#ab084360e7e8ef9151f637c71d7adeff2">LoadAvatarList</a> ( DWORD dwAccountID, std::vector&lt; cAvatarList &gt; &amp;AvatarList );
  86. <a name="l00071"></a>00071 <span class="keyword">static</span> BOOL <a class="code" href="classc_database.html#afb7edb8a6435462956f24aa9135e71b1">CreateAvatar</a> ( DWORD dwAccountID, <a class="code" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;ccm, DWORD &amp;dwNewAvatarGUID );
  87. <a name="l00072"></a>00072 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a0c3c93587037123bf2765d91f133d5a5">DeleteAvatar</a> ( DWORD dwAvatarGUID );
  88. <a name="l00073"></a>00073 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a7fdc554648e537f5e35bdbaa4175f1b0">LoadAvatar</a> ( <a class="code" href="classc_avatar.html">cAvatar</a>* pcAvatar );
  89. <a name="l00074"></a>00074 <span class="keyword">static</span> BOOL <a class="code" href="classc_database.html#a34968d28bf83bf9e65187458a5e3f8a2">LoadDungeonList</a> ( <span class="keywordtype">char</span> strName, std::vector&lt; cDungeonList &gt; &amp;DungeonList );
  90. <a name="l00075"></a>00075 <span class="keyword">static</span> <span class="keywordtype">void</span> SetupDB ( <span class="keywordtype">int</span> DBType, <span class="keywordtype">char</span>* szDBIP, <span class="keywordtype">char</span>* szDBNAME, <span class="keywordtype">char</span>* szDBUSER, <span class="keywordtype">char</span>* szDBPASSWORD );
  91. <a name="l00077"></a>00077
  92. <a name="l00078"></a>00078 <span class="comment">//eLeM: Functions to update avatar inventory in the database</span>
  93. <a name="l00079"></a>00079 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a28e6f9bb76889a1b5a84acb8e9670cef">AddToInventoryDB</a> ( DWORD dwAvatarGUID, <a class="code" href="classc_object.html">cObject</a>* pcObj );
  94. <a name="l00080"></a>00080 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#aaebd59281d93e6ad63014bd1c2653121">RemoveFromInventoryDB</a> ( DWORD dwAvatarGUID, DWORD dwObjectGUID );
  95. <a name="l00081"></a>00081
  96. <a name="l00082"></a>00082 <span class="comment">//k109: Adding functions to ease adding spells to Avatar</span>
  97. <a name="l00083"></a>00083 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#aad99ea2171588f78c51f97a148a2467e">AddSpell</a> ( DWORD dwAvatarGUID, <span class="keywordtype">int</span> SpellCount, <span class="keywordtype">int</span> SpellID );
  98. <a name="l00084"></a>00084 <span class="keyword">static</span> <span class="keywordtype">void</span> <a class="code" href="classc_database.html#a5fd805d2028347fd2c289208c99b7fae">AddSpellToTab</a> (DWORD dwAvatarGUID, <span class="keywordtype">int</span> SpellID, <span class="keywordtype">int</span> SpellCount, <span class="keywordtype">int</span> TabID);
  99. <a name="l00085"></a>00085
  100. <a name="l00086"></a>00086 <span class="comment">//k109: Functions to add starting items</span>
  101. <a name="l00087"></a>00087 <span class="keyword">static</span> <span class="keywordtype">void</span> AddGeneralItems (DWORD dwAvatarGUID);
  102. <a name="l00088"></a>00088 <span class="keyword">static</span> <span class="keywordtype">void</span> AddRaceItemsAluvian (DWORD dwAvatarGUID);
  103. <a name="l00089"></a>00089 <span class="keyword">static</span> <span class="keywordtype">void</span> AddRaceItemsGharundim (DWORD dwAvatarGUID);
  104. <a name="l00090"></a>00090 <span class="keyword">static</span> <span class="keywordtype">void</span> AddRaceItemsSho (DWORD dwAvatarGUID);
  105. <a name="l00091"></a>00091
  106. <a name="l00092"></a>00092 <span class="keyword">static</span> <span class="keywordtype">void</span> AddCasterItems (DWORD dwAvatarGUID);
  107. <a name="l00093"></a>00093 <span class="keyword">static</span> <span class="keywordtype">void</span> AddFoci (DWORD dwAvatarGUID, <a class="code" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;ccm);
  108. <a name="l00094"></a>00094 <span class="keyword">static</span> <span class="keywordtype">void</span> AddProfessionItems (DWORD dwAvatarGUID, <a class="code" href="struct_create_character_message.html">CreateCharacterMessage</a> &amp;ccm);
  109. <a name="l00095"></a>00095
  110. <a name="l00096"></a>00096 <span class="keyword">static</span> <span class="keywordtype">void</span> SaveCharacterFlags (DWORD dwAvatarGUID, DWORD Flags);
  111. <a name="l00097"></a>00097
  112. <a name="l00098"></a>00098 <span class="comment">//eLeM: Functions to convert between numerical types</span>
  113. <a name="l00099"></a>00099 <span class="keyword">static</span> <span class="keywordtype">float</span> <a class="code" href="classc_database.html#a76c81cecb4a67596e8a793f735d17cfc">Hex2Float</a> (DWORD hexValue);
  114. <a name="l00100"></a>00100 <span class="keyword">static</span> DWORD <a class="code" href="classc_database.html#a6eab03e92a2ff5f17fb78a7ef88c33f2">Float2Hex</a> (<span class="keywordtype">float</span> floatValue);
  115. <a name="l00101"></a>00101
  116. <a name="l00102"></a>00102 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnClass( DWORD dwClass )
  117. <a name="l00103"></a>00103 {
  118. <a name="l00104"></a>00104 <span class="keywordflow">switch</span> ( dwClass )
  119. <a name="l00105"></a>00105 {
  120. <a name="l00106"></a>00106 <span class="keywordflow">case</span> CHARDATA_CLASS_CUSTOM: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Custom&quot;</span>;
  121. <a name="l00107"></a>00107 <span class="keywordflow">case</span> CHARDATA_CLASS_BOW_HUNTER: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Bow Hunter&quot;</span>;
  122. <a name="l00108"></a>00108 <span class="keywordflow">case</span> CHARDATA_CLASS_SWASHBUCKLER: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Swashbuckler&quot;</span>;
  123. <a name="l00109"></a>00109 <span class="keywordflow">case</span> CHARDATA_CLASS_LIFE_CASTER: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Life Caster&quot;</span>;
  124. <a name="l00110"></a>00110 <span class="keywordflow">case</span> CHARDATA_CLASS_WAR_MAGE: <span class="keywordflow">return</span> <span class="stringliteral">&quot;War Mage&quot;</span>;
  125. <a name="l00111"></a>00111 <span class="keywordflow">case</span> CHARDATA_CLASS_WAYFARER: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Wayfarer&quot;</span>;
  126. <a name="l00112"></a>00112 <span class="keywordflow">case</span> CHARDATA_CLASS_SOLDIER: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Soldier&quot;</span>;
  127. <a name="l00113"></a>00113 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
  128. <a name="l00114"></a>00114 }
  129. <a name="l00115"></a>00115 }
  130. <a name="l00116"></a>00116
  131. <a name="l00117"></a>00117 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnGender( DWORD dwGender )
  132. <a name="l00118"></a>00118 {
  133. <a name="l00119"></a>00119 <span class="keywordflow">switch</span> ( dwGender )
  134. <a name="l00120"></a>00120 {
  135. <a name="l00121"></a>00121 <span class="keywordflow">case</span> CHARDATA_SEX_FEMALE: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Female&quot;</span>;
  136. <a name="l00122"></a>00122 <span class="keywordflow">case</span> CHARDATA_SEX_MALE: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Male&quot;</span>;
  137. <a name="l00123"></a>00123 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
  138. <a name="l00124"></a>00124 }
  139. <a name="l00125"></a>00125 }
  140. <a name="l00126"></a>00126
  141. <a name="l00127"></a>00127 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnRace( DWORD dwRace )
  142. <a name="l00128"></a>00128 {
  143. <a name="l00129"></a>00129 <span class="keywordflow">switch</span> ( dwRace )
  144. <a name="l00130"></a>00130 {
  145. <a name="l00131"></a>00131 <span class="keywordflow">case</span> CHARDATA_RACE_ALUVIAN: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Aluvian&quot;</span>;
  146. <a name="l00132"></a>00132 <span class="keywordflow">case</span> CHARDATA_RACE_GHARU: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Gharu&#39;ndim&quot;</span>;
  147. <a name="l00133"></a>00133 <span class="keywordflow">case</span> CHARDATA_RACE_SHO: <span class="keywordflow">return</span> <span class="stringliteral">&quot;Sho&quot;</span>;
  148. <a name="l00134"></a>00134 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
  149. <a name="l00135"></a>00135 }
  150. <a name="l00136"></a>00136 }
  151. <a name="l00137"></a>00137
  152. <a name="l00138"></a>00138 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnNamePrefix( BYTE bLevel )
  153. <a name="l00139"></a>00139 {
  154. <a name="l00140"></a>00140 <span class="keywordflow">switch</span> ( bLevel )
  155. <a name="l00141"></a>00141 {
  156. <a name="l00142"></a>00142 <span class="keywordflow">case</span> eDeveloper: <span class="keywordflow">return</span> <span class="stringliteral">&quot;+Developer &quot;</span>;
  157. <a name="l00143"></a>00143 <span class="keywordflow">case</span> eAdmin: <span class="keywordflow">return</span> <span class="stringliteral">&quot;+Envoy &quot;</span>;
  158. <a name="l00144"></a>00144 <span class="keywordflow">case</span> eUeber: <span class="keywordflow">return</span> <span class="stringliteral">&quot;+Uber &quot;</span>;
  159. <a name="l00145"></a>00145 <span class="keywordflow">case</span> eSentinel: <span class="keywordflow">return</span> <span class="stringliteral">&quot;+Sentinel &quot;</span>;
  160. <a name="l00146"></a>00146 <span class="keywordflow">case</span> eAdvocate: <span class="keywordflow">return</span> <span class="stringliteral">&quot;+Advocate &quot;</span>;
  161. <a name="l00147"></a>00147 <span class="keywordflow">case</span> eStaff: <span class="keywordflow">return</span> <span class="stringliteral">&quot;+&quot;</span>;
  162. <a name="l00148"></a>00148 <span class="keywordflow">case</span> eVIP: <span class="keywordflow">return</span> <span class="stringliteral">&quot;*&quot;</span>;
  163. <a name="l00149"></a>00149 <span class="keywordflow">case</span> eNormal: <span class="keywordflow">return</span> <span class="stringliteral">&quot;&quot;</span>;
  164. <a name="l00150"></a>00150 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
  165. <a name="l00151"></a>00151 }
  166. <a name="l00152"></a>00152 }
  167. <a name="l00153"></a>00153 <span class="keyword">private</span>:
  168. <a name="l00154"></a>00154
  169. <a name="l00155"></a>00155 };
  170. <a name="l00156"></a>00156
  171. <a name="l00157"></a>00157 <span class="preprocessor">#endif // #ifndef __DATABSE_H</span>
  172. </pre></div></div>
  173. <hr size="1"/><address style="text-align: right;"><small>Generated by&nbsp;
  174. <a href="http://www.doxygen.org/index.html">
  175. <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2 </small></address>
  176. </body>
  177. </html>