[Mangos 3.2.2a] SQL Inserts Mangos 

Skilled Illusionist
Joined
Jun 12, 2007
Messages
305
Reaction score
6
[Mangos 3.2.2a / 3.3.2] SQL Inserts

As of right now. I've not really dug into doing alot of SQL inserts. I will continue to add more as I dig more into the process.

SQL Inserts for A Better Blizz/Fun Server.

These codes are for the Following server specs.

Server : Mangos
Version : Revision 8990+
DBase type : ???????
DBase version : ???????
ScriptDev version : ScriptDev2 (for MaNGOS 8900+)
Client version : 3.2.2a(10505)

Update:
Trainers - Vendors-3.3.2.sql
Tier_Supplies-3.3.2.sql
Thunder Sword INSERT INTO - Main-Hand-3.3.2.sql
Client version : 3.3.2(11403)

Includes: Items
Item: Sword - Thunder "Various" - Removed none working Spell
ID's: 185,186,187,188,189,190,191,192
ADD: .npc additem ### - While NPC is selected

Notes:
  1. If you wish to have them in both hands. Insert the "Thunder Sword UPDATE - One- Hand.sql" After the "Thunder Sword INSERT INTO - Main-Hand.sql"
  2. The thunder sword is hard coded into the core of mangos. Thus the reason for the error when loading the mangos core. They will also have no icon in the bags. Also they will have to be dragged and drop into ones Char'

Includes: Tele NPC
NPC: Slappy McFry - Fixed for mangos 3.2.2a
ID's: 99001
Spawn: .npc add 99001
Locations: Stormwind, Menethil Harbor, GM Island, Darnassus,

WORK In PROGRESS
Includes: GM Island Scripts
Portals from GM Island: Booty Bay, Darkshore, Exodar Habour, Felwood, Grom Gol Base Camp, Minithel Habour, Orgrimmar, Ratchet, Theramore Island, Undercity
Portals to GM Island: GM Island Shopping - All start Areas
Game Objects: Elevator, Wagons, Boats, Boards - Boards to the boats. - To have 2 boats edit the sql file.
INSERTING these SQL's require the BOAT SQL
Trainers: All Classes - Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warrior, Warlock,
Trainers: All Races - Weapons
Vendor/Trainer: Fishing Trainer & Supplies, Riding Trainer & Mounts
Vendor:
World Trade Supplies - Has some supplies but, Not Finished
World BagSmith - 11 Pages of Bags, Packs, Pouchs, Sacks, Satchels
World GunSmith - 11 Pages of Guns, Rifles, Blunderbusses, Ammo, Ammo - Sacks, Pouch's
World BowSmith - 13 Pages of Bows, Crossbows, Quivers, Ammo

Trainers - Vendors.sql
Tier_Supplies.sql
OLD:
Tier Vendors
Borat: Tier 1 - Requires Gold
Viarra: Tier 2 - Requires Gold
Xaranna: Tier 3 - Requires Gold
Tsubassa: Tier 4 - Requires Trade
Corina: Tier 5 - Requires Trade
Xavi: Tier 6 - Requires Trade
Zara: Low Level Sets - Requires Gold
Zareline: Dungeon 1 - Requires Gold - No longer called Mother "STUPID Name"
Zeron: Dungeon 2 - Requires Gold - No longer called Father "STUPID Name"
Zar: Dungeon 3 - Requires Gold - Fixed Order
Shin'to: Highlevel Stuff - Requires Trade


NEW:
Vendors
'Oweiru', 'Legendary' - Requires Gold / Trade - Fixed Suuplies
'Garnet', 'World High level Cloak' - Requires Gold / Trade
'Zira', 'World Necklace' - Requires Gold / Trade
'Corrine', 'World Ring 1'
'Shieka', 'World Ring 2'
'Damien', 'World Ring 3' - Requires Gold / Trade
'Link', 'World Trinket' - Requires Gold / Trade
'Navi', 'World Librams, Idols and Totems' - Requires Gold / Trade
'Mnu', 'World 1H Swords' - Requires Gold / Trade
'Vae', 'World 2H Swords' - Requires Gold / Trade
'Orisx', 'World 1H Axe' - Requires Gold / Trade
'Eitad', 'World 2H Axe' - Requires Gold / Trade
'Norverth', 'World 1H Mace' - Requires Gold / Trade
'Germar', 'World 2H Mace' - Requires Gold / Trade
'Iri', 'World Guns' - Requires Gold / Trade
'Lulu', 'World Polearms' - Requires Gold / Trade
'Gandalf', 'World Fist' - Requires Gold / Trade
'Zidane', 'World Dagger' - Requires Gold / Trade
'Skye', 'World Bow' - Requires Gold / Trade
'Sol', 'World Crossbow' - Requires Gold / Trade
'Drake', 'World Wand' - Requires Gold / Trade

