Post here any database changes ok guys? [shadowlady] ==== progress ==== Ayothaya mobs == 50% All have correct stats now ? Nope! Einbroch mobs == 85% But their stats could be wrong. No info about MVP RSX 0608 Ayothaya items == 70% Added but no effect ( all are "etc" itens) Einbroch items == 5% Skill databases == celest working on them I believe. -- New Cards : Not Implemented 4149,Gargoyle_Card: missing getitemonkill?? (item not implemented) 4177,Dryad_Card: missing getitemonracekill?? 4187,Raydric_Archer_Card missing getitemonkill?? (item not implemented) 4189,Wraith_Dead_Card: missing getitemonracekill?? 4196,Marin_Card: missing bRandomDrop,Item1,Chance,Item2,Chance,etc 4198,Maya_Purple_Card: intravision not working atm 4224,Stem_Worm_Card: missing getitemonkill?? (item not implemented) 4228,Sleeper_Card: missing getitemonkill?? (item not implemented) 4256,Orc_Archer_Card: missing getitemonkill?? (item not implemented) 4296,Cramp_Card: missing getzenybychance?? 4231,Increase_Soil_Card 4262,Taoist_Hermit_Card 4265,Li_Me_Mang_Ryang_Card 06/01 * Optimized a lot of new cards scripts [DracoRPG] * Changed Deviling to receive 50% more damage from ALL elements but neutral, and not only Fire/Earth/Water/Wind [DracoRPG] * Changed doppelganger card aspd bonus to 10% as it should be. [massdriller] * Changed DoppelGanger card's attack speed increase to 30%. [Skotlex] This card current does not stacks. If anyone knows of a valid source that says otherwise, open a bug-report so it can be corrected. 05/29 * Moved the card-status listing from item_db.txt to this file [Skotlex] * Added the new column to item_db: refineable to specify which items can be refined. [Skotlex] * Fixed Novices able to wear all "Every class except Novice" headgears, thanks to duduc [DracoRPG] 05/28 * Added emotion constants to const.txt [Skotlex - R1853] The constants mirror their command counter part (ie: /meh -> e_meh), for the most part, except for the following: e_gasp (/!), e_what (/?), e_cash (/$), e_dots (/...), e_no (/??), e_hp (need HP), e_hlp (/hp, help emotion), e_scissors (ctrl+-), e_rock (ctrl+=), e_paper (ctrl+\) And the following flag-emotions are available: e_korea, e_indonesia, e_philippines, e_usa, e_brazil The whole point is being able to do in scripts "emotion e_wah;" instead of "emotion 16;" 05/25 * Fixed Peach Tree card, thanks to Komurka 05/20 * Updated mob skill DB, thanks to Komurka 05/17 * Corrected typo for sweet potato, thanks to maeki * Switched Tirfing and Mystelltain card effects, thanks to starlon [DracoRPG] 05/15 * Changed Hylozoist's race to demon, thanks to Dino9021 * Fixed Gajomart Card, thanks to starlon [DracoRPG] * Added missing 'amount input' packet for Sakexe 05-09 [celest] 05/12 * Added missing 'close storage' packet for Sakexe 05-09 [celest] 05/11 * Updated item_db (all items with use_script "pet" or "itemskill") to use the new type of item (11: delay-consumed usables) [Skotlex] * Added the new G_ mobs with poring stats, thanks to Komurka 05/10 * Changed 2005-05-09Sakexe's packet version to 17 [celest] * Fixed Merchant Class Card Combo Set bug (it was always ON) [Lupus] * Merchant Class Card Combo Set: added 0.1% Old Purple Box drop [Lupus] * Archer Class Card Combo Set: added +5% EXP bonus on killing Brute [Lupus] * Holy Class Card Combo Set: added +5% EXP bonus on killing Undead/Demon [Lupus] 05/09 * Added INT +2 and Unbreakable to Crown of Mistress [DracoRPG] * added Sara-chan's 18th packets update [Lupus] * Added FULLY updated mobs skills DB by Komurka (up to Aegis Zone 8.5) [Lupus] * Fixed drops of Antique Firelock (thanx 2 Freya) [Lupus] * Added skills to Beetle King thanks to MasterOfMuppets [Lupus] * Started updating monsters skills according to the recent servers thanks to MasterOfMuppets [Lupus] 05/08 * Fixed Whisper Boss card, thanks to sbilly * Updated the packet db (removed some duplicates, corrected some packets), thanks to glucose * Removed Sword Mastery from Alchemist's skill tree :o [DracoRPG] 05/06 * Fixed some genders for some FOOD. Added some new items into item_db. Thanks 2 Landarma [Lupus] 05/04 * Added 1% Horse Crest drops to Greatest General, Sohee monsters [Lupus] * Added implemented cards into card albums and to mobs drops [Lupus] * Set Mimic Card, Mystcase Card bonus to 0.1% (it was 0.01%, they has been increased to 0.1% due recent patch) But it isn't 1% for sure ? Greatest General Card semms having wrong effect, tough 8) [Lupus] 05/03 * Added missing item drop effects for some new cards [celest] * Fixed Heater Card and Freezer Card [celest] 05/02 * Fixed # of Deviling's slaves [Lupus] * Fixed cards that use getrefine [celest] 05/01 * Fixed skill tree entry for Potion Synthesis, thanks to shadow 04/30 * fixed cards that required bExpAddRace,bSPGainRace,bLoseSPWhenUnequip by MasterOfMuppets [Lupus] 04/29 * Re-added Spiral Pierce to Lord knight's skill tree * Added missing Shield Chain to the skill tree, thanks to Komurka * Fixed Harpy Card and Freezer Card, thanks to Komurka 04/28 * Added effect for Dumpling Child and Hermit Plant card * Changed Crab card to use 'isequipped' and fixed Rideword card 04/27 * Added effect for Solar Sword 04/26 * Fixed some items, thanks to Komurka and shadow * Applied new advanced skills changes from 4/26 patch [DracoRPG] * Reverted Arrow Shower / Double back to 0.1. Sorry! [Lupus] * Started implementing missing card effects [Lupus] * Added more mobs skills, thanx to MasterOfMuppets [Lupus] 04/25 * Fixed Durian and Ramadan, thanks to rollopop 04/23 * Fixed Red Scarf name, thanks to Sasuke [DracoRPG] * Removed some extra 0's in the item_db, thanks to Zoc * Added monsters skills to all Niflheim / Louyang monsters, changed Garm slaves to Garm Bebe. Thanx to MasterOfMuppets * Fixed Owl Duke Card, now casting IMPOSITIO on the card holder [Lupus] * Panacea,Royal Jelly now remove Hallucination Effect. accord.to 10 May patch [Lupus] * Hallucination Pills (Pellet) cause Hallucination Effect [Lupus] 04/22 * Updated effects for Ahura Mazda, Gaia Sword, Freezer Card * Added 4 items of THQ -> item_avail.txt [Lupus] * Removed the Stun effect ????? on Sweet Potato, fixed Assulter Card script not in correct field [DracoRPG] * Minor cards sets fixes [DracoRPG] - Reverted some wrong Codemaster's if(callfunc("Is_xx_Class"))) => if(callfunc("Is_xx_Class"))==0) changes - Fixed Thief cards set checking for Merchant class instead of Thief class 04/20 * Added Thief cards set and fixed other ones, now they should all work [DracoRPG] * Added Intravision item bonus [DracoRPG] * Adding supported map cell types to const.txt [celest] * Added summoned Geographers can heal their masters [celest] 04/19 * Corrected skill tree entry for Peco lord knight's Berserk [celest] 04/17 * Fixed "Every job except Novice" armors wearable by Novices [DracoRPG] 04/16 * Corrected job bonuses for novice, super novice and dancer [celest] 04/15 * Removed Raid not allowed in GvG (never seen it anywhere...) [DracoRPG] * Added new items, thanx to Landarma [Lupus] 04/12 * Added monsters skills and slaves to all Einbrook monsters, thx4info2 Landarma [Lupus] * fixed Deviling and Lou-Yang monsters drops, thx2 MasterOfMuppets [Lupus] * Added missing summon slaves to Deviling, Tao Gunka (correct # and type) [Lupus] * Made Deviling, Tao Gunka aggressive (st - according to most DBs, 2nd - it's MVP) * Corrected 1 wrong entry in the create arrow DB, thanks to Komurka 04/08 * Corrected wrong entries in the create arrow DB, thanks to Komurka 04/07 * Fixed materials for forging Lance : 1 Evil Horn -> 2 [DracoRPG] * Fixed Sphinx Hat equip location [DracoRPG] 04/06 * Added Einbrook monsters and drops, thanx to Landarma [Lupus] 04/05 * Some items fixes [DracoRPG] - added missing "Neko Mimi" hat #5099, thanks to Neko2 - fixed Wedding Rings item types, thank to nimrod * Removed Evil Wings drops from Mini Demon,Deviruchi,Archangeling and put it into Deviling [Lupus] according to kRO "Evil Wings" are dropped by Deviling only Deviling items drop chances aren't correct yet * Fixed skill tree entries for Vulcan Arrow, and Throw Arrow for gypsies, thanks to Hekate 04/04 * Removed required skills for Berserk (only job level 50 is needed) [DracoRPG] * Re-added MDEF +15 to Resting Cat [DracoRPG] * Added Sunglasses & Glasses into OBB, added slotted Sunglasses & Glasses into OVB [Lupus] 04/03 * Doppelganger Card gives only 10% ASPD bonus (from Aegis) [DracoRPG] 04/02 * More new cards and fixes [DracoRPG] - added Acolyte, Archer and Merchant sets effects - added Turtle General Card effect - corrected Job_Super_Novice -> Job_SuperNovice for Lude and Quve Cards - autospell weapons (except Fireblend, Ice Falchion and Electric Guitar) give no more the skill so it can't be used when you want 04/01 * New cards updates and additions [DracoRPG] - added Mage and Swordman sets effects - added Whisper Boss Card (not found the ID -> commented out) - activated Turtle General Card but effect not yet scripted - updated some effects from 3/17 patch 03/31 * Updated/added some new card effects [DracoRPG] * Reverted Berzebub card to reduce casting rate * Corrected some item effects, thanks to digigp and htm * Updated some cards effects from 3/25 patch [DracoRPG] * Updated freeze time for Frost Diver and Frost Nova * Updated cast time for Preserve, thanks to Neko2 03/29 * Some optimizatons, added missing skill to Electric Guitar [Lupus] * Added new items (thanx to Landarma) [Lupus] * Added effects to Spring Rabbit, Galapago, Sea Otter Cards [Lupus] It seems that item heal rate doesn't work yet 03/27 * Re-Updated MOB DB with correct file now 8) [Lupus] * Added all released cards into monsters drops and OCA [Lupus] * Minor Items, Monsters fixes [Lupus] 03/26 * Fixed some incorrect create arrow entries, thanks to boredpoo 03/25 * Added Einbrook's mobs, thanks to RodneyJ for their IDs [Lupus] * Removed some extra 0's in the item_db, thanks to Zoc * Corrected some item effects according to the mentoned earlier doc [Lupus] 03/24 * Corrected exp table entries for level 11 and 99, thanks to Dino9021 * Corrected some item effects according to the newly found Aegis Zone Server [DracoRPG] 03/22 * Corrected some typos in the items DB, thanks to Zoc [celest] * Added new items. Thanks to Landarma [Lupus] * skill CANNIBALIZE: fixed its upkeep time [Lupus] * Added Rafflesia into Dead Branch monsters list, removen all MVPs from there [Lupus] DBs never supposed to call MVPs!!! Only Sages Hocus Pocus could make a MVP from Alchemyst's Floras. (eA Hocus implementation doesn't support it yet) 03/21 * Corrected exp table entries for Super Novice, thanks to Dino9021 [celest] 03/19 * changed all cards to 'getrefine' function [Lupus] * used 'cardscnt' instead of 'isequipped' in Crab Card. It's a weapon compunding card. So it used to give up to 6 bonuses! on Assassin with 4 4-slotted weapons. Now it lets you get up to 2x bonuses per hand. Should be fixed more. already got idea 8) All the similar cards should be fixed in the same way. * Fixed missing END; in new cards, some optimizatons [Lupus] 03/18 * Updated item prices for Niflheim drops [celest] * Updated some Ayothaya mob stats [celest] * Fixed Incantation Samurai card reducing HP too quickly - the time should be in milliseconds ^^; [celest] * Added ~86 new cards. Fixed, optimized [Lupus] Thanks to Indiona,Landarma. Gosh, I had to fix some bugz ^_- 03/16 * Added new items. Thanks to Landarma [Lupus] 03/15 * Fixed pricing for Claw, thanks to Dino9021 [celest] 03/09 * Added new items. Thanks to Landarma [Lupus] 02/23 * New Cards: Some fixes, revisions, additions [Lupus] According to the latest news: Fixed Tirfing, Mysteltainn (swapped enemy sizes of the cards bonuses) Added bonus: Munak+Bongun+Hyegun Cards -> +1 Allstats Added Alice Card placement. (also added it for Spring Rabbit, Galapago, Otter) And put Alice Card into OCA can't add new effects for 22 Fed Update Cards yet. All the cards by 22Feb have been revised, but not all tested. 02/21 * Added new item: Takius' Blindfold. thanks to Landarma [Lupus] * Revised New Cards, added missing effects, fixed bugs [Lupus] ~20 cards to check left 8) But in 22 Feb some new cards have been announced T__T' * Added actual item_db.sql into sql-files. [Lupus] * item_db.txt: Added missing fields / removed extra fields from some new items V__V' [Lupus] * More monsters name fixes (GIANT_HONET -> GIANT_HORNET , etc) [Lupus] * Added actual mob_db.sql into sql-files. If you use SQL Mob DB then update it [Lupus] 02/19 * Added released cards into the monsters drops. Fixed couple card names [Lupus] (Arc Angeling -> Archangeling) 02/18 * Added more new cards effects (thanks to DracoRPG at this time) [Lupus] added missing bonus 'bAllStats' into doc/item_bonus.txt * Changed Goblin Leader Card to using bAddRace2 -- each player can only save 10 AddDamageClass, so this would save some space for other cards ^^ [celest] * Started adding new cards effects. Also big thanks to Landarma [Lupus] 02/17 * Added 4 columns into mob_db.txt & mob_db2.txt [Lupus] If you were using SQL MOB DB, then update your SQL DB and import all data from mob_db.txt mob_db2.txt * Fixed some mobs drops Whisper + Boss Whissper had wrong drops %% [Lupus] and Whisper had 0% Card drop...Also fixed all MVP mobs (MVP bonuses were shifted... MVP EXP was missing, etc) * Corrected Parrying lasting time, thanks to p14333 and krc2k for pointing it out [celest] 02/11 NOTE: Get rid of old cards on your server!!! IDs: 4149-4332 before using of this item_db.txt (some cards have changed their IDs) and it could cause ALIEN cards in your players equipment 8)) i.g. a weapon compounding CARDS inserted in armor, etc... * item_db.txt Massive update: [Lupus] - Added all new missing items (up to st.Valentine's Day Event) - Added new cards 4149-4332, sorted them and set their sripts. - Fixed some names, typos, weigths and prices * Commented out old custom cards from Old_Card_Album.txt till we brush them up [Lupus] * Removed old custom cards from MOBs drops [Lupus] thanks to Landarma(new items templates) Poki#3(removing cards from drops) * Updated Soul Breaker cast and delay time, thanks to matthias [celest] * Updated Chain Crush to require level 2 Tiger Fist, thanks to matthias for pointing it out [celest] 02/05 * item_db.txt Added prices to all Magic Scrolls and to Horse Crest, added +100-1000 Zeny effect to Gold Coin (it's used in st.Patric event) not sure in Zeny amount, tough. [Lupus] * mob_db.txt Kind of Beetle -> Beetle King. [Lupus] 01/26 * Updated Counter dagger's attack, thanks to Poki#3 * Added ayo_fild02 to nomemo mapflag list 01/13 * Fixed drops of Taoist Hermit, added drops rates to JOKER (all rates were 0%) Removed 0.01% Chances of all Apple drops plugs Tided up mob_db/mob_db2, removed extra tail delimiters (,,,,,,) [Lupus] 01/07 * Added midas' fix for Hammerfall and Adrenaline Rush [celest] * Added 'bDelayrate' and changed Phen card, Marduk Card and Berzebub Card's effects to use this instead of bCastrate (which was reducing casting time, not delay time) [celest] 01/05 * Added DracoRPG's changes [celest] - changed Gungnir to wind element - changed Damascus to cannot be broken 01/04 * item name fix Daydric Card -> Raydric Card [Lupus] Changed weight of Durian,Ramadan,Realgar Wine. Added effect to Durian fruit 01/01 * Included Mages and Wizards to be able to use berserk potions [celest] * Changed some create arrow outputs for new kRO 12/21/04 patch [Aria] 12/29 * Corrected Bloody Axe's weight - 400 > 4000 [celest] * Removed Bandit's Beard from item_avail.txt [celest] 12/28 * Removed Roguemaster's Bow adding steal chance, thanks Draco [celest] 12/26 * Added item_db2.txt - would be more convenient to store custom items in a separate db [celest] 12/21 * Added prices to Arrow Quviers ( = 500* arrow price), fixed few item names (removed '_' from jNAME column), fixed HP amount in Novices Red Potion [Lupus] 12/21 * Added the new Quivers, updated Horse Crest [celest] 12/20 * removed extra {},,,,,,, from each tailing [Lupus] * Corrected job requirements for some garments [celest] * Corrected skill tree requirements for 3 Peco Lord knight skills [celest] * Updated item 569 -> it's a Red potion given to novices if they pass the training grounds test [celest] 12/18 * Lord Knight's Concentration can now be used with any weapon [Aria] * Changed few God-items to fit kRO 12/7/04 Patch [Aria] - Reverted by Celest (sorry, but it's already updated ^^;) * Fixed screwed drops of Kapha (someone removed one number and all data was shifted) [Lupus] * Found one missing item N 569, looks like red Potion. Added a temp plug fixed typo bolt -> Bolt in one scroll [Lupus] BTW I made a TXT Resources merger (it helps merge clients resources itemdesc,etc) so if u need it just tell me 12/17 * Added effect for Deadly poison bottle and Ice cream [celest] 12/15 * Updated Steel Body, Thunderstorm, Investigate and Magic Crasher, thanks to midas * Removed elunium and oridecon from produce_db, thanks to Draco 12/14 * Changed 'Parasite' to non-moving [celest] 12/12 * Removed unuseable skills from skill_tree.txt [celest] 12/11 * Corrected item_db - Wedding rings should give all 3 skills [celest] 12/9 * Removed some unused skills from skill_tree.txt [celest] 12/8 * Capitalised horn_Card in item_db [celest] 12/7 * Fixed some item names (and swpped names of Alarm Mask and Expressionless Mask) [Lupus] * Added effect for Bow Thimble, Archer Skeleton Card and Tribal Solidarity [celest] * Updated Sleipnir, Brisingamen, Mjolnir, Megingord, Counter Dagger, Poison Knife [celest] * Updated SP requirements for Full Strip, Full Chemical Protection, Cannibalize [celest] * Corrected some item_db typos, thanks to DracoRPG 12/6 * Changed spiritball requirements for Chain Crush to 1, thanks to MaoMao of cAthena 12/5 * Edited skill_nocast_db - the skills should be useable outside GvG maps even if woe is on [celest] 12/3 * corrected Spider Web's maximum level [celest] * Removed Soul Drain from Professor's skill tree [celest] * Updated Stunner's job - Acolytes and monks should be able to use it too! [celest] 12/2 * Updated skill tree prerequisites for the new kRO skills [celest] 12/1 * Updated Poison React, Soul Change, Soul Burn [celest] 11/30 * Corrected bUnbreakable value in const.txt [celest] * updated skill_cast_db for Meltdown and Tiger Knuckle Fist [celest] 11/29 * Updated skill_db for Quagmire, Fog Wall [celest] 11/28 * Fixed Wedding rings placement 2->136 [Lupus] * Fixed mob Amon Ra stats/drops [shadow] 11/27 * Fixed some drain rates, fixed Balmung, Mjolnir, fixed all maces (for right jobs) [shadow] 11/26 * Fixed Abrakadabra (3 Yellow Gemstones -> Yellow Gemstones 2). And of course it would still use 1 Yellow even if you have Mistress Card, etc. [Lupus] TODO: Abrakadabra should also summon Monsters and even MVP by chance... * Lowered max level of Oridecon Research skill from 10 to 5 [Lupus] 11/25 * Added element effects to const.txt. [celest] Usage example: sc_start SC_Frost,30000,0; to change the weapon element to Water for 30 seconds. 11/23 * Added temporary requirements for the new guild skills [celest] 11/22 * Changed weapon requirements for Sharp Shooting [celest] * fixed job_db2.txt (,, -> ,) [Lupus] * Adding 11/23 kRO's new skills [celest] * Slim Potions requires empty test tube, not empty potion bottle *fixed* [shadow] 11/21 * added bClassChange to const.txt and added bClassChange,50; to azoth (.5% chance to transform monster into another.) [Valaris] * added mob stats: 1027,Raptice [Lupus] 11/20 - Added deadly poison bottle to produce_db.txt [celest] - Edited ASC_CDP in skill_require_db.txt - Edited ASC_EDP in skill_cast_db.txt 11/17 - Corrected max level for cloaking in skill_tree.txt [celest] 11/16 - Item 7110 fixed name -> Broken Sword (part of Bongun quest) [Lupus] 11/16 - Added BaseJob to const.txt [celest] 11/15 - Minor fix on wedding skills, to use 15% of SP/HP . [shadowlady] - ? 11/14 - Fixed Golden Thief Bug Mode!(+detects hidden) [Lupus]