Right first things is I am pretty new to tcl and eggdrops, but learning that and MYSQL at the same time.
What I have done so far is for people to visit a webpage and enter come bits of information ie.. username password email and so on.
Now that gets stored to mysql all fine and good from there on I am a bit stuck. I need the bot to allow users to login with the information they entered.. perhaps auth not login (not sure of diffrenece). Now i know about mysql tcl scripts but not sure how to do this.
For example... user visits website and enters
User:
Pass:
Number/ID:
PS: the number id's are all uniqe and they all have one.
Then they join irc and /msg botname auth theiruser theirpass
1. Keep eggdrop/mysql in sync. This option means you have to have a little script on your webserver that updates eggdrop when users are added, deleted, or have their passwords changed. This option is easy in one respect because then users can use all the normal eggdrop things. Also, since most of the time users will not be changing their passwords, it's more efficient to keep them in sync than constantly check against the database.
2. The harder option, but maybe neater, is to write a custom login script. When someone does the auth method that you said, the eggdrop can connect to the database, authenticate, and if it works, create a new user on the spot. The user would only have one hostmask - the exact hostmask of the person who authenticated. When the user leaves the channel, the user entry should be deleted. To be even cooler, if your irc network has something like a watch list, you can let the user leave the channel as long as you don't get a signal that the user disconnected. That would be pretty cool.
Anyway, the two approaches are totally different. It's up to you which one you do. The first one doesn't require any special eggdrop scripts, really, but rather a modification to your website to open a socket to eggdrop and perform some commands. It's quite easy with php (not sure what you're using though). The second option requires no changes to your website, but will need that custom auth script. If you really want to learn tcl, I suppose that's the better option. You should download and install any one of the tcl/mysql modules and learn how to use it. Then you can download an auth script from the tcl archive and edit it -- basically you want to substitute your mysql commands in place of the auth script's password checking routine.
What a long-winded post, good thing I type quickly!
lol yes it was longwindid but also very helpful.. much appreciated
Will go for the first option for now as there is still a lot more to this whole thing that needs doing.. Ill get it working basic then tidy up and advance it as time goes on.
The website is phpnuke (quite heavily modded) but still nuke. So any starter points for this "little script on your webserver"
from there on I am a bit stuck. I need the bot to allow users to login with the information they entered.. perhaps auth not login (not sure of diffrenece). Now i know about mysql tcl scripts but not sure how to do this.