Useful Queries Make you life Easier

SubZero*

عضو
2 فبراير 2017
98
1
0
16
Egypt

المستوي:


SHOFf.gif

Only At probasha


UZrGdab.gif


Query Clean SRO_VT_ACCOUNT
PHP:
USE [SRO_VT_ACCOUNT] 
GO 
TRUNCATE TABLE [dbo].[__SiegeFortressStatus__] 
TRUNCATE TABLE [dbo].[_BlockedUser] 
TRUNCATE TABLE [dbo].[_CasGMChatLog] 
TRUNCATE TABLE [dbo].[_Notice] 
TRUNCATE TABLE [dbo].[_Punishment] 
TRUNCATE TABLE [dbo].[_ServiceManagerLog] 
TRUNCATE TABLE [dbo].[_ShardCurrentUser] 
TRUNCATE TABLE [dbo].[_SMCLog] 
TRUNCATE TABLE [dbo].[QuaySoEpoint] 
TRUNCATE TABLE [dbo].[SK_CharRenameLog] 
TRUNCATE TABLE [dbo].[SK_DownLevelLog] 
TRUNCATE TABLE [dbo].[SK_ITEM_GuardLog] 
TRUNCATE TABLE [dbo].[SK_ItemSaleLog] 
TRUNCATE TABLE [dbo].[SK_PackageItemSaleLog] 
TRUNCATE TABLE [dbo].[SK_PK_UpdateLog] 
TRUNCATE TABLE [dbo].[SK_ResetSkillLog] 
TRUNCATE TABLE [dbo].[SK_Silk] 
TRUNCATE TABLE [dbo].[SK_SilkBuyList] 
TRUNCATE TABLE [dbo].[SK_SubtractSilk_VAS] 
TRUNCATE TABLE [dbo].[SR_ShardCharNames] 
TRUNCATE TABLE [dbo].[TB_Net2e] 
TRUNCATE TABLE [dbo].[TB_Net2e_Bak] 
TRUNCATE TABLE [dbo].[tb_partnerInfo] 
TRUNCATE TABLE [dbo].[tb_paygate_trans] 
TRUNCATE TABLE [dbo].[TB_User] 
TRUNCATE TABLE [dbo].[TB_User_Bak] 
TRUNCATE TABLE [dbo].[Test_HN] 
UPDATE [dbo].[_ShardService] SET ShardID = '64'

UZrGdab.gif




Clean Shard
PHP:
USE [SRO_VT_SHARD] 
GO 
truncate table _OpenMarket 
truncate table _CharSkill 
truncate table _CharSkillMastery 
truncate table _GuildMember 
truncate table _BlockedWhisperers 
truncate table _Inventory 
truncate table _InventoryForAvatar 
truncate table _InventoryForLinkedStorage 
truncate table _TrainingCampMember 
truncate table _TrainingCampSubMentorHonorPoint 
truncate table _TrainingCampHonorRank 
truncate table _TrainingCampBuffStatus 
delete from _TrainingCamp 
truncate table _StaticAvatar 
truncate table _User 
truncate table _Friend 
truncate table _Memo 
truncate table _TimedJob 
truncate table _CharTrijobSafeTrade 
delete from _CharTrijob 
truncate table _InvCOS 
delete from _CharCOS where ID > 0 
delete from _Char where charid > 0 
truncate table _Chest 
truncate table _ChestInfo 
truncate table _ItemPool 
delete from _Items where ID64 > 0 
delete from _AccountJID 
truncate table _GuildChest 
update _AlliedClans set Ally1 = 0, Ally2 = 0, Ally3 = 0, Ally4 = 0, Ally5 = 0, Ally6 = 0, Ally7 = 0, Ally8 = 0 
truncate table _GuildWar 
delete from _Guild where ID > 0 
delete from _AlliedClans where ID > 0 
truncate table _CharNameList 
truncate table _CharQuest 
truncate table _ClientConfig 
truncate table _DeletedChar 
truncate table _SiegeFortressStoneState 
truncate table _SiegeFortressRequest 
truncate table _SiegeFortressObject 
truncate table _SiegeFortressItemForge 
truncate table _SiegeFortressBattleRecord 
UPDATE  _SiegeFortress SET GuildID = '0', TaxRatio = '0', Tax = '0', NPCHired = '0', Introduction = NULL, CreatedDungeonTime = NULL, CreatedDungeonCount = NULL 
truncate table _CharNickNameList 
truncate table _GPHistory


UZrGdab.gif


Clean Log
PHP:
USE [SRO_VT_SHARDLOG] 
GO 
TRUNCATE TABLE [dbo].[_LogCashItem] 
TRUNCATE TABLE [dbo].[_LogEventChar] 
TRUNCATE TABLE [dbo].[_LogEventItem] 
TRUNCATE TABLE [dbo].[_LogEventSiegeFortress] 
TRUNCATE TABLE [dbo].[_LogSchedule] 
TRUNCATE TABLE [dbo].[_LogServerEvent]


UZrGdab.gif


Query Delete Char By Char Name
PHP:
USE [SRO_VT_SHARD] 
-- Query by InPanic-Kev 
declare @CharID int , @CharName varchar(16) 

set @CharName = 'CharName' 
set @CharID = ( select CharID from _Char where CharName16 = @CharName ) 

exec [_DeleteCharPermanently] @CharID

UZrGdab.gif



Query Plus Devil
PHP:
UPDATE dbo._Items set OptLevel='plus devil here'WHERE ID64='id devil here'

