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']);