Reply
How To Fix 7.8 Vendors  
Old 07-02-2008, 08:53 PM   #1
xdaknax
 
Join Date: Jan 2008
Posts: 39
xdaknax has a little shameless behaviour in the past
Since SO many are having problems I decided to Show everyone a simple way to fix it..

First Off the Cube Pieces..

In Creature_names it hs a mobs display information. In the Maledisplay2 & Femaledisplay2 Column you remove all the "1"'s with "0"'s that will fix that.

Next..

To Fix the Waist vendor and Shield Vendor Spell casting stuff..

In Creature_names and Creature_proto Change the entryID of the Shield Vendor to "49999" and the Waist Vendor to 50014. Next Go Into the Vendors Area, Look for the Old Shield Vendors ID and change them ALL like 30 of them or more to "49999" Then do the same for the Waist Vendors Old ID and make them all "50014" This puts there loot information to your new NPC id's..

This is just a simple fix and takes 5 minutes tops if you kno whats going on.
xdaknax is offline   Reply With Quote
 
Old 07-02-2008, 09:11 PM   #2
RiVOT
 
RiVOT's Avatar
 
Join Date: Jun 2008
Location: California, US
Posts: 44
RiVOT is an unknown quantity at this point
Dammit! When did 7.8 come out? I JUST made my server with 7.7 like a week ago :O
RiVOT is offline   Reply With Quote
 
Old 07-02-2008, 09:39 PM   #3
xdaknax
 
Join Date: Jan 2008
Posts: 39
xdaknax has a little shameless behaviour in the past
few days i think?
xdaknax is offline   Reply With Quote
 
Old 07-02-2008, 09:47 PM   #4
Xepher
Retired Ac-Web Mod
 
Xepher's Avatar
 
Join Date: Jun 2007
Posts: 2,021
Xepher has a reputation beyond reputeXepher has a reputation beyond reputeXepher has a reputation beyond reputeXepher has a reputation beyond reputeXepher has a reputation beyond reputeXepher has a reputation beyond repute
more of a tut so moved to tutorials and nice +rep
Xepher is offline   Reply With Quote
 
Old 07-03-2008, 06:59 AM   #5
wbng
 
Join Date: Jun 2008
Posts: 5
wbng is an unknown quantity at this point
is a repost -.-
wbng is offline   Reply With Quote
 
Old 07-03-2008, 07:12 AM   #6
mozdi
 
mozdi's Avatar
 
Join Date: Oct 2007
Location: Europe Hungary
Posts: 152
mozdi is an unknown quantity at this point
i need a sql qerry for this can ou make that xdaknax?! PLS PLS PLS
mozdi is offline   Reply With Quote
 
Old 07-03-2008, 07:13 PM   #7
cornrooster
 
Join Date: Jun 2008
Posts: 12
cornrooster is an unknown quantity at this point
thanks it worked
cornrooster is offline   Reply With Quote
 
Old 07-03-2008, 08:19 PM   #8
mozdi
 
mozdi's Avatar
 
Join Date: Oct 2007
Location: Europe Hungary
Posts: 152
mozdi is an unknown quantity at this point
i need a sql qerry for this can be automaticayy made.... pls make anyone to e
mozdi is offline   Reply With Quote
 
Old 07-03-2008, 10:11 PM   #9
hqtitan
 
hqtitan's Avatar
 
Join Date: Oct 2007
Location: United States
Posts: 1,732
hqtitan is just really nicehqtitan is just really nice
SQL Query would be something like:

Code:
UPDATE `creature_names` SET `maledisplay2` 0 where `entry` between 50000 and 500080;

UPDATE `creature_names` SET `femaledisplay2` 0 where `entry` between 50000 and 500080;
hqtitan is online now   Reply With Quote
 
Old 07-04-2008, 04:08 AM   #10
LeetWoovie
 
Join Date: Jun 2008
Posts: 33
LeetWoovie is an unknown quantity at this point
Your query does not work sadly. Could you write it to work ? I am rather lazy.
LeetWoovie is offline   Reply With Quote
 
Old 07-04-2008, 05:52 AM   #11
Hurkulez
 
Hurkulez's Avatar
 
Join Date: Apr 2008
Location: Missouri, USA
Posts: 1,892
Hurkulez is a glorious beacon of lightHurkulez is a glorious beacon of light
update `creature_names` set `male_displayid2` = '0' and `female_displayid2` = '0' where `male_displayid2` = '1' or `female_displayid2` = '1';

update `creature_names` set `female_displayid2` = '0' where `female_displayid2` = '1';

Last edited by Hurkulez; 07-05-2008 at 10:25 PM.
Hurkulez is offline   Reply With Quote
 
Old 07-04-2008, 04:22 PM   #12
Rue
 
Join Date: Mar 2008
Posts: 25
Rue is an unknown quantity at this point
Ummm I don't understand what to do.
Rue is offline   Reply With Quote
 
Old 07-04-2008, 05:06 PM   #13
avngd7fld96
 
