Saving XP by MySQL

Read log files for errors! If this fails, come here for help

Moderator: Forum Moderator

Post Reply
Roober
Peon
Posts: 6
Joined: Thu Oct 04, 2007 1:49 pm

Saving XP by MySQL

Post by Roober » Sun Oct 07, 2007 6:35 am

Hi! I have installed War3ft server (v.2.3.2) and I want to save players XP using MySQL db. But there is a problem

This is a part of my warFT.cfg

Code: Select all

mp_savexp 1
sv_sql	1
FT_saveby2

// SQL configuration
FT_sql_host		"SQL db IP addess"	
FT_sql_user		"XXXX"		
FT_sql_pass		"XXXX"		
FT_sql_db		"war3xp"
This is a part of my sql.cfg

Code: Select all

amx_sql_host	"SQL db IP addess"
amx_sql_user	"XXXX"
amx_sql_pass	"XXXX"
amx_sql_db	"war3xp"
amx_sql_table	"admins"
And there is no error logs in server console :shock:

War3ft Version: 2.3.2
Amxmodx Version: 1.76d
Metamod Version: 1.19

PS Sorry for my english

Need your help :(

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  
Slots Reservation  1.71     AMXX Dev Team     adminslots.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  
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  
ATAC               2.5.5.5  T(+)rget/f117bom  atac.2.5.5.5.am  running  
Warcraft 3 Frozen  2.3.2    Geesu==(Pimp Dad  warcraft3FT.amx  runing    
Respawn Forever    1.1      Pimp Daddy (OoTO  respawn.amxx     running  
Play or Be Kicked  1.4      Brad Jones        pbk.amxx         running  
ShowIP             1.0      hasta             amx_who.amxx     running  
High Ping Kicker   0.16.2   OLO/shadow        high_ping_kicke  running  
Join Name          1.2      jsauce            join_name.amxx   running  
Admin Free Look    1.9      Jim               admin_freelook.  running  

Code: Select all

Currently loaded modules:
name                    version  author              
Fun                     1.76     AMX Mod X Dev Team  
Engine                  1.76     AMX Mod X Dev Team  
FakeMeta                1.76d    AMX Mod X Dev Team  
MySQL                   1.76b    AMX Mod X Dev Team  
SQLite                  1.76b    AMX Mod X Dev Team  
CStrike                 1.71     AMX Mod X Dev Team  
CSX                   1.71     AMX Mod X Dev Team  

kp_downarrow
Rifleman
Posts: 162
Joined: Thu Dec 21, 2006 2:12 am

Post by kp_downarrow » Sun Oct 07, 2007 6:33 pm

whats the problem?

Roober
Peon
Posts: 6
Joined: Thu Oct 04, 2007 1:49 pm

Post by Roober » Mon Oct 08, 2007 6:54 am

Players XP saves to vault.ini but I want to save it in MySQL database!

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Tue Oct 09, 2007 8:12 am

First, either use AmxModX 1.71 or 1.76d, not both. Then, if you are using 1.76d, you will need to recompile wc3ft so it will work correctly. Then, post back here if you are still having issues
Image

No support via PM or Email

Roober
Peon
Posts: 6
Joined: Thu Oct 04, 2007 1:49 pm

Post by Roober » Tue Oct 09, 2007 4:07 pm

I have recompiled my warcraft3FT.sma with amxmodx 1.76 But problem doesn't gone :(

Code: Select all

Fun                     1.76     AMX Mod X Dev Team  
Engine                  1.76     AMX Mod X Dev Team  
FakeMeta                1.76d    AMX Mod X Dev Team  
MySQL                   1.76b    AMX Mod X Dev Team  
CStrike                 1.76     AMX Mod X Dev Team  
CSX                     1.76c    AMX Mod X Dev Team  
This is my error log after recompile. But axis-inf.mdl is dod model, am I right?

Code: Select all

L 10/10/2007 - 14:30:25: -------- Mapchange to de_dust --------
FATAL ERROR (shutting down): Mod_NumForName: models/player/axis-inf/axis-inf.mdl not found
Add "-debug" to the ./hlds_run command line to generate a debug.log to help with solving this problem
Срд Окт 10 14:30:25 GMT+2 2007: Server restart in 10 seconds
Attachments
warcraft3FT.sma
This is my warcraft3FT.sma, maybe someone would recompile it correctly :oops:
(19.88 KiB) Downloaded 344 times

Roober
Peon
Posts: 6
Joined: Thu Oct 04, 2007 1:49 pm

Post by Roober » Fri Oct 12, 2007 1:39 pm

help me :(

User avatar
YamiKaitou
Forum Moderator
Forum Moderator
Posts: 1925
Joined: Wed Feb 01, 2006 4:33 pm
Contact:

Post by YamiKaitou » Fri Oct 12, 2007 3:06 pm

That error is not being caused by WC3FT. Please verify that you have that file on the server.
Image

No support via PM or Email

Post Reply