[ Contribution ] Codes VSRO Files

11/30/2011 16:02 PlayCreedSRO#1
Leave them some codes that are that can serve them something...



Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12 [Only registered and activated users can see links. Click Here To Register...]

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

Added Code " New Query - SRO_VT_ACCOUNT "
Delete records from accounts to start from 0 the JID and not 2000

Code:
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
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_SilkGoods]
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_paygate_trans]
Code:
[URL=http://imageshack.us/photo/my-images/46/97419886.png/][IMG]http://img46.imageshack.us/img46/4714/97419886.png[/IMG][/URL]
------------------------------------------------------------------------------------------------------------------------------------------------------

Drop Item Rare Added " New Query - SRO_VT_SHARD "

Code:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE

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


Recall All Users To Jangan " New Query - SRO_VT_SHARD "

Code:
USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25254, posX= 1600.34668 , posY= -3.232344 ,posZ= 185.784119 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
------------------------------------------------------------------------------------------------------------------------------------------------------

Rate Item " New Query - SRO_VT_SHARD "

Code:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '3000', '6000')
WHERE Ratio LIKE '3000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2400', '4800')
WHERE Ratio LIKE '2400%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2100', '4200')
WHERE Ratio LIKE '2100%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1500', '3000')
WHERE Ratio LIKE '1500%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1200', '2400')
WHERE Ratio LIKE '1200%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1000', '2000')
WHERE Ratio LIKE '1000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '250', '500')
WHERE Ratio LIKE '250%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '25', '50')
WHERE Ratio LIKE '25%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '16', '32')
WHERE Ratio LIKE '16%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '8', '16')
WHERE Ratio LIKE '8%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '5', '10')
WHERE Ratio LIKE '5%';

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


Quest Begginer " SRO_VT_SHARD - _RefCharDefault_Quest "

List of items that each depending on the lvl

Code:
lv1 Weapon SoS 
lv5 Mov Speed Scroll 100%
lv8 Weapon SoS
lv10 Exp Scroll 100%
lv16 Weapon SoS
lv20 Exp Scroll 100%
lv24 Weapon SoS
lv 30 Exp scroll 150%
lv32 Weapon Sos
lv40 Exp Scroll 150%
lv42 Weapon SoS
lv50 Exp Scroll 150%
lv60 Exp Scroll 150%.
To disable only has that you change the 1 to 0

Code:
1	1	3	QEV_ALL_BASIC_1		5
1	2	3	QEV_ALL_BASIC_2		8
1	3	3	QEV_ALL_BASIC_3		10
1	4	3	QEV_ALL_BASIC_4		16
1	5	3	QEV_ALL_BASIC_5		20
1	6	3	QEV_ALL_BASIC_6		24
1	7	3	QEV_ALL_BASIC_7		30
1	8	3	QEV_ALL_BASIC_8		32
1	9	3	QEV_ALL_BASIC_9		40
1	10	3	QEV_ALL_BASIC_10	42
1	11	3	QEV_ALL_BASIC_11	50
1	12	3	QEV_ALL_BASIC_12	60
1	13	3	QEV_ALL_BASIC_0		1
Give Me Thanks +1 :)
11/30/2011 19:58 kebabas1600#2
better post all 12d DB with fixed immo/astral stones in mall and 12d droops items stones then it will be useful but not not rly i think
11/30/2011 23:16 Ehab almsry#3
thank you
12/01/2011 17:35 PlayCreedSRO#4
Thanks to you
12/03/2011 13:43 PlayCreedSRO#5
My Server PlayCreeDSRO By Hamachi


[Only registered and activated users can see links. Click Here To Register...]

Hamachi Web [Only registered and activated users can see links. Click Here To Register...]


ID Hamachi:


PlayCreeDSRO
PlayCreeDSRO1
PlayCreeDSRO2
PlayCreeDSRO3
PlayCreeDSRO4
PlayCreeDSRO5
PlayCreeDSRO6
PlayCreeDSRO7
PlayCreeDSRO8
PlayCreeDSRO9
PlayCreeDSRO10

Pasword : 1
12/04/2011 00:24 Avalance Danger#6
Quote:
Originally Posted by PlayCreedSRO View Post
Leave them some codes that are that can serve them something...



Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12 [Only registered and activated users can see links. Click Here To Register...]

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

Added Code " New Query - SRO_VT_ACCOUNT "
Delete records from accounts to start from 0 the JID and not 2000

Code:
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
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_SilkGoods]
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_paygate_trans]
Code:
[URL=http://imageshack.us/photo/my-images/46/97419886.png/][IMG]http://img46.imageshack.us/img46/4714/97419886.png[/IMG][/URL]
------------------------------------------------------------------------------------------------------------------------------------------------------

Drop Item Rare Added " New Query - SRO_VT_SHARD "

Code:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE

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


Recall All Users To Jangan " New Query - SRO_VT_SHARD "

Code:
USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25254, posX= 1600.34668 , posY= -3.232344 ,posZ= 185.784119 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
------------------------------------------------------------------------------------------------------------------------------------------------------

Rate Item " New Query - SRO_VT_SHARD "

Code:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '3000', '6000')
WHERE Ratio LIKE '3000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2400', '4800')
WHERE Ratio LIKE '2400%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2100', '4200')
WHERE Ratio LIKE '2100%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1500', '3000')
WHERE Ratio LIKE '1500%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1200', '2400')
WHERE Ratio LIKE '1200%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1000', '2000')
WHERE Ratio LIKE '1000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '250', '500')
WHERE Ratio LIKE '250%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '25', '50')
WHERE Ratio LIKE '25%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '16', '32')
WHERE Ratio LIKE '16%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '8', '16')
WHERE Ratio LIKE '8%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '5', '10')
WHERE Ratio LIKE '5%';

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


