شوية 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
-------------------------------------------
يارب يعجبكم
ارجو التقيم
وشكرا
منقول

[BomBom]

تمام الله ينور (Y)

[Golden sro]

شكرا

[™Anas™]

أنا عايز كويري عمل FB , Status حد يعرفها ؟

[Mr.Serag]

المشاركة الأصلية كتبت بواسطة ™Anas™ عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] أنا عايز كويري عمل FB , Status حد يعرفها ؟

دى من smc انتظر انشاء الله قريبا شرح ازاى تعمل FB من شرحى

[MyRȝturn]

تمــــــــــام
الله ينور

[Mr.Serag]

شكرا يارجالة على ردود الحلوة

[Z.e.K.o]

استمر ..... نورت المنتدى

[╣VendeTTa╠]

تسلم

[Mr.Serag]

المشاركة الأصلية كتبت بواسطة Z.e.K.o عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] استمر ..... نورت المنتدى

بنورك يازيكو

[Mahmoud Rashwan]

الله ينور

[Mr.Serag]

المشاركة الأصلية كتبت بواسطة Nour_Eldin عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ] الله ينور

شكرا

[nightmare200]

تسلم ايدك ياباشا

[nightmare200]

بس الكويري بتاع inventory دا غلط تقبل مروري

[elfr3on2010]

تسلم ايدك