كل شئ له علاقة بالـVsro هنا و بس ,,, By #Albert

[™Dev Microsoft™]

http://im26.gulfup.com/2012-07-04/1341434007131.png
http://img688.imageshack.us/img688/3638/welcomea.png
http://www14.0zz0.com/2013/11/16/11/632565550.gif



اولا : Sql DB Quires Collection

-Cleaning The Databases .




I. TABLE SQL
SRO_VT_ACCOUNT






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, [int] NOT NULL, [capacity] [smallint] NOT NULL ) ON [PRIMARY] GO



Query to Remove PK by CharName

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

USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0Query to ban player by Char name

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 --
---------------------------------
---------------------------

INSERT [dbo].[_Punishment]
(
[UserJID],
[Type],
[Executor],
[Shard],
[CharName],
[CharInfo],
[PosInfo] ,
[Guide],
[Description],
[RaiseTime],
,
,
[PunishTime],
[Status]
)
VALUES
(
@AccJID,
1,
1,
0,
@CharName,
1,
1,
@Reason,
@Reason,
@Begin,
@Begin,
@End,
@End,
0);
----------------------------------------------------------
DECLARE @ReasonID INT
SET @ReasonID =
(Select SerialNo FROM _Punishment Where UserJID = @AccJID)
----------------------------------------------------------
INSERT [dbo].[_BlockedUser]
(
[UserJID],
[UserID],
[Type],
[SerialNo],
[TimeBegin],
[TimeEnd])
VALUES
(
@AccJID,
@ID,
1,
@ReasonID,
@Begin,
@End);

-----------------------------------------------------------------
SELECT StrUserID FROM TB_User WHERE JID = @AccJID
-----------------------------------------------------------------Query to Unban Player by Cahr Name

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

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



/ تقدر تعمل
Restat characters, and set thier lvl

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


/ تقدر تختار الـMOB او الـUNIQ
و تزود الـEXP بتاعو

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


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.




USE [SRO_VT_SHARD_INIT]
GO

UPDATE dbo._RefObjItem
SET MaxStack = 10000
WHERE MaxStack = 50


Change Pets Page number to 5.



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

ALTER PROCEDURE [dbo].[_AddNewCOS]
@OwnerCharID int,
@RefObjID int,
@Level int,
@HP int,
@MP int,
@HGP int,
@KeeperNPC int,
@State int,
@InventorySize int,
@itemID int,
@PickItemConfig tinyint,
@RentEndTime smalldatetime
as

begin tran

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



Fix Dare Devil Skill / Not fully Working in some Databases
*Using it even there is no problems , will no affect your DBhttp://cdn.elitepvpers.org/forum/images/smilies/smile.gif


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 ].



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.



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



Finds Username, id, charname.


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.

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)


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


[B] Fix The Fortress War Uniques. [ Some of them was not working ].


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


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




Activating the 12th degree on DB




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



Fix Qin-Shin Tomb uniques timing .

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


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

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



USE [SRO_VT_SHARD]created by : Albert

Update Tab_RefNest Set
dwDelayTimeMin=600 ,
dwDelayTimeMax=1601 ,
--Posiçمo--
nRegionDBID=26737 ,
fLocalPosX=705 ,
fLocalPosY=272.922821 ,
fLocalPosZ=1466


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



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



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




Teleport All users to Jangan

USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25000, posX= 1073 , posY= 5 ,posZ= 1068 ,AppointedTeleport=19554,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
-

Clean grap pets inventory

use SHARD_1
exec _ClearInvalidCOS


cleaning db from trashes & invalid data


use SHARD_1
exec _RemoveAllInvalidData

http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif


ثانيا : بعض المشاكل و حلولها :



1- SR_ShardManager.exe
billing dead and closed
الحــــــــــــــــل : server.cfg