Quest Begginer " SRO_VT_SHARD - _RefCharDefault_Quest "

List of items that each depending on the lvl

Code:
lv1 Weapon SoS 
lv5 Mov Speed Scroll 100%
lv8 Weapon SoS
lv10 Exp Scroll 100%
lv16 Weapon SoS
lv20 Exp Scroll 100%
lv24 Weapon SoS
lv 30 Exp scroll 150%
lv32 Weapon Sos
lv40 Exp Scroll 150%
lv42 Weapon SoS
lv50 Exp Scroll 150%
lv60 Exp Scroll 150%.
To disable only has that you change the 1 to 0

Code:
1	1	3	QEV_ALL_BASIC_1		5
1	2	3	QEV_ALL_BASIC_2		8
1	3	3	QEV_ALL_BASIC_3		10
1	4	3	QEV_ALL_BASIC_4		16
1	5	3	QEV_ALL_BASIC_5		20
1	6	3	QEV_ALL_BASIC_6		24
1	7	3	QEV_ALL_BASIC_7		30
1	8	3	QEV_ALL_BASIC_8		32
1	9	3	QEV_ALL_BASIC_9		40
1	10	3	QEV_ALL_BASIC_10	42
1	11	3	QEV_ALL_BASIC_11	50
1	12	3	QEV_ALL_BASIC_12	60
1	13	3	QEV_ALL_BASIC_0		1
Give Me Thanks +1 :)
Copy Paste from RZ forums.
12/04/2011 17:03 PlayCreedSRO#7
Quote:
Originally Posted by Avalance Danger View Post
Copy Paste from RZ forums.
NOOB :mad: Look Name PlayCreeDSRO Lol is me. :handsdown:
12/05/2011 23:31 Kosaa#8
Quote:
Originally Posted by PlayCreedSRO View Post
Leave them some codes that are that can serve them something...



Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12 [Only registered and activated users can see links. Click Here To Register...]

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

Added Code " New Query - SRO_VT_ACCOUNT "
Delete records from accounts to start from 0 the JID and not 2000

