DELETE cms_bbprivmsgs.*, cms_bbprivmsgs_text.*
FROM cms_bbprivmsgs, cms_bbprivmsgs_text
WHERE cms_bbprivmsgs.privmsgs_id = cms_bbprivmsgs_text.privmsgs_text_id
AND cms_bbprivmsgs.privmsgs_date < 1172793600;
function delete_priv_msgs($user_id) {
global $user_prefix, $prefix, $db;
$priv_msgs = $db->sql_query("SELECT privmsgs_id FROM ".$prefix."_bbprivmsgs WHERE (privmsgs_from_userid=".$user_id." OR privmsgs_to_userid=".$user_id.")");
while($priv_msg = $db->sql_fetchrow($priv_msgs)) {
$result = $db->sql_query("DELETE FROM ".$prefix."_bbprivmsgs WHERE privmsgs_id=".$priv_msg['privmsgs_id']);
$result = $db->sql_query("DELETE FROM ".$prefix."_bbprivmsgs_text WHERE privmsgs_text_id=".$priv_msg['privmsgs_id']);
}
}
DELETE cms_bbprivmsgs.*, cms_bbprivmsgs_text.*
FROM cms_bbprivmsgs, cms_bbprivmsgs_text
WHERE cms_bbprivmsgs.privmsgs_id = cms_bbprivmsgs_text.privmsgs_text_id
AND cms_bbprivmsgs.privmsgs_date <1240005600;
Alle Zeitangaben sind in GMT + 1 Stunden