[Dave]

Well I have had some people ask how I parse the XboxMB API and get it to work without having the put a username in. You need to be added to Cheaters whitelist for it to work with this method. Big thanks for Austin for helping me with a bit of PDO. For this I created a Database in MySQL which has the UserGroup ID as the primary key and then has columns for the other data like username.

PHP Code:

<?php 
    require_once('connection.inc.php');
    $ip = $_SERVER['REMOTE_ADDR'];
    
    $api_url = 'http://api.xboxmb.com/?ip=';
    $info = curl_init();
    curl_setopt($info, CURLOPT_URL, $api_url.$ip);
    curl_setopt($info, CURLOPT_RETURNTRANSFER, true);
    $result = curl_exec($info);
    curl_close($info);
    $result = json_decode($result,true);
    
    if($result['Valid'] == true) {
        $sth = $dbh->prepare('SELECT * FROM users WHERE UserID = :UserID')->execute(array(':UserID', $result['UserID']));
        if($sth->rowCount() == 0) {
            $sth = $dbh->prepare("REPLACE INTO users (UserID, Username, UserGroup, Title, Staff, Diamond, Banned, Posts, Thanks, JoinDate) VALUES (:UserID, :Username, :UserGroup, :Title, :Staff, :Diamond, :Banned, :Posts, :Thanks, :JoinDate)");
            $sth->execute(array (
                ':UserID' => $result['UserID'],
                ':Username' => $result['Username'],
                ':UserGroup' => $result['UserGroup'],
                ':Title' => $result['Title'],
                ':Staff' => $result['Staff'],
                ':Diamond' => $result['Diamond'],
                ':Banned' => $result['Banned'],
                ':Posts' => $result['Posts'],
                ':Thanks' => $result['Thanks'],
                ':JoinDate' => $result['JoinDate']
            ));    
        }else {
            $UserInfo = $sth->fetch(PDO::FETCH_OBJ, PDO::FETCH_ASSOC);
            $UserGroupColor = ($UserInfo->UserGroup == "12") ? '800080' : (($UserInfo->UserGroup == "14") ? 'ff0000' : (($UserInfo->UserGroup == "6") ? '800000' : (($UserInfo->UserGroup == '17') ? '0000ff' : (($UserInfo->UserGroup == '5') ? '00bfff' : (($UserInfo->UserGroup == '10') ? '7b7b7b' : (($UserInfo->UserGroup == '11') ? '008000' : (($UserInfo->UserGroup == '19') ? 'e70ac5' : (($UserInfo->UserGroup == '25') ? '2b7d7a' : (($UserInfo->UserGroup == '24') ? '57df7b' : '202020')))))))));
        }
    }
?>

Then to use it just do;

PHP Code:

echo $UserInfo->Username."has ".$UserInfo->Posts."posts."; 


It will then display;

PHP Code:

Dave has 2,170 posts 


[imnotanoob]

Awesome stuff as usual daveyy

[sgt frankieboy]

Nice, but why are you storing the data inside a database? Just for learning I guess?

[Cheater912]

I would bind the UserID value to a prepared statement instead of adding it to the query. It defeats the purpose of using PDO.

$sth = $dbh->prepare('SELECT * FROM users WHERE UserID = :UserID')->execute(array(':UserID', $result['UserID']));

It's a good habit to get in to because it completely eliminates SQL injection. Even though the user ID is coming from XboxMB, you never know what may happen.

You can also use this:
XboxMB API Class

Just add this to the RequestMode class:

const IP = 'ip';

Nice tut

[Dave]

Originally Posted by Cheater912

I would bind the UserID value to a prepared statement instead of adding it to the query. It defeats the purpose of using PDO.

$sth = $dbh->prepare('SELECT * FROM users WHERE UserID = :UserID')->execute(array(':UserID', $result['UserID']));

It's a good habit to get in to because it completely eliminates SQL injection. Even though the user ID is coming from XboxMB, you never know what may happen.

You can also use this:
XboxMB API Class

Just add this to the RequestMode class:

const IP = 'ip';

Nice tut

Yeah I used to use something like that but Austin said it wasn't good for server to keep being parsed every time for everything so he told me to create DB to store it in. Thanks for the tip I will add it now.

[sgt frankieboy]

Originally Posted by Dave

Yeah I used to use something like that but Austin said it wasn't good for server to keep being parsed every time for everything so he told me to create DB to store it in. Thanks for the tip I will add it now.

That also explained my question of why adding it to a database

[Dave]

Originally Posted by sgt frankieboy

That also explained my question of why adding it to a database

Just noticed your question. Sorry for missing you. I also find it easier to use it from DB as it's an array.