trivia sql

spyda · Post by **spyda** » Wed Jun 23, 2004 2:38 am

Designing a trivia bot that will work with mysql.

Dont know much about how sql works, but know enough to do what I want.

Question is... Cause of all the data being stored on the same box the eggdrop is running from, that it is ok to connect to mysql on game start and d/c on stop(kick, split). Only reason is that the eggdrop connects about ever 2-3 seconds to change or read data.

Dont know what would be more stable and more secure. Anyone have any help thanx

------------
Thepope

Quinie · Post by **Quinie** » Wed Jun 23, 2004 6:35 am

I'm making scripts that work with mysql also.
I'm opening and closing connections as the scripts runs.
so this is when every i need to do a query.

You could open een connection al the time and never close it.
But i think opening and closining it when done is the best way to do it but that's just my opinion.

Kimmi · Post by **Kimmi** » Thu Sep 30, 2004 9:59 am

Have any one of U made this script??
Im looking for a script that stores the bots score in a mysql db, but I dont have the tec-skills to do it my self.

Kimmi · Post by **Kimmi** » Tue Oct 05, 2004 4:31 pm

anyone ?

Alchera · Post by **Alchera** » Tue Oct 05, 2004 7:55 pm

Try using the Search function using the keyword 'mysql'. This topic has been covered previously.

Kimmi · Post by **Kimmi** » Wed Oct 06, 2004 4:20 am

cant find it, when I do a search on "mysql" "sql" "trivia mysql" ++++
could the post be deleted of old age ?

Stealthx · Post by **Stealthx** » Wed Oct 06, 2004 8:29 am

Kimmi wrote:cant find it, when I do a search on "mysql" "sql" "trivia mysql" ++++
could the post be deleted of old age ?

How about trying your luck at TCLscript?

qba · Post by **qba** » Sat Dec 18, 2004 3:33 pm

This looks promising if we will see any progress. I've been seeking for a db based trivvia for a long time. There are so many pluses. You can design a web frontend to add questions. Then if you want they may have to be authorized before being addedd to db etc etc...

Any updates?

Quinie · Post by **Quinie** » Wed Feb 23, 2005 10:38 am

Still working on it, most work is done. Basis functions are working.
Send me a email Quinie at Quinie .nl
and i will keep you posted. (i forget topics)

Kimmie has seen it work in test i now i'm configing it to his needs