شوية Querys هتساعدك جامد

[Mr.Serag]

بسم الله الرحمن الرحيم
دة اول موضوع ليا فى المنتدى
انشاء الله هتسفيدو من الموضوع دة
مش هطول عليكم اتفضلو 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,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,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,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,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,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) 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
-------------------------------------------
يارب يعجبكم
ارجو التقيم
وشكرا
منقول