I will try to update in the near future for the latest version of the rAthena.
Open ../src/login/account.cpp
Search:
"SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`, `pincode_change`, `vip_time`, `old_group` FROM `%s` WHERE `account_id` = %d",
Change to:
"SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`, `pincode_change`, `vip_time`, `old_group`,`lock_id` FROM `%s` WHERE `account_id` = %d",
Search:
"SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`, `pincode_change` FROM `%s` WHERE `account_id` = %d",
Change to:
"SELECT `account_id`,`userid`,`user_pass`,`sex`,`email`,`group_id`,`state`,`unban_time`,`expiration_time`,`logincount`,`lastlogin`,`last_ip`,`birthdate`,`character_slots`,`pincode`, `pincode_change`, `lock_id` FROM `%s` WHERE `account_id` = %d",
Search:
#ifdef VIP_ENABLE
Sql_GetData(sql_handle, 16, &data, NULL); acc->vip_time = atol(data);
Sql_GetData(sql_handle, 17, &data, NULL); acc->old_group = atoi(data);
#endif
After add:
Sql_GetData(sql_handle, 18, &data, NULL); acc->lock_id = strtoul(data, NULL, 10);