Some questions:
#1. Does this bog down the server if you are NOT using a dedicated server? This was an issue with the egg-drop method.
#2. How might you store the nick as well for each person in the database? You could probably modify the table to be:
Code:
create table ircstat
( channelname text not null primary key,
channelusers smallint(5) not null default'0',
usernicks text not null
);
But within your perl script, how might with the following query:
Code:
$sql = $vbdb->prepare("UPDATE ircstat SET channelusers=$field[4] WHERE channelname=\"$field[3]\"");
I could insert as well the nick each person (seperated by commas, maybe using variable $nick or $username?) It would be great if the nick corresponded with the persons actual username on the forum, but that would be much more difficult to achieve.
Anyway, if this is possible I'll defiantly consider installing the hack.