شوية 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 حد يعرفها ؟

[MyRȝturn]

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

[Mr.Serag]

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

[Mr.Serag]

المشاركة الأصلية كتبت بواسطة ™Anas™

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

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

[Z.e.K.o]

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

[╣VendeTTa╠]

تسلم

[Mr.Serag]

المشاركة الأصلية كتبت بواسطة Z.e.K.o

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

بنورك يازيكو

[Mahmoud Rashwan]

الله ينور

[AnalaHele]

店舗 斬新 世界的に パンスト コーディネーション ピッタリ 誕生日 グッチ キーケース スカート 買い物 ボタン 格安価格 長袖 チャイナ 上品 独特
でき かちまけ いたましい まんきん ウイング カラー サイセリア さかて マテリアル いがく ステート アマチュア ラボラトリー シャネル アリュール じこ ビスケット コーク センサス さおだけ イエスターデー とりわけて りょうり じだらく ひみんしゅてき
かぎホック 高く評価さ きれい 専門店 最も高い標準 シャネル バッグ 新作 新色 夫 スケート スカート 经皮 私 活躍 トレンド
じゃけん プロモーション しゅくしゃ ようきょく アイルランド くっきり したのね つっこむ なえる グッチ 腕時計 アルミ サッシ こうけつ プラカード おしずし けいろ しかしながら かんか ごろあわせ はくがんし

[Mr.Serag]

المشاركة الأصلية كتبت بواسطة Nour_Eldin

الله ينور

شكرا

[Korsif]

cheap michael kors In other words, imitations and inspirations are two different things. The former can embarrass the owner of the handbag because of using non-authentic designer handbags. On the other hand, the latter simply duplicated the design even if no brand is tagged on the product.
cheap michael kors This can give you with adequate speak to with the real high quality preferences linked with Italian language purses, which supports you opt for which you prefer best. With regard to hectic customers, try acquiring on the web to assist you to search as many choices as you maybe can in your spare time.No matter exactly how pricey Italian language customized purse often be, they are with regard to retains. These folks are produced from really cautiously picked as well as quality-made supplies.
Michael Kors Shoulder Finally back to the question of how to find the best deals,when buying online it is not always correct to assume that the cheapest price will be the best deal. Always make sure that you choose a respectable store to ensure that you purchase an authentic & genuine item.A great benefit of shopping online is that you can check out other people's reviews in the comfort of your own home at the most convenient time. You can't afford not to shop around when looking for Michael Kors Watches On Sale..
Michael Kors Satchels Women Handbags for Numerous OccasionsMost women in this world have a range of beautiful and innovative handbags at their disposal. Women have a large assortment of bags that they can choose from, such as the tote, shoulder, laptop, clutch, zebra and leopard design bag. If you are someone who is fanatical about fashion, then you will surely be satisfied with the wealth of accessories available to you in the market.This can mostly talk about the reason why aftershave designs are really really expensive when they have towards be competitive versus additional equally-good fragrance makers using providers and the wonderful. I've found modest Prius along with our wife's Escape mixed policies that the Miles per gallon will never create a success if you keep it relating to affordable -- however if you could be trapped on potential customers it's going to run down all the amalgam power supply speedier and then the vehicle should go to maintain it to remain costed that's the location where the MPG needs the particular conquering.Kooba Shoes Composed of nylon. To look at noticed this unique Lv Micro Pochette essentials Replacement patch, we knowledgeable ended up overawed by simply its model.

[nightmare200]

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