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); } } } }