Need SQL Table

06/02/2010 01:50 allaz123#1
Okey after i failed trying to make the startlocation to parca from Braiken/Loa, i f*** up my table, and ofc i have no backup cuz im a smartass.

Can someone open the table character.dbo.char_mappos
and just tell me the orginal 'table's" which is suppose to be there..
06/02/2010 09:02 pieter#2
lol ill give u one as example

in this one braiken sets your char to the parca niete spawn
loa works as it should

structure
Code:
CREATE TABLE [char_mappos] (
	[mapIndex] [int] NOT NULL ,
	[line_no] [int] NOT NULL ,
	[wPosX] [int] NULL ,
	[wPosY] [int] NULL ,
	[wRetPosX] [int] NULL ,
	[wRetPosY] [int] NULL ,
	[wMapIndex] [int] NULL ,
	[wRetMapIndex] [int] NULL ,
	[byDirection] [int] NULL ,
	[byRetDirection] [int] NULL ,
	[ipt_time] [datetime] NULL ,
	CONSTRAINT [PK_CHAR_MAPPOS] PRIMARY KEY  CLUSTERED 
	(
		[mapIndex],
		[line_no]
	) WITH  FILLFACTOR = 90  ON [FG_MST0] 
) ON [FG_MST0]
GO
contents (csv u can import it with Manager or studio)
Code:
0,1,416,203,416,203,6,6,0,0,2008-05-31 01:13:15.060000000
0,2,416,203,416,203,6,6,0,0,2008-05-31 01:13:15.060000000
0,3,416,203,416,203,6,6,0,0,2008-05-31 01:13:15.060000000
7,1,150,342,150,342,7,7,0,0,2008-05-31 01:13:15.060000000
7,2,354,146,354,146,7,7,0,0,2008-05-31 01:13:15.060000000
7,3,336,366,336,366,7,7,0,0,2008-05-31 01:13:15.060000000