[ Contribution ] Codes VSRO Files

PlayCreedSRO · 11/30/2011, 16:02

Leave them some codes that are that can serve them something...

Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12

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

kebabas1600 · 11/30/2011, 19:58

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

Ehab almsry · 11/30/2011, 23:16

thank you

PlayCreedSRO · 12/01/2011, 17:35

Thanks to you

PlayCreedSRO · 12/03/2011, 13:43

My Server PlayCreeDSRO By Hamachi

Hamachi Web

ID Hamachi:

PlayCreeDSRO
PlayCreeDSRO1
PlayCreeDSRO2
PlayCreeDSRO3
PlayCreeDSRO4
PlayCreeDSRO5
PlayCreeDSRO6
PlayCreeDSRO7
PlayCreeDSRO8
PlayCreeDSRO9
PlayCreeDSRO10

Pasword : 1

~~Avalance Danger~~ · 12/04/2011, 00:24

Quote:

Originally Posted by PlayCreedSRO

Leave them some codes that are that can serve them something...

Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12

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.

PlayCreedSRO · 12/04/2011, 17:03

Quote:

Originally Posted by Avalance Danger

Copy Paste from RZ forums.

NOOB

Look Name PlayCreeDSRO Lol is me.

Kosaa · 12/05/2011, 23:31

Quote:

Originally Posted by PlayCreedSRO

Leave them some codes that are that can serve them something...

Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12

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

MR5 · 12/08/2011, 09:24

Any " New Query - SRO_VT_SHARD "
Delete records from _Char Table !!

PlayCreedSRO · 12/12/2011, 20:02

If you read you understand