Max Plus

02/28/2017 03:44 revldo1#1
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 Dracula Untold#2
add this code to _AddLogItem Procedure in LOG DB

or


i never used .... but u can try
03/08/2017 00:10 White Ros3#3
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 revldo1#4
up
04/08/2017 08:41 leo2111#5
Yeah, up... @[Only registered and activated users can see links. Click Here To Register...]
03/10/2023 01:34 tiras1102#6
Hello guys,

I changed it as @[Only registered and activated users can see links. Click Here To Register...]3 and @[Only registered and activated users can see links. Click Here To Register...] 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 View Post
Hello guys,

I changed it as @[Only registered and activated users can see links. Click Here To Register...]3 and @[Only registered and activated users can see links. Click Here To Register...] 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.