JRache
.
Cozum : PhpUser e Eklıyeceksınız Asahıdakını daha oncekı konumdan yola cıktım ıyı forumlar
PHP:
public function registerUsers2($username,$pw,$mail,$gs,$ip){
$querycert = $this->link->db_conn_account->query("select top (1) certificate_num from TB_User where JID > 0 order by JID desc");
$querycert->execute();
$querykomut = $querycert->fetch(PDO::FETCH_ASSOC);
$degerCert = $querykomut['certificate_num'];
if(empty($degerCert))
{
$degerCert = 203103198405100000;
}else{
$degerCert = $querykomut['certificate_num']+1;
}
$query = $this->link->db_conn_account->query("INSERT INTO TB_User(StrUserID,password,game_credit,credit,Status,GMrank,Name,Email,certificate_num,sex,address,postcode,phone,regtime,reg_ip,sec_primary,sec_content,AccPlayTime,LatestUpdateTime_ToPlayTime,EmailValidate)
VALUES('$username','$pw','0','0',NULL,NULL,NULL,'$mail','$degerCert',NULL,'$gs',NULL,'0',NULL,'$ip','3','3','0','0','1')");
$counts=$query->rowCount();
return $counts;
}