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

War3:Source
September 21, 2012, 10:41:28 PM *
Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
News: Download: http://war3source.com/index.php?board=9.0
What is War3Source?: http://war3source.com/index.php?topic=200.0
Sample Stats: http://war3source.com/war3stats
Steam Community Group: http://steamcommunity.com/groups/war3source
War3Source SVN Checkout: http://ownageclan.com/svn/war3source/
War3Source servers: http://www.game-monitor.com/search.php?vars=war3_version=
 
   Home   Help Search Login Register  
Pages: [1]
  Print  
Author Topic: Reset player level via command  (Read 733 times)
Zydu
Jr. Member
**
Posts: 51


View Profile
« on: December 05, 2010, 06:00:28 AM »

Plugin allowing to reset player lvl via command on all races will be really useful.
Logged
Zydu
Jr. Member
**
Posts: 51


View Profile
« Reply #1 on: December 13, 2011, 07:21:37 AM »

Bump.

Is there still hope for this addon or should I look for good sqlite editor?
Logged
Ownz
Developer
Administrator
Hero Member
*****
Posts: 2032



View Profile WWW Email
« Reply #2 on: December 13, 2011, 11:30:30 AM »

why does the player want to lose levels?
Logged

DarkEnergy
alex0310
Full Member
***
Posts: 170



View Profile
« Reply #3 on: December 13, 2011, 11:40:03 AM »

player does not want. I think it wants admin)))
Logged
Vulpone
Full Member
***
Posts: 140



View Profile Email
« Reply #4 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.
Logged

Sapere aude!
Necavi
Full Member
***
Posts: 217


View Profile
« Reply #5 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>.
« Last Edit: December 13, 2011, 09:06:22 PM by Necavi » Logged

nvn
Full Member
***
Posts: 133


View Profile
« Reply #6 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);
« Last Edit: December 14, 2011, 07:01:47 AM by nvn » Logged

Pages: [1]
  Print  
 
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.11 | SMF © 2006-2009, Simple Machines LLC Valid XHTML 1.0! Valid CSS!