New Query :)

[Ayman shawky]

اقعدت اقلب في المواقع ولمتلكم شوية Query كده وكمان في منهم كويري جديد ^^
نخش على الموضوع
1- Query To Plvl Char
كل اللي عليك هتحط الكويري وتحط اسم Char ومبروك بقى لفل 120

USE [SRO_VT_SHARD]
Declare @CharName VarChar(max)
Declare @Level BigInt
SET @CharName= 'Charname' --CharName
SET @Level = '120' --Level
UPDATE [Dbo].[_Char]
SET InventorySize = '109', --Iventory Size Min 45 max 109
RemainGold = RemainGold + '1', --GOLD to give
HwanLevel = '0', --Zerk Level ( 0 to none )
RemainSkillPoint = RemainSkillPoint + '101000', --SkillPoint to give
CurLevel = @Level,
MaxLevel = @Level,
Strength = @Level+19,
Intellect = @Level+19,
RemainStatPoint = @Level * 3 -3,
RemainHwanCount = 5, --RemainHwanCount
ExpOffset = 1-- Exp
WHERE CharName16 = @CharName


2- Query To Change Graduate And Honor Point
بمعنى ^^ كل اللي عليك هتحط اسم الChar وتغير ال Graduates بالرقم اللي انتا عايزة

USE [SRO_VT_SHARD]
DECLARE @CharName Varchar (MAX)
DECLARE @Graduates INT
DECLARE @HonorPoints INT
DECLARE @CharID INT
DECLARE @CampID INT
SET @CharName = 'Charname'
SET @CharID = (Select CharID FROM _Char Where CharName16 = @CharName)
SET @CampID = (Select TOP 1 CampID FROM _TrainingCampBuffStatus Where RecipientCharID = @CharID)
SET @Graduates = '1234'
SET @HonorPoints= @Graduates * 39

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

UPDATE [Dbo].[_TrainingCamp]
SET GraduateCount = @Graduates
WHERE [Dbo].[_TrainingCamp].[ID] = @CampID
UPDATE [dbo].[_TrainingCampMember]
SET HonorPoint = @HonorPoints
WHERE [dbo].[_TrainingCampMember].[CampID]=@CampID


3-نيجي بقى للجديد ^_^ Query To Know Amount silk With The Char By ID
بمعنى انك تعرف الأكونت ده في كام سيلك .. بالID بتاع الأكونت ^^ كل اللي عليك هتحط الId بتاع الأكونت ومبروك عليك ^^

USE [SRO_VT_ACCOUNT]
SELECT * FROM SK_Silk WHERE JID = (SELECT JID FROM TB_USER WHERE StrUserID = 'xxx')


4-Query To Remove Pk By CharName
بمعنى :) انكـ تحط اسم الChar يبقى الميلدر بتاعها زيرو ^^ Pk هيبقى صفر :)
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


5-Query To Remove Pk For all players
بمعنى كل اللعيبة اللي عندكـ في الجيم :) يبقى الميلدر بتاعها 0 الPk

USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0


6-Query To Ban Player By Char Name
يعني حط اسم الChar ياخد بان زي الفل :751:

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



7-Query To Unban Account By Char Name
بمعنى ^^ انك تشيل البان اللي حضرتك زرففته للبني آدم اللي زعلك :smokeing:

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


يارب اكون افدتكم بحاجة جديدة :mf_popcorn:

كلـمـة شـكـر تكـفـيـنـي

المفاجأه بتاعت الموضوع مقدم مني انا شخصيا بتجربه شخصيا ^^ حاجة بقى من الآخر
/spawnunique_all
حطها عندكـ في الكونسل ^_^ هتلاقي اليونيكات نزلت في مكانها الأساسي