123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178 |
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml">
- <head>
- <meta http-equiv="Content-Type" content="text/xhtml;charset=UTF-8"/>
- <title>UAS2: E:/uas2/Server/DataBase.h Source File</title>
- <link href="tabs.css" rel="stylesheet" type="text/css"/>
- <link href="doxygen.css" rel="stylesheet" type="text/css"/>
- </head>
- <body>
- <!-- Generated by Doxygen 1.6.2 -->
- <div class="navigation" id="top">
- <div class="tabs">
- <ul>
- <li><a href="main.html"><span>Main Page</span></a></li>
- <li><a href="annotated.html"><span>Classes</span></a></li>
- <li class="current"><a href="files.html"><span>Files</span></a></li>
- </ul>
- </div>
- <div class="tabs">
- <ul>
- <li><a href="files.html"><span>File List</span></a></li>
- <li><a href="globals.html"><span>File Members</span></a></li>
- </ul>
- </div>
- <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>
- <a name="l00002"></a>00002 <span class="comment">* This file is part of UAS2.</span>
- <a name="l00003"></a>00003 <span class="comment">*</span>
- <a name="l00004"></a>00004 <span class="comment">* UAS2 is free software; you can redistribute it and/or modify</span>
- <a name="l00005"></a>00005 <span class="comment">* it under the terms of the GNU General Public License as published by</span>
- <a name="l00006"></a>00006 <span class="comment">* the Free Software Foundation; either version 2 of the License, or</span>
- <a name="l00007"></a>00007 <span class="comment">* (at your option) any later version.</span>
- <a name="l00008"></a>00008 <span class="comment">*</span>
- <a name="l00009"></a>00009 <span class="comment">* UAS2 is distributed in the hope that it will be useful,</span>
- <a name="l00010"></a>00010 <span class="comment">* but WITHOUT ANY WARRANTY; without even the implied warranty of</span>
- <a name="l00011"></a>00011 <span class="comment">* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the</span>
- <a name="l00012"></a>00012 <span class="comment">* GNU General Public License for more details.</span>
- <a name="l00013"></a>00013 <span class="comment"></span>
- <a name="l00014"></a>00014 <span class="comment">* You should have received a copy of the GNU General Public License</span>
- <a name="l00015"></a>00015 <span class="comment">* along with UASv1; if not, write to the Free Software</span>
- <a name="l00016"></a>00016 <span class="comment">* Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA</span>
- <a name="l00017"></a>00017 <span class="comment">*/</span>
- <a name="l00018"></a>00018
- <a name="l00024"></a>00024 <span class="preprocessor">#ifndef __DATABASE_H</span>
- <a name="l00025"></a>00025 <span class="preprocessor"></span><span class="preprocessor">#define __DATABASE_H</span>
- <a name="l00026"></a>00026 <span class="preprocessor"></span>
- <a name="l00027"></a>00027 <span class="preprocessor">#include <sql.h></span>
- <a name="l00028"></a>00028 <span class="preprocessor">#include <sqlext.h></span>
- <a name="l00029"></a>00029 <span class="preprocessor">#include <sstream></span>
- <a name="l00030"></a>00030 <span class="preprocessor">#include <vector></span>
- <a name="l00031"></a>00031
- <a name="l00032"></a>00032 <span class="preprocessor">#include "<a class="code" href="_account_8h.html">Account.h</a>"</span>
- <a name="l00033"></a>00033 <span class="preprocessor">#include "<a class="code" href="_shared_8h.html">Shared.h</a>"</span>
- <a name="l00034"></a>00034
- <a name="l00035"></a>00035 <span class="keyword">class </span><a class="code" href="classc_avatar.html">cAvatar</a>;
- <a name="l00036"></a>00036
- <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>
- <a name="l00038"></a>00038 {
- <a name="l00039"></a>00039
- <a name="l00040"></a>00040 <span class="keyword">public</span>:
- <a name="l00041"></a>00041
- <a name="l00042"></a>00042 <span class="keyword">static</span> HENV m_hEnv;
- <a name="l00043"></a>00043 <span class="keyword">static</span> HDBC m_hDBC;
- <a name="l00044"></a>00044 <span class="keyword">static</span> HSTMT m_hStmt;
- <a name="l00045"></a>00045 <span class="keyword">static</span> <span class="keywordtype">int</span> wMaxModel;
- <a name="l00046"></a>00046 <span class="keyword">static</span> <span class="keywordtype">char</span> szModelName[1000][5];
- <a name="l00047"></a>00047 <span class="keyword">static</span> <span class="keywordtype">char</span> szModelNumber[1000][3];
- <a name="l00048"></a>00048 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBIP[16];
- <a name="l00049"></a>00049 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBNAME[20];
- <a name="l00050"></a>00050 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBUSER[20];
- <a name="l00051"></a>00051 <span class="keyword">static</span> <span class="keywordtype">char</span> szDBPASSWORD[20];
- <a name="l00052"></a>00052 <span class="keyword">static</span> <span class="keywordtype">int</span> intDBType;
- <a name="l00053"></a>00053
- <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> ( );
- <a name="l00059"></a>00059 <span class="keyword">static</span> <span class="keywordtype">void</span> Unload ( );
- <a name="l00060"></a>00060 <span class="keyword">static</span> <span class="keywordtype">void</span> GetError ( SQLSMALLINT type, SQLHANDLE *hptr );
- <a name="l00061"></a>00061 <span class="keyword">static</span> <span class="keywordtype">int</span> InitializeSQLEnvironment( );
- <a name="l00062"></a>00062 <span class="keyword">static</span> <span class="keywordtype">int</span> FreeSQLEnvironment ( );
- <a name="l00063"></a>00063 <span class="keyword">static</span> <span class="keywordtype">void</span> cDatabase::InitializeMaxModel( );
- <a name="l00064"></a>00064 <span class="keyword">static</span> <span class="keywordtype">void</span> cDatabase::LoadModelList( );
- <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 &dwGUIDCycle_Avatar );
- <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 &dwGUIDCycle_Object );
- <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 &dwIDAllegiance );
- <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 &dwAccountID, BOOL fCreate );
- <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 &dwAccountID );
- <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< cAvatarList > &AvatarList );
- <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> &ccm, DWORD &dwNewAvatarGUID );
- <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 );
- <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 );
- <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< cDungeonList > &DungeonList );
- <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 );
- <a name="l00077"></a>00077
- <a name="l00078"></a>00078 <span class="comment">//eLeM: Functions to update avatar inventory in the database</span>
- <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 );
- <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 );
- <a name="l00081"></a>00081
- <a name="l00082"></a>00082 <span class="comment">//k109: Adding functions to ease adding spells to Avatar</span>
- <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 );
- <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);
- <a name="l00085"></a>00085
- <a name="l00086"></a>00086 <span class="comment">//k109: Functions to add starting items</span>
- <a name="l00087"></a>00087 <span class="keyword">static</span> <span class="keywordtype">void</span> AddGeneralItems (DWORD dwAvatarGUID);
- <a name="l00088"></a>00088 <span class="keyword">static</span> <span class="keywordtype">void</span> AddRaceItemsAluvian (DWORD dwAvatarGUID);
- <a name="l00089"></a>00089 <span class="keyword">static</span> <span class="keywordtype">void</span> AddRaceItemsGharundim (DWORD dwAvatarGUID);
- <a name="l00090"></a>00090 <span class="keyword">static</span> <span class="keywordtype">void</span> AddRaceItemsSho (DWORD dwAvatarGUID);
- <a name="l00091"></a>00091
- <a name="l00092"></a>00092 <span class="keyword">static</span> <span class="keywordtype">void</span> AddCasterItems (DWORD dwAvatarGUID);
- <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> &ccm);
- <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> &ccm);
- <a name="l00095"></a>00095
- <a name="l00096"></a>00096 <span class="keyword">static</span> <span class="keywordtype">void</span> SaveCharacterFlags (DWORD dwAvatarGUID, DWORD Flags);
- <a name="l00097"></a>00097
- <a name="l00098"></a>00098 <span class="comment">//eLeM: Functions to convert between numerical types</span>
- <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);
- <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);
- <a name="l00101"></a>00101
- <a name="l00102"></a>00102 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnClass( DWORD dwClass )
- <a name="l00103"></a>00103 {
- <a name="l00104"></a>00104 <span class="keywordflow">switch</span> ( dwClass )
- <a name="l00105"></a>00105 {
- <a name="l00106"></a>00106 <span class="keywordflow">case</span> CHARDATA_CLASS_CUSTOM: <span class="keywordflow">return</span> <span class="stringliteral">"Custom"</span>;
- <a name="l00107"></a>00107 <span class="keywordflow">case</span> CHARDATA_CLASS_BOW_HUNTER: <span class="keywordflow">return</span> <span class="stringliteral">"Bow Hunter"</span>;
- <a name="l00108"></a>00108 <span class="keywordflow">case</span> CHARDATA_CLASS_SWASHBUCKLER: <span class="keywordflow">return</span> <span class="stringliteral">"Swashbuckler"</span>;
- <a name="l00109"></a>00109 <span class="keywordflow">case</span> CHARDATA_CLASS_LIFE_CASTER: <span class="keywordflow">return</span> <span class="stringliteral">"Life Caster"</span>;
- <a name="l00110"></a>00110 <span class="keywordflow">case</span> CHARDATA_CLASS_WAR_MAGE: <span class="keywordflow">return</span> <span class="stringliteral">"War Mage"</span>;
- <a name="l00111"></a>00111 <span class="keywordflow">case</span> CHARDATA_CLASS_WAYFARER: <span class="keywordflow">return</span> <span class="stringliteral">"Wayfarer"</span>;
- <a name="l00112"></a>00112 <span class="keywordflow">case</span> CHARDATA_CLASS_SOLDIER: <span class="keywordflow">return</span> <span class="stringliteral">"Soldier"</span>;
- <a name="l00113"></a>00113 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
- <a name="l00114"></a>00114 }
- <a name="l00115"></a>00115 }
- <a name="l00116"></a>00116
- <a name="l00117"></a>00117 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnGender( DWORD dwGender )
- <a name="l00118"></a>00118 {
- <a name="l00119"></a>00119 <span class="keywordflow">switch</span> ( dwGender )
- <a name="l00120"></a>00120 {
- <a name="l00121"></a>00121 <span class="keywordflow">case</span> CHARDATA_SEX_FEMALE: <span class="keywordflow">return</span> <span class="stringliteral">"Female"</span>;
- <a name="l00122"></a>00122 <span class="keywordflow">case</span> CHARDATA_SEX_MALE: <span class="keywordflow">return</span> <span class="stringliteral">"Male"</span>;
- <a name="l00123"></a>00123 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
- <a name="l00124"></a>00124 }
- <a name="l00125"></a>00125 }
- <a name="l00126"></a>00126
- <a name="l00127"></a>00127 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnRace( DWORD dwRace )
- <a name="l00128"></a>00128 {
- <a name="l00129"></a>00129 <span class="keywordflow">switch</span> ( dwRace )
- <a name="l00130"></a>00130 {
- <a name="l00131"></a>00131 <span class="keywordflow">case</span> CHARDATA_RACE_ALUVIAN: <span class="keywordflow">return</span> <span class="stringliteral">"Aluvian"</span>;
- <a name="l00132"></a>00132 <span class="keywordflow">case</span> CHARDATA_RACE_GHARU: <span class="keywordflow">return</span> <span class="stringliteral">"Gharu'ndim"</span>;
- <a name="l00133"></a>00133 <span class="keywordflow">case</span> CHARDATA_RACE_SHO: <span class="keywordflow">return</span> <span class="stringliteral">"Sho"</span>;
- <a name="l00134"></a>00134 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
- <a name="l00135"></a>00135 }
- <a name="l00136"></a>00136 }
- <a name="l00137"></a>00137
- <a name="l00138"></a>00138 <span class="keyword">static</span> <span class="keyword">inline</span> <span class="keywordtype">char</span> *ReturnNamePrefix( BYTE bLevel )
- <a name="l00139"></a>00139 {
- <a name="l00140"></a>00140 <span class="keywordflow">switch</span> ( bLevel )
- <a name="l00141"></a>00141 {
- <a name="l00142"></a>00142 <span class="keywordflow">case</span> eDeveloper: <span class="keywordflow">return</span> <span class="stringliteral">"+Developer "</span>;
- <a name="l00143"></a>00143 <span class="keywordflow">case</span> eAdmin: <span class="keywordflow">return</span> <span class="stringliteral">"+Envoy "</span>;
- <a name="l00144"></a>00144 <span class="keywordflow">case</span> eUeber: <span class="keywordflow">return</span> <span class="stringliteral">"+Uber "</span>;
- <a name="l00145"></a>00145 <span class="keywordflow">case</span> eSentinel: <span class="keywordflow">return</span> <span class="stringliteral">"+Sentinel "</span>;
- <a name="l00146"></a>00146 <span class="keywordflow">case</span> eAdvocate: <span class="keywordflow">return</span> <span class="stringliteral">"+Advocate "</span>;
- <a name="l00147"></a>00147 <span class="keywordflow">case</span> eStaff: <span class="keywordflow">return</span> <span class="stringliteral">"+"</span>;
- <a name="l00148"></a>00148 <span class="keywordflow">case</span> eVIP: <span class="keywordflow">return</span> <span class="stringliteral">"*"</span>;
- <a name="l00149"></a>00149 <span class="keywordflow">case</span> eNormal: <span class="keywordflow">return</span> <span class="stringliteral">""</span>;
- <a name="l00150"></a>00150 <span class="keywordflow">default</span>: <span class="keywordflow">return</span> NULL;
- <a name="l00151"></a>00151 }
- <a name="l00152"></a>00152 }
- <a name="l00153"></a>00153 <span class="keyword">private</span>:
- <a name="l00154"></a>00154
- <a name="l00155"></a>00155 };
- <a name="l00156"></a>00156
- <a name="l00157"></a>00157 <span class="preprocessor">#endif // #ifndef __DATABSE_H</span>
- </pre></div></div>
- <hr size="1"/><address style="text-align: right;"><small>Generated by
- <a href="http://www.doxygen.org/index.html">
- <img class="footer" src="doxygen.png" alt="doxygen"/></a> 1.6.2 </small></address>
- </body>
- </html>
|