NPC Replace

03/05/2018 18:41 devdash#1

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"

03/11/2018 00:15 HECKT0R#2

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 !

03/11/2018 03:58 devdash#3

Quote:

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

03/12/2018 13:50 devdash#4

thanks mate i really apprecaite ur help,
#Closed