Help me little problem ^_^

07/03/2012 21:08 fuddreckers#1
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 !!
07/04/2012 00:22 Haxor#2
Check RefNest
DwDailyTimeMin - DwDailyTimeMax
07/04/2012 17:54 fuddreckers#3
Quote:
Originally Posted by ™Haxor™ View Post
Check RefNest
DwDailyTimeMin - DwDailyTimeMax

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

[Only registered and activated users can see links. Click Here To Register...]
07/05/2012 01:38 ™Rapid™#4
Quote:
1800:60= 30 min..


Tiger Girl

Code:
 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

Code:
 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

Code:
 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:

Code:
 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

Code:
 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

Code:
 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

Code:
 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.