NPC Replace

[devdash]

how can i replace npc with other npc,
Example: the smith in jangan with smith hotan,
Note: jangan smith is empty have no items at all in case you wonder,

Thanks in advance, iam learning from you experts "ALOT"

[HECKT0R]

use this query

PHP Code:

select codename128,a.* from Tab_RefNest a 
    INNER JOIN Tab_RefTactics b ON a.dwTacticsID = b.dwTacticsID
    JOIN Tab_RefHive c ON a.dwHiveID = c.dwHiveID
    JOIN _RefObjCommon d ON b.dwObjID = d.ID
    where codename128  LIKE 'NPC_ NPC NAME HERE' 


you will get all the info about this npc
replace the locations only and remove the spawn for the unwanted npc by deleting his nest line if needed !

Cheers !

[devdash]

Originally Posted by msbmohamed

use this query

PHP Code:

select codename128,a.* from Tab_RefNest a 
    INNER JOIN Tab_RefTactics b ON a.dwTacticsID = b.dwTacticsID
    JOIN Tab_RefHive c ON a.dwHiveID = c.dwHiveID
    JOIN _RefObjCommon d ON b.dwObjID = d.ID
    where codename128  LIKE 'NPC_ NPC NAME HERE' 


you will get all the info about this npc
replace the locations only and remove the spawn for the unwanted npc by deleting his nest line if needed !

Cheers !

i will try it now and i will be back with the results

[devdash]

thanks mate i really apprecaite ur help,
#Closed