aboutsummaryrefslogtreecommitdiffstats
path: root/toj/php/notice.inc.php
diff options
context:
space:
mode:
Diffstat (limited to 'toj/php/notice.inc.php')
-rwxr-xr-xtoj/php/notice.inc.php244
1 files changed, 0 insertions, 244 deletions
diff --git a/toj/php/notice.inc.php b/toj/php/notice.inc.php
deleted file mode 100755
index dbf47cc..0000000
--- a/toj/php/notice.inc.php
+++ /dev/null
@@ -1,244 +0,0 @@
-<?php
-require_once('common.inc.php');
-require_once('user.inc.php');
-
-const NOTICE_DEF_LIM = 5;
-const NOTICE_MAX_LIM = 30;
-
-const NOTICE_ACT_CNT = 1;
-const NOTICE_ACT_NEW = 2;
-const NOTICE_ACT_OLD = 4;
-
-const NOTICE_TYP_USR = 1;
-const NOTICE_TYP_PRO = 2;
-const NOTICE_TYP_SQR = 3;
-const NOTICE_TYP_ALL = 255;
-
-class notice
-{
- private static function ins_uid($sqlc, $uid)
- {
- $sqlstr = 'INSERT INTO "notice_cache" ("uid", "tim", "cnt", "tmp", "rsv") VALUES ($1, $2, $3, $4, $5) RETURNING *;';
- $sqlarr = array($uid, date("Y-m-d H:i:s"), 0, "0", "0");
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $ret = pg_fetch_object($sqlr);
- pg_free_result($sqlr);
- return $ret;
- }
-
- public static function is_match($sqlc, $uid, &$not)
- {
- if($not->typ == NOTICE_TYP_ALL)
- {
- return true;
- }
- if($not->typ == NOTICE_TYP_USR)
- {
- return $uid == intval($not->val);
- }
- require_once('event.inc.php');
- if($not->typ == NOTICE_TYP_PRO)
- {
- if(!event::exec_func('problem.inc.php', 'problem::is_available', array($sqlc, $not->val, $uid)))
- {
- return false;
- }
- return true;
- }
- else if($not->typ == NOTICE_TYP_SQR)
- {
- $ret = event::exec_func('square.inc.php', 'square::get_user_relationship', array($sqlc, $uid, $not->val));
- if($ret >= SQUARE_USER_ACTIVE)
- {
- return true;
- }
- return false;
- }
- return false;
- }
-
- private static function update($sqlc, $uid, &$tar, &$arr)
- {
- if(count($arr) <= 0)
- {
- return false;
- }
- $sqlstr = 'UPDATE "notice_cache" SET "tmp"=$1, "cnt"=$2, "tim"=$4 WHERE "uid"=$3 RETURNING *;';
- $sqlarr = array($arr[0], intval($tar->cnt)+count($arr), $uid, date('Y-m-d H:i:s'));
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $ret = pg_fetch_object($sqlr);
- pg_free_result($sqlr);
- foreach($arr as $it)
- {
- $sqlstr = 'INSERT INTO "user_notice" ("uid", "nid") VALUES ($1, $2);';
- $sqlarr = array(intval($uid), intval($it));
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- pg_free_result($sqlr);
- }
- return $ret;
- }
-
- private static function check_new($sqlc, $uid)
- {
- $sqlstr = 'SELECT * FROM "notice_cache" WHERE "uid"=$1;';
- $sqlarr = array($uid);
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $ret = pg_fetch_object($sqlr);
- if($ret === false)
- {
- $ret = notice::ins_uid($sqlc, $uid);
- }
- pg_free_result($sqlr);
- $sqlstr = 'SELECT * FROM "notice" WHERE "nid" > $1 ORDER BY "tim";';
- $sqlarr = array(intval($ret->tmp));
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $buf = array();
- while($row = pg_fetch_object($sqlr))
- {
- if(self::is_match($sqlc, $uid, $row))
- {
- array_unshift($buf, $row->nid);
- }
- }
- pg_free_result($sqlr);
- if(count($buf) > 0)
- {
- return self::update($sqlc, $uid, $ret, $buf);
- }
- return $ret;
- }
-
- // **warning**: this function will clear notice count of uid!!
- public static function get($sqlc, $uid, $typ, $arg1, $arg2)
- {
- $uid = intval($uid);
- if(!$uid || !$sqlc)
- {
- return false;
- }
- $ret = self::check_new($sqlc, $uid);
- if($typ == NOTICE_ACT_CNT)
- {
- return intval($ret->cnt);
- }
- else if($typ == NOTICE_ACT_NEW)
- {
- if($ret->cnt == 0)
- {
- return array();
- }
- $sqlstr = 'SELECT "nid" FROM "user_notice" WHERE "uid"=$1 AND "nid">$2 ORDER BY "nid" DESC';
- $sqlarr = array($uid, intval($ret->rsv));
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $nids = array();
- while($it=pg_fetch_array($sqlr))
- {
- $nids[] = $it[0];
- }
- $sqlstr = 'SELECT * FROM "notice" WHERE "nid" IN ('.join($nids, ",").') ORDER BY "tim";';
- $sqlr = pg_query($sqlc, $sqlstr);
- $buf = array();
- while($it = pg_fetch_object($sqlr))
- {
- $it->nid = intval($it->nid);
- $it->typ = intval($it->typ);
- $buf[] = $it;
- }
- pg_free_result($sqlr);
- $sqlstr = 'UPDATE "notice_cache" SET "cnt"=0, "rsv"=$2 WHERE "uid"=$1;';
- $sqlarr = array($uid, $nids[0]);
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- return $buf;
- }
- else if($typ == NOTICE_ACT_OLD)
- {
- if($arg2 <= 0)
- {
- $arg2 = 1;
- }
- if($arg2 > NOTICE_MAX_LIM)
- {
- $arg2 = NOTICE_MAX_LIM;
- }
- $sqlstr = 'SELECT "nid" FROM "user_notice" WHERE "uid"=$1 AND "nid"<$2 ORDER BY "nid" DESC LIMIT $3';
- $sqlarr = array($uid, $arg1, $arg2);
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $nids = array();
- while($it=pg_fetch_array($sqlr))
- {
- $nids[] = $it[0];
- }
- $sqlstr = 'SELECT * FROM "notice" WHERE "nid" IN ('.join($nids, ",").') ORDER BY "tim";';
- $sqlr = pg_query($sqlc, $sqlstr);
- $buf = array();
- while($it = pg_fetch_object($sqlr))
- {
- $it->nid = intval($it->nid);
- $it->typ = intval($it->typ);
- $buf[] = $it;
- }
- pg_free_result($sqlr);
- return $buf;
- }
- return false;
- }
-
- public static function clr($sqlc, $uid, $lim=NOTICE_DEF_LIM)
- {
- return false;
- if($lim < 0)
- {
- $lim = 0;
- }
- $ret = self::check_new($sqlc, $uid);
- $buf = preg_split("/[,]/", $ret->tmp);
- $buf = array_slice($buf, 0, $ret->cnt+$lim);
- $sqlstr = 'UPDATE "notice_cache" SET "tmp"=$1 WHERE "uid"=$2;';
- $sqlarr = array(join($buf, ","), $uid);
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- if($sqlr)
- {
- return count($buf);
- }
- return false;
- }
-
- // you can add notice by calling it.
- public static function add($sqlc, $typ, $val, $txt)
- {
- if(!is_string($val))
- {
- $val = json_encode($val);
- }
- $sqlstr = 'INSERT INTO "notice" ("typ", "val", "txt", "tim") VALUES ($1, $2, $3, $4) RETURNING *;';
- $sqlarr = array($typ, $val, $txt, date('Y-m-d H:i:s'));
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $ret = pg_fetch_object($sqlr);
- if($ret === false)
- {
- return false;
- }
- return json_encode($ret);
- }
-
- public static function del($sqlc, $cond)
- {
- $sqlstr = 'DELETE FROM "notice" WHERE 0';
- if(isset($cond['nid']))
- {
- $sqlstr .= ' OR "nid"=$1';
- }
- if(isset($cond['tim']))
- {
- $sqlstr .= ' OR "tim" >= $2';
- }
- $sqlarr = array($cond['nid'], $cond['tim']);
- $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
- if(!$sqlr)
- {
- return false;
- }
- return true;
- }
-}
-?>
generated by cgit v1.2.3 (git 2.25.1) at 2024-06-29 05:06:24 +0800