* @brief Removes orphaned data from deleted contacts
*/
-use \Friendica\Core\Config;
+use Friendica\Core\Config;
function remove_contact_run($argv, $argc) {
if ($argc != 2) {
$id = intval($argv[1]);
// Only delete if the contact doesn't exist (anymore)
- $r = q("SELECT `id` FROM `contact` WHERE `id` = %d", intval($id));
+ $r = dba::select('contact', array('id'), array('id' => $id), array('limit' => 1));
if (dbm::is_result($r)) {
return;
}
- q("DELETE FROM `item` WHERE `contact-id` = %d", intval($id));
-
- q("DELETE FROM `photo` WHERE `contact-id` = %d", intval($id));
-
- q("DELETE FROM `mail` WHERE `contact-id` = %d", intval($id));
-
- q("DELETE FROM `event` WHERE `cid` = %d", intval($id));
-
- q("DELETE FROM `queue` WHERE `cid` = %d", intval($id));
+ // Now we delete all the depending table entries
+ dba::delete('contact', array('id' => $id));
}
-?>