Emistry

YOUR_COOLDOWN = gettimetick(2) + (86400 - gettimetick(1)); another easier way for daily checking gettime(DT_DAYOFYEAR)

may refer this post for guide to fix the account_id issue. https://rathena.org/board/topic/131467-need-help-sql-db-error-pls-thanks/#comment-407968

i think it only work for client around 2022+

something like this if not mistaken int value = static_cast<int>(mapreg_readreg(add_str("$WeatherBonus")));

you can find all the buff or debuff status change here. export_constant(SC_STONE); export_constant(SC_FREEZE); export_constant(SC_STUN); export_constant(SC_SLEEP); export_constant(SC_POISON); export_constant(SC_CURSE); export_constant(SC_SILENCE); export_constant(SC_CONFUSION); export_constant(SC_BLIND); export_constant(SC_BLEEDING); export_constant(SC_DPOISON); export_constant(SC_STONEWAIT); export_constant(SC_PROVOKE); export_constant(SC_ENDURE); export_constant(SC_TWOHANDQUICKEN); export_constant(SC_CONCENTRATE); export_constant(SC_HIDING); export_constant(SC_CLOAKING); export_constant(SC_ENCPOISON); export_constant(SC_POISONREACT); export_constant(SC_QUAGMIRE); export_constant(SC_ANGELUS); export_constant(SC_BLESSING); export_constant(SC_SIGNUMCRUCIS); export_constant(SC_INCREASEAGI); export_constant(SC_DECREASEAGI); export_constant(SC_SLOWPOISON); export_constant(SC_IMPOSITIO); export_constant(SC_SUFFRAGIUM); export_constant(SC_ASPERSIO); export_constant(SC_BENEDICTIO); export_constant(SC_KYRIE); export_constant(SC_MAGNIFICAT); export_constant(SC_GLORIA); export_constant(SC_AETERNA); export_constant(SC_ADRENALINE); export_constant(SC_WEAPONPERFECTION); export_constant(SC_OVERTHRUST); export_constant(SC_MAXIMIZEPOWER); export_constant(SC_TRICKDEAD); export_constant(SC_LOUD); export_constant(SC_ENERGYCOAT); export_constant(SC_BROKENARMOR); export_constant(SC_BROKENWEAPON); export_constant(SC_HALLUCINATION); export_constant(SC_WEIGHT50); export_constant(SC_WEIGHT90); export_constant(SC_ASPDPOTION0); export_constant(SC_ASPDPOTION1); export_constant(SC_ASPDPOTION2); export_constant(SC_ASPDPOTION3); export_constant(SC_SPEEDUP0); export_constant(SC_SPEEDUP1); export_constant(SC_ATKPOTION); export_constant(SC_MATKPOTION); export_constant(SC_WEDDING); export_constant(SC_SLOWDOWN); export_constant(SC_ANKLE); export_constant(SC_KEEPING); export_constant(SC_BARRIER); export_constant(SC_STRIPWEAPON); export_constant(SC_STRIPSHIELD); export_constant(SC_STRIPARMOR); export_constant(SC_STRIPHELM); export_constant(SC_CP_WEAPON); export_constant(SC_CP_SHIELD); export_constant(SC_CP_ARMOR); export_constant(SC_CP_HELM); export_constant(SC_AUTOGUARD); export_constant(SC_REFLECTSHIELD); export_constant(SC_SPLASHER); export_constant(SC_PROVIDENCE); export_constant(SC_DEFENDER); export_constant(SC_MAGICROD); export_constant(SC_SPELLBREAKER); export_constant(SC_AUTOSPELL); export_constant(SC_SIGHTTRASHER); export_constant(SC_AUTOBERSERK); export_constant(SC_SPEARQUICKEN); export_constant(SC_AUTOCOUNTER); export_constant(SC_SIGHT); export_constant(SC_SAFETYWALL); export_constant(SC_RUWACH); export_constant(SC_EXTREMITYFIST); export_constant(SC_EXPLOSIONSPIRITS); export_constant(SC_COMBO); export_constant(SC_BLADESTOP_WAIT); export_constant(SC_BLADESTOP); export_constant(SC_FIREWEAPON); export_constant(SC_WATERWEAPON); export_constant(SC_WINDWEAPON); export_constant(SC_EARTHWEAPON); export_constant(SC_VOLCANO); export_constant(SC_DELUGE); export_constant(SC_VIOLENTGALE); export_constant(SC_WATK_ELEMENT); export_constant(SC_ARMOR); export_constant(SC_ARMOR_ELEMENT_WATER); export_constant(SC_NOCHAT); export_constant(SC_PROTECTEXP); export_deprecated_constant3("SC_BABY", SC_PROTECTEXP, "SC_PROTECTEXP"); export_constant(SC_AURABLADE); export_constant(SC_PARRYING); export_constant(SC_CONCENTRATION); export_constant(SC_TENSIONRELAX); export_constant(SC_BERSERK); export_constant(SC_FURY); export_constant(SC_GOSPEL); export_constant(SC_ASSUMPTIO); export_constant(SC_BASILICA); export_constant(SC_GUILDAURA); export_constant(SC_MAGICPOWER); export_constant(SC_EDP); export_constant(SC_TRUESIGHT); export_constant(SC_WINDWALK); export_constant(SC_MELTDOWN); export_constant(SC_CARTBOOST); export_constant(SC_CHASEWALK); export_constant(SC_REJECTSWORD); export_constant(SC_MARIONETTE); export_constant(SC_MARIONETTE2); export_constant(SC_CHANGEUNDEAD); export_constant(SC_JOINTBEAT); export_constant(SC_MINDBREAKER); export_constant(SC_MEMORIZE); export_constant(SC_FOGWALL); export_constant(SC_SPIDERWEB); export_constant(SC_DEVOTION); export_constant(SC_SACRIFICE); export_constant(SC_STEELBODY); export_constant(SC_ORCISH); export_constant(SC_READYSTORM); export_constant(SC_READYDOWN); export_constant(SC_READYTURN); export_constant(SC_READYCOUNTER); export_constant(SC_DODGE); export_constant(SC_RUN); export_constant(SC_SHADOWWEAPON); export_constant(SC_ADRENALINE2); export_constant(SC_GHOSTWEAPON); export_constant(SC_KAIZEL); export_constant(SC_KAAHI); export_constant(SC_KAUPE); export_constant(SC_ONEHAND); export_constant(SC_PRESERVE); export_constant(SC_BATTLEORDERS); export_constant(SC_REGENERATION); export_constant(SC_DOUBLECAST); export_constant(SC_GRAVITATION); export_constant(SC_MAXOVERTHRUST); export_constant(SC_LONGING); export_constant(SC_HERMODE); export_constant(SC_SHRINK); export_constant(SC_SIGHTBLASTER); export_constant(SC_WINKCHARM); export_constant(SC_CLOSECONFINE); export_constant(SC_CLOSECONFINE2); export_constant(SC_DANCING); export_constant(SC_ELEMENTALCHANGE); export_constant(SC_RICHMANKIM); export_constant(SC_ETERNALCHAOS); export_constant(SC_DRUMBATTLE); export_constant(SC_NIBELUNGEN); export_constant(SC_ROKISWEIL); export_constant(SC_INTOABYSS); export_constant(SC_SIEGFRIED); export_constant(SC_WHISTLE); export_constant(SC_ASSNCROS); export_constant(SC_POEMBRAGI); export_constant(SC_APPLEIDUN); export_constant(SC_MODECHANGE); export_constant(SC_HUMMING); export_constant(SC_DONTFORGETME); export_constant(SC_FORTUNE); export_constant(SC_SERVICE4U); export_constant(SC_STOP); export_constant(SC_SPURT); export_constant(SC_SPIRIT); export_constant(SC_COMA); export_constant(SC_INTRAVISION); export_constant(SC_INCALLSTATUS); export_constant(SC_INCSTR); export_constant(SC_INCAGI); export_constant(SC_INCVIT); export_constant(SC_INCINT); export_constant(SC_INCDEX); export_constant(SC_INCLUK); export_constant(SC_INCHIT); export_constant(SC_INCHITRATE); export_constant(SC_INCFLEE); export_constant(SC_INCFLEERATE); export_constant(SC_INCMHPRATE); export_constant(SC_INCMSPRATE); export_constant(SC_INCATKRATE); export_constant(SC_INCMATKRATE); export_constant(SC_INCDEFRATE); export_constant(SC_STRFOOD); export_constant(SC_AGIFOOD); export_constant(SC_VITFOOD); export_constant(SC_INTFOOD); export_constant(SC_DEXFOOD); export_constant(SC_LUKFOOD); export_constant(SC_HITFOOD); export_constant(SC_FLEEFOOD); export_constant(SC_BATKFOOD); export_constant(SC_WATKFOOD); export_constant(SC_MATKFOOD); export_constant(SC_SCRESIST); export_constant(SC_XMAS); export_constant(SC_WARM); export_constant(SC_SUN_COMFORT); export_constant(SC_MOON_COMFORT); export_constant(SC_STAR_COMFORT); export_constant(SC_FUSION); export_constant(SC_SKILLRATE_UP); export_constant(SC_SKE); export_constant(SC_KAITE); export_constant(SC_SWOO); export_constant(SC_SKA); export_constant(SC_EARTHSCROLL); export_constant(SC_MIRACLE); export_constant(SC_MADNESSCANCEL); export_constant(SC_ADJUSTMENT); export_constant(SC_INCREASING); export_constant(SC_GATLINGFEVER); export_constant(SC_TATAMIGAESHI); export_constant(SC_UTSUSEMI); export_constant(SC_BUNSINJYUTSU); export_constant(SC_KAENSIN); export_constant(SC_SUITON); export_constant(SC_NEN); export_constant(SC_KNOWLEDGE); export_constant(SC_SMA); export_constant(SC_FLING); export_constant(SC_AVOID); export_constant(SC_CHANGE); export_constant(SC_BLOODLUST); export_constant(SC_FLEET); export_constant(SC_SPEED); export_constant(SC_DEFENCE); export_constant(SC_INCASPDRATE); export_constant(SC_INCFLEE2); export_constant(SC_JAILED); export_constant(SC_ENCHANTARMS); export_constant(SC_MAGICALATTACK); export_constant(SC_ARMORCHANGE); export_constant(SC_CRITICALWOUND); export_constant(SC_MAGICMIRROR); export_constant(SC_SLOWCAST); export_constant(SC_SUMMER); export_constant(SC_EXPBOOST); export_constant(SC_ITEMBOOST); export_constant(SC_BOSSMAPINFO); export_constant(SC_LIFEINSURANCE); export_constant(SC_INCCRI); //export_constant(SC_INCDEF); //export_constant(SC_INCBASEATK); //export_constant(SC_FASTCAST); export_constant(SC_MDEF_RATE); //export_constant(SC_HPREGEN); export_constant(SC_INCHEALRATE); export_constant(SC_PNEUMA); export_constant(SC_AUTOTRADE); export_constant(SC_KSPROTECTED); export_constant(SC_ARMOR_RESIST); export_constant(SC_SPCOST_RATE); export_constant(SC_COMMONSC_RESIST); export_constant(SC_SEVENWIND); export_constant(SC_DEF_RATE); //export_constant(SC_SPREGEN); export_constant(SC_WALKSPEED); export_constant(SC_MERC_FLEEUP); export_constant(SC_MERC_ATKUP); export_constant(SC_MERC_HPUP); export_constant(SC_MERC_SPUP); export_constant(SC_MERC_HITUP); export_constant(SC_MERC_QUICKEN); export_constant(SC_REBIRTH); //export_constant(SC_SKILLCASTRATE); //export_constant(SC_DEFRATIOATK); //export_constant(SC_HPDRAIN); //export_constant(SC_SKILLATKBONUS); export_constant(SC_ITEMSCRIPT); export_constant(SC_S_LIFEPOTION); export_constant(SC_L_LIFEPOTION); export_constant(SC_JEXPBOOST); //export_constant(SC_IGNOREDEF); export_constant(SC_HELLPOWER); export_constant(SC_INVINCIBLE); export_constant(SC_INVINCIBLEOFF); export_constant(SC_MANU_ATK); export_constant(SC_MANU_DEF); export_constant(SC_SPL_ATK); export_constant(SC_SPL_DEF); export_constant(SC_MANU_MATK); export_constant(SC_SPL_MATK); export_constant(SC_FOOD_STR_CASH); export_constant(SC_FOOD_AGI_CASH); export_constant(SC_FOOD_VIT_CASH); export_constant(SC_FOOD_DEX_CASH); export_constant(SC_FOOD_INT_CASH); export_constant(SC_FOOD_LUK_CASH); export_constant(SC_FEAR); export_constant(SC_BURNING); export_constant(SC_FREEZING); export_constant(SC_ENCHANTBLADE); export_constant(SC_DEATHBOUND); export_constant(SC_MILLENNIUMSHIELD); export_constant(SC_CRUSHSTRIKE); export_constant(SC_REFRESH); export_constant(SC_REUSE_REFRESH); export_constant(SC_GIANTGROWTH); export_constant(SC_STONEHARDSKIN); export_constant(SC_VITALITYACTIVATION); export_constant(SC_STORMBLAST); export_constant(SC_FIGHTINGSPIRIT); export_constant(SC_ABUNDANCE); export_constant(SC_ADORAMUS); export_constant(SC_EPICLESIS); export_constant(SC_ORATIO); export_constant(SC_LAUDAAGNUS); export_constant(SC_LAUDARAMUS); export_constant(SC_RENOVATIO); export_constant(SC_EXPIATIO); export_constant(SC_DUPLELIGHT); export_constant(SC_SECRAMENT); export_constant(SC_WHITEIMPRISON); export_constant(SC_MARSHOFABYSS); export_constant(SC_RECOGNIZEDSPELL); export_constant(SC_STASIS); export_constant(SC_SPHERE_1); export_constant(SC_SPHERE_2); export_constant(SC_SPHERE_3); export_constant(SC_SPHERE_4); export_constant(SC_SPHERE_5); export_constant(SC_READING_SB); export_constant(SC_FREEZE_SP); export_constant(SC_FEARBREEZE); export_constant(SC_ELECTRICSHOCKER); export_constant(SC_WUGDASH); export_constant(SC_BITE); export_constant(SC_CAMOUFLAGE); export_constant(SC_ACCELERATION); export_constant(SC_HOVERING); export_constant(SC_SHAPESHIFT); export_constant(SC_INFRAREDSCAN); export_constant(SC_ANALYZE); export_constant(SC_MAGNETICFIELD); export_constant(SC_NEUTRALBARRIER); export_constant(SC_NEUTRALBARRIER_MASTER); export_constant(SC_STEALTHFIELD); export_constant(SC_STEALTHFIELD_MASTER); export_constant(SC_OVERHEAT); export_constant(SC_OVERHEAT_LIMITPOINT); export_constant(SC_VENOMIMPRESS); export_constant(SC_POISONINGWEAPON); export_constant(SC_WEAPONBLOCKING); export_constant(SC_CLOAKINGEXCEED); export_constant(SC_HALLUCINATIONWALK); export_constant(SC_HALLUCINATIONWALK_POSTDELAY); export_constant(SC_ROLLINGCUTTER); export_constant(SC_TOXIN); export_constant(SC_PARALYSE); export_constant(SC_VENOMBLEED); export_constant(SC_MAGICMUSHROOM); export_constant(SC_DEATHHURT); export_constant(SC_PYREXIA); export_constant(SC_OBLIVIONCURSE); export_constant(SC_LEECHESEND); export_constant(SC_REFLECTDAMAGE); export_constant(SC_FORCEOFVANGUARD); export_constant(SC_SHIELDSPELL_HP); export_constant(SC_SHIELDSPELL_SP); export_constant(SC_SHIELDSPELL_ATK); export_constant(SC_EXEEDBREAK); export_constant(SC_PRESTIGE); export_constant(SC_BANDING); export_constant(SC_BANDING_DEFENCE); export_constant(SC_EARTHDRIVE); export_constant(SC_INSPIRATION); export_constant(SC_SPELLFIST); export_constant(SC_CRYSTALIZE); export_constant(SC_STRIKING); export_constant(SC_WARMER); export_constant(SC_VACUUM_EXTREME); export_constant(SC_PROPERTYWALK); export_constant(SC_SWINGDANCE); export_constant(SC_SYMPHONYOFLOVER); export_constant(SC_MOONLITSERENADE); export_constant(SC_RUSHWINDMILL); export_constant(SC_ECHOSONG); export_constant(SC_HARMONIZE); export_constant(SC_VOICEOFSIREN); export_constant(SC_DEEPSLEEP); export_constant(SC_SIRCLEOFNATURE); export_constant(SC_GLOOMYDAY); export_constant(SC_GLOOMYDAY_SK); export_constant(SC_SONGOFMANA); export_constant(SC_DANCEWITHWUG); export_constant(SC_SATURDAYNIGHTFEVER); export_constant(SC_LERADSDEW); export_constant(SC_MELODYOFSINK); export_constant(SC_BEYONDOFWARCRY); export_constant(SC_UNLIMITEDHUMMINGVOICE); export_constant(SC_SITDOWN_FORCE); export_constant(SC_NETHERWORLD); export_constant(SC_CRESCENTELBOW); export_constant(SC_CURSEDCIRCLE_ATKER); export_constant(SC_CURSEDCIRCLE_TARGET); export_constant(SC_LIGHTNINGWALK); export_constant(SC_RAISINGDRAGON); export_constant(SC_GT_ENERGYGAIN); export_constant(SC_GT_CHANGE); export_constant(SC_GT_REVITALIZE); export_constant(SC_GN_CARTBOOST); export_constant(SC_THORNSTRAP); export_constant(SC_BLOODSUCKER); export_constant(SC_SMOKEPOWDER); export_constant(SC_TEARGAS); export_constant(SC_MANDRAGORA); export_constant(SC_STOMACHACHE); export_constant(SC_MYSTERIOUS_POWDER); export_constant(SC_MELON_BOMB); export_constant(SC_BANANA_BOMB); export_constant(SC_BANANA_BOMB_SITDOWN); export_constant(SC_SAVAGE_STEAK); export_constant(SC_COCKTAIL_WARG_BLOOD); export_constant(SC_MINOR_BBQ); export_constant(SC_SIROMA_ICE_TEA); export_constant(SC_DROCERA_HERB_STEAMED); export_constant(SC_PUTTI_TAILS_NOODLES); export_constant(SC_BOOST500); export_constant(SC_FULL_SWING_K); export_constant(SC_MANA_PLUS); export_constant(SC_MUSTLE_M); export_constant(SC_LIFE_FORCE_F); export_constant(SC_EXTRACT_WHITE_POTION_Z); export_constant(SC_VITATA_500); export_constant(SC_EXTRACT_SALAMINE_JUICE); export_constant(SC__REPRODUCE); export_constant(SC__AUTOSHADOWSPELL); export_constant(SC__SHADOWFORM); export_constant(SC__BODYPAINT); export_constant(SC__INVISIBILITY); export_constant(SC__DEADLYINFECT); export_constant(SC__ENERVATION); export_constant(SC__GROOMY); export_constant(SC__IGNORANCE); export_constant(SC__LAZINESS); export_constant(SC__UNLUCKY); export_constant(SC__WEAKNESS); export_constant(SC__STRIPACCESSORY); export_constant(SC__MANHOLE); export_constant(SC__BLOODYLUST); export_constant(SC_CIRCLE_OF_FIRE); export_constant(SC_CIRCLE_OF_FIRE_OPTION); export_constant(SC_FIRE_CLOAK); export_constant(SC_FIRE_CLOAK_OPTION); export_constant(SC_WATER_SCREEN); export_constant(SC_WATER_SCREEN_OPTION); export_constant(SC_WATER_DROP); export_constant(SC_WATER_DROP_OPTION); export_constant(SC_WATER_BARRIER); export_constant(SC_WIND_STEP); export_constant(SC_WIND_STEP_OPTION); export_constant(SC_WIND_CURTAIN); export_constant(SC_WIND_CURTAIN_OPTION); export_constant(SC_ZEPHYR); export_constant(SC_SOLID_SKIN); export_constant(SC_SOLID_SKIN_OPTION); export_constant(SC_STONE_SHIELD); export_constant(SC_STONE_SHIELD_OPTION); export_constant(SC_POWER_OF_GAIA); export_constant(SC_PYROTECHNIC); export_constant(SC_PYROTECHNIC_OPTION); export_constant(SC_HEATER); export_constant(SC_HEATER_OPTION); export_constant(SC_TROPIC); export_constant(SC_TROPIC_OPTION); export_constant(SC_AQUAPLAY); export_constant(SC_AQUAPLAY_OPTION); export_constant(SC_COOLER); export_constant(SC_COOLER_OPTION); export_constant(SC_CHILLY_AIR); export_constant(SC_CHILLY_AIR_OPTION); export_constant(SC_GUST); export_constant(SC_GUST_OPTION); export_constant(SC_BLAST); export_constant(SC_BLAST_OPTION); export_constant(SC_WILD_STORM); export_constant(SC_WILD_STORM_OPTION); export_constant(SC_PETROLOGY); export_constant(SC_PETROLOGY_OPTION); export_constant(SC_CURSED_SOIL); export_constant(SC_CURSED_SOIL_OPTION); export_constant(SC_UPHEAVAL); export_constant(SC_UPHEAVAL_OPTION); export_constant(SC_TIDAL_WEAPON); export_constant(SC_TIDAL_WEAPON_OPTION); export_constant(SC_ROCK_CRUSHER); export_constant(SC_ROCK_CRUSHER_ATK); export_constant(SC_LEADERSHIP); export_constant(SC_GLORYWOUNDS); export_constant(SC_SOULCOLD); export_constant(SC_HAWKEYES); export_constant(SC_ODINS_POWER); export_constant(SC_RAID); export_constant(SC_FIRE_INSIGNIA); export_constant(SC_WATER_INSIGNIA); export_constant(SC_WIND_INSIGNIA); export_constant(SC_EARTH_INSIGNIA); export_constant(SC_PUSH_CART); export_constant(SC_SPELLBOOK1); export_constant(SC_SPELLBOOK2); export_constant(SC_SPELLBOOK3); export_constant(SC_SPELLBOOK4); export_constant(SC_SPELLBOOK5); export_constant(SC_SPELLBOOK6); export_constant(SC_MAXSPELLBOOK); export_constant(SC_INCMHP); export_constant(SC_INCMSP); export_constant(SC_PARTYFLEE); export_constant(SC_MEIKYOUSISUI); export_constant(SC_JYUMONJIKIRI); export_constant(SC_KYOUGAKU); export_constant(SC_IZAYOI); export_constant(SC_ZENKAI); export_constant(SC_KAGEHUMI); export_constant(SC_KYOMU); export_constant(SC_KAGEMUSYA); export_constant(SC_ZANGETSU); export_constant(SC_GENSOU); export_constant(SC_AKAITSUKI); export_constant(SC_STYLE_CHANGE); export_constant(SC_TINDER_BREAKER); export_constant(SC_TINDER_BREAKER2); export_constant(SC_CBC); export_constant(SC_EQC); export_constant(SC_GOLDENE_FERSE); export_constant(SC_ANGRIFFS_MODUS); export_constant(SC_OVERED_BOOST); export_constant(SC_LIGHT_OF_REGENE); export_constant(SC_ASH); export_constant(SC_GRANITIC_ARMOR); export_constant(SC_MAGMA_FLOW); export_constant(SC_PYROCLASTIC); export_constant(SC_PARALYSIS); export_constant(SC_PAIN_KILLER); export_constant(SC_HANBOK); export_constant(SC_DEFSET); export_constant(SC_MDEFSET); export_constant(SC_DARKCROW); export_constant(SC_FULL_THROTTLE); export_constant(SC_REBOUND); export_constant(SC_UNLIMIT); export_constant(SC_KINGS_GRACE); export_constant(SC_TELEKINESIS_INTENSE); export_constant(SC_OFFERTORIUM); export_constant(SC_FRIGG_SONG); export_constant(SC_MONSTER_TRANSFORM); export_constant(SC_ANGEL_PROTECT); export_constant(SC_ILLUSIONDOPING); export_constant(SC_FLASHCOMBO); export_constant(SC_MOONSTAR); export_constant(SC_SUPER_STAR); export_constant(SC_HEAT_BARREL); export_constant(SC_MAGICALBULLET); export_constant(SC_P_ALTER); export_constant(SC_E_CHAIN); export_constant(SC_C_MARKER); export_constant(SC_ANTI_M_BLAST); export_constant(SC_B_TRAP); export_constant(SC_H_MINE); export_constant(SC_QD_SHOT_READY); export_constant(SC_MTF_ASPD); export_constant(SC_MTF_RANGEATK); export_constant(SC_MTF_MATK); export_constant(SC_MTF_MLEATKED); export_constant(SC_MTF_CRIDAMAGE); export_constant(SC_OKTOBERFEST); export_constant(SC_STRANGELIGHTS); export_constant(SC_DECORATION_OF_MUSIC); export_constant(SC_QUEST_BUFF1); export_constant(SC_QUEST_BUFF2); export_constant(SC_QUEST_BUFF3); export_constant(SC_ALL_RIDING); export_constant(SC_TEARGAS_SOB); export_constant(SC__FEINTBOMB); export_constant(SC__CHAOS); export_constant(SC_CHASEWALK2); export_constant(SC_VACUUM_EXTREME_POSTDELAY); export_constant(SC_MTF_ASPD2); export_constant(SC_MTF_RANGEATK2); export_constant(SC_MTF_MATK2); export_constant(SC_2011RWC_SCROLL); export_constant(SC_JP_EVENT04); export_constant(SC_MTF_MHP); export_constant(SC_MTF_MSP); export_constant(SC_MTF_PUMPKIN); export_constant(SC_MTF_HITFLEE); export_constant(SC_CRIFOOD); export_constant(SC_ATTHASTE_CASH); export_constant(SC_REUSE_LIMIT_A); export_constant(SC_REUSE_LIMIT_B); export_constant(SC_REUSE_LIMIT_C); export_constant(SC_REUSE_LIMIT_D); export_constant(SC_REUSE_LIMIT_E); export_constant(SC_REUSE_LIMIT_F); export_constant(SC_REUSE_LIMIT_G); export_constant(SC_REUSE_LIMIT_H); export_constant(SC_REUSE_LIMIT_MTF); export_constant(SC_REUSE_LIMIT_ASPD_POTION); export_constant(SC_REUSE_MILLENNIUMSHIELD); export_constant(SC_REUSE_CRUSHSTRIKE); export_constant(SC_REUSE_STORMBLAST); export_constant(SC_ALL_RIDING_REUSE_LIMIT); export_constant(SC_REUSE_LIMIT_ECL); export_constant(SC_REUSE_LIMIT_RECALL); export_constant(SC_PROMOTE_HEALTH_RESERCH); export_constant(SC_ENERGY_DRINK_RESERCH); export_constant(SC_NORECOVER_STATE); export_constant(SC_SUHIDE); export_constant(SC_SU_STOOP); export_constant(SC_SPRITEMABLE); export_constant(SC_CATNIPPOWDER); export_constant(SC_SV_ROOTTWIST); export_constant(SC_BITESCAR); export_constant(SC_ARCLOUSEDASH); export_constant(SC_TUNAPARTY); export_constant(SC_SHRIMP); export_constant(SC_FRESHSHRIMP); export_constant(SC_ACTIVE_MONSTER_TRANSFORM); export_deprecated_constant(SC_CLOUD_KILL); export_constant(SC_LJOSALFAR); export_constant(SC_MERMAID_LONGING); export_constant(SC_HAT_EFFECT); export_constant(SC_FLOWERSMOKE); export_constant(SC_FSTONE); export_constant(SC_HAPPINESS_STAR); export_constant(SC_MAPLE_FALLS); export_constant(SC_TIME_ACCESSORY); export_constant(SC_MAGICAL_FEATHER); export_constant(SC_GVG_GIANT); export_constant(SC_GVG_GOLEM); export_constant(SC_GVG_STUN); export_constant(SC_GVG_STONE); export_constant(SC_GVG_FREEZ); export_constant(SC_GVG_SLEEP); export_constant(SC_GVG_CURSE); export_constant(SC_GVG_SILENCE); export_constant(SC_GVG_BLIND); export_constant(SC_CLAN_INFO); export_constant(SC_SWORDCLAN); export_constant(SC_ARCWANDCLAN); export_constant(SC_GOLDENMACECLAN); export_constant(SC_CROSSBOWCLAN); export_constant(SC_JUMPINGCLAN); export_constant(SC_TAROTCARD); export_constant(SC_GEFFEN_MAGIC1); export_constant(SC_GEFFEN_MAGIC2); export_constant(SC_GEFFEN_MAGIC3); export_constant(SC_MAXPAIN); export_constant(SC_ARMOR_ELEMENT_EARTH); export_constant(SC_ARMOR_ELEMENT_FIRE); export_constant(SC_ARMOR_ELEMENT_WIND); export_constant(SC_DAILYSENDMAILCNT); export_constant(SC_DORAM_BUF_01); export_constant(SC_DORAM_BUF_02); export_constant(SC_HISS); export_constant(SC_NYANGGRASS); export_constant(SC_GROOMING); export_constant(SC_SHRIMPBLESSING); export_constant(SC_CHATTERING); export_constant(SC_DORAM_WALKSPEED); export_constant(SC_DORAM_MATK); export_constant(SC_DORAM_FLEE2); export_constant(SC_DORAM_SVSP); export_constant(SC_FALLEN_ANGEL); export_constant(SC_CHEERUP); export_constant(SC_DRESSUP); export_constant(SC_GLASTHEIM_ATK); export_constant(SC_GLASTHEIM_DEF); export_constant(SC_GLASTHEIM_HEAL); export_constant(SC_GLASTHEIM_HIDDEN); export_constant(SC_GLASTHEIM_STATE); export_constant(SC_GLASTHEIM_ITEMDEF); export_constant(SC_GLASTHEIM_HPSP); export_constant(SC_LHZ_DUN_N1); export_constant(SC_LHZ_DUN_N2); export_constant(SC_LHZ_DUN_N3); export_constant(SC_LHZ_DUN_N4); export_constant(SC_ANCILLA); export_constant(SC_EARTHSHAKER); export_constant(SC_WEAPONBLOCK_ON); export_constant(SC_SPORE_EXPLOSION); export_constant(SC_ENTRY_QUEUE_APPLY_DELAY); export_constant(SC_ENTRY_QUEUE_NOTIFY_ADMISSION_TIME_OUT); export_constant(SC_ADAPTATION); export_constant(SC_BASILICA_CELL); export_constant(SC_LIGHTOFMOON); export_constant(SC_LIGHTOFSUN); export_constant(SC_LIGHTOFSTAR); export_constant(SC_LUNARSTANCE); export_constant(SC_UNIVERSESTANCE); export_constant(SC_SUNSTANCE); export_constant(SC_FLASHKICK); export_constant(SC_NEWMOON); export_constant(SC_STARSTANCE); export_constant(SC_DIMENSION); export_constant(SC_DIMENSION1); export_constant(SC_DIMENSION2); export_constant(SC_CREATINGSTAR); export_constant(SC_FALLINGSTAR); export_constant(SC_NOVAEXPLOSING); export_constant(SC_GRAVITYCONTROL); export_constant(SC_SOULCOLLECT); export_constant(SC_SOULREAPER); export_constant(SC_SOULUNITY); export_constant(SC_SOULSHADOW); export_constant(SC_SOULFAIRY); export_constant(SC_SOULFALCON); export_constant(SC_SOULGOLEM); export_constant(SC_SOULDIVISION); export_constant(SC_SOULENERGY); export_constant(SC_USE_SKILL_SP_SPA); export_constant(SC_USE_SKILL_SP_SHA); export_constant(SC_SP_SHA); export_constant(SC_SOULCURSE); export_constant(SC_HELLS_PLANT); export_constant(SC_INCREASE_MAXHP); export_constant(SC_INCREASE_MAXSP); export_constant(SC_HELPANGEL); export_constant(SC_REF_T_POTION); export_constant(SC_ADD_ATK_DAMAGE); export_constant(SC_ADD_MATK_DAMAGE); export_constant(SC_SOUNDOFDESTRUCTION); export_constant(SC_LUXANIMA); export_constant(SC_REUSE_LIMIT_LUXANIMA); export_constant(SC_ENSEMBLEFATIGUE); export_constant(SC_MISTY_FROST); export_constant(SC_MAGIC_POISON); export_constant(SC_EP16_2_BUFF_SS); export_constant(SC_EP16_2_BUFF_SC); export_constant(SC_EP16_2_BUFF_AC); export_constant(SC_EMERGENCY_MOVE); export_constant(SC_MADOGEAR); export_constant(SC_NPC_HALLUCINATIONWALK); export_constant(SC_OVERBRANDREADY); export_constant(SC_POISON_MIST); export_constant(SC_STONE_WALL); export_constant(SC_CLOUD_POISON); export_constant(SC_HOMUN_TIME); export_constant(SC_PACKING_ENVELOPE1); export_constant(SC_PACKING_ENVELOPE2); export_constant(SC_PACKING_ENVELOPE3); export_constant(SC_PACKING_ENVELOPE4); export_constant(SC_PACKING_ENVELOPE5); export_constant(SC_PACKING_ENVELOPE6); export_constant(SC_PACKING_ENVELOPE7); export_constant(SC_PACKING_ENVELOPE8); export_constant(SC_PACKING_ENVELOPE9); export_constant(SC_PACKING_ENVELOPE10); export_constant(SC_SOULATTACK); export_constant(SC_WIDEWEB); export_constant(SC_BURNT); export_constant(SC_CHILL); export_constant(SC_HANDICAPSTATE_DEEPBLIND); export_constant(SC_HANDICAPSTATE_DEEPSILENCE); export_constant(SC_HANDICAPSTATE_LASSITUDE); export_constant(SC_HANDICAPSTATE_FROSTBITE); export_constant(SC_HANDICAPSTATE_SWOONING); export_constant(SC_HANDICAPSTATE_LIGHTNINGSTRIKE); export_constant(SC_HANDICAPSTATE_CRYSTALLIZATION); export_constant(SC_HANDICAPSTATE_CONFLAGRATION); export_constant(SC_HANDICAPSTATE_MISFORTUNE); export_constant(SC_HANDICAPSTATE_DEADLYPOISON); export_constant(SC_HANDICAPSTATE_DEPRESSION); export_constant(SC_HANDICAPSTATE_HOLYFLAME); export_constant(SC_SERVANTWEAPON); export_constant(SC_SERVANT_SIGN); export_constant(SC_CHARGINGPIERCE); export_constant(SC_CHARGINGPIERCE_COUNT); export_constant(SC_DRAGONIC_AURA); export_constant(SC_VIGOR); export_constant(SC_DEADLY_DEFEASANCE); export_constant(SC_CLIMAX_DES_HU); export_constant(SC_CLIMAX); export_constant(SC_CLIMAX_EARTH); export_constant(SC_CLIMAX_BLOOM); export_constant(SC_CLIMAX_CRYIMP); export_constant(SC_WINDSIGN); export_constant(SC_CRESCIVEBOLT); export_constant(SC_CALAMITYGALE); export_constant(SC_MEDIALE); export_constant(SC_A_VITA); export_constant(SC_A_TELUM); export_constant(SC_PRE_ACIES); export_constant(SC_COMPETENTIA); export_constant(SC_RELIGIO); export_constant(SC_BENEDICTUM); export_constant(SC_AXE_STOMP); export_constant(SC_A_MACHINE); export_constant(SC_D_MACHINE); export_constant(SC_ABR_BATTLE_WARIOR); export_constant(SC_ABR_DUAL_CANNON); export_constant(SC_ABR_MOTHER_NET); export_constant(SC_ABR_INFINITY); export_constant(SC_SHADOW_EXCEED); export_constant(SC_DANCING_KNIFE); export_constant(SC_POTENT_VENOM); export_constant(SC_SHADOW_SCAR); export_constant(SC_E_SLASH_COUNT); export_constant(SC_SHADOW_WEAPON); export_constant(SC_GUARD_STANCE); export_constant(SC_ATTACK_STANCE); export_constant(SC_GUARDIAN_S); export_constant(SC_REBOUND_S); export_constant(SC_HOLY_S); export_constant(SC_ULTIMATE_S); export_constant(SC_SPEAR_SCAR); export_constant(SC_SHIELD_POWER); export_constant(SC_SPELL_ENCHANTING); export_constant(SC_SUMMON_ELEMENTAL_ARDOR); export_constant(SC_SUMMON_ELEMENTAL_DILUVIO); export_constant(SC_SUMMON_ELEMENTAL_PROCELLA); export_constant(SC_SUMMON_ELEMENTAL_TERREMOTUS); export_constant(SC_SUMMON_ELEMENTAL_SERPENS); export_constant(SC_ELEMENTAL_VEIL); export_constant(SC_MYSTIC_SYMPHONY); export_constant(SC_KVASIR_SONATA); export_constant(SC_SOUNDBLEND); export_constant(SC_GEF_NOCTURN); export_constant(SC_AIN_RHAPSODY); export_constant(SC_MUSICAL_INTERLUDE); export_constant(SC_JAWAII_SERENADE); export_constant(SC_PRON_MARCH); export_constant(SC_ROSEBLOSSOM); export_constant(SC_POWERFUL_FAITH); export_constant(SC_SINCERE_FAITH); export_constant(SC_FIRM_FAITH); export_constant(SC_HOLY_OIL); export_constant(SC_FIRST_BRAND); export_constant(SC_SECOND_BRAND); export_constant(SC_SECOND_JUDGE); export_constant(SC_THIRD_EXOR_FLAME); export_constant(SC_FIRST_FAITH_POWER); export_constant(SC_MASSIVE_F_BLASTER); export_constant(SC_PROTECTSHADOWEQUIP); export_constant(SC_RESEARCHREPORT); export_constant(SC_BO_HELL_DUSTY); export_constant(SC_BIONIC_WOODENWARRIOR); export_constant(SC_BIONIC_WOODEN_FAIRY); export_constant(SC_BIONIC_CREEPER); export_constant(SC_BIONIC_HELLTREE); export_constant(SC_SHADOW_STRIP); export_constant(SC_ABYSS_DAGGER); export_constant(SC_ABYSSFORCEWEAPON); export_constant(SC_ABYSS_SLAYER); export_constant(SC_FLAMETECHNIC); export_constant(SC_FLAMETECHNIC_OPTION); export_constant(SC_FLAMEARMOR); export_constant(SC_FLAMEARMOR_OPTION); export_constant(SC_COLD_FORCE); export_constant(SC_COLD_FORCE_OPTION); export_constant(SC_CRYSTAL_ARMOR); export_constant(SC_CRYSTAL_ARMOR_OPTION); export_constant(SC_GRACE_BREEZE); export_constant(SC_GRACE_BREEZE_OPTION); export_constant(SC_EYES_OF_STORM); export_constant(SC_EYES_OF_STORM_OPTION); export_constant(SC_EARTH_CARE); export_constant(SC_EARTH_CARE_OPTION); export_constant(SC_STRONG_PROTECTION); export_constant(SC_STRONG_PROTECTION_OPTION); export_constant(SC_DEEP_POISONING); export_constant(SC_DEEP_POISONING_OPTION); export_constant(SC_POISON_SHIELD); export_constant(SC_POISON_SHIELD_OPTION); export_constant(SC_SUB_WEAPONPROPERTY); export_constant(SC_M_LIFEPOTION); export_constant(SC_S_MANAPOTION); export_constant(SC_ALMIGHTY); export_constant(SC_ULTIMATECOOK); export_constant(SC_M_DEFSCROLL); export_constant(SC_INFINITY_DRINK); export_constant(SC_MENTAL_POTION); export_constant(SC_LIMIT_POWER_BOOSTER); export_constant(SC_COMBAT_PILL); export_constant(SC_COMBAT_PILL2); export_constant(SC_MYSTICPOWDER); export_constant(SC_SPARKCANDY); export_constant(SC_MAGICCANDY); export_constant(SC_ACARAJE); export_constant(SC_POPECOOKIE); export_constant(SC_VITALIZE_POTION); export_constant(SC_CUP_OF_BOZA); export_constant(SC_SKF_MATK); export_constant(SC_SKF_ATK); export_constant(SC_SKF_ASPD); export_constant(SC_SKF_CAST); export_constant(SC_BEEF_RIB_STEW); export_constant(SC_PORK_RIB_STEW); export_constant(SC_WEAPONBREAKER); export_constant(SC_TOXIN_OF_MANDARA); export_constant(SC_GOLDENE_TONE); export_constant(SC_TEMPERING); export_constant(SC_GRADUAL_GRAVITY); export_constant(SC_ALL_STAT_DOWN); export_constant(SC_KILLING_AURA); export_constant(SC_DAMAGE_HEAL); export_constant(SC_IMMUNE_PROPERTY_NOTHING); export_constant(SC_IMMUNE_PROPERTY_WATER); export_constant(SC_IMMUNE_PROPERTY_GROUND); export_constant(SC_IMMUNE_PROPERTY_FIRE); export_constant(SC_IMMUNE_PROPERTY_WIND); export_constant(SC_IMMUNE_PROPERTY_POISON); export_constant(SC_IMMUNE_PROPERTY_SAINT); export_constant(SC_IMMUNE_PROPERTY_DARKNESS); export_constant(SC_IMMUNE_PROPERTY_TELEKINESIS); export_constant(SC_IMMUNE_PROPERTY_UNDEAD); #ifdef RENEWAL export_constant(SC_EXTREMITYFIST2); #endif /* Custom Temporary */ export_constant(SC_EXPBOOST_VEND); export_constant(SC_ITEMBOOST_VEND); export_constant(SC_RUSH_QUAKE1); export_constant(SC_RUSH_QUAKE2); export_constant(SC_RELIEVE_DAMAGE); /* 4th Job Expanded */ export_constant(SC_INTENSIVE_AIM); export_constant(SC_INTENSIVE_AIM_COUNT); export_constant(SC_HIDDEN_CARD); export_constant(SC_GRENADE_FRAGMENT_1); export_constant(SC_GRENADE_FRAGMENT_2); export_constant(SC_GRENADE_FRAGMENT_3); export_constant(SC_GRENADE_FRAGMENT_4); export_constant(SC_GRENADE_FRAGMENT_5); export_constant(SC_GRENADE_FRAGMENT_6); export_constant(SC_AUTO_FIRING_LAUNCHEREFST); export_constant(SC_TALISMAN_OF_PROTECTION); export_constant(SC_TALISMAN_OF_WARRIOR); export_constant(SC_TALISMAN_OF_MAGICIAN); export_constant(SC_TALISMAN_OF_FIVE_ELEMENTS); export_constant(SC_T_FIRST_GOD); export_constant(SC_T_SECOND_GOD); export_constant(SC_T_THIRD_GOD); export_constant(SC_T_FOURTH_GOD); export_constant(SC_T_FIVETH_GOD); export_constant(SC_HEAVEN_AND_EARTH); export_constant(SC_TOTEM_OF_TUTELARY); export_constant(SC_HOGOGONG); export_constant(SC_MARINE_FESTIVAL); export_constant(SC_SANDY_FESTIVAL); export_constant(SC_KI_SUL_RAMPAGE); export_constant(SC_COLORS_OF_HYUN_ROK_1); export_constant(SC_COLORS_OF_HYUN_ROK_2); export_constant(SC_COLORS_OF_HYUN_ROK_3); export_constant(SC_COLORS_OF_HYUN_ROK_4); export_constant(SC_COLORS_OF_HYUN_ROK_5); export_constant(SC_COLORS_OF_HYUN_ROK_6); export_constant(SC_COLORS_OF_HYUN_ROK_BUFF); export_constant(SC_TEMPORARY_COMMUNION); export_constant(SC_BLESSING_OF_M_CREATURES); export_constant(SC_BLESSING_OF_M_C_DEBUFF); export_constant(SC_HNNOWEAPON); export_constant(SC_SHIELDCHAINRUSH); export_constant(SC_MISTYFROST); export_constant(SC_GROUNDGRAVITY); export_constant(SC_BREAKINGLIMIT); export_constant(SC_RULEBREAK); export_constant(SC_RISING_SUN); export_constant(SC_NOON_SUN); export_constant(SC_SUNSET_SUN); export_constant(SC_RISING_MOON); export_constant(SC_MIDNIGHT_MOON); export_constant(SC_DAWN_MOON); export_constant(SC_STAR_BURST); export_constant(SC_SKY_ENCHANT); export_constant(SC_SHADOW_CLOCK); export_constant(SC_SHINKIROU_CALL); export_constant(SC_NIGHTMARE); export_constant(SC_SBUNSHIN);

