imported>mutante mNo edit summary |
imported>RobiH (Removed completed task; Sorted by priority) |
||
(19 intermediate revisions by 2 users not shown) | |||
Line 1: | Line 1: | ||
Antisect |
Antisect is an [[IRC]] [[Bots|bot]] of the [[Eggdrop]] variety. |
||
It is running a selfmade script that can access this |
It is running a selfmade script that can access this [[Mediawiki]]. |
||
<@AntiSect> S23-Wiki script by mutante. Here are the triggers, mutante |
<@AntiSect> S23-Wiki script by mutante. Here are the triggers, mutante |
||
<@AntiSect> .title <string> - SEARCHes for a string in page TITLE (Alias .find) |
<@AntiSect> .title <string> - SEARCHes for a string in page TITLE (Alias .find) |
||
<@AntiSect> .content <string> - SEARCHes for a string in the page CONTENT (Alias .full) |
<@AntiSect> .content <string> - SEARCHes for a string in the page CONTENT (Alias .full) |
||
<@AntiSect> .display <page> - SHOWs the CONTENT of a wiki page (currently firsti 120 chars) |
<@AntiSect> .display <page> - SHOWs the CONTENT of a wiki page (currently firsti 120 chars) |
||
<@AntiSect> .rc - SHOWs the last 5 CHANGES on the Wiki (Recent Changes) |
<@AntiSect> .rc - SHOWs the last 5 CHANGES on the Wiki (Recent Changes) |
||
<@AntiSect> .popular - SHOW the most POPULAR wiki pages (hit count) |
<@AntiSect> .popular - SHOW the most POPULAR wiki pages (hit count) |
||
<@AntiSect> .sysops - SHOW the wiki SYSOPS |
<@AntiSect> .sysops - SHOW the wiki SYSOPS |
||
<@AntiSect> .stats - SHOW the wiki STATISTICS |
<@AntiSect> .stats - SHOW the wiki STATISTICS |
||
<@AntiSect> .teach <page> - Bonus Trigger: Teach [[padma]] (infobot) about <page> ;) |
<@AntiSect> .teach <page> - Bonus Trigger: Teach [[padma]] (infobot) about <page> ;) |
||
<@AntiSect> .help - SHOW this HELP message |
<@AntiSect> .help - SHOW this HELP message |
||
to be extended... |
to be extended... |
||
=== New SQL queries === |
|||
Get recent changes: |
|||
:'''<tt>select rc_title,rc_comment,rc_user_text,rc_timestamp from recentchanges order by rc_timestamp asc limit 3;</tt>''' |
|||
Get most popular page(s): |
|||
:'''<tt>select page_id,page_title,page_counter from page order by page_counter limit 5;</tt>''' |
|||
Search in content: |
|||
:'''<tt>select page_title from searchindex join page on page_id=si_page where si_text LIKE "%Vorbis%";</tt>''' |
|||
Display content (searchtext,plain without wikisyntax) |
|||
:'''<tt>select left(si_text,180) as si_sum from searchindex join page on page_id=si_page where page_title="Ogg";</tt>''' |
|||
--- |
|||
< avar> mutante: use recentchanges |
|||
< Duesentrieb> mutante: :'''<tt>select <stuff> from page join revision on rev_page_id = page_id where <foo></tt>''' |
|||
:'''<tt>select page_id,page_title,page_counter from page join revision on rev_id = page_id where page_title LIKE "Sandbox" limit 1;</tt>''' |
|||
Latest content: |
|||
:'''<tt>SELECT old_text,old_flags FROM `text` order by old_id desc LIMIT 1;</tt>''' |
|||
=== Full Script === |
|||
* http://meta.wikimedia.org/wiki/User:mutante/Eggdrop_TCL_script_for_mediawiki |
|||
=== The nickname === |
|||
[[Antisect (band)|Antisect]] was a british hardcore-[[Punk|punk]] band in the 1980ties. |
|||
[[Category:IRC]] |
[[Category:IRC]] |
Latest revision as of 21:03, 13 August 2006
Antisect 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 <string> - SEARCHes for a string in page TITLE (Alias .find)
<@AntiSect> .content <string> - SEARCHes for a string in the page CONTENT (Alias .full)
<@AntiSect> .display <page> - 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 <page> - Bonus Trigger: Teach padma (infobot) about <page> ;)
<@AntiSect> .help - SHOW this HELP message
to be extended...
New SQL queries[edit]
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";
---
< avar> mutante: use recentchanges < Duesentrieb> mutante: :select <stuff> from page join revision on rev_page_id = page_id where <foo>
- 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;