egghelp.org community Forum Index
[ egghelp.org home | forum home ]		 egghelp.org community
Discussion of eggdrop bots, shell accounts and tcl scripts.
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister 
 ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Ban/Akick/Info using Mysql

 
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help
View previous topic :: View next topic  
Author Message
SirTux
Voice


Joined: 20 May 2008
Posts: 2
PostPosted: Tue May 20, 2008 3:10 am    Post subject: Ban/Akick/Info using Mysql Reply with quote
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
Back to top
View user's profile Send private message
Papillon
Owner


Joined: 15 Feb 2002
Posts: 724
Location: *.no
PostPosted: Tue May 20, 2008 3:41 am    Post subject: Reply with quote
http://www.ucl.ac.uk/is/mysql/tcl/ should get you started Smile
_________________
Elen sila lúmenn' omentielvo
Back to top
View user's profile Send private message MSN Messenger
SirTux
Voice


Joined: 20 May 2008
Posts: 2
PostPosted: Tue May 20, 2008 12:02 pm    Post subject: Reply with quote
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
Back to top
View user's profile Send private message
ztian299
Halfop


Joined: 19 Apr 2008
Posts: 59
Location: *.no
PostPosted: Tue May 20, 2008 12:08 pm    Post subject: Reply with quote
example:

Code:

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 Smile
Back to top
View user's profile Send private message
Sir_Fz
Revered One


Joined: 27 Apr 2003
Posts: 3793
Location: Lebanon
PostPosted: Tue May 20, 2008 3:10 pm    Post subject: Reply with quote
Papillon wrote:
http://www.ucl.ac.uk/is/mysql/tcl/ should get you started Smile

Nice to see you back Wink Very Happy
_________________
Follow me on GitHub

- Opposing

Public Tcl scripts
Back to top
View user's profile Send private message Visit poster's website
Papillon
Owner


Joined: 15 Feb 2002
Posts: 724
Location: *.no
PostPosted: Tue May 20, 2008 4:03 pm    Post subject: Reply with quote
just when I'm bored m8.. just when I'm bored Wink
_________________
Elen sila lúmenn' omentielvo
Back to top
View user's profile Send private message MSN Messenger
Display posts from previous:   
Post new topic   Reply to topic    egghelp.org community Forum Index -> Scripting Help All times are GMT - 4 Hours
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Forum hosting provided by Reverse.net

Powered by phpBB © 2001, 2005 phpBB Group
subGreen style by ktauber