|
You last visited: Today at 01:12
Advertisement
[Alpha Version]Show Tool
Discussion on [Alpha Version]Show Tool within the Last Chaos Private Server forum part of the Last Chaos category.
10/06/2012, 20:24
|
#1
|
elite*gold: 30 
Join Date: Oct 2012
Posts: 40
Received Thanks: 30
|
[Alpha Version]Show Tool
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 :
Ausgabe :
|
|
|
|
10/06/2012, 20:51
|
#2
|
elite*gold: 241
Join Date: Dec 2011
Posts: 1,803
Received Thanks: 1,301
|
Quote:
Originally Posted by AlienTime
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
Beispiel : db : newproject_db user : root pw : (enter)
Eingabe :
Ausgabe :
|
Top!
Vielen Dank für dieses Release.
|
|
|
|
|
10/06/2012, 21:11
|
#3
|
elite*gold: 2470
Join Date: Jul 2010
Posts: 7,524
Received Thanks: 5,444
|
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
|
#4
|
elite*gold: 30
Join Date: Oct 2012
Posts: 40
Received Thanks: 30
|
Quote:
Originally Posted by Tarissuis
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
|
#5
|
elite*gold: 2470
Join Date: Jul 2010
Posts: 7,524
Received Thanks: 5,444
|
Quote:
Originally Posted by AlienTime
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 |
***, 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
|
#6
|
elite*gold: 30
Join Date: Oct 2012
Posts: 40
Received Thanks: 30
|
Quote:
Originally Posted by Tarissuis
***, 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
|
#7
|
elite*gold: 17
Join Date: Jan 2010
Posts: 6,067
Received Thanks: 4,733
|
#closed as requested
|
|
|
|
 |
Similar Threads
|
[FREE TOOL] DarkOrbit Multi-Tool (Alpha)
12/19/2012 - DarkOrbit - 9 Replies
I started now with a new, nice but small "project".
I will make a Tool and try to put the most important things.
Current Functions
- Ammo Mixer
- Auto-Rocket (=> + 1 Free CPU Slot)
- Auto-Repairbot (=> + 1 Free CPU Slot)
(- Auto-Rocket-Lunsher; need to configure correct, then I will make it availible)
- Many, many, many function will be added in future!
|
*Pumio* Source|NoMenuCode Tool {Alpha Version}
08/21/2011 - WarRock Hacks, Bots, Cheats & Exploits - 15 Replies
Hey Leute,
Ich möchte euch heute mein Tool vorstellen dieses Tool ist noch in der Alpha Version,
Ich will gucken wie es bei euch ankommt Wens schlecht ankommt werde ich das Thema schliesen.
Wens Gut ankommt werde ich das Tool noch weiter erweitern(Merh Sourcen ... )
Bitte Style nicht bewerten , ist ja eine Alpha Version ! STyle wird sich in Beta endern
Ich suche auch noch helfer also wer Interesse hat PmSchicken
Was kan dieses Tool ?
Du kannst dir Sourcen raussuchen. Alpha Version
Da...
|
Need Tool that show DB/Mets on Ground
11/22/2007 - Conquer Online 2 - 2 Replies
Hi all,
if I hunt in BI or AC I found a lot of Mets and DBS but sometimes I dont realize that. Is there a tool that shows mets and dbs on ground maybe with arrows or that pick ups Mets and DBS automatically??
mfg
|
All times are GMT +1. The time now is 01:13.
|
|
![[Alpha Version]Show Tool](https://www.elitepvpers.com/forum/iconimages/last-chaos-private-server/alpha-version-show-tool_ltr.gif){kind=small}