arent that is how the battleground work? you cant hit monster that is from your team.

change to OnClock1300: OnClock1500: OnClock1700: OnClock1900:

try autobonus2 "{ bonus bMatkRate,20; }",150,3000;

there are some trick you can try if you dont have any available src mod to support it yet. - Id: 1203 AegisName: Knife__ Script: | donpcevent "Sample::OnAttack"; - script Sample -1,{ OnAttack: .@gid = <MONSTER_GID>; // SET YOUR MONSTER GID HERE if (!unitexists(.@gid)) end; getunitdata .@gid, .@data; if (.@data[UMOB_HP] <= 1000) { unitkill .@gid; end; } setunitdata .@gid, UMOB_HP, (.@data[UMOB_HP] - 1000); end; } every attack shall reduce the monster HP by 1000. use at your own risk, script like these may cause performance issues, or max event queues, etc.

bonus2 bSkillAtk, "LK_SPIRALPIERCE", 500 + max(0, (BaseLevel - 200));

new_1-1 mapflag nocommand

it should be switch (rand(1, 4)) { ... ... }

OnNPCKillEvent: // Logic to detect when a MvP is killed if (getmonsterinfo(killedrid, MOB_MVPEXP) > 0 && strcharinfo(3) == "YOUR_MAP_NAME"){ conf/battle/drops.conf#L143-L150 // Make broadcast ** Player1 won Pupa's Pupa Card (chance 0.01%) *** // This can be set to any value between 0~10000. // Note: It also announces STEAL skill usage with rare items // 0 = don't show announces at all // 1 = show announces for 0.01% drop chance items // 333 = show announces for 3.33% or lower drop chance items // 10000 = show announces for all items rare_drop_announce: 100

you meant these ? conf/battle/battle.conf#L64-L78 // Type of penalty that is applied to FLEE when more than agi_penalty_count monsters are targetting player // 0 = no penalty is applied // 1 = agi_penalty_num is reduced from FLEE as a % // 2 = agi_penalty_num is reduced from FLEE as an exact amount agi_penalty_type: 1 // When agi penalty is enabled, to whom it should apply to? (Note 3) // By default, only players get the penalty. agi_penalty_target: 1 // Amount of enemies required to be targetting player before FLEE begins to be penalized agi_penalty_count: 3 // Amount of FLEE penalized per each attacking monster more than agi_penalty_count agi_penalty_num: 10

bindatcmd("rentitem", strnpcinfo(3)+"::OnAtcommand", 99);

function script Omegabox { specialeffect2 39; setarray .@Omega[0],42000,42005,42010; set .@Random, getarraysize( .@Omega); .@item_id = .@Omega[ rand( .@Random) ]; rentitem .@item_id, 1 * 259200; mes" Congratulations, you get a "+getitemname(.@item_id); if (.@item_id = 42000){ set #ONE, #ONE+ 1; mes "You have a total of"+ #ONE+" Points"; } if (.@item_id = 42005){ set #TWO, #TWO+ 1; mes "You have a total of"+ #TWO+" Points"; } if (.@item_id = 42010){ set #THREE, #THREE + 1; mes "You have a total of"+ #THREE +" Points"; } close; } try

use this https://github.com/rathena/rathena/pull/7394

find them in the file and remove it?

https://www.w3schools.com/Sql/func_mysql_datediff.asp

OnTimer1000: OnInit: showscript "Broadcaster", getnpcid(0, "Broadcaster"), AREA; initnpctimer; end;

setarray .combinedArray[getarraysize(.combinedArray)], .attr1, getarraysize(.attr1); setarray .combinedArray[getarraysize(.combinedArray)], .attr2, getarraysize(.attr2); setarray .combinedArray[getarraysize(.combinedArray)], .attr3, getarraysize(.attr3); setarray .combinedArray[getarraysize(.combinedArray)], .attr4, getarraysize(.attr4); setarray .combinedArray[getarraysize(.combinedArray)], .attr5, getarraysize(.attr5); setarray .combinedArray[getarraysize(.combinedArray)], .attr6, getarraysize(.attr6);

remove the data stored in data/towninfo.lub

No, latest rathena read most of the db files in yaml formal. doc/yaml/db

try prontera,155,181,5 script Sample 757,{ .@year = gettime(DT_YEAR); .@month = gettime(DT_MONTH); .@sql$ = "SELECT `nameid`, SUM(`amount`) AS `total` FROM `picklog` WHERE `type` = 'S' AND `amount` > 0 AND MONTH(`time`) = "+.@month+" AND YEAR(`time`) = "+.@year+" GROUP BY `nameid` ORDER BY `total` DESC LIMIT 10"; .@count = query_sql(.@sql$, .@nameid, .@total); mes "Items:"; for (.@i = 0; .@i < .@count; .@i++) mes getitemname(.@nameid[.@i])+" - "+F_InsertComma(.@total[.@i]); close; }

these are quest skill (aka platinum skills) you wont get them through allskills atcommand @questskill {<skill ID>} @lostskill {<skill ID>} Permanently adds or removes the specified quest skill. If no skill ID is specified, a list of available skills will be returned. use these instead.