Fix Bug F1
PHP:
UPDATE _RefCharDefault_Quest SET Service = 1  
delete from _CHARQUEST where QuestID = 1  
INSERT INTO _CharQuest (CharID, QuestID, Status,AchievementCount,StartTime,EndTime,QuestData1,QuestData2) SELECT CharID, 1,5,0, '2012-04-13 20:44:00','2012-04-13 20:44:00',31458135,0 FROM _CHAR where CharID > 0

Query Delete Item From All Players
PHP:
USE [SRO_VT_SHARD]  

Exec [Dbo].[_SEEK_N_DESTROY_ITEM]  'ITEM_COS_P_RABBIT_SCROLL'

UZrGdab.gif



Anther One
PHP:
USE [SRO_VT_SHARD] --- Coded by [iLegend]  
Declare @ItemCodeName Varchar (129)  
Set @ItemCodeName = 'CodeName128' --- write here the item codename128 that u want to remove it from all players.  
Update _Chest Set ItemID = 0   
where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))  
Update _Inventory Set ItemID = 0   
where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))  
Update _InvCOS Set ItemID = 0   
where ItemID in ( Select ID64 From _Items where RefItemID = (Select ID From _RefObjCommon where CodeName128 = @ItemCodeName ))

UZrGdab.gif



Query Get ID Item
PHP:
Use SRO_VT_SHARD select ID from _RefObjCommon where CodeName128 like 'CODE ITEM HERE'

UZrGdab.gif


Query Max Stack
PHP:
USE SRO_VT_SHARD 
DECLARE @CodeName VARCHAR(30) 
DECLARE @MaxStack INT 
SET @CodeName='%Code Item here%' 
SET @MaxStack=1000 --- New max stack  
UPDATE _RefObjItem SET MaxStack=@MaxStack WHERE ID IN (SELECT Link FROM _RefObjCommon WHERE CodeName128 LIKE @CodeName AND Service=1)



UZrGdab.gif


Query Change Npc Place
PHP:
USE [SRO_VT_SHARD] 

DECLARE @KINGEDITOR1 VARCHAR (129) 
DECLARE @CHARNAME VARCHAR (64) 

SET @KINGEDITOR1 = 'NPC_START_QUEST' ----- Your Npc Name 
SET @CHARNAME = 'Bedo_' ----- Charactar name [ where you Want to set npc ] 

Declare @AS1 int SET @AS1 = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @KINGEDITOR1) 
Declare @AS2 int SET @AS2 = (SELECT dwTacticsID FROM Tab_RefTactics WHERE dwObjID = @AS1) 
Declare @AS3 int SET @AS3 = (SELECT dwNestID FROM Tab_RefNest WHERE dwTacticsID = @AS2) 

Declare @ASpos1 int SET @ASpos1 = (SELECT latestregion FROM _char WHERE charname16 = @CHARNAME) 
Declare @ASpos2 int SET @ASpos2 = (SELECT posx FROM _char WHERE charname16 = @CHARNAME) 
Declare @ASpos3 int SET @ASpos3 = (SELECT posy FROM _char WHERE charname16 = @CHARNAME) 
Declare @ASpos4 int SET @ASpos4 = (SELECT posz FROM _char WHERE charname16 = @CHARNAME) 
--------------- By Rover 
UPDATE Tab_RefNest 
SET nregiondbid = @ASpos1, 
flocalposx = @ASpos2, 
flocalposy = @ASpos3, 
flocalposz = @ASpos4 
WHERE dwnestid = @AS3 and dwtacticsid = @AS2


UZrGdab.gif


Query Add Item To char

PHP:
USE SRO_VT_SHARD  
--Usage: 
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl 
declare @CharName varchar(64)  
  
set @CharName = 'YourCharName' 
  
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_TSTAFF_11_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_STAFF_11_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_NECKLACE_11_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_EARRING_11_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_RING_11_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_HA_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_SA_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_LA_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_FA_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_AA_SET_B_RARE',1,100    
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EU_W_CLOTHES_11_BA_SET_B_RARE',1,100


UZrGdab.gif


Query Delete PREM HONOR GODBLESS
PHP:
USE SRO_VT_SHARD 
GO 
DECLARE @CharName Varchar (MAX) 
DECLARE @CharID INT 
SET        @CharName = 'By Bedo' 
SET        @CharID = (Select CharID FROM _Char Where CharName16 = @CharName) 
DELETE FROM _TimedJob WHERE CharID = @CharID


Query Open skills for ch/eu
PHP:
USE SRO_VT_SHARD 
DECLARE @CharName varchar(255) 
DECLARE @CharID INT 

SET @CharName='Anas' 

SELECT @CharID = CharID FROM _Char WHERE CharName16=@CharName 

UPDATE _CharSkillMastery SET Level = '140' WHERE CharID=@CharID 

