From 18b778662388e98e90b13f28f28a83911ee96e95 Mon Sep 17 00:00:00 2001 From: Aaron Marks Date: Sun, 31 Jul 2005 05:26:08 +0000 Subject: Added beginnings of game core logic and state. Fixed a few problems with SQL queries using different SQL DB backends. I forget everything else. --- src/dalstorage.cpp | 16 ++++++++++++---- 1 file changed, 12 insertions(+), 4 deletions(-) (limited to 'src/dalstorage.cpp') 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 << ", " -- cgit v1.2.3-70-g09d2