public function getAllFriends(User $user)
{
$con = Connection::createConnection();
$result = mysql_query("SELECT u1.id as user_id, u1.username as user_name, u2.* FROM user u1, userprofile u2 where u1.id = u2.id AND u1.id != {$user->id}");
$friendList = array();
while ($row = mysql_fetch_array($result)) {
$userProfile = new UserProfile();
$tempUser = new User();
//setting user
$tempUser->id = $row['user_id'];
$tempUser->username = $row['user_name'];
$userProfile->setUser($tempUser);
//Setting user profile
$userProfile->id = $row['id'];
$userProfile->age = $row['age'];
$userProfile->country = $row['country'];
$userProfile->favgame = $row['favgame'];
$userProfile->humour = $row['humour'];
$userProfile->imgurl = $row['imgurl'];
$userProfile->job = $row['job'];
$userProfile->language = $row['language'];
$userProfile->politicalview = $row['politicalview'];
$userProfile->religion = $row['religion'];
$userProfile->school = $row['school'];
array_push($friendList, $userProfile);
}
return $friendList;
}
/**
*
* @param <Inventory> $inventory
* @param <int> $artifactPrice
* @param <GameProfile> $updatedGameProfile
* @return <Boolean>
* @SQL update gameprofile set gold = 100 where userid = 1
* @SQL delete from inventory where id=1 AND userid=1
*
*/
public function sellArtifact($inventory, $artifactPrice, $updatedGameProfile)
{
$con = Connection::createConnection();
$user = $updatedGameProfile->user;
$updateGameProfile = mysql_query("update gameprofile set gold = {$updatedGameProfile->gold} where userid = {$user->id}");
//delete from inventory
$deleteInventory = mysql_query("delete from inventory where id={$inventory->id} AND userid={$user->id}");
mysql_query("commit");
Connection::closeConnection($con);
return true;
}
/**
*
* @param <Inventory> $inventory
* @return <Inventory>
* @SQL Insert into inventory values (NULL,1,1,1)
*/
public function addToInventory($inventory)
{
$con = Connection::createConnection();
$artifact = $inventory->artifact;
$user = $inventory->user;
$result = mysql_query("Insert into inventory values (NULL,{$inventory->artifactLvl},{$artifact->id},{$user->id})");
$inventory->id = mysql_insert_id();
mysql_query("commit");
Connection::closeConnection($con);
return $inventory;
}
/**
*
* @param <String> $columnName
* @param <GameProfile> $gameProfile
* @return <Boolean>
* @SQL update gameprofile set spylvl=spylvl+1 where globallvl > spylvl+scoutlvl+buylvl+sharelvl AND userid =1
*/
public function addSkill($columnName, $gameProfile)
{
$con = Connection::createConnection();
$user = $gameProfile->user;
$addPoints = mysql_query("update gameprofile set {$columnName}={$columnName}+1 where globallvl > spylvl+scoutlvl+buylvl+sharelvl AND userid ={$user->id}");
if (mysql_affected_rows() < 1) {
Connection::closeConnection($con);
return false;
} else {
return true;
}
}
/**
*
* @param <User> $username
* @return <User>
* @SQL Select * From user Where username = 1
*/
public function isUsernameAvailable($username)
{
$con = Connection::createConnection();
$result = mysql_query("Select * From user Where username = '******'");
$loginid = -1;
$tempArray = mysql_fetch_array($result);
if (mysql_num_rows($result) == 1) {
$user = new User();
$user->id = $tempArray['id'];
$user->username = $tempArray['username'];
}
Connection::closeConnection($con);
return $user;
}
* @return JSON Information of the user.
*/
function login($conn)
{
$JSON = array();
$array_data = array();
// Gets the e-mail and password received from the login factory.
$email = $_REQUEST['email'];
$pass = $_REQUEST['pass'];
$query = "SELECT id, fullName, email, receipt, type FROM person WHERE email='{$email}' AND pass='******'";
$result = $conn->query($query);
while ($row = mysqli_fetch_array($result)) {
$array_data[] = $row;
}
foreach ($array_data as &$row) {
$JSON[] = array('id' => $row['id'], 'fullName' => utf8_encode($row['fullName']), 'email' => utf8_encode($row['email']), 'receipt' => $row['receipt'], 'type' => $row['type']);
}
if ($JSON == []) {
echo false;
} else {
echo json_encode($JSON);
}
}
// Try to make the connection with the database.
$connection = new Connection();
$conn = $connection->createConnection();
if ($conn) {
login($conn);
} else {
echo false;
}
public function getShareProgress($gameProfile, $gameProgress)
{
$con = Connection::createConnection();
$share = ServerConstants::SHARE;
$csp = $gameProgress->csp;
$friendUser = $gameProgress->friend->user;
$count = mysql_query("SELECT count(*) as count FROM gameprogress,progresstype where gameprogress.progresstypeid = progresstype.id AND progresstype.progresstype = '{$share}' AND gameprogress.cspid = {$csp->id} AND gameprogress.friendid = {$friendUser->id}");
while ($row = mysql_fetch_array($count)) {
$rowcount = $row['count'];
}
$base = 0.5;
$rowcount = $rowcount + 1;
$progress = pow($base, $rowcount) * $gameProfile->shareLvl * 5;
$progressType = $this->giveProgressTypeObj(ServerConstants::SHARE);
$insert = mysql_query("insert into gameprogress values (NULL,{$csp->id},{$friendUser->id},{$progressType->id})");
mysql_query("commit");
Connection::closeConnection($con);
return $progress;
}
/**
*
* @param <CurrentSearchParty> $currentSearchParty
* @return <CurrentSearchParty>
* @SQL update currentsearchparty,artifactinfo set progress = 10 where currentsearchparty.id = 1 AND (select isactive from artifactinfo where artifactinfo.id= currentsearchparty.artifactid) = 1
*/
public function updateCurrentSearchPartyProgress($currentSearchParty)
{
$con = Connection::createConnection();
$result = mysql_query("update currentsearchparty,artifactinfo set progress = '{$currentSearchParty->progress}' where currentsearchparty.id = '{$currentSearchParty->id}' AND (select isactive from artifactinfo where artifactinfo.id= currentsearchparty.artifactid) = 1");
if (mysql_affected_rows() < 1) {
//means the current search party we want to update the artifact of that party is not active
Connection::closeConnection($con);
return null;
}
Connection::closeConnection($con);
return $currentSearchParty;
}
<?php
set_include_path(get_include_path() . ';' . realpath(__DIR__));
function _autoloader($className)
{
$filePath = str_replace('_', '/', $className) . ".php";
require_once $filePath;
}
spl_autoload_register("_autoloader");
$config = (include __DIR__ . '/../config/config.php');
Connection::setConnection(Connection::createConnection($config['db']['host'], $config['db']['user'], $config['db']['password'], $config['db']['dbname']));
View::setViewPath($config['viewPath']);
