Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Shaiya > Shaiya Private Server
You last visited: Today at 12:11

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[How To]Char Name Special Character's Add ?

Discussion on [How To]Char Name Special Character's Add ? within the Shaiya Private Server forum part of the Shaiya category.

Reply
 
Old   #1
 
[GM]Nvia's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 156
Received Thanks: 592
[How To]Char Name Special Character's Add ?

Hello Everyone,

Special Characters Character name in SQL Anywhere Just how managers can be made?


Example : [GS]***-[(^_~)]
[GM]Nvia is offline  
Thanks
7 Users
Old 01/29/2013, 12:20   #2
 
TeddyBear94's Avatar
 
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,625
Code:
UPDATE PS_GameData.dbo.Chars
SET CharName= 'NewNameGoesHere'
WHERE CharName= 'OldNameGoesHere'
TeddyBear94 is offline  
Thanks
11 Users
Old 01/29/2013, 21:10   #3
 
[GM]Nvia's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 156
Received Thanks: 592
Not Work in Game. Only Changes Pvp Rank...
[GM]Nvia is offline  
Thanks
6 Users
Old 01/29/2013, 22:56   #4
 
Dreameh's Avatar
 
elite*gold: 360
Join Date: Jul 2012
Posts: 143
Received Thanks: 228
You have to execute the script that teddy posted and relog if you on the account.
Dreameh is offline  
Thanks
3 Users
Old 01/30/2013, 14:54   #5
 
[GM]Nvia's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 156
Received Thanks: 592
Daemah you understand me ? in my opinion dont understand " DONT WORK " Special Character's . ??GM??? < Special Character Changed. .....
[GM]Nvia is offline  
Thanks
6 Users
Old 01/30/2013, 15:40   #6
 
TeddyBear94's Avatar
 
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,625
open sql
open a new quiery
copy paste this in
Code:
UPDATE PS_GameData.dbo.Chars
SET CharName= '[GS]***-[(^_~)]'
WHERE CharName= 'Nvia'
run that quiery
logg in ur account ( if u was already online logg out and logg again in)
and ur name is changed.
TeddyBear94 is offline  
Thanks
2 Users
Old 01/30/2013, 16:41   #7
 
[GM]Nvia's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 156
Received Thanks: 592
Picture 1 :
Picture 2 :

u Understand ?

It's Work on : [GS]***-[(^_~)] but Don't Work my want name ... (tm,<<,>> etc... )
[GM]Nvia is offline  
Thanks
6 Users
Old 01/30/2013, 21:17   #8
 
TeddyBear94's Avatar
 
elite*gold: 10
Join Date: May 2012
Posts: 1,857
Received Thanks: 2,625
cause these aren't supported from sql.
TeddyBear94 is offline  
Thanks
2 Users
Old 01/31/2013, 09:18   #9
 
[GM]Nvia's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 156
Received Thanks: 592
How can we support in SQL? and to see a Game?
[GM]Nvia is offline  
Thanks
6 Users
Old 01/31/2013, 21:52   #10
 
Philipp_'s Avatar
 
elite*gold: 576
Join Date: Mar 2011
Posts: 348
Received Thanks: 994
You would have to change the data type of the CharName column since VARCHAR does not allow you to store unicode characters.
Philipp_ is offline  
Thanks
10 Users
Old 02/01/2013, 10:08   #11
 
[GM]Nvia's Avatar
 
elite*gold: 0
Join Date: Dec 2012
Posts: 156
Received Thanks: 592
thank you for relpy. But What data type should be?

I really grateful to you that you solve my problem ... stay
[GM]Nvia is offline  
Thanks
4 Users
Old 08/21/2013, 20:31   #12
 
elite*gold: 0
Join Date: Jul 2013
Posts: 17
Received Thanks: 43
Design Ps_gamedata dbo chars
change Charname From Varchar to Nvarchar
make sure your client font support unicode (game.exe)
and here you are:
littleJon is offline  
Thanks
1 User
Old 08/22/2013, 01:50   #13
 
[ADM]SpyRow's Avatar
 
elite*gold: 0
Join Date: Jun 2013
Posts: 465
Received Thanks: 668
Quote:
Originally Posted by [GM]Nvia View Post
How can we support in SQL? and to see a Game?
you simply can't

< = lower
> = bigger

SQL use those 2 things as lang as code thats why

if you add > SQL things you want N>vi ( bigger then V )

but who knows maybe i'm wrong o.O
[ADM]SpyRow is offline  
Old 08/22/2013, 02:00   #14
 
nubness's Avatar
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,450


All you have to do is change the data type from varchar to nvarchar. Make sure it's written like this nvarchar(50). Change your names from the database again, and it will work. If it doesn't work, do you mind pasting here whatever name you're failing to see properly in game ?
nubness is offline  
Thanks
2 Users
Old 08/23/2013, 08:19   #15
 
nubness's Avatar
 
elite*gold: 10
Join Date: Jan 2012
Posts: 1,698
Received Thanks: 5,450
We aren't forgetting anything, the game.exe simply doesn't support your language. You can try Chinese letters too, they will show up as question marks. Try a Vietnamese game.exe, it will definitely work, at least at showing your name properly.
nubness is offline  
Thanks
3 Users
Reply


Similar Threads Similar Threads
[Request]make name with special character (*&^%$#@![])
08/07/2011 - Shaiya - 11 Replies
the title say all ^^ is it possible ?
How to make character skin fo special force? need help?
03/22/2011 - Soldier Front - 3 Replies
Can someone teach me how to make character skins on special force? what tools do i need to download to make an edited character skin. thanks in advance ^^
[HELP]Block special char when reg new character
01/30/2011 - Metin2 Private Server - 1 Replies
Hello, Do somebody know, how to block special sign when somebody creat new character. Czech has special char as ěščřžýá ... and I want block it, becouse in game it write some square. Thx
Special character name?
01/12/2011 - Dragonica - 6 Replies
Musodragonica How do people get special characters in their character names? ive seen some people with names with stars in it! and how do i make a name with chinese characters on a english keyboard? :confused: Please help me! Thanks! :D
Special Character [Accents]???
03/08/2006 - Ragnarok Online - 9 Replies
ich hab jetzt schon in vielen foren die sich unter anderem mit dem hexen der ragexe beschäftigen das hier gesehen : Special Character &#91;Accents&#93; Search&#58; 80 75 0C 40 Replace&#58; 80 90 90 40 weiß einer von euch wie man diese zeichen in ro benutzt? sehe auch oft genug partynamen mit so verrückten zeichen, nicht solche : Ð?®, sondern eher symbole wie männchen und ordner 0o. wollte mal einen pm'en der sie benutze, hat aber gesagt : 'i don't say that' und setzte mich auf die ignore liste xD



All times are GMT +1. The time now is 12:11.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.