public static function add($param)
{
$pdo = new DBUtils();
$key_str = "";
$val_str = "";
$sql = "";
if (isset($param['type'])) {
$key_str .= "type,";
$val_str .= "'{$param['type']}',";
}
if (isset($param['studentName'])) {
$key_str .= "studentName,";
$val_str .= "'{$param['studentName']}',";
}
if (isset($param['num'])) {
$key_str .= "num" . ",";
$val_str .= "'{$param['num']}',";
}
$now = time();
$key_str .= "time" . ",";
$val_str .= "'{$now}',";
$key_str .= "course" . ",";
$val_str .= "'{$GLOBALS['STUDENT_COURSE_TYPE'][0]}',";
$key_str = substr($key_str, 0, strlen($key_str) - 1);
$val_str = substr($val_str, 0, strlen($val_str) - 1);
$sql = "insert into student_news (" . $key_str . ")";
$sql .= " VALUES (" . $val_str . ")";
$articleId = $pdo->insert($sql);
return $articleId;
}
public static function getIndex()
{
$pdo = new DBUtils();
$sql = "select * from homepage";
$rs = $pdo->query($sql);
return $rs;
}
public static function updatePhoto($param)
{
$pdo = new DBUtils();
$sql = "update homepage set photoUrl = '" . $param['photoUrl'] . "' where id = '{$param['id']}'";
$rs = $pdo->update($sql);
return $rs;
}
public static function delNav($snavId)
{
$pdo = new DBUtils();
$sql = "delete from second_nav where snavId = '{$snavId}'";
// print_r($sql);
// exit;
$rs = $pdo->delete($sql);
return $rs;
}
public static function getOne($courseId)
{
$pdo = new DBUtils();
$sql = "select * from course where courseId = {$courseId}";
$course = $pdo->getOne($sql);
$sql = "select * from courseType where courseId = {$courseId}";
$courseType = $pdo->query($sql);
return array("course" => $course, "courseType" => $courseType);
}
public function verifyUser()
{
$dbUtil = new DBUtils();
$value = $dbUtil->verifyUser($this->username, $this->password);
if ($value) {
$_SESSION["id"] = $this->username;
return "Logged in sucessfully";
} else {
return "Log in failed. Please try with proper user.";
}
return $value;
}
public function log()
{
$log = KLogger::instance(KLOGGER_PATH . "processors/", KLogger::DEBUG);
$log->logInfo("userxplog > log > start userId : " . $this->userId . " xp : " . $this->xp . " type : " . $this->type . " time : " . $this->time . " gameId : " . $this->gameId . " result : " . $this->result . " opponentId : " . $this->opponentId);
if (!empty($this->userId)) {
$userXPLog = new GameUserXpLog();
$userXPLog->setUserId($this->userId);
$userXPLog->setXp($this->xp);
$userXPLog->setTime($this->time);
$userXPLog->setType($this->type);
$userXPLog->setGameId($this->gameId);
$userXPLog->setResult($this->result);
$userXPLog->setOpponentId($this->opponentId);
try {
$user = GameUsers::getGameUserById($this->userId);
if (!empty($user)) {
$userXPLog->setUserLevel($user->userLevelNumber);
$userXPLog->setUserCoin($user->coins);
//$userCoinLog->setUserSpentCoin($user->opponentId);
}
} catch (Exception $exc) {
$log->logError("userxplog > log > User Error : " . $exc->getTraceAsString());
}
try {
$userXPLog->insertIntoDatabase(DBUtils::getConnection());
$log->logInfo("userxplog > log > Success");
} catch (Exception $exc) {
$log->logError("userxplog > log > Error : " . $exc->getTraceAsString());
}
} else {
$log->logError("userxplog > log > user Id is empty ");
}
}
public static function getGameCategoryItemWithLanguage()
{
$SQL = "SELECT categories.*,lang.language AS langCode,lang.text AS langText FROM " . TBL_GAME_ITEM_CATEGORY . " AS categories," . TBL_GAME_ITEM_CATEGORY_LANGUAGE . " AS lang WHERE categories.active=1 AND categories.categoryCode=lang.categoryCode ORDER BY id ASC";
$query = mysql_query($SQL, DBUtils::getManualConnection());
if (!empty($query)) {
$list = array();
$ids = array();
$i = 0;
while ($db_field = mysql_fetch_assoc($query)) {
$cat = GameItemCategory::createFromSQLWithLanguage($db_field);
if (!empty($cat)) {
$catId = $cat->getId();
if (!empty($catId)) {
if (isset($ids[$catId]) && isset($list[$ids[$catId]])) {
$oldItem = $list[$ids[$catId]];
$oldItem->languages = array_merge($oldItem->languages, $cat->languages);
} else {
array_push($list, $cat);
$ids[$catId] = $i;
$i++;
}
}
}
}
unset($ids);
return $list;
}
return array();
}
public static function gameResult(GameUsers $user, GameUsers $opponent, $roomGroupId, $action, $gameId = null, $double = 0, $normal = true, $type = null, $time = null)
{
$result = new FunctionResult();
$result->success = false;
if (!empty($user) && !empty($action)) {
if (empty($action) || !empty($action) && $action != GameUtils::$GAME_RESULT_ACTION_WIN && $action != GameUtils::$GAME_RESULT_ACTION_LOST) {
$result->result = "Unknown Action";
return $result;
}
GameUtils::updateXP($user, $opponent, $roomGroupId, $action, $gameId, $double, $normal, $type, $time);
GameUtils::updateCoin($user, $opponent, $roomGroupId, $action, $gameId, $double, $normal, $type, $time);
GameUtils::updateCounts($user, $opponent, $roomGroupId, $action, $gameId, $double, $normal, $type, $time);
if ($action == GameUtils::$GAME_RESULT_ACTION_WIN && ($type == GameUtils::$GAME_RESULT_ACTION_TYPE_LEFT || $type == GameUtils::$GAME_RESULT_ACTION_TYPE_TIMESUP) && !empty($opponent)) {
if (empty($time)) {
$time = time();
}
Queue::userLostConnLost($opponent->userId, $user->userId, $roomGroupId, GameUtils::$GAME_RESULT_ACTION_LOST, $gameId, $double, $normal, $type, $time);
}
try {
$user->updateToDatabase(DBUtils::getConnection());
$result->success = true;
$result->result = new stdClass();
$result->result->user = $user;
} catch (Exception $exc) {
$result->success = true;
$result->result = $exc->getTraceAsString();
}
return $result;
} else {
$result->result = "User not found";
return $result;
}
}
public static function setConstant($key, $value = null)
{
if (!empty($key)) {
GameConstantUtil::setCacheConstant($key, $value);
$setting = GameConstants::findByExample(DBUtils::getConnection(), GameConstants::create()->setKey_($key));
if (!empty($setting)) {
if (sizeof($setting) > 0) {
$setting = $setting[0];
$k = $setting->getKey_();
if (empty($k)) {
$setting = null;
}
} else {
$setting = null;
}
}
if (!empty($setting)) {
$setting->setValue_($value);
} else {
$setting = GameConstants::create();
$setting->setKey_($key);
$setting->setValue_($value);
}
$setting->updateInsertToDatabase(DBUtils::getConnection());
}
return false;
}
function getNav()
{
$pdo = new DBUtils();
$sql = "select * from nav";
$nav = $pdo->query($sql);
$header = array();
foreach ($nav as $key => $val) {
$header[$val['navId']] = array("navName" => $val['navName'], "navId" => $val['navId'], "second" => array());
}
$sql = "select * from second_nav";
$second = $pdo->query($sql);
foreach ($second as $key => $val) {
$header[$val['navId']]['second'][$val['snavId']] = array("snavName" => $val['snavName'], "snavId" => $val['snavId'], "link" => $val['snavName']);
}
return $header;
}
public static function autoLogin($rememberme = true)
{
if (isset($_SESSION["userId"])) {
$userId = $_SESSION["userId"];
$user = GameUsers::getGameUserById($userId);
if (!empty($user)) {
UtilFunctions::storeSessionUser($user, $rememberme);
return $user;
}
}
if (isset($_COOKIE["auth"]) && false) {
$cookie = $_COOKIE["auth"];
$arr = explode('&', $cookie);
$userName = substr($arr[0], 4);
$hash = substr($arr[1], 5);
$user = GameUsers::getGameUserByUserName($userName);
if (!empty($user)) {
if ($hash == md5($user->getPassword())) {
$user->setLastLoginDate(time());
$user->setLoginCount($user->getLoginCount() + 1);
$user->updateToDatabase(DBUtils::getConnection());
Queue::checkUserFriends($user->userId);
UtilFunctions::storeSessionUser($user, $rememberme);
return $user;
} else {
UtilFunctions::forgetMe();
}
}
}
return false;
}
/**
* save data in plenty_countries_of_delivery
*
* @param PlentySoapObject_GetCountriesOfDelivery $countryOfDelivery
*/
private function saveInDatabase($countryOfDelivery)
{
$query = 'REPLACE INTO `plenty_countries_of_delivery`
' . DBUtils::buildInsert(array('country_id' => $countryOfDelivery->CountryID, 'active' => $countryOfDelivery->CountryActive, 'country_name' => $countryOfDelivery->CountryName, 'iso_code_2' => $countryOfDelivery->CountryISO2));
$this->getLogger()->debug(__FUNCTION__ . ' save country ' . $countryOfDelivery->CountryISO2 . ' ' . $countryOfDelivery->CountryName);
DBQuery::getInstance()->replace($query);
}
function find_by_account($account, $limit = null)
{
$db =& DBUtils::connect();
$sql = 'SELECT f.id, f.url AS url FROM foaf f
JOIN member m ON f.member_id = m.id
WHERE m.account = ?';
$result = $db->getAll($sql, array($account));
if (DB::isError($result)) {
trigger_error(__CLASS__ . '::' . __FUNCTION__ . '(): ' . $result->toString(), E_USER_ERROR);
return null;
}
$parser =& new FOAFParser(true, CACHE_LITE_DIR, 60 * 60 * 24 * 1);
$foafs = array();
foreach ($result as $foaf) {
if (@$parser->parse($foaf['url']) === false) {
continue;
}
$people = $parser->getKnowsPerson();
foreach ($people as $index => $person) {
$people[$index]['foaf_id'] = $foaf['foaf_id'];
$people[$index]['foaf_url'] = $foaf['url'];
$p =& new FOAFParser(true, CACHE_LITE_DIR, 60 * 60 * 24 * 1);
if ($p->parse($person['seeAlso'])) {
$person['img'] = $p->getImg();
}
$foafs[$person['seeAlso']] = $person;
}
}
$res = array();
foreach ($foafs as $foaf) {
$res[] = $foaf;
}
return $res;
}
function find_with_content_category_by_account($account)
{
$db =& DBUtils::connect();
$sql = 'SELECT cc.id AS category_id, cc.name AS category_name, mcf.feed_id
FROM member_to_content_category_to_feed mcf
JOIN member m ON mcf.member_id = m.id
JOIN content_category cc ON mcf.content_category_id = cc.id
WHERE m.account = ?';
$result = $db->getAll($sql, array($account));
if (DB::isError($result)) {
trigger_error(__CLASS__ . '::' . __FUNCTION__ . '(): ' . $result->toString(), E_USER_ERROR);
return false;
}
$mcfs = $result;
$other = ContentCategoryUtils::get(PLNET_OTHER_CATEGORY_ID);
$feeds = FeedUtils::get_feeds_by_account($account);
$feeds_with_category = array();
foreach ($feeds as $key => $feed) {
foreach ($mcfs as $i => $mcf) {
if ($feed['id'] == $mcf['feed_id']) {
$feed['category_id'] = $mcf['category_id'];
$feed['category_name'] = $mcf['category_name'];
}
}
if (!isset($feed['category_id'])) {
$feed['category_id'] = $other['id'];
$feed['category_name'] = $other['name'];
}
$feeds_with_category[] = $feed;
}
return $feeds_with_category;
}
function Pager($sql_count, $sql, $current_page)
{
global $g_rb_database_type, $g_rb_pagerLimit, $DB_LINK;
$this->page_limit = $g_rb_pagerLimit;
$this->page = $current_page;
$this->sql = $sql;
if ($g_rb_database_type == "postgres") {
$sql .= " LIMIT " . $this->page_limit;
if ($this->page > 0) {
$sql .= " OFFSET " . ($this->page - 1) * $this->page_limit;
}
} else {
if ($g_rb_database_type == "mysql") {
$sql .= " LIMIT ";
if ($this->page > 0) {
$sql .= ($this->page - 1) * $this->page_limit . ", ";
}
$sql .= $this->page_limit;
}
}
// Get the count
$rc = $DB_LINK->Execute($sql_count);
DBUtils::checkResult($rc, NULL, NULL, $sql_count);
$this->total_results = $rc->fields[0];
// Make the query and set the results
$this->dbResults = $DB_LINK->Execute($sql);
DBUtils::checkResult($this->dbResults, NULL, NULL, $sql);
// Compute the max number of pages
$this->max_pages = ceil($this->total_results / $this->page_limit);
}
function lookup_consumer($consumer_key)
{
/*{{{*/
$secret = DBUtils::retrieveCustomer($consumer_key);
if ($secret) {
return new OAuthConsumer($consumer_key, $secret, NULL);
}
return NULL;
}
function Start($aDBServer, $aProjName)
{
$dbutils = new DBUtils($aDBServer);
$dbutils->SetProject($aProjName);
$this->iDirectory = $dbutils->GetProjDir($aProjName);
$this->iProjName = $aProjName;
$proj = $dbutils->GetProject();
$this->iShowPrivate = $dbutils->GetShowPrivate($aProjName);
$this->iDocType = $proj['fld_doctype'];
$ds = new DocStat($dbutils);
list($avg, $nc, $nm) = $ds->ProjStat($aProjName);
$t = '<table width=100% border=1 style="background-color:lightblue;"><tr><td align=center><span style="font-size:20pt;font-family:arial;font-weight:bold;">' . $aProjName . "</span></td></tr></table>\n";
$t .= '<div align=center><h3 style="color:darkred;font-family:arial;">Documentation status: ' . round($avg * 100) . '%</h3>';
$t .= '<span style="font-family:arial;">Total number of Classes: ' . $nc . ', Methods: ' . $nm . "</span><p>\n";
if ($this->iShowPrivate) {
$t .= '<i>This version <b>includes</b> private methods & classes</i><p>';
} else {
$t .= '<i>This version does <b>not</b> include private methods & classes</i><p>';
}
$t .= '<p><i>Generated at ' . strftime('%d %b %Y at %H:%M') . "</i><br>\n";
$t .= "</div><hr>";
$t .= "<p>" . $proj['fld_desc'];
if ($this->iDocType == 0) {
$dt = 'HTML: Multiple files.';
$this->iWriter->Open($this->iDirectory . 'projinfo.html');
$this->iWriter->W($t);
$this->iWriter->Close();
$this->iWriter->Open($this->iDirectory . 'index.html');
$this->iWriter->W($this->iIndexFramePage);
$this->iWriter->Close();
} else {
$dt = 'HTML: Single file.';
$this->iWriter->Open($this->iDirectory . 'index.html');
$this->iWriter->W($this->iIndexPage);
$this->iWriter->W($this->iCSS);
$this->iWriter->W($t);
}
HTMLGenerator::CloseWinButton('left');
echo "<hr>";
echo "<font face=arial><b>Generating reference for project : <font color=blue>{$aProjName}</font></b></font><br>";
echo "Output directory: <b><font color=blue>" . $this->iDirectory . '</font></b><br>';
echo "Output format: <b><font color=blue>{$dt}</font></b> <p>\n";
echo "<hr>";
}
function get_tagid_by_tagname($tagid)
{
$db =& DBUtils::connect();
$sql = "SELECT id FROM tag WHERE name = ?";
$result =& $db->getOne($sql, array($tagid));
if (DB::isError($result)) {
trigger_error('PlnetUtils::get_tagid_from_tagname(): fetch error.' . $result->toString(), E_USER_ERROR);
return false;
}
return $result;
}
function get($content_category_id)
{
$db =& DBUtils::connect();
$sql = 'SELECT * FROM content_category WHERE id = ?';
$result = $db->getRow($sql, array($content_category_id));
if (DB::isError($result)) {
trigger_error(__CLASS__ . '::' . __FUNCTION__ . '(): ' . $result->toString(), E_USER_ERROR);
return false;
}
return $result;
}
function get_sources_by_account($account)
{
$db =& DBUtils::connect();
$sql = "SELECT s.id, s.name, s.uri, s.link, s.icon \n FROM member m \n JOIN source s ON m.id = s.member_id \n WHERE m.account = ? \n ORDER BY s.id";
$result = $db->getAll($sql, array($account));
if (DB::isError($result)) {
trigger_error('PlnetUtils::get_sources_by_account(): ' . $result->toString(), E_USER_ERROR);
return false;
}
return $result;
}
/**
Gets a Column out of the database and returns them as a ADOdb type result
@param $table the table to query from
@param $valFld the first field to select
@param $keyFld The seconf field to select
@param $order how to order the result (should be either $valFld or $keyFld)
@return A ADOdb result
*/
public static function fetchColumn($table, $valFld, $keyFld = '', $order = '')
{
global $DB_LINK;
$table = $DB_LINK->addq($table, get_magic_quotes_gpc());
$valFld = $DB_LINK->addq($valFld, get_magic_quotes_gpc());
$keyFld = $DB_LINK->addq($keyFld, get_magic_quotes_gpc());
$order = $DB_LINK->addq($order, get_magic_quotes_gpc());
$sql = "SELECT {$valFld}" . ($keyFld ? ",{$keyFld}" : "") . " FROM {$table}" . ($order ? " ORDER BY {$order}" : "");
$rc = $DB_LINK->Execute($sql);
DBUtils::checkResult($rc, NULL, NULL, $sql);
return $rc;
}
function get_hot_tags($limit = null)
{
$db =& DBUtils::connect();
$sql = "SELECT t.name, COUNT(t.id) AS cnt\n FROM entry e\n JOIN entry_to_tag e2t ON e.id = e2t.entry_id\n JOIN tag t ON e2t.tag_id = t.id\n WHERE ? < e.date\n GROUP BY t.id\n ORDER BY cnt desc";
$sql .= $limit != null ? " LIMIT " . $limit : "";
$tags = $db->getAll($sql, array(date("Y-m-d", time() - 172800)));
if (DB::isError($tags)) {
trigger_error('fetch error.' . $tags->toString(), E_USER_ERROR);
return false;
}
return $tags;
}
public static function setNextId($field)
{
if (!empty($field)) {
$field = DBUtils::mysql_escape($field);
$id = rand(1000, 10000000);
$SQL = "INSERT INTO " . TBL_KEYGENERATOR . " (PK_COLUMN,VALUE_COLUMN) VALUES ('" . $field . "'," . $id . ")";
mysql_query($SQL) or die(mysql_error());
return $id;
} else {
return -1;
}
}
public function checkFriends()
{
$log = KLogger::instance(KLOGGER_PATH . "processors/", KLogger::DEBUG);
$log->logInfo("user > checkFriends > start userId : " . $this->userId);
$user = GameUsers::getGameUserById($this->userId);
if (!empty($user)) {
$userId = $user->userId;
if (!empty($userId)) {
$fbFriends = FriendUtils::getUserFacebookFriends($user);
if (!empty($fbFriends) && sizeof($fbFriends) > 0) {
$fbFriendIds = null;
foreach ($fbFriends as $fbFriend) {
if (!empty($fbFriend) && isset($fbFriend["id"])) {
if (empty($fbFriendIds)) {
$fbFriendIds = $fbFriend["id"];
} else {
$fbFriendIds = $fbFriendIds . "," . $fbFriend["id"];
}
}
}
$fbFriendUserIds = FriendUtils::getUserIdsFromFacebookIds($fbFriendIds);
if (!empty($fbFriendUserIds)) {
$friendIds = FriendUtils::getUserFriendIds($userId);
foreach ($fbFriendUserIds as $fbFriendId) {
if (!empty($fbFriendId)) {
$add = false;
if (!empty($friendIds) && sizeof($friendIds) > 0) {
if (!in_array($fbFriendId, $friendIds)) {
$add = true;
}
} else {
$add = true;
}
if ($add) {
$friend = new GameUserFriends();
$friend->setUserId($this->userId);
$friend->setType("facebook");
$friend->setFriendId($fbFriendId);
try {
$friend->insertIntoDatabase(DBUtils::getConnection());
} catch (Exception $exc) {
error_log("userclass>checkFriends userId : " . $this->userId . " friend Id : " . $fbFriendId . " Error : " . $exc->getMessage() . " Trace :" . $exc->getTraceAsString());
}
}
}
}
}
}
}
}
$log->logInfo("user > checkFriends > end userId : " . $this->userId);
}
public static function getDAU($sDate, $eDate)
{
$SQL = "SELECT count(distinct " . TBL_GAME_USER_LOGIN_LOG . ".userId) as count_ FROM " . TBL_GAME_USER_LOGIN_LOG . "," . TBL_GAME_USERS . " WHERE " . TBL_GAME_USER_LOGIN_LOG . ".userId NOT IN(" . ADMIN_EXCEPT_USERS . ") AND " . TBL_GAME_USER_LOGIN_LOG . ".time BETWEEN " . $sDate . " AND " . $eDate . " AND " . TBL_GAME_USER_LOGIN_LOG . ".userId=" . TBL_GAME_USERS . ".userId AND " . TBL_GAME_USERS . ".registerDate<" . $sDate;
$query = mysql_query($SQL, DBUtils::getManualConnection());
$count = 0;
if (!empty($query)) {
$db_field = mysql_fetch_assoc($query);
if (isset($db_field["count_"])) {
$count = $db_field["count_"];
}
}
return $count;
}
public static function getTotalCount()
{
$SQL = "SELECT COUNT(*) as total FROM " . TBL_GAME_USER_FEEDBACK;
$query = mysql_query($SQL, DBUtils::getManualConnection());
if (!empty($query)) {
while ($db_field = mysql_fetch_assoc($query)) {
if (!empty($db_field["total"])) {
return $db_field["total"];
}
}
}
return 0;
}
public static function updateUserImage($userId)
{
$result = new FunctionResult();
$result->success = false;
if (!empty($userId)) {
$user = GameUsers::getGameUserById($userId);
if (!empty($user)) {
$tmpImgPath = UserProfileImageUtils::downloadFBProfileImage($user->facebookId);
$profileImageUrl = null;
if (!empty($tmpImgPath)) {
try {
$s3 = new S3(AWS_API_KEY, AWS_SECRET_KEY);
$s3->setEndpoint(AWS_S3_ENDPOINT);
$imageName = "pi_" . $userId . ".png";
$s3Name = "profile.images/" . $userId . "/" . $imageName;
$res = $s3->putObjectFile($tmpImgPath, AWS_S3_BUCKET, $s3Name, S3::ACL_PUBLIC_READ);
if ($res) {
$profileImageUrl = 'http://' . AWS_S3_BUCKET . '.s3.amazonaws.com/' . $s3Name;
try {
unlink($tmpImgPath);
} catch (Exception $exc) {
error_log($exc->getTraceAsString());
}
} else {
$result->result = json_encode($res);
}
} catch (Exception $exc) {
$result->result = $exc->getTraceAsString();
}
} else {
$profileImageUrl = USER_DEFAULT_IMAGE_URL;
}
if (!empty($profileImageUrl)) {
$user->setProfilePicture($profileImageUrl);
try {
$user->updateToDatabase(DBUtils::getConnection());
$result->success = true;
$result->result = null;
} catch (Exception $exc) {
$result->result = $exc->getTraceAsString();
}
}
} else {
$result->result = "user not found";
}
} else {
$result->result = "user id empty";
}
return $result;
}
public static function useRequest($id, $used = 1)
{
if (!empty($id)) {
try {
$req = GameFbRequest::findById(DBUtils::getConnection(), $id);
if (!empty($req)) {
$req->setUsed($used);
$req->setUsedTime(time());
$req->updateToDatabase(DBUtils::getConnection());
}
} catch (Exception $exc) {
error_log($exc->getTraceAsString());
}
}
}
public static function edit($aboutusId, $content)
{
$pdo = new DBUtils();
$sql = "update aboutus set content='{$content}' where aboutusId = '{$aboutusId}'";
$rs = $pdo->update($sql);
return $rs;
}