Update Intructions:
Re-Apply
Trainers - Vendors.sql
Tier_Supplies.sql


Instructions.
Load SQL's into Mangos DB
Restart server
Ingame Restart - .server restart ## - Example: .server restart 10 - Restarts in 10 seconds

VISIT GM Island - .tele gmisland

These SQL Scripts works fine with http://forum.ragezone.com/f436/mangos-ytdb-full-dual-spec-ah-anticheat-626665/
 

Attachments

Last edited:
Update - GM Island Scripts
Portals from GM Island: Booty Bay, Darkshore, Exodar Habour, Felwood, Grom Gol Base Camp, Minithel Habour, Orgrimmar, Ratchet, Theramore Island, Undercity
Portals to GM Island: GM Island Shopping - All start Areas
Game Objects: Elevator, Wagons, Boats, Boards - Boards to the boats. - To have 2 boats edit the sql file.
INSERTING these SQL's require the BOAT SQL
Trainers: All Classes - Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warrior, Warlock,
Trainers: All Races - Weapons
Vendor/Trainer: Fishing Trainer & Supplies, Riding Trainer & Mounts
Vendor:
World Trade Supplies - Has some supplies but, Not Finished
World BagSmith - 11 Pages of Bags, Packs, Pouchs, Sacks, Satchels
World GunSmith - 11 Pages of Guns, Rifles, Blunderbusses, Ammo, Ammo - Sacks, Pouch's
World BowSmith - 13 Pages of Bows, Crossbows, Quivers, Ammo


NEW:
Tier Vendors
Borat: Tier 1 - Requires Gold
Viarra: Tier 2 - Requires Gold
Xaranna: Tier 3 - Requires Gold
Tsubassa: Tier 4 - Requires Trade
Corina: Tier 5 - Requires Trade
Xavi: Tier 6 - Requires Trade
 

Attachments

  • WoWScrnShot_122009_212201 - [Mangos 3.2.2a] SQL Inserts - RaGEZONE Forums
    WoWScrnShot_122009_212201.webp
    74.4 KB · Views: 1,131
  • WoWScrnShot_122009_212535 - [Mangos 3.2.2a] SQL Inserts - RaGEZONE Forums
    WoWScrnShot_122009_212535.webp
    65.5 KB · Views: 1,111
Last edited:
Trainers - Vendors.sql
Tier_Supplies.sql


OLD:
Tier Vendors
Borat: Tier 1 - Requires Gold
Viarra: Tier 2 - Requires Gold
Xaranna: Tier 3 - Requires Gold
Tsubassa: Tier 4 - Requires Trade
Corina: Tier 5 - Requires Trade
Xavi: Tier 6 - Requires Trade

NEW:
Tier Vendors
Zara: Low Level Sets - Requires Gold
Zareline: Dungeon 1 - Requires Gold - No longer called Mother "STUPID Name"
Zeron: Dungeon 2 - Requires Gold - No longer called Father "STUPID Name"
Zar: Dungeon 3 - Requires Gold - Fixed Order
Shin'to: Highlevel Stuff - Requires Trade
Vendors
Oweiru: Legendary - Requires Gold

Update Intructions:
Re-Apply
Trainers - Vendors.sql
Tier_Supplies.sql
 

Attachments

  • WoWScrnShot_123109_144020 - [Mangos 3.2.2a] SQL Inserts - RaGEZONE Forums
    WoWScrnShot_123109_144020.webp
    53.2 KB · Views: 1,074
  • WoWScrnShot_123109_150040 - [Mangos 3.2.2a] SQL Inserts - RaGEZONE Forums
    WoWScrnShot_123109_150040.webp
    35.5 KB · Views: 1,063
  • WoWScrnShot_123109_150156 - [Mangos 3.2.2a] SQL Inserts - RaGEZONE Forums
    WoWScrnShot_123109_150156.webp
    45.1 KB · Views: 1,061
Last edited:
Trainers - Vendors.sql
Tier_Supplies.sql
OLD:
Tier Vendors
Borat: Tier 1 - Requires Gold
Viarra: Tier 2 - Requires Gold
Xaranna: Tier 3 - Requires Gold
Tsubassa: Tier 4 - Requires Trade
Corina: Tier 5 - Requires Trade
Xavi: Tier 6 - Requires Trade
Zara: Low Level Sets - Requires Gold
Zareline: Dungeon 1 - Requires Gold - No longer called Mother "STUPID Name"
Zeron: Dungeon 2 - Requires Gold - No longer called Father "STUPID Name"
Zar: Dungeon 3 - Requires Gold - Fixed Order
Shin'to: Highlevel Stuff - Requires Trade


