XP won't save with mySql

DesasterUK · Post by **DesasterUK** » Sun Jul 23, 2006 11:21 am

Hi there.
My XPs won't save

I'm using amxx 1.75a and war3ft 2.3.2

Here my war3FT.cfg

//´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.
// Warcraft 3 Frozen Throne Configuration File
//´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.´¯`·.¸¸.

// Saving Options

wc3_save_xp 1 // Enables saving of experience (uses a vault, default is 0)
wc3_save_xp_db 1 // How should we save XP? (0 = NVault, 1 = MySQL, 2 = SQLite)

wc3_save_by 0 // What should I save this as? steam id = 0, IP = 1, name = 2 (SQL ONLY, default is 0)
wc3_save_pruning 0 // Automatically prunes the database of old users at a mapchange (default is 0)
wc3_days_before_delete 31 // However many days before deleting XP or pruning from the database (default is 31)
wc3_save_end_round 0 // Save xp at the end of each round (may cause lag, default is 1)

// SQL Database Information

wc3_sql_dbhost "127.0.0.1" // Host Name
wc3_sql_dbuser "wc3ft" // User Name
wc3_sql_dbpass "*******" // Password
wc3_sql_dbname "wc3ft" // Database Name
wc3_sql_tbname "war3users" // Table Name

When i start up the server it says
"Couldn't find option(s) with such variable (name "PlayerName")"
So it seems it connects to mysql correctly.

I created the war3users table by my own like it is said in the sticky but i still get the same problem.

I saw in other Topics that the cvars of some guys are different from mine, like wc3_save_xp_db is sv_sql.

Some weeks ago i set up an uwc3 server on the same system and it worked fine at all.

Sorry for my bad english but i think it is readable.
Don't be confused about my name... i'm german

Post by **Geesu** » Sun Jul 23, 2006 1:01 pm

where did you get the config file from? That looks like a config file for war3ft 3.0, not 2.3.2 ?

Esp. since 2.3.2 doesn't have nvault

DesasterUK · Post by **DesasterUK** » Sun Jul 23, 2006 1:26 pm

lol...
before 2.3.2 i had installed 3.0 for testinh and forgot to change the config file.
But i still get the same problem.

war3ft.cfg (this time the right one)

// 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 "127.0.0.1" // Host Name
FT_sql_user "wc3ft" // User Name
FT_sql_pass "*******" // Password
FT_sql_db "wc3ft" // Database Name
FT_auto_pruning 0 // Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete 31 // 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)

I tried to connect to mysql via console with the correct user and pass... it works fine

DesasterUK · Post by **DesasterUK** » Sun Jul 23, 2006 2:37 pm

hmmm... maybe war3ft 2.3.2 doesn't work with amxx 1.75a?

i think the error isn't in the plugin.
it seems it is a problem with the mysql module but i can't figure it out

if amxx can't connect to mysql it has to show an error like "can not connect to mysql (wrong password)" or something like this

DarkJP2 · Post by **DarkJP2** » Sun Jul 23, 2006 3:42 pm

did you recompile the war3ft plugin with the 1.75a compiler? it could be that the old code isn't interpreted like it should be since amxx 1.75+ has rewritten sql modules

DesasterUK · Post by **DesasterUK** » Sun Jul 23, 2006 3:57 pm

no i haven't recompiled it.
i'll try it

no... still the same problem

DarkJP2 · Post by **DarkJP2** » Sun Jul 23, 2006 6:01 pm

oh ok, then there is one littel thing i want to ask you because i remebered that just some seconds ago: are enough players on the server? i think there must be 4 players minimum on the server that the xp gets saved. the limit can be changed somewhere in the source

Post by **Geesu** » Sun Jul 23, 2006 9:59 pm

Pls follow the sticky...

amxx list
amxx modules
meta list

DesasterUK · Post by **DesasterUK** » Mon Jul 24, 2006 2:34 am

amxx list

Code: Select all

