Wondering what is possible with Bots

Nephand · Post by **Nephand** » Sun Dec 15, 2002 11:08 am

Thought this might be the forum to run with...

I need a network of bots in IRC that can run realtime updates to webspace.

An easy to understand reflection of what I want would be trivia top 10s.

As someone gains points on the channel, they should be updated in a mySQL database in the background.

I would then want the website to also access these points, and reflect on the screen the top 10 that is in IRC. Top 10 lists are a tip of the iceberg, I'd need, or prefer, the bots to use the same userlists that the people login to the website under.

I'm relatively new to these eggdrops and IRC generally, being just a casual user for the most part.

I'm just wondering if a) it is possible to have this, b) if it's practical.

I have heard that for DDoS reasons, it's wise to keep web server and shell server separate, so can I have them both look at the same mySQL database without it being incredibly slow?

Stopping now before I confuse things further, if you need clarification I'll be happy to

ppslim · Post by **ppslim** » Sun Dec 15, 2002 12:00 pm

This is partly possible, but is not for the faint harted.

This is not your average run of the mill script, but more somthign that would be generated for a comercial environment.

Fist off, you would need to create a trivia script, or even convert one, to work with a MySQL DB. This is no problem, and is probably the simplest part.

Using the web-sites userlist is a little harder, and would complicate the trivia script a lot.

As for seperating eggdrop, web-site and DB. Yes, this is true, but not for DDOS reasons.

Regardless of DDOS, or simply software crashes, if the DB goes down, your screwed. If either the bot or the web-server goes down, nothing matters, as life can continue (partly).

The main reason to keep these things seperate, is security, and server load. If you own the system, adn this is the only site, db and eggdrop run, then use a single system, there will be no adverse effects.

However, to top tis thread off, this sort of script is not the sort of thing, one person can create, it would take some time, effort and a good coder to do this. There is no real way to give pointers overall, however, we would be able to help with specific areas.

Nephand · Post by **Nephand** » Sun Dec 15, 2002 12:04 pm

Ahhh, hmm, much appreciated

I would imagine it would be an easier task to have it all work on files, pass those around and filtering, instead of directing into and out of the same database.