XP won't save with mySql
Moderator: Forum Moderator
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
XP won't save with mySql
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
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
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
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
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
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
amxx list
amxx modules
meta list
@ 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
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
out of the sourcecode (war3ft.cfg):
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?
Code: Select all
FT_min_b4_XP 2 // Minimum amount of players needed b4 awarding XP (default is 2)
could you post your full war3ft.cfg?
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
Look at the command description.DarkJP2 wrote:out of the sourcecode (war3ft.cfg):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 ^^'Code: Select all
FT_min_b4_XP 2 // Minimum amount of players needed b4 awarding XP (default is 2)
could you post your full war3ft.cfg?
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)
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
Here is the output from mysql db
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
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)
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
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
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.
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.
-
- WC3Mods Donor
- Posts: 223
- Joined: Thu Mar 09, 2006 6:05 pm
- Location: Germany
- Contact:
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
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