SR_ShardManager {
Certification "123.30.200.70", 15882
BILLING_SERVER_URL "http://123.30.200.70:8080/"
CREST_FTP_URL "ftp://sro_logo:[email protected]





http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png

2- مشكلة اللي في بعض الناس بتدور عليها
و هي كيفية فتح الـ
Certification Server


بص يا برو هاتفتح فيلات السيرفر بعد كدع فولدر ال Certification Server بعد كده فولدر الـ ini بعد كده فيل اسمو
srGlobalService.ini و ده يا برو اللي هاتعدل عليه زي ما هاتشوف ف المثال اللي هاوريهولك

DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_ACCOUNT;UID=sa;P WD=123456;DATABASE=SRO_VT_ACCOUNT



دي اول حاجة هاتعدل عليها و كده تمام نخش علي تاني حاجة و هي
srNodeType.ini
هاتشيل منها الاي بيه اللي موجود و تحوط الي بيه بتاعك
و اخيرا اخر حاجة هاتعدل عليها srShard.ini
زي ما هاتشوف ف المثال بردو
query=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=SRO_VT_SHARD_INIT;UID=s a;PWD=123456;DATABASE=SRO_VT_SHARD_INIT

query_log=DRIVER={SQL Server};SERVER=Your MachineName\SQLEXPRESS;DSN=Log_DB;UID=sa;PWD=12345 6;DATABASE=Log_DB

بص يا سيدي كده عدلنا علي فولدر ini
فاضل اللي بره الفولدر بئا ^^
افتح فيل التشغيل ايل ده و الفيل ده وظيفتو ان بيحفظ الشغل اللي حضرتك عملتو جوا الفولدر
compile.bat
و بعدين دوس علي
CustomCertificationServer.bat


http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
3- بص يا سيدي مشكلة الـDC
اعمل زي ما هاوريك ف الصور
http://s4.postimg.org/19lej35us/image.png
http://s4.postimg.org/19lg6mick/image.png
بعد ما تفتح الفولدرات دي هاتلاقي فيل اسمو DBConnect
و ده شكلة و اللي هاتحوط فيه بينات الـSQL بتاعك
http://img856.imageshack.us/img856/986/10402098.png
http://img716.imageshack.us/img716/5487/xyv154lsxnvt.png
4- مشكلة بتقابل ناس كتير و مش عارفية سببها لما بتيجي تفتح فيلات السيرفر بتقفل تاني لوحدها هاوريك حالا ازاي تحل المشكلة دي بالصور
http://i.imgur.com/4i8Mq.jpg
http://i.imgur.com/FisMR.jpg
http://i.imgur.com/OxChP.jpg
http://i.imgur.com/vbWwu.jpg





http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif

ثالثا : مجموعة مختلفة من الـDB's



اولا : DB الـ 60 CAP



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


http://www5.0zz0.com/2013/10/31/02/766996312.png

ثانيا : DB الـCap80


Devias Online Database (and Server Files) (80 cap)


DEVIAS_Server_Files-Insane.part1.rar: https://mega.co.nz/#!dhxlERiI!PoW2TE...E0-7IURLO-wImI (950.0 MB)
DEVIAS_Server_Files-Insane.part2.rar: https://mega.co.nz/#!Ig5AxSLB!diN3-T...mnIWCJJ9_zD75o (950.0 MB)
DEVIAS_Server_Files-Insane.part3.rar: https://mega.co.nz/#!wggF3KBI!A36SdG...6x5n8-3REctGpI (834.5 MB)

Devias Online Databases:

Devias Account: https://mega.co.nz/#!1thyRZBR!RIAGam...0SPxJHuY30PKDA (18.2 MB)
Devias Shard: https://mega.co.nz/#!pg5jyLwa!UZpfzz...zGEVt44DmBDuUI (1.04 GB)
Devias: Log: https://mega.co.nz/#!k9ZxUIAJ!MLbVvC...xvgBC3WbvFkgx8 (500.3 MB)

Devias Online v7: https://mega.co.nz/#!Us5xDBJR!LmRQYW...ydcGrHb8mfuFfI (1.47 GB)





http://www5.0zz0.com/2013/10/31/02/766996312.png
ثالثا : DB Cap90


DB Jsro + Files Server + Original Files + Cleint
With Fix 100%


* link's download

1 / link download original files server

http://uploading.com/files/16c22564/sl.rar/

////////////////////////////

2 / link download CertificationManager

http://www.mediafire.com/download/1f...SRO%282%29.rar

//////////////////////////

3 / link download DB

http://www.mediafire.com/download/m3..._DB%282%29.rar

///////////////////////////

4 / link download full client

https://drive.google.com/uc?id=0B7xF...xport=download


Old CSRO (ECSRO) TestIn Files


CertificationManager.rar

CSROTestIn.rar

backups_csrotestinDBSbyDrAbdelfattah.rar
و متنساش ده تغير الـClient Version لـ 1 و الـcontact id لـ 9
}


