This is the new home of the egghelp.org community forum.
All data has been migrated (including user logins/passwords) to a new phpBB version.


For more information, see this announcement post. Click the X in the top right-corner of this box to dismiss this message.

Ban/Akick/Info using Mysql

Help for those learning Tcl or writing their own scripts.
Post Reply
S
SirTux
Voice
Posts: 2
Joined: Tue May 20, 2008 3:03 am

Ban/Akick/Info using Mysql

Post by SirTux »

Hi to all !

I am looking on a way to make some new features with my egdrops i Actualy run 4 eggdrops in my irc network as IRCop with suces using self made script on outo baning and akicking malicious ip and users what i am trying to do is take it in a more advanced step by implementing mysql in this metter. what i want to do is have a central database where i can store my safe ip's like ips that i dont want to be banned from network also have like a "[censored] liste" and also give the ability to my ircop to check ip over the net. i know this is going to be a long proces but i will appretiate any one who can give me tips on starting this project its gona be the first time i write a mysql related tcl script
sincerely
User avatar
Papillon
Owner
Posts: 724
Joined: Fri Feb 15, 2002 8:00 pm
Location: *.no

Post by Papillon »

http://www.ucl.ac.uk/is/mysql/tcl/ should get you started :)
Elen sila lúmenn' omentielvo
S
SirTux
Voice
Posts: 2
Joined: Tue May 20, 2008 3:03 am

Post by SirTux »

Thnx Papillon that would be a good start for me new in mysql tcl scripting. I want to know also some more tips like would be better or posibe to write a separate mysqltcl script to call the database and other scripts for actions like calling the proc`s from the tcl and easly to ad more features later on this are the kind of tips I am looking for. Thnx again guys
z
ztian299
Halfop
Posts: 59
Joined: Sat Apr 19, 2008 4:57 pm
Location: *.no

Post by ztian299 »

example:

Code: Select all

set db [mysqlconnect -user USER -password PASSWORD -db DATABASE]
#example of connect

set test [mysqlexec "INSERT INTO table (text1, text2) VALUES ('$text1', '$text2'"]
#example of INSERT query
And so on :)
User avatar
Sir_Fz
Revered One
Posts: 3794
Joined: Sun Apr 27, 2003 3:10 pm
Location: Lebanon
Contact:

Post by Sir_Fz »

Papillon wrote:http://www.ucl.ac.uk/is/mysql/tcl/ should get you started :)
Nice to see you back ;) :D
User avatar
Papillon
Owner
Posts: 724
Joined: Fri Feb 15, 2002 8:00 pm
Location: *.no

Post by Papillon »

just when I'm bored m8.. just when I'm bored ;)
Elen sila lúmenn' omentielvo
Post Reply