egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2005-01-21T07:56:08-04:00 https://forum.eggheads.org/app.php/feed/topic/9008 2005-01-21T07:56:08-04:00 2005-01-21T07:56:08-04:00 https://forum.eggheads.org/viewtopic.php?p=45657#p45657 <![CDATA[autoop/autovoice]]>

Statistics: Posted by ^DooM^ — Fri Jan 21, 2005 7:56 am

]]> 2005-01-21T02:56:35-04:00 2005-01-21T02:56:35-04:00 https://forum.eggheads.org/viewtopic.php?p=45654#p45654 <![CDATA[autoop/autovoice]]>
the direct connection to mysql server had problems you know using mysqltcl, because its a sync socket and not assync there for the bot waits untill the socket ends.. i suppose..

still when your working remotly its not suggested because the server might not always be reachable, so.... i am not sur what froze it .. just saying, only thing i did know was that it froze even when i opend the socket it froze so..

and because ive used http servers a few times myself and they seemed to work just fine..

altho don't use the http lib from tcllib the eggdrop crashes after a few times, thats my experiance

by direct connection i mean to the mysql daemon and not use any backend crap, ..

never mind.. , just you say that its not true , because you use http all the time i am not talking about http, i was talking about a direct connection to mysql daemon, ..

:P don't wana be offensive in anyway just pointing out that you should read it a bit closer ;)

or i miss understood and your just agreeing .. in that case never mind the comments

Statistics: Posted by Ofloo — Fri Jan 21, 2005 2:56 am

]]> 2005-01-20T05:01:49-04:00 2005-01-20T05:01:49-04:00 https://forum.eggheads.org/viewtopic.php?p=45585#p45585 <![CDATA[autoop/autovoice]]>

Statistics: Posted by ^DooM^ — Thu Jan 20, 2005 5:01 am

]]> 2005-01-20T03:33:57-04:00 2005-01-20T03:33:57-04:00 https://forum.eggheads.org/viewtopic.php?p=45580#p45580 <![CDATA[autoop/autovoice]]>
use mysql tcl do a select query and read from the db, i should say that its preferably that you make sutch a thing local because in my experiance eggdrops connecting to a remote mysql db have trouble they freeze.. , but you could write an php script that reads it for you serv it on your http then make the eggdrop use http protocol to read it out..
I wrote a backend php script that requested the information from my mysql database.

Depending on what was passed through $_get, php pulled the requested information out of the database and in tcl parsed the webpage returned. I Never had my bot freeze doing it this way. I Also added a queue system for if the http was down or couldn't connect it retried every minute until it was back then executed the queue. :wink:
i said a remote mysql server you use http as i suggested .. :P, i think it froze tho because it was blocked by firewall

Statistics: Posted by Ofloo — Thu Jan 20, 2005 3:33 am

]]> 2005-01-19T14:44:10-04:00 2005-01-19T14:44:10-04:00 https://forum.eggheads.org/viewtopic.php?p=45543#p45543 <![CDATA[autoop/autovoice]]>
use mysql tcl do a select query and read from the db, i should say that its preferably that you make sutch a thing local because in my experiance eggdrops connecting to a remote mysql db have trouble they freeze.. , but you could write an php script that reads it for you serv it on your http then make the eggdrop use http protocol to read it out..
I wrote a backend php script that requested the information from my mysql database.

Depending on what was passed through $_get, php pulled the requested information out of the database and in tcl parsed the webpage returned. I Never had my bot freeze doing it this way. I Also added a queue system for if the http was down or couldn't connect it retried every minute until it was back then executed the queue. :wink:

Statistics: Posted by ^DooM^ — Wed Jan 19, 2005 2:44 pm

]]> 2005-01-18T19:07:58-04:00 2005-01-18T19:07:58-04:00 https://forum.eggheads.org/viewtopic.php?p=45526#p45526 <![CDATA[autoop/autovoice]]> Statistics: Posted by Ofloo — Tue Jan 18, 2005 7:07 pm

]]> 2005-01-18T18:41:52-04:00 2005-01-18T18:41:52-04:00 https://forum.eggheads.org/viewtopic.php?p=45523#p45523 <![CDATA[autoop/autovoice]]>
on a mysql based bulletin board i have a table
bb1_users with a lot of fields, three of them are
"ismod"
"issupermod"
"isadmin"

my eggdrop should autovoice peoples on join who are
ismod = 1
and autoop peoples who are
isadmin = 1
issupermod = 1

and the nicknames must be regged by nickserv

how must my query look on my eggdrop an otherway is to fetch a php generated file with the infos on it...

Statistics: Posted by ny — Tue Jan 18, 2005 6:41 pm

]]>