[Alpha Version]Show Tool

10/06/2012 20:24 AlienTime#1
Dieses Tool überprüft Character.
Es Überprüft alle Chars die über 100kkk gold besitze.


ich würde dieses tool weiter entwicklen sprich alle t_inven und alle tables sowie andere tools falls erwünscht.

Voraussetzung: Java JRE 7 Starten mit der beigelegten .bat

Code:
[ALPHA]
v 1.1 
Only t_inven00 and table 0
[URL="http://uploaded.net/file/w09h3ns2"] Download [/URL]

v 1.2
t_inven00 - 09 and table 0 
[URL="http://uploaded.net/file/ps658mt2"] Download [/URL]


Beispiel : db : newproject_db user : root pw : (enter)
Eingabe :
[Only registered and activated users can see links. Click Here To Register...]
Ausgabe :
[Only registered and activated users can see links. Click Here To Register...]
10/06/2012 20:51 €clips3#2
Quote:
Originally Posted by AlienTime View Post
Dieses Tool überprüft Character.

In der alpha Version die ich hier anbiete überprüft es alle Chars die über 100 kkk gold besitzen so ist es leicht festzustellen ob die gm leute pushen.
Die alpha bietet nur t_inven00 jeweils die 0 table.

ich würde dieses tool weiter entwicklen sprich alle t_inven und alle tables sowie andere tools falls erwünscht.


Voraussetzung: Java JRE 7 Starten mit der beigelegten .bat

[Only registered and activated users can see links. Click Here To Register...]


Beispiel : db : newproject_db user : root pw : (enter)
Eingabe :
[Only registered and activated users can see links. Click Here To Register...]
Ausgabe :
[Only registered and activated users can see links. Click Here To Register...]
Top!
Vielen Dank für dieses Release.
10/06/2012 21:11 Tarissuis#3
Und mit dieser Query könnt ihr automatisch alles Gold über einem bestimmten Betrag löschen:
Code:
UPDATE `t_inven00` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven00` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven00` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven00` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven00` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven01` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven01` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven01` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven01` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven01` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven02` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven02` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven02` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven02` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven02` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven03` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven03` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven03` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven03` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven03` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven04` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven04` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven04` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven04` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven04` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven05` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven05` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven05` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven05` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven05` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven06` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven06` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven06` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven06` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven06` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven07` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven07` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven07` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven07` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven07` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven08` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven08` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven08` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven08` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven08` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven09` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven09` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven09` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven09` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven09` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19')

Viele Grüße
Tarissuis


PS: Ich bin mir sicher, das geht noch viel einfacher, aber ich bin Neuling was Datenbankarbeit angeht, aber dieses Script macht dafür nur genau das, was es soll :)

PPS: a_count ist die Anzahl des Goldes, das übrig bleiben soll, ihr könnt das ganze gerne auch auf 1kkk setzen oder ähnliches.
10/06/2012 21:15 AlienTime#4
Quote:
Originally Posted by Tarissuis View Post
Und mit dieser Query könnt ihr automatisch alles Gold über einem bestimmten Betrag löschen:
Code:
UPDATE `t_inven00` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven00` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven00` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven00` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven00` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven01` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven01` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven01` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven01` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven01` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven02` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven02` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven02` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven02` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven02` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven03` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven03` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven03` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven03` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven03` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven04` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven04` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven04` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven04` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven04` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven05` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven05` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven05` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven05` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven05` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven06` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven06` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven06` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven06` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven06` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven07` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven07` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven07` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven07` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven07` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven08` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven08` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven08` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven08` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven08` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19');
UPDATE `t_inven09` SET `a_count0`='1' WHERE (`a_count0`>'10000000000') AND (`a_item_idx0`='19');
UPDATE `t_inven09` SET `a_count1`='1' WHERE (`a_count1`>'10000000000') AND (`a_item_idx1`='19');
UPDATE `t_inven09` SET `a_count2`='1' WHERE (`a_count2`>'10000000000') AND (`a_item_idx2`='19');
UPDATE `t_inven09` SET `a_count3`='1' WHERE (`a_count3`>'10000000000') AND (`a_item_idx3`='19');
UPDATE `t_inven09` SET `a_count4`='1' WHERE (`a_count4`>'10000000000') AND (`a_item_idx4`='19')

Viele Grüße
Tarissuis


PS: Ich bin mir sicher, das geht noch viel einfacher, aber ich bin Neuling was Datenbankarbeit angeht, aber dieses Script macht dafür nur genau das, was es soll :)

PPS: a_count ist die Anzahl des Goldes, das übrig bleiben soll, ihr könnt das ganze gerne auch auf 1kkk setzen oder ähnliches.

Dein befehl updated es also sprich löscht es direkt raus und man kriegt keine informationen wer es war bzw. so kann man auch nicht raus filtern welche ip es war und programme bieten die einfache handhabung für leute die überhaupt keine ahnung von mysql haben und es ist bequemer ;)
10/06/2012 21:18 Tarissuis#5
Quote:
Originally Posted by AlienTime View Post
Dein befehl updated es also sprich löscht es direkt raus und man kriegt keine informationen wer es war bzw. so kann man auch nicht raus filtern welche ip es war und programme bieten die einfache handhabung für leute die überhaupt keine ahnung von mysql haben und es ist bequemer ;)

Jap, so ist es, habe das ganze inzwischen editiert. Habe nicht ordentlich genug gelesen und dachte, dein Programm löscht das Gold nur, mein Fehler!
10/06/2012 21:20 AlienTime#6
Quote:
Originally Posted by Tarissuis View Post
Jap, so ist es, habe das ganze inzwischen editiert. Habe nicht ordentlich genug gelesen und dachte, dein Programm löscht das Gold nur, mein Fehler!
kein Problem :)


v1.2 updated
10/07/2012 09:56 Yannikin#7
#closed as requested