http://www5.0zz0.com/2013/10/31/02/766996312.png

رابعا : DB Cap100


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


http://www5.0zz0.com/2013/10/31/02/766996312.png

خامسا : DB cap 110


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

ملحوظة ::
بعد ما تسطب كل حاجة لازم تفك الكلينك كامل ف فيلات السيرفر و الا الـSR_GAMESERVER
هاياخد كرااااش http://www5.0zz0.com/2013/10/31/02/766996312.png
http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif


رابعا : الـVsro Files





========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!


http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif



خامسا : مجموعة من الـPHP




اولا : php الـGuild Ranking


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>

<tr>
<th>#</th>
<th>Guild Name</th>
<th>Level</th>
<th>XP</th>
</tr>';
while($r = odbc_fetch_array($sql)) {
echo '<tr><td>'.$i++.'</td><td>'.$r[Name].'</td><td>'.$r[Lvl].'</td><td>'.$r[GatheredSP].'</td></tr>';
}
echo '</table>';
}
rank_guild(); //will render ranking !


http://www5.0zz0.com/2013/10/31/02/766996312.png

ثانيا : php الـplayer Ranking


function rank_players() {
$conn=odbc_connect('SRO_VT_SHARD','sa','123465');
if (!$conn)
{exit("Connection Failed: " . $conn);}


$i = '1';
$sql = odbc_exec($conn,"SELECT TOP 10 CharName16,MaxLevel,RemainGold FROM _Char WHERE Deleted ='0' ORDER BY MaxLevel DESC");
echo '<table>

<tr>
<th>#</th>
<th>Character Name</th>
<th>Level</th>
<th>Gold</th>
</tr>';
while($r = odbc_fetch_array($sql)) {
echo '<tr><td>'.$i++.'</td><td>'.$r[CharName16].'</td><td>'.$r[MaxLevel].'</td><td>'.$r[RemainGold].'</td></tr>';
}
echo '</table>';
}
rank_players() ; //will render player ranking.


http://www5.0zz0.com/2013/10/31/02/766996312.png

تالثا : php الـChange PASS



<?php
StrUserID='$username' AND password='$password'");if (isset($_GET['act']) AND $_GET['act'] == "changepass")
{

function anti_injection($sql) {
$sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|'|\"|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
$sql = trim($sql);
$sql = strip_tags($sql);
$sql = addslashes($sql);
return $sql;
}

$regdate = date("Y-m-d H:i:s");
$newpass=md5($_POST['newpass']);
$newpass2=anti_injection($_POST['newpass']);
$password=anti_injection($_POST['password2']);
$username=anti_injection($_POST['username2']);

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();
}
?>



http://www5.0zz0.com/2013/10/31/02/766996312.png

رابعا : PHP الـReset status points



<?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) {

$start="2000-01-01";
$start_ts = strtotime($start);
$end_ts = strtotime($end);
$diff = $end_ts - $start_ts;

return round($diff / 86400);
}

$titulo="Reset your status points";
require_once("./modules/include/Config.php");
require_once("./modules/include/sqlConn.php");
require_once("./modules/include/Security.php");

$check = new security();
$message = null;
if($check->is_secure($_GET['char']) == false) $message[] = "";


if(count($message) > 0) {
// char isnt safe
echo "<script>location.href='index.php'</script>";
die;
}

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++;
}
}

if($charnumeros==0){
echo "<script>location.href='index.php'</script>";
die;
}

//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");







http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif


سادسا : مجموعة مختلفة من المواقع:


All website Mega : https://mega.co.nz/#!cxcnjBrK!DmeWdD...9teMBpvRz11DYs (https://mega.co.nz/#%21cxcnjBrK%21DmeWdDsU7EFyJiLGN4iBLi7ZCZk7Y9teMBp vRz11DYs)
All website MediaFire : http://www.mediafire.com/download.php?2icje9c0e8ixllt

