View Single Post
  #1  
Old 11-13-2015, 01:42 PM
SKlife83
Fire Beetle
 
Join Date: Oct 2015
Posts: 26
Default Everything is working but...

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
Reply With Quote