MySQL Quick Questions

jinetix · Post by **jinetix** » Mon Nov 21, 2005 4:14 am

Sorry, I couldn't find this in the forum search. If this has been answered already, I apologize beforehand.

Okay, I know that if the MySQL databse is located on the same machine as the game server, everything would be much faster and efficient but would that be the case if the database was located on a webserver? The webserver is located in Chicago and the game server is located in California. Will there be any glitches or lag when it comes to retrieving exp data if I use the web server option? Should I stick to the vault.ini?

Also, when I use the Vault Conversion tool on the website, I get this error.

Code: Select all

Query failed : (REPLACE INTO `war3users` SET playerid='STEAM_0:0:3658609',playername='=LNL=SkillZ' ',xp='211',race='8',skill1='0',skill2='1',skill3='0',skill4='0'; ) You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '211',race='8',skill1='0',skill2='1',skill3='0',skill4='0'' at line 1

Post by **Geesu** » Mon Nov 21, 2005 9:26 am

OK try it again, it was a bug in my code (would fail when a user had a ' in their name)

jinetix · Post by **jinetix** » Tue Nov 22, 2005 4:43 pm

It worked perfectly.

Geesu, one more quick question about sv_daysbeforedelete. If I set it to 0, will it disable the feature (not delete xp) or does the 0 mean that it'll delete everything?

Post by **Geesu** » Tue Nov 22, 2005 7:07 pm

No it will delete everything, the auto_pruning has to be on for that cvar to do anything

jinetix · Post by **jinetix** » Wed Nov 23, 2005 6:26 am

Something isn't working right. The experience on the server isn't being saved into the MySQL database but still into the vault.ini. I set mp_savexp to 1 and sv_mysql to 1 also.

mp_savexp 1
sv_mysql 1
FT_saveby 0
FT_mysql_host "205.234.243.50"
FT_mysql_user "myusername"
FT_mysql_pass "mypass"
FT_mysql_db "mydb"

I'm also running admin_sql.amxx. Why isn't it saving onto the MySQL server?

Post by **Geesu** » Wed Nov 23, 2005 8:50 am

Did you completely shut down your server? Check your amxx logs for an error message, and post what it says. If it's reading the sv_mysql correctly and it's not connecting it shoudl tell you in the logs

jinetix · Post by **jinetix** » Fri Nov 25, 2005 4:44 am

I get this error for the SQL..
L 11/25/2005 - 00:00:42: [MYSQL] Invalid database handle 0

Also, this may be a little off topic but, I get run time errors for a lot of the plugins saying.. "debug not enabled!" Should I set them all to debug mode?

Post by **Geesu** » Fri Nov 25, 2005 9:57 am

Doesn't matter, up 2 u... Also, that means its not connecting properly, wait til 2.2.9 and you *should* get a more detailed error message on connect