Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Rappelz > Rappelz Private Server
You last visited: Today at 08:19

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

 

[RELEASE] Rappelz Databasecleaner

Closed Thread
 
Old   #1


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
[RELEASE] Rappelz Databasecleaner V 1.2

NCarbon left, Silent left, Smokey left, Raskim left... Finally Xij will left, too!

NULL



Xijezu is offline  
Thanks
8 Users
Old   #2
 
elite*gold: 0
Join Date: Jun 2011
Posts: 70
Received Thanks: 5
LOOK Great for a really good serve but not for me :P


kKiMiKo is offline  
Old   #3
 
elite*gold: 0
Join Date: Jun 2011
Posts: 304
Received Thanks: 177
I wanted to know what exactly this does since
Quote:
It deletes unusual Items and Buffs from Telecaster-Database.
while it may be accurate, isn't what I'd say descriptive, and you don't provide much else in terms of documenting.
In short, I don't like black boxes.
SilentBill is offline  
Old   #4


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
Quote:
DELETE FROM State WHERE enable = '0'
DELETE FROM item WHERE keeping_id='0' AND owner_id = '0' AND account_id = '0' AND auction_id = '0' AND summon_id = '0'
.
Just those 2 commands.
I just wrote this tool because it is annoying to write that delete from item command again all the time...


Xijezu is offline  
Thanks
1 User
Old   #5


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
#new release
Xijezu is offline  
Old   #6
 
elite*gold: 0
Join Date: Feb 2010
Posts: 203
Received Thanks: 112
Error
Attached Images
File Type: jpg Untitled.jpg (44.7 KB, 15 views)
kaderebak is offline  
Old   #7


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
Connectionerror to your database.

Check your Databasesettings.
Xijezu is offline  
Old   #8
 
elite*gold: 0
Join Date: Oct 2011
Posts: 251
Received Thanks: 4
nice work ^^
falkenman is offline  
Old   #9
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
Hm das große am Telecaster sind nicht die dbos sondern der Transaction-Log. Wie der abgeschnitten wird, weiss ich selbst noch nicht. Ich hab schon mehrere Foren durchwühlt, aber bis jetzt ist alles gescheitert. SQL läst mich den Log nicht abschneiden. Habe auch sehr aufwändige Querys gefunden, aber wie gesagt: ne stunde später, hatte das auch nichts geschafft
lawlywood is offline  
Old   #10


 
elite*gold: 30
Join Date: May 2011
Posts: 4,801
Received Thanks: 3,181
Joa, aber wenn du schon die Items und Buffs raushaust, ist das auch schon ein netter Unterschied.
Auf'm DF-Server haste pro stunde um die 10.000 Dumpitems.
Insgesamt haben wir grad 10mio einträge o.ô xD
Xijezu is offline  
Old   #11
 
elite*gold: 0
Join Date: Mar 2011
Posts: 448
Received Thanks: 54
ok. Joa die eigentliche größe der DBs ist bei uns "marginal". Schau mal in die datenbank eigenschaften von Telecaster. Bei uns ist da nämlich der Transaction log 200gb + groß. Nerven tuts halt, dass die Backups dadurch richtung 1gb gehen (so langsam aber sicher) und das runterziehen halt ne weile braucht.


lawlywood is offline  
Closed Thread



« Previous Thread | Next Thread »



All times are GMT +2. The time now is 08:19.


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

Support | Contact Us | FAQ | Advertising | Privacy Policy | Abuse
Copyright ©2017 elitepvpers All Rights Reserved.