View Single Post
  #5  
Old 05-16-2018, 08:09 PM
Chakan
Fire Beetle
 
Join Date: Dec 2012
Location: Tn
Posts: 1
Default This doesnt work for me

Hello,
I'm dying to rid my little server of the scourge that is chain NPC summon but this code:

"update npc_types
set special_abilities = '0,' + substring(special_abilities, 2, length(special_abilities)-2)
where special_abilities like '1,%';"

doesn't work. I get an SQL error truncated incorrect double value '0'.

Any help would be greatly appreciated,
Reply With Quote