|
You last visited: Today at 00:53
Advertisement
[Release]CLEAN database + MSSQL cleaning script
Discussion on [Release]CLEAN database + MSSQL cleaning script within the Dekaron Private Server forum part of the Dekaron category.
02/16/2010, 11:33
|
#16
|
elite*gold: 0 
Join Date: Oct 2007
Posts: 17
Received Thanks: 1
|
on 1click server there are no Mastercodes like 'DEKARON_000001' so this script will delet the DEV Chars to, because they got no character_no like 'DEKARON_000001'.
please help me
|
|
|
|
02/16/2010, 11:53
|
#17
|
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
|
clean database ,, credits to zombe
|
|
|
|
|
02/16/2010, 17:41
|
#18
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,451
Received Thanks: 840
|
Quote:
Originally Posted by razooor
on 1click server there are no Mastercodes like 'DEKARON_000001' so this script will delet the DEV Chars to, because they got no character_no like 'DEKARON_000001'.
please help me
|
The name of the chars doesn't matter, what matters is their character_no, if the database doesn't have characters with character_no like DEKARON_000001, then that database won't work. For createing a character at least.
|
|
|
|
|
02/16/2010, 19:41
|
#19
|
elite*gold: 0
Join Date: Oct 2007
Posts: 17
Received Thanks: 1
|
I assure you there is no Character with character_no like DEKARON_000001.
and if i restore the postet link with clean database there is NO Character in there at user_character... so it doesen't works too T_T
Whats my mistake?
do i have to do anything else?
can anyone tell me how to restore the clean database step by step?
|
|
|
|
|
02/17/2010, 07:24
|
#20
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,451
Received Thanks: 840
|
Welll... That means you have anti-gm-hack v1, and it auto-deletes those characters. Turn it off.
|
|
|
|
|
02/17/2010, 17:08
|
#21
|
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
|
I told him that some msg back but he didnt read it ?XD
|
|
|
|
|
02/17/2010, 17:50
|
#22
|
elite*gold: 0
Join Date: Oct 2007
Posts: 17
Received Thanks: 1
|
sorry if im ask... but...^^ how to turn off it?
|
|
|
|
|
02/17/2010, 19:00
|
#23
|
elite*gold: 0
Join Date: Jul 2009
Posts: 912
Received Thanks: 250
|
easyest way = go to that job push delete button 
|
|
|
|
|
02/17/2010, 20:07
|
#24
|
elite*gold: 0
Join Date: Oct 2007
Posts: 17
Received Thanks: 1
|
Woot xD it works... Thank you Guyz for helping me
|
|
|
|
|
03/08/2010, 01:49
|
#25
|
elite*gold: 0
Join Date: May 2009
Posts: 30
Received Thanks: 0
|
What do I need to do so it doesn't delete a few of my characters?(or all [GM]s and [DEV]s)
sorry if the answer is posted somewhere else D:
Thank you.
|
|
|
|
|
03/10/2010, 10:43
|
#26
|
elite*gold: 0
Join Date: Mar 2008
Posts: 138
Received Thanks: 26
|
why don't realease script for deleting character other than the database that already we want to keep in database.
|
|
|
|
|
03/14/2010, 15:30
|
#27
|
elite*gold: 20
Join Date: Dec 2007
Posts: 1,451
Received Thanks: 840
|
I added the DB as an attachment... Sucked when you had to wait 45 seconds every time when you wanted to download it... :/
|
|
|
|
|
10/22/2010, 21:07
|
#28
|
elite*gold: 0
Join Date: Oct 2010
Posts: 20
Received Thanks: 1
|
can some on reupleade this download link dont work
kk sorry was clicking on wrong link i downloadt it... but can some one tell me were i need too put this stuff in im useing 1 click server
|
|
|
|
|
06/12/2011, 21:40
|
#29
|
elite*gold: 0
Join Date: Sep 2007
Posts: 432
Received Thanks: 66
|
Can any1 tell me how to use this?
do i need to load this into mssql query analyzer? and why is .BAK file.?
|
|
|
|
|
06/13/2011, 00:10
|
#30
|
elite*gold: 0
Join Date: May 2008
Posts: 509
Received Thanks: 1,246
|
Quote:
Originally Posted by gengkey02
Can any1 tell me how to use this?
do i need to load this into mssql query analyzer? and why is .BAK file.?
|
Copy and paste the query into MSSQL query analyzer and hit F5. Or alternatively you can restore the database backups which already have the query executed upon them.
|
|
|
|
 |
|
Similar Threads
|
[Release] PSC Database Script
02/27/2010 - Metin2 PServer Guides & Strategies - 56 Replies
Hallo,
ich hatte langeweile und hab euch mal ein Paysafecard-Script geschrieben, das die Accountid und die Paysafecard-Nummer in der Database speichert ;)
Es ist nichts besonderes aber könnte anderen helfen.
Anleitung:
Die config.php in dem Ordner 'inc' anpassen.
Die install.php im Ordner 'install' über xampp/webspace oder sonstiges ausführen (Xampp: http://localhost/install/install.php)
Danach könnt ihr das Script benutzen ;)
MFG
P.S. Datei im Anhang!
|
Clean/Empty Private Server Database Files
08/16/2009 - Dekaron Private Server - 20 Replies
I have taken the database files for the private server and cleaned them up.
The new packed and rar'd file is 1.1mb.
I used 'TRUNCATE TABLE <table name>' for most of the tables and 'DELETE FROM <table name>' for anything else that would truncate.
Use these files in the same way you would the other database backups.
Enjoy.
(Thanks if you use it please!!)
|
[Urgent] Need help to clean user_character Database
08/16/2009 - Dekaron Private Server - 12 Replies
sup guys?! i've got one database that was already in use. so there is there lots and lots of characters created and i want to delete them all.
but if i try to delete it with the query analyser with the DELETE command i have some ongame problems.
when i got my table cleared and run the server, when someone try to create a new char appears one error screen, and if he tries to recreate it it says that the name its already on use.
so what really happens:
1 - i do have one clear user_character...
|
Bugless DataBase clean!!
06/15/2009 - EO PServer Hosting - 31 Replies
Hey from me too..I wanna share with u a db that it is mostly translated and bugless...and has a lot of great systems such as:auto-ep,stack ep,manequinn..etc..
Below i give u the ini files that support this db ....also it has new weapons...
Database
Ini Files
The rest files
I hope u will enjoy it...and if u experience any problem with the icons i will give ya the dds files too....just leave a msg here..;)
Update:After a lot of incovinience credits go to:Necron33,Spy520 and rexes13...
|
Clean Database
12/25/2008 - Dekaron Private Server - 3 Replies
Any1 Give Clean and Working Database ?
|
All times are GMT +1. The time now is 00:53.
|
|
![[Release]CLEAN database + MSSQL cleaning script](https://www.elitepvpers.com/forum/iconimages/dekaron-private-server/release-clean-database-mssql-cleaning-script_ltr.gif){kind=small}
