egghelp/eggheads community

"Reading" a PHP-Query

2003-10-11T13:45:56-04:00

Thx alot egghead!!
I didnt know, where to find that tcl. I used tho old code from Papillon and now it works )

Thx all for your help!

Statistics: Posted by Spirit — Sat Oct 11, 2003 1:45 pm

"Reading" a PHP-Query

2003-10-11T13:18:23-04:00

Papillon gave the code snippet, so he may want to answer the question. But likely you need to use http.tcl that ships with tcl (directory http2.4).

Statistics: Posted by egghead — Sat Oct 11, 2003 1:18 pm

"Reading" a PHP-Query

2003-10-11T13:15:35-04:00

Ok now i get a little further (by using the egghttp.tcl), and there is always this message:

Code:

net: connect! sock 6net: eof!(read) socket 6

by using this code:

Code:

proc pub_!bsd {nick uhost hand chan rest} { set sock [egghttp:geturl http://www.website.com/ircquery.php?pass=secret&select=search¶m=B get_results]}bind pub - !bsd pub_!bsdproc get_results {sock} {   set buffer [egghttp:data $sock]   egghttp:cleanup $sock   putlog $buffer}

I used the example at the end of the script and made sure, that there are any results

Statistics: Posted by Spirit — Sat Oct 11, 2003 1:15 pm

"Reading" a PHP-Query

2003-10-11T11:18:52-04:00

i dont work that much with http scripts, but try using the egghttp:geturl proc instead

Statistics: Posted by GodOfSuicide — Sat Oct 11, 2003 11:18 am

"Reading" a PHP-Query

2003-10-11T11:02:15-04:00

Yep ..egghttp.tcl is loaded, but after your post
Didn't know i need that script *sorry*

Now there is a error:

Code:

Tcl error [pub_!getresult]: invalid command name "::http::geturl"

Statistics: Posted by Spirit — Sat Oct 11, 2003 11:02 am

"Reading" a PHP-Query

2003-10-11T10:49:59-04:00

is there an error on the partyline ?
and : have you loaded egghttp.tcl ?

Statistics: Posted by GodOfSuicide — Sat Oct 11, 2003 10:49 am

"Reading" a PHP-Query

2003-10-11T09:15:00-04:00

Thx Papillon!

Unfortuantely i am not getting any results back. Just for the testing i am posting the results in a dummychan right away.

Code:

proc pub_!getresult {nick uhost hand chan rest} {  set result [::http::data [set tok [::http::geturl http://www.website.com/ircquery.php?pass=secret&select=search¶m=B]]] putchan $chan $result ::http::cleanup $tok}bind pub - !getresult pub_!getresult

The bot is posting, when i fill $result by hand and i get results when i enter the URL in the IE

Statistics: Posted by Spirit — Sat Oct 11, 2003 9:15 am

"Reading" a PHP-Query

2003-10-11T08:33:42-04:00

Code:

set result [::http::data [set tok [::http::geturl http://www.website.com/ircquery.php?pass=secret&select=search¶m=B]]]::http::cleanup $tok#$result conatins the results

Statistics: Posted by Papillon — Sat Oct 11, 2003 8:33 am

"Reading" a PHP-Query

2003-10-11T06:06:45-04:00

Hi @ll!

I got a php-site, which searches a mysql-db and sends me the results as simple text back.
Is it possible to connect with the eggdrop to the page, get the results and post them into a channel?

The URL looks like this: http://www.website.com/ircquery.php?pas ... ch¶m=B

And the results are looking like this:
Bad Boy
Bomber
...

It makes a "B*" search in the database.

Statistics: Posted by Spirit — Sat Oct 11, 2003 6:06 am