Is there away and if so how ? menu

Shout-Out

User Tag List

Results 1 to 6 of 6
  1. #1
    Summer's Avatar Active Member
    Reputation
    16
    Join Date
    Sep 2007
    Posts
    308
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Is there away and if so how ?

    U know when u put some thing in ur Database like items and stuff

    Code:
    INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)
         VALUES (99993,2,13,-1,"Tree Guard's Fist","Tree Guard's Fist","Tree Guard's Fist","Tree Guard's Fist",48902,5,0,0000,0000,22,-1,-1,0,80,0,0,0,0,0,0,0,0,1,0, 3,43, 7,58, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,228,396,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1900,0,0,15806,1,0,0,0,0,42974,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,1,0,0,0,0,160,0,0,0,0,0,0,0,0,0,0,0,0,0,0);

    So if i made something im my Database like an Creature can i "De execute" so my creature's so other ppl can Execute them in there database

    Is there away and if so how ?
  2. #2
    pcrew's Avatar Member
    Reputation
    54
    Join Date
    Jun 2008
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    by "de execute" do you mean delete entry ?

  3. #3
    Clain's Avatar Banned
    Reputation
    179
    Join Date
    Jan 2008
    Posts
    1,396
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    No, I think he means export the query into an SQL for other users.

  4. #4
    pcrew's Avatar Member
    Reputation
    54
    Join Date
    Jun 2008
    Posts
    88
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    If he meant that he answered his own question

    Here is the SQL :
    INSERT INTO items (entry, class, subclass, field4, name1, name2, name3, name4, displayid, quality, flags, buyprice, sellprice, inventorytype, allowableclass, allowablerace, itemlevel, requiredlevel, RequiredSkill, RequiredSkillRank, RequiredSkillSubRank, RequiredPlayerRank1, RequiredPlayerRank2, RequiredFaction, RequiredFactionStanding, `Unique`, maxcount, ContainerSlots, stat_type1, stat_value1, stat_type2, stat_value2, stat_type3, stat_value3, stat_type4, stat_value4, stat_type5, stat_value5, stat_type6, stat_value6, stat_type7, stat_value7, stat_type8, stat_value8, stat_type9, stat_value9, stat_type10, stat_value10, dmg_min1, dmg_max1, dmg_type1, dmg_min2, dmg_max2, dmg_type2, dmg_min3, dmg_max3, dmg_type3, dmg_min4, dmg_max4, dmg_type4, dmg_min5, dmg_max5, dmg_type5, armor, holy_res, fire_res, nature_res, frost_res, shadow_res, arcane_res, delay, ammo_type, `range`, spellid_1, spelltrigger_1, spellcharges_1, spellcooldown_1, spellcategory_1, spellcategorycooldown_1, spellid_2, spelltrigger_2, spellcharges_2, spellcooldown_2, spellcategory_2, spellcategorycooldown_2, spellid_3, spelltrigger_3, spellcharges_3, spellcooldown_3, spellcategory_3, spellcategorycooldown_3, spellid_4, spelltrigger_4, spellcharges_4, spellcooldown_4, spellcategory_4, spellcategorycooldown_4, spellid_5, spelltrigger_5, spellcharges_5, spellcooldown_5, spellcategory_5, spellcategorycooldown_5, bonding, description, page_id, page_language, page_material, quest_id, lock_id, lock_material, sheathID, randomprop, unk203_1, block, itemset, MaxDurability, ZoneNameID, mapid, bagfamily, TotemCategory, socket_color_1, unk201_3, socket_color_2, unk201_5, socket_color_3, unk201_7, socket_bonus, GemProperties, ReqDisenchantSkill, unk2)
    VALUES (99993,2,13,-1,"Tree Guard's Fist","Tree Guard's Fist","Tree Guard's Fist","Tree Guard's Fist",48902,5,0,0000,0000,22,-1,-1,0,80,0,0,0,0,0,0,0,0,1,0, 3,43, 7,58, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0, 0,0,228,396,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1900,0,0,15806,1,0,0,0,0,429 74,2,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,1,"",0,0,0,0,0,1,1,0,0,0,0,160, 0,0,0,0,0,0,0,0,0,0,0,0,0,0);

  5. #5
    AsgardCX's Avatar Member
    Reputation
    13
    Join Date
    Dec 2008
    Posts
    114
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Yes, using navicat you can "Dump" your table data. Like this http://img291.imageshack.us/my.php?image=dumpfc1.jpg
    Last edited by AsgardCX; 12-25-2008 at 04:10 PM. Reason: Huh?
    This forums is almost as addicting as chick's n beer! :beerbang:

  6. #6
    Summer's Avatar Active Member
    Reputation
    16
    Join Date
    Sep 2007
    Posts
    308
    Thanks G/R
    0/0
    Trade Feedback
    0 (0%)
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    i mean if i only wanna dump one creature if i open Creature_names and Proto and wanna dump one creature in there

Similar Threads

  1. designer and prgrammer isle, how do i get there?
    By anonymous23 in forum World of Warcraft Emulator Servers
    Replies: 6
    Last Post: 01-03-2008, 06:08 PM
  2. Is there away
    By Snailz in forum World of Warcraft Emulator Servers
    Replies: 5
    Last Post: 12-30-2007, 12:24 PM
  3. Replies: 27
    Last Post: 08-13-2007, 07:03 AM
  4. Naxxramas(Sapphiron and Kelthuzad discovered) how the ****??
    By gotosleep in forum World of Warcraft General
    Replies: 1
    Last Post: 07-25-2006, 04:48 PM
All times are GMT -5. The time now is 07:30 AM. Powered by vBulletin® Version 4.2.3
Copyright © 2025 vBulletin Solutions, Inc. All rights reserved. User Alert System provided by Advanced User Tagging (Pro) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Google Authenticator verification provided by Two-Factor Authentication (Free) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
Digital Point modules: Sphinx-based search