if you need query just come here

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as

begin tran

declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (??¼±E£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID

if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end

insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (??¼±E£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (??¼±E£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- AI?¥??¸® »?¼? ½C??!
rollback tran
return -2
end

set @Slot = @Slot + 1
end
end

/* --´? A?»? A? ??·³??´A µ¥A???¸¦ ³??? ¾E´A´U!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end

--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0, 0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS

end

commit tran

return @COS_ID

USE(SRO_VT_SHARD)
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'YourCharName'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,1

USE SRO_VT_SHARD /* Add new Teleport */


DECLARE @Teleport VARCHAR (64)
DECLARE @CHARNAME1 VARCHAR (30)
DECLARE @CHARNAME2 VARCHAR (30)
DECLARE @OwnTeleport INT
DECLARE @Fee INT
DECLARE @RequiredLVL INT

/* Put your settings here */
SET @Teleport = 'PVP_ZONE' -- any name you want ex: PK_ZONE or PVP_ZONE
SET @CHARNAME1 = 'CHARNAME1' -- Teleport position
SET @CHARNAME2 = 'CHARNAME2' -- Spawn position after teleport
SET @OwnTeleport = 1 -- Target teleport ID ex: 1 for Jangan - 5 for Hotan - 20 for Constantinople
SET @Fee = 50000 -- Gold amount to Pass the teleport
SET @RequiredLVL = 0 -- minimum level required to teleport 0 for no restriction - ex:90 lvl 90 and higher can teleport
/* settings area end here */

IF EXISTS (SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = 'STORE_'+@Teleport)
BEGIN
raiserror('The stated teleportname of %s is already exist!',11,1,@Teleport);
RETURN;
END

DECLARE @MAXOBJ INT = (SELECT MAX (ID) FROM _RefObjCommon)+1
DECLARE @REGION1 INT SET @REGION1 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSX1 INT SET @POSX1 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSY1 INT SET @POSY1 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @POSZ1 INT SET @POSZ1 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME1)
DECLARE @LINK INT = (SELECT MAX (ID) FROM _RefObjStruct)+1

SET IDENTITY_INSERT _RefObjCommon ON
INSERT INTO _RefObjCommon (Service,ID,CodeName128,ObjName128,OrgObjCodeName1 28,NameStrID128,DescStrID128,CashItem,Bionic,TypeI D1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarit y,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPic k,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRe pair,CostRevive,CostBorrow,KeepingFee,SellPrice,Re qLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqL evelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCon tain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,S peed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj 128,AssocFileDrop128,AssocFileIcon128,AssocFile1_1 28,AssocFile2_128,Link) VALUES
(1,@MAXOBJ,'STORE_'+@Teleport,@Teleport,'xxx','SN_ STORE_'+@Teleport,'xxx',0,0,4,1,1,0,0,3,0,0,0,0,0, 0,0,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,@REGION1,0,@POSX1,@POSY1,@POSZ1,0,0,50,50,30,0,' quest\teleport01.bsr','xxx','xxx','xxx','xxx',@lin k)
SET IDENTITY_INSERT _RefObjCommon OFF

print ''
print 'Add the following line to teleportbuilding.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXOBJ)+' '+'STORE_'+@Teleport+' '+@Teleport+' xxx '+'SN_STORE_'+@Teleport+' xxx 0 0 4 1 1 0 0 3 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 -1 0 -1 0 -1 0 -1 0 -1 '+CONVERT(varchar(max),@REGION1)+' 0 '+CONVERT(varchar(max),@POSX1)+' '+CONVERT(varchar(max),@POSY1)+' '+CONVERT(varchar(max),@POSZ1)+' 0 0 50 50 30 0 quest\teleport01.bsr xxx xxx xxx xxx '+CONVERT(varchar(max),@link)
print ''
print 'Add the following line to textdata_object.txt @server_dep\silkroad\textdata folder'
print ''
print '1 '+'SN_STORE_'+@Teleport+' '+@Teleport
print ''
print ''

SET IDENTITY_INSERT _RefObjStruct ON
INSERT INTO _RefObjStruct (ID,Dummy_Data) VALUES
(@LINK,0)
SET IDENTITY_INSERT _RefObjStruct OFF

DECLARE @MAXTELID INT = (SELECT MAX (ID) FROM _RefTeleport)+1
DECLARE @WORLDID INT = (SELECT (WorldID) FROM _Char where CharName16 = @CHARNAME2)
DECLARE @REGION2 INT SET @REGION2 = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSX2 INT SET @POSX2 = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSY2 INT SET @POSY2 = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME2)
DECLARE @POSZ2 INT SET @POSZ2 = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME2)

INSERT INTO _RefTeleport (Service,ID,CodeName128,AssocRefObjCodeName128,Ass ocRefObjID,ZoneName128,GenRegionID,GenPos_X,GenPos _Y,GenPos_Z,GenAreaRadius,CanBeResurrectPos,CanGot oResurrectPos,GenWorldID,BindInteractionMask,Fixed Service) VALUES
(1,@MAXTELID,'GATE_'+@Teleport,'STORE_'+@Teleport, @MAXOBJ,'SN_STORE_'+@Teleport,@REGION2,@POSX2,@POS Y2,@POSZ2,30,0,0,@WORLDID,1,0)

