BMXWoody
08-13-2009, 11:21 AM
G'day guys, I'm not at all experienced with SQL but I've somehow managed to stumble through setting up and modifying my server without any trouble up until now.
I'm just trying to remove the summon ability from ALL NPCs in my server and I'm hoping someone can tell me how to drop the S value from the npcspecialattks column in the npc_types table. I've tried using UPDATETEXT and REPLACE functions but as I said, I really have no knowledge at all in SQL so I haven't had any luck.
I did have a pretty good look through the forums and the wiki for help but couldn't find anything. Hopefully I haven't missed a glaringly obviously tutorial or something.
Thanks in advance for any help you guys can offer.
Cheers,
BMXWoody.
I'm just trying to remove the summon ability from ALL NPCs in my server and I'm hoping someone can tell me how to drop the S value from the npcspecialattks column in the npc_types table. I've tried using UPDATETEXT and REPLACE functions but as I said, I really have no knowledge at all in SQL so I haven't had any luck.
I did have a pretty good look through the forums and the wiki for help but couldn't find anything. Hopefully I haven't missed a glaringly obviously tutorial or something.
Thanks in advance for any help you guys can offer.
Cheers,
BMXWoody.