private static function remove_notes($cache_id, $user_id) { if (Settings::get('OC_BRANCH') == 'oc.de') { # we can delete row if and only if there are no coords in it Db::execute("\n delete from coordinates\n where\n type = 2 -- personal note\n and cache_id = '" . Db::escape_string($cache_id) . "'\n and user_id = '" . Db::escape_string($user_id) . "'\n and longitude = 0\n and latitude = 0\n "); if (Db::get_affected_row_count() <= 0) { # no rows deleted - record either doesn't exist, or has coords # remove only description Db::execute("\n update coordinates\n set description = null\n where\n type = 2\n and cache_id = '" . Db::escape_string($cache_id) . "'\n and user_id = '" . Db::escape_string($user_id) . "'\n "); } } else { # oc.pl branch Db::execute("\n delete from cache_notes\n where\n cache_id = '" . Db::escape_string($cache_id) . "'\n and user_id = '" . Db::escape_string($user_id) . "'\n "); } }