print ''
print 'Add the following line to teleportdata.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+'GATE_'+@Teleport+' '+CONVERT(varchar(max),@MAXOBJ)+' '+'SN_STORE_'+@Teleport+' '+CONVERT(varchar(max),@REGION2)+' '+CONVERT(varchar(max),@POSX2)+' '+CONVERT(varchar(max),@POSY2)+' '+CONVERT(varchar(max),@POSZ2)+' 30 0 0 '+CONVERT(varchar(max),@WORLDID)+' 1 0'
print ''
print ''

IF @RequiredLVL = 0
BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0)
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@MAXTELID,@OwnTeleport,@Fee,0,0,0,0,0,0,0,0,0,0 ,0,0,0,0,0,0,0,0)

print ''
print 'Add the following lines to teleportlink.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print '1 '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0'
print ''
END
ELSE BEGIN
INSERT INTO _RefTeleLink (Service,OwnerTeleport,TargetTeleport,Fee,Restrict BindMethod,RunTimeTeleportMethod,CheckResult,Restr ict1,Data1_1,Data1_2,Restrict2,Data2_1,Data2_2,Res trict3,Data3_1,Data3_2,Restrict4,Data4_1,Data4_2,R estrict5,Data5_1,Data5_2) VALUES
(1,@OwnTeleport,@MAXTELID,@Fee,0,0,0,1,@RequiredLV L,999,0,0,0,0,0,0,0,0,0,0,0,0)

print ''
print ''
print 'Add the following line to teleportlink.txt @server_dep\silkroad\textdata folder'
print '1 '+CONVERT(varchar(max),@OwnTeleport)+' '+CONVERT(varchar(max),@MAXTELID)+' '+CONVERT(varchar(max),@Fee)+' 0 0 0 1 '+CONVERT(varchar(max),@RequiredLVL)+' 999 0 0 0 0 0 0 0 0 0 0 0 0'
print ''

END

print ''
print 'Done!'

USE SRO_VT_ACCOUNT;
GO
INSERT INTO SK_SILK
(JID,
silk_own,
silk_gift,
silk_point)
SELECT JID,
'0',
'0',
'0'
FROM TB_User
WHERE not exists (select * from SK_Silk
WHERE SK_SILK.JID = TB_User.JID);
UPDATE SK_Silk SET silk_own=silk_own+1000

USE SRO_VT_SHARD /* Add Unique Spot */

DECLARE @UNIQUE VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)
DECLARE @mindealy INT
DECLARE @maxdelay int
DECLARE @INITRADIUS INT
DECLARE @RADIUS int
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1

/* put your settings here */
SET @UNIQUE = 'MOB_SD_SELKIS' -- Unique code name from _RefobjCommon table
SET @CHARNAME = '[Developer]Zac' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 1800 -- Minimum time before appears in seconds
SET @maxdelay = 1800 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @RADIUS = 500 -- Radius around spot Unique can move in
/* end of settings area */

/* get ID of mob by code name */
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)

SET IDENTITY_INSERT Tab_RefTactics ON
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStam inaVariance,nSightRange,btAggressType,AggressData, btChangeTarget,btHelpRequestTo,btHelpResponseTo,bt BattleStyle,BattleStyleData,btDiversionBasis,Diver sionBasisData1,DiversionBasisData2,DiversionBasisD ata3,DiversionBasisData4,DiversionBasisData5,Diver sionBasisData6,DiversionBasisData7,DiversionBasisD ata8,btDiversionKeepBasis,DiversionKeepBasisData1, DiversionKeepBasisData2,DiversionKeepBasisData3,Di versionKeepBasisData4,DiversionKeepBasisData5,Dive rsionKeepBasisData6,DiversionKeepBasisData7,Divers ionKeepBasisData8,btKeepDistance,KeepDistanceData, btTraceType,btTraceBoundary,TraceData,btHomingType ,HomingData,btAggressTypeOnHoming,btFleeType,dwCha mpionTacticsID,AdditionOptionFlag,szDescString128) VALUES
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0 ,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0, 2,0,0,112,@UNIQUE)
SET IDENTITY_INSERT Tab_RefTactics OFF

SET IDENTITY_INSERT Tab_RefHive ON
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTot alCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRat e,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjTyp e,szDescString128) VALUES
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)
SET IDENTITY_INSERT Tab_RefHive OFF

/* get position coordinates of your character */

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)

SET IDENTITY_INSERT Tab_RefNest ON
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalP osX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGen erateRadius,nChampionGenPercentage,dwDelayTimeMin, dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,bt Type) VALUES
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY ,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay ,1,0,1,0)
SET IDENTITY_INSERT Tab_RefNest OFF


