- 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:
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/
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:
- 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"
- 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:

