[VsroFiles] FAQ + Tutorials thread for your server
Discussion on [VsroFiles] FAQ + Tutorials thread for your server within the SRO PServer Guides & Releases forum part of the SRO Private Server category.
[VsroFiles] FAQ + Tutorials thread for your server
Hello guys
I will share some tutorials that will help you if you have a vsro server
Lets start
-----------------------------------------------------------------------
Go to sro_vt_shard -- > Open table RefObjItem
We need ID's from 2033 to 2044
Ok scroll to right what we need is Param2,Param3,Param4
Like if we want to make 2x
We use this formula : Param2 = Param2 * 2
So we open calculate and we do *2 to the currently number that we have in Param2
And put new number on
Then we do the same to param3 and param4
Then Excute
First go to refobjcommon
Find the item you want to change maxstack
Like you want for elixirs
PHP Code:
ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B
You scroll and check the "Link" For it.
For example this item have link : 2029
then go to refobitem and look for 2029, You will see a row Called 'MaxStack'
Change it
then go to media.pk2
Then look for itemdata_xx
Search for this "ITEM_ETC_ARCHEMY_REINFORCE_RECIPE_WEAPON_B".
And change the number that exist after the xx xx and change it same to db
Example
Go to sro_vt_shard.
Programmability
Stored Procedures
Then click modify at _AddNewChar
Look at @StartPos_X
@StartPos_Y
@StartPos_Z
And change them
You can get the coords you want from your main account
Just login in ur main and stay on place you want
then go to sro_vt_shard tables
_Char table.Click open table
Look for PosX,PosY,PosZ And copy them to there
Go to sro_vt_shard
Search for "_RefDropClassSel_RareEquip" Table
Click open table
And there you see 10 is default mean = 1x
change to 15 if you want 1.5x and so on
USE [SRO_VT_SHARD_INIT]
GO
--by Saif1999
Declare @CharName Varchar (64)
Set @CharName = 'Put your char name here'
UPDATE dbo._Char
--change 100 to the level of your char you want
SET CurLevel= 100
SET MaxLevel = 100
WHERE CharID = (SELECT CharID FROM [dbo].[_Char] WHERE CharName16 = @CharName)
USE [SRO_VT_ACCOUNT]
GO
/****** Object: Table [dbo].[_PrivilegedIP] Script Date: 09/13/2011 08:35:06 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
DROP TABLE _PrivilegedIP
GO
CREATE TABLE [dbo].[_PrivilegedIP](
[IP1] [tinyint] NOT NULL,
[IP2] [tinyint] NOT NULL,
[IP3] [tinyint] NOT NULL,
[IP4] [tinyint] NOT NULL,
[IP5] [tinyint] NOT NULL,
[IP6] [tinyint] NOT NULL,
[IP7] [tinyint] NOT NULL,
[IP8] [tinyint] NOT NULL
) ON [PRIMARY]
GO
DECLARE @MonsterID int
DECLARE @ItemID int
DECLARE @DropRatio real
SET @MonsterID = [Desired Monster ID] -- Check RefObjCommon to find the desired ID
SET @DropRatio = 0.5 -- 100% = 1 / 50% = 0.5
SET @ItemID = [Desired Item ID] -- Check RefObjCommon to find the desired item ID
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER ON
GO
declare @COS_ID int
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
declare @MaxInventorySize tinyint
select @MaxInventorySize = InventorySize
from _RefObjCommon, _RefObjChar
where _RefObjCommon.ID = @RefObjID and _RefObjCommon.Link = _RefObjChar.ID
if( @@rowcount = 0 or @MaxInventorySize < @InventorySize )
begin
rollback tran
return -5
end
insert into _CharCOS values (@OwnerCharID, @RefObjID, @HP, @MP, @KeeperNPC, @State, NULL, @Level, 0, @HGP, @PickItemConfig, @RentEndTime)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
set @COS_ID = @@identity
if (@COS_ID = 0 OR @@error <> 0)
begin
rollback tran
return -1
end
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
if (@MaxInventorySize > 0)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
declare @Slot int
set @Slot = 0
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
-- pet_skill_item (ÃÖ¼±È£)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
while (@Slot < @MaxInventorySize)
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
--@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
begin
insert into _InvCOS values(@COS_ID, @Slot, 0)
if (@@error <> 0)
begin
-- Àκ¥Å丮 »ý¼º ½ÇÆÐ!
rollback tran
return -2
end
set @Slot = @Slot + 1
end
end
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù!
UPDATE _Char SET EngagedCOS = @COS_ID WHERE CharID = @OwnerCharID
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
BEGIN
ROLLBACK TRANSACTION
RETURN -3
END
*/
if( @itemID <> 0 )
begin
update _Items set Data = @COS_ID where ID64 = @itemID
if( @@error <> 0 or @@rowcount = 0 )
begin
rollback transaction
return -4
end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
declare @Serial64 bigint
select @Serial64 = Serial64 from _Items where Data = @COS_ID
exec _AddTimedJobForPet @COS_ID,5,22926,1992999999,1111708465,1,112,0,0,0, 0,0,@Serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
end
commit tran
return @COS_ID
More comming soon + Will add more photos
Stay tuned
i have done the max stack mod and it works the elixirs all stack up to quantity 100 although for some reason there isn't the little white number in the top left corner of the icon for the elixir
i have done the max stack mod and it works the elixirs all stack up to quantity 100 although for some reason there isn't the little white number in the top left corner of the icon for the elixir
[VSROFiles]SMCproblem 12/02/2011 - SRO Private Server - 2 Replies i change the ip but what about user and password
http://img600.imageshack.us/img600/6557/qwrtqwtqw t.png
Uploaded with ImageShack.us
any asnwer?
???????????????????????
VSROFiles[Error 11/28/2011 - SRO Private Server - 3 Replies what this error guys :(
http://img100.imageshack.us/img100/7837/whyyyyyy. png
Uploaded with ImageShack.us
Any Answer's ?
RegWeb for Vsrofiles 11/11/2011 - SRO Private Server - 0 Replies Hi! i need an simple regweb :P only id and pw for register I dont need more please any help¿?