Image : http://www.elitepvpers.com/forum/images/statusicon/wol_error.gifThis image has been resized. Click this bar to view the full image. The original image is sized 819x975.http://th08.deviantart.net/fs70/PRE/f/2010/035/7/d/Fly_for_Celestia_by_AzizNatour.jpg


Analyse Virus .rar : https://www.virustotal.com/de/file/3...is/1367160168/ (https://www.virustotal.com/de/file/33b6638d04b2c3abbd2c15020448201f2821461bca4f0fe130 d3352badd72c6e/analysis/1367160168/)


Database (.sql) clean no include http://cdn.elitepvpers.org/forum/images/smilies/frown.gif

Link : https://mega.co.nz/#!z4B0CQwb!EBahbh...NTHeB7RxZ_CuKs (https://mega.co.nz/#%21z4B0CQwb%21EBahbhz8r6VZhjtExQBLnRB6_XIflNTHeB7 RxZ_CuKs)


-----------------------------------------------------------------------------------------

Image : http://www.elitepvpers.com/forum/images/statusicon/wol_error.gifThis image has been resized. Click this bar to view the full image. The original image is sized 1202x939.http://imageshack.us/a/img213/5785/fireflyff.png


Analyse Virus .rar : https://www.virustotal.com/de/file/8...is/1367160542/ (https://www.virustotal.com/de/file/86991da677bf9782a35c5c0ed0e0c2398ded0cd3f9e252cb39 50040de89f0526/analysis/1367160542/)


Database (.sql) clean no include http://cdn.elitepvpers.org/forum/images/smilies/frown.gif

Link : https://mega.co.nz/#!HsIFVRxB!GDV9Kx...I9z1vg6qZAradc (https://mega.co.nz/#%21HsIFVRxB%21GDV9KxXW5zL1yGp33uJcoVQTJl4xbI9z1vg 6qZAradc)


-----------------------------------------------------------------------------------------

Image : http://www.elitepvpers.com/forum/images/statusicon/wol_error.gifThis image has been resized. Click this bar to view the full image. The original image is sized 1758x936.http://imageshack.us/a/img607/5715/trinitya.png


Analyse Virus .rar : https://www.virustotal.com/de/file/a...is/1367160328/ (https://www.virustotal.com/de/file/a93ef700a5268dfdc430d4e43045e68f9ab78b8a41965e89b2 ebb855b8752c9f/analysis/1367160328/)


Database (.sql) clean no include http://cdn.elitepvpers.org/forum/images/smilies/frown.gif

Link : https://mega.co.nz/#!T5QAyZQC!Oe6j4S...Fk-Oc1zjaDwr4M (https://mega.co.nz/#%21T5QAyZQC%21Oe6j4SBesKwW1WUMxAFJmRHvFMY6TFk-Oc1zjaDwr4M)


http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif

سابعا : شرح وافي للـIIS


http://silkroad4arab.com/vb/showthread.php?t=453813
http://www14.0zz0.com/2013/11/16/11/632565550.gif
http://www2.0zz0.com/2013/11/16/11/818702782.gif

ثامنا : شراح وافي لكيفية عمل سيرفر خاص بالفيديو
By:[I][B]ELjOker


part1
http://www.mediafire.com/download/oh3o783mo2r6k2v/1%29+How+To+Make+Private+Server+By+ELjOker+To+Silk road4arab.CoM.rar

part 2
http://www.mediafire.com/download/qy20sjuhcc2y9xo/2%29+How+To+Make+Private+Server+By+ELjOker+To+Silk road4arab.CoM.rar

part 3
http://www.mediafire.com/download/t5vtbdp2ffd21zq/3%29+How+To+Make+Private+Server+By+ELjOker+To+Silk road4arab.CoM.rar

part 4
http://www.mediafire.com/download/4pvhlnln9994onh/4%29+How+To+Make+Private+Server+By+ELjOker+To+Silk road4arab.CoM.rar

part 5
http://www.mediafire.com/download/ebyihc6s2d9vsjv/5%29+How+To+Make+Private+Server+By+ELjOker+To+Silk road4arab.CoM.rar

part 6
http://www.mediafire.com/download/y963vgavo7wu2ot/6%29+How+To+Make+Private+Server+By+ELjOker+To+Silk road4arab.CoM.rar


