|
You last visited: Today at 05:54
Advertisement
[ Contribution ] Codes VSRO Files
Discussion on [ Contribution ] Codes VSRO Files within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
11/30/2011, 16:02
|
#1
|
elite*gold: 0
Join Date: Nov 2011
Posts: 173
Received Thanks: 139
|
[ Contribution ] Add D12/RARE/JID Start " 1 "/Recall Jangan/Rate Item/Quest Begginer
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
|
|
|
11/30/2011, 19:58
|
#2
|
elite*gold: 10
Join Date: Oct 2008
Posts: 1,938
Received Thanks: 947
|
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
|
#3
|
elite*gold: 0
Join Date: Nov 2010
Posts: 90
Received Thanks: 18
|
thank you
|
|
|
12/01/2011, 17:35
|
#4
|
elite*gold: 0
Join Date: Nov 2011
Posts: 173
Received Thanks: 139
|
Thanks to you
|
|
|
12/03/2011, 13:43
|
#5
|
elite*gold: 0
Join Date: Nov 2011
Posts: 173
Received Thanks: 139
|
My Server PlayCreeDSRO By Hamachi
Hamachi Web
ID Hamachi:
PlayCreeDSRO
PlayCreeDSRO1
PlayCreeDSRO2
PlayCreeDSRO3
PlayCreeDSRO4
PlayCreeDSRO5
PlayCreeDSRO6
PlayCreeDSRO7
PlayCreeDSRO8
PlayCreeDSRO9
PlayCreeDSRO10
Pasword : 1
|
|
|
12/04/2011, 00:24
|
#6
|
elite*gold: 0
Join Date: Nov 2011
Posts: 93
Received Thanks: 16
|
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.
|
|
|
12/04/2011, 17:03
|
#7
|
elite*gold: 0
Join Date: Nov 2011
Posts: 173
Received Thanks: 139
|
Quote:
Originally Posted by Avalance Danger
Copy Paste from RZ forums.
|
NOOB Look Name PlayCreeDSRO Lol is me.
|
|
|
12/05/2011, 23:31
|
#8
|
elite*gold: 0
Join Date: Sep 2011
Posts: 21
Received Thanks: 1
|
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
|
|
|
12/08/2011, 09:24
|
#9
|
elite*gold: 0
Join Date: Oct 2011
Posts: 76
Received Thanks: 3
|
Any help
Any " New Query - SRO_VT_SHARD "
Delete records from _Char Table !!
|
|
|
12/12/2011, 20:02
|
#10
|
elite*gold: 0
Join Date: Nov 2011
Posts: 173
Received Thanks: 139
|
If you read you understand
|
|
|
Similar Threads
|
vsro files vs swsro files
11/27/2011 - SRO Private Server - 17 Replies
so yeah lets make a versus of which ones better or more easier to use.
Ps:NO FUCKING FLAMING!!!
Ps2:if its something else then explain what it is.
|
Vsro GM Command Codes?
11/08/2011 - SRO Private Server - 0 Replies
Is there someone who can give me the GM Codes on running Vsro Files? even though i have some i dont have all of them, Help would be appreciated thx.
|
help vsro files
10/14/2011 - SRO Private Server - 0 Replies
Please help me with vsro files servers, the computer can not connect with the team vier Have someone to help
|
About Vsro Files ... !!
09/13/2011 - SRO Private Server - 5 Replies
hi Guy's without insulting ...
I restored the Database ...etc
But I want to know How to Config the Database to make the SR_GameServer
and all .exe read it .. ? :handsdown::handsdown:
|
All times are GMT +2. The time now is 05:54.
|
|