avngd7fld96's Avatar
 
Join Date: Jan 2008
Location: Bel Air, Maryland
Posts: 141
avngd7fld96 is an unknown quantity at this point
I understand, but it's not working for my databases. It keeps saying "You have an error in your SQL Syntax; Check the manual that corresponds to your MySQL server for the right syntax to use near '0 where `entry` between 50000 and 50080' at line 1" what does that mean?
avngd7fld96 is offline   Reply With Quote
 
Old 07-04-2008, 05:35 PM   #14
shadow00caster
 
shadow00caster's Avatar
 
Join Date: Feb 2008
Posts: 49
shadow00caster is an unknown quantity at this point
I am too getting the SQL syntax error. Any ones know whats wrong?
shadow00caster is offline   Reply With Quote
 
Old 07-05-2008, 10:23 PM   #15
Hurkulez
 
Hurkulez's Avatar
 
Join Date: Apr 2008
Location: Missouri, USA
Posts: 1,892
Hurkulez is a glorious beacon of lightHurkulez is a glorious beacon of light
update post #11

Last edited by Hurkulez; 07-05-2008 at 10:26 PM.
Hurkulez is offline   Reply With Quote
 
Old 07-05-2008, 11:08 PM   #16
Rue
 
Join Date: Mar 2008
Posts: 25
Rue is an unknown quantity at this point
Thanks works like a charm ^_^
Do you have a query for the waist and shield vendor?

Last edited by Rue; 07-06-2008 at 02:49 PM. Reason: Automerged Doublepost
Rue is offline   Reply With Quote
 
Old 07-06-2008, 05:01 AM   #17
avngd7fld96
 
avngd7fld96's Avatar
 
Join Date: Jan 2008
Location: Bel Air, Maryland
Posts: 141
avngd7fld96 is an unknown quantity at this point
Yeah, I'd like query for that too, Navicat doesn't show enough rows to go to 50000 and above.
avngd7fld96 is offline   Reply With Quote
 
Old 07-06-2008, 09:29 AM   #18
reggie88
 
reggie88's Avatar
 
Join Date: Jul 2008
Location: Norway
Posts: 25
reggie88 is an unknown quantity at this point
Thx Hurkulez, work like a charm. whit that query did make it easyer for me to fix the vendors too (just chanced the name where i need to chance the nr.s ofc)

edit: ok got shield vendor to work but the waist vendor are still exploding

Last edited by reggie88; 07-08-2008 at 02:02 AM.
reggie88 is offline   Reply With Quote
 
Old 07-06-2008, 09:39 AM   #19
Mbz
 
Mbz's Avatar
 
Join Date: Feb 2008
Posts: 209
Mbz is an unknown quantity at this point
Thanks Hurkulez made it easier for everyone lol
Mbz is offline   Reply With Quote
 
Old 07-06-2008, 10:19 AM   #20
maymacc
 
maymacc's Avatar
 
Join Date: Jan 2008
Location: I-Live-In-Your-Pillow...
Posts: 567
maymacc will become famous soon enough
its called a query, not a quarry, thanks for that Hurkulez, helped me +rep
maymacc is offline   Reply With Quote
 
Old 07-06-2008, 01:39 PM   #21
AzraelUK
 
Join Date: Sep 2007
Posts: 3
AzraelUK is an unknown quantity at this point
[code]UPDATE `ascent`.`creature_names` SET Male_DisplayID2 = 0, Female_DisplayID2 = 0, Female_DisplayID = 0[/code]
AzraelUK is offline   Reply With Quote
 
Old 07-06-2008, 04:54 PM   #22
avngd7fld96
 
avngd7fld96's Avatar
 
Join Date: Jan 2008
Location: Bel Air, Maryland
Posts: 141
avngd7fld96 is an unknown quantity at this point
Is that to fix the vendor spellcasting?
avngd7fld96 is offline   Reply With Quote
 
Old 07-09-2008, 12:13 PM   #23
avngd7fld96
 
avngd7fld96's Avatar
 
Join Date: Jan 2008
Location: Bel Air, Maryland
Posts: 141
avngd7fld96 is an unknown quantity at this point
/bump

I know I double posted, but this one was being lost in the other threads, and I need to fix this to make my server public.
avngd7fld96 is offline   Reply With Quote
 
Old 07-09-2008, 01:12 PM   #24
jay08
 
jay08's Avatar
 
Join Date: Jun 2008
Location: Realmlist.wtf
Posts: 17
jay08 is an unknown quantity at this point
ah great, was looking for a fix for it, thanx +rep
jay08 is offline   Reply With Quote
 
Old 07-10-2008, 05:47 PM   #25
avngd7fld96
 
avngd7fld96's Avatar
 
Join Date: Jan 2008
Location: Bel Air, Maryland
Posts: 141
avngd7fld96 is an unknown quantity at this point
WTB vendor spellcasting query. -_- Sorry, I'm impatient. XD Just really wanna fix this.
avngd7fld96 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 01:35 AM.

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