I run an eggdrop for irc.dapcentral.org and lately people have been asking for the ability to have items and information from this http://www.dapcentral.org/modules.php?o ... dex&show=1, which is a Master List of episodes that the DAP has encoded. It would be useful to type in !episode 304 or something similar and have the eggdrop return information such as MD5 sums or file sizes.
The Master List is hosted on the same box as the eggdrop, and the Master List is driven through MySQL. So, in short, are there any scripts currently written to do this kind of thing, or is there some massively simpler way that I'm not thinking of? Thanks.
This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.
For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.
All data has been migrated (including user logins/passwords) to a new phpBB version.
For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.
SQL Database Call Script?
I'm not sure what you mean. There are scripts and modules that let you access mysql databases. However if you're looking for a script that specifically displays video archives, you're probably out of luck heh.
You could also use data from the webpage instead of directly from the database. There are lots of http scripts you could get and modify.
You could also use data from the webpage instead of directly from the database. There are lots of http scripts you could get and modify.
-
iiKon
No, I'm just looking to have a script that calls up information from a web page. Since the eggdrop is on the same box as the mysql server, I'm just wondering (1) if it would be easier to use a sql call function script, or a http call script and (2) how many of each type of script is available/where I might find them.
The Tcl package comes as standard, with a http package (simply use "package require http" to load it).
There are (from memory) about 5 MySql Tcl packages available.
If yout eggdrop is on the same server as the MySql server, then I recomend this option. There would be less of a performance hit, you will not be using slow Tcl based code to load data (the mysql packges are in C and C++ rather than the pure Tcl the http package is coded in), there is no need to parse data from a web-page, less data actualy returned to the script (only the results that are searched are return in mysql, rather than the whole web-page) and the fact, so long as your DB doesn't change (layout), you can change the web-site, without having to worry abouts eggdrop output.
There are (from memory) about 5 MySql Tcl packages available.
If yout eggdrop is on the same server as the MySql server, then I recomend this option. There would be less of a performance hit, you will not be using slow Tcl based code to load data (the mysql packges are in C and C++ rather than the pure Tcl the http package is coded in), there is no need to parse data from a web-page, less data actualy returned to the script (only the results that are searched are return in mysql, rather than the whole web-page) and the fact, so long as your DB doesn't change (layout), you can change the web-site, without having to worry abouts eggdrop output.