Was mache ich falsch?
Hier ist mal der Code:
Code: Alles auswählen
$message = $_GET['postid'];
$user = $userdata['username'];
$time = time();
$ip = $_SERVER['REMOTE_ADDR'];
$message_to_admin = 'Folgender Beitrag wurde gemeldet: Link: viewtopic.php?p='.$message.'#'.$message.' von '.$user.'';
$sql = "SELECT COUNT(`privmsgs_id`) AS `total` FROM `".PRIVMSGS_TABLE."`";
if( !( $result = mysql_query($sql) ) )
{
message_die(GENERAL_ERROR, 'Kann keine PN-Daten abfragen', '', __LINE__, __FILE__, $sql);
}
$row = mysql_fetch_array($result);
$post_id = intval($row['total']) + 1;
$sql = "INSERT INTO `".PRIVMSGS_TABLE."` (`privmsgs_type`, `privmsgs_subject`, `privmsgs_from_userid`, `privmsgs_to_userid`, `privmsgs_date`, `privmsgs_ip`, `privmsgs_enable_bbcode`, `privmsgs_enable_html`, `privmsgs_enable_smilies`, `privmsgs_attach_sig`)
VALUES (5, 'Meldung eines Beitrages', '-1', 2, '$time', '127001', 1, 0, 1, 0)";
if( !( $result = mysql_query($sql) ) )
{
message_die(GENERAL_ERROR, 'Kann keine PN hinterlegen', '', __LINE__, __FILE__, $sql);
}
$sql = "INSERT INTO `".PRIVMSGS_TEXT_TABLE."` (`privmsgs_text_id`, `privmsgs_bbcode_uid`, `privmsgs_text`) VALUES ('$post_id', '', '$message_to_admin')";
if( !( $result = mysql_query($sql) ) )
{
message_die(GENERAL_ERROR, 'Kann keine PN hinterlegen', '', __LINE__, __FILE__, $sql);
}
redirect(append_sid('index.'.$phpEx));