comparison admajax.php @ 1030:3a8c016c50fc

Mark related files to be deleted when deleting an entry.
author Matti Hamalainen <ccr@tnsp.org>
date Thu, 19 Nov 2015 20:54:59 +0200
parents 35a00a986f79
children 9fffc9e7e1b6
comparison
equal deleted inserted replaced
1029:35a00a986f79 1030:3a8c016c50fc
1667 $sql = stPrepareSQL("DELETE FROM entries WHERE id=%d", $id); 1667 $sql = stPrepareSQL("DELETE FROM entries WHERE id=%d", $id);
1668 stExecSQLCond($sql, "OK, entry ".$id." deleted."); 1668 stExecSQLCond($sql, "OK, entry ".$id." deleted.");
1669 1669
1670 $sql = stPrepareSQL("DELETE FROM votes WHERE entry_id=%d", $id); 1670 $sql = stPrepareSQL("DELETE FROM votes WHERE entry_id=%d", $id);
1671 stExecSQLCond($sql, "OK, entry ".$id." votes deleted."); 1671 stExecSQLCond($sql, "OK, entry ".$id." votes deleted.");
1672
1673 // Mark files to be deleted
1674 $sql = stPrepareSQL("UPDATE files SET deleted=%d WHERE entry_id=%d", 1, $id);
1675 stExecSQLCond($sql, "OK, entry ".$id." files marked.");
1672 } 1676 }
1673 else 1677 else
1674 if ($type == "compo") 1678 if ($type == "compo")
1675 { 1679 {
1676 // Delete votes for compo entry 1680 // Delete votes for compo entry