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

[Jangan]

Introduction:

• - This is actually an official iSRO Feature, where they force you to change your name before you login in-game if you have a racist or offensive name! This is a really cool feature! Please do not release this on shitpvpers, i dont want my work to be published on a retarded pathetic forum, Thank you for understanding!

Screen Shot:

Features:

• - Force Character NameChange On login
• - Changes Charname in char
• - Changes Charname in friendlist
• - Changes Charname in memo
• - Changes Charname in SMC/AllFields
• - Changes Charname in Guild
• - Changes Charname in Fortress
• - Changes Charname in Training Camps
• - These changes happen instantly, no server restart needed, you will login and your name will be changed in the guild etc etc, its 100% Real Time with the exception of Training camps, that require a server update/restart!

Still Missing:

• - Missing Media.pk2 Information in the Textui.txt, i will leave that to the media editors to finish it!!

How to Activate The Feature:

• Go to the database, and do this query
  

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

• Then execute this query to fix the stored procedures! and you are done!
  
  

  USE [SRO_VT_SHARD]
  GO
  /****** Fixed And Modified By Jangan ******/
  SET ANSI_NULLS ON
  GO
  SET QUOTED_IDENTIFIER ON
  GO
  
  -----------------------------------------------------------------------------------------------------
  
  ALTER procedure [dbo].[_RenameCharNameByID]
  @CharID        int,
  @NewName    varchar(64)
  as
      if (not exists (select charid from _char where charid = @charid))
          return -1
      set xact_abort on
  begin transaction
      if (exists (select charid from _charnamelist with (updlock) where charname16 = @NewName))
      begin
          rollback transaction
          return -3
      end
      declare @old_name varchar(64)
      select @old_name = charname16 from _char where charid = @charid
      update _char set charname16 = @NewName where charid = @charid
      if (@@error <> 0 or @@rowcount = 0)
      begin
          rollback transaction
          return -4        
      end
      insert _CharNameList values(@NewName, @charid)
      UPDATE _Char set CharName16 = @NewName where CharID = @CharID
      update _Friend set friendcharname = @NewName where friendcharid = @charid
      update _GuildMember set charname = @NewName where charid = @charid
      update _Memo set fromcharname = @NewName where fromcharname = @old_name
      update _TrainingCampMember set charname = @NewName where charid = @charid
      declare @cos_id int
      declare cos_cursor  cursor fast_forward for    
      select id
       from _charcos 
      where ownercharid = @CharID
      open cos_cursor 
      fetch next from cos_cursor  into @cos_id
      while( @@fetch_status = 0 )
      begin
          update _Items set CreaterName = @NewName 
          where ID64 in 
          (select ItemID from _InvCOS where COSID = @cos_id and ItemID > 0) 
          and CreaterName = @old_Name
          if (@@error <> 0 )
          begin
              close cos_cursor
              deallocate cos_cursor
              rollback transaction
              return -5
          end
          fetch next from cos_cursor  into @cos_id
      end
      close cos_cursor
      deallocate cos_cursor
      declare pc_inv_cursor cursor fast_forward for
      select it.Data                            
      from _Inventory as inv join _Items as it on inv.ItemID = it.ID64 
      where 
      (inv.CharID = @CharID and inv.Slot >= 13 and inv.ItemID > 0) and    
      (it.Data <> 0)  and                            
      (exists (select top 1 ID from _RefObjCommon where ID = it.RefItemID and TypeID1 = 3 and TypeID2 = 2))
      open pc_inv_cursor 
      fetch next from pc_inv_cursor  into @cos_id
      while( @@fetch_status = 0 )
      begin
          update _Items set CreaterName = @NewName 
          where ID64 in 
          (select ItemID from _InvCOS where COSID = @cos_id and ItemID > 0) 
          and CreaterName = @old_Name
          if (@@error <> 0 )
          begin
              close pc_inv_cursor
              deallocate pc_inv_cursor
              rollback transaction
              return -6
          end
          fetch next from pc_inv_cursor  into @cos_id
      end
      close pc_inv_cursor
      deallocate pc_inv_cursor
      if (CHARINDEX('@', @old_name, 0) > 0)
      begin
          select * from _Char
          where CharID = ''
      end
      commit transaction
  return 1 

Enjoy! Please thank,rep, and keep on developing guys! you are awesome :D

[MentaL]

[sladlejrhfpq]

o_O Very nice :) Thank you for sharing!

[Larkon]

See now i will say thank you , and nice release!

[asi]

new mediapk2 need ?

