Database fixes!

[sadgonewild]

and yes i did forget to give credit, sorry guys, ascent emu was my main source, cant quite remember links, but all i was doing was making it easy, was never asking for the fame.


Weapon Master fix

UPDATE `creature_proto`
SET `npcflags` = 16
WHERE `entry` in (select `entry` from `creature_names` where `subname` like '%weapon master%');

To open Zul'aman

REPLACE into areatriggers (entry,`type`,map,screen,name,position_x,position_y,position_z,orientation,required_honor
_rank,required_level) VALUES ('4738','1','568','568','Zul\'Aman Gate','119.152','1761.11','42.8081','0','0','70');

REPLACE into areatriggers (entry,`type`,map,screen,name,position_x,position_y,position_z,orientation,required_level
) VALUES ('4739','1','530','568','Zul\'Aman exit','6851','-7992.47','191.47','1.4930038','70');

If that one doesnt work

try:

INSERT INTO `areatriggers` (`entry`,`type`,`map`,`screen`,`name`,`position_x`,`position_y`,`position_z`,`required_level`) VALUES ('5000','1','568','568','Zul\'Aman','119.152','1761.11','42.8081','70')

INSERT INTO `worldmap_info` VALUES (568, 568, 1, 10, 70, 119.152, 1761.11, 42.8081, 568, 'Zul''Aman', 3, 259200, 0, 0, 0, 0, 0, 80, 0);

Trainer Fix

#new npcflag for trainers wo quests
update `creature_proto`
set `npcflags` = 49
where `entry` in (select `entry` from `creature_names` where `subname` like '% trainer')
and `entry` not in (select `id` from `creature_quest_starter`)
and `entry` not in (select `id` from `creature_quest_finisher`)
and `npcflags` != 129;

#new npcflag for quest_finisher trainers
update `creature_proto`
set `npcflags` = 51
where `entry` in (select `entry` from `creature_names` where `subname` like '% trainer')
and `entry` in (select `id` from `creature_quest_finisher`)
and `npcflags` != 129;

The Last update is kinda big so its hosted on filebeam.

http://filebeam.com/a72d05f1a8c45227391dcdf617699b2a

Vendor Fix

UPDATE creature_proto SET npcflags = 135296 WHERE npcflags = 16644;
UPDATE creature_proto SET npcflags = 4243 WHERE npcflags = 16407;
UPDATE creature_proto SET npcflags= 4241 WHERE npcflags = 16405;
UPDATE creature_proto SET npcflags = 4112 WHERE npcflags = 16400;
UPDATE creature_proto SET npcflags = 4227 WHERE npcflags = 16391;
UPDATE creature_proto SET npcflags = 4226 WHERE npcflags = 16390;
UPDATE creature_proto SET npcflags = 4225 WHERE npcflags = 16389;
UPDATE creature_proto SET npcflags = 4224 WHERE npcflags = 16388;
UPDATE creature_proto SET npcflags = 4099 WHERE npcflags = 16387;
UPDATE creature_proto SET npcflags = 4096 WHERE npcflags = 16384;
UPDATE creature_proto SET npcflags = 4194307 WHERE npcflags = 8195;
UPDATE creature_proto SET npcflags = 4194305 WHERE npcflags = 8193;
UPDATE creature_proto SET npcflags = 4194304 WHERE npcflags = 8192;
UPDATE creature_proto SET npcflags = 2097152 WHERE npcflags = 4096;
UPDATE creature_proto SET npcflags = 1048577 WHERE npcflags = 2049;
-- UPDATE creature_proto SET npcflags = 262145 WHERE npcflags = 1537;
-- UPDATE creature_proto SET npcflags = 262144 WHERE npcflags = 1536;
UPDATE creature_proto SET npcflags = 524417 WHERE npcflags = 1029;
UPDATE creature_proto SET npcflags = 524416 WHERE npcflags = 1028;
UPDATE creature_proto SET npcflags = 524288 WHERE npcflags = 1024;
UPDATE creature_proto SET npcflags = 131075 WHERE npcflags = 259;
UPDATE creature_proto SET npcflags = 131073 WHERE npcflags = 257;
UPDATE creature_proto SET npcflags = 131072 WHERE npcflags = 256;
UPDATE creature_proto SET npcflags = 65667 WHERE npcflags = 135;
UPDATE creature_proto SET npcflags = 65665 WHERE npcflags = 133;
UPDATE creature_proto SET npcflags = 65664 WHERE npcflags = 132;
UPDATE creature_proto SET npcflags = 65539 WHERE npcflags = 131;
UPDATE creature_proto SET npcflags = 65537 WHERE npcflags = 129;
-- UPDATE creature_proto SET npcflags = ??? WHERE npcflags = 64;
UPDATE creature_proto SET npcflags = 32769 WHERE npcflags = 33;
UPDATE creature_proto SET npcflags = 32768 WHERE npcflags = 32;
UPDATE creature_proto SET npcflags = 147 WHERE npcflags = 23;
UPDATE creature_proto SET npcflags = 145 WHERE npcflags = 21;
UPDATE creature_proto SET npcflags = 8195 WHERE npcflags = 11;
UPDATE creature_proto SET npcflags = 8194 WHERE npcflags = 10;
UPDATE creature_proto SET npcflags = 8193 WHERE npcflags = 9;
UPDATE creature_proto SET npcflags = 8192 WHERE npcflags = 8;
UPDATE creature_proto SET npcflags = 130 WHERE npcflags = 6;
UPDATE creature_proto SET npcflags = 129 WHERE npcflags = 5;
UPDATE creature_proto SET npcflags = 128 WHERE npcflags = 4;
UPDATE creature_proto SET npcflags = 1048576 WHERE npcflags = 2048;

