help fast plz

11/28/2014 03:17 Maddona#1

i made this query in my game ! and deleted npc`s and mobs ?

i want just back npc`s ? where i can back it again ?

any one can answer me ?

Spoiler

11/28/2014 04:57 x*Manu*x#2

Quote:

Originally Posted by Maddona

i made this query in my game ! and deleted npc`s and mobs ?

i want just back npc`s ? where i can back it again ?

any one can answer me ?

Spoiler

USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO
USE [SRO_VT_SHARD]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[Region](
[ID] [nchar](10) NULL
) ON [PRIMARY]

GO
INSERT INTO Region (ID)
select
_RefRegion.wRegionID
from
_RefRegion
where
/* Set JUPITER name here like 'JUPITER'*/
_RefRegion.ContinentName like 'JUPITER'
GO
delete FROM Tab_RefNest
WHERE EXISTS (SELECT ID FROM Region WHERE ID = nRegionDBID)
USE [SRO_VT_SHARD]
GO
IF EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[dbo].[Region]') AND type in (N'U'))
DROP TABLE [dbo].[Region]
GO

haha sorry but i never laughed so hard :D

11/28/2014 15:22 Almighty Boosting#3

Delete System32 folder and restart pc twice.

11/28/2014 15:25 Zodiao#4

Quote:

Originally Posted by Almighty Boosting

Delete System32 folder and restart pc twice.

End of 2014, People still thinks commenting this is funny and smart.

11/28/2014 20:08 Lavita-Owner#5

solved ##