egghelp/eggheads community Discussion of eggdrop bots, shell accounts and tcl scripts. 2005-08-02T07:47:21-04:00 https://forum.eggheads.org/app.php/feed/topic/10182 2005-08-02T07:47:21-04:00 2005-08-02T07:47:21-04:00 https://forum.eggheads.org/viewtopic.php?p=53636#p53636 <![CDATA[mysql table read]]> Statistics: Posted by Galadhrim — Tue Aug 02, 2005 7:47 am

]]> 2005-08-02T05:51:04-04:00 2005-08-02T05:51:04-04:00 https://forum.eggheads.org/viewtopic.php?p=53633#p53633 <![CDATA[mysql table read]]> mysql.mod module and mysqltcl APIs, there's third option for using SQL database with eggdrop: SQLite, small & fast database engine with Tcl interface

Statistics: Posted by demond — Tue Aug 02, 2005 5:51 am

]]> 2005-07-31T05:23:39-04:00 2005-07-31T05:23:39-04:00 https://forum.eggheads.org/viewtopic.php?p=53569#p53569 <![CDATA[mysql table read]]>
what do i need to run mysql ? mysqltcl only ?
You need a mysql server, like the one from your site. (The data doesn't come from a blackhole :D ) And you need mysqltcl. You can talk to the server using the mysqltcl in your tcl script.

Once you got that create a query that gets the user data from the database like

Code: 

SELECT * FROM users WHERE username='$nick'
Then you can read the data and decide if the person can stay or not.

Statistics: Posted by Galadhrim — Sun Jul 31, 2005 5:23 am

]]> 2005-07-30T18:35:49-04:00 2005-07-30T18:35:49-04:00 https://forum.eggheads.org/viewtopic.php?p=53546#p53546 <![CDATA[mysql table read]]> here already? if not, do so

Statistics: Posted by demond — Sat Jul 30, 2005 6:35 pm

]]> 2005-07-30T17:26:41-04:00 2005-07-30T17:26:41-04:00 https://forum.eggheads.org/viewtopic.php?p=53545#p53545 <![CDATA[mysql table read]]>
Im trying to understand mysql and tcl because i want to do a script that uses a database, but i need some help.

first : i want that my eggdrop reads from a database when a user join my channel to see if that user is registered in a website that i run, if the user is not registered the bot will ban him and ask the user to do the registration.

I know how to do the basic TCL for this script, i just cant do the mysql part.

can you give me an example of the code to see +/- how to do it ? what do i need to run mysql ? mysqltcl only ?

the table is small, the fields are

Code: 

  `id` mediumint(8) NOT NULL default '0',  `name` varchar(255) NOT NULL default '',  `mgroup` smallint(3) NOT NULL default '0',  `password` varchar(32) NOT NULL default '',

Thanks

Statistics: Posted by asmds — Sat Jul 30, 2005 5:26 pm

]]>