:facepalm: you truly are something else. No...this is not his best bet...The most simple one is his best bet.Quote:
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.
Will only return the name he's already got, Thus.Code:Select * From [USER_CHARACTER] Where character_name = 'Warmonger'
Will be his best bet.Code:Use character; Go Update [user_character] Set character_name= '[DEV]NAME' Where character_name= 'NAME'
Dn items
06/30/2011 01:25
Joker¨#16
06/30/2011 03:18
[DEV]Pro#17
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.
06/30/2011 03:19
Naruto™#18
nice ^^
06/30/2011 07:52
BlackLixt#19
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
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
06/30/2011 08:30
=Warmonger=#20
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 [Only registered and activated users can see links. Click Here To Register...], then he would know how to execute querys.Quote:
Quote:
- 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