print ''
print ''
print 'Done!'

Back UP Creat ON C Backup folder

USE SRO_VT_SHARD;
GO
BACKUP DATABASE SRO_VT_SHARD
TO DISK = 'C:\BACKUP\SRO_VT_SHARD.Bak'
WITH FORMAT,
MEDIANAME = 'SRO_VT_SHARD',
NAME = 'Full Backup of SRO_VT_SHARD';
GO


USE SRO_VT_ACCOUNT;
GO
BACKUP DATABASE SRO_VT_ACCOUNT
TO DISK = 'C:\BACKUP\SRO_VT_ACCOUNT.Bak'
WITH FORMAT,
MEDIANAME = 'SRO_VT_ACCOUNT',
NAME = 'Full Backup of SRO_VT_ACCOUNT';
GO


USE SRO_VT_SHARDLOG;
GO
BACKUP DATABASE SRO_VT_SHARDLOG
TO DISK = 'C:\BACKUP\SRO_VT_SHARDLOG.Bak'
WITH FORMAT,
MEDIANAME = 'SRO_VT_SHARDLOG',
NAME = 'Full Backup of SRO_VT_SHARDLOG';
GO

USE [master]

GO

ALTER LOGIN [sa] WITH PASSWORD=N'New Password', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF

GO

USE SRO_VT_SHARD

Declare @link int, @codename varchar(max), @level int, @newlevel int;

set @codename = 'SN_MOB_SD_HIKE' /* <- from textdata_object.txt */



set @link = (SELECT Link FROM _RefObJCommon WHERE NameStrID128 = @codename)
set @newlevel = (
case
when (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10 <= 120 THEN (SELECT Lvl FROM _RefObjChar WHERE ID = @link)+10
ELSE 120
end);

UPDATE _RefObjChar SET Lvl = @newlevel WHERE ID = @link
UPDATE _RefObjChar SET ExpToGive = cast(ExpToGive*1.1 as bigint) WHERE ID = @link
UPDATE _RefObjChar SET MaxHP = cast(MaxHP*1.1 as bigint) WHERE ID = @link

Media\server_dep\silkroad\textdata\textdata_object

USE [SRO_VT_SHARD]
DECLARE @KINGEDITOR1 VARCHAR (129)
DECLARE @CHARNAME VARCHAR (64)

SET @KINGEDITOR1 = 'NPC_EU_SPECIAL' ----- Your Npc Name
SET @CHARNAME = 'Twister' ----- Charactar name [ where you Want to set npc ]

Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1)
Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1)
Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2)

Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME)
Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME)

UPDATE Tab_RefNest
SET nregiondbid = @ASpos1,
flocalposx = @ASpos2,
flocalposy = @ASpos3,
flocalposz = @ASpos4
WHERE dwnestid = @AS3 and dwtacticsid = @AS2

USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET DropCount = 0
WHERE RefItemID BETWEEN 10897 AND 11416


UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET Prob_Absolute = 0
WHERE RefItemID BETWEEN 10897 AND 11416



UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 14181 AND 14869

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 12844 AND 14180

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 11417 AND 12843

UPDATE dbo._RefDropItemAssign
SET Prob_Relative = 0
WHERE RefItemID BETWEEN 10897 AND 11416

USE [SRO_VT_SHARD]

UPDATE _RefMonster_AssignedItemRndDrop set DropRatio = '1.65' where DropRatio = '0.33'
UPDATE _RefMonster_AssignedItemRndDrop set DropRatio = '0.825' where DropRatio = '0.11'

Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'ITEM_CH_TBLADE_11_SET_A_RARE'

USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare @CharName varchar(64)

set @CharName = 'GM'

exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_AVATAR_M_GM_UNIFORM',1,0

Use Sro_vt_shard select ID from _RefObjCommon where CodeName128 like 'MOB_RM_ROC'

USE [SRO_VT_SHARD]
DECLARE @Rate INT
SET @Rate = '100' -- Rate here
UPDATE [dbo].[_RefLevel]
SET

[JobExp_Trader] = [JobExp_Trader]/@Rate
,
[JobExp_Robber] = [JobExp_Robber]/@Rate
,
[JobExp_Hunter] = [JobExp_Hunter]/@Rate
WHERE [Lvl] BETWEEN 1 and 7


SELECT
*
FROM _RefLevel
WHERE Lvl BETWEEN 1 AND 140;

USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_ADD_ITEM_EXTERN] Script Date: 4/23/2017 5:55:18 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO







ALTER procedure [dbo].[_ADD_ITEM_EXTERN]
@charname varchar(64),
@codename varchar(128),
@data int,
@opt_level int
as
declare @charid int
declare @ref_item_id int
declare @link_to_item int
declare @inv_capacity int

set @inv_capacity = 45

