ngemus quote script

[elachys]

is it stored in a database or in a text file, if its in text can i have a copy 'cause there all really great quotes.

[scottlc]

You can find quotes easy if you ask Google.

[GSDragoon]

I would like a copy of the too. I was keeping a txt file of the really good ones, but my comp took a crap last week and I had to format without able to back anything up. But at least they're back on the main page.

[elachys]

i know how to make a quote script that not the question, this question is that i like the quotes and would like a copy ! ¬_¬

[[Unknown]]

I would hope they are stored in the database, for speed... and, you can probably find a great list if you just copy one of them and shuck it into Google with "s around it. Maybe add "quotes" to the query... you'll find a lot, I'm sure.

-[Unknown]

[scottlc]

Actually, in this situation using a database would not give speed increase since you are only reading the data and not querying the data.

For quotes:
http://www.brainyquotes.com/

[elachys]

thanks for the info, i thought database for speed also but then i thought a txt file would be easier to add quotes to.

[[Unknown]]

Originally Posted by scott_uk5

Actually, in this situation using a database would not give speed increase since you are only reading the data and not querying the data.

For quotes:
http://www.brainyquotes.com/

Yes, but if you have a long list of items, it being indexed can greatly increase the speed of things.

File based method:

PHP Code:

$quotes = file('quotes.txt');
echo trim($quotes[rand(0, count($quotes) - 1)]); 


(slow)

Database method:

PHP Code:

SELECT quote, author
FROM quotes 
ORDER BY RAND()
LIMIT 1 


(faster because there's less database access, and the file will be cached better by MySQL.)

Full files and eval'd data are faster as flat files, however.

-[Unknown]

[scottlc]

But if you store them in seperate files:

$number = int(rand(9)) + 1;
open(FILE, "<$number.txt");
print while <FILE>;
close FILE;

[[Unknown]]

Originally Posted by scott_uk5

But if you store them in seperate files:

$number = int(rand(9)) + 1;
open(FILE, "<$number.txt");
print while <FILE>;
close FILE;

True, but then you limit yourself - your example can only have a fixed number of quotes. Plus, you'll fill the directory with a kabillion files, and the shear file access alone might slow your server. (because it will be harder to cache a lot of files than a single file.)

-[Unknown]

[elachys]

unless they have a section in the admin panel then inputing them into a database would be a load of crap and even with that you'd have to put them in one at a time so unless they have no life then there is no scence to that methot, a txt file although slower would be alot easier to update and make the initial file for and thus they still have a life. besides since you mainly build a site for the 56K user (which is what most people use, although some may question this) it wouldn't make anysort of noticable difference to the speed .

[[Unknown]]

Originally Posted by little knipper

unless they have a section in the admin panel then inputing them into a database would be a load of crap and even with that you'd have to put them in one at a time so unless they have no life then there is no scence to that methot, a txt file although slower would be alot easier to update and make the initial file for and thus they still have a life. besides since you mainly build a site for the 56K user (which is what most people use, although some may question this) it wouldn't make anysort of noticable difference to the speed .

That kind of thinking is what makes programs and sites slow. Every thing adds up, and before long you've added .05 seconds to the load time. (which is noticable, especially when the load gets higher and more people are browsing, ie. on sites like this.)

It would not be that difficult, you just parse the stupid text file into a few inserts (read in the lines and output every 500 or so as inserts.) and then chug it in top the database. Just because you use phpMyAdmin and prefer to insert manually for some reason doesn't mean everyone does.... how do you think this forum works? Some fool inserts every post as it's made?

It can easily be done - admin interface or not - and it's faster... so there's no reason to limit yourself.

Sorry, I was a bit sarcastic - I've had a bad day so far... didn't mean anything by it.

-[Unknown]

[elachys]

>>
Sorry, I was a bit sarcastic - I've had a bad day so far... didn't mean anything by it.
hey no problem at least your willing to argue your point, i also think its nice that you think bobbi and the others don't have lives and would rather enter hundreds of quotes all day
personally since i have 8 months to do 2 years worth of work (i'm a last year GCSE studient )
i'd love to know how bobbi and the staff have time to even moderate the forums let alone spend a couple of hours a week updating the quotes.
hehe i had a bad day as well and its only 8 in the morning

[[Unknown]]

Originally Posted by little knipper

i'd love to know how bobbi and the staff have time to even moderate the forums let alone spend a couple of hours a week updating the quotes.
hehe i had a bad day as well and its only 8 in the morning

Heh... happens to the best of us . Moderating a forum is hard - I should know, I'm an administrator on like 5 of them.

And... are the quotes ever updated?

Anyhow... to show some proof, you could just parse the file like so: (I'm not a fan of obfusication, so I'll give PHP not Perl :P.)
(note that this is rough, it's not like I'm planning to package and distribute this :P.)

PHP Code:

$quotes = file('quotes.txt'); // Get the file, split by newlines.
$count_quotes = count($quotes); // Don't recalculate each iteration.
$query = '';
for ($i = 0; $i < $count_quotes; $i++)
{
    $query .= '
    (' . addslashes(rtrim($quotes[$i])) . '),';

    if (($i + 1) % 50 == 0)
    {
        mysql_query('
  INSERT INTO quotes (quote)
  VALUES' . substr($query, 0, -1));
        $query = '';
    }
} 


However ugly that may look, that could easily and quickly insert all the quotes right into the database. You can administrate them qith simple queries like this: (assuming you put a quote_id column on the table that was auto_increment..)

# Get the ID of a quote for editing or something.
SELECT quote_id
FROM quotes
WHERE quote LIKE '%Einstein%';

# Change something in all quotes.
UPDATE quotes
SET quote = REPLACE(quote, 'Einstein', 'Onemug');

So... I don't see how this is harder to work with... the SQL query aspect only seems to make it easier than the clunky "search and replace" tools of text editors.

-[Unknown]

[scottlc]

What's wrong with Perl? It is easy to read.

[elachys]

ok fine you've shown off enough
i'll shut up and leave you alone

[Kingo]

Try downloading e-books use a p2p or google
there it´s a lot of info out there.

[[Unknown]]

Originally Posted by little knipper

ok fine you've shown off enough
i'll shut up and leave you alone

Eh?

Sorry, I was meaning to help. Got on a side arguement... didn't mean to "push you out of the way" so to speak...

That's how you'd do it though - it's tough at first (for everyone, me, you, Bill Gates, etc.) but that's only more reason to go ahead and do it..

-[Unknown]