BeBot - An Anarchy Online and Age Of Conan chat automaton

Archive => Age of Conan Archive => AoC 0.6 support => Topic started by: Heiru on August 27, 2009, 01:12:03 am

Title: A way to export quotes from database?
Post by: Heiru on August 27, 2009, 01:12:03 am

We have some pretty funny quotes that we have gathered over time.  Is there a way to easily export the quotes from the database into some sort of file that is useable to post somewhere?


Thanks ahead of time!

Title: Re: A way to export quotes from database?
Post by: Glarawyn on August 27, 2009, 06:56:08 am

It's a MySQL database, so yes.

How you go about doing so is another matter.

Run the command:

mysql -u USERNAME -p DBNAME
SELECT quote,contributor FROM quotes;

That will dump a list that you can copy and paste.

Or to break it up...
SELECT quote,contributor FROM quotes LIMIT 0,25;
SELECT quote,contributor FROM quotes LIMIT 26,50;