[Query] to edit job type and job level for beginners!
PHP Code:
/*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/ /*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/
use SRO_VT_SHARD /*### Query by Kiro ###*/
declare [MENTION=768752]job[/MENTION]type int ;declare [MENTION=768752]job[/MENTION]lvl int ; declare [MENTION=551894]Char[/MENTION]name varchar(128)
set [MENTION=768752]job[/MENTION]lvl = '10' -- Job level
set [MENTION=768752]job[/MENTION]type = '1' -- (1 = Hunter) (2 = Thief) (3 = Hunter)
set [MENTION=551894]Char[/MENTION]name = 'Kiro' -- Character Name !
update _CharTrijob set [Level] = [MENTION=768752]job[/MENTION]lvl , [JobType] = [MENTION=768752]job[/MENTION]type where CharID = (select _char.CharID from _Char where CharName16 = [MENTION=551894]Char[/MENTION]name) /*### Query by Kiro ###*/
/*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/ /*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*//*### Query by Kiro ###*/