<?php
/*
CheckPlayer is a component of the OWHAutoRank plugin. It is intended to check a websites associated MySQL for a related User account.
CheckPlayer, and OWHAutoRank were written by Christopher 'Raniy@omgwtfhax.info' Lohman for OMGWTFHAX.info.(c)2012

 *
 * Redistribution and use in source and binary forms, with or without modification, are
 * permitted provided that the following conditions are met:
 *
 *    1. Redistributions of source code must retain the above copyright notice, this list of
 *       conditions and the following disclaimer.
 *
 *    2. Redistributions in binary form must reproduce the above copyright notice, this list
 *       of conditions and the following disclaimer in the documentation and/or other materials
 *       provided with the distribution.
 *
 * THIS SOFTWARE IS PROVIDED BY THE AUTHOR ''AS IS'' AND ANY EXPRESS OR IMPLIED
 * WARRANTIES, INCLUDING, BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND
 * FITNESS FOR A PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE AUTHOR OR
 * CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, OR
 * CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS OR
 * SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND ON
 * ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING
 * NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF
 * ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.
 *
 * The views and conclusions contained in the software and documentation are those of the
 * authors and contributors and should not be interpreted as representing official policies,
 * either expressed or implied, of anybody else.
*/

// EDIT ALL OF THESE VARIABLES TO REFLECT /YOUR/ SETUP.

// Define constants for mysql
$MySQLUser = "mysqluser";
$MySQLPass = "someverycleverpassword";
$MySQLDBName = "forums";
$MySQLString = "localhost";

// Define constants for your Websites database
$MySQLTableName = "users";
$MySQLFieldName = "username";




// DO NOT EDIT BELOW HERE!!!!!

// Check for Querystring 'PlayerName'
$PlayerName = $_POST['playername'];
if($PlayerName == "")
{
    $PlayerName = $_GET['playername'];
};

// Error controlling... If 'PlayerName' <1 or >16 return false. Not a valid 'PlayerName'
if(strlen($PlayerName) <1 || strlen($PlayerName) > 16){
    die("false");
};

// Check MySQL for User with 'PlayerName' ignoring case.
// If User exists then echo 'true'
    $MyMySQL = mysql_connect($MySQLString,$MySQLUser,$MySQLPass) or die("Couldnt Connect to MySQL! ERROR!");
    mysql_select_db($MySQLDBName,$MyMySQL) or die("Couldnt Select our DB! ERROR!");

    $NameQuery = "select `" . $MySQLFieldName . "` from `". $MySQLTableName . "` WHERE `" . $MySQLFieldName . "` = '" . $PlayerName . "' LIMIT 1";
    $NameResult = mysql_query($NameQuery,$MyMySQL) or die("I was unable to retrieve the user list!");
    $NumNames = mysql_num_rows($NameResult);
    if($NumNames == 1){
        die("true");
    } else {
        die("false");
    };

?>