[Urgent] Need help to clean user_character Database

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 database
2 - i cant create new chars at Dekaron Game
3 - the chars that ppl try to create r registered at my database.
i dont understand very well what its happening.

how can i delete all chars without having this troubles?
i hope someone here can help me..
tks

lol


deleted [DEV] chars

Quote:

Originally Posted by fackstix lol deleted [DEV] chars

where do I find this [DEV] Char and how to delete it? please help me

FAIL ! restore DB

Quote:

Originally Posted by janvier123 FAIL ! restore DB

please janvier123 all the places there I used the command to delete the acc but in time I at the game and will create the char of the error then I try to create the same char back says that the name of User already exists which Faser I need help me delete the chars and Guild so you can run the top player and top guild on the internet page of the command that I'm using the query analyzed and:

SELECT *
FROM user_character
DELETE user_character;

Read what fack said above. You can not delete the [DEV] characters that are in the db.

Quote:

Originally Posted by caper Read what fack said above. You can not delete the [DEV] characters that are in the db.

can i replace it for a new one?

There is only one of each class. Leave them there and don't touch them.

there are mastercodes for the classes, DO NOT DELETE THEM !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

Restore your DB and delete then EXCEPT THE MASTERCODES !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!!
there are more tables with mastercodes DO NOT DELETE THEM !!!!!!

Like:
skills, guild, and some others
again DO NOT DELETE THEM !!!!!!

Quote:

Originally Posted by janvier123 there are mastercodes for the classes, DO NOT DELETE THEM !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! Restore your DB and delete then EXCEPT THE MASTERCODES !!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! !!!!!!!!!!!!!!! there are more tables with mastercodes DO NOT DELETE THEM !!!!!! Like: skills, guild, and some others again DO NOT DELETE THEM !!!!!!

ok, now LISTEN, i DONT WANT to delete them, i already knew that there is master codes in there. what i want to do is to clear the ALREADY CREATED chars on that DB, thats what i want to know, if is there a way to delete this chars WITHOUT deleting those mastercodes.
IS THERE?!

do u know if there is a DB character with NOTHING IN IT?
totaly clear?

if i cant delete it, if im going to make one TOP PK, TOP LVL, TOP PVP on a website, how am i going to do it without those chars that already r registered get to appear?
i dont want them to get into the REAL list of chars from my server.
is there a way to?

Yeah. Delete every entry in user_character and just paste the rows with DEV chars then.

how? im already confused..
im already trying to create a new table for replace it... if there is a faster and better way can u explain it to me?
how i do it on the SQL and Query Analizer?

pls.. i really need this

delete one by one