SnakePending gibt dem Administrator von Postnuke die Möglichkeit zentral
alle 'wartenden' Inhalte, z.bsp. eingehende News, neue Termine, neue Links usw.
zu begutachten und freizugeben.
Einfach per <kopieren> und <einfügen> in Ihr
SnakePending-Modul übertragen und das _MYPREFIX mit Ihrem
eigenen Tabellen-Prefix ersetzen:
| |
Name |
URL |
SQL-Query |
| 0 |
Downloads
(new) |
admin.php?module=Downloads&op=main |
SELECT
count(*) FROM _MYPREFIX_downloads_newdownload |
| 1 |
Downloads
(modified) |
admin.php?module=Downloads&op=main |
SELECT
count(*) FROM _MYPREFIX_downloads_modrequest |
| 2 |
FAQ
(unanswered) |
admin.php?module=FAQ&op=FaqCatUnanswered |
SELECT
count(*) FROM _MYPREFIX_faqanswer where pn_answer='' |
| 3 |
reg.
User |
modules.php?op=modload&name=Members_List&file=index |
SELECT
count(*) FROM _MYPREFIX_users |
| 4 |
Referers |
admin.php?module=NS-Referers&op=main |
SELECT
count(*) FROM _MYPREFIX_referer |
| 5 |
Reviews |
admin.php?module=Reviews&op=main |
SELECT
count(*) FROM _MYPREFIX_reviews |
| 6 |
Reviews
(waiting) |
admin.php?module=Reviews&op=main |
SELECT
count(*) FROM _MYPREFIX_reviews_add |
| 7 |
Stories
(waiting) |
admin.php?module=NS-AddStory&op=submissions |
SELECT
count(*) FROM _MYPREFIX_queue WHERE pn_arcd=0 |
| 8 |
Stories
(Sections) |
admin.php?module=Sections&op=main |
SELECT
count(*) FROM _MYPREFIX_seccont |
| 9 |
Web_Links
(new) |
admin.php?module=Web_Links&op=main |
SELECT
count(*) FROM _MYPREFIX_links_newlink |
| 10 |
Web_Links
(modified) |
admin.php?module=Web_Links&op=main |
SELECT
count(*) FROM _MYPREFIX_links_modrequest |
| 11 |
Web_Links
(broken |
admin.php?module=Web_Links&op=LinksListBrokenLinks |
SELECT
count(*) FROM _MYPREFIX_links_modrequest WHERE pn_brokenlink=1 |
| 12 |
Web_Links
(modified) |
admin.php?module=Web_Links&op=LinksListModRequests |
SELECT
count(*) FROM _MYPREFIX_links_modrequest WHERE pn_brokenlink=0 |
| 13 |
Guestbook
(waiting) |
index.php?module=Guestbook&func=main |
SELECT
count(*) FROM _MYPREFIX_nukebook |
| 14 |
My_eGallery
(new) |
index.php?module=My_eGallery&type=admin |
SELECT
count(*) FROM _MYPREFIX_gallery_pictures_newpicture |
| 15 |
PostCalendar
(waiting) |
index.php?module=PostCalendar&type=admin&func=listqueued |
SELECT
count(*) FROM _MYPREFIX_postcalendar_events where pc_eventstatus=0 |
| 16 |
Statistics
(Hits) |
index.php?module=statistics&func=main |
SELECT
pn_count FROM _MYPREFIX_counter WHERE pn_var like 'hits' |
| 17 |
UpDownload
(new) |
admin.php?module=UpDownload&op=main |
SELECT
count(*) FROM _MYPREFIX_updownload_newdownload |
| 18 |
UpDownload
(modified) |
admin.php?module=UpDownload&op=main |
SELECT
count(*) FROM _MYPREFIX_updownload_modrequest |
| 19 |
UpDownload
(broken) |
admin.php?module=UpDownload&op=DownloadsListBrokenDownloads |
SELECT
count(*) FROM _MYPREFIX_updownload_modrequest where
pn_brokendownload=1 |
| 20 |
UpDownload
(modified) |
admin.php?module=UpDownload&op=DownloadsListModRequests |
SELECT
count(*) FROM _MYPREFIX_updownload_modrequest where
pn_brokendownload=0 |
| 21 |
INetJokes |
index.php?module=inetjokes&type=admin |
SELECT
count(*) FROM _MYPREFIX_inetjokes_jokes where pn_status=0 |
| 22 |
Books
(waiting) |
admin.php?module=books&op=BooksWaitingShow |
SELECT
COUNT(*) FROM _MYPREFIX_books_newbook |
| 23 |
Books
(modified) |
admin.php?module=books&op=BooksListModRequests |
SELECT
COUNT(*) FROM _MYPREFIX_books_modrequest WHERE brokenlink = '0' |
| 24 |
Books
(broken) |
admin.php?module=books&op=BooksListBrokenLinks |
SELECT
COUNT(*) FROM _MYPREFIX_books_modrequest WHERE brokenlink = '1' |
| 25 |
Calzone
(new) |
index.php?module=Calzone&type=admin&func=newevents |
SELECT
COUNT(*) FROM _MYPREFIX_calzone WHERE aid =
'0' |
