[CODES SQL] Add D12/RARE/JID Start " 1 "/Recall Jangan/Rate Item/Quest Begginer

[BlackRoseGaming]

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



Added D12 " New Query - SRO_VT_SHARD "

ItemData to add D12 Download

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

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]

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

Drop Item Rare Added " New Query - SRO_VT_SHARD "

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 "

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

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

Rate Item " New Query - SRO_VT_SHARD "

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

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

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

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


This helps to start from lvl 120 with 10m of gold and 357 points of stats and 5m of silk.

To add it.

* SRO_VT_SHARD
* Programmability
* Stored Precedures
* System Stored Precedures
* _AddNewChar


Example

BEGIN TRANSACTION
    
    -- Àδø½Ã½ºÅÛÀÌ Àû¿ëµÇ¸é¼­ ¸¶Áö¸·¿¡ WorldID¿Í 1°ªÀ» ´õ ³Ö¾î ÁÖ¾ú´Ù!      
INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,      
                LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)      
    VALUES (@RefCharID, @CharName, @CharScale, 129, 129, 25000, 983, 0, 32, 2094, 109,      
                GetDate(), 120, 120, 10000000, 357, 5000000, 200,200, 1, 1, 1, 1) 

This is to add items for when creating your character

* SRO_VT_SHARD
* Programmability
* Stored Precedures
* System Stored Precedures
* _AddNewChar

Example



you can get item list it from text of server_dep

   exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_PREMIUM_VIETNAM_GOLDTIME_PLUS',1,1      
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_E060118_100EXP_HELP',1,1      
    exec _ADD_ITEM_EXTERN @CharName,'ITEM_ETC_SCROLL_RETURN_NEWBIE_01',20,1
       exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_RETURN_SCROLL_HIGH_SPEED',10,1   
        exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1 
        exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1 
        exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_FLUTE_WHITE',1,1 
        exec _ADD_ITEM_EXTERN @CharName,'ITEM_COS_P_RABBIT_SCROLL_SILK',1,1   
        exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_DAMAGE_ABS_20P_SCROLL',20,1 
        exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_DAMAGE_INC_20P_SCROLL',20,1 

Give Me Like +1 :)

[MentaL]

[ahmed_ahmed9889]

thx alot

i will test it

but what files in client side i need

like isro files what i got from them

or vsro have all the data?

[BlackRoseGaming]

yeah data.pk2

[BlackRoseGaming]

no fuck problm

[Unrealx420]

no fuck problm

O.o

...?

[Hean]

Beware of the Recalluser Query. It has no correct values for Recallposition. Means if you die, your char is bugged.

[BlackRoseGaming]

Beware of the Recalluser Query. It has no correct values for Recallposition. Means if you die, your char is bugged.

to my it works me perfectly

[Kira]

Any New Query to Delete _Char Table !!

[BlackRoseGaming]

for the moment does not have this code. then update you:

[Caipi]

TRUNCATE TABLE _Char 

[Kira]

TRUNCATE TABLE _Char 

Thak you bro for Answer :)

But Don't work i got this error

Msg 4712, Level 16, State 1, Line 1
Cannot truncate table '_Char' because it is being referenced by a FOREIGN KEY constraint.


i use The Query like this

USE [SRO_VT_SHARD]
GO
TRUNCATE TABLE _Char

[Comandante]

Nice thread and lots of info... Thanks, comrade!

[BlackRoseGaming]

anything not cost anything help or share a bit of information:

[collerok]

UPDATE [Account_DB].[dbo].[TB_User] SET [password]='202cb962ac59075b964b07152d234b70'

turn on ur brain to understand whats it is. btw pass is 123

[BlackRoseGaming]

O.O hhahaha good