INSERT INTO _CharSkill VALUES (@CharID,1,1) 
INSERT INTO _CharSkill VALUES (@CharID,2,1) 
INSERT INTO _CharSkill VALUES (@CharID,40,1) 
INSERT INTO _CharSkill VALUES (@CharID,70,1) 
INSERT INTO _CharSkill VALUES (@CharID,298,1) 
INSERT INTO _CharSkill VALUES (@CharID,306,1) 
INSERT INTO _CharSkill VALUES (@CharID,314,1) 
INSERT INTO _CharSkill VALUES (@CharID,322,1) 
INSERT INTO _CharSkill VALUES (@CharID,346,1) 
INSERT INTO _CharSkill VALUES (@CharID,378,1) 
INSERT INTO _CharSkill VALUES (@CharID,418,1) 
INSERT INTO _CharSkill VALUES (@CharID,463,1) 
INSERT INTO _CharSkill VALUES (@CharID,558,1) 
INSERT INTO _CharSkill VALUES (@CharID,569,1) 
INSERT INTO _CharSkill VALUES (@CharID,580,1) 
INSERT INTO _CharSkill VALUES (@CharID,588,1) 
INSERT INTO _CharSkill VALUES (@CharID,596,1) 
INSERT INTO _CharSkill VALUES (@CharID,604,1) 
INSERT INTO _CharSkill VALUES (@CharID,647,1) 
INSERT INTO _CharSkill VALUES (@CharID,655,1) 
INSERT INTO _CharSkill VALUES (@CharID,672,1) 
INSERT INTO _CharSkill VALUES (@CharID,689,1) 
INSERT INTO _CharSkill VALUES (@CharID,699,1) 
INSERT INTO _CharSkill VALUES (@CharID,708,1) 
INSERT INTO _CharSkill VALUES (@CharID,716,1) 
INSERT INTO _CharSkill VALUES (@CharID,724,1) 
INSERT INTO _CharSkill VALUES (@CharID,735,1) 
INSERT INTO _CharSkill VALUES (@CharID,746,1) 
INSERT INTO _CharSkill VALUES (@CharID,757,1) 
INSERT INTO _CharSkill VALUES (@CharID,765,1) 
INSERT INTO _CharSkill VALUES (@CharID,773,1) 
INSERT INTO _CharSkill VALUES (@CharID,781,1) 
INSERT INTO _CharSkill VALUES (@CharID,789,1) 
INSERT INTO _CharSkill VALUES (@CharID,797,1) 
INSERT INTO _CharSkill VALUES (@CharID,805,1) 
INSERT INTO _CharSkill VALUES (@CharID,813,1) 
INSERT INTO _CharSkill VALUES (@CharID,821,1) 
INSERT INTO _CharSkill VALUES (@CharID,829,1) 
INSERT INTO _CharSkill VALUES (@CharID,853,1) 
INSERT INTO _CharSkill VALUES (@CharID,885,1) 
INSERT INTO _CharSkill VALUES (@CharID,925,1) 
INSERT INTO _CharSkill VALUES (@CharID,933,1) 
INSERT INTO _CharSkill VALUES (@CharID,943,1) 
INSERT INTO _CharSkill VALUES (@CharID,952,1) 
INSERT INTO _CharSkill VALUES (@CharID,960,1) 
INSERT INTO _CharSkill VALUES (@CharID,968,1) 
INSERT INTO _CharSkill VALUES (@CharID,976,1) 
INSERT INTO _CharSkill VALUES (@CharID,984,1) 
INSERT INTO _CharSkill VALUES (@CharID,992,1) 
INSERT INTO _CharSkill VALUES (@CharID,1003,1) 
INSERT INTO _CharSkill VALUES (@CharID,1014,1) 
INSERT INTO _CharSkill VALUES (@CharID,1025,1) 
INSERT INTO _CharSkill VALUES (@CharID,1033,1) 
INSERT INTO _CharSkill VALUES (@CharID,1041,1) 
INSERT INTO _CharSkill VALUES (@CharID,1049,1) 
INSERT INTO _CharSkill VALUES (@CharID,1053,1) 
INSERT INTO _CharSkill VALUES (@CharID,1057,1) 
INSERT INTO _CharSkill VALUES (@CharID,1065,1) 
INSERT INTO _CharSkill VALUES (@CharID,1073,1) 
INSERT INTO _CharSkill VALUES (@CharID,1081,1) 
INSERT INTO _CharSkill VALUES (@CharID,1089,1) 
INSERT INTO _CharSkill VALUES (@CharID,1099,1) 
INSERT INTO _CharSkill VALUES (@CharID,1108,1) 
INSERT INTO _CharSkill VALUES (@CharID,1116,1) 
INSERT INTO _CharSkill VALUES (@CharID,1124,1) 
INSERT INTO _CharSkill VALUES (@CharID,1132,1) 
INSERT INTO _CharSkill VALUES (@CharID,1140,1) 
INSERT INTO _CharSkill VALUES (@CharID,1148,1) 
INSERT INTO _CharSkill VALUES (@CharID,1153,1) 
INSERT INTO _CharSkill VALUES (@CharID,1158,1) 
INSERT INTO _CharSkill VALUES (@CharID,1163,1) 
INSERT INTO _CharSkill VALUES (@CharID,1168,1) 
INSERT INTO _CharSkill VALUES (@CharID,1173,1) 
INSERT INTO _CharSkill VALUES (@CharID,1178,1) 
INSERT INTO _CharSkill VALUES (@CharID,1189,1) 
INSERT INTO _CharSkill VALUES (@CharID,1200,1) 
INSERT INTO _CharSkill VALUES (@CharID,1217,1) 
INSERT INTO _CharSkill VALUES (@CharID,1234,1) 
INSERT INTO _CharSkill VALUES (@CharID,1244,1) 
INSERT INTO _CharSkill VALUES (@CharID,1253,1) 
INSERT INTO _CharSkill VALUES (@CharID,1261,1) 
INSERT INTO _CharSkill VALUES (@CharID,1269,1) 
INSERT INTO _CharSkill VALUES (@CharID,1271,1) 
INSERT INTO _CharSkill VALUES (@CharID,1273,1) 
INSERT INTO _CharSkill VALUES (@CharID,1275,1) 
INSERT INTO _CharSkill VALUES (@CharID,1286,1) 
INSERT INTO _CharSkill VALUES (@CharID,1297,1) 
INSERT INTO _CharSkill VALUES (@CharID,1308,1) 
INSERT INTO _CharSkill VALUES (@CharID,1316,1) 
INSERT INTO _CharSkill VALUES (@CharID,1324,1) 
INSERT INTO _CharSkill VALUES (@CharID,1332,1) 
INSERT INTO _CharSkill VALUES (@CharID,1337,1) 
INSERT INTO _CharSkill VALUES (@CharID,1342,1) 
INSERT INTO _CharSkill VALUES (@CharID,1350,1) 
INSERT INTO _CharSkill VALUES (@CharID,1358,1) 
INSERT INTO _CharSkill VALUES (@CharID,1368,1) 
INSERT INTO _CharSkill VALUES (@CharID,1377,1) 
INSERT INTO _CharSkill VALUES (@CharID,1385,1) 
INSERT INTO _CharSkill VALUES (@CharID,1393,1) 
INSERT INTO _CharSkill VALUES (@CharID,1398,1) 
INSERT INTO _CharSkill VALUES (@CharID,1403,1) 
INSERT INTO _CharSkill VALUES (@CharID,1408,1) 
INSERT INTO _CharSkill VALUES (@CharID,1410,1) 
INSERT INTO _CharSkill VALUES (@CharID,1412,1) 
INSERT INTO _CharSkill VALUES (@CharID,1414,1) 
INSERT INTO _CharSkill VALUES (@CharID,1422,1) 
INSERT INTO _CharSkill VALUES (@CharID,1430,1) 
INSERT INTO _CharSkill VALUES (@CharID,1438,1) 
INSERT INTO _CharSkill VALUES (@CharID,1443,1) 
INSERT INTO _CharSkill VALUES (@CharID,1448,1) 
INSERT INTO _CharSkill VALUES (@CharID,1465,1) 
INSERT INTO _CharSkill VALUES (@CharID,1482,1) 
INSERT INTO _CharSkill VALUES (@CharID,1499,1) 
INSERT INTO _CharSkill VALUES (@CharID,1509,1) 
INSERT INTO _CharSkill VALUES (@CharID,1518,1) 
INSERT INTO _CharSkill VALUES (@CharID,1526,1) 
INSERT INTO _CharSkill VALUES (@CharID,1534,1) 
INSERT INTO _CharSkill VALUES (@CharID,1539,1) 
INSERT INTO _CharSkill VALUES (@CharID,1544,1) 
INSERT INTO _CharSkill VALUES (@CharID,1549,1) 
INSERT INTO _CharSkill VALUES (@CharID,1557,1) 
INSERT INTO _CharSkill VALUES (@CharID,1565,1) 
INSERT INTO _CharSkill VALUES (@CharID,1573,1) 
INSERT INTO _CharSkill VALUES (@CharID,1578,1) 
INSERT INTO _CharSkill VALUES (@CharID,1583,1) 
INSERT INTO _CharSkill VALUES (@CharID,1588,1) 
INSERT INTO _CharSkill VALUES (@CharID,1593,1) 
INSERT INTO _CharSkill VALUES (@CharID,1598,1) 
INSERT INTO _CharSkill VALUES (@CharID,1609,1) 
INSERT INTO _CharSkill VALUES (@CharID,1617,1) 
INSERT INTO _CharSkill VALUES (@CharID,1628,1) 
INSERT INTO _CharSkill VALUES (@CharID,3149,1) 
INSERT INTO _CharSkill VALUES (@CharID,3167,1) 
INSERT INTO _CharSkill VALUES (@CharID,3176,1) 
INSERT INTO _CharSkill VALUES (@CharID,3224,1) 
INSERT INTO _CharSkill VALUES (@CharID,3340,1) 
INSERT INTO _CharSkill VALUES (@CharID,3349,1) 
INSERT INTO _CharSkill VALUES (@CharID,3364,1) 
INSERT INTO _CharSkill VALUES (@CharID,3379,1) 
INSERT INTO _CharSkill VALUES (@CharID,3391,1) 
INSERT INTO _CharSkill VALUES (@CharID,3406,1) 
INSERT INTO _CharSkill VALUES (@CharID,3409,1) 
INSERT INTO _CharSkill VALUES (@CharID,3415,1) 
INSERT INTO _CharSkill VALUES (@CharID,3430,1) 
INSERT INTO _CharSkill VALUES (@CharID,3431,1) 
INSERT INTO _CharSkill VALUES (@CharID,3446,1) 
INSERT INTO _CharSkill VALUES (@CharID,3461,1) 
INSERT INTO _CharSkill VALUES (@CharID,3467,1) 
INSERT INTO _CharSkill VALUES (@CharID,3473,1) 
INSERT INTO _CharSkill VALUES (@CharID,7139,1) 
INSERT INTO _CharSkill VALUES (@CharID,7159,1) 
INSERT INTO _CharSkill VALUES (@CharID,7203,1) 
INSERT INTO _CharSkill VALUES (@CharID,7322,1) 
INSERT INTO _CharSkill VALUES (@CharID,7385,1) 
INSERT INTO _CharSkill VALUES (@CharID,7390,1) 
INSERT INTO _CharSkill VALUES (@CharID,7392,1) 
INSERT INTO _CharSkill VALUES (@CharID,7404,1) 
INSERT INTO _CharSkill VALUES (@CharID,7418,1) 
INSERT INTO _CharSkill VALUES (@CharID,7474,1) 
INSERT INTO _CharSkill VALUES (@CharID,7484,1) 
INSERT INTO _CharSkill VALUES (@CharID,7513,1) 
INSERT INTO _CharSkill VALUES (@CharID,7520,1) 
INSERT INTO _CharSkill VALUES (@CharID,7536,1) 
INSERT INTO _CharSkill VALUES (@CharID,7554,1) 
INSERT INTO _CharSkill VALUES (@CharID,7577,1) 
INSERT INTO _CharSkill VALUES (@CharID,7582,1) 
INSERT INTO _CharSkill VALUES (@CharID,7584,1) 
INSERT INTO _CharSkill VALUES (@CharID,7596,1) 
INSERT INTO _CharSkill VALUES (@CharID,7612,1) 
INSERT INTO _CharSkill VALUES (@CharID,7637,1) 
INSERT INTO _CharSkill VALUES (@CharID,7651,1) 
INSERT INTO _CharSkill VALUES (@CharID,7672,1) 
INSERT INTO _CharSkill VALUES (@CharID,7675,1) 
INSERT INTO _CharSkill VALUES (@CharID,7688,1) 
INSERT INTO _CharSkill VALUES (@CharID,7798,1) 
INSERT INTO _CharSkill VALUES (@CharID,7805,1) 
INSERT INTO _CharSkill VALUES (@CharID,7829,1) 
INSERT INTO _CharSkill VALUES (@CharID,7838,1) 
INSERT INTO _CharSkill VALUES (@CharID,7839,1) 
INSERT INTO _CharSkill VALUES (@CharID,7853,1) 
INSERT INTO _CharSkill VALUES (@CharID,7862,1) 
INSERT INTO _CharSkill VALUES (@CharID,7877,1) 
INSERT INTO _CharSkill VALUES (@CharID,7881,1) 
INSERT INTO _CharSkill VALUES (@CharID,7894,1) 
INSERT INTO _CharSkill VALUES (@CharID,7899,1) 
INSERT INTO _CharSkill VALUES (@CharID,7907,1) 
INSERT INTO _CharSkill VALUES (@CharID,7919,1) 
INSERT INTO _CharSkill VALUES (@CharID,7931,1) 
INSERT INTO _CharSkill VALUES (@CharID,7938,1) 
INSERT INTO _CharSkill VALUES (@CharID,7947,1) 
INSERT INTO _CharSkill VALUES (@CharID,7953,1) 
INSERT INTO _CharSkill VALUES (@CharID,7959,1) 
INSERT INTO _CharSkill VALUES (@CharID,7962,1) 
INSERT INTO _CharSkill VALUES (@CharID,7972,1) 
INSERT INTO _CharSkill VALUES (@CharID,7980,1) 
INSERT INTO _CharSkill VALUES (@CharID,7995,1) 
INSERT INTO _CharSkill VALUES (@CharID,7997,1) 
INSERT INTO _CharSkill VALUES (@CharID,8010,1) 
INSERT INTO _CharSkill VALUES (@CharID,8024,1) 
INSERT INTO _CharSkill VALUES (@CharID,8050,1) 
INSERT INTO _CharSkill VALUES (@CharID,8084,1) 
INSERT INTO _CharSkill VALUES (@CharID,8097,1) 
INSERT INTO _CharSkill VALUES (@CharID,8103,1) 
INSERT INTO _CharSkill VALUES (@CharID,8109,1) 
INSERT INTO _CharSkill VALUES (@CharID,8115,1) 
INSERT INTO _CharSkill VALUES (@CharID,8119,1) 
INSERT INTO _CharSkill VALUES (@CharID,8129,1) 
INSERT INTO _CharSkill VALUES (@CharID,8133,1) 
INSERT INTO _CharSkill VALUES (@CharID,8142,1) 
INSERT INTO _CharSkill VALUES (@CharID,8150,1) 
INSERT INTO _CharSkill VALUES (@CharID,8164,1) 
INSERT INTO _CharSkill VALUES (@CharID,8171,1) 
INSERT INTO _CharSkill VALUES (@CharID,8183,1) 
INSERT INTO _CharSkill VALUES (@CharID,8195,1) 
INSERT INTO _CharSkill VALUES (@CharID,8204,1) 
INSERT INTO _CharSkill VALUES (@CharID,8214,1) 
INSERT INTO _CharSkill VALUES (@CharID,8220,1) 
INSERT INTO _CharSkill VALUES (@CharID,8221,1) 
INSERT INTO _CharSkill VALUES (@CharID,8238,1) 
INSERT INTO _CharSkill VALUES (@CharID,8239,1) 
INSERT INTO _CharSkill VALUES (@CharID,8250,1) 
INSERT INTO _CharSkill VALUES (@CharID,8253,1) 
INSERT INTO _CharSkill VALUES (@CharID,8276,1) 
INSERT INTO _CharSkill VALUES (@CharID,8291,1) 
INSERT INTO _CharSkill VALUES (@CharID,8304,1) 
INSERT INTO _CharSkill VALUES (@CharID,8316,1) 
INSERT INTO _CharSkill VALUES (@CharID,8320,1) 
INSERT INTO _CharSkill VALUES (@CharID,8338,1) 
INSERT INTO _CharSkill VALUES (@CharID,8347,1) 
INSERT INTO _CharSkill VALUES (@CharID,8348,1) 
INSERT INTO _CharSkill VALUES (@CharID,8361,1) 
INSERT INTO _CharSkill VALUES (@CharID,8370,1) 
INSERT INTO _CharSkill VALUES (@CharID,8379,1) 
INSERT INTO _CharSkill VALUES (@CharID,8383,1) 
INSERT INTO _CharSkill VALUES (@CharID,8390,1) 
INSERT INTO _CharSkill VALUES (@CharID,8399,1) 
INSERT INTO _CharSkill VALUES (@CharID,8405,1) 
INSERT INTO _CharSkill VALUES (@CharID,8410,1) 
INSERT INTO _CharSkill VALUES (@CharID,8414,1) 
INSERT INTO _CharSkill VALUES (@CharID,8416,1) 
INSERT INTO _CharSkill VALUES (@CharID,20494,1) 
INSERT INTO _CharSkill VALUES (@CharID,20497,1) 
INSERT INTO _CharSkill VALUES (@CharID,20500,1) 
INSERT INTO _CharSkill VALUES (@CharID,21215,1) 
INSERT INTO _CharSkill VALUES (@CharID,21217,1) 
INSERT INTO _CharSkill VALUES (@CharID,30578,1) 
INSERT INTO _CharSkill VALUES (@CharID,30584,1) 
INSERT INTO _CharSkill VALUES (@CharID,30590,1) 
INSERT INTO _CharSkill VALUES (@CharID,30596,1) 
INSERT INTO _CharSkill VALUES (@CharID,30600,1)


