[Official Feature] Perfect Fixed Character Name Service! iSRO Style!

[Wismo]

read what i said, you need to restart the svr for training camps!

Ouch, sorry. Thank you, Gr8 work!

[paltalkadel]

Jangan FTW :P

[epvp2]

can you make video because i don't understand any thing :-)

[paltalkadel]

awwww jangan i like u too ;) Mmmm :p dont think its so gay LOOOL just kidding
keep up bro u are the best ^_^ No Challenge

[megaman963]

Hey Jangan,

I want to know, what does last step do exactly?

    if (CHARINDEX('@', @old_name, 0) > 0)
    begin
        select * from _Char
        where CharID = ''
    end
    commit transaction
return 1 

[Jangan]

technically you dont need the last part.
i just removed the function where it cancels the query xD

i will probably improve this one day... but for now, its not really that big of a deal.

[tamer153]

thanks !

[sonsuzaxx]

Help me quvery error :
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 9
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 25
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 27
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 36
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 37
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 40
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 41
Must declare the scalar variable "@charid".
Msg 137, Level 15, State 2, Procedure _RenameCharNameByID, Line 43
Must declare the scalar variable "@charid".

[nimeni123]

amazing man

[collerok]

UPDATE _Char
         Set Charname = '@YOURNAME'
      WHERE Charname = 'YOURNAME' 

I cant get, what this query for it there is no such row in _char table.
May some1 explain me.

[sladlejrhfpq]

UPDATE _Char
         Set Charname = '@YOURNAME'
      WHERE Charname = 'YOURNAME' 

I cant get, what this query for it there is no such row in _char table.
May some1 explain me.

its very complicated:

UPDATE _Char
         Set Charname16 = '@YOURNAME'
      WHERE Charname16 = 'YOURNAME'

[nzamkdh]

textuisystem.txt (Already English)

//통합 UI관련 스트링 (2005-11-25)							0	0							
1	UIIT_PAG_UNITY_SERVER_ID_CHANGE	이름변경창	0	0	0	0	0	Name Change	Name Change	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_ID_CHANGE_EXPLANATION	통합 서버의 정책에 따라 캐릭터의 아이디를 변경해야 합니다.	0	0	0	0	0	Due to reports from the server you are required to change the name of your character in accordance with the User Agreement.	Your name has been blacklisted please change the new name.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_ID	기존 아이디	0	0	0	0	0	Current ID	Current ID	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_ID	변경 아이디	0	0	0	0	0	New ID	New ID	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OVERLAP_CONFIRM	중복확인	0	0	0	0	0	Check	Check	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_INPUT	입력	0	0	0	0	0	Input	Input	0	0	0	0	0	0

Due to reports from the server you are required to change the name of your character in accordance with the User Agreement.* (long text)

i change to : Your name has been blacklisted please change the new name.*


Thanks Jangan and ragezone... you all the best...

[safty0202]

after done !

UPDATE _Char
Set Charname16 = '@YOURNAME'
WHERE Charname16 = 'YOURNAME'

i got

(0 row(s) affected)

[nzamkdh]

huh... put you name character..

example :

UPDATE _Char
Set Charname16 = '@SeperBow'
WHERE Charname16 = 'SeperBow'

[collerok]

its very complicated:

UPDATE _Char
         Set Charname16 = '@YOURNAME'
      WHERE Charname16 = 'YOURNAME'

I understand that i had to change 'username' to 'username16', but i wasn't understand what this query used for, now i've got it.
If char names has its @ symbol at beginning then game force user to change his name.

Btw there was scroll in game to change user's name/guild maybe they can be fixed, using this sql code...