version)) { require_once(dirname(dirname(__FILE__)) . '/init.php'); } // Security check if (!$gallery->user->isAdmin()) { header("Location: " . makeAlbumHeaderUrl()); exit; } $iconElements[] = galleryIconLink( makeGalleryUrl("admin-page.php"), 'navigation/return_to.gif', gTranslate('core', "Return to admin page")); $iconElements[] = galleryIconLink( makeAlbumUrl(), 'navigation/return_to.gif', gTranslate('core', "Return to gallery")); $iconElements[] = LoginLogoutButton(makeGalleryUrl()); $adminbox['text'] = ''. gTranslate('core', "Find and remove comment spam") .''; $adminbox['commands'] = makeIconMenu($iconElements, 'right'); $adminbox["bordercolor"] = $gallery->app->default["bordercolor"]; $breadcrumb['text'][] = languageSelector(); if (!$GALLERY_EMBEDDED_INSIDE) { doctype(); ?> <?php echo clearGalleryTitle(gTranslate('core', "Comment Spam")) ?>
'; offerOptions(); echo ""; $g1_mode=getRequestVar('g1_mode'); echo '\n"; ?>
'; switch($g1_mode) { case 'deleteComments': deleteComments(); break; case 'findBlacklistedComments': findBlacklistedComments(); break; case 'updateBlacklist': updateBlacklist(); break; case 'viewBlacklist': viewBlacklist(); break; case 'editBlacklist': editBlacklist(); break; case 'addBlacklistEntries': showAddBox(); break; default: break; } echo "
%s", gTranslate('core', "Delete Comments")); if (!getRequestVar('delete')) { printf("

%s

", gTranslate('core', "No action taken!")); } else { $removedTotal = 0; foreach (getRequestVar('delete') as $key) { list ($albumName, $imageId, $key) = explode('|', $key); $albumQueue[$albumName][$imageId][$key] = 1; } $albumDB = new AlbumDB(); foreach ($albumQueue as $albumName => $imageQueue) { $album = $albumDB->getAlbumByName($albumName); $removedInAlbum = 0; foreach ($imageQueue as $imageId => $keys) { $photoIndex = $album->getPhotoIndex($imageId); for ($j = $album->numComments($photoIndex); $j > 0; $j--) { $comment = $album->getComment($photoIndex, $j); $key = getCommentKey($comment); if (isset($keys[$key])) { $removedInAlbum++; $removedTotal++; $album->deleteComment($photoIndex, $j); } } } $album->save(array(gTranslate('core', "Deleted %d spam comments"), $removedInAlbum)); } printf("

%s

", gTranslate('core', "Deleted %d spam comment.", "Deleted %d spam comments.", $removedTotal, gTranslate('core', "No comment deleted."), true)); } } function findBlacklistedComments() { global $gallery; $list = array(); $start = explode(' ', microtime()); $albumDB = new AlbumDB(); $totals = array('albums' => 0, 'photos' => 0, 'comments' => 0); $totalComments = 0; foreach ($albumDB->albumList as $album) { set_time_limit(30); $totals['albums']++; $numPhotos = $album->numPhotos(1); for ($i = 1; $i <= $numPhotos; $i++) { set_time_limit(30); $photo = $album->getPhoto($i); $numComments = $album->numComments($i); if ($numComments > 0) { for ($j = 1; $j <= $numComments; $j++) { set_time_limit(30); $comment = $album->getComment($i, $j); $totalComments++; if (isBlacklistedComment($comment)) { $list[] = array('albumName' => $album->fields['name'], 'imageId' => $photo->image->getId(), 'comment' => $comment, 'key' => getCommentKey($comment)); } } $totals['comments'] += $numComments; } } $totals['photos'] += $numPhotos; } $stop = explode(' ', microtime()); $elapsed = ($stop[0] - $start[0]) + ($stop[1] - $start[1]); printf('

'. gTranslate('core', "Scanned %d albums, %d photos, %d comments in %2.2f seconds") .'

', $totals['albums'], $totals['photos'], $totals['comments'], $elapsed); if (empty($list)) { printf("

%s

", gTranslate('core', "No spam comments.")); } else { print makeFormIntro('tools/despam-comments.php', array('name' => 'deleteComments')); print "\n"; printf("\n\t", gTranslate('core', "Entry"), gTranslate('core', "Delete")); foreach ($list as $entry) { print "\n\t"; print ""; print ""; print "\n\t"; print "\n\t" . ''; } print(""); print "
%s %s
"; printf("%s: %s/%s
\n", gTranslate('core', "Location"), makeAlbumUrl($entry['albumName'], $entry['imageId']), $entry['albumName'], $entry['imageId']); printf("%s: %s (on %s from %s)
\n", gTranslate('core', "Commenter"), $entry['comment']->getName(), $entry['comment']->getDatePosted(), $entry['comment']->getIPNumber()); printf("%s: %s
\n", gTranslate('core', "Comment"), $entry['comment']->getCommentText()); print "		"; printf("", sprintf("%s|%s|%s", $entry['albumName'], $entry['imageId'], $entry['key'])); print "
"; print gSubmit('submit', gTranslate('core', "Delete Checked Comments")); print ""; } } function getCommentKey(&$comment) { return md5($comment->getCommentText() . $comment->getDatePosted() . $comment->getIPNumber() . $comment->getName() . $comment->getUID()); } function editBlacklist() { $blacklist = loadBlacklist(); printf("

