قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة[ قسم متخصص فى شروحات و البرامج في عمل السيرفرات الخاصة ] [ يرجى عدم وضع الأسئلة والاستفسارات في هذا القسم ]
USE [SRO_VT_ACCOUNT] GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[SK_gamebang_ip]( [nID] [smallint] NOT NULL, [ip] [int] NOT NULL, [capacity] [smallint] NOT NULL ) ON [PRIMARY] GO
[/SPOILER]
Query to Remove PK by CharName
كود PHP:
USE [SRO_VT_SHARD]
DECLARE @CharName Varchar(max)
SET @CharName = 'Charname'
UPDATE _Char SET
RemainHwanCount = 5,
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
WHERE CharName16 = @CharName
Query to Remove Pk All Players
كود PHP:
USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
Query to ban player by Char name
كود PHP:
USE [SRO_VT_SHARD]
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @CharName VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @CharName = 'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
-----------------------------------------------------------------
USE SRO_VT_ACCOUNT
DECLARE @ID VARCHAR (64)
DECLARE @Reason VARCHAR(128)
DECLARE @Begin DATETIME
DECLARE @End DATETIME
SET @ID = (Select STRuserID FROM TB_User Where JID = @AccJID)
---------------------------------
SET @Reason = 'Ban Reason Here'
SET @Begin = '2012-05-01 00:00:00.000' -- Time Begin --
SET @End = '2040-01-01 00:00:00.000' -- Time End --
---------------------------------
---------------------------
-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------
Query to Unban Player by Cahr Name
كود PHP:
USE [SRO_VT_SHARD]
GO
--------------------------------
DECLARE @ChrID INT;
DECLARE @CharName VARCHAR(64);
DECLARE @AccJID INT;
---------------------------------
SET @CharName = 'CharNameHere'---
---------------------------------
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
--------------------------------
USE [SRO_VT_ACCOUNT]
--------------------------------
DELETE FROM [dbo].[_BlockedUser]
WHERE UserJID = @AccJID
DELETE FROM [dbo].[_Punishment]
WHERE UserJID = @AccJID
-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------
/ تقدر تلاقي الـchar بـID
[SPOILER]
كود PHP:
USE SRO_VT_SHARD
DECLARE @ChrID INT;
DECLARE @CharName VARCHAR(30);
DECLARE @AccJID INT;
/* Set char name here */
SET @CharName='Test'
SET @ChrID=(SELECT CharID FROM _Char WHERE CharName16=@CharName)
SET @AccJID=(SELECT UserJID FROM _User WHERE CharID=@ChrID)
USE SRO_VT_ACCOUNT
SELECT * FROM TB_User WHERE JID=@AccJID
[/SPOILER]
/ تقدر تعمل
Restat characters, and set thier lvl
[SPOILER]
كود PHP:
USE SRO_VT_SHARD
DECLARE @CharLevel INT;
DECLARE @CharName char(30);
DECLARE @Level INT;
/* Set character name and lvl here */
SET @CharName='Test'
SET @Level=110
UPDATE _Char SET RemainStatPoint=0 WHERE CharName16=@CharName
UPDATE _Char SET CurLevel=@Level WHERE CharName16=@CharName
UPDATE _Char SET MaxLevel=@Level WHERE CharName16=@CharName
UPDATE _Char SET ExpOffset=0 WHERE CharName16=@CharName
UPDATE _Char SET Strength=20 WHERE CharName16=@CharName
UPDATE _Char SET Intellect=20 WHERE CharName16=@CharName
SET @CharLevel=(SELECT CurLevel FROM _Char WHERE CharName16=@CharName)
UPDATE _Char SET Strength=Strength+@CharLevel-1 WHERE CharName16=@CharName
UPDATE _Char SET Intellect=Intellect+@CharLevel-1 WHERE CharName16=@CharName
UPDATE _Char SET RemainStatPoint=(@CharLevel-1)*3 WHERE CharName16=@CharName
[/SPOILER]
/ تقدر تختار الـMOB او الـUNIQ
و تزود الـEXP بتاعو [SPOILER]
كود PHP:
USE SRO_VT_SHARD
DECLARE @MobCodeName VARCHAR(30);
DECLARE @Rate INT;
DECLARE @Link INT;
/* Set mob CodeName, and rate here */
SET @Rate=5
SET @MobCodeName='MOB_JUPITER_JUPITER'
SET @Link=(SELECT Link FROM _RefObjCommon WHERE CodeName128=@MobCodeName)
UPDATE _RefObjChar SET ExpToGive=ExpToGive*@Rate WHERE ID=@Link
[/SPOILER]
Query to edit Drop in uniqs or mobs
اقتباس:
/*Edited By Albert*/
GO
DECLARE @Mob VarChar(MAX),@Item VarChar(MAX),@MonsterID iNt,@ItemID iNt,@DropRatio ReaL, @DropAmountMin INT, @DropAmountMax INT
--------------------------------------------------------------------------
SET @Mob = 'MOB_TQ_WHITESNAKE'/*Monster Code*/
SET @Item = 'ITEM_MALL_GLOBAL_CHATTING'/*Item Code*/
SET @DropAmountMin = 10 /*Drop Min*/
SET @DropAmountMax = 50 /*Drop Max*/
SET @DropRatio = 0.9 /*0.5 = '50%' */
--------------------------------------------------------------------------
SET @MonsterID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Mob)/**/
SET @ItemID = (SELECT ID FROM [dbo].[_RefObjCommon] WHERE CodeName128 = @Item)/**/
INSERT [dbo].[_RefMonster_AssignedItemDrop]/**/
(RefMonsterID,RefItemID,DropGroupType,OptLevel,Dro pAmountMin,DropAmountMax,DropRatio,RefMagicOptionI D1,CustomValue1,RefMagicOptionID2,CustomValue2,Ref MagicOptionID3,CustomValue3,RefMagicOptionID4,Cust omValue4,RefMagicOptionID5,CustomValue5,RefMagicOp tionID6,CustomValue6,RefMagicOptionID7,CustomValue 7,RefMagicOptionID8,CustomValue8,RefMagicOptionID9 ,CustomValue9,RentCodeName)/**/
VALUES(@MonsterID,@ItemID,0,0,@DropAmountMin,@Drop AmountMax,@DropRatio,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0 ,0,0,0,'xxx')/**/
Alchemy3x
اقتباس:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2033'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2034'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2035'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2036'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2037'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2038'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2039'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2040'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2041'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2042'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2043'
UPDATE [dbo].[_RefObjItem] set Param2='1682979880',Param3='473720360',Param4='134 944072' where ID='2044'
- Edit MaxStack for all items of stack = 50.
[SPOILER]
كود PHP:
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjItem
SET MaxStack = 10000
WHERE MaxStack = 50
[/SPOILER]
Change Pets Page number to 5.
[SPOILER]
كود PHP:
USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (أض¼±ب£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (أض¼±ب£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (أض¼±ب£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- ہخ؛¥إن¸® »¼؛ ½ائذ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´ُ ہج»َ ہج ؤأ·³؟،´آ µ¥ہجإح¸¦ ³ضءِ ¾ت´آ´ظ!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
[/SPOILER]
Fix Dare Devil Skill / Not fully Working in some Databases *Using it even there is no problems , will no affect your DB
كود PHP:
UPDATE _RefSkill SET Basic_ChainCode=9046 WHERE ID=9035
UPDATE _RefSkill SET Basic_ChainCode=9047 WHERE ID=9036
UPDATE _RefSkill SET Basic_ChainCode=9048 WHERE ID=9037
UPDATE _RefSkill SET Basic_ChainCode=9049 WHERE ID=9038
UPDATE _RefSkill SET Basic_ChainCode=9050 WHERE ID=9039
UPDATE _RefSkill SET Basic_ChainCode=9051 WHERE ID=9040
UPDATE _RefSkill SET Basic_ChainCode=9052 WHERE ID=9041
UPDATE _RefSkill SET Basic_ChainCode=9053 WHERE ID=9042
Change selling price for [Trader sell price without trading , Thief Sell price , and Trader Npc items buy Price ].
كود PHP:
USE [SRO_VT_SHARD_INIT]
GO
UPDATE dbo._RefObjCommon
SET Price = 3830
WHERE Price = 383
UPDATE dbo._RefObjCommon
SET SellPrice = 1910
WHERE SellPrice = 191
UPDATE dbo._RefPricePolicyOfItem
SET Cost = 114900
WHERE Cost = 16024
Change Job Profit.
[SPOILER]
كود PHP:
DECLARE @NewQuot FLOAT -- @ SRO_VT_SHARD
SET @NewQuot = 3 is also possible)
-- Profit %
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 2147 AND 2158
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 10394 AND 10401
UPDATE [dbo].[_ItemQuotation]
SET BaseQuot = BaseQuot*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_LB = Quot_LB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
UPDATE [dbo].[_ItemQuotation]
SET Quot_UB = Quot_UB*@NewQuot
WHERE RefItemID BETWEEN 24671 AND 24672
[/SPOILER]
Finds Username, id, charname.
كود PHP:
Select SRO_VT_SHARD_INIT.dbo._Char.CharName16 As CharName, U.StrUserID As UserName, UserJID As JID From SRO_VT_SHARD_INIT.dbo._User
Right Join SRO_VT_SHARD_INIT.dbo._Char
On SRO_VT_SHARD_INIT.dbo._User.CharID = SRO_VT_SHARD_INIT.dbo._Char.CharID
Right Join SRO_VT_ACCOUNT.dbo.TB_User As U
On U.JID = SRO_VT_SHARD_INIT.dbo._User.UserJID
Where _Char.CharName16 = 'CharNameHere'
Resets Guild penalty when leaving.
كود PHP:
Delete From _TimedJob Where ChardID = 'CharID' and JobID = '1
' - Finds registered guilds for fw, leader, fw name, etc.
اقتباس:
Use SRO_VT_SHARD_INIT
Select Distinct SG.GuildID, GM.CharName as GuildMaster, G.Name as GuildName, SG.FortressID, REFSG.CodeName128 As FortressName From _SiegeFortressRequest as SG
Right Join _RefSiegeFortress As REFSG On SG.FortressID = REFSG.FortressID
Right Join _Guild as G On G.ID = SG.GuildID
Right Join _RefSiegeFortress on REFSG.FortressID = SG.FortressID
Right Join _GuildMember as GM On GM.GuildID = SG.GuildID
Where GM.MemberClass = 0 and SG.RequestType = 0
Order By REFSG.CodeName128 Asc
Disable alchemy materials from dropping. (all that garbage that is no longer needed)
[SPOILER]
كود PHP:
USE [SRO_VT_SHARD]
GO
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6679 AND 5414
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 6082 AND 6371
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 10501 AND 10527
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 11499 AND 11668
UPDATE dbo._RefDropItemAssign
SET Service = 0
WHERE RefItemID BETWEEN 12554 AND 12569
[/SPOILER]
Fix The Fortress War Uniques. [ Some of them was not working ].
كود PHP:
use SRO_VT_SHARD_INIT
UPDATE _RefObjCommon SET TypeID3=1, TypeID4=1, Rarity=3
WHERE (CodeName128 LIKE 'MOB_FW_KYKLOPES_%') OR
(CodeName128 LIKE 'MOB_FW_WHITETIGER_%') OR
(CodeName128 LIKE 'MOB_FW_DARKEAGLE%') OR
(CodeName128 LIKE 'MOB_FW_HAGIAZO%') OR
(CodeName128 LIKE 'MOB_FW_BIGSPIDER_%') OR
(CodeName128 LIKE 'MOB_FW_HANGA%')
Added 120 Skills. [ This Query will Set service "1" for every Character skill exist in the DB
[SPOILER]
كود PHP:
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 1 AND 273
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 276 AND 3481
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3486 AND 3491
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 3493 AND 8321
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8328 AND 8328
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 8331 AND 12176
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12178 AND 12186
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12188 AND 12196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12198 AND 12199
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12201 AND 12206
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12210 AND 12216
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12218 AND 12222
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12225 AND 12306
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 12323 AND 20309
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20311 AND 20501
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 20503 AND 21266
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 21268 AND 29693
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 29696 AND 30897
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31038 AND 31086
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31088 AND 31103
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31105 AND 31181
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31190 AND 31196
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 31198 AND 31924
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32088 AND 32874
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32891 AND 32894
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 32897 AND 32904
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33042 AND 33045
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33072 AND 33073
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33077 AND 33287
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33289 AND 33294
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33296 AND 33300
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33302 AND 33307
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33309 AND 33312
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33314 AND 33338
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33340 AND 33347
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33349 AND 33372
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33374 AND 33382
UPDATE dbo._RefSkill
SET Service = 1
WHERE ID BETWEEN 33740 AND 33785
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 7182 AND 7184
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3436 AND 3440
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 5409 AND 5409
[/SPOILER]
Activating the 12th degree on DB
[SPOILER]
كود PHP:
USE [SRO_VT_SHARD_INIT]
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_EU%'
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%ITEM_CH%'
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 8994 AND 9005
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9008 AND 9025
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9028 AND 9045
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9048 AND 9065
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9068 AND 9085
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9088 AND 9105
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9114 AND 9125
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9134 AND 9145
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID BETWEEN 9154 AND 9225
UPDATE dbo._RefObjCommon
SET Service = 0
WHERE ID = 38620
[/SPOILER]
Fix Qin-Shin Tomb uniques timing .
كود PHP:
USE SRO_VT_SHARD_INIT
--B1
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32100 --B1 Unique
--B2
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32200 --Camp 8 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32300 --Camp 11 Unique
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32400 --Camp 11 Unique
--B3
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32500
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32600
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32700
UPDATE Tab_RefNest SET dwMaxTotalCount=1 WHERE dwTacticsID=32800
lol
change character's mastery's at a certain level
كود PHP:
USE [SRO_VT_SHARD]
GO
--by Evo , Input their name here, and set their skill level you desire.
Declare @CharName Varchar (64)
Set @CharName = '[GM]Albert'
UPDATE [dbo].[_CharSkillMastery]
SET Level= 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Change Character User Name
كود PHP:
USE [SRO_VT_ACCOUNT]
declare @AtualID varchar (30)
declare @NewID varchar (30)
set @AtualID = 'youridhere'
set @NewID = 'newidhere'
update tb_user set struserid = @NewID
where struserid = @ActualID
Moving Uniques from its spawns (E.G : DemonShitan )lol
WHERE dwTacticsID = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID =
(SELECT ID FROM _RefObjCommon WHERE Codename128 like 'MOB_RM_TAHOMET'))
ADD a GM account ( ip & [GM stats] & Some Gold
كود PHP:
use SRO_VT_ACCOUT
Go
INSERT INTO _PrivilegedIP (IP1, IP2, IP3, IP4, IP5, IP6 ,IP7 ,IP8)
VALUES (41, 232, 175, 220, 41, 232, 175, 240)
GO
update TB_User set GMrank = 1
where StrUserID = heroine
GO
update TB_User set sec_primary = 1
where StrUserID = heroine
Go
update TB_User set sec_content = 1
where StrUserID = heroine
Go
USE SRO_VT_SHARD
GO
update _Char set CharName16 = [GM] Albert
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999
where CharName16 like '%[GM] Albert%';
Honor ranks Fix
[SPOILER]
كود PHP:
USE SRO_VT_SHARD
TRUNCATE TABLE _TrainingCampHonorRank
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (1)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (2)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (3)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (4)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (5)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (6)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (7)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (8)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (9)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (10)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (11)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (12)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (13)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (14)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (15)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (16)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (17)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (18)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (19)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (20)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (21)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (22)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (23)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (24)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (25)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (26)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (27)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (28)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (29)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (30)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (31)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (32)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (33)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (34)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (35)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (36)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (37)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (38)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (39)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (40)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (41)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (42)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (43)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (44)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (45)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (46)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (47)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (48)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (49)
INSERT INTO _TrainingCampHonorRank(Ranking) VALUES (50)
exec _TRAINING_CAMP_UPDATEHONORRANK
2- مشكلة اللي في بعض الناس بتدور عليها و هي كيفية فتح الـ Certification Server
[SPOILER] بص يا برو هاتفتح فيلات السيرفر بعد كدع فولدر ال Certification Server بعد كده فولدر الـ ini بعد كده فيل اسمو srGlobalService.ini و ده يا برو اللي هاتعدل عليه زي ما هاتشوف ف المثال اللي هاوريهولك
دي اول حاجة هاتعدل عليها و كده تمام نخش علي تاني حاجة و هي
srNodeType.ini
هاتشيل منها الاي بيه اللي موجود و تحوط الي بيه بتاعك
و اخيرا اخر حاجة هاتعدل عليها srShard.ini
زي ما هاتشوف ف المثال بردو
query=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=sa;PWD=123456;DATABASE=SRO_VT_SHARD_INIT
بص يا سيدي كده عدلنا علي فولدر ini
فاضل اللي بره الفولدر بئا ^^
افتح فيل التشغيل ايل ده و الفيل ده وظيفتو ان بيحفظ الشغل اللي حضرتك عملتو جوا الفولدر
compile.bat
و بعدين دوس علي
CustomCertificationServer.bat
[/SPOILER]
3- بص يا سيدي مشكلة الـDC
اعمل زي ما هاوريك ف الصور
بعد ما تفتح الفولدرات دي هاتلاقي فيل اسمو DBConnect
و ده شكلة و اللي هاتحوط فيه بينات الـSQL بتاعك
4- مشكلة بتقابل ناس كتير و مش عارفية سببها لما بتيجي تفتح فيلات السيرفر بتقفل تاني لوحدها هاوريك حالا ازاي تحل المشكلة دي بالصور
ثالثا : مجموعة مختلفة من الـDB's
اولا : DB الـ 60 CAP
[SPOILER]
كود PHP:
DB ECSro
Files - https://mega.co.nz/#!UBJHGLRD!Q9ayI3...IGtmViyQJt2urg
Data - https://mega.co.nz/#!9d5XnYya!YpbkSS...PEYYnaM7Ge3PUo
Client - bloodlust_Full_Client - Download - 4shared - williams blanco
Query for Clean DB - https://mega.co.nz/#!dJZABI4Z!GZxppQ...cyH6JJDjZUYEvE
Auto Potion - https://mega.co.nz/#!sdhWWTpL!PTLLpV...kuoebyfI1IwEEA
[/SPOILER]
ثانيا : DB الـCap80
[SPOILER]
كود PHP:
Devias Online Database (and Server Files) (80 cap)
backups_csrotestinDBSbyDrAbdelfattah.rar
و متنساش ده تغير الـClient Version لـ 1 و الـcontact id لـ 9
}
[/SPOILER]
رابعا : DB Cap100
[SPOILER]
كود PHP:
DB Vehalla
link download client :http://www.multiupload.nl/71L7P7J8R7
server files: http://www.mediafire.com/download/yr...av2yu3/veh.rar
scripts: http://www.mediafire.com/?5c9mpfuvqoowdmd
fix scripts: http://www.mediafire.com/download/nb...alla_fixed.rar
Vehalla Databases 06.06.rar
[/SPOILER]
خامسا : DB cap 110
[SPOILER]
كود PHP:
DB R-FriendsPVP
link download DB
http://ge.tt/8MzzU9s/v/0
link download client
http://files.fm/u/ykodpuz
link download server files
http://files.fm/u/uonkxqr
[/SPOILER]
ملحوظة ::
اقتباس:
بعد ما تسطب كل حاجة لازم تفك الكلينك كامل ف فيلات السيرفر و الا الـSR_GAMESERVER
هاياخد كرااااش
رابعا : الـVsro Files
[SPOILER]
كود PHP:
========server files====================
Part1 :
Multi: Multiupload.com - upload your files to multiple file hosting sites!
Deposit: Deposit Files
Part2 :
Multi: Multiupload.com - upload your files to multiple file hosting sites!
Deposit: Deposit Files
Part3 :
Multi: Multiupload.com - upload your files to multiple file hosting sites!
Deposit: Deposit Files
========Database dumps================
Link : Blitzkrieq_Package_11.09.2011_1.rar
========Changeset obt 247 - 249==========
Link : Multiupload.com - upload your files to multiple file hosting sites!
========Xtrap update files===============
Link : Multiupload.com - upload your files to multiple file hosting sites!
=======Billing asp scripts=================
Link : Multiupload.com - upload your files to multiple file hosting sites!
=======Drew's custom cert===============
Link : Multiupload.com - upload your files to multiple file hosting sites! (you have to modify settings, try doing it on your own)
=======Latest SMC (update removed)=======
Multiupload.com - upload your files to multiple file hosting sites!
[/SPOILER]
خامسا : مجموعة من الـPHP
[SPOILER]
اولا : php الـGuild Ranking
[SPOILER]
اقتباس:
function rank_guild() {
$conn=odbc_connect('SRO_VT_SHARD','sa','123465');
if (!$conn)
{exit("Connection Failed: " . $conn);}
$i = '1';
$sql = odbc_exec($conn,"SELECT TOP 10 Name,Lvl,GatheredSP FROM _Guild ORDER BY GatheredSP DESC");
echo '<table>
if (!$_POST['username2'] )
{
echo "<script>alert('player name is empty');location.href='pass.php';</script>";
die();
}
else
if (!$_POST['password2'] )
{
echo "<script>alert('E-Mail is empty');location.href='pass.php';</script>";
die();
}
else
if (!$_POST['newpass'] )
{
echo "<script>alert('New Password is empty');location.href='pass.php';</script>";
die();
}
$query = odbc_exec($connect, "SELECT StrUserID FROM TB_User WHERE StrUserID='$username' AND StrUserID='$password'");
$checkusername = odbc_num_rows($query);
if(($checkusername != 0) and $checkpassword != 0)
{
odbc_exec($connect,"UPDATE TB_User SET password='$newpass' WHERE StrUserID='$username''")or die("Can't connect the MSSQL server.");
echo "<script>alert('Login Pass has been changed! \\nNew Password: $newpass2');location.href='pass.php';</script>";
} else
echo "<script>alert('Wrong Player Name/Email entered!');location.href='pass.php';</script>";
die();
}
?>
[/SPOILER]
رابعا : PHP الـReset status points
[SPOILER]
كود PHP:
<?php
//check that the user is logged
if(!isset($_SESSION)){
session_start();
}
if (isset($_SESSION['name'])) {
$userID = $_SESSION['name'];
}
else {
echo "<script>location.href='index.php'</script>";
die;
}
//makesure that the the variable char is present
if(!isset($_GET["char"])){
echo "<script>location.href='controlpanel.php'</script>";
die;
}
/*************************************
*convert a date in the format AAAA-MM-DD
*into numbers of days passed from 2000-01-01
*************************************/
function date2int($end) {
$titulo="Reset your status points";
require_once("./modules/include/Config.php");
require_once("./modules/include/sqlConn.php");
require_once("./modules/include/Security.php");
mssql_select_db($dbName1, $dbConn) or die ("Couln't select database $dbName1");
//select the JID from this account
$getUserJID = mssql_query("select * from TB_User where StrUserID = '".$_SESSION["name"]."'");
while ($row = mssql_fetch_array($getUserJID)) {
$userJID = $row['JID'];
//$userGM = $row['sec_content'];
}
mssql_select_db($dbName2, $dbConn) or die ("Couln't select database $dbName2");
//check that the char belong to te logged account
$getCharID = mssql_query("select * from _User where UserJID = '$userJID'");
$charnumeros=0;
while ($row = mssql_fetch_array($getCharID)) {
$charID2 = $row['CharID'];
if($charID2==$_GET['char']){
$charnumeros++;
}
}
//select char informations needed to reset
$getCharInfos = mssql_query("select * from _Char where CharID = ".$_GET['char']);
while ($row2 = mssql_fetch_array($getCharInfos)) {
$charName = $row2['CharName16'];
$charLevel = $row2['CurLevel'];
}
$erro="";
$reset = ($charLevel-1)+20;
$remainStats = ($charLevel-1)*3;
if($_GET["r"]=="true"){
//hoje it's the date from the present day
$hoje=date2int(date("Y-m-d"));
//does this char already made a reset sometime?
$jaDeu=mssql_num_rows(mssql_query("select * from _Char_Reset where char_id='".$_GET['char']."'"));
if($jaDeu>0){
//this is not the first time so let's know when it was
$quandoDeu=mssql_query("select * from _Char_Reset where char_id='".$_GET['char']."'");
while ($row = mssql_fetch_array($quandoDeu)) {
$charLastReset = $row['last_reset'];
}
//how much days ago? (today - last reset)
$passaram=$hoje-$charLastReset;
//if already 7 days passed update else you must wait
if($passaram>6){
mssql_query("update _Char_Reset set last_reset='$hoje' where char_id='".$_GET['char']."'");
}else{
$erro="You must wait ".(7-$passaram)." days to reset $charName again";
}
}else{
//insert that today this char made a reset
mssql_query("insert into _Char_Reset (char_id,last_reset) values ('".$_GET['char']."','$hoje')");
}
if($erro==""){
//here we make the reset itself if no errors occur
$conteudo="<br><br><br><p align='center'><font color='#2ed900'>$charName's Status Points were reseted.</font></p>";
mssql_query("update _Char set Strength=$reset, Intellect=$reset, RemainStatPoint=$remainStats where CharID = ".$_GET['char']);
}else{
$conteudo="<br><br><br><br><br><p align='center'><font color='red'>$erro</font></p>";
}
}else{
//here we have a confirmation if the player is sure he want to make the reset
$conteudo="<br><br><br><p align='center'>Are you sure you want to reset $charName's Status Points?</p><p align='center'>Remember that you can only reset it again after 7 days</font>";
$conteudo=$conteudo."<br><br><p align='center'><a href=\"reset.php?char=".$_GET["char"]."&r=true\"><img src=\"styles/img/cp/reset.png\" alt=\"\" border=\"0\"></a></p>";
}
include("theme.php");
[/SPOILER]
[/SPOILER]
سادسا : مجموعة مختلفة من المواقع:
All website Mega : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
All website MediaFire : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
Image : This image has been resized. Click this bar to view the full image. The original image is sized 819x975.
Analyse Virus .rar : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
if (!$_POST['username2'] )
{
echo "<script>alert('player name is empty');location.href='pass.php';</script>";
die();
}
else
if (!$_POST['password2'] )
{
echo "<script>alert('E-Mail is empty');location.href='pass.php';</script>";
die();
}
else
if (!$_POST['newpass'] )
{
echo "<script>alert('New Password is empty');location.href='pass.php';</script>";
die();
}
$query = odbc_exec($connect, "SELECT StrUserID FROM TB_User WHERE StrUserID='$username' AND StrUserID='$password'");
$checkusername = odbc_num_rows($query);
if(($checkusername != 0) and $checkpassword != 0)
{
odbc_exec($connect,"UPDATE TB_User SET password='$newpass' WHERE StrUserID='$username''")or die("Can't connect the MSSQL server.");
echo "<script>alert('Login Pass has been changed! \\nNew Password: $newpass2');location.href='pass.php';</script>";
} else
echo "<script>alert('Wrong Player Name/Email entered!');location.href='pass.php';</script>";
die();
}
?>
[/SPOILER]
* PHP الـReset status points
[SPOILER]
كود PHP:
<?php
//check that the user is logged
if(!isset($_SESSION)){
session_start();
}
if (isset($_SESSION['name'])) {
$userID = $_SESSION['name'];
}
else {
echo "<script>location.href='index.php'</script>";
die;
}
//makesure that the the variable char is present
if(!isset($_GET["char"])){
echo "<script>location.href='controlpanel.php'</script>";
die;
}
/*************************************
*convert a date in the format AAAA-MM-DD
*into numbers of days passed from 2000-01-01
*************************************/
function date2int($end) {
$titulo="Reset your status points";
require_once("./modules/include/Config.php");
require_once("./modules/include/sqlConn.php");
require_once("./modules/include/Security.php");
mssql_select_db($dbName1, $dbConn) or die ("Couln't select database $dbName1");
//select the JID from this account
$getUserJID = mssql_query("select * from TB_User where StrUserID = '".$_SESSION["name"]."'");
while ($row = mssql_fetch_array($getUserJID)) {
$userJID = $row['JID'];
//$userGM = $row['sec_content'];
}
mssql_select_db($dbName2, $dbConn) or die ("Couln't select database $dbName2");
//check that the char belong to te logged account
$getCharID = mssql_query("select * from _User where UserJID = '$userJID'");
$charnumeros=0;
while ($row = mssql_fetch_array($getCharID)) {
$charID2 = $row['CharID'];
if($charID2==$_GET['char']){
$charnumeros++;
}
}
//select char informations needed to reset
$getCharInfos = mssql_query("select * from _Char where CharID = ".$_GET['char']);
while ($row2 = mssql_fetch_array($getCharInfos)) {
$charName = $row2['CharName16'];
$charLevel = $row2['CurLevel'];
}
$erro="";
$reset = ($charLevel-1)+20;
$remainStats = ($charLevel-1)*3;
if($_GET["r"]=="true"){
//hoje it's the date from the present day
$hoje=date2int(date("Y-m-d"));
//does this char already made a reset sometime?
$jaDeu=mssql_num_rows(mssql_query("select * from _Char_Reset where char_id='".$_GET['char']."'"));
if($jaDeu>0){
//this is not the first time so let's know when it was
$quandoDeu=mssql_query("select * from _Char_Reset where char_id='".$_GET['char']."'");
while ($row = mssql_fetch_array($quandoDeu)) {
$charLastReset = $row['last_reset'];
}
//how much days ago? (today - last reset)
$passaram=$hoje-$charLastReset;
//if already 7 days passed update else you must wait
if($passaram>6){
mssql_query("update _Char_Reset set last_reset='$hoje' where char_id='".$_GET['char']."'");
}else{
$erro="You must wait ".(7-$passaram)." days to reset $charName again";
}
}else{
//insert that today this char made a reset
mssql_query("insert into _Char_Reset (char_id,last_reset) values ('".$_GET['char']."','$hoje')");
}
if($erro==""){
//here we make the reset itself if no errors occur
$conteudo="<br><br><br><p align='center'><font color='#2ed900'>$charName's Status Points were reseted.</font></p>";
mssql_query("update _Char set Strength=$reset, Intellect=$reset, RemainStatPoint=$remainStats where CharID = ".$_GET['char']);
}else{
$conteudo="<br><br><br><br><br><p align='center'><font color='red'>$erro</font></p>";
}
}else{
//here we have a confirmation if the player is sure he want to make the reset
$conteudo="<br><br><br><p align='center'>Are you sure you want to reset $charName's Status Points?</p><p align='center'>Remember that you can only reset it again after 7 days</font>";
$conteudo=$conteudo."<br><br><p align='center'><a href=\"reset.php?char=".$_GET["char"]."&r=true\"><img src=\"styles/img/cp/reset.png\" alt=\"\" border=\"0\"></a></p>";
}
include("theme.php");
[/SPOILER]
</div>
التعديل الأخير تم بواسطة ™Dev Microsoft™ ; 29-08-2014 الساعة 04:17 AM
شـريـط الاهـداءات
19-11-2013, 04:13 AM
This image has been resized. Click this bar to view the full image. The original image is sized 819x975.
.gif){kind=icon}
.gif){kind=icon}
العرض العادي
