egghelp/eggheads community

The best way to do this?

2007-10-30T15:45:15-04:00

Thank you very much!

I'll look into that!

Statistics: Posted by leandro — Tue Oct 30, 2007 3:45 pm

The best way to do this?

2007-10-30T15:43:58-04:00

Lets say you have a mysql database named akicks, with the fields mask, set.

Code:

bind time - "?0 * * * *" akick:updateproc akick:update {min hour day month year} {    if {[catch {[set mysql [mysql::connect -user username -password mypassword -host localhost -port 3306 -db akicks]} err]} {        putlog "mysql error"        foreach line [split $err \n] { putlog "$line" }        putlog "end of error"    } else {        set result [mysql::sel $mysql "SELECT * FROM `akicks` WHERE `set` = '0';" -list]        if {$result == ""} { return }        foreach akick $result {            if {$akick == ""} { return }            set mask [lindex [split $akick] 0]            putlog "adding '$mask' to akick list for #mychannel"            putquick "PRIVMSG ChanServ :akick #mychannel add $mask"            mysql::exec $mysql "UPDATE `akicks` SET `set` TO '1' WHERE `mask` = '$mask';"        }        putlog "updated akicks"    }}

This is just an example, not guaranteed working![/code]

Statistics: Posted by r0t3n — Tue Oct 30, 2007 3:43 pm

The best way to do this?

2007-10-30T13:02:25-04:00

Yes, MySQL.

Can you explain me how to do this in a more detailled manner?

Statistics: Posted by leandro — Tue Oct 30, 2007 1:02 pm

The best way to do this?

2007-10-30T13:00:53-04:00

are you using a SQL database? if yes, you'd better use the mysql package to access directly to the datas.

Statistics: Posted by CrazyCat — Tue Oct 30, 2007 1:00 pm

The best way to do this?

2007-10-30T12:50:36-04:00

Hi.

I'm creating an online database of akicks from a channel. Akicks can be added to the database via a webserver.

I display the newly added akicks on a webpage, which then the eggdrop must read, add them in chanserv, and mark them on the webserver.

But what is the best way to do this? Should I save the whole webpage to a .txt, then loop through the file, opening and closing a connection for each akick that needs to be set? Or should I do something else?

Thanks for your help.

Statistics: Posted by leandro — Tue Oct 30, 2007 12:50 pm