autoop/autovoice

ny · Post by ny » Tue Jan 18, 2005 6:41 pm

hi,

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...

Ofloo · Post by **Ofloo** » Tue Jan 18, 2005 7:07 pm

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..

^DooM^ · Post by **^DooM^** » Wed Jan 19, 2005 2:44 pm

Ofloo wrote: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.

Ofloo · Post by **Ofloo** » Thu Jan 20, 2005 3:33 am

^DooM^ wrote:
Ofloo wrote: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.

i said a remote mysql server you use http as i suggested ..

, i think it froze tho because it was blocked by firewall

^DooM^ · Post by **^DooM^** » Thu Jan 20, 2005 5:01 am

The Bot was remote to the SqlDB but as you said it could of been firewall issues.

Ofloo · Post by **Ofloo** » Fri Jan 21, 2005 2:56 am

no using a backend php script is a http interface and not a direct connection to the sql server as i suggested

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, ..

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

^DooM^ · Post by **^DooM^** » Fri Jan 21, 2005 7:56 am

I was agreeing with you