Archived copy of war3source.com, the War3Source forum (2009–2020), rebuilt from the Internet Archive by wc3mods.net. This page was captured on 2012-10-25 (original capture). Forum · All archived topics · Wiki · Bug tracker · Blog

War3:Source

General Discussion => War3: Source - Requests => Topic started by: Zydu on December 05, 2010, 06:00:28 AM



Title: Reset player level via command
Post by: Zydu on December 05, 2010, 06:00:28 AM
Plugin allowing to reset player lvl via command on all races will be really useful.


Title: Re: Reset player level via command
Post by: Zydu on December 13, 2011, 07:21:37 AM
Bump.

Is there still hope for this addon or should I look for good sqlite editor?


Title: Re: Reset player level via command
Post by: Ownz on December 13, 2011, 11:30:30 AM
why does the player want to lose levels?


Title: Re: Reset player level via command
Post by: alex0310 on December 13, 2011, 11:40:03 AM
player does not want. I think it wants admin)))


Title: Re: Reset player level via command
Post by: Vulpone on December 13, 2011, 12:35:05 PM
why does the player want to lose levels?

Some people on our server have done that. addiction.


Title: Re: Reset player level via command
Post by: Necavi on December 13, 2011, 08:44:47 PM
Created a plugin that will do it.
Two things to note about this:
1.) This is the worst way to do it, ideally this would be done through MySQL, but I was too lazy to look and see what would need clearing precisely.
2.) You have to supply a clientID, making it fairly useless, but that would be fairly easy to change, unfortunately I need to go cook dinner.

Registers War3_ResetLevels <client>.


Title: Re: Reset player level via command
Post by: nvn on December 14, 2011, 06:56:58 AM
You may also find that usefull, it wipes all data by steamid in w3s tables:

Code:
SQL_FastQuery(db,"DELETE FROM war3source, war3source_item2, war3source_racedata1
USING war3source
INNER JOIN war3source_item2
INNER JOIN war3source_racedata1
where war3source.steamid=war3source_item2.steamid AND war3source_item2.steamid=war3source_racedata1.steamid and war3source_racedata1 .steamid = %s;",AuthString);