Okay, So i assume your going to have a php webpage that is going to place everything into the MySQL database.
So if you had something like
online.php?nick1=on&nick2=on&nick3=off&nick4=on&nick5=on&nick6=offThen in the php, just send
mysql_query("insert into <db> values ($_GET[nick1], $_GET[nick2],...$_GET[nickN]);");Now, you'll get "on" or "off" in the database. You can print out status on the webpage based on whether they are on or off. Now, as for seinding the information, you can use:
-----------------------------
on 1:CONNECT: {
.timerchkonline 0 300 /checkonline
}
alias checkonline {
; set the name of the channel your checking for people on.
/set -u0 %chan
#mychannel ; set the names of the people whom your checking
/set -u0 %people
ATMA KingTomato ... ; Now, ghet status
/set -u0 %a 1
/unset %status
while (%a <= $numtok(%people, 32)) {
/set %status $+(%status,&,$gettok(%people, %a, 32),=)
if ($gettok(%people, %a, 32) ison %chan) { /set %status $+(%status,On) }
else { /set %status $+(%status,Off) }
/inc -u0 %a
}
/sockopen status
www.yoursite.com 80
}
on 1:SOCKOPEN:status: {
if ($sockerr) { /echo -a Error: Could not submit Status }
else {
/sockwrite -n $sockname GET
/online.php [ $+ [ $+(?,%status) ] ] HTTP/1.0
/sockwrite -n $sockname Host:
www.yoursite.com /sockwrite -n $sockname Connection: Keep-Alive
/sockwrite -n $sockname
}
if ($isFile(result.txt)) { .remove result.txt }
}
on 1:SOCKREAD:status: {
/sockread -f &result
/bwrite result.txt -1 -1 &result
}
on 1:SOCKCLOSE:status: {
; now, the result.txt file contains the text that would appear on the webpage
; as if you were to visit it in your browser. Use this to return if it was
; a success.
}
---------------------------------------------------
Change those in red..