[sytexx]

Hy jangan can you Made This tool  to php so only the GMs can use it

[SL1MSH4DY]

Ahh I was wondering what happens to your original thread of this lol but nice work nonetheless!
Posted via Mobile Device

[3d2000]

Amazing :d

[kobimodel]

nice release !

[IMOS]

Nice job.

Paste over lines 1738-1766 in your textuisystem.txt in Media.pk2
Added my own translations.

//통합 UI관련 스트링 (2005-11-25)							0	0							
1	UIIT_PAG_UNITY_SERVER_ID_CHANGE	이름변경창	0	0	0	0	0	Name Change	Trang thay ®æi tªn	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.	Theo quy ®Þnh cña m¸y chñ tæng hîp, b¹n ph¶i thay ®æi ID cña nh©n vËt.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_ID	기존 아이디	0	0	0	0	0	Current ID	Tµi kho¶n cò	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_ID	변경 아이디	0	0	0	0	0	New ID	Tµi kho¶n míi	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OVERLAP_CONFIRM	중복확인	0	0	0	0	0	Check	X¸c nhËn trïng lÆp	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_INPUT	입력	0	0	0	0	0	Input	NhËp	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_DISAPPROVAL_ID	해당 아이디[%s]는 사용할 수 없습니다.	0	0	0	0	0	[%s] can not be used.	Tµi kho¶n nµy kh«ng thÓ sö dông	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_USE_ID	해당 아이디[%s]는 사용할 수 있는 아이디 입니다.	0	0	0	0	0	[%s] can be used.	Tµi kho¶n nµy lµ tµi kho¶n cã thÓ sö dông	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_AUTO_CHR_DELETE	0	0	0	0	0	0	0	Tr­êng hîp ®Õn ®ît kiÓm tra ®Þnh kú vµo ngµy 20 th¸ng 5 n¨m 2006 mµ vÉn ch­a tù xãa c¸c nh©n vËt nµy th× theo quy ®Þnh vÒ nhËp m¸y chñ chØ 3 nh©n vËt ®­îc gi÷ l¹i cßn tÊt c¶ c¸c nh©n vËt sÏ bÞ xãa.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OPEN_TOTAL_STORAGEROOM	통합창고를 연다.	0	0	0	0	0	0	Më kho cña m¸y chñ	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OPEN_ANYSERVER_STORAGEROOM	[%s]서버창고	0	0	0	0	0	0	Kho m¸y chñ nhËp	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_TOTAL_STORAGEROOM	통합서버 창고	0	0	0	0	0	0	Më kho cña m¸y chñ	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_ANYSERVER_STORAGEROOM	[%s]서버의 창고를 연다.	0	0	0	0	0	0	Thêi gian b¶o qu¶n cßn phót giê ngµy	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_STORAGEROOM_REMAIN_TIME	2009년 3월 25일 물품삭제	0	0	0	0	0	0	Thay ®æi tªn héi	0	0	0	0	0	0	
1	UIIT_PAG_UNITY_SERVER_GUILD_NAME_CHANGE	길드이름 변경	0	0	0	0	0	0	Theo quy ®Þnh cña m¸y chñ nhËp, b¹n ph¶i thay ®æi tªn cña héi.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_GUILD_NAME_CHANGE_EXPLANATION	통합 서버의 정책에 따라 길드의 이름을 변경해야 합니다.	0	0	0	0	0	0	Tªn héi cò	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_GUILD_NAME	기존 길드명	0	0	0	0	0	0	Tªn héi míi	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_GUILD_NAME	변경 길드명	0	0	0	0	0	0	Tªn héi cã thÓ dïng	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_USE_GUILD_NAME	해당 길드이름[%s]은 사용 가능합니다.	0	0	0	0	0	0	Tªn héi kh«ng thÓ dïng	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_DISAPPROVAL_GUILD_NAME	해당 길드이름[%s]은 사용할 수 없습니다.	0	0	0	0	0	0	Th«ng b¸o liªn quan ®Õn m¸y chñ nhËp	0	0	0	0	0	0	
1	UIIT_PAG_UNITY_SERVER_FALSE_NAME_CHANGE	가명 변경	0	0	0	0	0	Change Alias	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_FALSE_NAME_CHANGE_EXPLANATION	통합 서버의 정책에 따라 가명을 변경해야 합니다.	0	0	0	0	0	As per the integrated server policy, your alias must be changed.	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_FALSE_NAME	기존 가명	0	0	0	0	0	Old Alias	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_FALSE_NAME	변경 가명	0	0	0	0	0	New Alias	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_DISAPPROVAL_FALSE_NAME	해당 가명[%s]은 사용할 수 없습니다.	0	0	0	0	0	[%s] is unavailable.	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_USE_FALSE_NAME	해당 가명[%s]은 사용 가능합니다.	0	0	0	0	0	[%s] is available.	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_COMMON	통합서버 관련공지	0	0	0	0	0	0	Xin chµo. §©y lµ Con §­êng T¬ Lôa Online.\nT¹i Con §­êng T¬ Lôa Online, chóng t«i sÏ cho b¹n thêi gian ®Ó thay ®æi tªn nh©n vËt(1 lÇn) vµ chØnh ®èn l¹i kho do viÖc m¸y chñ ®Õn lóc kiÕm tra ®Þnh kú vµo mång 1 th¸ng 6 n¨m 2006(ch­a chÝnh x¸c).Nh÷ng nh©n vËt vµ kiÓm kª kho ch­a xö lý trong thêi gian trªn th× sÏ bÞ mÊt ®i theo quy ®Þnh m¸y chñ, nªn ®Ò nghÞ c¸c b¹n chó ý tr­íc thêi gian nµy h·y kiÓm kª, chØnh lý kho, thay ®æi tµi kho¶n.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_COMMON_CONTENT	<sml2>안녕하세요. 실크로드 온라인 입니다.<br><br>