UZrGdab.gif



To Stop PK For Ever
PHP:
SRO_VT_SHARDLOG << Programmability << Stored Procedures << _AddLogChar 
-------------------------------------------- 
IF (@EventID = 6 or @EventID = 9 or @EventID = 20 or @EventID = 11 or @EventID = 4) ---Made By #Xan 
Update SRO_VT_SHARD.dbo._Char Set DailyPK = 50 where CharID = @CharID


Query Trade Item
PHP:
UPDATE _RefObjCommon  
SET CanTrade = 0  
WHERE Codename128 ='ITEM_MALL_GLOBAL_CHATTING'

UZrGdab.gif


Query Remove PK By Char Name
PHP:
USE [SRO_VT_SHARD] 
DECLARE @CharName Varchar(max) 
SET  @CharName = 'Kira' 

UPDATE _Char SET 
RemainHwanCount = 5, 
DailyPK= 0, 
TotalPK= 0, 
PKPenaltyPoint= 0 
WHERE CharName16 = @CharName



UZrGdab.gif


Query To Banned Account By CharName
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 
-----------------------------------------------------------------


UZrGdab.gif


Query UnBan 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] 
-------------------------------- 
DELETE FROM [dbo].[_BlockedUser] 
WHERE UserJID = @AccJID 
DELETE FROM [dbo].[_Punishment] 
WHERE UserJID = @AccJID 

