[Solved] Max Plus

[revldo1]

How I Can Delete Max plus +12 i want open to 250

can't search any query in AddLogChar OR AddLogItem

[Dracula Untold]

add this code to _AddLogItem Procedure in LOG DB

 Spoiler

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

 Spoiler

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

[White Ros3]

From Procedure AddItemExtern In SRO_VT_SHARD
Go to SRO_VT_SHARD >> Programmability >> StoredProcedures >> _ADD_ITEM_EXTERN
search On

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

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

[revldo1]

up

[leo2111]

Yeah, up... @

[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

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.