[Guide] Making a Working Premade Enchant vendor for Ascent

[kreegoth]

For all the people who are having trouble and cant LEARN spells from designs or patterns..

Downlaod this file execute Sql into database and then you can learn recipes np..it fixes them all for all professions

Filebeam - Free Fast File Hosting

[Jackie Moon]

or if your more an advanced server creator you can easy enter your database and change the requirements

[Jackie Moon]

[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?

means you already got an item with that number, either you go through the pack and modify the numbers or get a new repack or live without

[Darth Piggy]

I'l +Rep anyone who hosts the file on rapidshare plz, i'm having trouble connecting to filebeam

Thanks

[EgoDiligoErectus]

Hella tight : O Everybody needs an enchant vendor... lmao

[Drummer]

Awesome, worked perfect for me

[Jackie Moon]

Back from break happy to see me!

[Christina]

[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?

That means 1 of 2 things.

1) You have an ID by 98987 already (extremely unlikely)
2) You already added this SQL and your adding it again in vein (probably your problem)


On a side note.. (this is why I'm posting)

This doesn't work unless you have Vellums from Inscription working. (which my server doesn't have working atm)

+Rep if you can figure out how to get this working for me.

[jockeborg]

lol
i spawned the vendor and stuff but the enchant doesnt work for me
there just grey

[Jackie Moon]

[COLOR="DarkOrange"]
That means 1 of 2 things.

1) You have an ID by 98987 already (extremely unlikely)
2) You already added this SQL and your adding it again in vein (probably your problem)


On a side note.. (this is why I'm posting)

This doesn't work unless you have Vellums from Inscription working. (which my server doesn't have working atm)

+Rep if you can figure out how to get this working for me.

It does because ive been using this before Inscription came out so yeah it may be something to do with your repack im not sure.


Anyone else need help?

[zwhit]

Thanks, this could help my server out,
nice job.

[Jackie Moon]

Thanks Zwhit

[mitch56]

nice good job jackie

[Jackie Moon]

Thanks Mitch

[iverdiver]

Kinda worked for me, i could spawn the npc and buy the enchants from the vendor.. But they were just white items, which i couldnt use to enchant my items with? how do i fix this?