|
You last visited: Today at 16:07
Advertisement
[ Release ] New Sql DB quires Collection .
Discussion on [ Release ] New Sql DB quires Collection . within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
05/09/2012, 02:50
|
#16
|
elite*gold: 0 
Join Date: Apr 2009
Posts: 1,713
Received Thanks: 892
|
Quote:
Originally Posted by ahmed4ever2u
here you are another good one 
GM account ( ip & [GM stats] & Some Gold ) [Main]
PHP Code:
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] UnderGround
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999
where CharName16 like '%[GM] UnderGround%';
1st Edit [main]
Honor Fix
PHP Code:
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
2nd Edit [not main] :
all users to jangan
PHP Code:
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
edit 3 : ( main )
Clean grap pets inventory ( kral for hackers )
PHP Code:
use SHARD_1
exec _ClearInvalidCOS
Edit 4 : ( main )
cleaning db from trashes & invalid data
PHP Code:
use SHARD_1
exec _RemoveAllInvalidData
|
Sweeet  i will have use for atleast 2 of this ones
|
|
|
|
05/09/2012, 15:27
|
#17
|
elite*gold: 0
Join Date: May 2012
Posts: 37
Received Thanks: 7
|
Quote:
Originally Posted by ahmed4ever2u
here you are another good one
GM account ( ip & [GM stats] & Some Gold ) [Main]
PHP Code:
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] UnderGround
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999
where CharName16 like '%[GM] UnderGround%';
1st Edit [main]
Honor Fix
PHP Code:
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
2nd Edit [not main] :
all users to jangan
PHP Code:
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
edit 3 : ( main )
Clean grap pets inventory ( kral for hackers )
PHP Code:
use SHARD_1
exec _ClearInvalidCOS
Edit 4 : ( main )
cleaning db from trashes & invalid data
PHP Code:
use SHARD_1
exec _RemoveAllInvalidData
|
i will use them 
|
|
|
|
|
05/09/2012, 20:02
|
#18
|
elite*gold: 0
Join Date: Feb 2010
Posts: 2,278
Received Thanks: 443
|
Quote:
Originally Posted by tamer15
well , thank you
but i would ask blackrogue got skilldatax.enc ?
|
no........
|
|
|
|
|
05/10/2012, 17:00
|
#19
|
elite*gold: 0
Join Date: Apr 2012
Posts: 338
Received Thanks: 180
|
New Quires are added ....
Thanks to , Ahmed4ever2u , and 
-change character's mastery's at a certain level..
Credits ; nukertube , By ღ ∂ropp
PHP Code:
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]BlackBerry'
UPDATE [dbo].[_CharSkillMastery]
SET Level= 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Change Character User Name , A.K.A. ID.
Credits ; nukertube , By ღ ∂ropp
PHP Code:
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 )
Credits : nukertube , By ღ ∂ropp
PHP Code:
USE [SRO_VT_SHARD]
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 )
by : Ahmed4ever2u
PHP Code:
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] UnderGround
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999
where CharName16 like '%[GM] UnderGround%';
-Honor ranks Fix.
by : Ahmed4ever2u
PHP Code:
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.
by : ahmed4ever2u
PHP Code:
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 .
By : Ahmed4ever2u
PHP Code:
use SHARD_1
exec _ClearInvalidCOS
-cleaning db from trashes & invalid data.
by : ahmed4ever2u
PHP Code:
use SHARD_1
exec _RemoveAllInvalidData
|
|
|
|
|
05/11/2012, 16:14
|
#20
|
elite*gold: 0
Join Date: May 2012
Posts: 37
Received Thanks: 7
|
Quote:
Originally Posted by Neko*
New Quires are added ....
Thanks to , Ahmed4ever2u , and
-change character's mastery's at a certain level..
Credits ; nukertube , By ღ ∂ropp
PHP Code:
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]BlackBerry'
UPDATE [dbo].[_CharSkillMastery]
SET Level= 120
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
Change Character User Name , A.K.A. ID.
Credits ; nukertube , By ღ ∂ropp
PHP Code:
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 )
Credits : nukertube , By ღ ∂ropp
PHP Code:
USE [SRO_VT_SHARD]
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 )
by : Ahmed4ever2u
PHP Code:
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] UnderGround
where CharName16 like '%UnderGround%';
GO
update _Char set RemainGold = 999999999999
where CharName16 like '%[GM] UnderGround%';
-Honor ranks Fix.
by : Ahmed4ever2u
PHP Code:
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.
by : ahmed4ever2u
PHP Code:
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 .
By : Ahmed4ever2u
PHP Code:
use SHARD_1
exec _ClearInvalidCOS
-cleaning db from trashes & invalid data.
by : ahmed4ever2u
PHP Code:
use SHARD_1
exec _RemoveAllInvalidData
|
more useful query's
|
|
|
|
|
05/11/2012, 17:13
|
#21
|
elite*gold: 0
Join Date: Nov 2009
Posts: 1,163
Received Thanks: 1,161
|
Here's another query for you, it's to ban players via database, easily with 1 query.
PHP Code:
--By Leandro ( nukertube ) --
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
-----------------------------------------------------------------
--By Leandro ( nukertube ) --
|
|
|
|
|
05/13/2012, 02:12
|
#22
|
elite*gold: 0
Join Date: Apr 2011
Posts: 590
Received Thanks: 774
|
you must put Name Of Credits this is query
!!
|
|
|
|
|
05/13/2012, 02:20
|
#23
|
elite*gold: 0
Join Date: Apr 2012
Posts: 338
Received Thanks: 180
|
Quote:
Originally Posted by BestOnWorld
you must put Name Of Credits this is query
!!
|
Well , i didn't give the credits to my self , and this was my own Sql Quires library , so i didn't save the credits with each one.. , and i added some btw
Could you please tell me which query is yours ?
|
|
|
|
|
05/13/2012, 03:26
|
#24
|
elite*gold: 0
Join Date: Apr 2011
Posts: 590
Received Thanks: 774
|
Quote:
Originally Posted by Neko*
Well , i didn't give the credits to my self , and this was my own Sql Quires library , so i didn't save the credits with each one.. , and i added some btw
Could you please tell me which query is yours ? |
no problem i was think you give Credits to your self
Added 120 Skills By Me
and this is Query to Search in RefObjCommon
USE [SRO_VT_SHARD]
GO
SELECT [Service]
,[ID]
,[CodeName128]
,[ObjName128]
,[OrgObjCodeName128]
,[NameStrID128]
,[DescStrID128]
,[CashItem]
,[Bionic]
,[TypeID1]
,[TypeID2]
,[TypeID3]
,[TypeID4]
,[DecayTime]
,[Country]
,[Rarity]
,[CanTrade]
,[CanSell]
,[CanBuy]
,[CanBorrow]
,[CanDrop]
,[CanPick]
,[CanRepair]
,[CanRevive]
,[CanUse]
,[CanThrow]
,[Price]
,[CostRepair]
,[CostRevive]
,[CostBorrow]
,[KeepingFee]
,[SellPrice]
,[ReqLevelType1]
,[ReqLevel1]
,[ReqLevelType2]
,[ReqLevel2]
,[ReqLevelType3]
,[ReqLevel3]
,[ReqLevelType4]
,[ReqLevel4]
,[MaxContain]
,[RegionID]
,[Dir]
,[OffsetX]
,[OffsetY]
,[OffsetZ]
,[Speed1]
,[Speed2]
,[Scale]
,[BCHeight]
,[BCRadius]
,[EventID]
,[AssocFileObj128]
,[AssocFileDrop128]
,[AssocFileIcon128]
,[AssocFile1_128]
,[AssocFile2_128]
,[Link]
FROM [dbo].[_RefObjCommon]
WHERE (CodeName128 LIKE 'Put Here Your Item Name')
|
|
|
|
|
05/14/2012, 14:23
|
#25
|
elite*gold: 0
Join Date: Jul 2011
Posts: 1,058
Received Thanks: 1,118
|
Last 100 Drops from Mobs (with the use of the SHARDLOG DB), for Homepages or w/e ->
PHP Code:
USE SRO_VT_SHARD
BEGIN
SELECT TOP 100
chart.CharName16 as Player,
elog.ItemRefID as ItemID,
ref.CodeName128 as ItemCode,
CASE WHEN CHARINDEX('Opt',elog.strDesc) != 0 THEN SUBSTRING(elog.strDesc,(PATINDEX('%+%',elog.strDesc)),2) ELSE '+0' END as '+Amount',
SUBSTRING(elog.strDesc,CHARINDEX('MOB',elog.strDesc),(CHARINDEX(',',elog.strDesc, CHARINDEX('MOB',elog.strDesc)))-CHARINDEX('MOB',elog.strDesc)) as Monster,
CASE
WHEN chart.CharName16 collate SQL_Latin1_General_CP1_CI_AS like '%'+(SUBSTRING(elog.strDesc,CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1,(CHARINDEX(']',elog.strDesc, CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1))-CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))-1))+'%'
THEN '-'
WHEN CHARINDEX('Var',elog.strDesc) != 0
THEN UPPER(SUBSTRING(elog.strDesc,CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1,(CHARINDEX(']',elog.strDesc, CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))+1))-CHARINDEX('[',elog.strDesc,CHARINDEX('Var',elog.strDesc))-1))
ELSE '-'
END as Info,
elog.EventTime as 'Date'
FROM _Items as items
JOIN /*#*/SRO_VT_SHARDLOG.dbo._LogEventItem/*#*/ as elog on items.Serial64 = elog.Serial64
JOIN _Char as chart on elog.CharID = chart.CharID
JOIN _RefObjCommon as ref on elog.ItemRefID = ref.ID
WHERE
elog.strDesc like '%MOB%'
AND elog.strDesc not like '%NPC%'
AND ref.CodeName128 not like '%ARCHEMY%'
AND chart.CharName16 not like '%[GM]%'
ORDER BY elog.EventTime desc
END
I'm Caipi, if I cud I'd rename my nick here but unfortunately.. ;o
A list of the online players also through the SHARDLOG DB:
PHP Code:
USE SRO_VT_SHARDLOG
SELECT
chart.CharName16 as 'Player',
CASE
WHEN MAX(elog.EventID) = 4 THEN 'Online'
WHEN MAX(elog.EventID) = 6 THEN 'Offline'
ELSE '-'
END as 'Status',
CASE
WHEN MAX(elog.EventID) = 6 THEN '0'
WHEN LEN(MAX(elog.EventTime)) > 0 THEN DATEDIFF(MINUTE,cast(MAX(elog.EventTime) as datetime),GETDATE())
ELSE '-'
END as 'Minutes',
MAX(elog.EventTime) as Date
FROM
/*#*/_LogEventChar/*#*/ as elog
JOIN /*#*/SRO_VT_SHARD.dbo._Char/*#*/ as chart on elog.CharID = chart.CharID
WHERE
(elog.EventID = 4 OR elog.EventID = 6)
GROUP BY chart.CharName16
HAVING MAX(elog.EventID) = 4
ORDER BY MAX(elog.EventID) asc
|
|
|
|
|
05/14/2012, 14:27
|
#26
|
elite*gold: 0
Join Date: Dec 2007
Posts: 3,210
Received Thanks: 6,289
|
Quote:
Originally Posted by IceAmStiel
I'm Caipi, if I cud I'd rename my nick here but unfortunately.. ;o
|
PM any admin about it, I asked them to change my nick and they did it pretty fast, around 1 year ago or so.
|
|
|
|
|
05/25/2012, 09:51
|
#27
|
elite*gold: 0
Join Date: Jan 2008
Posts: 122
Received Thanks: 23
|
thank you for all these awesome queries
|
|
|
|
|
05/27/2012, 06:26
|
#28
|
elite*gold: 0
Join Date: May 2010
Posts: 578
Received Thanks: 166
|
ღ ∂ Ropp is trying to stay with my credits?
|
|
|
|
|
05/27/2012, 07:52
|
#29
|
elite*gold: 179
Join Date: Dec 2010
Posts: 931
Received Thanks: 311
|
thanks its useful
|
|
|
|
|
10/20/2013, 13:20
|
#30
|
elite*gold: 0
Join Date: Mar 2009
Posts: 28
Received Thanks: 0
|
UPDATE dbo._RefSkill
SET Service = 0
WHERE ID BETWEEN 3437 AND 3440
Fix Fire Shield - Emperror 6 Lv
|
|
|
|
 |
