fix for akanon->steamfont (for MW_052_053 + )

[wize_one]

>> WARNING <<


>> WARNING <<


this is a temp fix, should it have been a real fix there would be more spam!.. (source into doors, and reboot world).....

INSERT INTO `doors` VALUES (9999,200,'Akanon','AKADOOR',56.47,-72.22,3.75,0,58,0,0,0,0,0,0,0,'Steamfont',0,0,0,99 9);

for some reason dest_x, dest_y, dest_z is not being read.


to get a good dest loc(if useing mw_052_053_alpha2 or the new release need to replace entry 350 in zone_points with,

INSERT INTO `zone_points` VALUES (350,'akanon',255,55,-73,4.38,0,'steamfont',-2052.35,540.89,-105,999,0,0,0);

.

[Chicomalo]

Hey wiz_one I try runing the command

INSERT INTO `zone_points` VALUES (350,'akanon',255,55,-73,4.38,0,'steamfont',-2052.35,540.89,-105,999,0,0,0);

and I got this error

ERROR 1061: Duplicate entry '350' for key 1

How can I delete that duplicate and enter the one your have provided?

[wize_one]

hmm overlooked part of the instruction..

to get a good dest loc(if useing mw_052_053_alpha2 or the new release need to replace entry 350 in zone_points with,
Quote:

INSERT INTO `zone_points` VALUES (350,'akanon',255,55,-73,4.38,0,'steamfont',-2052.35,540.89,-105,999,0,0,0);

could just delete 350 in zone_points then source in the sql line, or just hand edit it.

[Lurker_005]

instead of using

INSERT INTO

use

REPLACE INTO

That will overwrite any existing entry (if any)

[wize_one]

thanks Lurker..

/grin i just grabed the line from a dump of the table....

[Chicomalo]

Cool thanks, that works