$connection = odbc_connect( $connection_string, $user, $pass ); if($_POST[acao]!="Alterar") { $user = $_GET['user']; $trans = base64_decode($_GET['data']); $query = "SELECT * FROM [sPTDB].[dbo].[ShopTransCreditos] WHERE [USER_TRANS] = '$user' AND [DT_TRANS]='$trans'"; $q = odbc_exec($connection, $query); $dados = odbc_fetch_array($q); $user_trans=$dados['USER_TRANS']; $id_trans=$dados['ID_TRANS']; $ct_trans=$dados['CT_TRANS']; $st_trans=$dados['ST_TRANS']; $dt_trans=$dados['DT_TRANS']; $ip_trans=$dados['IP_TRANS']; ?>
} if($_POST[acao]=="Alterar") { $user_trans=$_POST['user_trans']; $id_trans=trim($_POST['id_trans']); $ct_trans=$_POST['ct_trans']; $st_trans=$_POST['st_trans']; $dt_trans=$_POST['dt_trans']; $ip_trans=$_POST['ip_trans']; if(!$user_trans OR !$id_trans OR !$ct_trans OR !$st_trans OR !$dt_trans OR !$ip_trans){ echo""; echo""; } else { if($user_trans==$id_trans){ echo""; echo""; }else{ $query_verids = "SELECT * FROM [accountdb].[dbo].[ALLPersonalMember] WHERE [userid]='$user_trans'"; $q_verids = odbc_exec($connection, $query_verids); $dadosplayer = odbc_fetch_array($q_verids); $creditos_user = $dadosplayer['Coins']; if($creditos_user<$ct_trans && $st_trans==3){ echo""; echo""; } else { $newcoin = $creditos_user-$ct_trans; $atualizar = odbc_exec("UPDATE [accountdb].[dbo].[ALLPersonalMember] SET [Coins]='{$newcoin}' WHERE [UserID]='$user_trans'"); /* $trans_dir=$creditos."$id_trans.arc"; //nova id para transferencia "techno" $new_ct_user=$creditos_user-$ct_trans; //somando creditos para nova id 'techno' $new_ct_trans=file_get_contents($trans_dir)+$ct_trans; //pegando creditos if($st_trans==3){ file_put_contents($creditos."$user_trans.arc",$new_ct_user); file_put_contents($trans_dir,$new_ct_trans); */ } if(odbc_do($connection,"UPDATE [sPTDB].[dbo].[ShopTransCreditos] SET [ST_TRANS]='$st_trans' WHERE [USER_TRANS]='$user_trans' AND [DT_TRANS]='$dt_trans'")){ echo""; echo""; }}}} ?>