Someone has to extract all those brain informationOk, let me enlighten you as far as i can
Suffix, ExamineArticle, MessageArticle:
this is selfexplanatory, and is taken to determine diffrent articles when using another language than english.
example: German language replace 'the' by der die das and so on.
regards
Argo
You Get it Right !About Gender: Dunno if i get you right here but if i set gender in npct it is taken from there, test it yourself
UPDATE merchantitem, npctemplate, (SELECT merchantitem.itemListID, @i:=@i+1 AS iterator FROM merchantitem,(SELECT @i:=0) cnt GROUP BY merchantitem.itemListID) uptbl
SET merchantitem.ItemlistID = uptbl.iterator, npctemplate.ItemsListTemplateID = uptbl.iterator
WHERE merchantitem.ItemlistID = uptbl.ItemlistID AND npctemplate.ItemsListTemplateID = uptbl.ItemlistID
SELECT * FROM `npctemplate` JOIN `merchantitem` on `npctemplate`.`ItemsListTemplateID` = `merchantitem`.`ItemListID` WHERE `npctemplate`.`ItemsListTemplateID` IS NOT NULL AND `npctemplate`.`ItemsListTemplateID` NOT LIKE '';
Users browsing this forum: No registered users and 1 guest