AdrianD - Thank you for the response I was not aware of the Raid_target field nor for some reason did I see it when I looked at the database.
In the end I ended up running my sqls which surprisingly ran pretty much as is. Then i ended up running the last query a few more times to catch stragglers who had an extremely large amount of hp to begin with.
It is good to know and consider the ## factor though and I will keep that in mind I appreciate your assistance again as well Kingly.
as for the Adding a Weapon to an NPC to hold it seems I am at a loss there and will attempt to just add them into the database im guessing a simple query would work
as in to update the spawn based on id and d_melee_texture or something.
hopefully i get some time to lookinto that later it just seemed that that there isnt a simple command to be able to type #HOLDTHIS "itemid" seems much more straight forward. Im wondering If i could add one to the database by creating a new GM command that would run a query into the db by selecting the clients target as the ID and the input "14383"(Innoruuk's curse for example) and then put it in the db.
I suppose though you may have to use the texture id such as 152 for IC or something instead.
I was attempting to get #npcedit priweapon (id) or #npcedit priweapon (modelid) to work but they return no error but do nothing.
Guess its time to start looking:P
Edited instead of double posting.
Looking in the command.cpp files i find this.
Code:
c->Message(0, "#npcedit weapon - Sets an NPC's primary and secondary weapon model");
if (strcasecmp(sep->arg[1], "weapon") == 0) {
c->Message(15,"NPCID %u will have item graphic %i set to his primary and item graphic %i set to his secondary on repop.", npcTypeID, atoi(sep->arg[2]), atoi(sep->arg[3]));
std::string query = StringFormat("UPDATE npc_types SET d_melee_texture1 = %i, d_melee_texture2 = %i WHERE id = %i", atoi(sep->arg[2]), atoi(sep->arg[3]), npcTypeID);
database.QueryDatabase(query);
return;
}
When my DB is done sourcing back into Mysql(Sql dump and cmd line sourcing is taking like 2 hours!!) I am gonna give that a shot. It looks like from that command you can only set BOTH at once. Or maybe actually requires NPCID(Target) Modelid1 Modelid2 format for Dual wield. But we will see:P
Threaded Mode
