Honor disable.

[Zika123]

I posted this before long time ago but cant find it back

How do i disable honor for honor items on mangos for wow version 1.12.1

thanks in advance =)

Greetings zika.

 

[xanaal]

make a new text file.
add this in it:
UPDATE `item_template` SET `requiredhonorrank`=`requiredhonorrank`+4 WHERE `requiredhonorrank`>0;
change extension to .sql
voilla
works for me

 

[Zika123]

Doesnt work for me , but thanks anyway

but there was a much easyier way to anyone ^^?

 

[xanaal]

hm... weird

then (if u have time) change in database from all honor items their ranks to 0

 

[Zika123]

ye i know about that but takes so long

and i know there was a option that was verry easy but forgot =(

 

[xanaal]

tell me what is says if u want to import that what it wrote

 

[Zika123]

ok so i make text document write in it

UPDATE `item_template` SET `requiredhonorrank`=`requiredhonorrank`+4 WHERE `requiredhonorrank`>0;

Rename the text document to??? and put .sql after it?

and import in Mangos database?

explain bit /shy ^^

 

[xanaal]

yea

make it from *****.txt to *****.sql
just name it honor.sql or whatever and then import

 

[Zika123]

i imported the file into mangos. still says in game need honor =(

 

[xanaal]

did u restart server?
(im just guessing: try to make it +0 there where it says +4)
gl

 

[GXAngel]

What?

UPDATE `item_template` SET `requiredhonorrank`=`requiredhonorrank`+4 WHERE `requiredhonorrank`>0;

This query tolds:

Update the Honor Required Row with the actual value with 4 ranks more, to all items with honor required..

xD this query makes now the honor rank necessary is more high than before...

If u want erase the required honor the correct query is:

UPDATE `item_template` SET `requiredhonorrank`= 0 WHERE `requiredhonorrank`>0;

 

[Zika123]

ok lets try again

 

[Zika123]

Works perfect man thanks alot !!! kiss kiss ^^

 

[xanaal]

yea i said that in latest reply...
anyway... anyone has idea when honor will be 100% fixed?

edit: ah yea... that + was the problem too XD
sorry.... but i copyed it from one repack..