[Guide] Making a Working Premade Enchant vendor for Ascent

[Jackie Moon]

Bump refreshing it

[scarfaze]

Jackie Moon, can you please add me [email protected] to msn? I need some help with getting my server public!

[Babbaa]

This isn't a guide,
It's more like an release..

Good stuff anyway.

[Empoo]

Hello, and thanks for making this guide - exactly what I was looking for!

I've got a problem making it work properly though.

First off, I wasn't quite sure wich database in Navicat I was supposed to execute the bash file in, so I figured I might aswell try all of them and see wich one worked. Frankly, it didn't work with any of them. When I try to run the ".npc spawn 98987" command in-game, I get some sort of error saying "Invalid entry id.". And no, I didn't change NPC ID in the SQL-file.

Could anyone please help me figure out what I'm doing wrong?

[Saint-Pasdoy]

DOnt bump thread, if ppl are interested they gonna bump it

[hingxxwing]

Nice , enchanthing... pretty much all profs are bugged on my server... it gives you the recipe.. but it just says the name...... and u cant learn it =P well im glad u made this! i needed somthing like this..

[hodas]

Great Work Jackie Moon, I executed it to myn database and it's working perfectly. +rep for this

[Jackie Moon]

Hing i'm not sure and thanks for the positive comments. Empoo it means you've all ready got an item with the same ID sorry bud and sorry for the late responses my computer broke

[jerry809]

Uh...
I already posted a release of Premade Enchants already....
and it includes inserting the items
then adding the npc

[svedin]

okey, i'm noob at this dose this works whit SQLyog or do i need to download a other one?

[overload119]

Yes! Finally.

Every single server needs this.

[Jackie Moon]

okey, i'm noob at this dose this works whit SQLyog or do i need to download a other one?

just download the pack i linked and execute it into your database using MYSQL or HeidiSQL or any SQL database you use

and btw my pack just lets you download it execute it and then tell you how to spawn it and change name.

[NipplesAndLicks]

[Err] 1062 - Duplicate entry '98987' for key 1
[Err] INSERT INTO creature_proto (entry, minlevel, maxlevel, faction, minhealth, maxhealth, mana, scale, npcflags, attacktime, mindamage, maxdamage, rangedattacktime, rangedmindamage, rangedmaxdamage, mountdisplayid, equipmodel1, equipinfo1, equipslot1, equipmodel2, equipinfo2, equipslot2, equipmodel3, equipinfo3, equipslot3, respawntime, armor, resistance1, resistance2, resistance3, resistance4, resistance5, resistance6, combat_reach, bounding_radius, auras, boss, money, invisibility_type, death_state)
VALUES (98987, 255, 255, 814, 100000, 100000, 102, 1, 128, 1800, 150, 250, 1800, 500, 650, 0, 0, 0, 0, 0, 0, 0, 0, 0, 0, 36000, 0, 0, 0, 0, 0, 0, 0, 1, 0, "MEMO", 0, 0, 0, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

anyone?

[Edge94]

nice find. i really needed this for my server

[Dr. Livingstone]

Nice guide. Really helpful for a twink server