/*$Id: byuser.php 814 2012-10-16 13:28:15Z dmitriy $*/
require_once 'head_inc.php';
$cur_page = $page_byuser;
$how_many = 50;
$max_id = 1;
$last_id = 0;
$query = 'SELECT count(*) from confa_posts where author=' . $author_id . ' and status != 2';
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$row = mysql_fetch_row($result);
$count = $row[0];
$last_id = get_page_last_index('confa_posts where author=' . $author_id, $how_many, $page);
$query = 'SELECT u.username, u.moder, p.auth, p.closed as post_closed, CONVERT_TZ(p.created, \'' . $server_tz . '\', \'' . $prop_tz . ':00\') as created, p.subject, p.status, p.id as msg_id, p.chars from confa_posts p, confa_users u where p.author=' . $author_id . ' and p.author=u.id and p.status != 2 and p.id <= ' . $last_id . ' order by msg_id desc limit 50';
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$num = 1;
$out = '';
if (mysql_num_rows($result) == 0) {
$max_id = $last_id;
}
while ($row = mysql_fetch_assoc($result)) {
$msg_id = $row['msg_id'];
$u_moder = $row['moder'];
$subj = $row['subject'];
}
$where = '';
$where_author = '';
if (!is_null($author_id)) {
$where_author = 'p.author=' . $author_id . ' and ';
$where = ' and author=' . $author_id;
}
$query = 'SELECT count(*) from confa_posts where ' . $subquery . $where;
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$row = mysql_fetch_row($result);
$count = $row[0];
$last_id = get_page_last_index(' confa_posts where ' . $subquery . $where, $how_many, $page);
if (is_null($last_id) || strlen($last_id) == 0) {
$last_id = 0;
}
$query = 'SELECT u.username, u.moder, p.auth, p.closed as post_closed, CONVERT_TZ(p.created, \'' . $server_tz . '\', \'EST\') as created, p.subject, p.status, p.id as msg_id, p.chars from confa_posts p, confa_users u where ' . $where_author . ' p.author=u.id and p.' . $subquery . ' and p.id <= ' . $last_id . ' order by msg_id desc limit 50';
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$num = 1;
$out = '';
if (mysql_num_rows($result) == 0) {
$max_id = $last_id;
}
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
die;
}
$cur_page = $page_pmail;
$how_many = 20;
$max_id = 1;
$last_id = 0;
$search_condition = 'receiver=' . $user_id . ' and !(p.status &' . $pm_deleted_by_receiver . ')';
$query = 'SELECT count(*) from confa_pm p where ' . $search_condition;
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$row = mysql_fetch_row($result);
$count = $row[0];
$last_id = get_page_last_index('confa_pm p where ' . $search_condition, $how_many, $page);
if (is_null($last_id)) {
$last_id = 1;
}
$query = 'SELECT s.username as sender_name, p.id as id, p.sender, p.receiver, p.subject, p.body, CONVERT_TZ(p.created, \'' . $server_tz . '\', \'' . $prop_tz . ':00\') as created, p.status, p.chars from confa_pm p, confa_users s where p.sender=s.id and ' . $search_condition . ' and p.id <= ' . $last_id . ' order by id desc limit 20';
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$num = 1;
$out = '';
if (mysql_num_rows($result) == 0) {
$max_id = $last_id;
}
$auth_text = '';
}
$how_many = 50;
$max_id = 1;
$last_id = 0;
$query = 'SELECT count(*) from confa_bookmarks where user='******'query failed ' . mysql_error() . ' QUERY: ' . $query);
die(' Query failed ');
}
$row = mysql_fetch_row($result);
$count = $row[0];
if (is_null($page)) {
$page = 1;
}
$last_id = get_page_last_index('confa_bookmarks where user='******'SELECT u.username, u.moder, p.auth, p.closed as post_closed, CONVERT_TZ(p.created, \'' . $server_tz . '\', \'EST\') as created, p.subject, p.content_flags, p.views, p.likes, p.dislikes, p.status, p.id as msg_id, p.chars, b.user, b.post from confa_posts p, confa_users u, confa_bookmarks b where b.user='******' and b.post=p.id and p.author=u.id and p.status != 2 and b.id <= ' . $last_id . ' order by msg_id desc limit 50';
$result = mysql_query($query);
if (!$result) {
mysql_log(__FILE__, 'query failed ' . mysql_error() . ' QUERY: ' . $query);
die('Query failed ');
}
$num = 1;
$out = '';
if (mysql_num_rows($result) == 0) {
$max_id = $last_id;
}
while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {