v7 Medaliu sistema
uzas123
parašyta 2010-07-29 13:33
Naujokas
Reputacija:
0 Pranešimai: 9
Įstojo: 2010-07-29
Sveiki, man iskilo problema irasant medaliu sistemos moda v7. Viskas normalei isirase bet nera failu tokiu kaip profile.php - kad rodytu medalius profilyje ir forume. Gal kas galetu pasidalinti siais failais, stai mano siusta medaliu sistema: http://phpfusion.lt/medaliu-sistema,m492
Labai busiu dekingas kas pades. ;)
Aciu nebereikia, galte trinti tema.
Redagavo uzas123 2010-07-29 14:37
ire
parašyta 2010-07-29 14:39
Savekas
Reputacija:
0 Pranešimai: 102
Įstojo: 2009-06-10
yra includes gi...
All you need is love
uzas123
parašyta 2010-07-29 14:50
Naujokas
Reputacija:
0 Pranešimai: 9
Įstojo: 2010-07-29
O gal galima butu suzinoti, kaip i foruma ikisti ? :) kad butu po avataru ?
csmacet
parašyta 2010-11-24 08:15
Naujokas
Reputacija:
0 Pranešimai: 1
Įstojo: 2010-11-23
pas mane ir tas pats
Wyciokazz
parašyta 2010-11-24 09:51
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
viewthread.php faila redaguoti.
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
mantenas
parašyta 2010-11-25 14:58
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
Na ,o b�tu malonu jaigu pasakytum ,kaip. Nes a? nesu �gudes su php tiek kiek j�s. U? pagalba tikrai b��iau d�kingas
Wyciokazz
parašyta 2010-11-25 15:52
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
idek savo viewthread nes daugelio jis skiriasi.
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
szarunas
parašyta 2010-11-25 17:55
Apšylantis
Reputacija:
0 Pranešimai: 85
Įstojo: 2009-12-25
Stai mano vyciokai gali perkoduoti? Code
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: viewthread.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once \"../maincore.php\";
require_once INCLUDES.\"forum_include.php\";
require_once THEMES.\"templates/header.php\";
include LOCALE.LOCALESET.\"forum/main.php\";
$posts_per_page = 20;
add_to_title($locale['global_200'].$locale['400']);
if (!isset($_GET['thread_id']) || !isnum($_GET['thread_id'])) { redirect(\"index.php\"); }
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
\"SELECT t.*, f.*, f2.forum_name AS forum_cat_name
FROM \".DB_THREADS.\" t
LEFT JOIN \".DB_FORUMS.\" f ON t.forum_id=f.forum_id
LEFT JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE t.thread_id='\".$_GET['thread_id'].\"'\"
);
if (dbrows($result)) {
$fdata = dbarray($result);
if (!checkgroup($fdata['forum_access']) || !$fdata['forum_cat']) { redirect(\"index.php\"); }
} else {
redirect(\"index.php\");
}
if ($fdata['forum_post'] != 0 && checkgroup($fdata['forum_post'])) {
$can_post = true;
} else {
$can_post = false;
}
if ($fdata['forum_reply'] != 0 && checkgroup($fdata['forum_reply'])) {
$can_reply = true;
} else {
$can_reply = false;
}
if ($settings['forum_edit_lock'] == 1) {
$lock_edit = true;
} else {
$lock_edit = false;
}
//locale dependent forum buttons
if (is_array($fusion_images)) {
if ($settings['locale'] != \"English\") {
$newpath = \"\";
$oldpath = explode(\"/\", $fusion_images['newthread']);
for ($i = 0; $i < count($oldpath) - 1; $i++) {
$newpath .= $oldpath[$i].\"/\";
}
if (is_dir($newpath.$settings['locale'])) {
redirect_img_dir($newpath, $newpath.$settings['locale'].\"/\");
}
}
}
//locale dependent forum buttons
$mod_groups = explode(\".\", $fdata['forum_moderators']);
if (iSUPERADMIN) { define(\"iMOD\", true); }
if (!defined(\"iMOD\") && iMEMBER && $fdata['forum_moderators']) {
foreach ($mod_groups as $mod_group) {
if (!defined(\"iMOD\") && checkgroup($mod_group)) { define(\"iMOD\", true); }
}
}
if (!defined(\"iMOD\")) { define(\"iMOD\", false); }
if (iMEMBER) {
$thread_match = $fdata['thread_id'].\"\|\".$fdata['thread_lastpost'].\"\|\".$fdata['forum_id'];
if (($fdata['thread_lastpost'] > $lastvisited) && !preg_match(\"(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)\", $userdata['user_threads'])) {
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_threads='\".$userdata['user_threads'].\".\".stripslashes($thread_match).\"' WHERE user_id='\".$userdata['user_id'].\"'\");
}
}
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_views=thread_views+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
if ((iMOD || iSUPERADMIN) && isset($_POST['delete_posts']) && (isset($_POST['delete_post'])) && is_array($_POST['delete_post']) && count($_POST['delete_post'])) {
$del_posts = \"\"; $i = 0; $post_count = 0;
foreach ($_POST['delete_post'] as $del_post_id) {
if (isnum($del_post_id)) { $del_posts .= ($del_posts ? \",\" : \"\").$del_post_id; $i++; }
}
if ($del_posts) {
$result = dbquery(\"SELECT post_author, COUNT(post_id) as num_posts FROM \".DB_POSTS.\" WHERE post_id IN (\".$del_posts.\") GROUP BY post_author\");
if (dbrows($result)) {
while ($pdata = dbarray($result)) {
$result2 = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts-\".$pdata['num_posts'].\" WHERE user_id='\".$pdata['post_author'].\"'\");
$post_count = $post_count + $pdata['num_posts'];
}
}
$result = dbquery(\"SELECT attach_name FROM \".DB_FORUM_ATTACHMENTS.\" WHERE post_id IN (\".$del_posts.\")\");
if (dbrows($result)) {
while ($data = dbarray($result)) {
unlink(FORUM.\"attachments/\".$data['attach_name']);
}
}
$result = dbquery(\"DELETE FROM \".DB_FORUM_ATTACHMENTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
$result = dbquery(\"DELETE FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
}
if (!dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\")) {
$result = dbquery(\"DELETE FROM \".DB_THREADS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_THREAD_NOTIFY.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_VOTERS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLLS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = false;
} else {
$result = dbquery(\"SELECT post_datestamp, post_author, post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
$ldata = dbarray($result);
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".$ldata['post_datestamp'].\"', thread_lastpostid='\".$ldata['post_id'].\"', thread_postcount=thread_postcount-1, thread_lastuser='\".$ldata['post_author'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = true; unset($ldata);
}
$result = dbquery(\"SELECT post_datestamp, post_author FROM \".DB_POSTS.\" WHERE forum_id='\".$fdata['forum_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
if (dbrows($result)) {
$ldata = dbarray($result);
$forum_lastpost = \"forum_lastpost='\".$ldata['post_datestamp'].\"', forum_lastuser='\".$ldata['post_author'].\"'\";
} else {
$forum_lastpost = \"forum_lastpost='0', forum_lastuser='0'\";
}
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET \".$forum_lastpost.(!$thread_count ? \"forum_threadcount=forum_threadcount-1,\" : \",\").\" forum_postcount=forum_postcount-\".$post_count.\" WHERE forum_id = '\".$fdata['forum_id'].\"'\");
if (!$thread_count) { redirect(\"viewforum.php?forum_id=\".$fdata['forum_id']); }
}
if (isset($_GET['pid']) && isnum($_GET['pid'])) {
$reply_count = dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$fdata['thread_id'].\"' AND post_id<='\".$_GET['pid'].\"'\");
if ($reply_count > $posts_per_page) { $_GET['rowstart'] = ((ceil($reply_count / $posts_per_page)-1) * $posts_per_page); }
}
$caption = $fdata['forum_cat_name'].\" :: \".$fdata['forum_name'].\" \";
if (iMEMBER && isset($_POST['cast_vote']) && (isset($_POST['poll_option']) && isnum($_POST['poll_option']))) {
$result = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_VOTERS.\" WHERE forum_vote_user_id='\".$userdata['user_id'].\"' AND thread_id='\".$_GET['thread_id'].\"'\");
if (!dbrows($result)) {
$result = dbquery(\"UPDATE \".DB_FORUM_POLL_OPTIONS.\" SET forum_poll_option_votes=forum_poll_option_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"' AND forum_poll_option_id='\".$_POST['poll_option'].\"'\");
$result = dbquery(\"UPDATE \".DB_FORUM_POLLS.\" SET forum_poll_votes=forum_poll_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"INSERT INTO \".DB_FORUM_POLL_VOTERS.\" (thread_id, forum_vote_user_id, forum_vote_user_ip) VALUES ('\".$_GET['thread_id'].\"', '\".$userdata['user_id'].\"', '\".USER_IP.\"')\");
}
redirect(FUSION_SELF.\"?thread_id=\".$_GET['thread_id']);
}
if (iMEMBER && $can_reply && !$fdata['thread_locked'] && isset($_POST['postquickreply'])) {
$message = stripinput(censorwords($_POST['message']));
if ($message != \"\") {
require_once INCLUDES.\"flood_include.php\";
if (!flood_control(\"post_datestamp\", DB_POSTS, \"post_author='\".$userdata['user_id'].\"'\")) {
$sig = ($userdata['user_sig'] ? '1' :'0');
$smileys = isset($_POST['disable_smileys']) || preg_match(\"#\[code\](.*?)\[/code\]#si\", $message) ? \"0\" : \"1\";
$result = dbquery(\"INSERT INTO \".DB_POSTS.\" (forum_id, thread_id, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_edituser, post_edittime) VALUES ('\".$fdata['forum_id'].\"', '\".$_GET['thread_id'].\"', '$message', '$sig', '$smileys', '\".$userdata['user_id'].\"', '\".time().\"', '\".USER_IP.\"', '0', '0')\");
$newpost_id = mysql_insert_id();
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET forum_lastpost='\".time().\"', forum_postcount=forum_postcount+1, forum_lastuser='\".$userdata['user_id'].\"' WHERE forum_id='\".$fdata['forum_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".time().\"', thread_lastpostid='\".$newpost_id.\"', thread_postcount=thread_postcount+1, thread_lastuser='\".$userdata['user_id'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts+1 WHERE user_id='\".$userdata['user_id'].\"'\");
redirect(\"postify.php?post=reply&error=0&forum_id=\".$fdata['forum_id'].\"&thread_id=\".$_GET['thread_id'].\"&post_id=$newpost_id\");
} else {
redirect(\"viewthread.php?thread_id=\".$_GET['thread_id']);
}
}
}
$rows = dbcount(\"(thread_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\");
$last_post = dbarray(dbquery(\"SELECT post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\"));
opentable($locale['500']);
echo \"\n\";
if (($rows > $posts_per_page) || ($can_post || $can_reply)) {
echo \"\n\n\";
if ($rows > $posts_per_page) { echo \"\n\"; }
if (iMEMBER && $can_post) {
echo \"\n\";
}
}
echo \"\n\".makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].\"&\").\" \n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n
\n\";
}
if ($rows != 0) {
if ($_GET['rowstart'] == 0 && $fdata['thread_poll'] == \"1\") {
if (iMEMBER) {
$presult = dbquery(
\"SELECT tfp.*, tfv.forum_vote_user_id FROM \".DB_FORUM_POLLS.\" tfp
LEFT JOIN \".DB_FORUM_POLL_VOTERS.\" tfv
ON tfp.thread_id=tfv.thread_id AND forum_vote_user_id='\".$userdata['user_id'].\"'
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
} else {
$presult = dbquery(
\"SELECT tfp.* FROM \".DB_FORUM_POLLS.\" tfp
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
}
if (dbrows($presult)) {
$pdata = dbarray($presult); $i = 1;
if (iMEMBER) { echo \"\n\"; }
}
}
$result = dbquery(
\"SELECT p.*, fa.attach_id, fa.attach_name, fa.attach_ext, fa.attach_size, u.*, u2.user_name AS edit_name
FROM \".DB_POSTS.\" p
LEFT JOIN \".DB_FORUM_ATTACHMENTS.\" fa USING(post_id)
LEFT JOIN \".DB_USERS.\" u ON p.post_author = u.user_id
LEFT JOIN \".DB_USERS.\" u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp LIMIT \".$_GET['rowstart'].\",$posts_per_page\"
);
if (iMOD) { echo \"\n\";
}
if ($rows > $posts_per_page) {
echo \"\n\";
echo makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].(isset($_GET['highlight']) ? \"&highlight=\".urlencode($_GET['highlight']):\"\").\"&\").\"\n\";
echo \"
\n\";
}
$forum_list = \"\"; $current_cat = \"\";
$result = dbquery(
\"SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name
FROM \".DB_FORUMS.\" f
INNER JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE \".groupaccess('f.forum_access').\" AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC\"
);
while ($data = dbarray($result)) {
if ($data['forum_cat_name'] != $current_cat) {
if ($current_cat != \"\") { $forum_list .= \"\n\"; }
$current_cat = $data['forum_cat_name'];
$forum_list .= \"\n\";
}
$sel = ($data['forum_id'] == $fdata['forum_id'] ? \" selected='selected'\" : \"\");
$forum_list .= \"\".$data['forum_name'].\" \n\";
}
$forum_list .= \" \n\";
if (iMOD) { echo \"\n\"; }
if ($can_post || $can_reply) {
echo \"\n\n\";
echo \"\n\n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n\";
}
echo \"
\n\";
}
closetable();
if (iMEMBER && $can_reply && !$fdata['thread_locked']) {
require_once INCLUDES.\"bbcode_include.php\";
opentable($locale['512']);
echo \"\n\";
closetable();
}
echo \"\n\";
list($postcount, $lastpid) = dbarraynum(dbquery(\"SELECT COUNT(post_id), MAX(post_id) FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' GROUP BY thread_id\"));
if(isnum($postcount)){
dbquery(\"UPDATE \".DB_THREADS.\" SET thread_postcount='$postcount', thread_lastpostid=$lastpid WHERE thread_id='\".$_GET['thread_id'].\"'\");
}
require_once THEMES.\"templates/footer.php\";
?>
WwW.KarCiaMa.CoM - Portalas turintis savo unikali� praeit�,dabart� , bei ateit� :)
mantenas
parašyta 2010-11-25 20:22
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
?tai mani?kis
Code
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: viewthread.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once \"../maincore.php\";
require_once INCLUDES.\"forum_include.php\";
require_once THEMES.\"templates/header.php\";
include LOCALE.LOCALESET.\"forum/main.php\";
$posts_per_page = 20;
add_to_title($locale['global_200'].$locale['400']);
if (!isset($_GET['thread_id']) || !isnum($_GET['thread_id'])) { redirect(\"index.php\"); }
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
\"SELECT t.*, f.*, f2.forum_name AS forum_cat_name
FROM \".DB_THREADS.\" t
LEFT JOIN \".DB_FORUMS.\" f ON t.forum_id=f.forum_id
LEFT JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE t.thread_id='\".$_GET['thread_id'].\"'\"
);
if (dbrows($result)) {
$fdata = dbarray($result);
if (!checkgroup($fdata['forum_access']) || !$fdata['forum_cat']) { redirect(\"index.php\"); }
} else {
redirect(\"index.php\");
}
if ($fdata['forum_post'] != 0 && checkgroup($fdata['forum_post'])) {
$can_post = true;
} else {
$can_post = false;
}
if ($fdata['forum_reply'] != 0 && checkgroup($fdata['forum_reply'])) {
$can_reply = true;
} else {
$can_reply = false;
}
if ($settings['forum_edit_lock'] == 1) {
$lock_edit = true;
} else {
$lock_edit = false;
}
//locale dependent forum buttons
if (is_array($fusion_images)) {
if ($settings['locale'] != \"English\") {
$newpath = \"\";
$oldpath = explode(\"/\", $fusion_images['newthread']);
for ($i = 0; $i < count($oldpath) - 1; $i++) {
$newpath .= $oldpath[$i].\"/\";
}
if (is_dir($newpath.$settings['locale'])) {
redirect_img_dir($newpath, $newpath.$settings['locale'].\"/\");
}
}
}
//locale dependent forum buttons
$mod_groups = explode(\".\", $fdata['forum_moderators']);
if (iSUPERADMIN) { define(\"iMOD\", true); }
if (!defined(\"iMOD\") && iMEMBER && $fdata['forum_moderators']) {
foreach ($mod_groups as $mod_group) {
if (!defined(\"iMOD\") && checkgroup($mod_group)) { define(\"iMOD\", true); }
}
}
if (!defined(\"iMOD\")) { define(\"iMOD\", false); }
if (iMEMBER) {
$thread_match = $fdata['thread_id'].\"\|\".$fdata['thread_lastpost'].\"\|\".$fdata['forum_id'];
if (($fdata['thread_lastpost'] > $lastvisited) && !preg_match(\"(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)\", $userdata['user_threads'])) {
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_threads='\".$userdata['user_threads'].\".\".stripslashes($thread_match).\"' WHERE user_id='\".$userdata['user_id'].\"'\");
}
}
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_views=thread_views+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
if ((iMOD || iSUPERADMIN) && isset($_POST['delete_posts']) && (isset($_POST['delete_post'])) && is_array($_POST['delete_post']) && count($_POST['delete_post'])) {
$del_posts = \"\"; $i = 0; $post_count = 0;
foreach ($_POST['delete_post'] as $del_post_id) {
if (isnum($del_post_id)) { $del_posts .= ($del_posts ? \",\" : \"\").$del_post_id; $i++; }
}
if ($del_posts) {
$result = dbquery(\"SELECT post_author, COUNT(post_id) as num_posts FROM \".DB_POSTS.\" WHERE post_id IN (\".$del_posts.\") GROUP BY post_author\");
if (dbrows($result)) {
while ($pdata = dbarray($result)) {
$result2 = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts-\".$pdata['num_posts'].\" WHERE user_id='\".$pdata['post_author'].\"'\");
$post_count = $post_count + $pdata['num_posts'];
}
}
$result = dbquery(\"SELECT attach_name FROM \".DB_FORUM_ATTACHMENTS.\" WHERE post_id IN (\".$del_posts.\")\");
if (dbrows($result)) {
while ($data = dbarray($result)) {
unlink(FORUM.\"attachments/\".$data['attach_name']);
}
}
$result = dbquery(\"DELETE FROM \".DB_FORUM_ATTACHMENTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
$result = dbquery(\"DELETE FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
}
if (!dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\")) {
$result = dbquery(\"DELETE FROM \".DB_THREADS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_THREAD_NOTIFY.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_VOTERS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLLS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = false;
} else {
$result = dbquery(\"SELECT post_datestamp, post_author, post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
$ldata = dbarray($result);
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".$ldata['post_datestamp'].\"', thread_lastpostid='\".$ldata['post_id'].\"', thread_postcount=thread_postcount-1, thread_lastuser='\".$ldata['post_author'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = true; unset($ldata);
}
$result = dbquery(\"SELECT post_datestamp, post_author FROM \".DB_POSTS.\" WHERE forum_id='\".$fdata['forum_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
if (dbrows($result)) {
$ldata = dbarray($result);
$forum_lastpost = \"forum_lastpost='\".$ldata['post_datestamp'].\"', forum_lastuser='\".$ldata['post_author'].\"'\";
} else {
$forum_lastpost = \"forum_lastpost='0', forum_lastuser='0'\";
}
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET \".$forum_lastpost.(!$thread_count ? \"forum_threadcount=forum_threadcount-1,\" : \",\").\" forum_postcount=forum_postcount-\".$post_count.\" WHERE forum_id = '\".$fdata['forum_id'].\"'\");
if (!$thread_count) { redirect(\"viewforum.php?forum_id=\".$fdata['forum_id']); }
}
if (isset($_GET['pid']) && isnum($_GET['pid'])) {
$reply_count = dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$fdata['thread_id'].\"' AND post_id<='\".$_GET['pid'].\"'\");
if ($reply_count > $posts_per_page) { $_GET['rowstart'] = ((ceil($reply_count / $posts_per_page)-1) * $posts_per_page); }
}
$caption = $fdata['forum_cat_name'].\" :: \".$fdata['forum_name'].\" \";
if (iMEMBER && isset($_POST['cast_vote']) && (isset($_POST['poll_option']) && isnum($_POST['poll_option']))) {
$result = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_VOTERS.\" WHERE forum_vote_user_id='\".$userdata['user_id'].\"' AND thread_id='\".$_GET['thread_id'].\"'\");
if (!dbrows($result)) {
$result = dbquery(\"UPDATE \".DB_FORUM_POLL_OPTIONS.\" SET forum_poll_option_votes=forum_poll_option_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"' AND forum_poll_option_id='\".$_POST['poll_option'].\"'\");
$result = dbquery(\"UPDATE \".DB_FORUM_POLLS.\" SET forum_poll_votes=forum_poll_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"INSERT INTO \".DB_FORUM_POLL_VOTERS.\" (thread_id, forum_vote_user_id, forum_vote_user_ip) VALUES ('\".$_GET['thread_id'].\"', '\".$userdata['user_id'].\"', '\".USER_IP.\"')\");
}
redirect(FUSION_SELF.\"?thread_id=\".$_GET['thread_id']);
}
if (iMEMBER && $can_reply && !$fdata['thread_locked'] && isset($_POST['postquickreply'])) {
$message = stripinput(censorwords($_POST['message']));
if ($message != \"\") {
require_once INCLUDES.\"flood_include.php\";
if (!flood_control(\"post_datestamp\", DB_POSTS, \"post_author='\".$userdata['user_id'].\"'\")) {
$sig = ($userdata['user_sig'] ? '1' :'0');
$smileys = isset($_POST['disable_smileys']) || preg_match(\"#\[code\](.*?)\[/code\]#si\", $message) ? \"0\" : \"1\";
$result = dbquery(\"INSERT INTO \".DB_POSTS.\" (forum_id, thread_id, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_edituser, post_edittime) VALUES ('\".$fdata['forum_id'].\"', '\".$_GET['thread_id'].\"', '$message', '$sig', '$smileys', '\".$userdata['user_id'].\"', '\".time().\"', '\".USER_IP.\"', '0', '0')\");
$newpost_id = mysql_insert_id();
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET forum_lastpost='\".time().\"', forum_postcount=forum_postcount+1, forum_lastuser='\".$userdata['user_id'].\"' WHERE forum_id='\".$fdata['forum_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".time().\"', thread_lastpostid='\".$newpost_id.\"', thread_postcount=thread_postcount+1, thread_lastuser='\".$userdata['user_id'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts+1 WHERE user_id='\".$userdata['user_id'].\"'\");
redirect(\"postify.php?post=reply&error=0&forum_id=\".$fdata['forum_id'].\"&thread_id=\".$_GET['thread_id'].\"&post_id=$newpost_id\");
} else {
redirect(\"viewthread.php?thread_id=\".$_GET['thread_id']);
}
}
}
$rows = dbcount(\"(thread_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\");
$last_post = dbarray(dbquery(\"SELECT post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\"));
opentable($locale['500']);
echo \"\n\";
if (($rows > $posts_per_page) || ($can_post || $can_reply)) {
echo \"\n\n\";
if ($rows > $posts_per_page) { echo \"\n\"; }
if (iMEMBER && $can_post) {
echo \"\n\";
}
}
echo \"\n\".makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].\"&\").\" \n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n
\n\";
}
if ($rows != 0) {
if ($_GET['rowstart'] == 0 && $fdata['thread_poll'] == \"1\") {
if (iMEMBER) {
$presult = dbquery(
\"SELECT tfp.*, tfv.forum_vote_user_id FROM \".DB_FORUM_POLLS.\" tfp
LEFT JOIN \".DB_FORUM_POLL_VOTERS.\" tfv
ON tfp.thread_id=tfv.thread_id AND forum_vote_user_id='\".$userdata['user_id'].\"'
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
} else {
$presult = dbquery(
\"SELECT tfp.* FROM \".DB_FORUM_POLLS.\" tfp
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
}
if (dbrows($presult)) {
$pdata = dbarray($presult); $i = 1;
if (iMEMBER) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\n\n\n\n\".$pdata['forum_poll_title'].\" \n\";
echo \"\n\";
$presult = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY forum_poll_option_id ASC\");
$poll_options = dbrows($presult);
while ($pvdata = dbarray($presult)) {
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
$option_votes = ($pdata['forum_poll_votes'] ? number_format(100 / $pdata['forum_poll_votes'] * $pvdata['forum_poll_option_votes']) : 0);
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
} else {
echo \"\n\n\n\";
$i++;
}
}
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
echo \"\n\n\n\";
} else {
echo \"\n\n\n\";
}
echo \"\n
\n\";
if (iMEMBER) { echo \" \n\"; }
}
}
$result = dbquery(
\"SELECT p.*, fa.attach_id, fa.attach_name, fa.attach_ext, fa.attach_size, u.*, u2.user_name AS edit_name
FROM \".DB_POSTS.\" p
LEFT JOIN \".DB_FORUM_ATTACHMENTS.\" fa USING(post_id)
LEFT JOIN \".DB_USERS.\" u ON p.post_author = u.user_id
LEFT JOIN \".DB_USERS.\" u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp LIMIT \".$_GET['rowstart'].\",$posts_per_page\"
);
if (iMOD) { echo \"\n\"; }
echo \"\n\";
$numrows = dbrows($result);
$current_row = 1;
while ($data = dbarray($result)) {
$message = $data['post_message'];
if ($data['post_smileys']) { $message = parsesmileys($message); }
if ($current_row == 1) {
echo \"\n\n\n\";
}
echo \"\n\";
if ($current_row > 1) { echo \"\n\n\n\"; }
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\n\n\n\";
echo \"\n\n\n\n\";
$current_row++;
}
}
echo \"\n\";
if (iMEMBER && $settings['thread_notify']) {
if (dbcount(\"(thread_id)\", DB_THREAD_NOTIFY, \"thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\")) {
$result2 = dbquery(\"UPDATE \".DB_THREAD_NOTIFY.\" SET notify_datestamp='\".time().\"', notify_status='1' WHERE thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\");
echo \"
\".$locale['515'].\" \";
} else {
echo \"
\".$locale['516'].\" \";
}
}
echo \"
\n\";
add_to_title($locale['global_201'].$fdata['thread_subject']);
echo \"\".$fdata['thread_subject'].\"
\n \".$data['user_name'].\" \n\";
echo \"\n\";
echo \"\".$locale['505'].showdate(\"forumdate\", $data['post_datestamp']).\"
\n\";
echo \" \n\";
if ($data['user_avatar'] && file_exists(IMAGES.\"avatars/\".$data['user_avatar'])) {
echo \" \n\";
}
echo \"\";
if ($data['user_level'] >= 102) {
echo $settings['forum_ranks'] ? show_forum_rank($data['user_posts'], $data['user_level']) : getuserlevel($data['user_level']);
} else {
$is_mod = false;
foreach ($mod_groups as $mod_group) {
if (!$is_mod && preg_match(\"(^\.{$mod_group}$|\.{$mod_group}\.|\.{$mod_group}$)\", $data['user_groups'])) {
$is_mod = true;
}
}
if ($settings['forum_ranks']) {
echo $is_mod ? show_forum_rank($data['user_posts'], 104) : show_forum_rank($data['user_posts'], $data['user_level']);
} else {
echo $is_mod ? $locale['user1'] : getuserlevel($data['user_level']);
}
}
echo \" \n\";
echo \"\".$locale['502'].\" \".$data['user_posts'].\" \n\";
echo \"\".$locale['504'].\" \".showdate(\"%d.%m.%y\", $data['user_joined']).\" \n\";
echo \" \n\";
if (iMOD) { echo \"
\n\"; }
echo nl2br(parseubb($message));
echo \"\";
if ($data['attach_id']) {
if (in_array($data['attach_ext'], $imagetypes) && @getimagesize(FORUM.\"attachments/\".$data['attach_name'])) {
echo \"\n \n\".$data['user_name'].$locale['506'].\" \n\".display_image($data['attach_name']).\" [\".parsebytesize(filesize(FORUM.\"attachments/\".$data['attach_name'])).\"]\n\";
} else {
echo \"\n \n\".$data['user_name'].$locale['507'].\" \n\".$data['attach_name'].\" \";
}
}
if ($data['post_edittime'] != \"0\") {
echo \"\n \n\".$locale['508'].\"\".$data['edit_name'].\" \".$locale['509'].showdate(\"forumdate\", $data['post_edittime']);
}
if ($data['post_showsig'] && array_key_exists(\"user_sig\", $data) && $data['user_sig']) {
echo \"\n \".nl2br(parseubb(parsesmileys($data['user_sig']), \"b|i|u||center|small|url|mail|img|color\"));
}
echo \" \";
if (($settings['forum_ips'] && iMEMBER) || iMOD) { echo \"\".$locale['571'].\" : \".$data['post_ip']; } else { echo \" \"; }
echo \" \n\n\";
if (array_key_exists(\"user_web\", $data) && $data['user_web']) {
if (!strstr($data['user_web'], \"http://\")) { $urlprefix = \"http://\"; } else { $urlprefix = \"\"; }
echo \"
\";
}
if (iMEMBER && $data['user_id']!=$userdata['user_id']) {
echo \"
\n\";
}
echo \"
\n\";
if (iMEMBER && ($can_post || $can_reply)) {
if (!$fdata['thread_locked']) {
echo \"
\n\";
if (iMOD || ($lock_edit && $last_post['post_id'] == $data['post_id'] && $userdata['user_id'] == $data['post_author']) || (!$lock_edit && $userdata['user_id'] == $data['post_author'])) {
echo \"
\n\";
}
} else {
if (iMOD) {
echo \"
\n\";
}
}
}
echo \"
\n
\n\";
if (iMOD) {
echo \"\n\n\n\";
echo \"\n\";
echo \"\n\";
echo \">\".$locale['460'].\" ::\n\";
echo \">\".$locale['461'].\" >
\n \n\";
}
if ($rows > $posts_per_page) {
echo \"\n\";
echo makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].(isset($_GET['highlight']) ? \"&highlight=\".urlencode($_GET['highlight']):\"\").\"&\").\"\n\";
echo \"
\n\";
}
$forum_list = \"\"; $current_cat = \"\";
$result = dbquery(
\"SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name
FROM \".DB_FORUMS.\" f
INNER JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE \".groupaccess('f.forum_access').\" AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC\"
);
while ($data = dbarray($result)) {
if ($data['forum_cat_name'] != $current_cat) {
if ($current_cat != \"\") { $forum_list .= \"\n\"; }
$current_cat = $data['forum_cat_name'];
$forum_list .= \"\n\";
}
$sel = ($data['forum_id'] == $fdata['forum_id'] ? \" selected='selected'\" : \"\");
$forum_list .= \"\".$data['forum_name'].\" \n\";
}
$forum_list .= \" \n\";
if (iMOD) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\";
if (iMOD) {
echo \"\n\";
}
echo \"\n\n\"; if (iMOD) { echo \" \n\"; }
if ($can_post || $can_reply) {
echo \"\n\n\";
echo \"\n\n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n\";
}
echo \"
\n\";
}
closetable();
if (iMEMBER && $can_reply && !$fdata['thread_locked']) {
require_once INCLUDES.\"bbcode_include.php\";
opentable($locale['512']);
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n \n\";
closetable();
}
echo \"\n\";
list($postcount, $lastpid) = dbarraynum(dbquery(\"SELECT COUNT(post_id), MAX(post_id) FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' GROUP BY thread_id\"));
if(isnum($postcount)){
dbquery(\"UPDATE \".DB_THREADS.\" SET thread_postcount='$postcount', thread_lastpostid=$lastpid WHERE thread_id='\".$_GET['thread_id'].\"'\");
}
require_once THEMES.\"templates/footer.php\";
?>
Redagavo mantenas 2010-11-25 20:24
Wyciokazz
parašyta 2010-11-26 05:42
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
Medali� sistemos koda turit kuris y profili �siterpia?
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
mantenas
parašyta 2010-11-26 09:30
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
Kad n�ra ten read.txt faile para?ytas jis.... Nes man visada sakydavo ?i�r�k � read.txt ,o jame sura?ytos nesamon�s ir tiek...
Wyciokazz
parašyta 2010-11-26 10:31
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
Sari pabandyk
Code
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: viewthread.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licen... Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once \"../maincore.php\";
require_once INCLUDES.\"forum_include.php\";
require_once THEMES.\"templates/header.php\";
include LOCALE.LOCALESET.\"forum/main.php\";
$posts_per_page = 20;
add_to_title($locale['global_200'].$locale['400']);
if (!isset($_GET['thread_id']) || !isnum($_GET['thread_id'])) { redirect(\"index.php\"); }
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
\"SELECT t.*, f.*, f2.forum_name AS forum_cat_name
FROM \".DB_THREADS.\" t
LEFT JOIN \".DB_FORUMS.\" f ON t.forum_id=f.forum_id
LEFT JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE t.thread_id='\".$_GET['thread_id'].\"'\"
);
if (dbrows($result)) {
$fdata = dbarray($result);
if (!checkgroup($fdata['forum_access']) || !$fdata['forum_cat']) { redirect(\"index.php\"); }
} else {
redirect(\"index.php\");
}
if ($fdata['forum_post'] != 0 && checkgroup($fdata['forum_post'])) {
$can_post = true;
} else {
$can_post = false;
}
if ($fdata['forum_reply'] != 0 && checkgroup($fdata['forum_reply'])) {
$can_reply = true;
} else {
$can_reply = false;
}
if ($settings['forum_edit_lock'] == 1) {
$lock_edit = true;
} else {
$lock_edit = false;
}
//locale dependent forum buttons
if (is_array($fusion_images)) {
if ($settings['locale'] != \"English\") {
$newpath = \"\";
$oldpath = explode(\"/\", $fusion_images['newthread']);
for ($i = 0; $i < count($oldpath) - 1; $i++) {
$newpath .= $oldpath[$i].\"/\";
}
if (is_dir($newpath.$settings['locale'])) {
redirect_img_dir($newpath, $newpath.$settings['locale'].\"/\");
}
}
}
//locale dependent forum buttons
$mod_groups = explode(\".\", $fdata['forum_moderators']);
if (iSUPERADMIN) { define(\"iMOD\", true); }
if (!defined(\"iMOD\") && iMEMBER && $fdata['forum_moderators']) {
foreach ($mod_groups as $mod_group) {
if (!defined(\"iMOD\") && checkgroup($mod_group)) { define(\"iMOD\", true); }
}
}
if (!defined(\"iMOD\")) { define(\"iMOD\", false); }
if (iMEMBER) {
$thread_match = $fdata['thread_id'].\"\|\".$fdata['thread_lastpost'].\"\|\".$fdata['forum_id'];
if (($fdata['thread_lastpost'] > $lastvisited) && !preg_match(\"(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)\", $userdata['user_threads'])) {
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_threads='\".$userdata['user_threads'].\".\".stripslashes($thread_match).\"' WHERE user_id='\".$userdata['user_id'].\"'\");
}
}
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_views=thread_views+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
if ((iMOD || iSUPERADMIN) && isset($_POST['delete_posts']) && (isset($_POST['delete_post'])) && is_array($_POST['delete_post']) && count($_POST['delete_post'])) {
$del_posts = \"\"; $i = 0; $post_count = 0;
foreach ($_POST['delete_post'] as $del_post_id) {
if (isnum($del_post_id)) { $del_posts .= ($del_posts ? \",\" : \"\").$del_post_id; $i++; }
}
if ($del_posts) {
$result = dbquery(\"SELECT post_author, COUNT(post_id) as num_posts FROM \".DB_POSTS.\" WHERE post_id IN (\".$del_posts.\") GROUP BY post_author\");
if (dbrows($result)) {
while ($pdata = dbarray($result)) {
$result2 = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts-\".$pdata['num_posts'].\" WHERE user_id='\".$pdata['post_author'].\"'\");
$post_count = $post_count + $pdata['num_posts'];
}
}
$result = dbquery(\"SELECT attach_name FROM \".DB_FORUM_ATTACHMENTS.\" WHERE post_id IN (\".$del_posts.\")\");
if (dbrows($result)) {
while ($data = dbarray($result)) {
unlink(FORUM.\"attachments/\".$data['attach_name']);
}
}
$result = dbquery(\"DELETE FROM \".DB_FORUM_ATTACHMENTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
$result = dbquery(\"DELETE FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
}
if (!dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\")) {
$result = dbquery(\"DELETE FROM \".DB_THREADS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_THREAD_NOTIFY.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_VOTERS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLLS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = false;
} else {
$result = dbquery(\"SELECT post_datestamp, post_author, post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
$ldata = dbarray($result);
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".$ldata['post_datestamp'].\"', thread_lastpostid='\".$ldata['post_id'].\"', thread_postcount=thread_postcount-1, thread_lastuser='\".$ldata['post_author'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = true; unset($ldata);
}
$result = dbquery(\"SELECT post_datestamp, post_author FROM \".DB_POSTS.\" WHERE forum_id='\".$fdata['forum_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
if (dbrows($result)) {
$ldata = dbarray($result);
$forum_lastpost = \"forum_lastpost='\".$ldata['post_datestamp'].\"', forum_lastuser='\".$ldata['post_author'].\"'\";
} else {
$forum_lastpost = \"forum_lastpost='0', forum_lastuser='0'\";
}
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET \".$forum_lastpost.(!$thread_count ? \"forum_threadcount=forum_threadcount-1,\" : \",\").\" forum_postcount=forum_postcount-\".$post_count.\" WHERE forum_id = '\".$fdata['forum_id'].\"'\");
if (!$thread_count) { redirect(\"viewforum.php?forum_id=\".$fdata['forum_id']); }
}
if (isset($_GET['pid']) && isnum($_GET['pid'])) {
$reply_count = dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$fdata['thread_id'].\"' AND post_id<='\".$_GET['pid'].\"'\");
if ($reply_count > $posts_per_page) { $_GET['rowstart'] = ((ceil($reply_count / $posts_per_page)-1) * $posts_per_page); }
}
$caption = $fdata['forum_cat_name'].\" :: \".$fdata['forum_name'].\" \";
if (iMEMBER && isset($_POST['cast_vote']) && (isset($_POST['poll_option']) && isnum($_POST['poll_option']))) {
$result = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_VOTERS.\" WHERE forum_vote_user_id='\".$userdata['user_id'].\"' AND thread_id='\".$_GET['thread_id'].\"'\");
if (!dbrows($result)) {
$result = dbquery(\"UPDATE \".DB_FORUM_POLL_OPTIONS.\" SET forum_poll_option_votes=forum_poll_option_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"' AND forum_poll_option_id='\".$_POST['poll_option'].\"'\");
$result = dbquery(\"UPDATE \".DB_FORUM_POLLS.\" SET forum_poll_votes=forum_poll_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"INSERT INTO \".DB_FORUM_POLL_VOTERS.\" (thread_id, forum_vote_user_id, forum_vote_user_ip) VALUES ('\".$_GET['thread_id'].\"', '\".$userdata['user_id'].\"', '\".USER_IP.\"')\");
}
redirect(FUSION_SELF.\"?thread_id=\".$_GET['thread_id']);
}
if (iMEMBER && $can_reply && !$fdata['thread_locked'] && isset($_POST['postquickreply'])) {
$message = stripinput(censorwords($_POST['message']));
if ($message != \"\") {
require_once INCLUDES.\"flood_include.php\";
if (!flood_control(\"post_datestamp\", DB_POSTS, \"post_author='\".$userdata['user_id'].\"'\")) {
$sig = ($userdata['user_sig'] ? '1' :'0');
$smileys = isset($_POST['disable_smileys']) || preg_match(\"#\[code\](.*?)\[/code\]#si\", $message) ? \"0\" : \"1\";
$result = dbquery(\"INSERT INTO \".DB_POSTS.\" (forum_id, thread_id, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_edituser, post_edittime) VALUES ('\".$fdata['forum_id'].\"', '\".$_GET['thread_id'].\"', '$message', '$sig', '$smileys', '\".$userdata['user_id'].\"', '\".time().\"', '\".USER_IP.\"', '0', '0')\");
$newpost_id = mysql_insert_id();
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET forum_lastpost='\".time().\"', forum_postcount=forum_postcount+1, forum_lastuser='\".$userdata['user_id'].\"' WHERE forum_id='\".$fdata['forum_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".time().\"', thread_lastpostid='\".$newpost_id.\"', thread_postcount=thread_postcount+1, thread_lastuser='\".$userdata['user_id'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts+1 WHERE user_id='\".$userdata['user_id'].\"'\");
redirect(\"postify.php?post=reply&error=0&forum_id=\".$fdata['forum_id'].\"&thread_id=\".$_GET['thread_id'].\"&post_id=$newpost_id\");
} else {
redirect(\"viewthread.php?thread_id=\".$_GET['thread_id']);
}
}
}
$rows = dbcount(\"(thread_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\");
$last_post = dbarray(dbquery(\"SELECT post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\"));
opentable($locale['500']);
echo \"\n\";
if (($rows > $posts_per_page) || ($can_post || $can_reply)) {
echo \"\n\n\";
if ($rows > $posts_per_page) { echo \"\n\"; }
if (iMEMBER && $can_post) {
echo \"\n\";
}
}
echo \"\n\".makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].\"&\").\" \n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n
\n\";
}
if ($rows != 0) {
if ($_GET['rowstart'] == 0 && $fdata['thread_poll'] == \"1\") {
if (iMEMBER) {
$presult = dbquery(
\"SELECT tfp.*, tfv.forum_vote_user_id FROM \".DB_FORUM_POLLS.\" tfp
LEFT JOIN \".DB_FORUM_POLL_VOTERS.\" tfv
ON tfp.thread_id=tfv.thread_id AND forum_vote_user_id='\".$userdata['user_id'].\"'
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
} else {
$presult = dbquery(
\"SELECT tfp.* FROM \".DB_FORUM_POLLS.\" tfp
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
}
if (dbrows($presult)) {
$pdata = dbarray($presult); $i = 1;
if (iMEMBER) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\n\n\n\n\".$pdata['forum_poll_title'].\" \n\";
echo \"\n\";
$presult = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY forum_poll_option_id ASC\");
$poll_options = dbrows($presult);
while ($pvdata = dbarray($presult)) {
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
$option_votes = ($pdata['forum_poll_votes'] ? number_format(100 / $pdata['forum_poll_votes'] * $pvdata['forum_poll_option_votes']) : 0);
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
} else {
echo \"\n\n\n\";
$i++;
}
}
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
echo \"\n\n\n\";
} else {
echo \"\n\n\n\";
}
echo \"\n
\n\";
if (iMEMBER) { echo \" \n\"; }
}
}
$result = dbquery(
\"SELECT p.*, fa.attach_id, fa.attach_name, fa.attach_ext, fa.attach_size, u.*, u2.user_name AS edit_name
FROM \".DB_POSTS.\" p
LEFT JOIN \".DB_FORUM_ATTACHMENTS.\" fa USING(post_id)
LEFT JOIN \".DB_USERS.\" u ON p.post_author = u.user_id
LEFT JOIN \".DB_USERS.\" u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp LIMIT \".$_GET['rowstart'].\",$posts_per_page\"
);
if (iMOD) { echo \"\n\"; }
echo \"\n\";
$numrows = dbrows($result);
$current_row = 1;
while ($data = dbarray($result)) {
$message = $data['post_message'];
if ($data['post_smileys']) { $message = parsesmileys($message); }
if ($current_row == 1) {
echo \"\n\n\n\";
}
echo \"\n\";
if ($current_row > 1) { echo \"\n\n\n\"; }
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\n\n\n\";
echo \"\n\n\n\n\";
$current_row++;
}
}
echo \"\n\";
if (iMEMBER && $settings['thread_notify']) {
if (dbcount(\"(thread_id)\", DB_THREAD_NOTIFY, \"thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\")) {
$result2 = dbquery(\"UPDATE \".DB_THREAD_NOTIFY.\" SET notify_datestamp='\".time().\"', notify_status='1' WHERE thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\");
echo \"
\".$locale['515'].\" \";
} else {
echo \"
\".$locale['516'].\" \";
}
}
echo \"
\n\";
add_to_title($locale['global_201'].$fdata['thread_subject']);
echo \"\".$fdata['thread_subject'].\"
\n \".$data['user_name'].\" \n\";
echo \"\n\";
echo \"\".$locale['505'].showdate(\"forumdate\", $data['post_datestamp']).\"
\n\";
echo \" \n\";
if ($data['user_avatar'] && file_exists(IMAGES.\"avatars/\".$data['user_avatar'])) {
echo \" \n\";
}
$medaliai = dbquery(\"SELECT * FROM \".DB_AWARD.\" WHERE award_user='\".$data['user_id'].\"'\");
while ($award = dbarray($medaliai)) {
echo \" \n\";
}
echo \"\";
if ($data['user_level'] >= 102) {
echo $settings['forum_ranks'] ? show_forum_rank($data['user_posts'], $data['user_level']) : getuserlevel($data['user_level']);
} else {
$is_mod = false;
foreach ($mod_groups as $mod_group) {
if (!$is_mod && preg_match(\"(^\.{$mod_group}$|\.{$mod_group}\.|\.{$mod_group}$)\", $data['user_groups'])) {
$is_mod = true;
}
}
if ($settings['forum_ranks']) {
echo $is_mod ? show_forum_rank($data['user_posts'], 104) : show_forum_rank($data['user_posts'], $data['user_level']);
} else {
echo $is_mod ? $locale['user1'] : getuserlevel($data['user_level']);
}
}
echo \" \n\";
echo \"\".$locale['502'].\" \".$data['user_posts'].\" \n\";
echo \"\".$locale['504'].\" \".showdate(\"%d.%m.%y\", $data['user_joined']).\" \n\";
echo \" \n\";
if (iMOD) { echo \"
\n\"; }
echo nl2br(parseubb($message));
echo \"\";
if ($data['attach_id']) {
if (in_array($data['attach_ext'], $imagetypes) && @getimagesize(FORUM.\"attachments/\".$data['attach_name'])) {
echo \"\n \n\".$data['user_name'].$locale['506'].\" \n\".display_image($data['attach_name']).\" [\".parsebytesize(filesize(FORUM.\"attachments/\".$data['attach_name'])).\"]\n\";
} else {
echo \"\n \n\".$data['user_name'].$locale['507'].\" \n\".$data['attach_name'].\" \";
}
}
if ($data['post_edittime'] != \"0\") {
echo \"\n \n\".$locale['508'].\"\".$data['edit_name'].\" \".$locale['509'].showdate(\"forumdate\", $data['post_edittime']);
}
if ($data['post_showsig'] && array_key_exists(\"user_sig\", $data) && $data['user_sig']) {
echo \"\n \".nl2br(parseubb(parsesmileys($data['user_sig']), \"b|i|u||center|small|url|mail|img|color\"));
}
echo \" \";
if (($settings['forum_ips'] && iMEMBER) || iMOD) { echo \"\".$locale['571'].\" : \".$data['post_ip']; } else { echo \" \"; }
echo \" \n\n\";
if (array_key_exists(\"user_web\", $data) && $data['user_web']) {
if (!strstr($data['user_web'], \"http://\")) { $urlprefix = \"http://\"; } else { $urlprefix = \"\"; }
echo \"
\";
}
if (iMEMBER && $data['user_id']!=$userdata['user_id']) {
echo \"
\n\";
}
echo \"
\n\";
if (iMEMBER && ($can_post || $can_reply)) {
if (!$fdata['thread_locked']) {
echo \"
\n\";
if (iMOD || ($lock_edit && $last_post['post_id'] == $data['post_id'] && $userdata['user_id'] == $data['post_author']) || (!$lock_edit && $userdata['user_id'] == $data['post_author'])) {
echo \"
\n\";
}
} else {
if (iMOD) {
echo \"
\n\";
}
}
}
echo \"
\n
\n\";
if (iMOD) {
echo \"\n\n\n\";
echo \"\n\";
echo \"\n\";
echo \">\".$locale['460'].\" ::\n\";
echo \">\".$locale['461'].\" >
\n \n\";
}
if ($rows > $posts_per_page) {
echo \"\n\";
echo makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].(isset($_GET['highlight']) ? \"&highlight=\".urlencode($_GET['highlight']):\"\").\"&\").\"\n\";
echo \"
\n\";
}
$forum_list = \"\"; $current_cat = \"\";
$result = dbquery(
\"SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name
FROM \".DB_FORUMS.\" f
INNER JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE \".groupaccess('f.forum_access').\" AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC\"
);
while ($data = dbarray($result)) {
if ($data['forum_cat_name'] != $current_cat) {
if ($current_cat != \"\") { $forum_list .= \"\n\"; }
$current_cat = $data['forum_cat_name'];
$forum_list .= \"\n\";
}
$sel = ($data['forum_id'] == $fdata['forum_id'] ? \" selected='selected'\" : \"\");
$forum_list .= \"\".$data['forum_name'].\" \n\";
}
$forum_list .= \" \n\";
if (iMOD) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\";
if (iMOD) {
echo \"\n\";
}
echo \"\n\n\"; if (iMOD) { echo \" \n\"; }
if ($can_post || $can_reply) {
echo \"\n\n\";
echo \"\n\n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n\";
}
echo \"
\n\";
}
closetable();
if (iMEMBER && $can_reply && !$fdata['thread_locked']) {
require_once INCLUDES.\"bbcode_include.php\";
opentable($locale['512']);
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n \n\";
closetable();
}
echo \"\n\";
list($postcount, $lastpid) = dbarraynum(dbquery(\"SELECT COUNT(post_id), MAX(post_id) FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' GROUP BY thread_id\"));
if(isnum($postcount)){
dbquery(\"UPDATE \".DB_THREADS.\" SET thread_postcount='$postcount', thread_lastpostid=$lastpid WHERE thread_id='\".$_GET['thread_id'].\"'\");
}
require_once THEMES.\"templates/footer.php\";
?>
Redagavo Wyciokazz 2010-11-26 10:45
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
mantenas
parašyta 2010-11-26 12:10
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
Mano medaliu sistema lygiai tokia pati ir kiek per?i�r�jau toks pat ir viewthread.php ,bet man meta error forume kai ?i�riu...
Wyciokazz
parašyta 2010-11-26 13:39
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
Tai gerai a? tau y pm i?siun�iau koda patikrink jeigu meta klaida tai para?yk �ia.
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
mantenas
parašyta 2010-11-26 14:29
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
Taip meta klaida...
Wyciokazz
parašyta 2010-11-26 15:10
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
Kokia gali para?yti ar man i? lub� skaityti?
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
mantenas
parašyta 2010-11-26 20:18
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
Parse error: syntax error, unexpected '&' in /usr/home/www1/ftp/mantas123/forum/viewthread.php on line 281
Wyciokazz
parašyta 2010-11-27 10:26
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
Code
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: viewthread.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licen... Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once \"../maincore.php\";
require_once INCLUDES.\"forum_include.php\";
require_once THEMES.\"templates/header.php\";
include LOCALE.LOCALESET.\"forum/main.php\";
$posts_per_page = 20;
add_to_title($locale['global_200'].$locale['400']);
if (!isset($_GET['thread_id']) || !isnum($_GET['thread_id'])) { redirect(\"index.php\"); }
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
\"SELECT t.*, f.*, f2.forum_name AS forum_cat_name
FROM \".DB_THREADS.\" t
LEFT JOIN \".DB_FORUMS.\" f ON t.forum_id=f.forum_id
LEFT JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE t.thread_id='\".$_GET['thread_id'].\"'\"
);
if (dbrows($result)) {
$fdata = dbarray($result);
if (!checkgroup($fdata['forum_access']) || !$fdata['forum_cat']) { redirect(\"index.php\"); }
} else {
redirect(\"index.php\");
}
if ($fdata['forum_post'] != 0 && checkgroup($fdata['forum_post'])) {
$can_post = true;
} else {
$can_post = false;
}
if ($fdata['forum_reply'] != 0 && checkgroup($fdata['forum_reply'])) {
$can_reply = true;
} else {
$can_reply = false;
}
if ($settings['forum_edit_lock'] == 1) {
$lock_edit = true;
} else {
$lock_edit = false;
}
//locale dependent forum buttons
if (is_array($fusion_images)) {
if ($settings['locale'] != \"English\") {
$newpath = \"\";
$oldpath = explode(\"/\", $fusion_images['newthread']);
for ($i = 0; $i < count($oldpath) - 1; $i++) {
$newpath .= $oldpath[$i].\"/\";
}
if (is_dir($newpath.$settings['locale'])) {
redirect_img_dir($newpath, $newpath.$settings['locale'].\"/\");
}
}
}
//locale dependent forum buttons
$mod_groups = explode(\".\", $fdata['forum_moderators']);
if (iSUPERADMIN) { define(\"iMOD\", true); }
if (!defined(\"iMOD\") && iMEMBER && $fdata['forum_moderators']) {
foreach ($mod_groups as $mod_group) {
if (!defined(\"iMOD\") && checkgroup($mod_group)) { define(\"iMOD\", true); }
}
}
if (!defined(\"iMOD\")) { define(\"iMOD\", false); }
if (iMEMBER) {
$thread_match = $fdata['thread_id'].\"\|\".$fdata['thread_lastpost'].\"\|\".$fdata['forum_id'];
if (($fdata['thread_lastpost'] > $lastvisited) && !preg_match(\"(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)\", $userdata['user_threads'])) {
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_threads='\".$userdata['user_threads'].\".\".stripslashes($thread_match).\"' WHERE user_id='\".$userdata['user_id'].\"'\");
}
}
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_views=thread_views+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
if ((iMOD || iSUPERADMIN) && isset($_POST['delete_posts']) && (isset($_POST['delete_post'])) && is_array($_POST['delete_post']) && count($_POST['delete_post'])) {
$del_posts = \"\"; $i = 0; $post_count = 0;
foreach ($_POST['delete_post'] as $del_post_id) {
if (isnum($del_post_id)) { $del_posts .= ($del_posts ? \",\" : \"\").$del_post_id; $i++; }
}
if ($del_posts) {
$result = dbquery(\"SELECT post_author, COUNT(post_id) as num_posts FROM \".DB_POSTS.\" WHERE post_id IN (\".$del_posts.\") GROUP BY post_author\");
if (dbrows($result)) {
while ($pdata = dbarray($result)) {
$result2 = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts-\".$pdata['num_posts'].\" WHERE user_id='\".$pdata['post_author'].\"'\");
$post_count = $post_count + $pdata['num_posts'];
}
}
$result = dbquery(\"SELECT attach_name FROM \".DB_FORUM_ATTACHMENTS.\" WHERE post_id IN (\".$del_posts.\")\");
if (dbrows($result)) {
while ($data = dbarray($result)) {
unlink(FORUM.\"attachments/\".$data['attach_name']);
}
}
$result = dbquery(\"DELETE FROM \".DB_FORUM_ATTACHMENTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
$result = dbquery(\"DELETE FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
}
if (!dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\")) {
$result = dbquery(\"DELETE FROM \".DB_THREADS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_THREAD_NOTIFY.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_VOTERS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLLS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = false;
} else {
$result = dbquery(\"SELECT post_datestamp, post_author, post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
$ldata = dbarray($result);
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".$ldata['post_datestamp'].\"', thread_lastpostid='\".$ldata['post_id'].\"', thread_postcount=thread_postcount-1, thread_lastuser='\".$ldata['post_author'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = true; unset($ldata);
}
$result = dbquery(\"SELECT post_datestamp, post_author FROM \".DB_POSTS.\" WHERE forum_id='\".$fdata['forum_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
if (dbrows($result)) {
$ldata = dbarray($result);
$forum_lastpost = \"forum_lastpost='\".$ldata['post_datestamp'].\"', forum_lastuser='\".$ldata['post_author'].\"'\";
} else {
$forum_lastpost = \"forum_lastpost='0', forum_lastuser='0'\";
}
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET \".$forum_lastpost.(!$thread_count ? \"forum_threadcount=forum_threadcount-1,\" : \",\").\" forum_postcount=forum_postcount-\".$post_count.\" WHERE forum_id = '\".$fdata['forum_id'].\"'\");
if (!$thread_count) { redirect(\"viewforum.php?forum_id=\".$fdata['forum_id']); }
}
if (isset($_GET['pid']) && isnum($_GET['pid'])) {
$reply_count = dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$fdata['thread_id'].\"' AND post_id<='\".$_GET['pid'].\"'\");
if ($reply_count > $posts_per_page) { $_GET['rowstart'] = ((ceil($reply_count / $posts_per_page)-1) * $posts_per_page); }
}
$caption = $fdata['forum_cat_name'].\" :: \".$fdata['forum_name'].\" \";
if (iMEMBER && isset($_POST['cast_vote']) && (isset($_POST['poll_option']) && isnum($_POST['poll_option']))) {
$result = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_VOTERS.\" WHERE forum_vote_user_id='\".$userdata['user_id'].\"' AND thread_id='\".$_GET['thread_id'].\"'\");
if (!dbrows($result)) {
$result = dbquery(\"UPDATE \".DB_FORUM_POLL_OPTIONS.\" SET forum_poll_option_votes=forum_poll_option_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"' AND forum_poll_option_id='\".$_POST['poll_option'].\"'\");
$result = dbquery(\"UPDATE \".DB_FORUM_POLLS.\" SET forum_poll_votes=forum_poll_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"INSERT INTO \".DB_FORUM_POLL_VOTERS.\" (thread_id, forum_vote_user_id, forum_vote_user_ip) VALUES ('\".$_GET['thread_id'].\"', '\".$userdata['user_id'].\"', '\".USER_IP.\"')\");
}
redirect(FUSION_SELF.\"?thread_id=\".$_GET['thread_id']);
}
if (iMEMBER && $can_reply && !$fdata['thread_locked'] && isset($_POST['postquickreply'])) {
$message = stripinput(censorwords($_POST['message']));
if ($message != \"\") {
require_once INCLUDES.\"flood_include.php\";
if (!flood_control(\"post_datestamp\", DB_POSTS, \"post_author='\".$userdata['user_id'].\"'\")) {
$sig = ($userdata['user_sig'] ? '1' :'0');
$smileys = isset($_POST['disable_smileys']) || preg_match(\"#\[code\](.*?)\[/code\]#si\", $message) ? \"0\" : \"1\";
$result = dbquery(\"INSERT INTO \".DB_POSTS.\" (forum_id, thread_id, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_edituser, post_edittime) VALUES ('\".$fdata['forum_id'].\"', '\".$_GET['thread_id'].\"', '$message', '$sig', '$smileys', '\".$userdata['user_id'].\"', '\".time().\"', '\".USER_IP.\"', '0', '0')\");
$newpost_id = mysql_insert_id();
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET forum_lastpost='\".time().\"', forum_postcount=forum_postcount+1, forum_lastuser='\".$userdata['user_id'].\"' WHERE forum_id='\".$fdata['forum_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".time().\"', thread_lastpostid='\".$newpost_id.\"', thread_postcount=thread_postcount+1, thread_lastuser='\".$userdata['user_id'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts+1 WHERE user_id='\".$userdata['user_id'].\"'\");
redirect(\"postify.php?post=reply&error=0&forum_id=\".$fdata['forum_id'].\"&thread_id=\".$_GET['thread_id'].\"&post_id=$newpost_id\");
} else {
redirect(\"viewthread.php?thread_id=\".$_GET['thread_id']);
}
}
}
$rows = dbcount(\"(thread_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\");
$last_post = dbarray(dbquery(\"SELECT post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\"));
opentable($locale['500']);
echo \"\n\";
if (($rows > $posts_per_page) || ($can_post || $can_reply)) {
echo \"\n\n\";
if ($rows > $posts_per_page) { echo \"\n\"; }
if (iMEMBER && $can_post) {
echo \"\n\";
}
}
echo \"\n\".makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].\"&\").\" \n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n
\n\";
}
if ($rows != 0) {
if ($_GET['rowstart'] == 0 && $fdata['thread_poll'] == \"1\") {
if (iMEMBER) {
$presult = dbquery(
\"SELECT tfp.*, tfv.forum_vote_user_id FROM \".DB_FORUM_POLLS.\" tfp
LEFT JOIN \".DB_FORUM_POLL_VOTERS.\" tfv
ON tfp.thread_id=tfv.thread_id AND forum_vote_user_id='\".$userdata['user_id'].\"'
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
} else {
$presult = dbquery(
\"SELECT tfp.* FROM \".DB_FORUM_POLLS.\" tfp
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
}
if (dbrows($presult)) {
$pdata = dbarray($presult); $i = 1;
if (iMEMBER) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\n\n\n\n\".$pdata['forum_poll_title'].\" \n\";
echo \"\n\";
$presult = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY forum_poll_option_id ASC\");
$poll_options = dbrows($presult);
while ($pvdata = dbarray($presult)) {
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
$option_votes = ($pdata['forum_poll_votes'] ? number_format(100 / $pdata['forum_poll_votes'] * $pvdata['forum_poll_option_votes']) : 0);
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
} else {
echo \"\n\n\n\";
$i++;
}
}
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
echo \"\n\n\n\";
} else {
echo \"\n\n\n\";
}
echo \"\n
\n\";
if (iMEMBER) { echo \" \n\"; }
}
}
$result = dbquery(
\"SELECT p.*, fa.attach_id, fa.attach_name, fa.attach_ext, fa.attach_size, u.*, u2.user_name AS edit_name
FROM \".DB_POSTS.\" p
LEFT JOIN \".DB_FORUM_ATTACHMENTS.\" fa USING(post_id)
LEFT JOIN \".DB_USERS.\" u ON p.post_author = u.user_id
LEFT JOIN \".DB_USERS.\" u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp LIMIT \".$_GET['rowstart'].\",$posts_per_page\"
);
if (iMOD) { echo \"\n\"; }
echo \"\n\";
$numrows = dbrows($result);
$current_row = 1;
while ($data = dbarray($result)) {
$message = $data['post_message'];
if ($data['post_smileys']) { $message = parsesmileys($message); }
if ($current_row == 1) {
echo \"\n\n\n\";
}
echo \"\n\";
if ($current_row > 1) { echo \"\n\n\n\"; }
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\n\n\n\";
echo \"\n\n\n\n\";
$current_row++;
}
}
echo \"\n\";
if (iMEMBER && $settings['thread_notify']) {
if (dbcount(\"(thread_id)\", DB_THREAD_NOTIFY, \"thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\")) {
$result2 = dbquery(\"UPDATE \".DB_THREAD_NOTIFY.\" SET notify_datestamp='\".time().\"', notify_status='1' WHERE thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\");
echo \"
\".$locale['515'].\" \";
} else {
echo \"
\".$locale['516'].\" \";
}
}
echo \"
\n\";
add_to_title($locale['global_201'].$fdata['thread_subject']);
echo \"\".$fdata['thread_subject'].\"
\n \".$data['user_name'].\" \n\";
echo \"\n\";
echo \"\".$locale['505'].showdate(\"forumdate\", $data['post_datestamp']).\"
\n\";
echo \" \n\";
if ($data['user_avatar'] && file_exists(IMAGES.\"avatars/\".$data['user_avatar'])) {
echo \" \n\";
}
$award = dbarray(dbquery(\"SELECT * FROM \".DB_AWARD.\" WHERE award_user='\".$data['user_id'].\"'\"));
echo \" \n\";
echo \"\";
if ($data['user_level'] >= 102) {
echo $settings['forum_ranks'] ? show_forum_rank($data['user_posts'], $data['user_level']) : getuserlevel($data['user_level']);
} else {
$is_mod = false;
foreach ($mod_groups as $mod_group) {
if (!$is_mod && preg_match(\"(^\.{$mod_group}$|\.{$mod_group}\.|\.{$mod_group}$)\", $data['user_groups'])) {
$is_mod = true;
}
}
if ($settings['forum_ranks']) {
echo $is_mod ? show_forum_rank($data['user_posts'], 104) : show_forum_rank($data['user_posts'], $data['user_level']);
} else {
echo $is_mod ? $locale['user1'] : getuserlevel($data['user_level']);
}
}
echo \" \n\";
echo \"\".$locale['502'].\" \".$data['user_posts'].\" \n\";
echo \"\".$locale['504'].\" \".showdate(\"%d.%m.%y\", $data['user_joined']).\" \n\";
echo \" \n\";
if (iMOD) { echo \"
\n\"; }
echo nl2br(parseubb($message));
echo \"\";
if ($data['attach_id']) {
if (in_array($data['attach_ext'], $imagetypes) && @getimagesize(FORUM.\"attachments/\".$data['attach_name'])) {
echo \"\n \n\".$data['user_name'].$locale['506'].\" \n\".display_image($data['attach_name']).\" [\".parsebytesize(filesize(FORUM.\"attachments/\".$data['attach_name'])).\"]\n\";
} else {
echo \"\n \n\".$data['user_name'].$locale['507'].\" \n\".$data['attach_name'].\" \";
}
}
if ($data['post_edittime'] != \"0\") {
echo \"\n \n\".$locale['508'].\"\".$data['edit_name'].\" \".$locale['509'].showdate(\"forumdate\", $data['post_edittime']);
}
if ($data['post_showsig'] && array_key_exists(\"user_sig\", $data) && $data['user_sig']) {
echo \"\n \".nl2br(parseubb(parsesmileys($data['user_sig']), \"b|i|u||center|small|url|mail|img|color\"));
}
echo \" \";
if (($settings['forum_ips'] && iMEMBER) || iMOD) { echo \"\".$locale['571'].\" : \".$data['post_ip']; } else { echo \" \"; }
echo \" \n\n\";
if (array_key_exists(\"user_web\", $data) && $data['user_web']) {
if (!strstr($data['user_web'], \"http://\")) { $urlprefix = \"http://\"; } else { $urlprefix = \"\"; }
echo \"
\";
}
if (iMEMBER && $data['user_id']!=$userdata['user_id']) {
echo \"
\n\";
}
echo \"
\n\";
if (iMEMBER && ($can_post || $can_reply)) {
if (!$fdata['thread_locked']) {
echo \"
\n\";
if (iMOD || ($lock_edit && $last_post['post_id'] == $data['post_id'] && $userdata['user_id'] == $data['post_author']) || (!$lock_edit && $userdata['user_id'] == $data['post_author'])) {
echo \"
\n\";
}
} else {
if (iMOD) {
echo \"
\n\";
}
}
}
echo \"
\n
\n\";
if (iMOD) {
echo \"\n\n\n\";
echo \"\n\";
echo \"\n\";
echo \">\".$locale['460'].\" ::\n\";
echo \">\".$locale['461'].\" >
\n \n\";
}
if ($rows > $posts_per_page) {
echo \"\n\";
echo makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].(isset($_GET['highlight']) ? \"&highlight=\".urlencode($_GET['highlight']):\"\").\"&\").\"\n\";
echo \"
\n\";
}
$forum_list = \"\"; $current_cat = \"\";
$result = dbquery(
\"SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name
FROM \".DB_FORUMS.\" f
INNER JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE \".groupaccess('f.forum_access').\" AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC\"
);
while ($data = dbarray($result)) {
if ($data['forum_cat_name'] != $current_cat) {
if ($current_cat != \"\") { $forum_list .= \"\n\"; }
$current_cat = $data['forum_cat_name'];
$forum_list .= \"\n\";
}
$sel = ($data['forum_id'] == $fdata['forum_id'] ? \" selected='selected'\" : \"\");
$forum_list .= \"\".$data['forum_name'].\" \n\";
}
$forum_list .= \" \n\";
if (iMOD) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\";
if (iMOD) {
echo \"\n\";
}
echo \"\n\n\"; if (iMOD) { echo \" \n\"; }
if ($can_post || $can_reply) {
echo \"\n\n\";
echo \"\n\n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n\";
}
echo \"
\n\";
}
closetable();
if (iMEMBER && $can_reply && !$fdata['thread_locked']) {
require_once INCLUDES.\"bbcode_include.php\";
opentable($locale['512']);
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n \n\";
closetable();
}
echo \"\n\";
list($postcount, $lastpid) = dbarraynum(dbquery(\"SELECT COUNT(post_id), MAX(post_id) FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' GROUP BY thread_id\"));
if(isnum($postcount)){
dbquery(\"UPDATE \".DB_THREADS.\" SET thread_postcount='$postcount', thread_lastpostid=$lastpid WHERE thread_id='\".$_GET['thread_id'].\"'\");
}
require_once THEMES.\"templates/footer.php\";
?>
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]
mantenas
parašyta 2010-11-27 10:38
Naujokas
Reputacija:
0 Pranešimai: 10
Įstojo: 2010-09-12
Dabar puslapi jau atidaro ,bet ?tai k� para?o vietoi medalio paveiksliuko.
Notice: Use of undefined constant DB_AWARD - assumed 'DB_AWARD' in /usr/home/www1/ftp/mantas123/forum/viewthread.php on line 287
Table 'mantas123_1.DB_AWARD' doesn't existTable 'mantas123_1.DB_AWARD' doesn't exist
Wyciokazz
parašyta 2010-11-27 10:57
Administratorius
Reputacija:
1 Pranešimai: 2108
Įstojo: 2008-02-27
Code
/*-------------------------------------------------------+
| PHP-Fusion Content Management System
| Copyright (C) 2002 - 2008 Nick Jones
| http://www.php-fu...
+--------------------------------------------------------+
| Filename: viewthread.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licen... Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once \"../maincore.php\";
require_once INCLUDES.\"forum_include.php\";
require_once THEMES.\"templates/header.php\";
include LOCALE.LOCALESET.\"forum/main.php\";
$posts_per_page = 20;
add_to_title($locale['global_200'].$locale['400']);
if (!isset($_GET['thread_id']) || !isnum($_GET['thread_id'])) { redirect(\"index.php\"); }
if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }
$result = dbquery(
\"SELECT t.*, f.*, f2.forum_name AS forum_cat_name
FROM \".DB_THREADS.\" t
LEFT JOIN \".DB_FORUMS.\" f ON t.forum_id=f.forum_id
LEFT JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE t.thread_id='\".$_GET['thread_id'].\"'\"
);
if (dbrows($result)) {
$fdata = dbarray($result);
if (!checkgroup($fdata['forum_access']) || !$fdata['forum_cat']) { redirect(\"index.php\"); }
} else {
redirect(\"index.php\");
}
if ($fdata['forum_post'] != 0 && checkgroup($fdata['forum_post'])) {
$can_post = true;
} else {
$can_post = false;
}
if ($fdata['forum_reply'] != 0 && checkgroup($fdata['forum_reply'])) {
$can_reply = true;
} else {
$can_reply = false;
}
if ($settings['forum_edit_lock'] == 1) {
$lock_edit = true;
} else {
$lock_edit = false;
}
//locale dependent forum buttons
if (is_array($fusion_images)) {
if ($settings['locale'] != \"English\") {
$newpath = \"\";
$oldpath = explode(\"/\", $fusion_images['newthread']);
for ($i = 0; $i < count($oldpath) - 1; $i++) {
$newpath .= $oldpath[$i].\"/\";
}
if (is_dir($newpath.$settings['locale'])) {
redirect_img_dir($newpath, $newpath.$settings['locale'].\"/\");
}
}
}
//locale dependent forum buttons
$mod_groups = explode(\".\", $fdata['forum_moderators']);
if (iSUPERADMIN) { define(\"iMOD\", true); }
if (!defined(\"iMOD\") && iMEMBER && $fdata['forum_moderators']) {
foreach ($mod_groups as $mod_group) {
if (!defined(\"iMOD\") && checkgroup($mod_group)) { define(\"iMOD\", true); }
}
}
if (!defined(\"iMOD\")) { define(\"iMOD\", false); }
if (iMEMBER) {
$thread_match = $fdata['thread_id'].\"\|\".$fdata['thread_lastpost'].\"\|\".$fdata['forum_id'];
if (($fdata['thread_lastpost'] > $lastvisited) && !preg_match(\"(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)\", $userdata['user_threads'])) {
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_threads='\".$userdata['user_threads'].\".\".stripslashes($thread_match).\"' WHERE user_id='\".$userdata['user_id'].\"'\");
}
}
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_views=thread_views+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
if ((iMOD || iSUPERADMIN) && isset($_POST['delete_posts']) && (isset($_POST['delete_post'])) && is_array($_POST['delete_post']) && count($_POST['delete_post'])) {
$del_posts = \"\"; $i = 0; $post_count = 0;
foreach ($_POST['delete_post'] as $del_post_id) {
if (isnum($del_post_id)) { $del_posts .= ($del_posts ? \",\" : \"\").$del_post_id; $i++; }
}
if ($del_posts) {
$result = dbquery(\"SELECT post_author, COUNT(post_id) as num_posts FROM \".DB_POSTS.\" WHERE post_id IN (\".$del_posts.\") GROUP BY post_author\");
if (dbrows($result)) {
while ($pdata = dbarray($result)) {
$result2 = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts-\".$pdata['num_posts'].\" WHERE user_id='\".$pdata['post_author'].\"'\");
$post_count = $post_count + $pdata['num_posts'];
}
}
$result = dbquery(\"SELECT attach_name FROM \".DB_FORUM_ATTACHMENTS.\" WHERE post_id IN (\".$del_posts.\")\");
if (dbrows($result)) {
while ($data = dbarray($result)) {
unlink(FORUM.\"attachments/\".$data['attach_name']);
}
}
$result = dbquery(\"DELETE FROM \".DB_FORUM_ATTACHMENTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
$result = dbquery(\"DELETE FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' AND post_id IN(\".$del_posts.\")\");
}
if (!dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\")) {
$result = dbquery(\"DELETE FROM \".DB_THREADS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_THREAD_NOTIFY.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_VOTERS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"DELETE FROM \".DB_FORUM_POLLS.\" WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = false;
} else {
$result = dbquery(\"SELECT post_datestamp, post_author, post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
$ldata = dbarray($result);
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".$ldata['post_datestamp'].\"', thread_lastpostid='\".$ldata['post_id'].\"', thread_postcount=thread_postcount-1, thread_lastuser='\".$ldata['post_author'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$thread_count = true; unset($ldata);
}
$result = dbquery(\"SELECT post_datestamp, post_author FROM \".DB_POSTS.\" WHERE forum_id='\".$fdata['forum_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\");
if (dbrows($result)) {
$ldata = dbarray($result);
$forum_lastpost = \"forum_lastpost='\".$ldata['post_datestamp'].\"', forum_lastuser='\".$ldata['post_author'].\"'\";
} else {
$forum_lastpost = \"forum_lastpost='0', forum_lastuser='0'\";
}
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET \".$forum_lastpost.(!$thread_count ? \"forum_threadcount=forum_threadcount-1,\" : \",\").\" forum_postcount=forum_postcount-\".$post_count.\" WHERE forum_id = '\".$fdata['forum_id'].\"'\");
if (!$thread_count) { redirect(\"viewforum.php?forum_id=\".$fdata['forum_id']); }
}
if (isset($_GET['pid']) && isnum($_GET['pid'])) {
$reply_count = dbcount(\"(post_id)\", DB_POSTS, \"thread_id='\".$fdata['thread_id'].\"' AND post_id<='\".$_GET['pid'].\"'\");
if ($reply_count > $posts_per_page) { $_GET['rowstart'] = ((ceil($reply_count / $posts_per_page)-1) * $posts_per_page); }
}
$caption = $fdata['forum_cat_name'].\" :: \".$fdata['forum_name'].\" \";
if (iMEMBER && isset($_POST['cast_vote']) && (isset($_POST['poll_option']) && isnum($_POST['poll_option']))) {
$result = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_VOTERS.\" WHERE forum_vote_user_id='\".$userdata['user_id'].\"' AND thread_id='\".$_GET['thread_id'].\"'\");
if (!dbrows($result)) {
$result = dbquery(\"UPDATE \".DB_FORUM_POLL_OPTIONS.\" SET forum_poll_option_votes=forum_poll_option_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"' AND forum_poll_option_id='\".$_POST['poll_option'].\"'\");
$result = dbquery(\"UPDATE \".DB_FORUM_POLLS.\" SET forum_poll_votes=forum_poll_votes+1 WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"INSERT INTO \".DB_FORUM_POLL_VOTERS.\" (thread_id, forum_vote_user_id, forum_vote_user_ip) VALUES ('\".$_GET['thread_id'].\"', '\".$userdata['user_id'].\"', '\".USER_IP.\"')\");
}
redirect(FUSION_SELF.\"?thread_id=\".$_GET['thread_id']);
}
if (iMEMBER && $can_reply && !$fdata['thread_locked'] && isset($_POST['postquickreply'])) {
$message = stripinput(censorwords($_POST['message']));
if ($message != \"\") {
require_once INCLUDES.\"flood_include.php\";
if (!flood_control(\"post_datestamp\", DB_POSTS, \"post_author='\".$userdata['user_id'].\"'\")) {
$sig = ($userdata['user_sig'] ? '1' :'0');
$smileys = isset($_POST['disable_smileys']) || preg_match(\"#\[code\](.*?)\[/code\]#si\", $message) ? \"0\" : \"1\";
$result = dbquery(\"INSERT INTO \".DB_POSTS.\" (forum_id, thread_id, post_message, post_showsig, post_smileys, post_author, post_datestamp, post_ip, post_edituser, post_edittime) VALUES ('\".$fdata['forum_id'].\"', '\".$_GET['thread_id'].\"', '$message', '$sig', '$smileys', '\".$userdata['user_id'].\"', '\".time().\"', '\".USER_IP.\"', '0', '0')\");
$newpost_id = mysql_insert_id();
$result = dbquery(\"UPDATE \".DB_FORUMS.\" SET forum_lastpost='\".time().\"', forum_postcount=forum_postcount+1, forum_lastuser='\".$userdata['user_id'].\"' WHERE forum_id='\".$fdata['forum_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_THREADS.\" SET thread_lastpost='\".time().\"', thread_lastpostid='\".$newpost_id.\"', thread_postcount=thread_postcount+1, thread_lastuser='\".$userdata['user_id'].\"' WHERE thread_id='\".$_GET['thread_id'].\"'\");
$result = dbquery(\"UPDATE \".DB_USERS.\" SET user_posts=user_posts+1 WHERE user_id='\".$userdata['user_id'].\"'\");
redirect(\"postify.php?post=reply&error=0&forum_id=\".$fdata['forum_id'].\"&thread_id=\".$_GET['thread_id'].\"&post_id=$newpost_id\");
} else {
redirect(\"viewthread.php?thread_id=\".$_GET['thread_id']);
}
}
}
$rows = dbcount(\"(thread_id)\", DB_POSTS, \"thread_id='\".$_GET['thread_id'].\"'\");
$last_post = dbarray(dbquery(\"SELECT post_id FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp DESC LIMIT 1\"));
opentable($locale['500']);
echo \"\n\";
if (($rows > $posts_per_page) || ($can_post || $can_reply)) {
echo \"\n\n\";
if ($rows > $posts_per_page) { echo \"\n\"; }
if (iMEMBER && $can_post) {
echo \"\n\";
}
}
echo \"\n\".makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].\"&\").\" \n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n
\n\";
}
if ($rows != 0) {
if ($_GET['rowstart'] == 0 && $fdata['thread_poll'] == \"1\") {
if (iMEMBER) {
$presult = dbquery(
\"SELECT tfp.*, tfv.forum_vote_user_id FROM \".DB_FORUM_POLLS.\" tfp
LEFT JOIN \".DB_FORUM_POLL_VOTERS.\" tfv
ON tfp.thread_id=tfv.thread_id AND forum_vote_user_id='\".$userdata['user_id'].\"'
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
} else {
$presult = dbquery(
\"SELECT tfp.* FROM \".DB_FORUM_POLLS.\" tfp
WHERE tfp.thread_id='\".$_GET['thread_id'].\"'\"
);
}
if (dbrows($presult)) {
$pdata = dbarray($presult); $i = 1;
if (iMEMBER) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\n\n\n\n\".$pdata['forum_poll_title'].\" \n\";
echo \"\n\";
$presult = dbquery(\"SELECT * FROM \".DB_FORUM_POLL_OPTIONS.\" WHERE thread_id='\".$_GET['thread_id'].\"' ORDER BY forum_poll_option_id ASC\");
$poll_options = dbrows($presult);
while ($pvdata = dbarray($presult)) {
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
$option_votes = ($pdata['forum_poll_votes'] ? number_format(100 / $pdata['forum_poll_votes'] * $pvdata['forum_poll_option_votes']) : 0);
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
} else {
echo \"\n\n\n\";
$i++;
}
}
if ((iMEMBER && isset($pdata['forum_vote_user_id']) || (!$fdata['forum_vote'] || !checkgroup($fdata['forum_vote'])))) {
echo \"\n\n\n\";
} else {
echo \"\n\n\n\";
}
echo \"\n
\n\";
if (iMEMBER) { echo \" \n\"; }
}
}
$result = dbquery(
\"SELECT p.*, fa.attach_id, fa.attach_name, fa.attach_ext, fa.attach_size, u.*, u2.user_name AS edit_name
FROM \".DB_POSTS.\" p
LEFT JOIN \".DB_FORUM_ATTACHMENTS.\" fa USING(post_id)
LEFT JOIN \".DB_USERS.\" u ON p.post_author = u.user_id
LEFT JOIN \".DB_USERS.\" u2 ON p.post_edituser = u2.user_id AND post_edituser > '0'
WHERE p.thread_id='\".$_GET['thread_id'].\"' ORDER BY post_datestamp LIMIT \".$_GET['rowstart'].\",$posts_per_page\"
);
if (iMOD) { echo \"\n\"; }
echo \"\n\";
$numrows = dbrows($result);
$current_row = 1;
while ($data = dbarray($result)) {
$message = $data['post_message'];
if ($data['post_smileys']) { $message = parsesmileys($message); }
if ($current_row == 1) {
echo \"\n\n\n\";
}
echo \"\n\";
if ($current_row > 1) { echo \"\n\n\n\"; }
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\n\n\n\";
echo \"\n\n\n\n\";
$current_row++;
}
}
echo \"\n\";
if (iMEMBER && $settings['thread_notify']) {
if (dbcount(\"(thread_id)\", DB_THREAD_NOTIFY, \"thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\")) {
$result2 = dbquery(\"UPDATE \".DB_THREAD_NOTIFY.\" SET notify_datestamp='\".time().\"', notify_status='1' WHERE thread_id='\".$_GET['thread_id'].\"' AND notify_user='\".$userdata['user_id'].\"'\");
echo \"
\".$locale['515'].\" \";
} else {
echo \"
\".$locale['516'].\" \";
}
}
echo \"
\n\";
add_to_title($locale['global_201'].$fdata['thread_subject']);
echo \"\".$fdata['thread_subject'].\"
\n \".$data['user_name'].\" \n\";
echo \"\n\";
echo \"\".$locale['505'].showdate(\"forumdate\", $data['post_datestamp']).\"
\n\";
echo \" \n\";
if ($data['user_avatar'] && file_exists(IMAGES.\"avatars/\".$data['user_avatar'])) {
echo \" \n\";
}
$award = dbarray(dbquery(\"SELECT * FROM \".DB_PREFIX.\"award WHERE award_user='\".$data['user_id'].\"'\"));
echo \" \n\";
echo \"\";
if ($data['user_level'] >= 102) {
echo $settings['forum_ranks'] ? show_forum_rank($data['user_posts'], $data['user_level']) : getuserlevel($data['user_level']);
} else {
$is_mod = false;
foreach ($mod_groups as $mod_group) {
if (!$is_mod && preg_match(\"(^\.{$mod_group}$|\.{$mod_group}\.|\.{$mod_group}$)\", $data['user_groups'])) {
$is_mod = true;
}
}
if ($settings['forum_ranks']) {
echo $is_mod ? show_forum_rank($data['user_posts'], 104) : show_forum_rank($data['user_posts'], $data['user_level']);
} else {
echo $is_mod ? $locale['user1'] : getuserlevel($data['user_level']);
}
}
echo \" \n\";
echo \"\".$locale['502'].\" \".$data['user_posts'].\" \n\";
echo \"\".$locale['504'].\" \".showdate(\"%d.%m.%y\", $data['user_joined']).\" \n\";
echo \" \n\";
if (iMOD) { echo \"
\n\"; }
echo nl2br(parseubb($message));
echo \"\";
if ($data['attach_id']) {
if (in_array($data['attach_ext'], $imagetypes) && @getimagesize(FORUM.\"attachments/\".$data['attach_name'])) {
echo \"\n \n\".$data['user_name'].$locale['506'].\" \n\".display_image($data['attach_name']).\" [\".parsebytesize(filesize(FORUM.\"attachments/\".$data['attach_name'])).\"]\n\";
} else {
echo \"\n \n\".$data['user_name'].$locale['507'].\" \n\".$data['attach_name'].\" \";
}
}
if ($data['post_edittime'] != \"0\") {
echo \"\n \n\".$locale['508'].\"\".$data['edit_name'].\" \".$locale['509'].showdate(\"forumdate\", $data['post_edittime']);
}
if ($data['post_showsig'] && array_key_exists(\"user_sig\", $data) && $data['user_sig']) {
echo \"\n \".nl2br(parseubb(parsesmileys($data['user_sig']), \"b|i|u||center|small|url|mail|img|color\"));
}
echo \" \";
if (($settings['forum_ips'] && iMEMBER) || iMOD) { echo \"\".$locale['571'].\" : \".$data['post_ip']; } else { echo \" \"; }
echo \" \n\n\";
if (array_key_exists(\"user_web\", $data) && $data['user_web']) {
if (!strstr($data['user_web'], \"http://\")) { $urlprefix = \"http://\"; } else { $urlprefix = \"\"; }
echo \"
\";
}
if (iMEMBER && $data['user_id']!=$userdata['user_id']) {
echo \"
\n\";
}
echo \"
\n\";
if (iMEMBER && ($can_post || $can_reply)) {
if (!$fdata['thread_locked']) {
echo \"
\n\";
if (iMOD || ($lock_edit && $last_post['post_id'] == $data['post_id'] && $userdata['user_id'] == $data['post_author']) || (!$lock_edit && $userdata['user_id'] == $data['post_author'])) {
echo \"
\n\";
}
} else {
if (iMOD) {
echo \"
\n\";
}
}
}
echo \"
\n
\n\";
if (iMOD) {
echo \"\n\n\n\";
echo \"\n\";
echo \"\n\";
echo \">\".$locale['460'].\" ::\n\";
echo \">\".$locale['461'].\" >
\n \n\";
}
if ($rows > $posts_per_page) {
echo \"\n\";
echo makePageNav($_GET['rowstart'],$posts_per_page,$rows,3,FUSION_SELF.\"?thread_id=\".$_GET['thread_id'].(isset($_GET['highlight']) ? \"&highlight=\".urlencode($_GET['highlight']):\"\").\"&\").\"\n\";
echo \"
\n\";
}
$forum_list = \"\"; $current_cat = \"\";
$result = dbquery(
\"SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name
FROM \".DB_FORUMS.\" f
INNER JOIN \".DB_FORUMS.\" f2 ON f.forum_cat=f2.forum_id
WHERE \".groupaccess('f.forum_access').\" AND f.forum_cat!='0' ORDER BY f2.forum_order ASC, f.forum_order ASC\"
);
while ($data = dbarray($result)) {
if ($data['forum_cat_name'] != $current_cat) {
if ($current_cat != \"\") { $forum_list .= \"\n\"; }
$current_cat = $data['forum_cat_name'];
$forum_list .= \"\n\";
}
$sel = ($data['forum_id'] == $fdata['forum_id'] ? \" selected='selected'\" : \"\");
$forum_list .= \"\".$data['forum_name'].\" \n\";
}
$forum_list .= \" \n\";
if (iMOD) { echo \"\n\"; }
echo \"\n\n\";
echo \"\n\";
if (iMOD) {
echo \"\n\";
}
echo \"\n\n\"; if (iMOD) { echo \" \n\"; }
if ($can_post || $can_reply) {
echo \"\n\n\";
echo \"\n\n\";
if (!$fdata['thread_locked'] && $can_reply) {
echo \" \n\";
}
if ($can_post) {
echo \" \n\";
}
echo \"
\n\";
}
closetable();
if (iMEMBER && $can_reply && !$fdata['thread_locked']) {
require_once INCLUDES.\"bbcode_include.php\";
opentable($locale['512']);
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n\";
echo \"\n\";
echo \"\n\n \n\";
closetable();
}
echo \"\n\";
list($postcount, $lastpid) = dbarraynum(dbquery(\"SELECT COUNT(post_id), MAX(post_id) FROM \".DB_POSTS.\" WHERE thread_id='\".$_GET['thread_id'].\"' GROUP BY thread_id\"));
if(isnum($postcount)){
dbquery(\"UPDATE \".DB_THREADS.\" SET thread_postcount='$postcount', thread_lastpostid=$lastpid WHERE thread_id='\".$_GET['thread_id'].\"'\");
}
require_once THEMES.\"templates/footer.php\";
?>
Kam kurti tai kas jau sukurta.
Nesu ekstrasensas ar dar koks čigonas tad iš nieko negaliu suprast kur bėda.
[img]http://27.media.tumblr.com/tumblr_m3hdwudgjG1rteofuo1_500.gif[/img]