phpBB.de

Code: Alles auswählen

// BEGIN DM-TopicDone
if ($isdone == 'yes')
{
		$sql = 'UPDATE ' . TOPICS_TABLE . '
			SET topic_done = 1
			WHERE topic_id = ' . $donetopic;
		$db->sql_query($sql);

	$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
	redirect($redirect_url);
}
if ($isdone == 'no')
{
		$sql = 'UPDATE ' . TOPICS_TABLE . '
			SET topic_done = 0
			WHERE topic_id = ' . $donetopic;
		$db->sql_query($sql);

	$redirect_url = append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id);
	redirect($redirect_url);
}
// END DM-TopicDone

Code: Alles auswählen

//BEGIN DM_TopicDone
			'TOPIC_DONE'		=> (($user->data['user_id'] == $row['topic_poster'] && $auth->acl_get('f_edit', $forum_id)) || $auth->acl_get('m_edit', $forum_id)) ? (($row['topic_done'] == 1) ? '[<a href="viewforum.php?f='.$forum_id.'&dt='.$topic_id.'&done=no"><span class="DMdone">' . $user->lang['DMDONE'] . '</span></a>]' : '[<a href="viewforum.php?f='.$forum_id.'&dt='.$topic_id.'&done=yes"><span class="DMdonenot">' . $user->lang['DMNDONE'] . '</span></a>]') : (($row['topic_done'] == 1) ? '[<span class="DMdone">' . $user->lang['DMDONE'] . '</span>]' : '[<span class="DMdonenot">' . $user->lang['DMNDONE'] . '</span>]'),
//END DM_TopicDone

Code: Alles auswählen

$is_topic_done			=> ($row['topic_done'] == 1) ? 'yes' : 'no';
'U_TOPIC_DONE'			=> append_sid("{$phpbb_root_path}viewforum.$phpEx", 'f=' . $forum_id . '&dt=' . $topic_id . '&done=' . $is_topic_done),
'S_CAN_TOPIC_DONE_EDIT'	=> (($user->data['user_id'] == $row['topic_poster'] && $auth->acl_get('f_edit', $forum_id)) || $auth->acl_get('m_edit', $forum_id)) ? true : false,
'S_IS_TOPIC_DONE'		=> ($row['topic_done'] == 1) ? true : false,

Code: Alles auswählen

<!-- IF S_CAN_TOPIC_DONE_EDIT -->[<a href="{U_TOPIC_DONE}"><span class="<!-- IF S_IS_TOPIC_DONE -->DMdone<!-- ELSE -->DMdonenot<!-- ENDIF -->"><!-- IF S_IS_TOPIC_DONE -->'{L_DMDONE}'<!-- ELSE -->'{DMNDONE}'<!-- ENDIF --></span></a>]<!-- ELSE -->[<span class="<!-- IF S_IS_TOPIC_DONE -->DMdone<!-- ELSE -->DMdonenot<!-- ENDIF -->"><!-- IF S_IS_TOPIC_DONE -->'{{L_DMDONE}}'<!-- ELSE -->'{DMNDONE}'<!-- ENDIF --></span>]<!-- ENDIF -->

Code: Alles auswählen

SQL ERROR [ mysqli ]

Column 'topic_done' cannot be null [1048]

SQL

UPDATE phpbb_topics SET forum_id = 4, icon_id = 0, topic_done = NULL, topic_approved = '1', topic_title = 'TestTopic', topic_first_poster_name = 'D3xT3r', topic_type = 0, topic_time_limit = 0, poll_title = '', poll_start = 0, poll_max_options = 1, poll_length = 0, poll_vote_change = 0, topic_attachment = 0 WHERE topic_id = 7

BACKTRACE

FILE: includes/db/mysqli.php
LINE: 163
CALL: dbal->sql_error()

FILE: includes/functions_posting.php
LINE: 1960
CALL: dbal_mysqli->sql_query()

FILE: posting.php
LINE: 1009
CALL: submit_post()