[Release]CLEAN database + MSSQL cleaning script

razooor · 02/16/2010, 11:33

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

҉ THT ҉ · 02/16/2010, 11:53

clean database ,, credits to zombe

Zombe · 02/16/2010, 17:41

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.

razooor · 02/16/2010, 19:41

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?

Zombe · 02/17/2010, 07:24

Welll... That means you have anti-gm-hack v1, and it auto-deletes those characters. Turn it off.

҉ THT ҉ · 02/17/2010, 17:08

I told him that some msg back but he didnt read it ?XD

razooor · 02/17/2010, 17:50

sorry if im ask... but...^^ how to turn off it?

҉ THT ҉ · 02/17/2010, 19:00

easyest way = go to that job push delete button

razooor · 02/17/2010, 20:07

Woot xD it works... Thank you Guyz for helping me

skeena · 03/08/2010, 01:49

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.

bellydaniel · 03/10/2010, 10:43

why don't realease script for deleting character other than the database that already we want to keep in database.

Zombe · 03/14/2010, 15:30

I added the DB as an attachment... Sucked when you had to wait 45 seconds every time when you wanted to download it... :/

~~ramirez666~~ · 10/22/2010, 21:07

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

gengkey02 · 06/12/2011, 21:40

Can any1 tell me how to use this?
do i need to load this into mssql query analyzer? and why is .BAK file.?

~~=Warmonger=~~ · 06/13/2011, 00:10

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.