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.

trivia sql

Old posts that have not been replied to for several years.
Locked
s
spyda
Halfop
Posts: 64
Joined: Mon Aug 12, 2002 2:22 am
Location: Australia

trivia sql

Post by spyda »

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
Q
Quinie
Voice
Posts: 27
Joined: Fri Jan 09, 2004 5:29 am
Location: NL
Contact:

Post by Quinie »

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.
K
Kimmi
Halfop
Posts: 58
Joined: Thu Jul 24, 2003 4:17 pm
Location: Norway
Contact:

Post by Kimmi »

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@EFnet
K
Kimmi
Halfop
Posts: 58
Joined: Thu Jul 24, 2003 4:17 pm
Location: Norway
Contact:

Post by Kimmi »

anyone ?
Kimmi@EFnet
User avatar
Alchera
Revered One
Posts: 3344
Joined: Mon Aug 11, 2003 12:42 pm
Location: Ballarat Victoria, Australia
Contact:

Post by Alchera »

Try using the Search function using the keyword 'mysql'. This topic has been covered previously.
Add [SOLVED] to the thread title if your issue has been.
Search | FAQ | RTM
K
Kimmi
Halfop
Posts: 58
Joined: Thu Jul 24, 2003 4:17 pm
Location: Norway
Contact:

Post by Kimmi »

cant find it, when I do a search on "mysql" "sql" "trivia mysql" ++++
could the post be deleted of old age ?
Kimmi@EFnet
User avatar
Stealthx
Halfop
Posts: 68
Joined: Fri Oct 01, 2004 3:37 am
Location: StealthBox

Post by Stealthx »

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? :mrgreen:
+ Stealth Box +
q
qba
Voice
Posts: 5
Joined: Tue Dec 14, 2004 4:13 pm

Post by qba »

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?
Q
Quinie
Voice
Posts: 27
Joined: Fri Jan 09, 2004 5:29 am
Location: NL
Contact:

Post by Quinie »

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) :P

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