Register for your free account! | Forgot your password?

You last visited: Today at 23:32

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



[Release] Fix Blackpills on vSRO Files

Discussion on [Release] Fix Blackpills on vSRO Files within the SRO PServer Guides & Releases forum part of the SRO Private Server category.

Reply
 
Old   #1


 
tschulian's Avatar
 
elite*gold: 294
Join Date: Sep 2013
Posts: 1,410
Received Thanks: 635
Post [Release] Fix Blackpills on vSRO Files

Hi,
I know that there are several Tutorials and Guides how to fix the BlackPillBug.
But 99% of them are based on static IDs. I am tired of all those skype pms with "plazt fex blackmbot bugk halp" ö.Ö

I rewrote a small Script (and tested it on vSro v188).

PHP Code:
select ID as ID_ObjCommon,CodeName128,Link 
from SRO_VT_SHARD
.._RefObjCommon 
where CodeName128 like 
'ITEM_ETC_CURE_RANDOM_0%'

/* <-- Remove if you are sure that you'll update the right items!
update SRO_VT_SHARD.._RefObjItem 
    set Param4='21000', 
    Desc4_128='COOLTIME:0x000000C9' 
where ID in 
(select Link from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_ETC_CURE_RANDOM_0%')
--*/

select ID as ID_ObjItem,Param4,Desc4_128 
from SRO_VT_SHARD
.._RefObjItem 
where ID in 
(select Link from SRO_VT_SHARD.._RefObjCommon where CodeName128 like 'ITEM_ETC_CURE_RANDOM_0%'
I commented the Update part to ensure that you first use the select.
Make sure that it looks like this:



Otherwise if there are no Items like "ITEM_ETC_CURE_RANDOM_" in the list, you'll update wrong things and may bug your server.

If you ensured that you'll update the right items remove the /* and have fun.
tschulian is offline  
Old 09/02/2020, 00:32   #2
 
srothanglong's Avatar
 
elite*gold: 0
Join Date: Apr 2019
Posts: 272
Received Thanks: 60
Does this solve the problem
Quote:
USE [SRO_VT_SHARD]
GO

UPDATE _RefObjItem SET Param4='20000', Desc4_128='COOLTIME:0x000000C8'
WHERE ID BETWEEN 5861 and 5864
srothanglong is offline  
Reply


Similar Threads Similar Threads
[Release]VSRO 1.208 Client Compatible for VSRO 1.193 files
09/14/2022 - SRO PServer Guides & Releases - 15 Replies
Hello, I was had a project with synx to login with different clients versions, i was able to make synx login by client V1.208 with his myth online files, but as every one know i have no more interesting in silkroad at all so today im releasing the modified sro_client.exe that will work with V1.208 Client and V1.193 files Note: Download the setup for VSro 1.208 client and replace the sro_client with my one. Bugs: 2nd bar showing symbols Preview: http://i.imgur.com/mIptw.jpg



All times are GMT +1. The time now is 23:32.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.