Mr.Serag
02-05-2013, 01:10 PM
بسم الله الرحمن الرحيم
دة اول موضوع ليا فى المنتدى
انشاء الله هتسفيدو من الموضوع دة
مش هطول عليكم اتفضلو Querys
Add item in Unique/Mob drop
USE SRO_VT_SHARD
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 3810
SET @DropRatio = 1
SET @ItemID = 24165
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
-------------------------------------------
Change magic pop rate
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! RageZone ! */
DECLARE @Rate int
SET @Rate = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
-------------------------------------------
Add New Unique spot
USE SRO_VT_SHARD
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_CH_TIGERWOMAN_L2' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'WildOne' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 1 -- Minimum time before appears in seconds
SET @maxdelay = 5 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @RADIUS = 200 -- 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!'
دة MOB_CH_TIGERWOMAN_L2 اسم اليونك تحط بدالو الاسم انتا عاوزة
ودة WildOne تحط بدالو اسم الشخصية انتا عاوز ينزل فية اليونيك
فى ناس ممكن تكون عارفة وناس لا فحبيت اوضح نكمل
-------------------------------------------
Change Stones rate
USE SRO_VT_SHARD
GO
UPDATE _RefObjItem
SET Param4 = Here Put The Rate You Want %
WHERE ID BETWEEN 4630 AND 5013
مكان Here Put The Rate You Want حط النسبة انتا عاوزة
-------------------------------------------
Change mob level
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
-------------------------------------------
Change inventory size by cher name
USE([SRO_VT_SHARD_INIT])
GO()
Declare @CharName Varchar (64)
Set @CharName = 'Kira'/* Char Name */
Update(dbo._Char)
InventorySize = 109 /* Number Of Slot Max 109 */
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
-------------------------------------------
for get Account data
/* B Y L E A N D R O N u k e r t u b e */
USE [SRO_VT_ACCOUNT]
/* B Y L E A N D R O N u k e r t u b e */
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_GetAccountData]
@CharName VARCHAR(30)
AS
BEGIN
SELECT
[SRO_VT_SHARD].[dbo].[_Char].[CharName16]as'Nome do Char',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[StrUserID]AS 'Login',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[password]as 'Senha',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[name]as 'Nome',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[Email]as 'E-Mail',
[SRO_VT_SHARD].[dbo].[_Char].[CharID]as 'Char ID',
[SRO_VT_SHARD].[dbo].[_User].[UserJID]AS 'Account JID',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[sec_content] as 'User Security Group'
FROM [SRO_VT_SHARD].[dbo].[_Char] INNER JOIN
[SRO_VT_SHARD].[dbo].[_User] ON
[SRO_VT_SHARD].[dbo].[_Char].[CharID]=
[SRO_VT_SHARD].[dbo].[_User].[CharID]
INNER JOIN
[SRO_VT_ACCOUNT].[dbo].[TB_User] ON
[SRO_VT_SHARD].[dbo].[_User].[UserJID] =
[SRO_VT_ACCOUNT].[dbo].[TB_User].[JID]
WHERE [SRO_VT_SHARD].[dbo].[_Char].[CharName16]LIKE @CharName
END
GO
/* B Y L E A N D R O N u k e r t u b e */
EXEC
USE [SRO_VT_ACCOUNT]
Exec [dbo].[_GetAccountData] 'PkMaximum'
-------------------------------------------
Coin Drop Amount & Rate
مفيد جدا لسيرفر 110
-- Coin DropAmount Query By ToLiv3 --
-- Copper Coin--
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN1%'
-- Gold Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN4%'
-- Silver Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN3%'
-- Iron Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN2%'
DropAmountMin=How many will drop at min
DropAmountMax=How many will drop at max
-------------------------------------------
يارب يعجبكم
ارجو التقيم
وشكرا
منقول
:mf_leia:
دة اول موضوع ليا فى المنتدى
انشاء الله هتسفيدو من الموضوع دة
مش هطول عليكم اتفضلو Querys
Add item in Unique/Mob drop
USE SRO_VT_SHARD
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = 3810
SET @DropRatio = 1
SET @ItemID = 24165
INSERT _RefMonster_AssignedItemDrop
(
RefMonsterID,
RefItemID,
DropGroupType,
OptLevel,
DropAmountMin,
DropAmountMax,
DropRatio,
RefMagicOptionID1,
CustomValue1,
RefMagicOptionID2,
CustomValue2,
RefMagicOptionID3,
CustomValue3,
RefMagicOptionID4,
CustomValue4,
RefMagicOptionID5,
CustomValue5,
RefMagicOptionID6,
CustomValue6,
RefMagicOptionID7,
CustomValue7,
RefMagicOptionID8,
CustomValue8,
RefMagicOptionID9,
CustomValue9,
RentCodeName
)
VALUES(@MonsterID , @ItemID, 0, 0, 1, 1, @DropRatio, 0, 0, 0, 0, 0, 0, 0, 0,
0, 0, 0, 0, 0, 0, 0, 0, 0 , 0 , 'xxx')
-------------------------------------------
Change magic pop rate
USE [SRO_VT_SHARD]
GO
/* MsSQL Script For Change Magic Pop Rates - CEZALAND - ! RageZone ! */
DECLARE @Rate int
SET @Rate = 10
UPDATE dbo._RefGachaItemSet SET Ratio = Ratio*@Rate WHERE Ratio*@Rate < 32768 -- 32767 max value for smallint
-------------------------------------------
Add New Unique spot
USE SRO_VT_SHARD
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_CH_TIGERWOMAN_L2' -- Unique code name from _RefobjCommon table
SET @CHARNAME = 'WildOne' -- Character name from _Char table to get mob position X Y Z
SET @mindealy = 1 -- Minimum time before appears in seconds
SET @maxdelay = 5 -- Maximum time before appears in seconds
SET @INITRADIUS = 100 -- Radius around spot unique can generated at
SET @RADIUS = 200 -- 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!'
دة MOB_CH_TIGERWOMAN_L2 اسم اليونك تحط بدالو الاسم انتا عاوزة
ودة WildOne تحط بدالو اسم الشخصية انتا عاوز ينزل فية اليونيك
فى ناس ممكن تكون عارفة وناس لا فحبيت اوضح نكمل
-------------------------------------------
Change Stones rate
USE SRO_VT_SHARD
GO
UPDATE _RefObjItem
SET Param4 = Here Put The Rate You Want %
WHERE ID BETWEEN 4630 AND 5013
مكان Here Put The Rate You Want حط النسبة انتا عاوزة
-------------------------------------------
Change mob level
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
-------------------------------------------
Change inventory size by cher name
USE([SRO_VT_SHARD_INIT])
GO()
Declare @CharName Varchar (64)
Set @CharName = 'Kira'/* Char Name */
Update(dbo._Char)
InventorySize = 109 /* Number Of Slot Max 109 */
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
-------------------------------------------
for get Account data
/* B Y L E A N D R O N u k e r t u b e */
USE [SRO_VT_ACCOUNT]
/* B Y L E A N D R O N u k e r t u b e */
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE procedure [dbo].[_GetAccountData]
@CharName VARCHAR(30)
AS
BEGIN
SELECT
[SRO_VT_SHARD].[dbo].[_Char].[CharName16]as'Nome do Char',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[StrUserID]AS 'Login',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[password]as 'Senha',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[name]as 'Nome',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[Email]as 'E-Mail',
[SRO_VT_SHARD].[dbo].[_Char].[CharID]as 'Char ID',
[SRO_VT_SHARD].[dbo].[_User].[UserJID]AS 'Account JID',
[SRO_VT_ACCOUNT].[dbo].[TB_User].[sec_content] as 'User Security Group'
FROM [SRO_VT_SHARD].[dbo].[_Char] INNER JOIN
[SRO_VT_SHARD].[dbo].[_User] ON
[SRO_VT_SHARD].[dbo].[_Char].[CharID]=
[SRO_VT_SHARD].[dbo].[_User].[CharID]
INNER JOIN
[SRO_VT_ACCOUNT].[dbo].[TB_User] ON
[SRO_VT_SHARD].[dbo].[_User].[UserJID] =
[SRO_VT_ACCOUNT].[dbo].[TB_User].[JID]
WHERE [SRO_VT_SHARD].[dbo].[_Char].[CharName16]LIKE @CharName
END
GO
/* B Y L E A N D R O N u k e r t u b e */
EXEC
USE [SRO_VT_ACCOUNT]
Exec [dbo].[_GetAccountData] 'PkMaximum'
-------------------------------------------
Coin Drop Amount & Rate
مفيد جدا لسيرفر 110
-- Coin DropAmount Query By ToLiv3 --
-- Copper Coin--
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN1%'
-- Gold Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN4%'
-- Silver Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN3%'
-- Iron Coin --
UPDATE dbo._RefMonster_AssignedItemRndDrop
Set DropAmountMin='1', DropAmountMax='5'
WHERE ItemGroupCodeName128 like '%SD_TOKEN2%'
DropAmountMin=How many will drop at min
DropAmountMax=How many will drop at max
-------------------------------------------
يارب يعجبكم
ارجو التقيم
وشكرا
منقول
:mf_leia: