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.

[MentaL]

[asi]

error

[matadoor]

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

[MikroBody]

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]

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

Error Video..

Untitled.mp4 - YouTube

[matadoor]

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

Error Video..

Untitled.mp4 - YouTube

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]

thank you

[fabian1121]

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

[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.

[matadoor]

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]

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 :D