XP is not saving in database(5$ donation if you help me)

[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

Code: Select all

sv_sql			1	

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.

[DesasterUK]

enable mysql in your modules.ini

i'm not sure, but i think 2.3.2 doesn't support sqlite

[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

[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

[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?

[YamiKaitou]

Check you amxx logs and see if there is any errors

[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

[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

[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

[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?

[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

[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

[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.

[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.

[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

[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

[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

[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?

[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.

[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

[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.