[SQL] For delete Mobs

[magamio]

Me not programmer and not nice speak English but here my Script for delete Mob-Tactics From Tab_RefTactics.

Why need that?
This script need for server's that open oldschool(only China) game and have not more RAM

You need change name's of your DB and find line _RefRegion.ContinentName like 'JUPITER'
JUPITER - it's select all Region where name is 'JUPITER'

JUPITER - Jupiter
SD - DESERT OF ALEX
DELTA - Alexandria
Eu - Constantinople
Ca - Central Asia (Samarkand)
Pharaoh - HOLY TEMPLE
KingsValley - ALEX DOWN
TEMPLE - JOB CAVE ALEXANDRIA

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

 

[3oOomar]

Re: [Release][SQL] For delete Mobs

thank's

 

[evilheart]

Re: [Release][SQL] For delete Mobs

thanks

 

[evilheart]

Re: [Release][SQL] For delete Mobs

bro i have problem .. My Alex South / Norht NPC Gone

 

[LeMbo]

#Report This Query Remove NPC too !!

 

[Unrealx420]

Yeah this is why you shouldn't trust random queries made by a random noob.

 

[magamio]

bro i have problem .. My Alex South / Norht NPC Gone

If you can open eyes, can see that in my post

This script need for server's that open oldschool(only China) game and have not more RAM

 

[Eroticus]

I Want to use ur thing but can u help me to cancel deletion of "TEMPLE - JOB CAVE ALEXANDRIA"

Thank you.

 

[moseba123]

i need one for delet Event Mob have or other metedo : plis thx