----------------------------------------------------------------- 
SELECT StrUserID FROM TB_User WHERE JID = @AccJID 
-----------------------------------------------------------------


UZrGdab.gif



Query Change SQL Password
PHP:
USE [master]  

GO  
/******** By Yui ********/  
ALTER LOGIN [sa] WITH PASSWORD=N'New Password', DEFAULT_DATABASE=[master], DEFAULT_LANGUAGE=[us_english], CHECK_EXPIRATION=OFF, CHECK_POLICY=OFF  

GO


UZrGdab.gif



Query Add New Spot For Unique
PHP:
USE SRO_VT_SHARD /* Add Unique Spot By ™BaZzZoKa™ */  
Go  
DECLARE @UNIQUE VARCHAR (129)  
DECLARE @CHARNAME VARCHAR (64)  
DECLARE @mindealy INT  
DECLARE @maxdelay int  
DECLARE @INITRADIUS INT  
DECLARE @RADIUS int  
DECLARE @MAXNEST int = (SELECT MAX (dwNestID) FROM Tab_RefNest)+1  
DECLARE @MAXHIVE int = (SELECT MAX (dwHiveID) FROM Tab_RefHive)+1  
DECLARE @MAXTACTICS int = (SELECT MAX (dwTacticsID) FROM Tab_RefTactics)+1  

