How To Fix 7.8 Vendors

xdaknax · 07-02-2008, 08:53 PM

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.

RiVOT · 07-02-2008, 09:11 PM

Dammit! When did 7.8 come out? I JUST made my server with 7.7 like a week ago :O

xdaknax · 07-02-2008, 09:39 PM

few days i think?

**Xepher** · 07-02-2008, 09:47 PM

more of a tut so moved to tutorials and nice +rep

wbng · 07-03-2008, 06:59 AM

is a repost -.-

mozdi · 07-03-2008, 07:12 AM

i need a sql qerry for this can ou make that xdaknax?! PLS PLS PLS

cornrooster · 07-03-2008, 07:13 PM

thanks it worked

mozdi · 07-03-2008, 08:19 PM

i need a sql qerry for this can be automaticayy made.... pls make anyone to e

hqtitan · 07-03-2008, 10:11 PM

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;

LeetWoovie · 07-04-2008, 04:08 AM

Your query does not work sadly. Could you write it to work ? I am rather lazy.

Hurkulez · 07-04-2008, 05:52 AM

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';

Rue · 07-04-2008, 04:22 PM

Ummm I don't understand what to do.

avngd7fld96 · 07-04-2008, 05:06 PM

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?

shadow00caster · 07-04-2008, 05:35 PM

I am too getting the SQL syntax error. Any ones know whats wrong?

Hurkulez · 07-05-2008, 10:23 PM

update post #11

Rue · 07-05-2008, 11:08 PM

Thanks works like a charm ^_^
Do you have a query for the waist and shield vendor?

avngd7fld96 · 07-06-2008, 05:01 AM

Yeah, I'd like query for that too, Navicat doesn't show enough rows to go to 50000 and above.

reggie88 · 07-06-2008, 09:29 AM

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

Mbz · 07-06-2008, 09:39 AM

Thanks Hurkulez made it easier for everyone lol

maymacc · 07-06-2008, 10:19 AM

its called a query, not a quarry, thanks for that Hurkulez, helped me +rep

AzraelUK · 07-06-2008, 01:39 PM

[code]UPDATE `ascent`.`creature_names` SET Male_DisplayID2 = 0, Female_DisplayID2 = 0, Female_DisplayID = 0[/code]

avngd7fld96 · 07-06-2008, 04:54 PM

Is that to fix the vendor spellcasting?

avngd7fld96 · 07-09-2008, 12:13 PM

/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.

jay08 · 07-09-2008, 01:12 PM

ah great, was looking for a fix for it, thanx +rep

avngd7fld96 · 07-10-2008, 05:47 PM

WTB vendor spellcasting query. -_- Sorry, I'm impatient. XD Just really wanna fix this.

07-03-2008, 10:11 PM	#9
hqtitan Join Date: Oct 2007 Location: United States Posts: 1,732	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;

07-05-2008, 10:23 PM	#15
Hurkulez Join Date: Apr 2008 Location: Missouri, USA Posts: 1,892	update post #11 Last edited by Hurkulez; 07-05-2008 at 10:26 PM.

07-05-2008, 11:08 PM	#16
Rue Join Date: Mar 2008 Posts: 25	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

07-06-2008, 09:29 AM	#18
reggie88 Join Date: Jul 2008 Location: Norway Posts: 25	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.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

07-02-2008, 08:53 PM	#1
xdaknax Join Date: Jan 2008 Posts: 39	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.

07-02-2008, 09:11 PM	#2
RiVOT Join Date: Jun 2008 Location: California, US Posts: 44	Dammit! When did 7.8 come out? I JUST made my server with 7.7 like a week ago :O

07-02-2008, 09:39 PM	#3
xdaknax Join Date: Jan 2008 Posts: 39	few days i think?

07-02-2008, 09:47 PM	#4
Xepher Retired Ac-Web Mod Join Date: Jun 2007 Posts: 2,021	more of a tut so moved to tutorials and nice +rep

07-03-2008, 06:59 AM	#5
wbng Join Date: Jun 2008 Posts: 5	is a repost -.-

07-03-2008, 07:12 AM	#6
mozdi Join Date: Oct 2007 Location: Europe Hungary Posts: 152	i need a sql qerry for this can ou make that xdaknax?! PLS PLS PLS

07-03-2008, 07:13 PM	#7
cornrooster Join Date: Jun 2008 Posts: 12	thanks it worked

07-03-2008, 08:19 PM	#8
mozdi Join Date: Oct 2007 Location: Europe Hungary Posts: 152	i need a sql qerry for this can be automaticayy made.... pls make anyone to e

07-04-2008, 04:08 AM	#10
LeetWoovie Join Date: Jun 2008 Posts: 33	Your query does not work sadly. Could you write it to work ? I am rather lazy.

07-04-2008, 05:52 AM	#11
Hurkulez Join Date: Apr 2008 Location: Missouri, USA Posts: 1,892	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.

07-04-2008, 04:22 PM	#12
Rue Join Date: Mar 2008 Posts: 25	Ummm I don't understand what to do.

07-04-2008, 05:06 PM	#13
avngd7fld96 Join Date: Jan 2008 Location: Bel Air, Maryland Posts: 141	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?

07-04-2008, 05:35 PM	#14
shadow00caster Join Date: Feb 2008 Posts: 49	I am too getting the SQL syntax error. Any ones know whats wrong?

07-06-2008, 05:01 AM	#17
avngd7fld96 Join Date: Jan 2008 Location: Bel Air, Maryland Posts: 141	Yeah, I'd like query for that too, Navicat doesn't show enough rows to go to 50000 and above.

07-06-2008, 09:39 AM	#19
Mbz Join Date: Feb 2008 Posts: 209	Thanks Hurkulez made it easier for everyone lol

07-06-2008, 10:19 AM	#20
maymacc Join Date: Jan 2008 Location: I-Live-In-Your-Pillow... Posts: 567	its called a query, not a quarry, thanks for that Hurkulez, helped me +rep

07-06-2008, 01:39 PM	#21
AzraelUK Join Date: Sep 2007 Posts: 3	[code]UPDATE `ascent`.`creature_names` SET Male_DisplayID2 = 0, Female_DisplayID2 = 0, Female_DisplayID = 0[/code]

07-06-2008, 04:54 PM	#22
avngd7fld96 Join Date: Jan 2008 Location: Bel Air, Maryland Posts: 141	Is that to fix the vendor spellcasting?

07-09-2008, 12:13 PM	#23
avngd7fld96 Join Date: Jan 2008 Location: Bel Air, Maryland Posts: 141	/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.

07-09-2008, 01:12 PM	#24
jay08 Join Date: Jun 2008 Location: Realmlist.wtf Posts: 17	ah great, was looking for a fix for it, thanx +rep

07-10-2008, 05:47 PM	#25
avngd7fld96 Join Date: Jan 2008 Location: Bel Air, Maryland Posts: 141	WTB vendor spellcasting query. -_- Sorry, I'm impatient. XD Just really wanna fix this.