If you find any more fixes!! PLEASE post them here.

i have alot made a .txt and put it on filebeam for people to download this rather than copy and paste each section you can here



hope this helps some people

[*TraPStaR*]

copy paste FTW give credits to the people at ascent emu

[sadgonewild]

copy paste FTW give credits to the people at ascent emu

haha done, wasnt all copy n paste btw,

half of the items were mine,

just made it easy for every.

like it says in the post, was never asking for fame!

[Summer]

Thx =)

But i Got One Problem Cant Open Zul'aman Plz Help Me
Will +Rep When i Can

[sadgonewild]

Thx =)

But i Got One Problem Cant Open Zul'aman Plz Help Me
Will +Rep When i Can

did u try both the scrips?

if not try them

[lazzer]

ehhh.. i cant execute the scripts it says

 
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `worldmap_info` VALUES (568, 568, 1, 10, 70, 119.152, 1761.11, 42.80' at line 3
[Err] INSERT INTO `areatriggers` (`entry`,`type`,`map`,`screen`,`name`,`position_x`,`position_y`,`position_z`,`required_level`) VALUES ('5000','1','568','568','Zul\'Aman','119.152','1761.11','42.8081','70')
INSERT INTO `worldmap_info` VALUES (568, 568, 1, 10, 70, 119.152, 1761.11, 42.8081, 568, 'Zul''Aman', 3, 259200, 0, 0, 0, 0, 0, 80, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Can anyone help me? :/

[sadgonewild]

ehhh.. i cant execute the scripts it says

 
[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'INSERT INTO `worldmap_info` VALUES (568, 568, 1, 10, 70, 119.152, 1761.11, 42.80' at line 3
[Err] INSERT INTO `areatriggers` (`entry`,`type`,`map`,`screen`,`name`,`position_x`,`position_y`,`position_z`,`required_level`) VALUES ('5000','1','568','568','Zul\'Aman','119.152','1761.11','42.8081','70')
INSERT INTO `worldmap_info` VALUES (568, 568, 1, 10, 70, 119.152, 1761.11, 42.8081, 568, 'Zul''Aman', 3, 259200, 0, 0, 0, 0, 0, 80, 0);
[Msg] Finished - Unsuccessfully
--------------------------------------------------

Can anyone help me? :/

you need to update the "rev" you are using.

have a look in ascent guides there are alot there.

[lazzer]

ok , do you know which? im using rescent 2340 shouldnt it be new enough?