Help me little problem ^_^

[fuddreckers]

No unique appearing in my server .... only lord appear every 24h
and Powerful unique , so please i need Query to fix unique appearing time
every 30 min.. its so boring that no unique appear all players are boring ,,
and the second problem .. when i load any monster there are no name
appearing Like " Yuno has appeared " , but the unique already appears but with no name , and when anyone kill it no name appear to , so i want it to be like any unique !!

[Haxor]

Check RefNest
DwDailyTimeMin - DwDailyTimeMax

[fuddreckers]

Originally Posted by ™Haxor™

Check RefNest
DwDailyTimeMin - DwDailyTimeMax

how can i get unique id or help me please , i saw query before to do that job
prove pic

[™Rapid™]

1800:60= 30 min..


Tiger Girl

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_CH_TIGERWOMAN'))

Uruchi

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics 
 WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_OA_URUCHI'))

Isyutaru

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_KK_ISYUTARU'))

Lord Yarkan:

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_TK_BONELORD'))

Demon Shaitan

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET'))

Cerberus

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_EU_KERBEROS'))

Captain ivy

 Update Tab_RefNest Set dwDelayTimeMin=1800 , dwDelayTimeMax=1800 WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = 
 (SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_AM_IVY'))

To change the spawn time for other unique do like that:

use this way.