EQEmulator Forums - fix for akanon->steamfont (for MW_052

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Archive::Database/World Building (https://www.eqemulator.org/forums/forumdisplay.php?f=625)

- - fix for akanon->steamfont (for MW_052_053 + ) (https://www.eqemulator.org/forums/showthread.php?t=11692)

wize_one

02-02-2004 03:49 PM

fix for akanon->steamfont (for MW_052_053 + )

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

Quote:

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,

Quote:

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

Chicomalo

02-04-2004 05:41 PM

Hey wiz_one I try runing the command

Quote:

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

Quote:

ERROR 1061: Duplicate entry '350' for key 1

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

wize_one

02-04-2004 05:48 PM

hmm overlooked part of the instruction..8)

Quote:

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

02-04-2004 05:51 PM

instead of using

Code:

INSERT INTO

use

Code:

REPLACE INTO

That will overwrite any existing entry (if any)

wize_one

02-04-2004 05:54 PM

thanks Lurker..

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

Chicomalo

02-04-2004 06:21 PM

Cool thanks, that works :D

All times are GMT -4. The time now is 04:15 AM.