problem with drop & guild union

2 questions
1. how can i add spcific item to drop from all mobs in all regions with spcific rate example ( arena coin 20% drop rate )

2. how can i allow to give union to all guild members the 50 of em, wish means broke the limit of authority union

thanks in advance.

Quote:

Originally Posted by alydandy 2 questions 1. how can i add spcific item to drop from all mobs in all regions with spcific rate example ( arena coin 20% drop rate ) 2. how can i allow to give union to all guild members the 50 of em, wish means broke the limit of authority union thanks in advance.

1. Query you need add to every single mob

2. you must edit gameserver & client with a special Tool

Quote:

Originally Posted by mialuisa 1. Query you need add to every single mob  Spoiler PHP Code: USE SRO_VT_SHARD GO DECLARE [MENTION=290558]MONSTER[/MENTION]ID int DECLARE [MENTION=1134588]item[/MENTION]ID int DECLARE [MENTION=2178693]Dropr[/MENTION]atio real SET [MENTION=290558]MONSTER[/MENTION]ID = 3810 <-------- Mob,Unique ID you want Add Drop in SET [MENTION=2178693]Dropr[/MENTION]atio = 1 <-------- Drop Ration 1=100% , 0.5 = 50%  SET [MENTION=1134588]item[/MENTION]ID = 24165 <-------- ITEM ID You want Add in Drop INSERT _RefMonster_AssignedItemDrop  ( RefMonsterID, RefItemID, DropGroupType, OptLevel, DropAmountMin, DropAmountMax, DropRatio, RefMagicOptionID1, CustomValue1, RefMagicOptionID2, CustomValue2, RefMagicOptionID3, CustomValue3, RefMagicOptionID4, CustomValue4, RefMagicOptionID5, CustomValue5, RefMagicOptionID6, CustomValue6, RefMagicOptionID7, CustomValue7, RefMagicOptionID8, CustomValue8, RefMagicOptionID9, CustomValue9, RentCodeName )  VALUES [MENTION=290558]MONSTER[/MENTION]ID , [MENTION=1134588]item[/MENTION]ID, 0, 0, 1, 1, [MENTION=2178693]Dropr[/MENTION]atio, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')  PHP Code: Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'  PHP Code: Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_08_A_RARE'  Little Mob list PHP 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  2. you must edit gameserver & client with a special Tool

1. thanks really for the perfect answer.
2. can i have this special tool, i heard that some server already did that edit, so that tool have to be some where ?

Quote:

Originally Posted by alydandy 1. thanks really for the perfect answer. 2. can i have this special tool, i heard that some server already did that edit, so that tool have to be some where ?

here i have upload in attach !

but it has a virus

i have check it on my testserver click by SRO_CLIENT.exe open patch last part stay Change Guild/Union Chat limit

12 is standard ! and click the white box by change after this patch and search your sro-client.exe

Quote:

Originally Posted by mialuisa but it has a virus i have check it on my testserver click by SRO_CLIENT.exe open patch last part stay Change Guild/Union Chat limit 12 is standard ! and click the white box by change after this patch and search your sro-client.exe

is that will virus my sro client ? or i can use it then delete it then no problems ?

Quote:

Originally Posted by alydandy is that will virus my sro client ? or i can use it then delete it then no problems ?

is only in that tool
also you can use it after this you can delete it !!

Quote:

Originally Posted by mialuisa is only in that tool also you can use it after this you can delete it !!

thanks alot <3

Quote:

Originally Posted by alydandy thanks alot <3

No Problem :)