if (not exists (select * from _RefObjCommon where Codename128 = @codename))
begin
raiserror('unknown item: %s', 1, 12, @codename)
return -1
end
if (not exists (select * from _char with (nolock) where charname12 = @charname))
begin
raiserror('not existing character: %s', 1, 12, @charname)
return -2
end
select @charid = charid, @inv_capacity = InventorySize from _char with (nolock) where charname12 = @charname
if (not exists (select * from _inventory with (nolock) where charid = @charid and slot >= 13 and slot < @inV_capacity and itemid = 0))
begin
raiserror('Inventory Full: %s', 1, 12, @charname)
return -3 -- inventory full
end
declare @empty_slot int
select top 1 @empty_slot = slot from _inventory with (nolock) where charid = @charid and slot >= 13 and slot < @inV_capacity and itemid = 0 order by slot
set @ref_item_id = 0
set @link_to_item = 0
select @ref_item_id = id, @link_to_item = link from _RefObjCommon where codename128 = @codename
if (@ref_item_id = 0 or @ref_item_id is null)
begin
raiserror('@RefItemID == NULL: %s', 1, 12, @charname)
return -4
end
if (@link_to_item = 0 or @link_to_item is null)
begin
raiserror('RefItem Link == NULL: %s', 1, 12, @charname)
return -5
end
declare @tid1 int
declare @tid2 int
declare @tid3 int
declare @tid4 int
select @tid1 = TypeID1, @tid2 = TypeID2, @tid3 = TypeID3, @tid4 = TypeID4 from _RefObjCommon where ID = @ref_item_id
declare @IS_EQUIP int
declare @IS_PET int
set @IS_EQUIP = 0
set @IS_PET = 0
if (@tid1 <> 3)
begin
raiserror('not item: %s, %s', 1, 12, @charname, @codename)
return -6 -- ?AA×! ¾?A??UA? ¾?´I¾??
end
if (@tid1 = 3 and @tid2 = 1)
set @IS_EQUIP = 1
else if (@tid1 = 3 and @tid2 = 2 and @tid3 = 1 and (@tid4 = 1 or @tid4 = 2 ) )
set @IS_PET = 1
declare @item_id bigint
set @item_id = 0

declare @dummy_serial_number bigint
set @dummy_serial_number = 0
if (@IS_EQUIP = 1)
begin
declare @dur int
select @dur = Dur_L from _RefObjItem where ID = @link_to_item
set @data = @dur
if (@opt_level < 0)
set @opt_level = 0
else if (@opt_level > 12)
set @opt_level = 12

