Dn items

[Joker¨]

Originally Posted by Warmonger1337

Truly if you don't understand a query, then you shouldn't be messing with these files, as 100's of querys are executed every minute. I have only looked through the files for 1 day about a year ago.

Select * From [USER_CHARACTER] Where character_name = 'Warmonger'

Will only return the name he's already got, Thus.

Use character;
Go
Update [user_character] Set character_name= '[DEV]NAME' Where character_name= 'NAME'

Will be his best bet.

you truly are something else. No...this is not his best bet...The most simple one is his best bet.

[[DEV]Pro]

Well, in-case you have a-lot of characters in your database for whatever reason that might be, (which I highly doubt) you could always go to user_character right click, click "Query" and click the character name box. Put the character name in the "criteria" section, and execute it.

[Naruto™]

nice ^^

[BlackLixt]

ok i will write this again

also how to make yourself a GM/DEV/DEKARON well that's super easy:

open enterprise manager
go to db account , tables chose from tables Tbl_user right click this table and chose 3-rd option that should say "return all rows"

find your account copy user_no then close account db and open char DB go to tables as well then chose table user_character right click on it chose 3-rd option as to account after that u will see some butons up there chose the 3-rd that should say Show/Hide Grid Pane after that chose the second Column and put in the first panel user_no after that paste your user_no from account to criteria then hit the 7-th option that should say run after that u will se your char/char's just put [GM] [DEV] [DEKARON] in front of the char u want to be GM DEV OR DEKARON

[=Warmonger=]

Originally Posted by Joker¨

you truly are something else. No...this is not his best bet...The most simple one is his best bet.

This is the most simple way of doing it. Replace NAME with your characters name, hit F5. Simple done in under 10 seconds. Unless you want to scroll through 1000's of results. If the original poster bothered to read my , then he would know how to execute querys.

Originally Posted by Warmonger

• 1. Open Enterprise Manager (Start -> Programs -> Microsoft SQL Server -> Enterprise Manager)
• 2. Go To Tools -> SQL Query Analyzer (Login With Your "sa" Password)
• 3. Fill In Your Information And Execute It