NEW:
Vendors
'Oweiru', 'Legendary' - Requires Gold / Trade - Fixed Suuplies
'Garnet', 'World High level Cloak' - Requires Gold / Trade
'Zira', 'World Necklace' - Requires Gold / Trade
'Corrine', 'World Ring 1'
'Shieka', 'World Ring 2'
'Damien', 'World Ring 3' - Requires Gold / Trade
'Link', 'World Trinket' - Requires Gold / Trade
'Navi', 'World Librams, Idols and Totems' - Requires Gold / Trade
'Mnu', 'World 1H Swords' - Requires Gold / Trade
'Vae', 'World 2H Swords' - Requires Gold / Trade
'Orisx', 'World 1H Axe' - Requires Gold / Trade
'Eitad', 'World 2H Axe' - Requires Gold / Trade
'Norverth', 'World 1H Mace' - Requires Gold / Trade
'Germar', 'World 2H Mace' - Requires Gold / Trade
'Iri', 'World Guns' - Requires Gold / Trade
'Lulu', 'World Polearms' - Requires Gold / Trade
'Gandalf', 'World Fist' - Requires Gold / Trade
'Zidane', 'World Dagger' - Requires Gold / Trade
'Skye', 'World Bow' - Requires Gold / Trade
'Sol', 'World Crossbow' - Requires Gold / Trade
'Drake', 'World Wand' - Requires Gold / Trade

Update Intructions:
Re-Apply
Trainers - Vendors.sql
Tier_Supplies.sql
 

Attachments

  • WoWScrnShot_010210_201332 - [Mangos 3.2.2a] SQL Inserts - RaGEZONE Forums
    WoWScrnShot_010210_201332.webp
    51.4 KB · Views: 1,084
and where are blizzlike inserts?

Zara is the Blizzlike Tier vendor



Update:
Trainers - Vendors-3.3.2.sql
Tier_Supplies-3.3.2.sql
Thunder Sword INSERT INTO - Main-Hand-3.3.2.sql
Client version : 3.3.2(11403)

All other SQL's still apply for 3.3.2(11403)
 
Last edited:
Thanks for the release! Love it, modded it a bit too.

A good option is to replace your trainers with the IsleOfMasters (scriptdev scripts) ones like i did, save having 10000,00000 NPCs training different classes.
 
Hello I put these updates on GM island and the other version of 9560 and started giving me two errors.

Loading Items...
==================================================== 100%
>> Loaded 37097 item prototypes

Item (Entry: 175) not correct (not listed in list of existed items).
Item (Entry: 176) not correct (not listed in list of existed items).
Item (Entry: 177) not correct (not listed in list of existed items).
Item (Entry: 178) not correct (not listed in list of existed items).
Item (Entry: 185) not correct (not listed in list of existed items).
Item (Entry: 186) not correct (not listed in list of existed items).
Item (Entry: 187) not correct (not listed in list of existed items).
Item (Entry: 188) not correct (not listed in list of existed items).
Item (Entry: 189) not correct (not listed in list of existed items).
Item (Entry: 190) not correct (not listed in list of existed items).
Item (Entry: 191) not correct (not listed in list of existed items).
Item (Entry: 192) not correct 1 material, must be 6 (still using DB value).
Item (Entry: 192) not correct 13 inventory type, must be 21 (still using DB valu
e).

Loading Creature Data...
=Table `creature` have creature (GUID: 200110 Entry: 5028) with `creature_templa
te`.`RegenHealth`=1 and low current health (25), `creature_template`.`minhealth`
=63000.
Table `creature` have creature (GUID: 200001 Entry: 99001) with `creature_templa
te`.`RegenHealth`=1 and low current health (20585), `creature_template`.`minheal
th`=24000.
Table `creature` have creature (GUID: 200001 Entry: 99001) with low current mana
(4788), `creature_template`.`minmana`=5875.
Table `creature` have creature (GUID: 200002 Entry: 99001) with `creature_templa
te`.`RegenHealth`=1 and low current health (10056), `creature_template`.`minheal
th`=24000.
Table `creature` have creature (GUID: 200002 Entry: 99001) with low current mana
(1438), `creature_template`.`minmana`=5875.
Table `creature` have creature (GUID: 200003 Entry: 99001) with `creature_templa
te`.`RegenHealth`=1 and low current health (18972), `creature_template`.`minheal
th`=24000.
Table `creature` have creature (GUID: 200003 Entry: 99001) with low current mana
(4275), `creature_template`.`minmana`=5875.
Table `creature` have creature (GUID: 200004 Entry: 99001) with `creature_templa
te`.`RegenHealth`=1 and low current health (18308), `creature_template`.`minheal
th`=24000.
Table `creature` have creature (GUID: 200004 Entry: 99001) with low current mana
(4064), `creature_template`.`minmana`=5875.
Table `creature` has creature (GUID: 200225) with non existing creature entry 10
0107, skipped.

Do you have any idea how to fix them
 
Back