Register for your free account! | Forgot your password?

Go Back   elitepvpers › MMORPGs › Last Chaos › Last Chaos Private Server
[Alpha Version]Show Tool [Alpha Version]Show Tool
You last visited: Today at 18:35

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement


Advertise with us!

[Alpha Version]Show Tool

Discussion on [Alpha Version]Show Tool within the Last Chaos Private Server forum part of the Last Chaos category.

Closed Thread
 
Old   #1
 
elite*gold: 30
The Black Market: 1/0/0
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 :
AlienTime is offline  
Thanks
3 Users
Old   #2
 
elite*gold: 241
The Black Market: 37/0/0
Join Date: Dec 2011
Posts: 1,803
Received Thanks: 1,301
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




Beispiel : db : newproject_db user : root pw : (enter)
Eingabe :

Ausgabe :
Top!
Vielen Dank für dieses Release.
€clips3 is offline  
Old   #3

 
Tarissuis's Avatar
 
elite*gold: 2470
The Black Market: 35/0/1
Join Date: Jul 2010
Posts: 7,524
Received Thanks: 5,446
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.
Tarissuis is offline  
Old   #4
 
elite*gold: 30
The Black Market: 1/0/0
Join Date: Oct 2012
Posts: 40
Received Thanks: 30
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
AlienTime is offline  
Old   #5

 
Tarissuis's Avatar
 
elite*gold: 2470
The Black Market: 35/0/1
Join Date: Jul 2010
Posts: 7,524
Received Thanks: 5,446
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

***, so ist es, habe das ganze inzwischen editiert. Habe nicht ordentlich genug gelesen und dachte, dein Programm löscht das Gold nur, mein Fehler!
Tarissuis is offline  
Old   #6
 
elite*gold: 30
The Black Market: 1/0/0
Join Date: Oct 2012
Posts: 40
Received Thanks: 30
Quote:
Originally Posted by Tarissuis View Post
***, 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
AlienTime is offline  
Old   #7


 
Yannikin's Avatar
 
elite*gold: 17
The Black Market: 57/0/0
Join Date: Jan 2010
Posts: 6,067
Received Thanks: 4,733
#closed as requested
Yannikin is offline  
Closed Thread

« LC Files WoD connector funzt nich | Brauche dringend Hilfe »

Similar Threads 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 +2. The time now is 18:36.

elitepvpers - play less, get more - Top

Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.