10:30:33 Currently loaded plugins:
                name                    version  author            file             status   
          [  1] Admin Base              1.75     AMXX Dev Team     admin.amxx       running  
          [  2] Admin Commands          1.75     AMXX Dev Team     admincmd.amxx    running  
          [  3] Admin Help              1.75     AMXX Dev Team     adminhelp.amxx   running  
          [  4] Slots Reservation       1.75     AMXX Dev Team     adminslots.amxx  running  
          [  5] Multi-Lingual System    1.75     AMXX Dev Team     multilingual.am  running  
          [  6] Menus Front-End         1.75     AMXX Dev Team     menufront.amxx   running  
          [  7] Commands Menu           1.75     AMXX Dev Team     cmdmenu.amxx     running  
          [  8] Players Menu            1.75     AMXX Dev Team     plmenu.amxx      running  
          [  9] Maps Menu               1.75     AMXX Dev Team     mapsmenu.amxx    running  
          [ 10] Admin Chat              1.75     AMXX Dev Team     adminchat.amxx   running  
          [ 11] Anti Flood              1.75     AMXX Dev Team     antiflood.amxx   running  
          [ 12] Scrolling Message       1.75     AMXX Dev Team     scrollmsg.amxx   running  
          [ 13] Info. Messages          1.75     AMXX Dev Team     imessage.amxx    running  
          [ 14] Admin Votes             1.75     AMXX Dev Team     adminvote.amxx   running  
          [ 15] NextMap                 1.75     AMXX Dev Team     nextmap.amxx     running  
          [ 16] Nextmap Chooser         1.75     AMXX Dev Team     mapchooser.amxx  running  
          [ 17] TimeLeft                1.75     AMXX Dev Team     timeleft.amxx    running  
          [ 18] Pause Plugins           1.75     AMXX Dev Team     pausecfg.amxx    running  
          [ 19] Stats Configuration     1.75     AMXX Dev Team     statscfg.amxx    running  
          [ 20] StatsX                  1.75     AMXX Dev Team     statsx.amxx      running  
          [ 21] Warcraft 3 Frozen Thro  2.3.2    Geesu==(Pimp Dad  warcraft3FT.amx  debug    
         21 plugins, 21 running

amxx modules

Code: Select all

10:32:23 Currently loaded modules:
               name                    version  author               status     
          [ 1] MySQL                   1.75     AMX Mod X Dev Team   running    
          [ 2] Fun                     1.75     AMX Mod X Dev Team   running    
          [ 3] Engine                  1.75     AMX Mod X Dev Team   running    
          [ 4] FakeMeta                1.75     AMX Mod X Dev Team   running    
          [ 5] CStrike                 1.75     AMX Mod X Dev Team   running    
          [ 6] CSX                     1.75     AMX Mod X Dev Team   running    
          [ 7] Sockets                 1.75     HLSW Dev Team        running    
         7 modules, 7 correct

meta list

Code: Select all

10:33:07 Currently loaded plugins:
               description      stat pend  file              vers      src  load  unlod
          [ 1] AMX Mod X        RUN   -    amxmodx_mm_i386.  v1.75a    ini  ANY   ANY  
          [ 2] MySQL            RUN   -    mysql_amxx_i386.  v1.75     pl1  ANY   ANY  
          [ 3] Fun              RUN   -    fun_amxx_i386.so  v1.75     pl1  ANY   ANY  
          [ 4] Engine           RUN   -    engine_amxx_i386  v1.75     pl1  ANY   ANY  
          [ 5] FakeMeta         RUN   -    fakemeta_amxx_i3  v1.75     pl1  ANY   ANY  
          [ 6] CStrike          RUN   -    cstrike_amxx_i38  v1.75     pl1  ANY   ANY  
          [ 7] CSX              RUN   -    csx_amxx_i386.so  v1.75     pl1  ANY   ANY  
         7 plugins, 7 running

@ DarkJP2:
I think its 4 players before u get XPs.
Savexp has to work all the time.
If u play with 4 players some time and one guy will left u cant save your xp? This makes no sense to me.

I activated savexp in the config.
But the server switches to short term.
I noticed it when i was testing and gave 10.000 XPs to another Player and he gets Level 10.
On savexp level 10 is something above 40.000 XPs

DarkJP2 · Post by **DarkJP2** » Mon Jul 24, 2006 3:45 am

out of the sourcecode (war3ft.cfg):

Code: Select all

	FT_min_b4_XP		2		// Minimum amount of players needed b4 awarding XP (default is 2)

i though the value of this cvar was higher by default because some people use to do 2-player-xp-"grinding" and that it affects the saving not the awarding ^^'

could you post your full war3ft.cfg?

DesasterUK · Post by **DesasterUK** » Mon Jul 24, 2006 4:16 am

DarkJP2 wrote:out of the sourcecode (war3ft.cfg):
Code: Select all
	FT_min_b4_XP		2		// Minimum amount of players needed b4 awarding XP (default is 2)
i though the value of this cvar was higher by default because some people use to do 2-player-xp-"grinding" and that it affects the saving not the awarding ^^'

could you post your full war3ft.cfg?

Look at the command description.
It says before awarding XP It doesn't take effect on the saveXP.

But thats not the problem.
The problem is that the server doesn't start in savexp mode because something seems wrong with mysql module or settings.
But user, pass, db and table are ok cause i can connect to it via putty.

The only error message i get is the one that told me that it cant find "PlayerName".
PlayerName is part of the war3users table and its in there.

maybe i made something wrong when i created the war3users table.
i followed the sticky for converting vault to mysql.
i meen i created the table in the way its told there.

Here is the full war3FT.cfg

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		"127.0.0.1"	// Host Name
FT_sql_user		"wc3ft"		// User Name
FT_sql_pass		"*****"		// Password
FT_sql_db		"wc3ft"		// Database Name
FT_auto_pruning		0		// Automatically prunes the database of old users at a mapchange (default is 0)
sv_daysbeforedelete	31		// 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)

// Experience options
mp_xpmultiplier		1.0		// set the level required to gain a level as a multiple (default 1.0)
mp_weaponxpmodifier	1		// gives additional XP for using certain weaker weapons (default is 1)
FT_min_b4_XP		2		// Minimum amount of players needed b4 awarding XP (default is 2)
FT_objectives		1		// If enabled, will display message in chat to show XP they gain for completing certain objectives (default is 1)
FT_kill_objectives	0		// Shows how much XP you gain for killing someone (each kill, default is 0)
FT_bombplanterxp	15		// XP given for planting the bomb (default is 15)
FT_defusexp		30		// XP given for defusing the bomb (default is 30)
FT_hostagexp		25		// XP given for helping to rescue the hostages (default is 25)
FT_killrescuemanxp	25		// XP given for killing the person rescuing the hostages (default is 25)
FT_xpbonus		50		// XP given for purchasing tome of experience (default is 50)
FT_kill_bomb_carrier_bonus 25		// XP given for killing the bomb carrier (default is 25)
FT_defuser_kill_bonus	25		// XP given for killing the defuser (default is 25)
FT_VIP_kill_bonus	25		// XP given for killing the VIP (default is 25)
FT_VIP_escape_bonus	30		// XP given when the VIP escapes (default is 30)
FT_headshot_bonus	9		// XP given for getting a headshot (default is 9)
FT_xp_radius		750		// Radius to give XP to teammates near where the special objective is completed (rescued hosties, bomb planted, killed vip, vip escaped, default is 750)
FT_round_win_XP		35		// Experience given to the winning team (default is 35)
FT_autoxp		0		// With this option set to 1, the joining players will receive the average amount of XP that all of the players have (SHORT TERM XP ONLY, default is 0)

// Game Play Enhancements
sv_warcraft3		1		// Set this to 0 to disable warcraft (default is 1)
mp_grenadeprotection	0		// Only 1 HE grenade will be allowed for purchase per round (default is 0)
FT_position		0		// 0 is for left, 1 is for right (where to put the information for those spectating, default is 0)
FT_centerhud		1		// Automatically makes the hud be centered (message that shows xp/race/level, default is 1)
FT_items_in_hud		0		// Display items w/a HUD message (this will take up 1 of the 4 channels, default is 0)
FT_spec_info		1		// Show Spectating information for dead players (default is 1)
FT_show_icons		1		// Shows icons on your screen when your ultimate is ready (default is 1)
FT_race_icons		1		// Allow users to type /icons to show player icons above the player (default is 1)
FT_level_icons		1		// Allow users to type /icons to see player levels above the player (default is 1)
FT_CD			0		// If set to 1, it will not allow players without Cheating Death to play this mod (default is 0)
FT_buyzone		0		// Restrict purchasing shopmenu items to within the buyzone? (default is 0)
FT_buytime		0		// Restrict purchasing shopmenu items to within the buytime? (default is 0)
FT_buydead		1		// Allow users to purchase items when dead? (default is 1)
FT_show_player		1		// Show teammate and enemy information in the center of the screen when they are on target? (not for DOD, default is 1)
FT_query_client		1		// Check user's cl_minmodel cvar every second (default is 1)

// TYPE OF WARCRAFT (If race 4 or 5 is selected, messsages will say WAR3 instead
// of saying WAR3FT, also shopmenu2 will be disabled, as well as saying rings and ability)
FT_races		8		// Number of races (if races are less than 5, the second shopmenu will be disabled (4 is standard war3), default is 8)

// ****************************************************************************************************
// ABILITY ENHANCEMENTS
// ****************************************************************************************************

// Chameleon Race Configuration Options (Race 9)
//	This race allows you to either assign skills that will be permanent, or random skills will be chosen each round
FT_Race9_Random		1		// Should the 9th race have random skills each round?, if so the next 4 option are irrelevant (default is 1)
FT_Race9_Skill1		1		// What race should the first skill be taken from? (default is 1)
FT_Race9_Skill2		1		// What race should the second skill be taken from? (default is 1)
FT_Race9_Skill3		1		// What race should the third skill be taken from? (default is 1)
FT_Race9_Ultimate	1		// What race should the ultimate be taken from? (default is 1)


// Skill and Ultimate configurations
FT_ultimatedelay	15.0		// Amount of time (in seconds) to delay the ultimates at the start of each round (default is 15.0)
FT_healing_range	750		// Range for Healing Wave to jump from player to player and heal (default is 750)
FT_ultimate_cooldown	35.0		// Cooldown of all ultimates (default is 35.0)
FT_warn_suicide		1		// Tells Undead Scourges their bomb is armed when they hit ultimate key, a second key press then detonates it (default is 1)
FT_blinkenabled		1		// Use blink instead of team teleport (default is 1)
FT_blink_protection	1		// slays people who abuse blink on some maps (skywalking, map exploiting, default is 1)
FT_blink_radius		500		// Enemies who have immunity w/in this radius will cause blink to fail (default is 500)
FT_blink_dizziness	1		// What type of diziness? (1 or 0 is flashbang effect, 2 is fading blue screen, default is 1)
FT_entangle_drop	0		// Should the player's primary weapon be dropped when they are entangled? (default is 0)
FT_impale_intensity	10		// Setting this to a lower non-negative number will lower the intensity of impale (default is 10)

// Item configurations
FT_glove_timer		10		// Interval between receiving a new grenade with the Flaming Gloves of Warmth (default is 10)
FT_no_gloves_on_ka	1		// Prevents Flaming gloves of warmth on ka maps and scoutzknivez (default is 1)
FT_glove_orc_damage	0		// When using gloves, should orcs be given the critical dmg? (Default is 0)
FT_no_orcnades		0		// Prevent orc nades on ka_ maps, fy_ maps and jail_riot (default is 0)
FT_claw			6		// Damage done by Claws of Attack (default is 6)
FT_bootspeed		275.0		// Speed given for purchasing boots of speed (different for dod, see dod section, default is 275)
FT_health_bonus		15		// Health bonus given for periapt of health (default is 15)
FT_frost_speed		125.0		// Speed of victim when attacked with Orb of Frost (default is 125.0)
FT_mask_of_death	0.2		// Percentage of like gained back by mask of death (default is 0.3)
FT_cloak		150		// Invisibility given with cloak, lower is more invisible (default is 150)
FT_sock			0.5		// Gravity level for Sock of the Feather

// Bot Configuration Options
FT_bot_buy_item		0.33		// Chance of a bot buying a shopmenu item at the beginning of the round (default is 0.33)

// DOD Options
DOD_startmoney		800		// Starting "fake" money for dod
DOD_bootspeed		45.0		// Stamina given for boots of speed in Day of Defeat (default is 45.0)

I tried it with localhost buts still the same.

DesasterUK · Post by **DesasterUK** » Mon Jul 24, 2006 4:23 am

Here is the output from mysql db

Code: Select all

mysql> describe war3users;
+------------+---------------+------+-----+---------+-------+
| Field      | Type          | Null | Key | Default | Extra |
+------------+---------------+------+-----+---------+-------+
| playerid   | varchar(35)   |      | PRI |         |       |
| playername | varchar(35)   |      |     |         |       |
| xp         | int(11)       |      |     | 0       |       |
| race       | tinyint(4)    |      | PRI | 0       |       |
| skill1     | tinyint(4)    |      |     | 0       |       |
| skill2     | tinyint(4)    |      |     | 0       |       |
| skill3     | tinyint(4)    |      |     | 0       |       |
| skill4     | tinyint(4)    |      |     | 0       |       |
| time       | timestamp(14) | YES  |     | NULL    |       |
+------------+---------------+------+-----+---------+-------+
9 rows in set (0.00 sec)

Maybe it helps to find the problem

I set up the statistics page on the same server and same userdata.
It shows no record found.
http://xps.team-kpk.de
I think its correct.
Theres no data in the table.
If its a problem with mysql it should show an error message

DesasterUK · Post by **DesasterUK** » Mon Jul 24, 2006 5:14 am

Tested with amxx 1.71
Workes fine
I think i got the problem.
1st i run a 3.0 alpha for testing.
war3ft.cfg is located in configs/war3ft
2.3.2 war3ft.cfg is located in configs/

when i set up 2.3.2 i just replaced the 3.0 config with the 2.3.2 one
will try it again with amxx 1.75
but i think it will work.

DesasterUK · Post by **DesasterUK** » Mon Jul 24, 2006 5:43 am

It workes.
Slap me.
Beat me.

But i'm a little bit confused.
How could the plugin connect to mysql without the config file?
Or is it connecting with the standard settings?
OK. User root exists.
But the standard db is not in mysql.
There should be an error message "can't find database".
But its an amxx error, right?

Just another question.
Are there differences in the mysql table structure between version 2.2.5 and 2.3.2?

I wanna update a server from 2.2.5 to 2.3.2.
Can i copy the database with mysql dumb?

Thx a lot so far
And thx for supporting one of the best plugins ever