|
Similar Threads
|
[RELEASE] Collection Of Various Pets
04/02/2012 - EO PServer Guides & Releases - 15 Replies
Ok guys, unlike some members of the community i feel like actually contributing. Actually its more of I am bored so i feel like releasing some things. Below is about 1/6th of all the pets i have collected to put in an EO server. I aint bothered to delete them so i thought i would release some of them. I doubt i will release them all simply because i have given them to a few of the servers i respect and i wont do that to them.
Before you ask, no there is no DB part of it. If you cant figure...
|
[Release] S4 League Hack Collection
10/22/2011 - S4 League Hacks, Bots, Cheats & Exploits - 76 Replies
Hello everyone.
This Thread is for the Members who dont know to Search.
I read it x100 times what someone search a Hack and thats enough.
If a Member Post again somethink like "I need a hack" you can post the Thread URL on hes Thread.
| | | | | |
Nightmare | Kintow | Spoiler ZrnX001 | v.2.1 | Yes | Yes | Updated +
-Cyber D3D- | -CyberLinK- | Spoiler ZrnX002 | v.2.3 | Yes | Yes | Updated +
Unknown Viruz | -Zombie-001- | Spoiler ZrnX005 | v.1.1 | Yes | No | Updated +
|
[Release] Lucidsoft - Collection
11/10/2010 - Flyff PServer Guides & Releases - 14 Replies
Hallo lieber E*PvP'er/in.
In diesem Thread werde ich euch meinen Collection Generator vorstellen und auch Releasen und jeweils Updaten.
Dieser sieht so aus:
http://img94.imageshack.us/img94/4690/1111bkc.jpg
und kann mom bisher leider nur ein Ticket erstellen, doch werden in den nächsten versionen immer neuere und viel bessere Updates nachfolgen.
|
Release GMS V0.55 hacks collection
10/06/2008 - MapleStory - 12 Replies
Monster Glue
Stickies all Monsters on the floor. Should work great with ground-bound monsters. No DC, but when other players are in the map their client may overdrive the effect.
RapidShare: 1-Click Webhosting
MEGAUPLOAD - The leading online storage and file delivery service
Supramob (New: Fight up to 50 Monsters at once instead of just 6)
|
All times are GMT +2. The time now is 16:07.
|
|
![[ Release ] New Sql DB quires Collection .](https://www.elitepvpers.com/forum/iconimages/sro-pserver-guides-releases/release-new-sql-db-quires-collection_ltr.gif){kind=small}
