Connexion
S'inscrire
Actualités
Quoi de neuf
Activités générales
Auteurs
Forums
Nouveaux messages
Rechercher un forum
Quoi de neuf
Nouveaux messages
Nouveaux messages de profil
Activités générales
Membres
Membres inscrits
Visiteurs actuels
Nouveaux messages de profil
Rechercher dans les messages des profils
Teams
Créé ton équipe
Quoi de neuf ?
Nouveaux messages
Rechercher un forum
Menu
Connexion
S'inscrire
Install the app
Install
Forums
Forums généraux
Informatique
Développement
Questions, aides et recherches
Résolus
cherche un api de connection/édition pour ma bdd
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
Vous utilisez un navigateur non à jour ou ancien. Il ne peut pas afficher ce site ou d'autres sites correctement.
Vous devez le mettre à jour ou utiliser un
navigateur alternatif
.
Répondre à la discussion
Message
<blockquote data-quote="Must Energie" data-source="post: 6497581" data-attributes="member: 476682"><p>ou si vous avez juste 10 minutes pour m'aider a corriger les .php car d'apres pas mal de personnes ils sont beuger :/</p><p></p><p>api.php :</p><p>[CODE]<?php</p><p>include './database.php';</p><p>$username = mysql_escape_string($_GET['username']);</p><p>$password = mysql_escape_string($_GET['password']);</p><p>$hwid = mysql_escape_string($_GET['hwid']);</p><p></p><p>$squery = mysql_query("SELECT * FROM $table WHERE username='$username'");</p><p>$query = mysql_fetch_array($squery);</p><p>$rowcount = mysql_num_rows($squery);</p><p></p><p>if($new == $query['password'])</p><p>{</p><p>$chpw = "UPDATE $table Set password = '$password' WHERE username = '$username'";</p><p>$updpw = mysql_query($chpw);</p><p>}</p><p></p><p>if($new == $query['hwid'])</p><p>{</p><p>$chhwid = "UPDATE $table Set hwid = '$hwid' WHERE username = '$username'";</p><p>$updhwid = mysql_query($chhwid);</p><p>}</p><p></p><p>$squery = mysql_query("SELECT * FROM $table WHERE username='$username'");</p><p>$query = mysql_fetch_array($squery);</p><p>$rowcount = mysql_num_rows($squery);</p><p></p><p>if($rowcount == 1)</p><p>{</p><p> if($password != $query['password'])</p><p> echo'wrongpassword';</p><p> else</p><p> {</p><p> if($hwid != $query['hwid'])</p><p> echo'sharedaccount'; //</p><p> else</p><p> $squery = mysql_query("SELECT * FROM $table WHERE username='$username'");</p><p>$squery = mysql_query("SELECT * FROM $table WHERE hwid='$hwid'");</p><p>$str = $query['username'].$query['hwid'].'working';</p><p>echo md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(hash( 'sha256', (md5(hash( 'sha256', (md5($str))))))))))))))));</p><p> }</p><p>}</p><p>else</p><p>{</p><p> echo'Usernamenotregistred'; //</p><p>}</p><p>?>[/CODE]</p><p></p><p>apimanager.php</p><p></p><p>[CODE]<?php</p><p>include './database.php';</p><p>$del = '';</p><p>$username = mysql_escape_string($_GET['username']);</p><p>$password = mysql_escape_string($_GET['password']);</p><p>$hwid = mysql_escape_string($_GET['hwid']);</p><p>$GET = 'GET';</p><p></p><p>$squery = mysql_query("SELECT * FROM $table WHERE username='$username'");</p><p>$query = mysql_fetch_array($squery);</p><p></p><p>if($username != $query['username']) {</p><p> if($username == $GET){</p><p> $read = "SELECT username FROM $table";</p><p> $get = mysql_query($read);</p><p> while($row = mysql_fetch_object($get)){</p><p> echo "$row->username-";</p><p> }</p><p> }</p><p> else{</p><p> $create = "INSERT INTO $table (`index`, `username`, `password`, `hwid`) VALUES (NULL, '$username', '', '')";</p><p> $write = mysql_query($create);</p><p> echo'write';</p><p> }</p><p>}</p><p>else{</p><p> if($username == $query['username'])</p><p> {</p><p> if($password == 'DEL')</p><p> {</p><p> $chpw = "UPDATE $table Set password = '$del' WHERE username = '$username'";</p><p> $updpw = mysql_query($chpw);</p><p> echo'passreset';</p><p> }</p><p> else</p><p> {</p><p> if($hwid == 'DEL')</p><p> {</p><p> $chhwid = "UPDATE $table Set hwid = '$del' WHERE username = '$username'";</p><p> $uphwid = mysql_query($chhwid);</p><p> echo'hwidreset';</p><p> }</p><p> else</p><p> {</p><p> $delete = "DELETE FROM $table WHERE username='$username'";</p><p> $del = mysql_query($delete);</p><p> echo'delet';</p><p> }</p><p> }</p><p> }</p><p> else</p><p> {</p><p> echo'failure';</p><p> }</p><p>}</p><p>?> [/CODE]</p><p></p><p>et le database.php</p><p></p><p>[CODE]<?php</p><p>$server = ''; // Serveur SQL adresse</p><p>$user = ''; // Username de ton MySQL</p><p>$pass = ''; // Password de ton MySQL</p><p>$db = ''; // Nom de la database</p><p>$table = 'APIMonsteurkill'; // Nom de Table dans ta Database (personellement je l'est aplez api et je vous fourni la table deja toute faite)</p><p>$new = ''; //ne pas touchez</p><p></p><p>mysql_connect($server, $user, $pass) or die(mysql_error());</p><p>mysql_select_db($db) or die(mysql_error());</p><p>?>[/CODE]</p></blockquote><p></p>
[QUOTE="Must Energie, post: 6497581, member: 476682"] ou si vous avez juste 10 minutes pour m'aider a corriger les .php car d'apres pas mal de personnes ils sont beuger :/ api.php : [CODE]<?php include './database.php'; $username = mysql_escape_string($_GET['username']); $password = mysql_escape_string($_GET['password']); $hwid = mysql_escape_string($_GET['hwid']); $squery = mysql_query("SELECT * FROM $table WHERE username='$username'"); $query = mysql_fetch_array($squery); $rowcount = mysql_num_rows($squery); if($new == $query['password']) { $chpw = "UPDATE $table Set password = '$password' WHERE username = '$username'"; $updpw = mysql_query($chpw); } if($new == $query['hwid']) { $chhwid = "UPDATE $table Set hwid = '$hwid' WHERE username = '$username'"; $updhwid = mysql_query($chhwid); } $squery = mysql_query("SELECT * FROM $table WHERE username='$username'"); $query = mysql_fetch_array($squery); $rowcount = mysql_num_rows($squery); if($rowcount == 1) { if($password != $query['password']) echo'wrongpassword'; else { if($hwid != $query['hwid']) echo'sharedaccount'; // else $squery = mysql_query("SELECT * FROM $table WHERE username='$username'"); $squery = mysql_query("SELECT * FROM $table WHERE hwid='$hwid'"); $str = $query['username'].$query['hwid'].'working'; echo md5(md5(md5(md5(md5(md5(md5(md5(md5(md5(hash( 'sha256', (md5(hash( 'sha256', (md5($str)))))))))))))))); } } else { echo'Usernamenotregistred'; // } ?>[/CODE] apimanager.php [CODE]<?php include './database.php'; $del = ''; $username = mysql_escape_string($_GET['username']); $password = mysql_escape_string($_GET['password']); $hwid = mysql_escape_string($_GET['hwid']); $GET = 'GET'; $squery = mysql_query("SELECT * FROM $table WHERE username='$username'"); $query = mysql_fetch_array($squery); if($username != $query['username']) { if($username == $GET){ $read = "SELECT username FROM $table"; $get = mysql_query($read); while($row = mysql_fetch_object($get)){ echo "$row->username-"; } } else{ $create = "INSERT INTO $table (`index`, `username`, `password`, `hwid`) VALUES (NULL, '$username', '', '')"; $write = mysql_query($create); echo'write'; } } else{ if($username == $query['username']) { if($password == 'DEL') { $chpw = "UPDATE $table Set password = '$del' WHERE username = '$username'"; $updpw = mysql_query($chpw); echo'passreset'; } else { if($hwid == 'DEL') { $chhwid = "UPDATE $table Set hwid = '$del' WHERE username = '$username'"; $uphwid = mysql_query($chhwid); echo'hwidreset'; } else { $delete = "DELETE FROM $table WHERE username='$username'"; $del = mysql_query($delete); echo'delet'; } } } else { echo'failure'; } } ?> [/CODE] et le database.php [CODE]<?php $server = ''; // Serveur SQL adresse $user = ''; // Username de ton MySQL $pass = ''; // Password de ton MySQL $db = ''; // Nom de la database $table = 'APIMonsteurkill'; // Nom de Table dans ta Database (personellement je l'est aplez api et je vous fourni la table deja toute faite) $new = ''; //ne pas touchez mysql_connect($server, $user, $pass) or die(mysql_error()); mysql_select_db($db) or die(mysql_error()); ?>[/CODE] [/QUOTE]
Insérer les citations…
Vérification
Publier la réponse
Forums
Forums généraux
Informatique
Développement
Questions, aides et recherches
Résolus
cherche un api de connection/édition pour ma bdd
Ce site utilise des cookies. En continuant à utiliser ce site, vous acceptez l'utilisation des cookies.
Acceptez
En savoir plus.…
Haut