GM Island Vendor Fix  
Old 07-11-2008, 12:53 AM   #1
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
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.
Code:
UPDATE creature_spawns
SET faction = 35
WHERE faction = 1741 AND displayid = 18106;

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.


Code:
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.

Last edited by GoldHawk; 07-13-2008 at 07:30 PM. Reason: Uploaded pics
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 01:15 AM   #2
niklas
 
niklas's Avatar
 
Join Date: Dec 2007
Location: Sweden, Sandviken
Posts: 287
niklas is an unknown quantity at this point
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!

Last edited by niklas; 07-11-2008 at 01:21 AM.
niklas is offline   Reply With Quote
 
Old 07-11-2008, 01:18 AM   #3
The Joker
 
The Joker's Avatar
 
Join Date: Dec 2007
Location: Gotham City
Posts: 852
The Joker is a jewel in the rough
Testing Now, If It Works Plus Rep.

Yup Works Plus Rep.

Last edited by The Joker; 07-11-2008 at 01:23 AM. Reason: Automerged Doublepost
The Joker is offline   Reply With Quote
 
Old 07-11-2008, 01:23 AM   #4
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Niklas, I didn't even think about that! Thanks for mentioning it!

*edits first post*

BTW, Thanks for the +REP

Last edited by GoldHawk; 07-11-2008 at 01:44 AM. Reason: Forgot a word
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 02:46 AM   #5
MutilatedFlame
 
Join Date: Jun 2008
Posts: 824
MutilatedFlame is an unknown quantity at this point
Mine already work, but good job man. +rep for doing this for the community.
MutilatedFlame is offline   Reply With Quote
 
Old 07-11-2008, 03:36 AM   #6
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Thanks for the +rep.
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 04:07 AM   #7
MercenaryX2
 
MercenaryX2's Avatar
 
Join Date: Dec 2007
Location: Kansas City Kansas
Posts: 64
MercenaryX2 is an unknown quantity at this point
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?

Last edited by MercenaryX2; 07-11-2008 at 04:10 AM.
MercenaryX2 is offline   Reply With Quote
 
Old 07-11-2008, 04:33 AM   #8
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
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.

Last edited by GoldHawk; 07-11-2008 at 03:32 PM.
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 04:49 AM   #9
Mbz
 
Mbz's Avatar
 
Join Date: Feb 2008
Posts: 209
Mbz is an unknown quantity at this point
thanks worked for me +rep
Mbz is offline   Reply With Quote
 
Old 07-11-2008, 04:51 AM   #10
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Thanks, Mbz. Glad it worked for you!
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 04:55 AM   #11
Vargen
 
Join Date: Mar 2008
Posts: 9
Vargen is an unknown quantity at this point
good job, thx, +rep
Vargen is offline   Reply With Quote
 
Old 07-11-2008, 05:09 AM   #12
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Thanks for the +rep, Vargen.
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 08:25 AM   #13
lesslinger
 
Join Date: Jun 2008
Posts: 68
lesslinger is an unknown quantity at this point
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
lesslinger is offline   Reply With Quote
Help  
Old 07-11-2008, 09:11 AM   #14
sither123
 
Join Date: May 2008
Posts: 2
sither123 is an unknown quantity at this point
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...
sither123 is offline   Reply With Quote
 
Old 07-11-2008, 03:17 PM   #15
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
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.
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 03:23 PM   #16
deeppowder
 
Join Date: May 2008
Posts: 5
deeppowder is an unknown quantity at this point
YES! thank you GoldHawk! everything works! +rep
deeppowder is offline   Reply With Quote
 
Old 07-11-2008, 03:27 PM   #17
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Glad I could help and thanks for the +rep
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 08:47 PM   #18
MohammadKoush
 
Join Date: Jun 2008
Posts: 22
MohammadKoush is an unknown quantity at this point
i have installed it will give rep+ if it work and thanx
MohammadKoush is offline   Reply With Quote
 
Old 07-11-2008, 10:47 PM   #19
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
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.

Last edited by GoldHawk; 07-11-2008 at 10:53 PM.
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 10:52 PM   #20
niklas
 
niklas's Avatar
 
Join Date: Dec 2007
Location: Sweden, Sandviken
Posts: 287
niklas is an unknown quantity at this point
Quote:
Originally Posted by MercenaryX2 View Post
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
niklas is offline   Reply With Quote
 
Old 07-11-2008, 11:09 PM   #21
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Thanks Niklas. I'm glad that somebody doesn't make rash assumptions.

I'm just waiting to see what Hurk says.
GoldHawk is offline   Reply With Quote
 
Old 07-11-2008, 11:36 PM   #22
niklas
 
niklas's Avatar
 
Join Date: Dec 2007
Location: Sweden, Sandviken
Posts: 287
niklas is an unknown quantity at this point
No problem, i know you didnt stole this. but if you did. i dont realy care. it's working right?
niklas is offline   Reply With Quote
 
Old 07-12-2008, 12:24 AM   #23
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
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.
GoldHawk is offline   Reply With Quote
 
Old 07-12-2008, 06:16 AM   #24
mikeh27
 
Join Date: Jun 2008
Posts: 27
mikeh27 is an unknown quantity at this point
+rep
mikeh27 is offline   Reply With Quote
 
Old 07-12-2008, 06:34 AM   #25
GoldHawk
 
GoldHawk's Avatar
 
Join Date: Jun 2007
Location: AresDB
Posts: 410
GoldHawk has a spectacular aura about
Thanks for the +rep, mikeh27.
GoldHawk is offline   Reply With Quote
Reply

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off

Forum Jump


All times are GMT. The time now is 06:24 AM.

All times are GMT. The time now is 06:24 AM. Contact Us - AC Web - Archive - Privacy Statement - Top