/* put your settings here */  
SET @UNIQUE = 'MOB_JUPITER_YUNO' -- Unique code name from _RefobjCommon table  
SET @CHARNAME = 'CHARNAME' -- Character name from _Char table to get mob position X Y Z  
SET @mindealy = 60  -- Minimum time before appears in seconds  
SET @maxdelay = 120  -- Maximum time before appears in seconds  
SET @INITRADIUS = 100  -- Radius around spot unique can generated at  
SET @RADIUS = 500  -- Radius around spot Unique can move in  
/* end of settings area */  

/* get ID of mob by code name */  
Declare @MOBID int SET @MOBID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @UNIQUE)  

SET IDENTITY_INSERT Tab_RefTactics ON  
INSERT INTO Tab_RefTactics (dwTacticsID,dwObjID,btAIQoS,nMaxStamina,btMaxStaminaVariance,nSightRange,btAggressType,AggressData,btChangeTarget,btHelpRequestTo,btHelpResponseTo,btBattleStyle,BattleStyleData,btDiversionBasis,DiversionBasisData1,DiversionBasisData2,DiversionBasisData3,DiversionBasisData4,DiversionBasisData5,DiversionBasisData6,DiversionBasisData7,DiversionBasisData8,btDiversionKeepBasis,DiversionKeepBasisData1,DiversionKeepBasisData2,DiversionKeepBasisData3,DiversionKeepBasisData4,DiversionKeepBasisData5,DiversionKeepBasisData6,DiversionKeepBasisData7,DiversionKeepBasisData8,btKeepDistance,KeepDistanceData,btTraceType,btTraceBoundary,TraceData,btHomingType,HomingData,btAggressTypeOnHoming,btFleeType,dwChampionTacticsID,AdditionOptionFlag,szDescString128) VALUES  
(@MAXTACTICS,@MOBID,0,500,50,200,0,0,2,2,2,0,0,5,0,0,0,0,0,30,0,0,4,0,0,0,0,0,0,0,0,0,0,0,1,500,0,0,2,0,0,112,@UNIQUE)  
SET IDENTITY_INSERT Tab_RefTactics OFF  

