[Help Thread] Please post your questions here.

07/02/2012 15:53 pprfds#826
ok the only thing i done is typing this code in sql [it doesnt work]

the code is

Quote:
USE [Arcadia]
GO
delete [dbo].[TacticalPositionResource] where dungeon_id=20000
go
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 0, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 1, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 2, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 3, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 4, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 5, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 6, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 7, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 202068, 28403, 126023)
GO
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 8, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 9, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 10, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 11, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 12, 202125, 23673, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 197417, 28580, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 198873, 28457, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 200546, 28391, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 202068, 28403, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 197026, 25926, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 198651, 25901, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 200339, 25945, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 202194, 26114, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 197324, 23734, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 198566, 23754, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 200370, 23657, 126023)
INSERT [dbo].[TacticalPositionResource] ([dungeon_id], [tactical_pos_id], [tactical_pos_x], [tactical_pos_y], [prop_id]) VALUES (20000, 13, 202125, 23673, 126023)
the warp code is

Quote:
/run warp(197417, 28580, "TwilightPrince")
07/02/2012 18:45 abdonight#827
helpppppppppppppp


[Only registered and activated users can see links. Click Here To Register...]
07/02/2012 21:14 pprfds#828
Quote:
Originally Posted by abdonight View Post
helpppppppppppppp


[Only registered and activated users can see links. Click Here To Register...]

update your windows to SP1
07/03/2012 14:55 c1ph3r#829
Quote:
Originally Posted by pprfds View Post
ok the only thing i done is typing this code in sql [it doesnt work]

the code is



the warp code is
You should add the layer to the warpcode

warp(197417, 28580, layer, "TwilightPrince")

Example:

/run warp(197417, 28580,1, "TwilightPrince")
07/03/2012 19:54 M@agma#830
Hello guys ;)
Let's take for example the NPC who sell 'Things' to make staged pet...(I dunno the name)
I want to add in this NPC , the JOKER Pet ... How can I do it pls ? (easy way). (Step by step pls) :D
And how can I change the prices of the items ?? Item by Item in any NPC :D pls .
Screenshot for the NPC where I want to add JOKER .
[Only registered and activated users can see links. Click Here To Register...]
07/03/2012 21:48 ghost_h#831
@M@agma
u can download some guys shared XXXX item shop..
read and learn it..
07/04/2012 12:25 c1ph3r#832
Quote:
Originally Posted by M@agma View Post
Hello guys ;)
Let's take for example the NPC who sell 'Things' to make staged pet...(I dunno the name)
I want to add in this NPC , the JOKER Pet ... How can I do it pls ? (easy way). (Step by step pls) :D
And how can I change the prices of the items ?? Item by Item in any NPC :D pls .
Screenshot for the NPC where I want to add JOKER .
[Only registered and activated users can see links. Click Here To Register...]
We need more brain in this community :D Go to dbo.marketresource...

1. Every NPC has his own contactscript.
2. Check this script in your NPCResource.
3. Go to your .lua Files and search for the script-function.
4. Look for the "open_market" command.
5. Go to your dbo.MarketResource and search for the marketname.
6. Add an Item to dbo.MarketResource and set the name to the marketname.
7. Your item will appear in the shop.

To change the goldamounts you have to modify the "price_ratio" value in dbo.MarketResource. It's kind of a multiplicator for the price from dbo.ItemResource.
07/04/2012 12:58 M@agma#833
Okey Thanks :D

I want to Know if it's possible to make Max rupee + Then 10 billion guys ;)
07/04/2012 13:01 pprfds#834
Quote:
Originally Posted by c1ph3r View Post
You should add the layer to the warpcode

warp(197417, 28580, layer, "TwilightPrince")

Example:

/run warp(197417, 28580,1, "TwilightPrince")


not this the problem

the problem is the portal dont show on layer 1 but on layer 0 it show but in layer 0 there is no monsters so i want the monsters to resbown in layer 0 and to fix the portal in layer 1
07/04/2012 13:16 c1ph3r#835
@pprfds
How did you add the portals?
07/04/2012 19:01 pprfds#836
i diddnt do any thing only i used the script that i post it may be the script worked on layer 0 only
07/04/2012 22:56 Stikmen#837
Hi there. Can any one help me?(

2012/07/05 02:52:40 DB COM ERROR: DB_EULAAccept: Could not find stored procedure "dbo.web_nflavor_accept"
I can play on my server but when my friend loged in and then try to connect to server i receive this in auth server
07/05/2012 11:43 ChoosenDark#838
Hi can someone please Teamview me to get this good damn server to work ??? its for me to use with a few friends when our normal server is down

i have SQL 2012, 7.3 Infinite files (think its the one with the skill bugs) the cube dungeon files (not yet added to DB) and I run windows 7 64

the coding side of it i should be able to manage its just i cannot get the server to connect and have now been trying for 3 days and have searched and searched the forums

Thanks
07/05/2012 12:36 M@agma#839
I searched in the forum but I didn't found what I need ;)
so I was wanderring If it's possible to change the name of NPC's?? :D
07/05/2012 12:39 c1ph3r#840
You have to modify the db_string.rdb...as far as i know names are client sided...