|
|
• الانـتـسـاب » Mar 2013
|
|
• رقـم العـضـويـة » 110495
|
|
• المشـــاركـات » 2,214
|
|
• الـدولـة » in Dedicated Server
|
|
• الـهـوايـة » Develop DB&PHP Edit&Fixing Buged Files
|
|
• اسـم الـسـيـرفـر » Private Server
|
|
• الـجـنـس » Male
|
|
• نقـاط التقييم » 61
|
|
|
 
|
.gif)
كل شئ له علاقة بالـVsro هنا و بس ,,, By #Albert
I. TABLE SQL
SRO_VT_ACCOUNT
[SPOILER]
كود PHP:
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 --
---------------------------------
---------------------------
INSERT [dbo].[_Punishment]
(
[UserJID],
[Type],
[Executor],
[Shard],
[CharName],
[CharInfo],
[PosInfo] ,
[Guide],
[Description],
[RaiseTime],
[BlockStartTime],
[BlockEndTime],
[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
كود 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
-----------------------------------------------------------------
[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
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
[/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
كود PHP:
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
كود 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
[/SPOILER]
Teleport All users to Jangan
كود PHP:
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
كود PHP:
use SHARD_1
exec _ClearInvalidCOS
cleaning db from trashes & invalid data
كود PHP:
use SHARD_1
exec _RemoveAllInvalidData
ثانيا : بعض المشاكل و حلولها :
ثالثا : مجموعة مختلفة من الـ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)
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)
[/SPOILER]
ثالثا : DB Cap90
[SPOILER]
كود PHP:
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
}
[/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>
<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 !
|
[/SPOILER]
ثانيا : php الـplayer Ranking
[SPOILER]
اقتباس:
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.
|
[/SPOILER]
تالثا : php الـChange PASS
[SPOILER]
كود PHP:
<?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();
}
?>
[/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) {
$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");
[/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 : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
Database (.sql) clean no include 
Link : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
-----------------------------------------------------------------------------------------
Image : This image has been resized. Click this bar to view the full image. The original image is sized 1202x939. 
Analyse Virus .rar : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
Database (.sql) clean no include
Link : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
-----------------------------------------------------------------------------------------
Image : This image has been resized. Click this bar to view the full image. The original image is sized 1758x936. 
Analyse Virus .rar : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
Database (.sql) clean no include
Link : عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
سابعا : شرح وافي للـIIS
ثامنا : شراح وافي لكيفية عمل سيرفر خاص بالفيديو
By: ELjOker
اقتباس:
part1
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
part 2
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
part 3
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
part 4
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
part 5
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
part 6
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]
|
تاسعا : PHP SCRIPTS
* 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>
<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 !
|
[/SPOILER]
* php الـplayer Ranking
[SPOILER]
اقتباس:
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.
|
[/SPOILER]
* php الـChange PASS
[SPOILER]
كود PHP:
<?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();
}
?>
[/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) {
$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");
[/SPOILER]
</div>
|
19-11-2013, 04:13 AM
المواضيع المتشابهه
العرض الشجري