http://www14.0zz0.com/2013/11/16/11/632565550.gif

http://www5.0zz0.com/2013/10/31/02/766996312.png
تاسعا : PHP SCRIPTS



* php الـGuild Ranking


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>

<tr>
<th>#</th>
<th>Guild Name</th>
<th>Level</th>
<th>XP</th>
</tr>';
while($r = odbc_fetch_array($sql)) {
echo '<tr><td>'.$i++.'</td><td>'.$r[Name].'</td><td>'.$r[Lvl].'</td><td>'.$r[GatheredSP].'</td></tr>';
}
echo '</table>';
}
rank_guild(); //will render ranking !

http://www5.0zz0.com/2013/10/31/02/766996312.png

* php الـplayer Ranking

function rank_players() {
$conn=odbc_connect('SRO_VT_SHARD','sa','123465');
if (!$conn)
{exit("Connection Failed: " . $conn);}


$i = '1';
$sql = odbc_exec($conn,"SELECT TOP 10 CharName16,MaxLevel,RemainGold FROM _Char WHERE Deleted ='0' ORDER BY MaxLevel DESC");
echo '<table>

<tr>
<th>#</th>
<th>Character Name</th>
<th>Level</th>
<th>Gold</th>
</tr>';
while($r = odbc_fetch_array($sql)) {
echo '<tr><td>'.$i++.'</td><td>'.$r[CharName16].'</td><td>'.$r[MaxLevel].'</td><td>'.$r[RemainGold].'</td></tr>';
}
echo '</table>';
}
rank_players() ; //will render player ranking.


http://www5.0zz0.com/2013/10/31/02/766996312.png

* php الـChange PASS



<?php
StrUserID='$username' AND password='$password'");if (isset($_GET['act']) AND $_GET['act'] == "changepass")
{

function anti_injection($sql) {
$sql = preg_replace(sql_regcase("/(from|select|insert|delete|where|'|\"|drop table|show tables|#|\*|--|\\\\)/"),"",$sql);
$sql = trim($sql);
$sql = strip_tags($sql);
$sql = addslashes($sql);
return $sql;
}

$regdate = date("Y-m-d H:i:s");
$newpass=md5($_POST['newpass']);
$newpass2=anti_injection($_POST['newpass']);
$password=anti_injection($_POST['password2']);
$username=anti_injection($_POST['username2']);

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();
}
?>


http://www5.0zz0.com/2013/10/31/02/766996312.png

* PHP الـReset status points


<?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) {

$start="2000-01-01";
$start_ts = strtotime($start);
$end_ts = strtotime($end);
$diff = $end_ts - $start_ts;

return round($diff / 86400);
}

$titulo="Reset your status points";
require_once("./modules/include/Config.php");
require_once("./modules/include/sqlConn.php");
require_once("./modules/include/Security.php");

$check = new security();
$message = null;
if($check->is_secure($_GET['char']) == false) $message[] = "";


if(count($message) > 0) {
// char isnt safe
echo "<script>location.href='index.php'</script>";
die;
}

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++;
}
}

if($charnumeros==0){
echo "<script>location.href='index.php'</script>";
die;
}

//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");



http://www5.0zz0.com/2013/10/31/02/766996312.png




http://www14.0zz0.com/2013/11/16/11/632565550.gif



:littleangel:
http://www6.0zz0.com/2013/10/31/01/698124232.png




</div>

[che_9299]

الله بنور
عليك
استمر

[aaaaa200123]

تسلمـ

[™Dev Microsoft™]

تسلمـ
ده واجبي
الله بنور
عليك
استمر
شكرا ليك

[افندينا ™Hamboka™]

تمام ياض استمر

[CritYouDown]

الله ينور شغل 100 100 :thumbsup:

[™Dev Microsoft™]

الله ينور شغل 100 100 :thumbsup:
تسلم ^^
تمام ياض استمر

ايوا بئا ^_^

[Ch3tos]

شغل عالي الصراحهـ

[ExTincTion]

الف شكر

على مجهودك

[™Dev Microsoft™]

الف شكر

على مجهودك
علي ايه ده واجبي :)
شغل عالي الصراحهـ

تسلم يا برو ^^

[elfr3on2010]

