Skip to content

Instantly share code, notes, and snippets.

@PlugFox

PlugFox/guild_storage.csv

Created June 2, 2024 10:56
Show Gist options
  • Save PlugFox/d9aa9cd84e4b2f09abfa2aa6014f4de4 to your computer and use it in GitHub Desktop.
Save PlugFox/d9aa9cd84e4b2f09abfa2aa6014f4de4 to your computer and use it in GitHub Desktop.
Download ZIP
Ragnarok Online: Guild storage
Raw
guild_storage.csv
id amount aegis name type subtype slots
525 16 Panacea Panacea Healing
603 179 Old_Blue_Box Old Blue Box Usable
604 3899 Branch_Of_Dead_Tree Dead Branch Usable
606 701 Aloebera Aloevera Delayconsume
607 1973 Yggdrasilberry Yggdrasil Berry Healing
616 648 Old_Card_Album Old Card Album Usable
617 1494 Old_Violet_Box Old Purple Box Usable
658 45 Union_Of_Tribe Union of Tribe Usable
662 114 Inspector_Certificate Authoritative Badge Usable
665 89 Gift_Box_2 Gift Box Usable
714 28 Emperium Emperium Etc
715 149 Yellow_Gemstone Yellow Gemstone Etc
716 263 Red_Gemstone Red Gemstone Etc
725 83 Red_Jewel Sardonyx Etc
726 1 Blue_Jewel Sapphire Etc
727 154 White_Jewel Opal Etc
728 2 Golden_Jewel Topaz Etc
729 13 Bluish_Green_Jewel Zircon Etc
730 62 Crystal_Jewel 1carat Diamond Etc
731 10 Crystal_Jewel_ 2carat Diamond Etc
732 21 Crystal_Jewel__ 3carat Diamond Etc
743 3 Spore_Doll Spore Doll Etc
753 1 Monkey_Doll Yoyo Doll Etc
756 328 Oridecon_Stone Rough Oridecon Etc
757 3812 Elunium_Stone Rough Elunium Etc
909 24 Jellopy Jellopy Etc
911 123 Scell Scell Etc
912 933 Zargon Zargon Etc
914 2 Fluff Fluff Etc
931 160 Orcish_Voucher Orcish Voucher Etc
938 645 Sticky_Mucus Sticky Mucus Etc
971 84 Detrimindexta Detrimindexta Etc
972 3 Karvodailnirol Karvodailnirol Etc
975 1 Scarlet_Dyestuffs Scarlet Dyestuffs Etc
976 3 Lemon_Dyestuffs Lemon Dyestuffs Etc
980 1 Orange_Dyestuffs Orange Dyestuffs Etc
982 3 White_Dyestuffs White Dyestuffs Etc
984 259 Oridecon Oridecon Etc
985 1280 Elunium Elunium Etc
990 20 Boody_Red Red Blood Etc
991 2 Crystal_Blue Crystal Blue Etc
992 21 Wind_Of_Verdure Wind of Verdure Etc
993 2169 Yellow_Live Green Live Etc
994 106 Flame_Heart Flame Heart Etc
995 1 Mistic_Frozen Mystic Frozen Etc
996 111 Rough_Wind Rough Wind Etc
997 537 Great_Nature Great Nature Etc
999 84 Steel Steel Etc
1000 2090 Star_Crumb Star Crumb Etc
1001 647 Sparkling_Dust Star Dust Etc
1002 270 Iron_Ore Iron Ore Etc
1003 153 Coal Coal Etc
1008 8 Frozen_Heart Necklace of Oblivion Etc
1009 13 Sacred_Marks Hand of God Etc
1019 104 Wooden_Block Trunk Etc
1030 11 Tiger_Footskin Tiger's Footskin Etc
1035 64 Dragon_Canine Dragon Canine Etc
1036 360 Dragon_Scale Dragon Scale Etc
1038 8 Petite_DiablOfs_Horn Little Evil Horn Etc
1039 120 Petite_DiablOfs_Wing Little Evil Wing Etc
1059 4 Transparent_Cloth Fabric Etc
1065 83 Booby_Trap Trap Etc
1095 42 Needle_Of_Alarm Needle of Alarm Etc
1097 1 Worn_Out_Page Worn Out Page Etc
1140 2 Byeorrun_Gum Byeollungum Weapon 1hSword
1170 1 Katzbalger Katzbalger Weapon 2hSword
1181 1 Tae_Goo_Lyeon Tae Goo Lyeon Weapon 2hSword 2
1182 1 Bloody_Eater Bloody Eater Weapon 2hSword 2
1191 3 Alca_Bringer Alca Bringer Weapon 2hSword
1196 2 Chrome_Twohand_Sword Chrome Two-Handed Sword Weapon 2hSword
1223 2 Forturn_Sword Fortune Sword Weapon Dagger
1237 1 Grimtooth_ Grimtooth Weapon Dagger
1242 1 Counter_Dagger Dagger of Counter Weapon Dagger
1261 1 Infiltrator Infiltrator Weapon Katar
1307 1 Windhawk Windhawk Weapon 1hAxe
1387 11 Giant_Axe Giant Axe Weapon 2hAxe 1
1417 3 Pole_Axe Pole Axe Weapon 1hSpear 1
1433 2 Imperial_Spear Imperial Spear Weapon 1hSpear 1
1466 1 Crescent_Scythe Crescent Scythe Weapon 2hSpear
1528 1 Grand_Cross Grand Cross Weapon Mace
1552 4 Tablet Tablet Weapon Book 1
1565 3 Death_Note Ledger of Death Weapon Book 2
1584 1 Chilly_Spell_Book Cold Magic Book Weapon Book 2
1646 1 La'cryma_Stick La'cryma Stick Weapon Staff 2
1661 1 Mental_Destroyer Mental Destroyer Weapon Staff
1668 1 Sword_Stick Sword Stick Weapon Staff 2
1734 1 Orc_Archer_Bow Orc Archer Bow Weapon Bow
1746 2 Elven_Bow Elven Bow Weapon Bow 1
1830 1 Sura_Rampage Sura Rampage Weapon Knuckle 1
1959 1 Tail_ Tail Whip Weapon Whip 2
2000 1 Destruction_Rod Staff of Destruction Weapon 2hStaff 1
2115 3 Valkyrja's_Shield Valkyrja's Shield Armor 1
2123 1 Orleans_Server Orleans's Server Armor 1
2131 1 Magic_Study_Vol1 Magic Bible Vol1 Armor 1
2153 2 Imperial_Guard Imperial Guard Armor 1
2249 1 Coronet Coronet Armor
2255 1 Satanic_Chain Evil Wing Armor
2354 4 Goibne's_Armor Goibne's Armor Armor
2357 1 Valkyrie_Armor Valkyrian Armor Armor 1
2375 1 Diabolus_Armor Diabolus Armor Armor 1
2419 2 Goibne's_Combat_Boots Goibne's Greaves Armor
2423 1 Variant_Shoes Variant Shoes Armor
2440 1 Sprint_Shoes Sprint Shoes Armor 1
2499 1 Temporal_Boots Temporal Boots Armor
2520 2 Goibne's_Shoulder_Arms Goibne's Spaulders Armor
2527 12 Dragon_Breath Dragon Breath Armor 1
2607 6 Clip Clip Armor 1
2615 3 Safety_Ring Safety Ring Armor
2648 1 Morpheus's_Ring Morpheus's Ring Armor
2649 1 Morpheus's_Armlet Morpheus's Bracelet Armor
2650 1 Morrigane's_Belt Morrigane's Belt Armor
2651 1 Morrigane's_Pendant Morrigane's Pendant Armor
2678 1 Ring_Of_Flame_Lord Ring Of Flame Lord Armor
2679 1 Ring_Of_Resonance Ring Of Resonance Armor
2701 3 Orleans_Glove Orleans's Glove Armor 1
2702 1 Bison_Horn Bison Horn Armor 1
2729 1 Diabolus_Ring Diabolus Ring Armor 1
2861 1 Crimson_Orb Crismon Orb Armor
4002 3 Fabre_Card Fabre Card Card
4005 4 Poring__Card Santa Poring Card Card
4006 1 Lunatic_Card Lunatic Card Card
4010 1 Wilow_Card Willow Card Card
4012 4 Thief_Bug_Egg_Card Thief Bug Egg Card Card
4013 2 Andre_Egg_Card Andre Egg Card Card
4016 37 Thief_Bug_Card Thief Bug Card Card
4019 1 Hornet_Card Hornet Card Card
4020 2 Farmiliar_Card Familiar Card Card
4022 11 Spore_Card Spore Card Card
4025 1 Skeleton_Card Skeleton Card Card
4026 6 Thief_Bug_Female_Card Female Thief Bug Card Card
4035 29 Hydra_Card Hydra Card Card
4037 1 Snake_Card Snake Card Card
4038 1 Zombie_Card Zombie Card Card
4043 36 Andre_Card Andre Card Card
4044 1 Smokie_Card Smokie Card Card
4047 1 Ghostring_Card Ghostring Card Card
4049 1 Vadon_Card Vadon Card Card
4050 10 Thief_Bug_Male_Card Male Thief Bug Card Card
4053 3 Vitata_Card Vitata Card Card
4058 1 Thara_Frog_Card Thara Frog Card Card
4066 13 Orc_Warrior_Card Orc Warrior Card Card
4069 12 Drainliar_Card Drainliar Card Card
4075 1 Argos_Card Argos Card Card
4077 2 Phen_Card Phen Card Card
4078 2 Savage_Card Savage Card Card
4079 1 Mantis_Card Mantis Card Card
4083 1 Rafflesia_Card Rafflesia Card Card
4086 1 Soldier_Skeleton_Card Soldier Skeleton Card Card
4087 1 Giearth_Card Giearth Card Card
4089 2 Sword_Fish_Card Swordfish Card Card
4094 1 Archer_Skeleton_Card Archer Skeleton Card Card
4098 3 Dokebi_Card Dokebi Card Card
4102 4 Whisper_Card Whisper Card Card
4103 5 Horong_Card Horong Card Card
4105 2 Marc_Card Marc Card Card
4107 11 Verit_Card Verit Card Card
4110 7 Ghoul_Card Ghoul Card Card
4113 1 Marionette_Card Marionette Card Card
4114 3 Argiope_Card Argiope Card Card
4115 2 Hunter_Fly_Card Hunter Fly Card Card
4116 2 Isis_Card Isis Card Card
4117 7 Side_Winder_Card Sidewinder Card Card
4122 15 Deviruchi_Card Deviruchi Card Card
4123 6 Eddga_Card Eddga Card Card
4127 1 Nightmare_Card Nightmare Card Card
4128 6 Golden_Bug_Card Golden Thief Bug Card Card
4131 2 Moonlight_Flower_Card Moonlight Flower Card Card
4132 12 Mistress_Card Mistress Card Card
4135 4 Orc_Load_Card Orc Lord Card Card
4137 1 Drake_Card Drake Card Card
4140 1 Knight_Of_Abyss_Card Abysmal Knight Card Card
4141 1 Evil_Druid_Card Evil Druid Card Card
4143 8 Orc_Hero_Card Orc Hero Card Card
4144 3 Osiris_Card Osiris Card Card
4146 6 Maya_Card Maya Card Card
4147 2 Baphomet_Card Baphomet Card Card
4148 2 Pharaoh_Card Pharaoh Card Card
4149 5 Gargoyle_Card Gargoyle Card Card
4158 1 Flying_Deleter_Card Sky Deleter Card Card
4166 2 Nightmare_Terror_Card Nightmare Terror Card Card
4168 1 Dark_Lord_Card Dark Lord Card Card
4169 2 Dark_Illusion_Card Dark Illusion Card Card
4170 1 Dark_Frame_Card Dark Frame Card Card
4171 1 Dark_Priest_Card Dark Priest Card Card
4175 3 Poison_Toad_Card Poisonous Toad Card Card
4180 14 Driller_Card Driller Card Card
4183 1 Vagabond_Wolf_Card Vagabond Wolf Card Card
4189 1 Wraith_Dead_Card Wraith Dead Card Card
4196 8 Marin_Card Marin Card Card
4203 1 Mutant_Dragon_Card Mutant Dragonoid Card Card
4205 20 Mimic_Card Mimic Card Card
4207 1 Mysteltainn_Card Mysteltainn Card Card
4215 1 Blazzer_Card Blazer Card Card
4216 1 Sasquatch_Card Sasquatch Card Card
4223 257 Stalactic_Golem_Card Stalactic Golem Card Card
4234 41 Anolian_Card Anolian Card Card
4236 5 Amon_Ra_Card Amon Ra Card Card
4240 10 Arclouse_Card Arclouze Card Card
4243 1 Antonio_Card Antonio Card Card
4248 3 Ancient_Mummy_Card Ancient Mummy Card Card
4255 11 Orc_Lady_Card Orc Lady Card Card
4271 2 Giant_Honet_Card Giant Hornet Card Card
4272 1 Dancing_Dragon_Card Zhu Po Long Card Card
4274 2 Zombie_Master_Card Zombie Master Card Card
4279 2 Deleter_Card Earth Deleter Card Card
4283 3 Greatest_General_Card Greatest General Card Card
4289 1 Caterpillar_Card Caterpillar Card Card
4290 1 Cat_O_Nine_Tail_Card Cat O' Nine Tails Card Card
4295 1 Kraben_Card Kraben Card Card
4296 3 Cramp_Card Cramp Card Card
4298 1 Cremy_Fear_Card Creamy Fear Card Card
4300 4 Chimera_Card Chimera Card Card
4304 3 Tamruan_Card Tamruan Card Card
4306 1 Toad_Card Toad Card Card
4307 2 Kind_Of_Beetle_Card Beetle King Card Card
4308 78 Tri_Joint_Card Tri Joint Card Card
4324 4 Garm_Card Hatii Card Card
4332 1 Waste_Stove_Card Waste Stove Card Card
4333 2 Venomous_Card Venomous Card Card
4334 1 Noxious_Card Noxious Card Card
4339 1 Mineral_Card Mineral Card Card
4340 1 Teddy_Bear_Card Teddy Bear Card Card
4342 1 Rsx_0806_Card RSX-0806 Card Card
4369 2 Venatu_Card Venatu Card Card
4373 4 Chung_E_Card Green Maiden Card Card
4374 1 Apocalips_H_Card Vesper Card Card
4376 2 Lady_Tanee_Card Lady Tanee Card Card
4378 22 Acidus_Card Gold Acidus Card Card
4379 4 Acidus__Card Blue Acidus Card Card
4380 3 Ferus_Card Red Ferus Card Card
4381 1 Ferus__Card Green Ferus Card Card
4384 12 Hydro_Card Hydrolancer Card Card
4385 3 Dragon_Egg_Card Dragon Egg Card Card
4386 2 Detale_Card Detardeurus Card Card
4387 1 Ancient_Mimic_Card Ancient Mimic Card Card
4391 1 Retribution_Card Baroness of Retribution Card Card
4401 4 Alicel_Card Alicel Card Card
4402 2 Aliot_Card Aliot Card Card
4426 1 Byorgue_Card Byorgue Card Card
4427 3 Sword_Guardian_Card Sword Guardian Card Card
4428 1 Bow_Guardian_Card Bow Guardian Card Card
4429 12 Salamander_Card Salamander Card Card
4431 4 Kasa_Card Kasa Card Card
4440 5 Necromancer_Card Necromancer Card Card
4450 1 Banshee_Master_Card Banshee Master Card Card
4459 1 Lata_Card Rata Card Card
4473 1 Ancient_Tree_Card Ancient Tree Card Card
4505 2 Scaraba_Card Scaraba Card Card
4508 354 Gold_Scaraba_Card Gold Scaraba Card Card
4509 2 Gold_Q_Scaraba_Card Gold Queen Scaraba Card Card
4545 1 Novice_Poring_Card Novice Poring Card Card
4596 2 AntiqueBook_Card Antique Book Card Card
4627 3 Big_Bell_Card Big Bell Card Card
4628 1 Neo_Punk_Card Neo Punk Card Card
5127 1 Morrigane's_Helm Morrigane's Helm Armor
5128 1 Goibne's_Helmet Goibne's Helm Armor
5160 1 Magestic_Goat_ Majestic Goat Armor 1
5808 1 Diabolus_Helmet Dark Bacilium Armor 1
6004 1 Bapho_Doll Cursed Baphomet Doll Etc
6008 1 Wood Wood Etc
6108 3 Apple_Pudding Apple Pudding Etc
6212 10 Bomb_Mushroom_Spore Bomb Mushroom Spore Etc
6214 82 Smoke_Powder Smoke Powder Etc
6216 9 Oil_Bottle Oil Bottle Etc
6223 25 Carnium Carnium Etc
6224 107 Bradium Bradium Etc
6245 2 Black_Powder Black Powder Etc
6249 9 Savage_Meat Savage Meat Etc
6253 75 Cold_Ice Cold Ice Etc
6323 5 Twinhorn_Helm Two-Horned Helmet Etc
6469 7 Will_Of_Warrior Warrior's Will Etc
6607 1 Temporal_Crystal Temporal Crystal Etc
6608 17 Coagulated_Spell Coagulated Spell Etc
6635 5 Blacksmith_Blessing Blacksmith Blessing Etc
7005 124 Skull Skull Etc
7026 11 Key_Of_Clock_Tower Key of Clock Tower Etc
7063 2 Soft_Feather Soft Feather Etc
7073 13 Jewel_Of_Prayer Freya's Jewel Etc
7074 2 Iron_Glove Thor's Gauntlets Etc
7075 7 Iron_Maiden Iron Maiden Etc
7076 12 Mystery_Wheel Wheel of the Unknown Etc
7077 10 Silver_Fancy Silver Ornament Etc
7078 5 Anger_Of_Valkurye Wrath of Valkyrie Etc
7079 11 Feather_Of_Angel Feather of Angel Wing Etc
7081 2 Beard_Of_Women Woman's Moustache Etc
7082 1 Root_Of_Stone Root of Stone Etc
7083 10 Soul_Of_Fish Spirit of Fish Etc
7084 5 Saliva_Of_Bird Sputum of Bird Etc
7085 6 Tendon_Of_Bear Sinew of Bear Etc
7086 8 Symbol_Of_Sun Emblem of the Sun God Etc
7087 13 Breath_Of_Soul Breath of Spirit Etc
7088 20 Crystal_Of_Snow Snow Crystal Etc
7089 6 Indication_Of_Tempest Omen of Tempest Etc
7090 16 Slilince_Wave Ripple Etc
7091 11 Rough_Billows Billow Etc
7092 15 Air_Stream Drifting Air Etc
7095 2 Broken_Steel_Piece Metal Fragment Etc
7135 1 Fire_Bottle Bottle Grenade Etc
7137 2 MenEater_Plant_Bottle Plant Bottle Etc
7139 2 Coating_Bottle Glistening Coat Etc
7140 31 Seed_Of_Life Seed of Life Etc
7165 2 Limpid_Celestial_Robe Transparent Celestial Robe Etc
7190 52 Solid_Peeling Solid Husk Etc
7202 52 Beetle_Nipper Pincher of Beetle Etc
7297 2 Biotite Biotite Etc
7299 12 Bamboo_Basket Straw Basket Etc
7301 38 Sword_Accessory Tassel Etc
7317 28 Screw Rusty Screw Etc
7319 4 Old_Steel_Plate Used Iron Plate Etc
7345 3 Armlet_Of_Prisoner Handcuffs Etc
7347 4 Lab_Staff_Record Research Chart Etc
7352 1 Transparent_Plate01 Transparent Plate Etc
7353 1 Transparent_Plate02 Transparent Plate Etc
7356 10 Piece_Of_Crest1 Crest Piece Etc
7357 9 Piece_Of_Crest2 Crest Piece Etc
7358 6 Piece_Of_Crest3 Crest Piece Etc
7359 3 Piece_Of_Crest4 Crest Piece Etc
7443 59 Tri_Headed_Dragon_Head Three-Headed Dragon's Head Etc
7444 7 Treasure_Box Treasure Box Etc
7445 85 Dragonball_Green Green Bijou Etc
7446 75 Dragonball_Blue Blue Bijou Etc
7447 47 Dragonball_Red Red Bijou Etc
7448 263 Dragonball_Yellow Yellow Bijou Etc
7477 15 Cookbook06 Level 6 Cookbook Etc
7507 107 Sturdy_Iron_Piece Solid Iron Piece Etc
7511 25 Rune_Of_Darkness Rune of Darkness Etc
7512 78 Burnt_Parts Burnt Part Etc
7513 1 Pocket_Watch__ Pocket Watch Etc
7642 101 Bloody_Coin Bloody Coin Etc
7934 14 Poison_Herb_Makulata Poison Herb Makulata Etc
7938 377 Light_Granule Light Granule Etc
7940 5 Special_Alloy_Trap Special Alloy Trap Etc
10038 1 Horn_Protector Horn Barrier Petarmor
11003 1 Legend_Of_Kafra01 Kafra Legend Vol.1 Etc
12074 19 Str_Dish09 Tendon Satay Healing
12085 52 Vit_Dish10 Immortal Stew Healing
12090 1 Agi_Dish10 Steamed Desert Scorpions Healing
12103 45 Bloody_Dead_Branch Bloody Branch Usable
12106 5 Accessory_Box Jewelry Box Usable
12107 1332 Wrapped_Mask Wrapped Mask Usable
12128 17 Imperial_Cooking_Kits Royal Cooking Kit Usable
12129 1 Fantastic_Cooking_Kits Fantastic Cooking Kit Usable
12132 1 Red_Bag Santa's Bag Usable
12210 22 Bubble_Gum Bubble Gum Usable
12215 1 Blessing_10_Scroll LV10 Blessing Scroll Usable
12246 23 Magic_Card_Album Mystical Card Album Usable
12623 57 High_Weapon_Box Advanced Weapons Box Usable
12674 27 God_Material_Box God Material Box Usable
12675 7 Sg_Weapon_Supply_Box WoE Weapon Supply Box Usable
12735 1718 Runstone_Ancient Ancient Rune Healing
13017 3 House_Auger_ Ice Pick Weapon Dagger 1
13414 1 Elemental_Sword Elemental Sword Weapon 1hSword 3
13421 1 Ruber Ruber Weapon 1hSword 1
14194 1 F_Blessing10_Box50 Lv10 Blessing Scroll Box 50 Cash
15089 1 Menswear Menswear Armor
15378 4 Lava_Leather_Armor Lava Leather Armor Armor 1
15379 1 Lava_Leather_Suit Lava Leather Suit Armor 1
15380 4 Lava_Leather_Robe Lava Leather Robe Armor 1
16003 1 Carga_Mace Carga Mace Weapon Mace 2
18000 1 Cannon_Ball Cannon Ball Ammo Cannonball
18002 1 Dark_Cannon_Ball Dark Cannon Ball Ammo Cannonball
18004 1 Iron_Cannon_Ball Iron Cannon Ball Ammo Cannonball
18103 3 Mystic_Bow Mystic Bow Weapon Bow
18110 1 Big_CrossBow Giant Crossbow Weapon Bow 2
18874 6 One_Eyed_Glass_ Monocle Armor 1
19090 4 Alarm_Mask_ Alarm Mask Armor 1
19914 1 Felock_Cap Felrock's Hat Armor
20935 1 Lava_Leather_Manteau Lava Leather Manteau Armor 1
20937 1 Lava_Leather_Hood Lava Leather Hood Armor 1
22200 4 Lava_Leather_Shoes Lava Leather Shoes Armor 1
22201 4 Lava_Leather_Sandals Lava Leather Sandals Armor 1
22515 10 Key_Of_Twisted_Time Twisted Key of Time Delayconsume
23815 39 Magma_Essence Lava Essence Delayconsume
25127 1 Silent_Energy_Particle Silent Energy Particle Etc
25128 1 Weak_Energy_Particle Weak Energy Particle Etc
25129 6 Unstable_Energy_Particle Unstable Energy Particle Etc
25272 73 Illusion_Gemstone Illusion Gemstone Etc
25311 122 Piece_of_Black_Horn Piece of Black Horn Etc
25313 107 Old_Shell Old Shell Etc
25638 89 Token_Of_Bigstone Megalithic Token Etc
25640 30 Pot_Stone Potted Stone Etc
25641 36 Hard_Mud Hard Mud Etc
25642 38 Weak_Worm Vulnerable Worm Etc
25728 473 Shadowdecon_Ore Rough Shadowdecon Etc
25729 2 Shadowdecon Shadowdecon Etc
25730 561 Zelunium_Ore Rough Zelunium Etc
25731 1 Zelunium Zelunium Etc
27029 1 Fire_Golem_Card Fire Golem Card Card
27114 3 Ominous_Solider_Card Ominous Solider Card Card
27115 1 Ominous_Permeter_Card Ominous Permeter Card Card
27116 1 Ominous_Heater_Card Ominous Heater Card Card
27117 1 Ominous_Assaulter_Card Ominous Assaulter Card Card
27118 1 Ominous_Freezer_Card Ominous Freezer Card Card
27179 1 Coyote_Card Coyote Card Card
27181 8 AirShip_Raid_Card Airship Raid Card Card
27291 4 Ancient_Tri_Joint_Card Ancient Tri Joint Card Card
27292 3 Ancient_Stalactic_Golem_Card Ancient Stalactic Golem Card Card
27293 1 Ancient_Megalith_Card Ancient Megalith Card Card
27311 1 Mutant_Plaga_Card Mutant Plaga Card Card
27347 2 Rigid_Kaho_Card Rigid Kaho Card Card
27348 3 Rigid_Lava_Golem_Card Rigid Lava Golem Card Card
27349 2 Rigid_Explosion_Card Rigid Explosion Card Card
27350 7 Rigid_Earth_Deleter_Card Rigid Earth Deleter Card Card
27351 12 Rigid_Sky_Deleter_Card Rigid Sky Deleter Card Card
27352 2 Rigid_Nightmare_Terror_Card Rigid Nightmare Terror Card Card
27353 2 Rigid_Blazer_Card Rigid Blazer Card Card
28619 3 Prisoner_Diary Prisoner's Diary Weapon Book 2
31017 1 XM_Cookie_Card Vicious Cookie Card Card
31018 4 XM_Mystcase_Card Evil Dwelling Box Card Card
31019 2 XM_Lude_Card Creepy Demon Card Card
31020 1 XM_Hylozoist_Card Malicious Baby Ghost Card Card
31021 2 XM_Marionette_Card Dancing Marionette Card Card
31022 1 XM_Teddy_Bear_Card Abandoned Teddy Bear Card Card
300011 1 Holy_Frus_Card Holy Frus Card Card
300111 1 Bellare3_Card Elite Bellare Card Card
300114 1 Plaga3_Card Magic-poisoned Plaga Card Card
300140 1 ILL_Sropho_Card Deep Sea Sropho Card Card
300143 1 ILL_Marse_Card Deep Sea Marse Card Card
300258 1 aegis_300258 Lavaeter Card Card
1000276 1 Flame_Acid_Bottle Flame Acid Bottle Etc
1000280 3 High_Coating_Bottle Advanced Coating Potion Etc
1000281 3 High_Plant_Bottle Greater Plant Bottle Etc
Raw
guild_storage.sql
SELECT
gs.id AS id,
gs.amount AS amount,
items.name_aegis AS aegis,
items.name_english AS name,
items.type AS type,
items.subtype AS subtype,
items.slots AS slots
FROM
(
SELECT
nameid AS id,
SUM(amount) AS amount
FROM guild_storage
WHERE guild_id = 2
GROUP BY nameid
) AS gs
LEFT JOIN item_db_re AS items
ON gs.id = items.id
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment