Chrispees Mall & Julianx Mall

[djblade17]

Hey everyone i dont know if anyone ever wanted 2 different malls on a server but i did infact i want more but anyways im using the newest chrispee repack and wanted to include julianx mall well here is julianx mall edited by me its a work in progress

http://rapidshare.com/files/69170297/JulianXmallforchrispee.sql.html

EDIT: FIXED draenei and night elf and blood elf teleports FOR CHRISPEE

if anyone knows where i can find other shopping centers let me know

execute chrispee repack
then julianxxmallforchrispee

[weaselking1973]

are the both in the same spawn locations as originaly made?

[djblade17]

yes i have tested portals to mall from several locations
the only thing so far that i see that was affected was the beer stands at chrispees mall and the broom vendor i have to take a closer look into it
also if anyone else sees any bugs let me know

[weaselking1973]

are they both spawned in AV and GMIsland? mostly. if not then i need to set some gaurds around where they are spawned in this setup of yours

[djblade17]

normal places

[djblade17]

working on fix for draenei and night elf and blood elf teleports
if anyone is getting access violation error

[kate1]

Query:
/* Creature_spawns */
/* Creature_spawns */
INSERT INTO creature_spawns VALUES(540266390,300000,530,-3530.95,-109.254,304.497,3.45575,0,20023,1741,0,0,0,0,0)

Error occured at:2007-11-26 18:39:05
Line no.:222
Error Code: 1136 - Column count doesn't match value count at row 1

[Respawn]

nice man keap going

[Respawn]

Cant you put up some pics ower the malls??

[kate1]

can any1 plz help me with my problem?

[Humanfighter]

pic's plz?

[latruwski]

Query:
/* Creature_spawns */
/* Creature_spawns */
INSERT INTO creature_spawns VALUES(540266390,300000,530,-3530.95,-109.254,304.497,3.45575,0,20023,1741,0,0,0,0,0)

Error occured at:2007-11-26 18:39:05
Line no.:222
Error Code: 1136 - Column count doesn't match value count at row 1

well simple... your DB is not updated or is too new or something...
Column count doesn't match value count at row 1
i guess you know what this means... it means that the amount of numbers in this query:
INSERT INTO creature_spawns VALUES(540266390,300000,530,-3530.95,-109.254,304.497,3.45575,0,20023,1741,0,0,0,0,0)

does not match the amount of columns you have in the creature_spawns table... check the table for what column you could be missing or compare the sql file to your table ...and check what columns you are missing...

grtz

[Illidan1]

nice job mate, thanks for Posting them