تسلم ايدك اكثر من رائع
يريت يثبت

[™Dev Microsoft™]

تسلم ايدك اكثر من رائع
يريت يثبت
تسلم :)

[Bazooka100]

اســـتـــمـــر :whistling:

[Hamza FiGo]

بجد ممتاز

شكرا جزيلاااااااااااااااا

[™Dev Microsoft™]

اســـتـــمـــر :whistling:

thx :)
بجد ممتاز

شكرا جزيلاااااااااااااااا

ده بس من زوق حضرتك & ده واجب عليا و يارب اكون افدت حضراتكم :)

[Alrayk]

تسلم يا كبير :mf_lustslow:

[™Dev Microsoft™]

Nice Topic My Son :111 (23):
ومالو يا حبيبي :bicycle:
تسلم يا كبير :mf_lustslow:
ربنا يخليك :)

[Tigger]

تسلمـ

[™Dev Microsoft™]

thq bro

[!_Ahmed Elabbasy_!]

Tslam bs ana 3ande Biling Dead Wa 3ml kol 7aga s7 :S odbc + Sever.cfg zyak bzbat +iis Port 8080 a3ml eh
http://www.ot2.cohttpm/download/133021/you.can.Fix.it.take.it.___.png.html

[elbattawy1st]

BeGaD PriNcE :v9v9net_017:

[Hero]

تمام

[™Dev Microsoft™]

برو انت متأكد انك مسطب الـ iis كامل اصلا ؟

[™Dev Microsoft™]

عموما ده لينك موضوع قديم بس هايساعدكو كتيير
http://www.silkroad4arab.com/vb/showthread.php?t=534603

[Legacy]

تمام بس ال Reset Stat + Change Password مش شغلين

[Mr.Android]

بجد روعة :specool:

[™Dev Microsoft™]

Ty <3

[iLead]

برنس والله

بس في شويت لينكات في ال Database

لينكاتها بايزه

[™Dev Microsoft™]

قولي عليها و انا هارفعها من جديد
انت مش شايف التوقيع مكتوب فيه ( Report Dead Links ) !! :111:

[iLead]

خامسا : DB cap 110

Link Dead

[™Dev Microsoft™]

خامسا : DB cap 110

Link Dead

done :) :poster_spam::wolverine:

[13E7]

تمام الله ينور عليك

[iLead]

Db D11

R-Friend's ولا Omega

[iLead]

معلومه

OmegaSro Database

بايزه فيها Error في ال Param's

ياريت تشوفلنا R-Friend's عشان تبقي زي ال كلينت

[™Dev Microsoft™]

علي فكرة دي R-friends
بس الاسم بس اللي متغيير :)

[!_Ahmed Elabbasy_!]

بجد شغل عالى

[™Dev Microsoft™]

تسلم :)

[™Dev Microsoft™]

في حد قابلتو اش مشكلة تاني !!

[elgemizi1]

GooooooD Jop
فعلا ده 3 موضوع ليك و عجبني اوي :mf_lustslow:

[™Dev Microsoft™]

تسلم كتيير يا برو ^_^
بس للاسف ممنوع الفرانكو و ياريت تعدل المشاركة بتاعتك قدامك لحد بليل لو مش عدلتها هاعملها انا :)

[™Dev Microsoft™]

تم التعديل علي مشاركة elgemizi1 (http://www.silkroad4arab.com/vb/member.php?u=119498)
و تحويلها الي لغة عربية

[medolife20]

معلش كنت عاوز اتكلم معاك فى موضوع على الخاص بعد اذنك البيرت
وحاولت ابعتلك مسج هنا بس بيقول مينفعش فياريت لو ينفع اتكلم معاك على الخاص

[loht]

مجهود كبير الله ينور

[™Dev Microsoft™]

thq

[™Dev Microsoft™]

!! UP

[waleedelmassry]

ما شاء اللة روعة

[geraya.sama]

:mf_laughbounce::mf_laughbounce: تسلم يا كبير

[MR.KaBO]

هو موضوع جميل تسلم

بس الخط زباله وونص اللغة انجليزي يا راجل هو في حد فاهم عربي :thumbsup:

[deadly123]

شغال مشاء الله علي مياه بيضه تسلم :)