Antisect (bot)

Antisect was a british hardcore punk band and is an IRC bot of the Eggdrop variety. It is running a selfmade script that can access this Mediawiki.

<@AntiSect> S23-Wiki script by mutante. Here are the triggers, mutante

<@AntiSect> .title - SEARCHes for a string in page TITLE (Alias .find)

<@AntiSect> .content - SEARCHes for a string in the page CONTENT (Alias .full)

<@AntiSect> .display - SHOWs the CONTENT of a wiki page (currently firsti 120 chars)

<@AntiSect> .rc - SHOWs the last 5 CHANGES on the Wiki (Recent Changes)

<@AntiSect> .popular - SHOW the most POPULAR wiki pages (hit count)

<@AntiSect> .sysops - SHOW the wiki SYSOPS

<@AntiSect> .stats - SHOW the wiki STATISTICS

<@AntiSect> .teach - Bonus Trigger: Teach padma (infobot) about ;)

<@AntiSect> .help - SHOW this HELP message

to be extended...

[x] fix wiki bot commands,broken because of mediawiki upgrade

New SQL queries
Get recent changes:
 * select rc_title,rc_comment,rc_user_text,rc_timestamp from recentchanges order by rc_timestamp asc limit 3;

Get most popular page(s):
 * select page_id,page_title,page_counter from page order by page_counter limit 5;

Search in content:


 * select page_title from searchindex join page on page_id=si_page where si_text LIKE "%Vorbis%";

Display content (searchtext,plain without wikisyntax)


 * select left(si_text,180) as si_sum from searchindex join page on page_id=si_page where page_title="Ogg";

---

mutante: use recentchanges < Duesentrieb> mutante: :select from page join revision on rev_page_id = page_id where 


 * select page_id,page_title,page_counter from page join revision on rev_id = page_id where page_title LIKE "Sandbox" limit 1;

Latest content:


 * SELECT old_text,old_flags FROM `text`  order by old_id  desc LIMIT 1;

Full Script

 * http://meta.wikimedia.org/wiki/User:mutante/Eggdrop_TCL_script_for_mediawiki