SET IDENTITY_INSERT Tab_RefHive ON  
INSERT INTO Tab_RefHive (dwHiveID,btKeepMonsterCountType,dwOverwriteMaxTotalCount,fMonsterCountPerPC,dwSpawnSpeedIncreaseRate,dwMaxIncreaseRate,btFlag,GameWorldID,HatchObjType,szDescString128) VALUES  
(@MAXHIVE,0,1,0,0,0,0,1,1,@UNIQUE)  
SET IDENTITY_INSERT Tab_RefHive OFF  

/* get position coordinates of your character */  

DECLARE @REGION INT SET @REGION = (SELECT (LatestRegion) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSX INT SET @POSX = (SELECT (POSX) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSY INT SET @POSY = (SELECT (POSY) FROM _Char WHERE CharName16 = @CHARNAME)  
DECLARE @POSZ INT SET @POSZ = (SELECT (POSZ) FROM _Char WHERE CharName16 = @CHARNAME)  

SET IDENTITY_INSERT Tab_RefNest ON  
INSERT INTO Tab_RefNest (dwNestID,dwHiveID,dwTacticsID,nRegionDBID,fLocalPosX,fLocalPosY,fLocalPosZ,wInitialDir,nRadius,nGenerateRadius,nChampionGenPercentage,dwDelayTimeMin,dwDelayTimeMax,dwMaxTotalCount,btFlag,btRespawn,btType) VALUES  
(@MAXNEST,@MAXHIVE,@MAXTACTICS,@REGION,@POSX,@POSY,@POSZ,0,@RADIUS,@INITRADIUS,0,@mindealy,@maxdelay,1,0,1,0)  
SET IDENTITY_INSERT Tab_RefNest OFF  


print ''  
print ''  
print 'Done!'

UZrGdab.gif



Query To Close Item In Npc
PHP:
UPDATE [dbo].[_RefShopGoods] 
 SET Service = 1 
 WHERE RefPackageItemCodeName like 'PACKAGE_ITEM_ETC_ARCHEMY_REINFORCE_PROB_UP_A_14'

UZrGdab.gif



How to Make Devil Full Blue
PHP:
Put the Devil Sprit to charecter's bag and open SMC > SR_UserEdit > CharItem > Type the name of the character make a call. Later, search charecter bag and find the array of Devil Spirit item ID. Then use the following query. 




Query : USE SRO_VT_SHARD 
UPDATE dbo._Items set MagParamNum='5',MagParam1='30064771144',MagParam2= '30064771150',MagParam3='5583457484950',MagParam4= '5583457484962',MagParam5='257698037898'WHERE ID64='HereITEMID'


UZrGdab.gif


Query Change Name By Old Name xD
PHP:
USE SRO_VT_SHARD  
GO 
Update _Char 
set CharName16 = 'New Name' 
where CharName16 = 'Old Name'


UZrGdab.gif


Add Drob in Unique
PHP:
USE(SRO_VT_SHARD_INIT) 
GO() 

DECLARE @MonsterID int 
DECLARE @ItemID int 
DECLARE @DropRatio real 



SET @MonsterID = 24160 -- You can find Monster ID's at RefObjCommon 
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5 / 0% = 0 of course 
SET @ItemID = 35773 -- You can find Item ID's at RefObjCommon 


INSERT(_RefMonster_AssignedItemDrop) 
( 
RefMonsterID, 
RefItemID, 
DropGroupType, 
OptLevel, 
DropAmountMin, 
DropAmountMax, 
DropRatio, 
RefMagicOptionID1, 
CustomValue1, 
RefMagicOptionID2, 
CustomValue2, 
RefMagicOptionID3, 
CustomValue3, 
RefMagicOptionID4, 
CustomValue4, 
RefMagicOptionID5, 
CustomValue5, 
RefMagicOptionID6, 
CustomValue6, 
RefMagicOptionID7, 
CustomValue7, 
RefMagicOptionID8, 
CustomValue8, 
RefMagicOptionID9, 
CustomValue9, 
RentCodeName() 
)  
VALUES(@MonsterID ,   @ItemID, 0,          0,        1,             1,             @DropRatio,           0,                 0,           0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0,                 0,            0 ,                0 ,           'xxx')



UZrGdab.gif


Query PLVL CHar
PHP:
USE [SRO_VT_SHARD] 
Declare @CharName VarChar(max) 
Declare @Level BigInt 
SET @CharName=        '’Marwan Abbas'  --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


UZrGdab.gif


Query Add Item In Npc
PHP:
USE SRO_VT_SHARD /* ITEMS TO NPC FOR GOLD by Caipi */  
Declare @ItemID int  
Declare @yourPrice int  
Declare @WhichTAB varchar(74)  



SET @ItemID = 23                            /* The Item ID of the Item you want to add to the NPC*/ --## <--  
SET @yourPrice = 5000                        /* The price per Unit */ --## <--  
SET @WhichTAB = 'STORE_CH_POTION_TAB1'        /* To which Tab at which NPC you want to add the Item*/  



/* Codename instead of the ID */   
Declare @CodeName varchar (74) SET @CodeName = (SELECT CodeName128 FROM _RefObjCommon WHERE ID = @ItemID)  

/* Which Itemdata.txt is affected in the Media.pk2*/  
Declare @newItemID varchar(5)  
Declare @lastPrice varchar(25) SET @lastPrice = (SELECT Price FROM _RefObjCommon WHERE ID = @ItemID)  
Declare @yourPriceCHAR varchar(25) SET @yourPriceCHAR = @yourPrice  
IF (@ItemID < 5000) SET @newItemID = 5000  
else if (@ItemID < 10000) SET @newItemID = 10000  
else if (@ItemID < 15000) SET @newItemID = 15000  
else if (@ItemID < 20000) SET @newItemID = 20000  
else if (@ItemID < 25000) SET @newItemID = 25000  
else if (@ItemID < 30000) SET @newItemID = 30000  
else if (@ItemID < 35000) SET @newItemID = 35000  
else if (@ItemID < 40000) SET @newItemID = 40000  
else SET @newItemID = 45000  
print ''  
print @CodeName + ' from Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'  
print 'Change the current Price of '+@lastPrice+' to '+@yourPriceCHAR+' at the itemdata_'+@newItemID+'. (For the visual Price ingame)'  
/*END which Itemdata.txr*/  

/*for _RefObjCommon Price*/  
UPDATE _RefObjCommon SET Price = @yourPrice WHERE ID = @ItemID  

/* for _RefPackageItem */  
IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName)  
    BEGIN  
        print 'Already added @ RefPackageItem/.txt!'  
    END  
ELSE BEGIN  
Declare @SN varchar(74) SET @SN = (SELECT NameStrID128 FROM _RefObjCommon WHERE ID = @ItemID)  
Declare @DESC varchar(74) SET @Desc = (SELECT DescStrID128 FROM _RefObjCommon WHERE ID = @ItemID)  
Declare @DDJ varchar(74) SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID = @ItemID)  
INSERT INTO _RefPackageItem (Service,Country,CodeName128,SaleTag,ExpandTerm,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)   
VALUES (1,15,'PACKAGE_'+@CodeName,0,'EXPAND_TERM_ALL',@SN,@Desc,@DDJ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')  
Declare @TOPID varchar (10) SET @TOPID = (SELECT MAX(ID) FROM _RefPackageItem)  
print ''  
print 'Add the following line @ refpackageitem.txt'  
print '1    15    '+@TOPID+'    PACKAGE_'+@CodeName+'    0    EXPAND_TERM_ALL    '+@SN+'    '+@DESC+'    '+@DDJ+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'  
print ''  
END  

/* for _RefPricePolicyOfItem */  
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 1 AND Cost = @yourPrice)  
    BEGIN  
        print 'Already added @ RefPricePolicyOfItem/.txt!'  
    END  
