Go Back   EQEmulator Home > EQEmulator Forums > Development > Development::Database/World Building

Development::Database/World Building World Building forum, dedicated to the EQEmu MySQL Database. Post partial/complete databases for spawns, items, etc.

Reply
 
Thread Tools Display Modes
  #31  
Old 11-07-2010, 12:23 PM
GeorgeS
Forum Guide
 
Join Date: Sep 2003
Location: California
Posts: 1,475
Default

I use Heidisql - free and does all I need it to do
http://www.heidisql.com/

GeorgeS
__________________
Your source for EQ database tools
Toolshop is open for business


http://www.georgestools.chrsschb.com//
Reply With Quote
  #32  
Old 07-26-2014, 07:05 PM
sklead's Avatar
sklead
Sarnak
 
Join Date: Jul 2005
Posts: 38
Default

I was going to post a new thread, but I figured I would ask here before posting a new thread. I was trying to spawn a new NPC and I wanted it to have a apostrophe in the name, like: L'Vaen Kestal. When I did the #spawn command he popped up just fine, and when I did the create command everything went well, but when I repopped the zone he didn't show up. I checked my DB and he was in there as L'Vaen Kestal, but he wouldn't show up. I even tried using ASCII code (39 for ') in the DB and he still wouldn't spawn. I have this problem with player names as well; when I try to rename a player with an apostrophe I can't do it. So my question is how do I do this? I've played on a few other servers where I've seen players and NPCs with names like this.
__________________
In my defens, God me defend
Reply With Quote
  #33  
Old 07-26-2014, 08:25 PM
Kingly_Krab
Administrator
 
Join Date: May 2013
Location: United States
Posts: 1,589
Default

Have you tried escaping the apostrophe using a \?
So like this:
Code:
#spawn L\'Vaen_Kestal
Code:
#npcedit name L\'Vaen_Kestal
Reply With Quote
  #34  
Old 07-26-2014, 10:33 PM
sklead's Avatar
sklead
Sarnak
 
Join Date: Jul 2005
Posts: 38
Default

I wasn't aware that you could do that lol, but yes it worked as far as allowing me to spawn the mob. However when you con mobs with names like that or fight them it cuts off everything after the apostrophe. So in this case the NPCs name is literally just "L" when conning or fighting. Another mob I had was Mora V'tali which shows up as "Mora V".
__________________
In my defens, God me defend
Reply With Quote
  #35  
Old 07-27-2014, 08:01 PM
Uleat's Avatar
Uleat
Developer
 
Join Date: Apr 2012
Location: North Carolina
Posts: 2,815
Default

If that's not acceptable, try using the accent mark ` (under tilde ~)

I know players could get that added to their names on live.


I don't know if the con issue is client- or server-related..but, 'fixing' it might cause problems with other server features..like scripting?
__________________
Uleat of Bertoxxulous

Compilin' Dirty
Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

   

All times are GMT -4. The time now is 10:23 AM.


 

Everquest is a registered trademark of Daybreak Game Company LLC.
EQEmulator is not associated or affiliated in any way with Daybreak Game Company LLC.
Except where otherwise noted, this site is licensed under a Creative Commons License.
       
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Template by Bluepearl Design and vBulletin Templates - Ver3.3