Code:
USE [SRO_VT_ACCOUNT]
GO
TRUNCATE TABLE [dbo].[TB_User]
TRUNCATE TABLE [dbo].[TB_User_Bak]
TRUNCATE TABLE [dbo].[SK_CharRenameLog]
TRUNCATE TABLE [dbo].[_Punishment]
TRUNCATE TABLE [dbo].[_ServiceManagerLog]
TRUNCATE TABLE [dbo].[Test_HN]
TRUNCATE TABLE [dbo].[_BlockedUser]
TRUNCATE TABLE [dbo].[_CasGMChatLog]
TRUNCATE TABLE [dbo].[_Notice]
TRUNCATE TABLE [dbo].[_SMCLog]
TRUNCATE TABLE [dbo].[QuaySoEpoint]
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_SilkGoods]
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_paygate_trans]
Code:
[URL=http://imageshack.us/photo/my-images/46/97419886.png/][IMG]http://img46.imageshack.us/img46/4714/97419886.png[/IMG][/URL]
------------------------------------------------------------------------------------------------------------------------------------------------------

Drop Item Rare Added " New Query - SRO_VT_SHARD "

Code:
USE SRO_VT_SHARD
DECLARE @RATE INT
SET @RATE = 10 
update _RefDropClassSel_RareEquip set ProbGroup1 = ProbGroup1*@RATE
update _RefDropClassSel_RareEquip set ProbGroup2 = ProbGroup2*@RATE
update _RefDropClassSel_RareEquip set ProbGroup3 = ProbGroup3*@RATE
update _RefDropClassSel_RareEquip set ProbGroup4 = ProbGroup4*@RATE
update _RefDropClassSel_RareEquip set ProbGroup5 = ProbGroup5*@RATE
update _RefDropClassSel_RareEquip set ProbGroup6 = ProbGroup6*@RATE
update _RefDropClassSel_RareEquip set ProbGroup7 = ProbGroup7*@RATE
update _RefDropClassSel_RareEquip set ProbGroup8 = ProbGroup8*@RATE
update _RefDropClassSel_RareEquip set ProbGroup9 = ProbGroup9*@RATE
update _RefDropClassSel_RareEquip set ProbGroup10 = ProbGroup10*@RATE
update _RefDropClassSel_RareEquip set ProbGroup11 = ProbGroup11*@RATE
update _RefDropClassSel_RareEquip set ProbGroup12 = ProbGroup12*@RATE
update _RefDropClassSel_RareEquip set ProbGroup13 = ProbGroup13*@RATE
update _RefDropClassSel_RareEquip set ProbGroup14 = ProbGroup14*@RATE
update _RefDropClassSel_RareEquip set ProbGroup15 = ProbGroup15*@RATE
update _RefDropClassSel_RareEquip set ProbGroup16 = ProbGroup16*@RATE
update _RefDropClassSel_RareEquip set ProbGroup17 = ProbGroup17*@RATE
update _RefDropClassSel_RareEquip set ProbGroup18 = ProbGroup18*@RATE
update _RefDropClassSel_RareEquip set ProbGroup19 = ProbGroup19*@RATE
update _RefDropClassSel_RareEquip set ProbGroup20 = ProbGroup20*@RATE
update _RefDropClassSel_RareEquip set ProbGroup21 = ProbGroup21*@RATE
update _RefDropClassSel_RareEquip set ProbGroup22 = ProbGroup22*@RATE
update _RefDropClassSel_RareEquip set ProbGroup23 = ProbGroup23*@RATE
update _RefDropClassSel_RareEquip set ProbGroup24 = ProbGroup24*@RATE
update _RefDropClassSel_RareEquip set ProbGroup25 = ProbGroup25*@RATE
update _RefDropClassSel_RareEquip set ProbGroup26 = ProbGroup26*@RATE
update _RefDropClassSel_RareEquip set ProbGroup27 = ProbGroup27*@RATE
update _RefDropClassSel_RareEquip set ProbGroup28 = ProbGroup28*@RATE
update _RefDropClassSel_RareEquip set ProbGroup29 = ProbGroup29*@RATE
update _RefDropClassSel_RareEquip set ProbGroup30 = ProbGroup30*@RATE
update _RefDropClassSel_RareEquip set ProbGroup31 = ProbGroup31*@RATE

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


Recall All Users To Jangan " New Query - SRO_VT_SHARD "

Code:
USE [SRO_VT_SHARD]
UPDATE _Char SET LatestRegion= 25254, posX= 1600.34668 , posY= -3.232344 ,posZ= 185.784119 ,AppointedTeleport=27754,TelRegion= 0, TelPosX= 0, TelPosY= 0, TelPosZ= 0, 
DiedRegion= 0 ,DiedPosX= 0 ,DiedPosY= 0, DiedPosZ= 0, WorldID= 1 WHERE CharID>= 0
------------------------------------------------------------------------------------------------------------------------------------------------------

Rate Item " New Query - SRO_VT_SHARD "

Code:
USE [SRO_VT_SHARD]
UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '3000', '6000')
WHERE Ratio LIKE '3000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2400', '4800')
WHERE Ratio LIKE '2400%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '2100', '4200')
WHERE Ratio LIKE '2100%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1500', '3000')
WHERE Ratio LIKE '1500%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1200', '2400')
WHERE Ratio LIKE '1200%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '1000', '2000')
WHERE Ratio LIKE '1000%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '250', '500')
WHERE Ratio LIKE '250%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '25', '50')
WHERE Ratio LIKE '25%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '16', '32')
WHERE Ratio LIKE '16%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '8', '16')
WHERE Ratio LIKE '8%';

UPDATE [dbo].[_RefGachaItemSet]
SET Ratio = replace(Ratio, '5', '10')
WHERE Ratio LIKE '5%';

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


Quest Begginer " SRO_VT_SHARD - _RefCharDefault_Quest "

List of items that each depending on the lvl

Code:
lv1 Weapon SoS 
lv5 Mov Speed Scroll 100%
lv8 Weapon SoS
lv10 Exp Scroll 100%
lv16 Weapon SoS
lv20 Exp Scroll 100%
lv24 Weapon SoS
lv 30 Exp scroll 150%
lv32 Weapon Sos
lv40 Exp Scroll 150%
lv42 Weapon SoS
lv50 Exp Scroll 150%
lv60 Exp Scroll 150%.
To disable only has that you change the 1 to 0

Code:
1	1	3	QEV_ALL_BASIC_1		5
1	2	3	QEV_ALL_BASIC_2		8
1	3	3	QEV_ALL_BASIC_3		10
1	4	3	QEV_ALL_BASIC_4		16
1	5	3	QEV_ALL_BASIC_5		20
1	6	3	QEV_ALL_BASIC_6		24
1	7	3	QEV_ALL_BASIC_7		30
1	8	3	QEV_ALL_BASIC_8		32
1	9	3	QEV_ALL_BASIC_9		40
1	10	3	QEV_ALL_BASIC_10	42
1	11	3	QEV_ALL_BASIC_11	50
1	12	3	QEV_ALL_BASIC_12	60
1	13	3	QEV_ALL_BASIC_0		1
Give Me Thanks +1 :)
i admit ... i am a newbie
could you tell me what to do exactly ? o_o
i've downloaded the files ... what am i suppose to do now
12/08/2011 09:24 MR5#9
Any " New Query - SRO_VT_SHARD "
Delete records from _Char Table !!
12/12/2011 20:02 PlayCreedSRO#10
If you read you understand