Editing items through SMC

[matadoor]

Well i know alot already know that ,, but i searched most of topics and had to figure it out with some hints , so since i had much help in this forum- there will be people still dont know how to edit items in SMC , well let's start!

First : start your server ,Then go to SR_UserEdit tab,Char Item-

Now just insert your char name .. for me it's Tui and hit Query > SMC will search for it and once it finishs you'll see all items in ur inv. OptLVL is the current + now right click on the item you want to edit and choose Modify Item

Now there will pop up a screen with all data about the item
Opt LVL : is the current + i changed it from +8 to +12 > hit Validate !
Next is Variance .. that's the white stats basicly for getting full 100% stats put this number > 34359738367 < this will get a 100% on all stats on weapons /sets/acc's > Hit Validate !
up right you'll see a clean window , just right click and " Add New" you'll see a window like that

Max opt lvl is the max blue
now Validate , that last window i dont know what's if for =P
Hit Update ,, and relog and here you get a FB / Max stats item
Few tips : to edit the items in SMC the char must be offline from the game server , 2nd as i said make sure the name is the same in DB ... dont use an [] name as of [GM] [Admin] , SMC wont read it ..hope i helped , i'll be answering all your questions

Edit : More options Credits for that goes to metalzombe !

Some more info
You can edit items when character is online. Just put the item you want in storage close it then edit it once you edit it teleport before you re-open storage and then its done. Other wise it will revert back if you dont teleport.

To make items higher then +12 in SMC
"Thanks to Portal Dark for guide"
Modify three stored procedures
SMC_ADD_ITEM
SMC_EDIT_ITEM
SMC_DEL_ITEM

Find

if (@OptLvl < 0)  
    set @OptLvl = 0  
   else if (@OptLvl > 12)  
    set @OptLvl = 12

and replace the 12 with 250
This will allow you to create items past 12 but only in SMC not in game.

And for character with [GM] in name you can either change name in DB while offline make changes then change it back in DB. Or just create a dummy char on account name it "smcedit" and use it to select the storage.

 

[asi]

Re: [Guide] Editing items through SMC

error

 

[matadoor]

Re: [Guide] Editing items through SMC

From what i see , SMC cant locate your chr name as cannot find target . try with other names , normal without [GM] , [Admin]

 

[MikroBody]

Re: [Guide] Editing items through SMC

error

you r edit items account
but you`r account in game
if you need edit status item
you need account logout and will you edit any think

 

[asi]

Re: [Guide] Editing items through SMC

[GM] or [Admin] I did not write . name test and error ?

Error Video..

To view the content, you need to sign in or register

 

[matadoor]

Re: [Guide] Editing items through SMC

[GM] or [Admin] I did not write . name test and error ?

Error Video..

To view the content, you need to sign in or register

well i've not tried adding items through smc ... just try dropping it when ur char's online and relog , edit through smc and check ... maybe smc cant just put smth in the DB unless there's a game running .

 

[firat0912]

Re: [Guide] Editing items through SMC

thank you

 

[fabian1121]

Re: [Guide] Editing items through SMC

You can't use it if your char's nickname is [GM]XXXXX

 

[metalzombe]

Re: [Guide] Editing items through SMC

Some more info
You can edit items when character is online. Just put the item you want in storage close it then edit it once you edit it teleport before you re-open storage and then its done. Other wise it will revert back if you dont teleport.

To make items higher then +12 in SMC
"Thanks to Portal Dark for guide"
Modify three stored procedures
SMC_ADD_ITEM
SMC_EDIT_ITEM
SMC_DEL_ITEM

Find

if (@OptLvl < 0)  
    set @OptLvl = 0  
   else if (@OptLvl > 12)  
    set @OptLvl = 12

and replace the 12 with 250
This will allow you to create items past 12 but only in SMC not in game.

And for character with [GM] in name you can either change name in DB while offline make changes then change it back in DB. Or just create a dummy char on account name it "smcedit" and use it to select the storage.

 

[matadoor]

Re: [Guide] Editing items through SMC

Some more info
You can edit items when character is online. Just put the item you want in storage close it then edit it once you edit it teleport before you re-open storage and then its done. Other wise it will revert back if you dont teleport.

To make items higher then +12 in SMC
"Thanks to Portal Dark for guide"
Modify three stored procedures
SMC_ADD_ITEM
SMC_EDIT_ITEM
SMC_DEL_ITEM

Find

if (@OptLvl < 0)  
    set @OptLvl = 0  
   else if (@OptLvl > 12)  
    set @OptLvl = 12

and replace the 12 with 250
This will allow you to create items past 12 but only in SMC not in game.

And for character with [GM] in name you can either change name in DB while offline make changes then change it back in DB. Or just create a dummy char on account name it "smcedit" and use it to select the storage.

Thanks for that , didnt know about the max + , i'll add it to the guide credits for you ofc =)

 

[nukertube]

Re: [Guide] Editing items through SMC

can not use simbols '[' , ']'

 

[omardahy]

can i do this for item in NPC to make this FB and 100% ?

 

[RockStars]

Where i can find ?

SMC_ADD_ITEM
SMC_EDIT_ITEM
SMC_DEL_ITEM

 

[Caosfox]

sro_vt_shard -> procedures
(maybe say stored procedures, depends on your sql front end)

 

[samersamirg]

sro_vt_shard -> procedures
(maybe say stored procedures, depends on your sql front end)

I can't find this table if you can post the design of this table ^_^

nvm I found it

 

[SynxCreative]

Download Link Plz

 

[na7al000]

SRO_VT_SHARD >>>>> Programmability >>> Stored Procedures >>>> SMC _ EDIT , ADD , DEL

 

[RoyalDevil]

I'm trying to edit an item but it shows. query error : Unknown..
I checked SMC_EDIT_ITEM, but nothing is wrong there.

Any idea, any help? thanks in advance.

 

[Blacksheep25]

I'm trying to edit an item but it shows. query error : Unknown..
I checked SMC_EDIT_ITEM, but nothing is wrong there.

Any idea, any help? thanks in advance.

Can you show us a screenshot so we can understand more what your trying to do?