Search found 5 matches

by Fyrmn472
Wed Oct 10, 2007 9:44 pm
Forum: Help/Support
Topic: Deleting XP
Replies: 9
Views: 30806

As I suspected, it worked by adding a ";" to the end.

Code: Select all

DROP TABLE `wc3_player`,`wc3_player_extra`,`wc3_player_race`,`wc3_player_skill`;
Thanks
by Fyrmn472
Wed Oct 10, 2007 1:11 pm
Forum: Help/Support
Topic: Deleting XP
Replies: 9
Views: 30806

I tried the DROP query you provided, restarted the game server, reconnected and levels are still where they were. So I cleared the buffer using "\c" and tried the DELETE query you provided. I restarted the game server, reconnected and levels are still where they were. Here's what I did: http://www.s...
by Fyrmn472
Wed Oct 10, 2007 11:45 am
Forum: Help/Support
Topic: Deleting XP
Replies: 9
Views: 30806

That doesn't not work for me. Shouldn't there be a ";" at the end?
by Fyrmn472
Sat Oct 06, 2007 12:08 am
Forum: Help/Support
Topic: Deleting XP
Replies: 9
Views: 30806

So if I want to delte all XP in DB, I query this in MySql:

Code: Select all

DELETE * FROM wc3_player`,`wc3_player_extra`,`wc3_player_race`,`wc3_player_skill`
I'm no expert but something doesn't look right.... :?
by Fyrmn472
Fri Oct 05, 2007 4:45 pm
Forum: Help/Support
Topic: To all of you having Problems with connecting to local mysql
Replies: 1
Views: 11900

For me, it was: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock All else fails, check /etc/my.cnf and it will have the basedir listed. The tutorial that was made is great! --> http://wc3mods.net/forums/viewtopic.php?t=375 I am VERY new to MySql and it was fairly easy to complete. All I had to do whe...