|
You last visited: Today at 16:09
Advertisement
[Release] some useful Query's
Discussion on [Release] some useful Query's within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
08/06/2012, 03:17
|
#1
|
elite*gold: 5
Join Date: May 2012
Posts: 217
Received Thanks: 113
|
[Release] some useful Query's
Query to Plvl Char
Quote:
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
|
Query to Change Graduate and Honor Point
Quote:
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
|
Query to Show amount silk by User ID
Quote:
USE [SRO_VT_ACCOUNT]
SELECT * FROM SK_Silk WHERE JID = (SELECT JID FROM TB_USER WHERE StrUserID = 'xxx')
|
Query to Remove PK by CharName
Quote:
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
Quote:
USE [SRO_VT_SHARD]
UPDATE _Char SET
DailyPK= 0,
TotalPK= 0,
PKPenaltyPoint= 0
|
Query to Ban Player By CharName
Quote:
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 Acc By CharName
Quote:
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
-----------------------------------------------------------------
|
|
|
|
08/06/2012, 05:52
|
#2
|
Chat Killer In Duty
elite*gold: 5
Join Date: May 2008
Posts: 16,304
Received Thanks: 6,460
|
#approved
|
|
|
09/29/2012, 14:18
|
#3
|
elite*gold: 0
Join Date: Jan 2011
Posts: 292
Received Thanks: 46
|
All Works fine ty
|
|
|
Similar Threads
|
[HELP]Suche Drachengott Equip Query's
04/30/2012 - Metin2 Private Server - 3 Replies
Wie man oben sehen kann suche ich nach den DG Eq query's um die Serverside einzufügen. :D
Schnelle Hilfe!!
|
Alle Zombie-Mob Query's
01/03/2011 - Metin2 Private Server - 2 Replies
Suche alle Query's der Zombie-Mob's!:cool:
...überal gesucht.
Edit!: Von allen Gnomen ebenfalls... Thx.
|
[Helpful] Query's For New Server Owners.
08/27/2010 - EO PServer Hosting - 4 Replies
Here i am going to release some query's to help some of you out. I am sure alot of the older members of server owners. Already no all of this.
Well here is the frist one.
Query For Deleteing Flowers Off of a Player.
update cq_user set flower=0 where account_id=2;
update cq_user set flower_w=0 where account_id=2;
DELETE FROM cq_flower WHERE player_id >= 14481775;
|
All times are GMT +1. The time now is 16:09.
|
|