SQL Inserts

Printable View

29-04-08
Quakes69

8 Attachment(s)

SQL Inserts

I've read the rules and it didn't state anything on posting this here. This here is for ppl that are looking to make more of their blizz/fun servers.

Start with the Trainers.
I've looked through the SQL creature_template's and found a few trainers that aren't being used. They are called World Trainer bla bla bla. Done by SDB makers I guess cause that's what I'm using.

These codes are for the Following server specs.

Server : Mangos
Version : Revision 4479
DBase type : Project SilverMoon
DBase version : 18
ScriptDev version : ScriptDev2 Revision 136
Client version : 2.1.3(6869)

Includes:
Boats at GM Island - Can be used for Trainers, Shops, And so forth
Boards to Ship 1 and Ship 2

Includes: Default Model ID's for
World Weapons, Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warrior, Warlock, Riding - Trainers
World Trade - Vendor

Includes: Modified Model ID's for
World Weapons, Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warrior, Warlock - Trainers. Including Weapons.
World Trade - Vendor

Includes: These need to be installed for Trainers, Vendors
Weapons, Druid, Hunter, Mage, Paladin, Priest, Rogue, Shaman, Warrior, Warlock, Riding - Spells
Gun - Arrow - Items

Creature ID's

Trainers:
----------------
Weapons - 7173
Druid - 4985
Hunter - 4986
Mage - 4987
Paladin - 4988
Priest - 4989
Rogue - 4990
Shaman - 4991
Warrior - 4992
Warlock - 4993
Riding - 5028

Vendors:
----------------
Trade Supplies - 5064

Vendor / Trainer
----------------
Fishing - 5967

In Game
.addspw ####
.spawndist 5 - If you wish for it to move around a bit. Makes it more interesting.

Includes: Start: Gold Item - Sells for 1000,00,00 = 1k
The gold bar can not be sold and bought back for more Gold. It sells for 1000G and Buys back for 0. Which takes it away if you try. Change the Amount price to your liking. 10000000 = 1k 5000000 = 500G 500000 = 50G. Remember Double 00's(1G,00,00) for Copper then Silver. If a 24kt. gold bar is not to your players likings. then they are to f*ing lazy.

Includes:

Gm Island Guards
GM Island Bulletin Board
Start Char' Item - Announcement Letter

And so on ---------------------------------------------------------------

For portals
[ame]http://forum.ragezone.com/showthread.php?t=330250[/ame]

Finished, There are some bugs with Priest, And another trainer But these bugs are also on the normal trainers too.

Quakes Items:
Summon Nether Drake - Outland Only
Peep the Phoenix - Outland Only "Create by PSM(Project Silvermoon)"
Swift Spectral Tiger - Every where
Tallstrider - Every where
Bridle - Every Where / Slow riding mount 1.5 speed / start mount, No lvl No skill
Nether Drake - Every where

Thunders - Swords 4 lvl's
Infusers - Maces 4 lvl's
Dragon - Guns 2 lvl's
05-07-08
Shirou

Re: [ManGoS] SQL Inserts

Do u mayby know why if i make a item a random item for my server it shows a Qeustion mark but when i put it on me it shows correct ?
05-07-08
Shirou

Re: [ManGoS] SQL Inserts

And the other program i get is when i try add that Announcement letter thing it says my Vaulues is incorrect at row 1
05-07-08
Quakes69

1 Attachment(s)

Re: [ManGoS] SQL Inserts

These codes are for the Following server specs.

Server : Mangos
Version : Revision 4479
DBase type : Project SilverMoon
DBase version : 18
ScriptDev version : ScriptDev2 Revision 136
Client version : 2.1.3(6869)

1. You'll have to edit the Items to fit your mangos. Meaning if you have mangos higher then what it is supported(2.1.3) for. Then, you'll have to go into your DB and find where it has been added to or deleted from by 1.

To view the pic you might have to turn off your IE Automatic Image Resizing in
Tools/Internet Options/Advanced/Multimedia/
Click pic, Click pic after showing in ragezones viewer.

2. Display is wrong

P.S.
Editing prior posts isn't a crime. lol
05-07-08
Shirou

Re: [ManGoS] SQL Inserts

Display is correct shows if i use it then it shows right but when i add it in my bag it shows a Question mark.

do u perhaps have msn ? if u do can u add me perhaps : hewitt@absamail.co.za
08-07-08
Quakes69

Re: [ManGoS] SQL Inserts

For spells:
the display ID is the Icon. the item however is not the Display ID. It's the number that's 3/4 the way towards the end or so.

Quote:

Originally Posted by Example

INSERT INTO `item_template` VALUES (666910, 15, 0, -1, 'Nether Drake', 39239, 5, 64, 1, 10000000, 5000000, 0, -1, -1, 40, 40, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 28828, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 1, 'A fast runner!', 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 'internalitemhandler', 0);

39239 is the Display ID "ICON".
28828 is the Spell ID

Now for just plain items, Display ID should be as that.

Quote:

Originally Posted by Example

REPLACE INTO `item_template` VALUES (666600, 7, 0, -1, '24kt. Gold Bar', 7352, 2, 0, 0, 0, 10000000, 0, -1, -1, 30, 0, 0, 0, 0, 0, 0, 0, 0, 1, 1, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, '', 0, 0, 0, 0, 0, 4, 0, 0, 0, 0, 0, 0, 0, 0, 11, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, -1, 0, 'internalitemhandler', 0);

It holds no spells.

Now there's items that do hold spells. Other then mounts. Them, I'm not to sure on.
16-08-08
Fentus

Re: [ManGoS] SQL Inserts

Ok I am also having the same problem as CronicT I can't insert any items I make with out it displaying as a question mark and also not bing able to equip it with out dragging and dropping ...