ELSE BEGIN  
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)  
VALUES (1,15,'PACKAGE_'+@CodeName,1,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')  
Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice  
print ''  
print 'Add the following line @ refpricepolicyofitem.txt'  
print '1    15    PACKAGE_'+@CodeName+'    1    0    '+@NEWPRICE+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'  
print ''  
END  

/* for _RefShopGoods */  
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefTabCodeName = @WhichTAB)  
    BEGIN  
        print 'Already added @ RefShopGoods/.txt!'  
    END  
ELSE BEGIN  
Declare @newSLOTINDEX varchar(15) SET @newSLOTINDEX = (SELECT MAX(SlotIndex) FROM _RefShopGoods WHERE RefTabCodeName = @WhichTAB)+1  
INSERT INTO _RefShopGoods (Service,Country,RefTabCodeName,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)  
VALUES (1,15,@WhichTAB,'PACKAGE_'+@CodeName,@newSLOTINDEX,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')  
print ''  
print 'Add the following line @ refshopgoods.txt'  
print '1    15    '+@WhichTAB+'    '+'PACKAGE_'+@CodeName+'    '+@newSLOTINDEX+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'  
print ''  
END  

/* for _RefScrapOfPackageItem */  
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefItemCodeName = @CodeName)  
    BEGIN  
        print 'Already added @ RefScrapOfPackageItem/.txt!'  
    END  
ELSE BEGIN  
INSERT INTO _RefScrapOfPackageItem (Service,Country,RefPackageItemCodeName,RefItemCodeName,OptLevel,Variance,Data,MagParamNum,MagParam1,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6,MagParam7,MagParam8,MagParam9,MagParam10,MagParam11,MagParam12,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)  
VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')  
Declare @ScrapIndex varchar(15)  
SET @ScrapIndex = (SELECT MAX([Index]) FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)  
print ''  
print 'Add the following line @ refscrapofpackageitem.txt'  
print '1    15    '+'PACKAGE_'+@CodeName+'    '+@CodeName+'    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@ScrapIndex  
print ''  
END  
print ''  
print ''  
print 'Done!'


UZrGdab.gif



علشان تعرف كا واحد full console
PHP:
USE SRO_VT_ACCOUNT 
/*****Yui4host ** Skype (valikiemagic)***/ 
SELECT *FROM [dbo].[TB_User] 
WHERE sec_primary BETWEEN '1' and '1'



UZrGdab.gif


Query Recall All Players To JANGAN
PHP:
USE [SRO_VT_SHARD] 
UPDATE _Char SET LatestRegion= 25000, posX= 982 , posY= -0.421872 ,posZ= 140 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0,  
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0

:emoji11:
الموضوع متجدد
كلمه حلوا بقا

 




BuiLt4KiLl

عضو
9 فبراير 2017
24
6
0
1
Kuwait

المستوي:

رد: Useful Queries Make you life Easier

تمت الموافقة
طبعاً مواضيع الـQuery مبتخلصش
بس الله ينور
في مجموعة Queries مش موجودة في المواضيع التانية
:emoji13: :emoji13:
 




التعديل الأخير:

SubZero*

عضو
2 فبراير 2017
98
1
0
16
Egypt

المستوي:

رد: Useful Queries Make you life Easier

تمت الموافقة
طبعا{ مواضيع الـQuery مبتخلصش
بس الله ينور
في مجموعة Queries مش موجودة قي المواضيع التانية
:emoji13: :emoji13:

شكرا فى كيرهات مش موجودا :emoji11: