public static function insert_login_makekey($uid = 0, $comkey = '', $usr_new = 0)
{
$query = "SELECT * FROM `tk_buburegusr` WHERE `usr_uid` = '" . $uid . "'";
$user = dbconn::db_getRow($query);
$query = "SELECT * FROM `tk_comkeylog` WHERE `log_uid` = '" . $uid . "'";
$comdata = dbconn::db_getRow($query);
if (!empty($comdata)) {
$comkey = $comdata['log_comkey'];
}
if (empty($user)) {
$query = "SELECT * FROM `bbt_user` WHERE `id` = '" . $uid . "'";
$user = dbconn::db_defgetRow($query);
if (!empty($user['id'])) {
if ($user['state'] == 'active') {
$makekey = dbconn::make_newkey();
$sql = "INSERT INTO `tk_buburegusr`(\n\t\t\t\t\t\t\t`usr_uid`, `usr_new`, `usr_makekey`, `usr_comkey`, `created_at`, `updated_at`\n\t\t\t\t\t\t) VALUES (\n\t\t\t\t\t\t\t'" . $user['id'] . "','" . $usr_new . "','" . $makekey . "','" . $comkey . "','" . date('Y-m-d H:i:s') . "','" . date('Y-m-d H:i:s') . "'\n\t\t\t\t\t\t)";
$result = dbconn::db_query($sql);
}
}
}
}
