Example #1
0
    	if($getLastDate['lastUpdated']==$date){
    		echo 'dates match';	
    	}*/
    /*Reads through the tbluser table by row. 
    		@@Then Grabs the selected row's steamid and date
    		@@Then Checks the date, if it is null then it will		
    		@@add the users friends to the userstable, and the tblusers users gameslist to mongo		
    		*/
    for ($i = 0; $i < $numrows; $i++) {
        $getLastDate = mysqli_query($db1, "select lastUpdated from tbluser limit {$i},1;");
        //select 1 row at index i
        $userdate = mysqli_fetch_assoc($getLastDate);
        //echo $userdate["lastUpdated"];
        $fetchid = mysqli_query($db1, "select steamid from tbluser limit {$i},1;");
        $sid = mysqli_fetch_assoc($fetchid);
        $steamid = $sid["steamid"];
        if ($userdate["lastUpdated"] == null) {
            if (mysqli_fetch_assoc($getLastDate) != $date) {
                echo 'dates dont match';
                $newDate = "UPDATE tbluser SET lastUpdated='{$date}' WHERE steamid='{$steamid}'";
                $sendquery = mysqli_query($db1, $newDate);
                addFriendsToUsers($steamid);
                sendMongo($steamid, 2);
            }
            //end if1
        }
        //end if0
    }
    //end for
}
//end while
Example #2
0
 function showFriends($steamID)
 {
     /*
     @this function will retrieve the users friends list from steam
     @then it will compare it to our tables. if the friend is in the database
     @it will pull it from there and display it
     @otherwise it will add it to the database then pull it.
     */
     $apikey1 = "238E8D6B70BF7499EE36312EF39F91AA";
     $pushFriends = "http://api.steampowered.com/ISteamUser/GetFriendList/v0001/?key={$apikey1}&steamid={$steamID}&relationship=friend";
     //echo "addFriends initialized";
     //echo $apikey1;
     $jsonList = file_get_contents($pushFriends);
     $json_decode = json_decode($jsonList);
     //echo $json_decode->friendslist->friends[0]->steamid;
     $db1 = mysqli_connect("localhost", "root", "password", "profile");
     if (!mysqli_ping($db1)) {
         echo 'Lost connection, exiting after query #1';
         exit;
     }
     //$i=0;
     $friendArray = array();
     foreach ($json_decode->friendslist->friends as $friend) {
         $friendID = $friend->steamid;
         //echo $friendID;
         $sql_fetch_id = "SELECT * FROM users WHERE steamid = {$friendID}";
         $query_id = mysqli_query($db1, $sql_fetch_id);
         //echo $friendID;
         if (mysqli_num_rows($query_id) > 0) {
             //echo "true";
             $sql_fetch_avatar = "SELECT avatar FROM users WHERE steamid = {$friendID}";
             $sql_fetch_id = "SELECT steamid FROM users WHERE steamid = {$friendID}";
             $sql_fetch_name = "SELECT name FROM users WHERE steamid = {$friendID}";
             $query_avatar = mysqli_query($db1, $sql_fetch_avatar);
             $row_avatar = mysqli_fetch_assoc($query_avatar);
             //$query_id= mysqli_query($db1,$sql_fetch_id);
             //$row_id=mysqli_fetch_assoc($query_id);
             $query_name = mysqli_query($db1, $sql_fetch_name);
             $row_name = mysqli_fetch_assoc($query_name);
             $avatar = $row_avatar["avatar"];
             //$fID=$row_avatar["id"];
             $fName = $row_name["name"];
             array_push($friendArray, $avatar, $fName);
             //echo "<img src=$avatar>";
             //echo "\r\n";
             //echo $fName;
             //echo "<br>";
         } else {
             addFriendsToUsers($steamID);
         }
     }
     return $friendArray;
 }
function requestProcessor($request)
{
    echo "received request" . PHP_EOL;
    var_dump($request);
    if (!isset($request['type'])) {
        return "ERROR: unsupported message type";
    }
    switch ($request['type']) {
        case "login":
            //return doLogin($request['username'],$request['password']);
            $auth = doLogin($request['username'], $request['password']);
            if ($auth == true) {
                return array('hello' => 'world');
            }
        case "validate_session":
            return doValidate($request['sessionId']);
            //in case friends this will return a list of friends from
            //the the steam user, and send it in an array to the client.
        //in case friends this will return a list of friends from
        //the the steam user, and send it in an array to the client.
        case "showFriends":
            return showFriends($request['steamid']);
        case "popFri":
            addFriendsToUsers($request['steamid']);
        case "add":
            retrieveUserInfo($request['steamid']);
            //return array("returnCode" => '0', 'message'=>"Server received request and processed");
    }
    //return array("returnCode" => '0', 'message'=>"Server received request and processed");
}