declare @remain_gold bigint
select @remain_gold = remaingold from _char where charid = @charid
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- »???°³?? (??¼±E£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
exec _STRG_ADD_EQUIP_NORMAL @item_id output, @dummy_serial_number output, 6, @charid, @empty_slot, @ref_item_id, @opt_level, 0, @data
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
end
else
begin
if( @IS_PET = 1 )
set @data = 0
else
begin
declare @max_count int
select @max_count = MaxStack from _RefObjItem where ID = @link_to_item

if (@data <= 0 or @data > @max_count)
begin
set @data = @max_count
end
end

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- »???°³?? (??¼±E£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
exec _STRG_ADD_EXPENDABLE @item_id output, @dummy_serial_number output, 6, @charid, @empty_slot, @ref_item_id, @data

--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
end

if (@item_id > 0)
return 1
else
begin
raiserror('failed for unknown reason: %s, %s', 1, 12, @charname, @codename)
return -7
end

USE SRO_VT_SHARD
DECLARE @CodeName VARCHAR(30)
DECLARE @MaxStack INT
SET @CodeName='Code'
SET @MaxStack=1000
UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)

USE [SRO_VT_SHARD_INIT]
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='841489940',Param3='336860180',Param4='3362 02250' where ID='2044'

USE SRO_VT_SHARD
GO
UPDATE _RefObjItem
SET Param4 = 5
WHERE ID BETWEEN 4630 AND 5013

USE SRO_VT_SHARD
GO
Declare @ItemCode varchar(max) = '%ITEM_CH_%_14_%'
DELETE _RefMonster_AssignedItemDrop
FROM _RefMonster_AssignedItemDrop Drops
LEFT JOIN _RefObjCommon Objects
ON (Drops.RefItemID = Objects.ID)
WHERE CodeName128 like @ItemCode

USE SRO_VT_SHARD
UPDATE _SiegeFortress SET GuildID = 0

USE [SRO_VT_SHARD]

Exec [Dbo].[_SEEK_N_DESTROY_ITEM] ['ITEM_COS_P_RABBIT_SCROLL' ]

USE SRO_VT_SHARD
DELETE FROM _TimedJob WHERE CharID = 'ID'

remove tablets
Update _RefDropItemAssign
set service = 0
where RefItemID between 6295 and 6678




add stone
Update _RefDropItemAssign
set service = 1
where RefItemID between 6679 and 7062

USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0

DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD //
DECLARE @NewPrice INT
DECLARE @NewStack INT
DECLARE @NewSellPrice INT
SET @NewQuot = 99.9 -- Doubles the profit % trough "2.0" (e.g. 2.6 is also possible)
SET @NewPrice = 9999 -- Goods Price @ the Shop
SET @NewStack = 9999 -- Increases/Decreases the maximum Stack, Default = 40
SET @NewSellPrice = 999 -- Goods Price if you sell them directly again - without trading.

-- Profit %

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401

UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672

-- Price / SellPrice

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 2147 AND 2158

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 2147 AND 2158

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 10394 AND 10401

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 10394 AND 10401

UPDATE [dbo].[_RefObjCommon]
SET Price = @NewPrice
WHERE ID BETWEEN 24671 AND 24672

UPDATE [dbo].[_RefObjCommon]
SET SellPrice = @NewSellPrice
WHERE ID BETWEEN 24671 AND 24672

-- MaxStack

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 1926 AND 1937

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 5881 AND 5888

UPDATE [dbo].[_RefObjItem]
SET MaxStack = @NewStack
WHERE ID BETWEEN 11159 AND 11160

-- Price

UPDATE [dbo].[_RefPricePolicyOfItem]
SET Cost = @NewPrice
Where RefPackageItemCodeName like '%ITEM_ETC_TRADE%'

USE SRO_VT_SHARD
DECLARE @RefID int
SELECT @RefID = R.dwTacticsID
FROM Tab_RefTactics R
JOIN _RefObjCommon O
ON O.ID = R.dwObjID
WHERE O.CodeName128 LIKE 'MOB_RM_TAHOMET'
Update Tab_RefNest Set dwDelayTimeMin = 7200 , dwDelayTimeMax = 900 WHERE dwTacticsID = @RefID
Select * FROM Tab_RefNest WHERE dwTacticsID = @RefID

USE [SRO_VT_SHARD]
DECLARE @CharName varchar(255)
DECLARE @CharID INT
SET @CharName='MyReturn'
SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName
UPDATE _CharSkillMastery SET Level = '120' WHERE CharID=@CharID
INSERT INTO _CharSkill VALUES (@CharID,1,1)
INSERT INTO _CharSkill VALUES (@CharID,2,1)
INSERT INTO _CharSkill VALUES (@CharID,40,1)
INSERT INTO _CharSkill VALUES (@CharID,70,1)
INSERT INTO _CharSkill VALUES (@CharID,298,1)
INSERT INTO _CharSkill VALUES (@CharID,306,1)
INSERT INTO _CharSkill VALUES (@CharID,314,1)
INSERT INTO _CharSkill VALUES (@CharID,322,1)
INSERT INTO _CharSkill VALUES (@CharID,346,1)
INSERT INTO _CharSkill VALUES (@CharID,378,1)
INSERT INTO _CharSkill VALUES (@CharID,418,1)
INSERT INTO _CharSkill VALUES (@CharID,463,1)
INSERT INTO _CharSkill VALUES (@CharID,558,1)
INSERT INTO _CharSkill VALUES (@CharID,569,1)
INSERT INTO _CharSkill VALUES (@CharID,580,1)
INSERT INTO _CharSkill VALUES (@CharID,588,1)
INSERT INTO _CharSkill VALUES (@CharID,596,1)
INSERT INTO _CharSkill VALUES (@CharID,604,1)
INSERT INTO _CharSkill VALUES (@CharID,647,1)
INSERT INTO _CharSkill VALUES (@CharID,655,1)
INSERT INTO _CharSkill VALUES (@CharID,672,1)
INSERT INTO _CharSkill VALUES (@CharID,689,1)
INSERT INTO _CharSkill VALUES (@CharID,699,1)
INSERT INTO _CharSkill VALUES (@CharID,708,1)
INSERT INTO _CharSkill VALUES (@CharID,716,1)
INSERT INTO _CharSkill VALUES (@CharID,724,1)
INSERT INTO _CharSkill VALUES (@CharID,735,1)
INSERT INTO _CharSkill VALUES (@CharID,746,1)
INSERT INTO _CharSkill VALUES (@CharID,757,1)
INSERT INTO _CharSkill VALUES (@CharID,765,1)
INSERT INTO _CharSkill VALUES (@CharID,773,1)
INSERT INTO _CharSkill VALUES (@CharID,781,1)
INSERT INTO _CharSkill VALUES (@CharID,789,1)
INSERT INTO _CharSkill VALUES (@CharID,797,1)
INSERT INTO _CharSkill VALUES (@CharID,805,1)
INSERT INTO _CharSkill VALUES (@CharID,813,1)
INSERT INTO _CharSkill VALUES (@CharID,821,1)
INSERT INTO _CharSkill VALUES (@CharID,829,1)
INSERT INTO _CharSkill VALUES (@CharID,853,1)
INSERT INTO _CharSkill VALUES (@CharID,885,1)
INSERT INTO _CharSkill VALUES (@CharID,925,1)
INSERT INTO _CharSkill VALUES (@CharID,933,1)
INSERT INTO _CharSkill VALUES (@CharID,943,1)
INSERT INTO _CharSkill VALUES (@CharID,952,1)
INSERT INTO _CharSkill VALUES (@CharID,960,1)
INSERT INTO _CharSkill VALUES (@CharID,968,1)
INSERT INTO _CharSkill VALUES (@CharID,976,1)
INSERT INTO _CharSkill VALUES (@CharID,984,1)
INSERT INTO _CharSkill VALUES (@CharID,992,1)
INSERT INTO _CharSkill VALUES (@CharID,1003,1)
INSERT INTO _CharSkill VALUES (@CharID,1014,1)
INSERT INTO _CharSkill VALUES (@CharID,1025,1)
INSERT INTO _CharSkill VALUES (@CharID,1033,1)
INSERT INTO _CharSkill VALUES (@CharID,1041,1)
INSERT INTO _CharSkill VALUES (@CharID,1049,1)
INSERT INTO _CharSkill VALUES (@CharID,1053,1)
INSERT INTO _CharSkill VALUES (@CharID,1057,1)
INSERT INTO _CharSkill VALUES (@CharID,1065,1)
INSERT INTO _CharSkill VALUES (@CharID,1073,1)
INSERT INTO _CharSkill VALUES (@CharID,1081,1)
INSERT INTO _CharSkill VALUES (@CharID,1089,1)
INSERT INTO _CharSkill VALUES (@CharID,1099,1)
INSERT INTO _CharSkill VALUES (@CharID,1108,1)
INSERT INTO _CharSkill VALUES (@CharID,1116,1)
INSERT INTO _CharSkill VALUES (@CharID,1124,1)
INSERT INTO _CharSkill VALUES (@CharID,1132,1)
INSERT INTO _CharSkill VALUES (@CharID,1140,1)
INSERT INTO _CharSkill VALUES (@CharID,1148,1)
INSERT INTO _CharSkill VALUES (@CharID,1153,1)
INSERT INTO _CharSkill VALUES (@CharID,1158,1)
INSERT INTO _CharSkill VALUES (@CharID,1163,1)
INSERT INTO _CharSkill VALUES (@CharID,1168,1)
INSERT INTO _CharSkill VALUES (@CharID,1173,1)
INSERT INTO _CharSkill VALUES (@CharID,1178,1)
INSERT INTO _CharSkill VALUES (@CharID,1189,1)
INSERT INTO _CharSkill VALUES (@CharID,1200,1)
INSERT INTO _CharSkill VALUES (@CharID,1217,1)
INSERT INTO _CharSkill VALUES (@CharID,1234,1)
INSERT INTO _CharSkill VALUES (@CharID,1244,1)
INSERT INTO _CharSkill VALUES (@CharID,1253,1)
INSERT INTO _CharSkill VALUES (@CharID,1261,1)
INSERT INTO _CharSkill VALUES (@CharID,1269,1)
INSERT INTO _CharSkill VALUES (@CharID,1271,1)
INSERT INTO _CharSkill VALUES (@CharID,1273,1)
INSERT INTO _CharSkill VALUES (@CharID,1275,1)
INSERT INTO _CharSkill VALUES (@CharID,1286,1)
INSERT INTO _CharSkill VALUES (@CharID,1297,1)
INSERT INTO _CharSkill VALUES (@CharID,1308,1)
INSERT INTO _CharSkill VALUES (@CharID,1316,1)
INSERT INTO _CharSkill VALUES (@CharID,1324,1)
INSERT INTO _CharSkill VALUES (@CharID,1332,1)
INSERT INTO _CharSkill VALUES (@CharID,1337,1)
INSERT INTO _CharSkill VALUES (@CharID,1342,1)
INSERT INTO _CharSkill VALUES (@CharID,1350,1)
INSERT INTO _CharSkill VALUES (@CharID,1358,1)
INSERT INTO _CharSkill VALUES (@CharID,1368,1)
INSERT INTO _CharSkill VALUES (@CharID,1377,1)
INSERT INTO _CharSkill VALUES (@CharID,1385,1)
INSERT INTO _CharSkill VALUES (@CharID,1393,1)
INSERT INTO _CharSkill VALUES (@CharID,1398,1)
INSERT INTO _CharSkill VALUES (@CharID,1403,1)
INSERT INTO _CharSkill VALUES (@CharID,1408,1)
INSERT INTO _CharSkill VALUES (@CharID,1410,1)
INSERT INTO _CharSkill VALUES (@CharID,1412,1)
INSERT INTO _CharSkill VALUES (@CharID,1414,1)
INSERT INTO _CharSkill VALUES (@CharID,1422,1)
INSERT INTO _CharSkill VALUES (@CharID,1430,1)
INSERT INTO _CharSkill VALUES (@CharID,1438,1)
INSERT INTO _CharSkill VALUES (@CharID,1443,1)
INSERT INTO _CharSkill VALUES (@CharID,1448,1)
INSERT INTO _CharSkill VALUES (@CharID,1465,1)
INSERT INTO _CharSkill VALUES (@CharID,1482,1)
INSERT INTO _CharSkill VALUES (@CharID,1499,1)
INSERT INTO _CharSkill VALUES (@CharID,1509,1)
INSERT INTO _CharSkill VALUES (@CharID,1518,1)
INSERT INTO _CharSkill VALUES (@CharID,1526,1)
INSERT INTO _CharSkill VALUES (@CharID,1534,1)
INSERT INTO _CharSkill VALUES (@CharID,1539,1)
INSERT INTO _CharSkill VALUES (@CharID,1544,1)
INSERT INTO _CharSkill VALUES (@CharID,1549,1)
INSERT INTO _CharSkill VALUES (@CharID,1557,1)
INSERT INTO _CharSkill VALUES (@CharID,1565,1)
INSERT INTO _CharSkill VALUES (@CharID,1573,1)
INSERT INTO _CharSkill VALUES (@CharID,1578,1)
INSERT INTO _CharSkill VALUES (@CharID,1583,1)
INSERT INTO _CharSkill VALUES (@CharID,1588,1)
INSERT INTO _CharSkill VALUES (@CharID,1593,1)
INSERT INTO _CharSkill VALUES (@CharID,1598,1)
INSERT INTO _CharSkill VALUES (@CharID,1609,1)
INSERT INTO _CharSkill VALUES (@CharID,1617,1)
INSERT INTO _CharSkill VALUES (@CharID,1628,1)
INSERT INTO _CharSkill VALUES (@CharID,3149,1)
INSERT INTO _CharSkill VALUES (@CharID,3167,1)
INSERT INTO _CharSkill VALUES (@CharID,3176,1)
INSERT INTO _CharSkill VALUES (@CharID,3224,1)
INSERT INTO _CharSkill VALUES (@CharID,3340,1)
INSERT INTO _CharSkill VALUES (@CharID,3349,1)
INSERT INTO _CharSkill VALUES (@CharID,3364,1)
INSERT INTO _CharSkill VALUES (@CharID,3379,1)
INSERT INTO _CharSkill VALUES (@CharID,3391,1)
INSERT INTO _CharSkill VALUES (@CharID,3406,1)
INSERT INTO _CharSkill VALUES (@CharID,3409,1)
INSERT INTO _CharSkill VALUES (@CharID,3415,1)
INSERT INTO _CharSkill VALUES (@CharID,3430,1)
INSERT INTO _CharSkill VALUES (@CharID,3431,1)
INSERT INTO _CharSkill VALUES (@CharID,3446,1)
INSERT INTO _CharSkill VALUES (@CharID,3461,1)
INSERT INTO _CharSkill VALUES (@CharID,3467,1)
INSERT INTO _CharSkill VALUES (@CharID,3473,1)
INSERT INTO _CharSkill VALUES (@CharID,7139,1)
INSERT INTO _CharSkill VALUES (@CharID,7159,1)
INSERT INTO _CharSkill VALUES (@CharID,7203,1)
INSERT INTO _CharSkill VALUES (@CharID,7322,1)
INSERT INTO _CharSkill VALUES (@CharID,7385,1)
INSERT INTO _CharSkill VALUES (@CharID,7390,1)
INSERT INTO _CharSkill VALUES (@CharID,7392,1)
INSERT INTO _CharSkill VALUES (@CharID,7404,1)
INSERT INTO _CharSkill VALUES (@CharID,7418,1)
INSERT INTO _CharSkill VALUES (@CharID,7474,1)
INSERT INTO _CharSkill VALUES (@CharID,7484,1)
INSERT INTO _CharSkill VALUES (@CharID,7513,1)
INSERT INTO _CharSkill VALUES (@CharID,7520,1)
INSERT INTO _CharSkill VALUES (@CharID,7536,1)
INSERT INTO _CharSkill VALUES (@CharID,7554,1)
INSERT INTO _CharSkill VALUES (@CharID,7577,1)
INSERT INTO _CharSkill VALUES (@CharID,7582,1)
INSERT INTO _CharSkill VALUES (@CharID,7584,1)
INSERT INTO _CharSkill VALUES (@CharID,7596,1)
INSERT INTO _CharSkill VALUES (@CharID,7612,1)
INSERT INTO _CharSkill VALUES (@CharID,7637,1)
INSERT INTO _CharSkill VALUES (@CharID,7651,1)
INSERT INTO _CharSkill VALUES (@CharID,7672,1)
INSERT INTO _CharSkill VALUES (@CharID,7675,1)
INSERT INTO _CharSkill VALUES (@CharID,7688,1)
INSERT INTO _CharSkill VALUES (@CharID,7798,1)
INSERT INTO _CharSkill VALUES (@CharID,7805,1)
INSERT INTO _CharSkill VALUES (@CharID,7829,1)
INSERT INTO _CharSkill VALUES (@CharID,7838,1)
INSERT INTO _CharSkill VALUES (@CharID,7839,1)
INSERT INTO _CharSkill VALUES (@CharID,7853,1)
INSERT INTO _CharSkill VALUES (@CharID,7862,1)
INSERT INTO _CharSkill VALUES (@CharID,7877,1)
INSERT INTO _CharSkill VALUES (@CharID,7881,1)
INSERT INTO _CharSkill VALUES (@CharID,7894,1)
INSERT INTO _CharSkill VALUES (@CharID,7899,1)
INSERT INTO _CharSkill VALUES (@CharID,7907,1)
INSERT INTO _CharSkill VALUES (@CharID,7919,1)
INSERT INTO _CharSkill VALUES (@CharID,7931,1)
INSERT INTO _CharSkill VALUES (@CharID,7938,1)
INSERT INTO _CharSkill VALUES (@CharID,7947,1)
INSERT INTO _CharSkill VALUES (@CharID,7953,1)
INSERT INTO _CharSkill VALUES (@CharID,7959,1)
INSERT INTO _CharSkill VALUES (@CharID,7962,1)
INSERT INTO _CharSkill VALUES (@CharID,7972,1)
INSERT INTO _CharSkill VALUES (@CharID,7980,1)
INSERT INTO _CharSkill VALUES (@CharID,7995,1)
INSERT INTO _CharSkill VALUES (@CharID,7997,1)
INSERT INTO _CharSkill VALUES (@CharID,8010,1)
INSERT INTO _CharSkill VALUES (@CharID,8024,1)
INSERT INTO _CharSkill VALUES (@CharID,8050,1)
INSERT INTO _CharSkill VALUES (@CharID,8084,1)
INSERT INTO _CharSkill VALUES (@CharID,8097,1)
INSERT INTO _CharSkill VALUES (@CharID,8103,1)
INSERT INTO _CharSkill VALUES (@CharID,8109,1)
INSERT INTO _CharSkill VALUES (@CharID,8115,1)
INSERT INTO _CharSkill VALUES (@CharID,8119,1)
INSERT INTO _CharSkill VALUES (@CharID,8129,1)
INSERT INTO _CharSkill VALUES (@CharID,8133,1)
INSERT INTO _CharSkill VALUES (@CharID,8142,1)
INSERT INTO _CharSkill VALUES (@CharID,8150,1)
INSERT INTO _CharSkill VALUES (@CharID,8164,1)
INSERT INTO _CharSkill VALUES (@CharID,8171,1)
INSERT INTO _CharSkill VALUES (@CharID,8183,1)
INSERT INTO _CharSkill VALUES (@CharID,8195,1)
INSERT INTO _CharSkill VALUES (@CharID,8204,1)
INSERT INTO _CharSkill VALUES (@CharID,8214,1)
INSERT INTO _CharSkill VALUES (@CharID,8220,1)
INSERT INTO _CharSkill VALUES (@CharID,8221,1)
INSERT INTO _CharSkill VALUES (@CharID,8238,1)
INSERT INTO _CharSkill VALUES (@CharID,8239,1)
INSERT INTO _CharSkill VALUES (@CharID,8250,1)
INSERT INTO _CharSkill VALUES (@CharID,8253,1)
INSERT INTO _CharSkill VALUES (@CharID,8276,1)
INSERT INTO _CharSkill VALUES (@CharID,8291,1)
INSERT INTO _CharSkill VALUES (@CharID,8304,1)
INSERT INTO _CharSkill VALUES (@CharID,8316,1)
INSERT INTO _CharSkill VALUES (@CharID,8320,1)
INSERT INTO _CharSkill VALUES (@CharID,8338,1)
INSERT INTO _CharSkill VALUES (@CharID,8347,1)
INSERT INTO _CharSkill VALUES (@CharID,8348,1)
INSERT INTO _CharSkill VALUES (@CharID,8361,1)
INSERT INTO _CharSkill VALUES (@CharID,8370,1)
INSERT INTO _CharSkill VALUES (@CharID,8379,1)
INSERT INTO _CharSkill VALUES (@CharID,8383,1)
INSERT INTO _CharSkill VALUES (@CharID,8390,1)
INSERT INTO _CharSkill VALUES (@CharID,8399,1)
INSERT INTO _CharSkill VALUES (@CharID,8405,1)
INSERT INTO _CharSkill VALUES (@CharID,8410,1)
INSERT INTO _CharSkill VALUES (@CharID,8414,1)
INSERT INTO _CharSkill VALUES (@CharID,8416,1)
INSERT INTO _CharSkill VALUES (@CharID,20494,1)
INSERT INTO _CharSkill VALUES (@CharID,20497,1)
INSERT INTO _CharSkill VALUES (@CharID,20500,1)
INSERT INTO _CharSkill VALUES (@CharID,21215,1)
INSERT INTO _CharSkill VALUES (@CharID,21217,1)
INSERT INTO _CharSkill VALUES (@CharID,30578,1)
INSERT INTO _CharSkill VALUES (@CharID,30584,1)
INSERT INTO _CharSkill VALUES (@CharID,30590,1)
INSERT INTO _CharSkill VALUES (@CharID,30596,1)
INSERT INTO _CharSkill VALUES (@CharID,30600,1)