[Jangan]

Nice job.

Paste over lines 1738-1766 in your textuisystem.txt in Media.pk2
Added my own translations.

//통합 UI관련 스트링 (2005-11-25)							0	0							
1	UIIT_PAG_UNITY_SERVER_ID_CHANGE	이름변경창	0	0	0	0	0	Name Change	Trang thay ®æi tªn	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.	Theo quy ®Þnh cña m¸y chñ tæng hîp, b¹n ph¶i thay ®æi ID cña nh©n vËt.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_ID	기존 아이디	0	0	0	0	0	Current ID	Tµi kho¶n cò	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_ID	변경 아이디	0	0	0	0	0	New ID	Tµi kho¶n míi	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OVERLAP_CONFIRM	중복확인	0	0	0	0	0	Check	X¸c nhËn trïng lÆp	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_INPUT	입력	0	0	0	0	0	Input	NhËp	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_DISAPPROVAL_ID	해당 아이디[%s]는 사용할 수 없습니다.	0	0	0	0	0	[%s] can not be used.	Tµi kho¶n nµy kh«ng thÓ sö dông	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_USE_ID	해당 아이디[%s]는 사용할 수 있는 아이디 입니다.	0	0	0	0	0	[%s] can be used.	Tµi kho¶n nµy lµ tµi kho¶n cã thÓ sö dông	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_AUTO_CHR_DELETE	0	0	0	0	0	0	0	Tr­êng hîp ®Õn ®ît kiÓm tra ®Þnh kú vµo ngµy 20 th¸ng 5 n¨m 2006 mµ vÉn ch­a tù xãa c¸c nh©n vËt nµy th× theo quy ®Þnh vÒ nhËp m¸y chñ chØ 3 nh©n vËt ®­îc gi÷ l¹i cßn tÊt c¶ c¸c nh©n vËt sÏ bÞ xãa.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OPEN_TOTAL_STORAGEROOM	통합창고를 연다.	0	0	0	0	0	0	Më kho cña m¸y chñ	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_OPEN_ANYSERVER_STORAGEROOM	[%s]서버창고	0	0	0	0	0	0	Kho m¸y chñ nhËp	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_TOTAL_STORAGEROOM	통합서버 창고	0	0	0	0	0	0	Më kho cña m¸y chñ	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_ANYSERVER_STORAGEROOM	[%s]서버의 창고를 연다.	0	0	0	0	0	0	Thêi gian b¶o qu¶n cßn phót giê ngµy	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_STORAGEROOM_REMAIN_TIME	2009년 3월 25일 물품삭제	0	0	0	0	0	0	Thay ®æi tªn héi	0	0	0	0	0	0	
1	UIIT_PAG_UNITY_SERVER_GUILD_NAME_CHANGE	길드이름 변경	0	0	0	0	0	0	Theo quy ®Þnh cña m¸y chñ nhËp, b¹n ph¶i thay ®æi tªn cña héi.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_GUILD_NAME_CHANGE_EXPLANATION	통합 서버의 정책에 따라 길드의 이름을 변경해야 합니다.	0	0	0	0	0	0	Tªn héi cò	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_GUILD_NAME	기존 길드명	0	0	0	0	0	0	Tªn héi míi	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_GUILD_NAME	변경 길드명	0	0	0	0	0	0	Tªn héi cã thÓ dïng	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_USE_GUILD_NAME	해당 길드이름[%s]은 사용 가능합니다.	0	0	0	0	0	0	Tªn héi kh«ng thÓ dïng	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_DISAPPROVAL_GUILD_NAME	해당 길드이름[%s]은 사용할 수 없습니다.	0	0	0	0	0	0	Th«ng b¸o liªn quan ®Õn m¸y chñ nhËp	0	0	0	0	0	0	
1	UIIT_PAG_UNITY_SERVER_FALSE_NAME_CHANGE	가명 변경	0	0	0	0	0	Change Alias	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_FALSE_NAME_CHANGE_EXPLANATION	통합 서버의 정책에 따라 가명을 변경해야 합니다.	0	0	0	0	0	As per the integrated server policy, your alias must be changed.	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_EXISTING_FALSE_NAME	기존 가명	0	0	0	0	0	Old Alias	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_CHANGE_FALSE_NAME	변경 가명	0	0	0	0	0	New Alias	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_DISAPPROVAL_FALSE_NAME	해당 가명[%s]은 사용할 수 없습니다.	0	0	0	0	0	[%s] is unavailable.	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_USE_FALSE_NAME	해당 가명[%s]은 사용 가능합니다.	0	0	0	0	0	[%s] is available.	0	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_COMMON	통합서버 관련공지	0	0	0	0	0	0	Xin chµo. §©y lµ Con §­êng T¬ Lôa Online.\nT¹i Con §­êng T¬ Lôa Online, chóng t«i sÏ cho b¹n thêi gian ®Ó thay ®æi tªn nh©n vËt(1 lÇn) vµ chØnh ®èn l¹i kho do viÖc m¸y chñ ®Õn lóc kiÕm tra ®Þnh kú vµo mång 1 th¸ng 6 n¨m 2006(ch­a chÝnh x¸c).Nh÷ng nh©n vËt vµ kiÓm kª kho ch­a xö lý trong thêi gian trªn th× sÏ bÞ mÊt ®i theo quy ®Þnh m¸y chñ, nªn ®Ò nghÞ c¸c b¹n chó ý tr­íc thêi gian nµy h·y kiÓm kª, chØnh lý kho, thay ®æi tµi kho¶n.	0	0	0	0	0	0	
1	UIIT_STT_UNITY_SERVER_COMMON_CONTENT	<sml2>안녕하세요. 실크로드 온라인 입니다.<br><br>

