diff options
| author | Aaron Marks <nymacro@gmail.com> | 2005-07-31 05:26:08 +0000 |
|---|---|---|
| committer | Aaron Marks <nymacro@gmail.com> | 2005-07-31 05:26:08 +0000 |
| commit | 18b778662388e98e90b13f28f28a83911ee96e95 (patch) | |
| tree | 5e16ba5adc9cdc3d4f84769e0a4e93ff7155c7a0 /src/dalstorage.cpp | |
| parent | d593cb2395ddc144844297ea12122c12e60d3bba (diff) | |
| download | manaserv-18b778662388e98e90b13f28f28a83911ee96e95.tar.gz manaserv-18b778662388e98e90b13f28f28a83911ee96e95.tar.bz2 manaserv-18b778662388e98e90b13f28f28a83911ee96e95.tar.xz manaserv-18b778662388e98e90b13f28f28a83911ee96e95.zip | |
Added beginnings of game core logic and state.
Fixed a few problems with SQL queries using different SQL DB backends.
I forget everything else.
Diffstat (limited to 'src/dalstorage.cpp')
| -rw-r--r-- | src/dalstorage.cpp | 16 |
1 files changed, 12 insertions, 4 deletions
diff --git a/src/dalstorage.cpp b/src/dalstorage.cpp index 938b06a9..1bc71dab 100644 --- a/src/dalstorage.cpp +++ b/src/dalstorage.cpp @@ -446,7 +446,7 @@ DALStorage::_addAccount(const AccountPtr& account) RawStatistics& stats = (*it)->getRawStatistics(); std::ostringstream sql3; sql3 << "insert into " << CHARACTERS_TBL_NAME - << " (name, gender, level, money, x, y, map_id, str, agi, int, dex luck)" + << " (name, gender, level, money, x, y, map_id, str, agi, vit, int, dex luck)" << " values (" << (account_it->second).id << ", '" << (*it)->getName() << "', '" @@ -531,10 +531,18 @@ DALStorage::_updAccount(const AccountPtr& account) std::ostringstream sql3; if (charInfo.rows() == 0) { - sql3 << "inpsert into " << CHARACTERS_TBL_NAME - << " (name, gender, level, money, x, y, map_id, str, agi, vit, int, dex, luck)" + sql3 << "insert into " << CHARACTERS_TBL_NAME + << " (" +#ifdef SQLITE_SUPPORT + << "user_id, " +#endif + << "name, gender, level, money, x, y, map_id, str, agi, vit, int, dex, luck)" << " values (" +#ifdef SQLITE_SUPPORT << (account_it->second).id << ", '" +#else + << "'" +#endif << (*it)->getName() << "', " << (*it)->getGender() << ", " << (*it)->getLevel() << ", " @@ -561,7 +569,7 @@ DALStorage::_updAccount(const AccountPtr& account) << " str = " << stats.strength << ", " << " agi = " << stats.agility << ", " << " vit = " << stats.vitality << ", " -#ifdef MYSQL_SUPPORT +#if defined(MYSQL_SUPPORT) || defined(POSTGRESQL_SUPPORT) << " `int` = " << stats.intelligence << ", " #else << " int = " << stats.intelligence << ", " |