
Lütfen acil yardım arkadaşlar.
Kod: Tümünü seç
#-----[ OPEN ]--------------------------------------------------------
#
modcp.php
#
#-----[ FIND ]--------------------------------------------------------
#
$unlock = ( isset($HTTP_POST_VARS['unlock']) ) ? TRUE : FALSE;
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
$unfreeze = ( isset($HTTP_POST_VARS['unfreeze']) ) ? TRUE : FALSE;
$mass_unfreeze = ( isset($HTTP_POST_VARS['mass_unfreeze']) ) ? TRUE : FALSE;
#
#-----[ FIND ]--------------------------------------------------------
#
else if ( $unlock )
{
$mode = 'unlock';
}
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
else if ( $unfreeze )
{
$mode = 'unfreeze';
}
else if ( $mass_unfreeze )
{
$mode = 'mass_unfreeze';
}
#
#-----[ FIND ]--------------------------------------------------------
#
$sql = "SELECT u.username, p.*, pt.post_text, pt.bbcode_uid, pt.post_subject, p.post_username
#
#-----[ IN-LINE FIND ]------------------------------------------------
#
p.post_username
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------------
#
, p.post_freeze
#
#-----[ FIND ]--------------------------------------------------------
#
$post_subject = ( $postrow[$i]['post_subject'] != '' ) ? $postrow[$i]['post_subject'] : $topic_title;
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
$post_frozen= '';
if( intval($postrow[$i]['post_freeze']) > 0 )
{
$post_frozen = $lang['Last_isfreeze'];
}
#
#-----[ FIND ]--------------------------------------------------------
#
'POST_SUBJECT' => $post_subject,
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
'L_SPLIT_FROZEN' => $post_frozen,
#
#-----[ FIND ]--------------------------------------------------------
#
$template->pparse('split_body');
}
}
break;
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
case 'unfreeze':
if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
{
message_die(GENERAL_MESSAGE, $lang['None_selected']);
}
$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ? $HTTP_POST_VARS['topic_id_list'] : array($topic_id);
$topic_id_sql = '';
for($i = 0; $i < count($topics); $i++)
{
$topic_id_sql .= ( ( $topic_id_sql != "") ? ', ' : '' ) . intval($topics[$i]);
}
$sql = "UPDATE " . POSTS_TABLE . "
SET post_freeze = 0
WHERE post_id = '$post_id'
AND forum_id = $forum_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update topics table', '', __LINE__, __FILE__, $sql);
}
$sql = "SELECT p.*
FROM " . POSTS_TABLE . " p
WHERE p.topic_id = $topic_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not obtain post/user information.", '', __LINE__, __FILE__, $sql);
}
$postrow = array();
if ($row = $db->sql_fetchrow($result))
{
do
{
$postrow[] = $row;
}
while ($row = $db->sql_fetchrow($result));
$db->sql_freeresult($result);
$total_posts = count($postrow);
}
for($i = 0; $i < $total_posts; $i++)
{
if ( intval($postrow[$i]['post_freeze']) > 0 )
{
$stillFreeze = 1;
}
}
$sql = "SELECT p.post_time
FROM " . POSTS_TABLE . " p
WHERE p.topic_id = $topic_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not select post_time', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$data_new_unfreeze = intval($row['post_time']);
$sql = "SELECT f.*, p.post_time
FROM ( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not select post_time", '', __LINE__, __FILE__, $sql);
}
$postrow = $db->sql_fetchrow($result);
$data_act_last_forum_post = intval($postrow['post_time']);
if (intval($data_new_unfreeze) > intval($data_act_last_forum_post))
{
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_last_post_id = $post_id
WHERE forum_id = $forum_id";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update forum_last_post_id information.', '', __LINE__, __FILE__, $sql);
}
}
if ( (!empty($topic_id)) && $stillFreeze == TRUE )
{
$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
$message = $lang['frozen_still_exist'] . '<br /><br />' . sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
}
elseif ( !empty($topic_id) )
{
$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
}
else
{
$redirect_page = "modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'];
$message = sprintf($lang['Click_return_modcp'], '<a href="' . $redirect_page . '">', '</a>');
}
$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');
$template->assign_vars(array(
'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
);
message_die(GENERAL_MESSAGE, $lang['Post_Unfreezed'] . '<br /><br />' . $message);
break;
case 'mass_unfreeze':
if ( empty($HTTP_POST_VARS['topic_id_list']) && empty($topic_id) )
{
message_die(GENERAL_MESSAGE, $lang['None_selected']);
}
$topics = ( isset($HTTP_POST_VARS['topic_id_list']) ) ? $HTTP_POST_VARS['topic_id_list'] : array($topic_id);
$topic_id_sql = '';
for($i = 0; $i < count($topics); $i++)
{
$topic_id_sql .= ( ( $topic_id_sql != "") ? ', ' : '' ) . intval($topics[$i]);
$sql = "SELECT topic_last_post_id
FROM " . TOPICS_TABLE . "
WHERE topic_id IN ($topic_id_sql)
AND forum_id = $forum_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not select topic_last_post_id', '', __LINE__, __FILE__, $sql);
}
$row = $db->sql_fetchrow($result);
$data_topic_last_post_id = intval($row['topic_last_post_id']);
$sql = "SELECT post_id, post_time
FROM " . POSTS_TABLE . "
WHERE topic_id IN ($topic_id_sql)
AND forum_id = $forum_id
AND post_id = $data_topic_last_post_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not select post_time', '', __LINE__, __FILE__, $sql);
}
$postrow = $db->sql_fetchrow($result);
$unfreeze_post_id = intval($postrow['post_id']);
$unfreeze_post_time = intval($postrow['post_time']);
$sql = "SELECT f.*, p.post_time
FROM ( " . FORUMS_TABLE . " f
LEFT JOIN " . POSTS_TABLE . " p ON p.post_id = f.forum_last_post_id )";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, "Could not select forum_last_post_id", '', __LINE__, __FILE__, $sql);
}
$postrow = $db->sql_fetchrow($result);
$data_act_last_forum_post = intval($postrow['post_time']);
if (intval($unfreeze_post_time) > intval($data_act_last_forum_post))
{
$sql = "UPDATE " . FORUMS_TABLE . "
SET forum_last_post_id = $unfreeze_post_id
WHERE forum_id = $forum_id";
if ( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not update forum_last_post_id information.', '', __LINE__, __FILE__, $sql);
}
}
}
$sql = "UPDATE " . POSTS_TABLE . "
SET post_freeze = 0
WHERE topic_id IN ($topic_id_sql)
AND forum_id = $forum_id";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not update posts table', '', __LINE__, __FILE__, $sql);
}
if ( !empty($topic_id) )
{
$redirect_page = "viewtopic.$phpEx?" . POST_TOPIC_URL . "=$topic_id&sid=" . $userdata['session_id'];
$message = sprintf($lang['Click_return_topic'], '<a href="' . $redirect_page . '">', '</a>');
}
else
{
$redirect_page = "modcp.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'];
$message = sprintf($lang['Click_return_modcp'], '<a href="' . $redirect_page . '">', '</a>');
}
$message = $message . '<br \><br \>' . sprintf($lang['Click_return_forum'], '<a href="' . "viewforum.$phpEx?" . POST_FORUM_URL . "=$forum_id&sid=" . $userdata['session_id'] . '">', '</a>');
$template->assign_vars(array(
'META' => '<meta http-equiv="refresh" content="3;url=' . $redirect_page . '">')
);
message_die(GENERAL_MESSAGE, $lang['Mass_Unfreeze_Success'] . '<br /><br />' . $message);
break;
#
#-----[ FIND ]--------------------------------------------------------
#
'L_UNLOCK' => $lang['Unlock'],
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
'L_MASS_UNFREEZE' => $lang['Mass_Unfreeze'],
#
#-----[ FIND ]--------------------------------------------------------
#
$sql = "SELECT t.*, u.username, u.user_id, p.post_time
#
#-----[ IN-LINE FIND ]------------------------------------------------
#
p.post_time
#
#-----[ IN-LINE AFTER, ADD ]------------------------------------------------
#
, p.post_freeze
#
#-----[ FIND ]--------------------------------------------------------
#
while ( $row = $db->sql_fetchrow($result) )
{
$topic_title = '';
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
$cp_unfreeze_exp = '';
if( intval($row['post_freeze']) > 0 )
{
$cp_unfreeze_exp = $lang['Mod_CP_unfreeze_explain'];
}
#
#-----[ FIND ]--------------------------------------------------------
#
'TOPIC_ID' => $topic_id,
#
#-----[ AFTER, ADD ]--------------------------------------------------
#
'L_MOD_CP_EXPLAIN_UNFREEZE' => $cp_unfreeze_exp,
Kod: Tümünü seç
#-----[ FIND ]--------------------------------------------------------
#
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
#
#-----[ REPLACE WITH ]--------------------------------------------------------
#
if ( intval($forum_data[$j]['post_freeze']) == 0 )
{
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a>';
}
else
{
$last_post .= '<a href="' . append_sid("viewtopic.$phpEx?" . POST_POST_URL . '=' . $forum_data[$j]['forum_last_post_id']) . '#' . $forum_data[$j]['forum_last_post_id'] . '"><img src="' . $images['icon_latest_reply'] . '" border="0" alt="' . $lang['View_latest_post'] . '" title="' . $lang['View_latest_post'] . '" /></a><br />' . $lang['Last_isfreeze'];
}
#
Bu forumu görüntüleyen kullanıcılar: Hiç bir kayıtlı kullanıcı yok ve 1 misafir