Everything is working but...

[SKlife83]

I've managed to build my linux server with local login, bots, mercs, and everything else. I've even started editing the mobs stats hp,atk,ac, etc. However, when I goto add special abilities to the mobs I get a syntax error. The following is what I am trying to do:

mysql>
UPDATE `npc_types` SET `special_abilities` = `special_abilities` + 2,1,25,8000,60000^3,1,15,1,75^5,4,100,0,0,0,100,0^ 7,1^9,1^10,1^38,1^41,1^44,1,0,5,15,5,20;

The error I receive is:

ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '1,25,8000,60000^3,1,15,1,75^5,4,100,0,0,0,100,0^7 ,1^9,1^10,1^38,1^41,1^44,1,0,5,' at line 1

However, if i type UPDATE `npc_types` SET `special_abilities` = `special_abilities` = 0; column is filled with all 0's so I'm not sure whats going on.

Mr. Uleat was taking a look at it, but he is a busy man and I've already asked him for enough help. If anyone has a clue how to add most of the special attacks to all npcs, please let me know!

Thanks,
Mike

[Shendare]

You need to put single quotes around non-numeric values like the special abilities line. It's a text field, since it contains commas and carets and multiple numbers, as opposed to a single numeric value like a number column.


UPDATE `npc_types` SET `special_abilities` = `special_abilities` + '2,1,25,8000,60000^3,1,15,1,75^5,4,100,0,0,0,100,0 ^ 7,1^9,1^10,1^38,1^41,1^44,1,0,5,15,5,20';

[SKlife83]

Thank you, got it. Just one last problem. Having npc's KOS. Lead me to this thread:

http://www.eqemulator.org/forums/showthread.php?t=26439

However does not seem to work for me as everything is indifferent. I basically want to make all npc(besides quest/merchant/missions etc etc.) KOS to players. Thanks!

[Huppy]

Just curious, haven't worked on a linux box in a long while. Last one was a Debian 6.
I never had any problems with that one, but now I've got this Debian 7.9 going.
The problem I am having is the executables (all of them), zone, world, etc., including
my start and stop scripts. (which I did chmod)
I get "command not found" when trying to execute any of them in a terminal.
I have it all in one folder (eqemu), just as one does in windows.
Running the eqemu update perl script worked fine.
When I do a ls , the executable files show their "green status" as they normally would.
I know, I'm probably missing something, maybe something new. I didn't have this prob back
when I was running the Debian 6, but I've been searching through a whole pot of coffee,
racking my brains out, hahahaha
UPDATE EDIT: SO SORRY< this wasn't meant as a reply to this thread, I screwed up posting it, lol
Another UPDATE: I recompiled the executables and this time they work, have no idea what happened first time,
I didn't change anything, but now I just have to get the start/stop to work, lol