char create sql ~

Quote:

Originally Posted by [DEV]Pwner sry but i i need a sql query ? so what is it no i dont want that , i want to add that easy and remove it when i need . so it's not permanent

all you have to do is clear the contents of the default characters with a simple query

delete from character.dbo.user_bag, character.dbo.user_suit where character_no like 'DEKARON%'

and then they will start off with nothing again, u can make an account only u know the info too, place all the 'DEKARON' dev characters on that account by finding ur account number in account.dbo.user_profile and then searching for the dev characters and put ur user_no on all those characters, log into them and place what u want on them, when u wanna clear it, just run the above query, and start over, or log on to the account and change the items u want to be changed, how much simpler can it get then that?

Quote:

Originally Posted by Decima all you have to do is clear the contents of the default characters with a simple query delete from character.dbo.user_bag, character.dbo.user_suit where character_no like 'DEKARON%' and then they will start off with nothing again, u can make an account only u know the info too, place all the 'DEKARON' dev characters on that account by finding ur account number in account.dbo.user_profile and then searching for the dev characters and put ur user_no on all those characters, log into them and place what u want on them, when u wanna clear it, just run the above query, and start over, or log on to the account and change the items u want to be changed, how much simpler can it get then that?

i got it ... and worked good , and i requested close this thread
thx btw :p