GM Island Vendor Fix

[GoldHawk]

I got tired of the GM Island Vendors being all screwed up so I fixed them.

They are now 100% working on Repack 7.8. Not sure about any older repacks, but they *SHOULD* work. This fix was created be me and only me.

Fixes Include:
Display ID Fix - No more blue and white boxes!
Cursor Fix - No more vanishing cursor! (It's now an anvil cursor)
Bug Fix - They no longer blow up, fly away, or endlessly cast spells.
Another Bug Fix - When you buy something, you no longer get sent back to page 1. (Thanks to Niklas for mentioning it)


Steps: (also in readme)
1. delete_old_vendors.sql
2. creature_names.sql
3. creature_proto.sql
4. creature_spawns.sql
5. vendors.sql

Not working? Try restarting your server and deleting your wow cache.


They are still spawned in the same location as before and look the same.

Enjoy! (Don't forget to +rep)

NOTICE: If you use the download method, you must also run the code (after you run the sql files) directly under this message or it won't work as intended.

UPDATE creature_spawns
SET faction = 35
WHERE faction = 1741 AND displayid = 18106;

DOWNLOAD LINKS:

Filebeam - Free Fast File Hosting

RapidShare: Easy Filehosting

MEGAUPLOAD - The leading online storage and file delivery service





vv NEW CODE BELOW vv

This fix does the same thing as the downloadable one. I made this for a member on here and decided to post it here because it's much shorter than the queries found in the downloadable fix. I repeat, this does the SAME EXACT thing as the downloadable fix. Just copy, paste, and execute if you want to try it.


NOTE: If you changed your vendor's entry numbers, then ONLY execute the first TWO queries.

NOTE 2: I haven't tested the code, but it should work. Just let me know if you can't execute it for some reason.

UPDATE creature_names
SET info_str = NULL, type = 7, rank = 0, male_displayid2 = 0, female_displayid2 = 0, unknown_float2 = 1
WHERE male_displayid2 = 1 AND female_displayid2 = 1;

UPDATE creature_proto
SET minlevel = 70, maxlevel = 70, faction = 35, minhealth = 10000, maxhealth = 10000, mana = 1000, npcflags = 4225, attacktime = 100, attacktype = 0, mindamage = 1000, maxdamage = 1001, equipslot3 = 0, respawntime = 500, armor = 1212, resistance1 = 0, resistance2 = 0, resistance3 = 0, resistance4 = 0, resistance5 = 0, resistance6 = 0, combat_reach = 1.5, bounding_radius = 0.208, death_state = 0, walk_speed = 2.5, run_speed = 8, fly_speed = 14
WHERE minlevel = 100 AND npcflags = 4224;


UPDATE creature_names
SET entry = 50081
WHERE entry = 50010;

UPDATE creature_names
SET entry = 50082
WHERE entry = 50011;

UPDATE creature_names
SET entry = 50083
WHERE entry = 50012;


UPDATE creature_proto
SET entry = 50081
WHERE entry = 50010;

UPDATE creature_proto
SET entry = 50082
WHERE entry = 50011;

UPDATE creature_proto
SET entry = 50083
WHERE entry = 50012;


UPDATE creature_spawns
SET entry = 50081
WHERE entry = 50010;

UPDATE creature_spawns
SET entry = 50082
WHERE entry = 50011;

UPDATE creature_spawns
SET entry = 50083
WHERE entry = 50012;


UPDATE vendors
SET entry = 50081
WHERE entry = 50010;

UPDATE vendors
SET entry = 50082
WHERE entry = 50011;

UPDATE vendors
SET entry = 50083
WHERE entry = 50012;

UPDATE creature_spawns
SET faction = 35
WHERE faction = 1741 AND displayid = 18106;

vv Notice that the vendors are still there and didn't fly off, blow up, etc! vv



Sorry, wow wouldn't let me take a picture of the cursor, but believe me, it's fixed.

[niklas]

Nice i'll check if it's working.

EDIT: 100% Working!


You should add one more thing. When i buy something of (example) Page 4 of 9 im not getting throw back to page 1! Thanks alot dude!

i've been looking for this!

HE DESERVES REP!

[The Joker]

Testing Now, If It Works Plus Rep.

Yup Works Plus Rep.

[GoldHawk]

Niklas, I didn't even think about that! Thanks for mentioning it!

*edits first post*

BTW, Thanks for the +REP

[MutilatedFlame]

Mine already work, but good job man. +rep for doing this for the community.

[GoldHawk]

Thanks for the +rep.

[MercenaryX2]

Hurk released a fix EXACTLY like this. I'd say you stole this and then claimed it as your own... That's retarded. The only thing that is different is that yours is for Repack 7.8. Give credit?

[GoldHawk]

Are you talking about this topic? http://www.ac-web.org/forum/releases...sql-files.html

His fix is TOTALLY different than mine. Maybe you should check before you tell somebody that they stole from somebody else.

[Mbz]

thanks worked for me +rep

[GoldHawk]

Thanks, Mbz. Glad it worked for you!

[Vargen]

good job, thx, +rep

[GoldHawk]

Thanks for the +rep, Vargen.

[lesslinger]

Works great for me. Only thing is that on most of the vendors, cursor still disapears, only some show anvil. Not a big deal, I am still happy. Great job. +rep

[sither123]

Im usless at this kinda stuff...so please explain...all you give is a few files...what do i do with them and how do i do it???

Please Help,
Simon...

[GoldHawk]

lesslinger, try deleting your WoW cache.

sither123, you need to get a mysql program like heidisql (download it on the computer with the repack). Heidisql is free to download and use. After you download Heidisql, run it and connect to your database. I'm going to assume you didn't change your info.

Click New
Description: WoW
Hostname / IP: 127.0.0.1
User: root
Pass: ascent
Click Save + Connect

After you connect, double click the ascent database on the left side to start a connection. Then, near the top, you will see three tabs. Click the take that says Query. Once you're there. Click the folder button on the query page to open a sql file. Select the 1st one and open it. Now you run it by hitting the blue arrow (looks like a play button on a VCR) or by hitting F9. Then you open the 2nd one, execute, etc. (The order is in the readme)

It's a rough tutorial, but if you try to figure it out, I'm sure you'll do fine.

[deeppowder]

YES! thank you GoldHawk! everything works! +rep

[GoldHawk]

Glad I could help and thanks for the +rep

[MohammadKoush]

i have installed it will give rep+ if it work and thanx

[GoldHawk]

Hurkulez, look at my code and then look at yours. They are nothing alike. I'm getting accused of something I didn't do and it's really getting on my nerves because nobody even thought to compare the code or anything before pointing fingers and making accusations.

I don't steal code. Never have, never will.
I try to do some good for the private server community and I get called a thief.

Trust me. Just look at the code.

[niklas]

Originally Posted by MercenaryX2

Hurk released a fix EXACTLY like this. I'd say you stole this and then claimed it as your own... That's retarded. The only thing that is different is that yours is for Repack 7.8. Give credit?

You really wanna know what's retarded?.. YOU!
You always point fingers at people or flame at them BEFORE even looking at the facts!
Now that's RETARDED! Please, lookup facts before saying something.
Thanks.

-Niklas

[GoldHawk]

Thanks Niklas. I'm glad that somebody doesn't make rash assumptions.

I'm just waiting to see what Hurk says.

[niklas]

No problem, i know you didnt stole this. but if you did. i dont realy care. it's working right?

[GoldHawk]

Yea, but don't worry. I didn't steal it and I'm trying as hard as I can to clear my name. I always give credit where it is needed. Heck, I even gave you credit for mentioning the bug fix where it sends you back to page 1.

[mikeh27]

+rep

[GoldHawk]

Thanks for the +rep, mikeh27.