function execute($params)
{
$action = $params->action;
$itemId = intval($params->itemId);
$loginId = intval($params->loginId);
$name = $params->name;
if (empty($action) || empty($itemId) || empty($loginId) || empty($name)) {
$message = "Bad input: missing required parameters.";
$response = array("code" => 500, "message" => $message);
return $response;
}
$bookmarkDao = new \com\indigloo\sc\dao\Bookmark();
$postDao = new \com\indigloo\sc\dao\Post();
$postId = PseudoId::decode($itemId);
$postDBRow = $postDao->getOnId($postId);
$title = $postDBRow["title"];
$ownerId = $postDBRow["login_id"];
$code = 200;
switch ($action) {
case UIConstants::LIKE_POST:
$bookmarkDao->like($ownerId, $loginId, $name, $itemId, $title);
$message = sprintf(" Success! Like for item %s done.", $title);
break;
default:
break;
}
$response = array("code" => $code, "message" => $message);
return $response;
}
function process($params, $options)
{
$qparams = Url::getRequestQueryParams();
$gpage = Url::tryQueryParam("gpage");
$gpage = empty($gpage) ? "1" : $gpage;
$redis = new redis\Activity();
$pageSize = Config::getInstance()->get_value("main.page.items");
$paginator = new \com\indigloo\ui\Pagination($qparams, $pageSize);
$zsetKey = Nest::score("post", "likes");
$members = $redis->getPagedZSet($zsetKey, $paginator);
//first one is id, second one is score
$count = 0;
$scores = array();
$ids = array();
for ($i = 1; $i < sizeof($members); $i++) {
if ($i % 2 == 0) {
array_push($scores, $members[$i - 1]);
} else {
$itemId = $members[$i - 1];
$postId = PseudoId::decode($itemId);
array_push($ids, $postId);
}
}
//get post rows using ids
$postDao = new \com\indigloo\sc\dao\Post();
$postDBRows = $postDao->getOnSearchIds($ids);
$pageHeader = 'Most popular';
$pageBaseUrl = '/pub/popular';
$pageTitle = SeoData::getPageTitleWithNumber($gpage, "popular items");
$metaKeywords = SeoData::getHomeMetaKeywords();
$metaDescription = SeoData::getMetaDescriptionWithNumber($gpage, "popular items");
$file = APP_WEB_DIR . '/view/tiles-page.php';
include $file;
}
function process($params, $options)
{
if (is_null($params) || empty($params)) {
$controller = new \com\indigloo\sc\controller\Http400();
$controller->process();
exit;
}
$plistId = Util::getArrayKey($params, "list_id");
$listId = PseudoId::decode($plistId);
$qparams = Url::getRequestQueryParams();
$gpage = Url::tryQueryParam("gpage");
$gpage = empty($gpage) ? "1" : $gpage;
//@todo input check
// people can type all sort of input garbage
settype($listId, "int");
$listDao = new \com\indigloo\sc\dao\Lists();
$listDBRow = $listDao->getOnId($listId);
if (empty($listDBRow)) {
//not found
$controller = new \com\indigloo\sc\controller\Http404();
$controller->process();
exit;
}
$listName = $listDBRow["name"];
$listPubUrl = sprintf("%s/pub/list/%d/%s", Url::base(), $plistId, $listDBRow["seo_name"]);
//get items from sc_list_item table
$model = new \com\indigloo\sc\model\ListItem();
$filter = new Filter($model);
$filter->add($model::LIST_ID, Filter::EQ, $listId);
$pageSize = Config::getInstance()->get_value("user.page.items");
$filters = array();
array_push($filters, $filter);
$paginator = new \com\indigloo\ui\Pagination($qparams, $pageSize);
$itemDBRows = $listDao->getPagedItems($paginator, $filters);
$loginId = $listDBRow["login_id"];
$userDao = new \com\indigloo\sc\dao\User();
$userDBRow = $userDao->getOnLoginId($loginId);
$template = APP_WEB_DIR . '/view/list/pub.php';
//page variables
$pageBaseUrl = $listPubUrl;
$pageTitle = sprintf("page %d of %s", $gpage, $listDBRow["name"]);
$description = Util::abbreviate($listDBRow["description"], 160);
$metaDescription = SeoData::thisOrHomeDescription($description);
$metaKeywords = SeoData::getHomeMetaKeywords();
include $template;
}
}
printf("\n\n");
/*
Do not select items that were liked but deleted in the iterim
select subject_id, object_id, verb from sc_bookmark b,sc_post p
where b.object_id = p.pseudo_id and b.verb = 1 ;
*/
$sql = "select subject_id, object_id from sc_bookmark b,sc_post p ";
$sql .= " where b.object_id = p.pseudo_id and b.verb = 1 ";
$rows = MySQL\Helper::fetchRows($mysqli, $sql);
$t11 = " update sc_user_counter set like_count = like_count + 1 where login_id = %s ; ";
$t21 = " update sc_post_counter set like_count = like_count + 1 where post_id = %s ; ";
foreach ($rows as $row) {
$t1sql = sprintf($t11, $row["subject_id"]);
//sc_bookmark.object_id is pseudo_id
$postId = PseudoId::decode($row["object_id"]);
$t2sql = sprintf($t21, $postId);
printf("%s \n", $t1sql);
printf("%s \n", $t2sql);
}
printf("\n\n");
/* no concept of deleting the user in system as on 22 nov. 2012 */
$sql = " select follower_id, following_id from sc_follow ";
$rows = MySQL\Helper::fetchRows($mysqli, $sql);
$t1 = " update sc_user_counter set follower_count = follower_count + 1 where login_id = %s ; ";
$t2 = " update sc_user_counter set following_count = following_count + 1 where login_id = %s ; ";
foreach ($rows as $row) {
$t1sql = sprintf($t1, $row["following_id"]);
$t2sql = sprintf($t2, $row["follower_id"]);
printf("%s \n", $t1sql);
printf("%s \n", $t2sql);
function getPostFeed($row)
{
$postDao = new \com\indigloo\sc\dao\Post();
$itemId = $row["object_id"];
$postId = PseudoId::decode($itemId);
$image = $postDao->getImageOnId($postId);
$feedVO = new \stdClass();
$feedVO->subject = $row["subject"];
$feedVO->subjectId = $row["subject_id"];
$feedVO->object = "post";
$feedVO->objectId = $row["object_id"];
$feedVO->title = $row["object"];
$feedVO->verb = $row["verb"];
$feedVO->srcImage = $image["thumbnail"];
$feedVO->nameImage = $image["name"];
$feed = json_encode($feedVO);
if ($feed === FALSE || $feed == 'null' || $feed == 'NULL') {
//encoding went wrong
$message = sprintf("problem with encoding activity row %d ", $row["id"]);
trigger_error($message, E_USER_ERROR);
}
return $feed;
}
break;
default:
$sortVariable = "likes";
}
$zsetKey = Nest::score("post", $sortVariable);
$members = $redis->getPagedZSet($zsetKey, $paginator);
$count = 0;
$scores = array();
$ids = array();
if (sizeof($members) >= 2) {
for ($i = 1; $i < sizeof($members); $i++) {
// odd ones are members
// evens are scores
if ($i % 2 != 0) {
$itemId = $members[$i - 1];
$postId = PseudoId::decode($itemId);
array_push($ids, $postId);
//score is next one
$scores[$itemId] = isset($members[$i]) ? $members[$i] : 0;
}
}
}
$rows = $postDao->getOnSearchIds($ids);
$pageNo = $paginator->getPageNo();
$startId = ($pageNo - 1) * $pageSize;
$endId = $startId + $pageSize - 1;
$rowsHtml = "";
$gNumRecords = sizeof($rows);
foreach ($rows as $row) {
$score = isset($scores[$row["pseudo_id"]]) ? $scores[$row["pseudo_id"]] : 0;
$rowsHtml .= \com\indigloo\sc\html\Post::getAdminWidget($row, $score);
break;
case "tainted":
$filter = new Filter($model);
$filter->add($model::TAINTED, Filter::EQ, 1);
array_push($filters, $filter);
$ftname = "Tainted";
break;
case "name":
$filter = new Filter($model);
$filter->add($model::USER_NAME, Filter::LIKE, $gtoken);
array_push($filters, $filter);
$ftname = "name:" . $gtoken;
break;
case "user":
$filter = new Filter($model);
$loginId = PseudoId::decode($userId);
$filter->add($model::LOGIN_ID, Filter::EQ, $loginId);
array_push($filters, $filter);
$ftname = "user:"******"user.page.items");
$total = $userDao->getTotal($filters);
$paginator = new \com\indigloo\ui\Pagination($qparams, $pageSize);
$userDBRows = $userDao->getPaged($paginator, $filters);
$gtoken = "";
use com\indigloo\sc\auth\Login;
use com\indigloo\ui\form\Message as FormMessage;
use com\indigloo\ui\form\Sticky;
use com\indigloo\ui\Filter;
use com\indigloo\sc\util\PseudoId;
$sticky = new Sticky($gWeb->find(Constants::STICKY_MAP, true));
$panelId = $sticky->get("panel_id");
$qparams = Url::getRequestQueryParams();
$gSessionLogin = \com\indigloo\sc\auth\Login::getLoginInSession();
$loginId = $gSessionLogin->id;
$loginName = $gSessionLogin->name;
if (is_null($loginId)) {
trigger_error("Error : NULL or invalid login_id", E_USER_ERROR);
}
$plistId = Url::getQueryParam("list_id");
$listId = PseudoId::decode($plistId);
settype($listId, "int");
$listDao = new \com\indigloo\sc\dao\Lists();
$listDBRow = $listDao->getOnId($listId);
$listName = $listDBRow["name"];
//list owner check
if (!Login::isOwner($listDBRow["login_id"])) {
header("Location: /site/error/403.html");
exit;
}
$listPubUrl = sprintf("%s/pub/list/%d/%s", Url::base(), $plistId, $listDBRow["seo_name"]);
//get items from sc_list_item table
$model = new \com\indigloo\sc\model\ListItem();
$filter = new Filter($model);
$filter->add($model::LIST_ID, Filter::EQ, $listId);
$pageSize = Config::getInstance()->get_value("user.page.items");
function process($params, $options)
{
if (is_null($params) || empty($params)) {
$controller = new \com\indigloo\sc\controller\Http400();
$controller->process();
exit;
}
$itemId = Util::getArrayKey($params, "item_id");
if ($itemId < 1200) {
//@todo remove permanent redirect
$redirectUrl = "/item/" . PseudoId::encode($itemId);
header("HTTP/1.1 301 Moved Permanently");
header("Location: " . $redirectUrl);
exit;
}
$postDao = new \com\indigloo\sc\dao\Post();
$postId = PseudoId::decode($itemId);
$postDBRow = $postDao->getOnId($postId);
if (empty($postDBRow)) {
//not found
$controller = new \com\indigloo\sc\controller\Http404();
$controller->process();
exit;
}
$options = array();
$options["group"] = true;
$postView = \com\indigloo\sc\html\Post::createPostView($postDBRow, $options);
// links is separate from postView for historical reasons
$linksJson = $postDBRow['links_json'];
$dblinks = json_decode($linksJson);
$links = array();
foreach ($dblinks as $link) {
$link = Url::addHttp($link);
array_push($links, $link);
}
/* data for facebook/google+ dialogs */
$itemObj = new \stdClass();
$itemObj->appId = Config::getInstance()->get_value("facebook.app.id");
$itemObj->host = Url::base();
/* google+ cannot redirect to local box */
$itemObj->netHost = "http://www.3mik.com";
$itemObj->callback = $itemObj->host . "/callback/fb-share.php";
if ($postView->hasImage) {
/* use original image for og snippets, smaller images may be ignored */
/* facebook and google+ dialogs need absolute URL */
$itemObj->picture = $postView->srcImage;
} else {
$itemObj->picture = $itemObj->host . "/css/asset/sc/logo.png";
}
//do not urlencode - as we use this value as canonical url
$itemObj->link = $itemObj->host . "/item/" . $itemId;
$itemObj->netLink = $itemObj->netHost . "/item/" . $itemId;
// title in DB is 128 chars long.
// here on page we want to use a 70 char title.
// also used in item images alt text
// item description should be 160 chars.
$itemObj->title = Util::abbreviate($postView->title, 70);
$itemObj->title = sprintf("item %s - %s", $itemId, $itemObj->title);
$itemObj->description = Util::abbreviate($postView->description, 160);
$itemObj->description = sprintf("item %s - %s by user %s", $itemId, $itemObj->description, $postView->userName);
$strItemObj = json_encode($itemObj);
//make the item json string form safe
$strItemObj = Util::formSafeJson($strItemObj);
/* likes data */
$bookmarkDao = new \com\indigloo\sc\dao\Bookmark();
$likeDBRows = $bookmarkDao->getLikeOnItemId($itemId);
$gWeb = \com\indigloo\core\Web::getInstance();
/* sticky is used by comment form */
$sticky = new Sticky($gWeb->find(Constants::STICKY_MAP, true));
$gRegistrationPopup = false;
$loginIdInSession = \com\indigloo\sc\auth\Login::tryLoginIdInSession();
//show registration popup
if (is_null($loginIdInSession)) {
$register_popup = $gWeb->find("sc:browser:registration:popup");
$register_popup = is_null($register_popup) ? false : $register_popup;
if (!$register_popup) {
$gRegistrationPopup = true;
$gWeb->store("sc:browser:registration:popup", true);
}
}
$group_slug = $postDBRow["group_slug"];
$groupDao = new \com\indigloo\sc\dao\Group();
$group_names = $groupDao->tokenizeSlug($group_slug, ",", true);
$pageTitle = $itemObj->title;
$metaKeywords = SeoData::getMetaKeywords($group_names);
$pageUrl = Url::base() . Url::current();
$file = APP_WEB_DIR . '/view/item.php';
include $file;
}
<?php
//sc/qa/comment/edit.php
include 'sc-app.inc';
include APP_WEB_DIR . '/inc/header.inc';
include APP_WEB_DIR . '/inc/role/user.inc';
use com\indigloo\Util;
use com\indigloo\Url;
use com\indigloo\ui\form\Sticky;
use com\indigloo\Constants;
use com\indigloo\ui\form\Message as FormMessage;
use com\indigloo\sc\auth\Login;
use com\indigloo\sc\util\PseudoId;
$sticky = new Sticky($gWeb->find(Constants::STICKY_MAP, true));
$encodedId = Url::getQueryParam("id");
$commentId = PseudoId::decode($encodedId);
$qUrl = Url::tryBase64QueryParam("q", "/");
$fUrl = Url::current();
$commentDao = new com\indigloo\sc\dao\Comment();
$commentDBRow = $commentDao->getOnId($commentId);
if (!(Login::isOwner($commentDBRow['login_id']) || Login::isAdmin())) {
header("Location: /site/error/403.html");
exit;
}
$sticky = new Sticky($gWeb->find(Constants::STICKY_MAP, true));
$itemId = PseudoId::encode($commentDBRow['post_id']);
?>
<!DOCTYPE html>
<html>
function getOnItemId($itemId)
{
$postId = PseudoId::decode($itemId);
$row = mysql\Post::getOnId($postId);
return $row;
}
function deleteItems($loginId, $listId, $itemsJson)
{
$items = json_decode($itemsJson);
//get all the itemIds
$itemIds = array();
foreach ($items as $item) {
$itemId = PseudoId::decode($item);
array_push($itemIds, $itemId);
}
if (empty($itemIds)) {
//@todo - throw error?
return;
}
mysql\Lists::deleteItems($loginId, $listId, $itemIds);
}
private function processLists($params, $options)
{
$pubUserId = Util::getArrayKey($params, "login_id");
$loginId = PseudoId::decode($pubUserId);
$qparams = Url::getRequestQueryParams();
$userDao = new \com\indigloo\sc\dao\User();
$userDBRow = $userDao->getOnLoginId($loginId);
$this->isValidUser($userDBRow);
$gpage = Url::tryQueryParam("gpage");
$gpage = empty($gpage) ? "1" : $gpage;
$listDao = new \com\indigloo\sc\dao\Lists();
$qparams = Url::getRequestQueryParams();
$pageSize = Config::getInstance()->get_value("user.page.items");
$paginator = new \com\indigloo\ui\Pagination($qparams, $pageSize);
$listDBRows = $listDao->getPagedOnLoginId($paginator, $loginId);
$template = APP_WEB_DIR . '/view/user/lists.php';
//page variables
$pageBaseUrl = "/pub/user/" . $pubUserId;
$pageTitle = sprintf("page %d of lists by %s", $gpage, $userDBRow["name"]);
$metaKeywords = SeoData::getHomeMetaKeywords();
$metaDescription = SeoData::getHomeMetaDescription();
include $template;
}
<?php
include 'sc-app.inc';
include APP_CLASS_LOADER;
use com\indigloo\sc\util\PseudoId;
if ($argc < 3) {
printf("Usage : {$php} change.php <pseudo_id> <password> \n");
exit;
}
$pseudoId = $argv[1];
$pseudoId = trim($pseudoId);
$password = $argv[2];
$loginId = PseudoId::decode($pseudoId);
//get email lookup on loginId
$userDao = new \com\indigloo\sc\dao\User();
$row = $userDao->getOnLoginId($loginId);
$email = $row["email"];
printf("change for login_id = %s, email = %s \n ", $loginId, $email);
$data = \com\indigloo\auth\User::changePassword("sc_user", $loginId, $email, $password);
