<?php
/*
Viscacha - A bulletin board solution for easily managing your content
Copyright (C) 2004-2009 The Viscacha Project
Author: Matthias Mohr (et al.)
Publisher: The Viscacha Project, http://www.viscacha.org
Start Date: May 22, 2004
This program is free software; you can redistribute it and/or modify
it under the terms of the GNU General Public License as published by
the Free Software Foundation; either version 2 of the License, or
(at your option) any later version.
This program is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with this program; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
error_reporting(E_ALL);
define('SCRIPTNAME', 'popup');
define('VISCACHA_CORE', '1');
include ("data/config.inc.php");
include ("classes/function.viscacha_frontend.php");
($code = $plugins->load('popup_start')) ? eval($code) : null;
if ($_GET['action'] == "filetypes") {
($code = $plugins->load('popup_filetypes_query')) ? eval($code) : null;
if (empty($_GET['type'])) {
error($lang->phrase('query_string_error'), 'javascript:self.close();');
}
$result = $db->query("SELECT * FROM {$db->pre}filetypes WHERE extension LIKE '%{$_GET['type']}%'");
$nr = $db->num_rows($result);
$cache = array();
while ($row = $db->fetch_assoc($result)) {
$row['extension'] = str_replace(',', ', ', $row['extension']);
$cache[] = $row;
}
echo $tpl->parse("popup/header");
($code = $plugins->load('popup_filetypes_prepared')) ? eval($code) : null;
echo $tpl->parse("popup/filetypes");
($code = $plugins->load('popup_filetypes_end')) ? eval($code) : null;
}
elseif ($_GET['action'] == "showpost") {
echo $tpl->parse("popup/header");
$sql_select = iif($config['pm_user_status'] == 1, ", IF (s.mid > 0, 1, 0) AS online");
$sql_join = iif($config['pm_user_status'] == 1, "LEFT JOIN {$db->pre}session AS s ON s.mid = u.id");
($code = $plugins->load('popup_showpost_query')) ? eval($code) : null;
$result = $db->query("
SELECT
t.status, t.prefix,
r.topic_id, r.board, r.edit, r.dosmileys, r.dowords, r.id, r.topic, r.comment, r.date, r.name as gname, r.email as gmail, r.guest,
u.id as mid, u.name as uname, u.mail, u.regdate, u.fullname, u.hp, u.signature, u.location, u.gender, u.birthday, u.pic, u.lastvisit, u.icq, u.yahoo, u.aol, u.msn, u.jabber, u.skype, u.groups,
f.* {$sql_select}
FROM {$db->pre}replies AS r
LEFT JOIN {$db->pre}user AS u ON r.name = u.id AND r.guest = '0'
LEFT JOIN {$db->pre}topics AS t ON t.id = r.topic_id
LEFT JOIN {$db->pre}userfields AS f ON u.id = f.ufid AND r.guest = '0'
{$sql_join}
WHERE r.id = '{$_GET['id']}'
LIMIT 1
");
$found = $db->num_rows($result);
if ($found == 1) {
$row = $slog->cleanUserData($db->fetch_object($result));
$my->p = $slog->Permissions($row->board);
if (empty($row->topic_id)) {
$row->topic_id = $row->id;
}
}
$error = array();
if ($found == 0) {
$error[] = $lang->phrase('query_string_error');
}
if ($found == 1 && $my->p['forum'] == 0) {
$error[] = $lang->phrase('not_allowed');
}
if (count($error) > 0) {
errorLogin($error,'javascript:self.close();');
}
$catbid = $scache->load('cat_bid');
$fc = $catbid->get();
$last = $fc[$row->board];
forum_opt($last);
($code = $plugins->load('popup_showpost_start')) ? eval($code) : null;
if ($config['tpcallow'] == 1) {
$uploads = $db->query("SELECT id, tid, mid, file, source, hits FROM {$db->pre}uploads WHERE tid = ".$_GET['id']);
}
$inner['upload_box'] = '';
// Custom Profile Fields
include_once('classes/class.profilefields.php');
$pfields = new ProfileFieldViewer($row->mid);
$pfields->setUserData($row);
if ($row->guest == 0) {
$row->mail = '';
$row->name = $row->uname;
}
else {
$row->mail = $row->gmail;
$row->name = $row->gname;
$row->mid = 0;
$row->groups = GROUP_GUEST;
}
$new = iif($row->date >= $my->clv, 'new', 'old');
BBProfile($bbcode);
$bbcode->setSmileys($row->dosmileys);
if ($config['wordstatus'] == 0) {
$row->dowords = 0;
}
$bbcode->setReplace($row->dowords);
$bbcode->setAuthor($row->mid);
if ($row->status == 2) {
$row->comment = $bbcode->ReplaceTextOnce($row->comment, 'moved');
}
$row->comment = $bbcode->parse($row->comment);
if ($my->opt_showsig == 1) {
BBProfile($bbcode, 'signature');
$row->signature = $bbcode->parse($row->signature);
}
if ($config['post_user_status'] == 1) {
$row->lang_online = $lang->phrase('profile_'.iif($row->online == 1, 'online', 'offline'));
}
$row->date = str_date($lang->phrase('dformat1'), times($row->date));
$row->regdate = gmdate($lang->phrase('dformat2'), times($row->regdate));
$row->level = $slog->getStatus($row->groups, ', ');
if (empty($row->location)) {
$row->location = $lang->phrase('showtopic_na');
}
if ($row->groups != NULL && ((!empty($row->fullname) && $config['fullname_posts'] == 1) || (!empty($row->signature) && $my->opt_showsig == 1))) {
$bottom = TRUE;
}
else {
$bottom = FALSE;
}
if ($config['tpcallow'] == 1 && $db->num_rows($uploads) > 0) {
while ($file = $db->fetch_assoc($uploads)) {
$uppath = 'uploads/topics/'.$file['source'];
$fsize = filesize($uppath);
$fsize = formatFilesize($fsize);
($code = $plugins->load('popup_showpost_attachments_prepared')) ? eval($code) : null;
$inner['upload_box'] .= $tpl->parse("popup/showpost_upload");
}
}
$edit = array();
if (!empty($row->edit)) {
preg_match_all('~^([^\t]+)\t(\d+)\t([^\t]*)\t([\d\.]+)$~m', $row->edit, $edits, PREG_SET_ORDER);
BBProfile($bbcode);
foreach ($edits as $e) {
$edit[] = array(
$e[1],
gmdate($lang->phrase('dformat1'), times($e[2])),
empty($e[3]) ? $lang->phrase('post_editinfo_na') : $bbcode->wordwrap($e[3]),
empty($e[4]) ? '-' : $e[4]
);
}
$anz = count($edit);
if ($anz == 0) {
$row->edit = null;
}
$lastdata = end($edit);
if ($lastdata != false) {
list(, $date, $why, ) = $lastdata;
}
}
($code = $plugins->load('popup_showpost_prepared')) ? eval($code) : null;
echo $tpl->parse("popup/showpost");
($code = $plugins->load('popup_showpost_end')) ? eval($code) : null;
}
elseif ($_GET['action'] == "edithistory") {
echo $tpl->parse("popup/header");
($code = $plugins->load('popup_edithistory_query')) ? eval($code) : null;
$result = $db->query("
SELECT r.ip, r.topic_id, r.board, r.edit, r.id, r.topic, r.date, u.name as uname, r.name as gname, u.id as mid, u.groups, r.email as gmail, r.guest
FROM {$db->pre}replies AS r
LEFT JOIN {$db->pre}user AS u ON r.name = u.id AND r.guest = '0'
WHERE r.id = '{$_GET['id']}'
LIMIT 1
");
$found = $db->num_rows($result);
if ($found == 1) {
$row = $gpc->prepare($db->fetch_assoc($result));
$my->p = $slog->Permissions($row['board']);
}
$error = array();
if ($found == 0) {
$error[] = $lang->phrase('query_string_error');
}
if ($found == 1 && $my->p['forum'] == 0) {
$error[] = $lang->phrase('not_allowed');
}
if (count($error) > 0) {
errorLogin($error,'javascript:self.close();');
}
$catbid = $scache->load('cat_bid');
$fc = $catbid->get();
$last = $fc[$row['board']];
forum_opt($last);
($code = $plugins->load('popup_edithistory_start')) ? eval($code) : null;
if ($row['guest'] == 0) {
$row['mail'] = '';
$row['name'] = $row['uname'];
}
else {
$row['mail'] = $row['gmail'];
$row['name'] = $row['gname'];
$row['mid'] = 0;
$row['groups'] = GROUP_GUEST;
}
$row['date'] = str_date($lang->phrase('dformat1'), times($row['date']));
$edit = array();
if (!empty($row['edit'])) {
preg_match_all('~^([^\t]+)\t(\d+)\t([^\t]*)\t([\d\.]+)$~m', $row['edit'], $edits, PREG_SET_ORDER);
foreach ($edits as $e) {
$edit[] = array(
'date' => str_date($lang->phrase('dformat1'), times($e[2])),
'reason' => empty($e[3]) ? $lang->phrase('post_editinfo_na') : $e[3],
'name' => $e[1],
'ip' => empty($e[4]) ? '-' : $e[4]
);
($code = $plugins->load('popup_edithistory_entry_prepared')) ? eval($code) : null;
}
}
($code = $plugins->load('popup_edithistory_prepared')) ? eval($code) : null;
echo $tpl->parse("popup/edithistory");
($code = $plugins->load('popup_edithistory_end')) ? eval($code) : null;
}
elseif ($_GET['action'] == "postrating") {
$rtg = $gpc->get('rating', int);
($code = $plugins->load('popup_postrating_start')) ? eval($code) : null;
if ($my->vlogin) {
$result = $db->query("SELECT * FROM {$db->pre}replies WHERE id = '{$_GET['id']}'");
$post = $db->fetch_assoc($result);
if ($post['name'] == $my->id) {
$error = $lang->phrase('postrating_you_posted');
}
$result = $db->query("
SELECT mid, pid, tid, rating
FROM {$db->pre}postratings
WHERE mid = '{$my->id}' AND pid = '{$_GET['id']}'
");
$rating = $db->fetch_assoc($result);
$rating['rating'] = intval($rating['rating']);
if ($post['name'] != $my->id) {
if (!empty($rtg) && $rating['rating'] != 1 && $rating['rating'] != -1) {
$result = $db->query("SELECT topic_id, name, email, guest FROM {$db->pre}replies WHERE id = '{$_GET['id']}'");
$topic = $db->fetch_assoc($result);
if ($topic['guest'] == 0) {
$aid = $topic['name'];
}
else {
$aid = 0;
}
$db->query("INSERT INTO {$db->pre}postratings SET aid = '{$aid}', mid = '{$my->id}', pid = '{$_GET['id']}', tid = '{$topic['topic_id']}', rating = '{$rtg}'");
$rating = array(
'rating' => $rtg,
'pid' => $_GET['id'],
'tid' => $_GET['topic_id'],
'mid' => $my->id
);
}
if ($db->affected_rows() != 1) {
$error = $lang->phrase('unknown_error');
}
elseif ($rating['rating'] == 1) {
$error = $lang->phrase('postrating_rated_positive');
}
elseif ($rating['rating'] == -1) {
$error = $lang->phrase('postrating_rated_negative');
}
else {
$error = $lang->phrase('query_string_error');
}
}
}
else {
$error = $lang->phrase('log_not_logged');
}
echo $tpl->parse("popup/header");
($code = $plugins->load('popup_postrating_prepared')) ? eval($code) : null;
echo $tpl->parse("popup/postrating");
($code = $plugins->load('popup_postrating_end')) ? eval($code) : null;
echo $tpl->parse("popup/footer");
}
($code = $plugins->load('popup_end')) ? eval($code) : null;
$slog->updatelogged();
$zeitmessung = t2();
echo $tpl->parse("popup/footer");
$phpdoc->Out();
$db->close();
?>