Page 1 of 1
XP is not saving in database(5$ donation if you help me)
Posted: Wed Feb 21, 2007 9:32 am
by Senne
--- Please enter the following information for support ---
War3ft Version: 2.3.2
Amxmodx Version: v1.71
Metamod Version:
amxx list:
amxx modules:
meta list:
ill try to be full and give a full list :
Code: Select all
Currently loaded plugins:
name version author file status
Admin Base 1.71 AMXX Dev Team admin.amxx running
Admin Commands 1.71 AMXX Dev Team admincmd.amxx running
Admin Help 1.71 AMXX Dev Team adminhelp.amxx running
Multi-Lingual Sys 1.71 AMXX Dev Team multilingual.am running
Menus Front-End 1.71 AMXX Dev Team menufront.amxx running
Commands Menu 1.71 AMXX Dev Team cmdmenu.amxx running
Players Menu 1.71 AMXX Dev Team plmenu.amxx running
Teleport Menu 1.71 AMXX Dev Team telemenu.amxx running
Maps Menu 1.71 AMXX Dev Team mapsmenu.amxx running
Admin Chat 1.71 AMXX Dev Team adminchat.amxx running
Anti Flood 1.71 AMXX Dev Team antiflood.amxx running
Scrolling Message 1.71 AMXX Dev Team scrollmsg.amxx running
Info. Messages 1.71 AMXX Dev Team imessage.amxx running
Admin Votes 1.71 AMXX Dev Team adminvote.amxx running
NextMap 1.71 AMXX Dev Team nextmap.amxx running
Nextmap Chooser 1.71 AMXX Dev Team mapchooser.amxx running
TimeLeft 1.71 AMXX Dev Team timeleft.amxx running
Pause Plugins 1.71 AMXX Dev Team pausecfg.amxx running
Stats Configurati 1.71 AMXX Dev Team statscfg.amxx running
Restrict Weapons 1.71 AMXX Dev Team restmenu.amxx running
StatsX 1.71 AMXX Dev Team statsx.amxx running
CS Misc. Stats 1.71 AMXX Dev Team miscstats.amxx running
CS Stats Logging 1.71 AMXX Dev Team stats_logging.a running
Warcraft 3 Frozen 2.3.2 Geesu==(Pimp Dad warcraft3FT.amx debug
Team Balancer 1.8b2 Ptahhotep ptb.amxx running
AINO Commands 2.0 AMX(x) Community admin_allinone. running
Last man bets 0.9.3 JGHG lastmanbets.amx running
Automatic knife d 0.3 JGHG automatic_knife running
POD-Bot Menu 1.2 g4s|figurE.09 amxx_podbotmenu running
AMX Team Control 1.0 whitemike amx_teams.amxx running
Weapon Arena 2.0.4 JGHG/JTP10181 weaponarena.amx running
Real Nade Drops 0.4 VEN realnadedrops.a running
Ninja Rope 1.1.1 EJL-SpaceDude/JT amx_ninjarope.a
Code: Select all
Currently loaded modules:
name version author
Fun 1.71 AMX Mod X Dev Team
Engine 1.71 AMX Mod X Dev Team
FakeMeta 1.71 AMX Mod X Dev Team
CStrike 1.71 AMX Mod X Dev Team
CSX 1.71 AMX Mod X Dev Team
Sqlite 1.70 AMX Mod X De
Code: Select all
Currently running plugins:
[ 1] AMX Mod X, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 2] POD-Bot mm, vR2b46d, Aug 9 2005, by Count Floyd & Bots United, see http://www.bots-united.com
[ 3] Fun, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 4] Engine, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 5] FakeMeta, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 6] CStrike, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmodx.org
[ 7] CSX, v1.71, Apr 2 2006, by AMX Mod X Dev Team, see http://www.amxmo
The problem i'm having :
I created a mysql database with phpadmin.
After several rounds there is still no data in saved (no 'war3users' list).
While i filled in all the right data :
war3ft.cfg file :
Code: Select all
// Warcraft 3 Frozen Throne Configuration File
mp_savexp 1 // Enables saving of experience (uses a vault, default is 0)
sv_sql 0 // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
FT_admin_flag "m" // Admin flag required to give/take XP (default is m)
// SQL configuration
FT_sql_host "blinkedouttoprotectme.secureserver.net" // Host Name
FT_sql_user "amxxft" // User Name
FT_sql_pass "amxxft" // Password
FT_sql_db "amxxft" // Database Name
FT_auto_pruning 1 // Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete 333 // However many days before deleting XP or pruning from the database (default is 31)
sv_sqltablename "war3users" // Table Name, no need to change (default is war3users)
sv_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)
And it creates a bug to : when i enter players start with an ultimate.. while having 0 xp.
I leveled 3 levels, xp saves at the end of the round.
I changed map, and it started with 0 xp.
My database says no data found.
The log file does not give any error related to saving xp or database.
I willmake a small donation if you can help me , bec i already spended 2 days in fixing it.
ow i also tried
for a day and then xp did save and there wasnt an ultimate bug. But then the xp is saved on the gameserver right? Bec when i connect it with a xpstat page to the xp database on webserver it says no data.
Posted: Wed Feb 21, 2007 1:05 pm
by DesasterUK
enable mysql in your modules.ini
i'm not sure, but i think 2.3.2 doesn't support sqlite
Posted: Wed Feb 21, 2007 1:12 pm
by Senne
ok i found this :
Code: Select all
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
;mysql_amxx_i386.so
;mysql_amxx.dll
;mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
sqlite_amxx.dll
sqlite_amxx_i386.so
sqlite_amxx_amd64.so
and replaced it to this :
Code: Select all
; -------------------------------------------
; Database Access - only enable one of these
; -------------------------------------------
; MySQL
mysql_amxx_i386.so
mysql_amxx.dll
mysql_amxx_amd64.so
; PostgreSQL
;pgsql_amxx_i386.so
;pgsql_amxx.dll
; Microsoft SQL
;mssql_amxx.dll
; SQLite
;sqlite_amxx.dll
;sqlite_amxx_i386.so
;sqlite_amxx_amd64.so
in the modules.ini
Posted: Wed Feb 21, 2007 1:19 pm
by DesasterUK
now wait for a mapchange and check if mysql is running
amxx modules
now it should work
otherwise take a look in the amxx logs for an error message and post it here if u don't know how to handle it
Posted: Wed Feb 21, 2007 1:20 pm
by Senne
well euhm it gave my server a 2000 ping...for 3 minutes
then i see in the log file it couldnt connect to the mysql database
Code: Select all
Unable to connect to the MySQL database after 3 attempts, switching to short-term mode
L 02/21/2007 - 14:18:07: [warcraft3FT.amxx] Error: Can't connect to MySQL server on 'blinked out.secureserver.net' (10060)
Do i need to give an ip or can i just fill in the domain name the database gives me xxxx.secureserver.net in my case.
Do i need to set anything else then the war3ft.cfg file? or do i have to do something in my database to allow it to connect?
Posted: Wed Feb 21, 2007 1:20 pm
by YamiKaitou
Check you amxx logs and see if there is any errors
Posted: Wed Feb 21, 2007 1:25 pm
by DesasterUK
maybe u have to set ur gameserver ip in ur database to allow the connection
normally u can type the domain name
but the ip will be more "secure", because of DNS problems
in the error logs there should be a more detailed error message
Posted: Wed Feb 21, 2007 1:53 pm
by Senne
here is the error log at a newmap :
Code: Select all
L 02/21/2007 - 14:16:48: [admincmd.amxx] Cmd: "WAR3 FROZEN THRONE T3HRELOADED.<0><><>" changelevel "cs_italy"
L 02/21/2007 - 14:16:50: [warcraft3FT.amxx] Database pruning successful, data older than 333 days was removed
L 02/21/2007 - 14:16:50: [warcraft3FT.amxx] SQLite database connection closed
L 02/21/2007 - 14:16:50: -------- Mapchange to cs_italy --------
L 02/21/2007 - 14:16:52: [AMXX] Failed to open dictionary file: cstrike\addons\amxmodx\data\lang\admin_allinone.txt
L 02/21/2007 - 14:17:15: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 02/21/2007 - 14:17:15: [warcraft3FT.amxx] Error: Can't connect to MySQL server on 'p3smysql1.secureserver.net' (10060)
L 02/21/2007 - 14:17:15: [mapmanager.amxx] DeagsMapManager - Found 11 Maps in your mapcycle.txt/allmaps.txt file, 11 are available for filling slots.
L 02/21/2007 - 14:17:16: [mapmanager.amxx] DeagsMapManager - Did not ban any maps from mapstoban.ini file.
L 02/21/2007 - 14:17:41: [warcraft3FT.amxx] Database connection failed, attempting to reconnect in 5 seconds
L 02/21/2007 - 14:17:41: [warcraft3FT.amxx] Error: Can't connect to MySQL server on 'p3smysql1.secureserver.net' (10060)
L 02/21/2007 - 14:17:43: [MYSQL] Invalid database handle 0
L 02/21/2007 - 14:17:43: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx")
L 02/21/2007 - 14:17:43: [AMXX] Run time error 10: native error (native "dbi_query")
L 02/21/2007 - 14:17:43: [AMXX] [0] XP.inl::XP_Prune_Player (line 789)
L 02/21/2007 - 14:17:43: [AMXX] [1] warcraft3FT.sma::client_putinserver (line 376)
L 02/21/2007 - 14:17:44: [MYSQL] Invalid database handle 0
L 02/21/2007 - 14:17:44: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx")
L 02/21/2007 - 14:17:44: [AMXX] Run time error 10: native error (native "dbi_query")
L 02/21/2007 - 14:17:44: [AMXX] [0] XP.inl::XP_Prune_Player (line 789)
L 02/21/2007 - 14:17:44: [AMXX] [1] warcraft3FT.sma::client_putinserver (line 376)
L 02/21/2007 - 14:17:45: [MYSQL] Invalid database handle 0
L 02/21/2007 - 14:17:45: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx")
L 02/21/2007 - 14:17:45: [AMXX] Run time error 10: native error (native "dbi_query")
L 02/21/2007 - 14:17:45: [AMXX] [0] XP.inl::XP_Prune_Player (line 789)
L 02/21/2007 - 14:17:45: [AMXX] [1] warcraft3FT.sma::client_putinserver (line 376)
L 02/21/2007 - 14:17:45: [MYSQL] Invalid database handle 0
L 02/21/2007 - 14:17:45: [AMXX] Displaying debug trace (plugin "warcraft3FT.amxx")
L 02/21/2007 - 14:17:45: [AMXX] Run time error 10: native error (native "dbi_query")
L 02/21/2007 - 14:17:45: [AMXX] [0] XP.inl::XP_Prune_Player (line 789)
L 02/21/2007 - 14:17:45: [AMXX] [1] warcraft3FT.sma::client_putinserver (line 376)
L 02/21/2007 - 14:18:07: [warcraft3FT.amxx] Unable to connect to the MySQL database after 3 attempts, switching to short-term mode
L 02/21/2007 - 14:18:07: [warcraft3FT.amxx] Error: Can't connect to MySQL server on 'p3smysql1.secureserver.net' (10060)
L 02/21/2007 - 14:18:11: [mapmanager.amxx] DeagsMapManager - Loaded 9 maps into the maps that will be picked for the vote.
L 02/21/2007 - 14:18:11: [mapmanager.amxx] DeagsMapManager - 1 Maps were not loaded because they were the last maps played, or defined twice, or banned.
L 02/21/2007 - 14:18:38: [admin.amxx] Login: "[T3H-RL] Senne<153><STEAM_0:0:3637317><>" became an admin (account "STEAM_0:0:3637317") (access "abcdefghijklmnopqrtu") (address "81.165.160.179")
L 02/21/2007 - 14:36:25: [mapmanager.amxx] DeagsMapManager - Nominations for the map vote: 0 out of 5 possible nominations
L 02/21/2007 - 14:36:25: [mapmanager.amxx] DeagsMapManager - randomly filling slots for the vote with 5 out of 9.
L 02/21/2007 - 14:36:25: [mapmanager.amxx] DeagsMapManager - Filled 5 vote slots with random maps.
L 02/21/2007 - 14:36:25: [mapmanager.amxx] DeagsMapManager - Vote: Voting for the next map started.
L 02/21/2007 - 14:36:45: [mapmanager.amxx] DeagsMapManager - Vote: Voting for the next map finished. The next map will be awp_winter.
besides the mapchanger errors there is the database error.
amxx modules :
Code: Select all
Currently loaded modules:
name version author
Fun 1.71 AMX Mod X Dev Team
Engine 1.71 AMX Mod X Dev Team
FakeMeta 1.71 AMX Mod X Dev Team
CStrike 1.71 AMX Mod X Dev Team
CSX 1.71 AMX Mod X Dev Team
MySQL 1.71 AMX Mod X De
and mysql is indeed loaded
in addition i checked my war3ft.cfg again :
Code: Select all
// Warcraft 3 Frozen Throne Configuration File
mp_savexp 1 // Enables saving of experience (uses a vault, default is 0)
sv_sql 1 // Save using a SQL module (a module needs to be turned on, note: to use this mp_savexp must also be 1, default is 0)
FT_saveby 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (default is 0)
FT_admin_flag "m" // Admin flag required to give/take XP (default is m)
// SQL configuration
FT_sql_host "leftout.secureserver.net" // Host Name
FT_sql_user "amxxft" // User Name
FT_sql_pass "amxxft" // Password
FT_sql_db "amxxft" // Database Name
FT_auto_pruning 1 // Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete 333 // However many days before deleting XP or pruning from the database (default is 31)
sv_sqltablename "war3users" // Table Name, no need to change (default is war3users)
sv_save_end_round 1 // Save xp at the end of each round (may cause lag, default is 1)
my amxxft database is with phpadmin, if someone can tell me how to make sure my gameserver is allowed to acces it.. bec i have no clue
what i get with my mysql database
Code: Select all
$hostname="leftout.secureserver.net";
$username="amxxft";
$password="your_password";
$dbname="amxxft";
$usertable="your_tablename";
of course your password = amxxft
Posted: Wed Feb 21, 2007 1:54 pm
by Senne
ow before i forget when i open my database there is indeed no table with 'war3users' . So my server really cant connect to the database
Posted: Wed Feb 21, 2007 2:00 pm
by DesasterUK
your mysql server doesn't seem to exist
couldn't ping or trace him
is it a database given to you from your website provider?
seems he blocks all connections from outside
--- edit ---
where are you from?
Posted: Wed Feb 21, 2007 2:27 pm
by Senne
sry one day in the month my internet is fucked up , and this month it is today
i always blinked out the database adress for safety reasons...
but ok here it is : p3smysql1.secureserver.net
i'm located in belgium but the webserver and gameserver in the usa (atlanta). its a usa community
Posted: Wed Feb 21, 2007 2:33 pm
by DesasterUK
i know ur serveraddress
its showing in the log file
as i said i can't ping or trace it
so it seems your server blocks all connections from outside
Posted: Wed Feb 21, 2007 2:47 pm
by Senne
is there a way to enable this?
bec i have postnuke and a wordpress (websites) that use a database and they work fine.
I also tried out this morning an xpstats and that was able to connect to the xp database.. the only thing it gave that there were no users.
Posted: Wed Feb 21, 2007 3:02 pm
by DesasterUK
ur websites (xp-stats, postnuke, wordpress) are running at the same provider as the mysql database?
in that case contact your provider if there is a way to connect from outside to your database.
Posted: Wed Feb 21, 2007 3:09 pm
by Senne
ok i sended them a mail (my hosting company is godaddy.com, maybe you know them... ).
And yes my websites are running on the same webserver as the database is.
i'll let you know if they help me
Posted: Wed Feb 21, 2007 7:03 pm
by Geesu
Your permissions are set up wrong - as the app can't connect to MySQL given the supplied info...
Another issue I noticed - do NOT create war3users yourself - it will be created automatically
Making it yourself will just add to the problems
Posted: Wed Feb 21, 2007 10:50 pm
by DesasterUK
Josh?
Try to ping his database server.
No reply all the time.
So it couldn't be because of wrong permissions.
I think it's a server within a LAN that can only be reached by other servers in the network of his provider
Posted: Thu Feb 22, 2007 5:05 am
by Senne
I mailed my provider (godaddy.com) And i was really suprised that such a large company doesn not allow remote connections to their databases... .
Anyhow i have a friend who lent me a database and i now connected the gameserver to it. The log i'm getting now isd this (after a mapchange)
Code: Select all
L 02/22/2007 - 05:57:05: -------- Mapchange to de_dust2 --------
L 02/22/2007 - 05:57:08: [warcraft3FT.amxx] Connection to MySQL database successful
L 02/22/2007 - 05:58:10: [warcraft3FT.amxx] Error in querying database, location: 3
L 02/22/2007 - 05:58:10: [warcraft3FT.amxx] Message: Lost connection to MySQL server during query (1)
L 02/22/2007 - 05:58:10: [warcraft3FT.amxx] Query statement: REPLACE INTO `war3users` (`playerid`, `playername`, `xp`, `race`, `skill1`, `skill2`, `skill3`, `skill4`) VALUES ('STEAM_0:0:3637317', '[T3H-RL] Senne', 48, 3, 0, 0, 0, 0)
this is what i get in the server at the end of a round
Code: Select all
* [WAR3FT] An error has occurred when saving your race information, please contact a server
administrat
not each round , like every 3 rounds i think
If i keep using his database and lets say in a year i change my hosting and create an own database , can i just export the current one and load it in a new one?
Posted: Thu Feb 22, 2007 5:12 am
by Senne
ow i just did a couple of mapchanges and the xp i had the rounds before saves.
another thingy , does a server with 20 players + xpstats + banlist create alot of traffic to the mysql databases ? just so my friend doesnt get an overload.
Posted: Thu Feb 22, 2007 11:02 am
by DesasterUK
never checked the database traffic, cause i'm running mysql and my gameserver on the same server
@ query error:
try to connect directly on the ip adress instead the domain name
maybe there is a ping problem
Posted: Thu Feb 22, 2007 12:04 pm
by Senne
i'll be asking him for the ip's
when i didnt had acces from the gameserver to the webserver , i did install xpstats 1.1 . And it did work (meaning it did load the page). But now after changing the info of it (new database adres) it doesnt seen to load anymore (maybe the same ping problem).
Anyone have a good xpstats mod? if been googling alot and ... nothing really comes out.