![[RELEASE] Perfect query to change spawn rate](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-perfect-query-change-spawn-rate_ltr.gif){kind=small}
since i saw so many spawn change queries they fcked up your whole db with decrease / increase unique spawn rate, instance spawn rate etc i just decided to write my own here we go
Code:
DECLARE @RARE FLOAT = 0.75 /*_#2 = 200%, 1 = 100%, 0.5 = 50%*/
UPDATE TRN
SET TRN.dwMaxTotalCount *= @RARE
FROM Tab_RefNest TRN
JOIN Tab_RefTactics TRT ON TRN.dwTacticsID = TRT.dwTacticsID
JOIN _RefObjCommon ROC ON TRT.dwObjID = ROC.ID
WHERE ROC.CodeName128 LIKE 'MOB%'
AND ROC.Rarity = 0
AND dwDelayTimeMin < 600
AND dwDelayTimeMin != 0
AND dwMaxTotalCount != 1
Code:
MOB_AM_ARCHER MOB_AM_ARCHER_CLON MOB_AM_CRAB MOB_AM_CRAB_CLON MOB_AM_PUNISHER MOB_AM_PUNISHER_CLON MOB_AM_ROGUE MOB_AM_ROGUE_CLON MOB_AM_SOLDIER MOB_AM_SOLDIER_CLON MOB_AM_WOLF MOB_AM_WOLF_CLON MOB_CA_GOLEM MOB_CA_GOLEM_CLON MOB_CA_HUNARCHER MOB_CA_HUNARCHER_CLON MOB_CA_HUNLANCER MOB_CA_HUNLANCER_CLON MOB_CA_MONKEY MOB_CA_MONKEY_CLON MOB_CA_ONG MOB_CA_ONG_CLON MOB_CA_PERYTON MOB_CA_PERYTON_CLON MOB_CH_BANDIT MOB_CH_BANDIT_CLON MOB_CH_BANDITARCHER MOB_CH_BANDITARCHER_CLON MOB_CH_BIGEYEGHOST MOB_CH_BIGEYEGHOST_CLON MOB_CH_CHAKJI MOB_CH_CHAKJI_CLON MOB_CH_GYO MOB_CH_GYO_CLON MOB_CH_MANGNYANG MOB_CH_STONEGHOST MOB_CH_STONEGHOST_CLON MOB_CH_TIGER MOB_CH_TIGER_CLON MOB_CH_TOMBSTONE MOB_CH_TOMBSTONE_CLON MOB_CH_WATERGHOST MOB_CH_WATERGHOST_CLON MOB_CH_WHITETIGER MOB_CH_WHITETIGER_CLON MOB_CH_YEOHA MOB_CH_YEOHA_CLON MOB_DH_BLINDMON MOB_DH_BLINDMON_CLON MOB_DH_BUGGHOST MOB_DH_BUGGHOST_CLON MOB_DH_NACHAL MOB_DH_NACHAL_CLON MOB_DH_SOLDIEREARTHGHOST MOB_DH_SOLDIEREARTHGHOST_CLON MOB_DH_WORKEARTHGHOST MOB_DH_WORKEARTHGHOST_CLON MOB_DH_YACHA MOB_DH_YACHA_CLON MOB_EU_BAROI MOB_EU_BAROI_CLON MOB_EU_BARPOLLE MOB_EU_BARPOLLE_CLON MOB_EU_BARUSWOLF MOB_EU_BARUSWOLF_CLON MOB_EU_DOWB MOB_EU_DOWB_CLON MOB_EU_EDENP MOB_EU_EDENP_CLON MOB_EU_KYKLOPES MOB_EU_KYKLOPES_CLON MOB_EU_KYKLOPES_CLON2 MOB_EU_LADON MOB_EU_LADON_CLON MOB_EU_LION MOB_EU_LION_CLON MOB_EU_MOVOI MOB_EU_MOVOI_CLON MOB_EU_SIREN MOB_EU_SIREN_CLON MOB_KK_GWHITESPIDER MOB_KK_GWHITESPIDER_CLON MOB_KK_ISHADE MOB_KK_ISHADE_CLON MOB_KK_PENON_F MOB_KK_PENON_W MOB_KK_PLANAR MOB_KK_PLANAR_CLON MOB_KK_SPIDER MOB_KK_SPIDER_CLON MOB_KK_YETI MOB_KK_YETI_CLON MOB_KT_BUNWANG MOB_KT_BUNWANG_CLON MOB_KT_DESERTTRUNKZ_CLON MOB_KT_MUJIGI MOB_KT_MUJIGI_CLON MOB_KT_ONG_CLON2 MOB_KT_WHITESPIDER MOB_KT_WHITESPIDER_CLON MOB_OA_BLACKROBBER MOB_OA_BLACKROBBER_CLON MOB_OA_BLACKROBBERARCHER MOB_OA_BLACKROBBERARCHER_CLON MOB_OA_DESERTTRUNKZ MOB_OA_DESERTTRUNKZ_CLON2 MOB_OA_ONG MOB_OA_ONG_CLON MOB_OA_REDEYEGHOST MOB_OA_REDEYEGHOST_CLON MOB_OA_REDSCORPION MOB_OA_REDSCORPION_CLON MOB_OA_SCORPION MOB_OA_SCORPION_CLON MOB_OA_YEOWA MOB_OA_YEOWA_CLON MOB_QT_01_ANTELOPE_CLON MOB_QT_01_ARCHER_CLON MOB_QT_01_BAROI MOB_QT_01_CRAB_CLON MOB_QT_01_HUNARCHER_CLON MOB_QT_01_MONKEY MOB_QT_01_ONG_CLON MOB_QT_01_PUNISHER_CLON MOB_QT_RM_FEATHERMASK_01 MOB_QT_RM_ROCKY_CLON_01 MOB_RM_ANTELOPE MOB_RM_ANTELOPE_CLON MOB_RM_FEATHERMASK MOB_RM_FEATHERMASK_CLON MOB_RM_GOAT MOB_RM_GOAT_CLON MOB_RM_ROCKY MOB_RM_ROCKY_CLON MOB_RM_WINGTRIBE MOB_RM_WINGTRIBE_CLON MOB_RM_WINGTRIBESPEAR MOB_RM_WINGTRIBESPEAR_CLON MOB_SD_ACHNISH MOB_SD_ACHNISHLAMA MOB_SD_AKER MOB_SD_AKERU MOB_SD_BAST MOB_SD_BASTET MOB_SD_BLOOD_HYENA MOB_SD_BLOOD_SANDMAN MOB_SD_BLOODKHEPRI MOB_SD_CAMELSPIDER MOB_SD_CHIEF_HYENA MOB_SD_COELACAN MOB_SD_COELACANTH MOB_SD_CRUELRAIDER MOB_SD_DARK_SANDMAN MOB_SD_DARKKHEPRI MOB_SD_DARKSCOUT MOB_SD_DEMONBUG MOB_SD_DESERTBUG MOB_SD_DEVIL_SANDMAN MOB_SD_DEVILWORM MOB_SD_EVILBUG MOB_SD_HARSAPHETH MOB_SD_HARSMESS MOB_SD_HERON MOB_SD_HIKE MOB_SD_IMOUTHES MOB_SD_KEISAS MOB_SD_KEISAS_BERSERK MOB_SD_LLIGHTINGKHEPRI MOB_SD_MEHEN MOB_SD_MONT MOB_SD_MONTKILLER MOB_SD_MUMMY_HUBRIS MOB_SD_MUMMY_RAGE MOB_SD_PRIEST_CHASTISEMENT MOB_SD_PRIEST_FEAR MOB_SD_PRIEST_FLAME MOB_SD_PRIEST_GALE MOB_SD_PRIEST_REVENGE MOB_SD_SAND_HYENA MOB_SD_SANDBUG MOB_SD_SANDRAIDER MOB_SD_SANDSCOUT MOB_SD_SANDSTING MOB_SD_SANDWORM MOB_SD_SELKION MOB_SD_SEPTU MOB_SD_SPECTOR_DEMOLITION MOB_SD_SPECTOR_GREED MOB_SD_TATHEN MOB_SD_TELBASTA MOB_SD_TENEN MOB_SD_UNEG MOB_SD_URAEUS MOB_SD_WENEG MOB_SD_WINDSPIDER MOB_TK_BONEGENERAL MOB_TK_BONEGENERAL_CLON MOB_TK_BONEHUNTER MOB_TK_BONEHUNTER_CLON MOB_TK_BONEMAGE MOB_TK_BONEMAGE_CLON MOB_TK_BONESOLDIER MOB_TK_BONESOLDIER_CLON MOB_TK_DEATHKARA MOB_TK_DEATHKARA_CLON MOB_TK_DEVILEYE MOB_TK_DEVILEYE_CLON MOB_TK_EDIMMU MOB_TK_EDIMMU_CLON MOB_TQ_QINSHITOMBSTONE MOB_TQ_QINSHITOMBSTONE_CLON MOB_TQ_QINSHITOMBSTONE_CLON2 MOB_TQ_QINSHITRAP5 MOB_TQ_ROYALSOLDIER MOB_TQ_ROYALSOLDIER_CLON MOB_TQ_ROYALSOLDIER_CLON2 MOB_TQ_SNAKEDEMON MOB_TQ_SNAKEDEMON_CLON MOB_TQ_SNAKEDEMON_CLON2 MOB_TQ_SNAKEMAN MOB_TQ_SNAKEMAN_CLON MOB_TQ_SNAKEMAN_CLON2 MOB_TQ_SNAKESLAVE MOB_TQ_SNAKESLAVE_CLON MOB_TQ_SNAKESLAVE_CLON2 MOB_TQ_SNAKEWOMAN MOB_TQ_SNAKEWOMAN_CLON MOB_TQ_SNAKEWOMAN_CLON2 MOB_TQ_TOMBARCHER MOB_TQ_TOMBARCHER_CLON MOB_TQ_TOMBARCHER_CLON2 MOB_TQ_TOMBBUGGHOST MOB_TQ_TOMBBUGGHOST_CLON MOB_TQ_TOMBBUGGHOST_CLON2 MOB_TQ_TOMBSOLDIER MOB_TQ_TOMBSOLDIER_CLON MOB_TQ_TOMBSOLDIER_CLON2 MOB_TQ_TOMBSTONEGHOST MOB_TQ_TOMBSTONEGHOST_CLON MOB_TQ_TOMBSTONEGHOST_CLON2 MOB_WC_DEMONHORSE MOB_WC_DEMONHORSE_CLON MOB_WC_DEVILBUG MOB_WC_EARTHGHOST MOB_WC_EARTHGHOST_CLON MOB_WC_EARTHKING MOB_WC_EARTHKING_CLON MOB_WC_GHOSTBUG MOB_WC_GUNPOWDERGHOST MOB_WC_GUNPOWDERGHOST_CLON MOB_WC_HYEONGCHEON MOB_WC_HYEONGCHEON_CLON MOB_WC_HYUNGNO MOB_WC_HYUNGNO_CLON
