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

Quote:

---

Originally Posted by Jangan

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

---

Ouch, sorry. Thank you, Gr8 work!

Jangan FTW :P

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

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

Hey Jangan,

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

PHP Code:

---

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


---

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.

thanks !

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".

amazing man

PHP Code:

---

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.

Quote:

---

Originally Posted by collerok

PHP Code:

---

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:

Code:

---

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

---

textuisystem.txt (Already English)

Code:

---

//통합 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... :thumbup1:

after done !

Quote:

---

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

---

i got

Quote:

---

(0 row(s) affected)

---

huh... put you name character..

example :

Code:

---

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

---

Quote:

---

Originally Posted by sladlejrhfpq

its very complicated:

Code:

---

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...