%s

", gTranslate('core', "Delete from blacklist")); if (!getRequestVar('delete')) { printf("

%s

", gTranslate('core', "No action taken!")); } else { $removed = array(); foreach (getRequestVar('delete') as $key) { if (isset($blacklist['entries'][$key])) { $removed[$blacklist['entries'][$key]] = 1; unset($blacklist['entries'][$key]); } } if (empty($removed)) { printf("

%s

", gTranslate('core', "No action taken!")); } else { $success = saveBlacklist($blacklist); if (!$success) { printf("

%s

", gTranslate('core', "Error saving blacklist!")); } else { printf("

%s

", gTranslate('core', "Deleted %d entry from blacklist.", "Deleted %d entries from blacklist", sizeof($removed), '', true) ); print ""; } } } } function saveBlacklist($blacklist) { return safe_serialize($blacklist, getBlacklistFilename()); } function updateBlacklist() { $blacklist = loadBlacklist(); $dupes = array(); $added = array(); $newlines = split("[\n\r]+", getRequestVar('newBlacklistEntries')); foreach ($newlines as $line) { $line = ereg_replace("#.*", "", $line); $line = trim($line); if (empty($line)) { continue; } // Check for duplicates $key = md5($line); if (isset($blacklist['entries'][$key])) { $dupes[$line] = 1; } else { $blacklist['entries'][$key] = $line; $added[$line] = 1; } } $success = saveBlacklist($blacklist); if (!$success) { printf("

%s

", gTranslate('core', "Error saving blacklist!")); } else { if (!empty($added)) { printf("

%s

", gTranslate('core', "Added to blacklist:")); print ""; } if (!empty($dupes)) { printf("

%s

", gTranslate('core', "Following duplicates were not added:")); print ""; } if (empty($added) && empty($dupes) && empty($removed)) { printf("

%s

", gTranslate('core', "No action taken!")); } } } function viewBlacklist() { $blacklist = loadBlacklist(); printf("

%s (%d)

", gTranslate('core', "Current blacklist"), sizeof($blacklist['entries'])); if (empty($blacklist['entries'])) { print gTranslate('core', "Your blacklist is empty. You must add new entries to your blacklist for it to be useful."); } else { echo insertFormJS('updateBlacklistForm'); print makeFormIntro("tools/despam-comments.php", array('name' => 'updateBlacklistForm')); $blacklistTable = new galleryTable(); $blacklistTable->setAttrs(array('align' => 'center', 'width' => '60%')); $blacklistTable->setHeaders(array(gTranslate('core', "Entry"), gTranslate('core', "Delete"))); $blacklistTable->setColumnCount(2); foreach ($blacklist['entries'] as $key => $regex) { $blacklistTable->addElement(array('content' => wordwrap($regex, 80, "
", true))); $blacklistTable->addElement(array( 'content' => '', 'cellArgs' => array('align' => 'center'))); } $blacklistTable->addElement(array( 'content' => insertFormJSLinks('delete[]'), 'cellArgs' => array('colspan' => 2, 'align' => 'center'))); echo $blacklistTable->render(); print "\n"; printf("\n", gTranslate('core', "Update Blacklist")); print "\n"; } } function showAddBox() { print makeFormIntro('tools/despam-comments.php'); printf("

%s

", gTranslate('core', "Enter new blacklist entries")); print gTranslate('core', "Useful blacklists: "). ""; print gTranslate('core', "You can just cut and paste these blacklists into the text box, or add new entries of your own."); print "
"; print "
"; print ""; printf("", gTranslate('core', "Update Blacklist")); print ""; } function offerOptions() { $options = array( "findBlacklistedComments" => gTranslate('core', "Find blacklisted comments"), "viewBlacklist" => gTranslate('core', "View/Edit blacklist"), "addBlacklistEntries" => gTranslate('core', "Add blacklist entries") ); echo gTranslate('core', "Options"); echo "\n
    "; foreach ($options as $key => $text) { printf("\n\t
  1. %s
    2. ", makeGalleryUrl('tools/despam-comments.php', array('g1_mode' => $key)), $text); } echo "\n
"; } ?>