الموقع العربي الاول للعبة Silkroad Online

بسم الله الرحمن الرحيم
دة اول موضوع ليا فى المنتدى
انشاء الله هتسفيدو من الموضوع دة
مش هطول عليكم اتفضلو 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
-------------------------------------------
يارب يعجبكم
ارجو التقيم
وشكرا
منقول
:mf_leia: