|
You last visited: Today at 05:23
Advertisement
Max Plus
Discussion on Max Plus within the SRO PServer Questions & Answers forum part of the SRO Private Server category.
02/28/2017, 03:44
|
#1
|
elite*gold: 0
Join Date: Oct 2014
Posts: 212
Received Thanks: 30
|
Max Plus
How I Can Delete Max plus +12 i want open to 250
can't search any query in AddLogChar OR AddLogItem
|
|
|
03/01/2017, 17:16
|
#2
|
elite*gold: 247
Join Date: Feb 2014
Posts: 1,815
Received Thanks: 495
|
add this code to _AddLogItem Procedure in LOG DB
if(@Operation = 90)
begin
declare @ int select @ = OptLevel from SRO_VT_SHARD.._Items Where Serial64 = @ erial if @ >= 12)
begin
update SRO_VT_SHARD.._Items Set OptLevel = '12' Where Serial64 = @ erial
end
end
or
if (@Operation=90)
BEGIN
-- Yui Plus limit --
declare @ us int =17 -- this for max plus you want to limit declare @ us int =16 -- this for back plus limit
UPDATE SRO_VT_SHARD.dbo._items set optlevel = @ us where optlevel >= @ us and serial64 > 0
end
i never used .... but u can try
|
|
|
03/08/2017, 00:10
|
#3
|
elite*gold: 13
Join Date: Nov 2013
Posts: 268
Received Thanks: 192
|
From Procedure AddItemExtern In SRO_VT_SHARD
Go to SRO_VT_SHARD >> Programmability >> StoredProcedures >> _ADD_ITEM_EXTERN
search On
Code:
declare [MENTION=1319586]dur[/MENTION] int
select [MENTION=1319586]dur[/MENTION] = Dur_L from _RefObjItem where ID = [MENTION=298250]link[/MENTION]_to_item
set [MENTION=336745]DaTa[/MENTION] = [MENTION=1319586]dur[/MENTION]
if [MENTION=1489981]opt[/MENTION]_level < 0)
set [MENTION=1489981]opt[/MENTION]_level = 0
else if [MENTION=1489981]opt[/MENTION]_level > 12)
set [MENTION=1489981]opt[/MENTION]_level = 12
Then Change 12 To Ur +++
Then U Can Use This Query To Sent Any Player The Item With The +++ U Want
Code:
USE SRO_VT_SHARD
--Usage:
--exec _ADD_ITEM_EXTERN 'CharName','ItemsCodeName',Count,OptLvl
declare [MENTION=3898309]charname[/MENTION] varchar(64)
set [MENTION=3898309]charname[/MENTION] = 'Name'
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_TSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_TSWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_DAGGER_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_STAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_SHIELD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_SWORD_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_AXE_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_HARP_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_CROSSBOW_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_DARKSTAFF_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_W_HEAVY_11_HA_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_W_HEAVY_11_SA_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_W_HEAVY_11_BA_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_W_HEAVY_11_LA_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_W_HEAVY_11_FA_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_W_HEAVY_11_AA_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_RING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_EARRING_11_A_RARE',1,18
exec _ADD_ITEM_EXTERN [MENTION=3898309]charname[/MENTION],'ITEM_EU_NECKLACE_11_A_RARE',1,18
|
|
|
04/07/2017, 02:05
|
#4
|
elite*gold: 0
Join Date: Oct 2014
Posts: 212
Received Thanks: 30
|
up
|
|
|
04/08/2017, 08:41
|
#5
|
elite*gold: 0
Join Date: Jan 2009
Posts: 944
Received Thanks: 404
|
Yeah, up... @
|
|
|
03/10/2023, 01:34
|
#6
|
elite*gold: 0
Join Date: Jun 2019
Posts: 29
Received Thanks: 0
|
Hello guys,
I changed it as @ 3 and @ discribed and changed the + of the weapon to 249 via SMC. If I login I can see that it was changed to 249 but after relog it is back to +12.
Any idea what wrong?
Thanks for help
Quote:
Originally Posted by tiras1102
Hello guys,
I changed it as @ 3 and @ discribed and changed the + of the weapon to 249 via SMC. If I login I can see that it was changed to 249 but after relog it is back to +12.
Any idea what wrong?
Thanks for help
|
I could fix it. The problem was in the stored procedure for login/logoff event.
|
|
|
All times are GMT +2. The time now is 05:23.
|
|