Much respect, i couldnt find this in the isro media, and forgot to try the korean media xD

+1

See now i will say thank you , and nice release!

-.-

Rofl... you are the definition of the worst leecher, you expect me to release things all the time, when i don't you insult me in all my threads, but when i do you thank me?

No thanks... don't need your thanks. I'd rather see you get lost from this community.

[Larkon]

Much respect, i couldnt find this in the isro media, and forgot to try the korean media xD

+1






-.-

Rofl... you are the definition of the worst leecher, you expect me to release things all the time, when i don't you insult me in all my threads, but when i do you thank me?

No thanks... don't need your thanks. I'd rather see you get lost from this community.

You might wanna get your facts a bit straight up Not leecher. I have helped lots of people here and worked with lots of people here. Posting here aint my main thing. Hence my post count. Second i dont use mostly nothing released here. Especially not using this one. I dont need it. But i do say thanks for a good find. Third i dont even have a silkroad server , not planning on doing one either. Got better things in life to do than worry about a video game for you to be saying im a leecher.

Fourth your going to be saying why am i here if i got better things to do in life. Easy , i used to play silkroad before. I enjoy seeing how the game development for this game has gone up. SO i check around to see how stuff are going for the game. Even if i have nothing to do with it.

Last thing , I sometimes help people b skype or msn or facebook when i have time. Since they know i have been working with Ms sql my entire life " real life job " they ask me for help.

Now last thread i simply stated that your going off on your own words. You complain on thread that people dont released stuff on a development community. Im sipply did it back to you when you did the same thing. Simple enough. Now, enjoy w.e your doing.

[darkhole1123]

thnax for sharing, epvper ppl are gonna be happy to have it there too
Kidding
i dont leech, ill post my OWN releases if I make one, but never steal others stuff

[Wismo]

Does not work for Training Camps

[Jangan]

Does not work for Training Camps

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

[Baracoda]

great work :)