Admin-controlled (only) random quote hack for header/homepage

What does this hack do?
It adds a quote and the quoter to your board, either in your header/footer (hack global.php) or on your forumhome page (hack root/index.php).

What's the additional server load of this hack?
It adds 1 query to each page you have a quote show up on. If you add it to global.php it'll add 1 query to ALL pages, if you add it to root/index.php it'll only add 1 query to your forumhome, but you won't be able to show the quotes anywhere else.

Why should we use your hack and not one of the two other quote hacks?
Mine is extremely easy (_I_ made it, and I'm a n00b!) but, more importantly, it doesn't allow your users to enter quotes nor does it put it on two silly lines (no offense Lesane, but that aspect, I found absolutely horrid). This is useful if you have a lot of users and don't feel like spending 4 hours a day moderating all new quote-submissions your members made. Or, if you just want full control.

Instructions:
Step 1: run this query on your vBulletin database (I suggest in phpMyAdmin):

PHP Code:

CREATE TABLE quotes (
  quote text NOT NULL,
  name text,
  letter tinytext,
  id int(11) NOT NULL auto_increment,
  PRIMARY KEY (id)
) 


Step 2 a: if you want it to appear in your header/footer on ALL pages, open global.php and find this line:

PHP Code:

// ###################### Start templates ####################### 


Add ABOVE that, this code:

PHP Code:

// quotes hack by KuraFire
 $quot=$DB_site->query_first("SELECT quote,name FROM quotes ORDER BY rand() LIMIT 1");
 $thequote = $quot['quote'];
 $thequoter = $quot['name']; 


Step 3 a: save global.php and edit your header/footer template. Put in $thequote for the quote, and $thequoter for the quote's quoter, ie. the person who said the quote.


Step 2 b: if you want this to appear only on your forumhome, open root/index.php and find this line:

PHP Code:

// get total posts 


Add ABOVE that, the following:

PHP Code:

// quotes hack by KuraFire
 $quot=$DB_site->query_first("SELECT quote,name FROM quotes ORDER BY rand() LIMIT 1");
 $thequote = $quot['quote'];
 $thequoter = $quot['name']; 


Step 3 b: save your root/index.php and edit your forumhome template (won't work on forumhome_whatever or so, only on your main forumhome template). Add $thequote for the quote, and $thequoter for the quote's quoter, ie. person who said the quote.

That's it. I left it up to you entirely where and how you add the quote and quoter, seeing as how people will place it in different places entirely.

Attached is a small selection of my own quotes database. Not all of it, for a: it'd be quite a lot, and b: it took me a lot of work to get those quotes together and into a database, neatly, and I'm not done processing my entire collection yet so I'm not making my entire quotes database publicly available.
To add these 100 quotes to your database, run the contents of 100quotes.sql as a query in phpMyAdmin on your database.

In the second post, I will add a screenshot.

This hack is really basic, Kura, I'm sure you can do more with this! What's your plan, my man?
Self-imployed vote of confidence, woohoo!
*cough* anyway, yeah this is actually just the first part of a rather big hack I have in mind, though not yet in true development. What I'm Planning to create, is a quote index very similar to the memberlist, but then about quotes. You'll have noticed that the structure of the `quotes` table that this hack adds, includes a "letter" column. This is solely for the purpose of making the quotes table searchable by letter, later on. Like, when you click on members, you'll have the option to select all members by a single letter. Same with the quotes list I am working on (in my mind mostly, thus far).

(edit: this quotes listing is now done. Contact me if you want an early release)

UPDATE IN POST #20: Admin Panel Addition for easy Quotes adding!


[high]* KuraFire awaits response again...
[/high]

Edit: credit goes out to Lesane for being the first one to have made a quote hack, of course, but this one is different, and I think it's good for people to be able to have a choice.

[zootsuit]

I have Lesane's quote hack on my site and I love it...

...as for the author of the quote not being mentioned, that's BS...it's offered now, and my members LOVE it.

Looks awesome as well...fits in perfectly.

[KuraFire]

Yes, well, I have the Quotes List hack fully functional now, similar to the member list but for my quotes, and it works like a charm. Does Lesane's hack include that yet?

[Boofo]

Is there any way to add a function to edit the quotes in case I want to add the quoters name to quotes if I don't already have them? And, also it might be nice to be able to edit spelling and things like that if we missed it when entering them and things like that.

I guess I don't get the lettering part of it. I just went through the alphabet when entering them and started back at "a" when I hit 27 quotes. Does that copy over the first one if I reuse the alphabet again?

[KuraFire]

Boofo, I totally don't get what you mean by the second part... :/

Hmm, edit function... I'll see about adding that before I release the whole thing as the Ultimate Quote Hack. It'll be a bit more difficult but I'll have it done with that UQH release. You'll have to wait a bit for it, though....

[Lesane]

Yes, well, I have the Quotes List hack fully functional now, similar to the member list but for my quotes, and it works like a charm. Does Lesane's hack include that yet?

Mine don't includes that and it will never include that. Mine will never include any addon u make for your hack. It's not a race or something.

[KuraFire]

Boofo: btw, you can edit your quotes in phpMyAdmin though, and if you don't have that, it's a Big loss and you should try getting it installed on your webhost cos it makes your vB-management life So much easier.

Lesane: I know, but a quotes list is simply an extremely useful feature.
It's not a race indeed, but why did you say "Ofcourse" (above, post #12) in response to my question about your hack having a Quotes list that's sortable, orderable and searchable, if you're now saying you'll never have that?

[Boofo]

I'm referring to the letters that the quote.php asks for at the bottom of the screen.

Quote
Name
Letter

I entered "a" thru "z" for 26 quotes and then started over at "a" when I hit 27 quotes. What do the letters represent? And do I need to use them for each quote entered?

[Boofo]

Still, a quote editor in the admin cp would be easier and nicer.

[Lesane]

Originally posted by KuraFire
Lesane: I know, but a quotes list is simply an extremely useful feature.
It's not a race indeed, but why did you say "Ofcourse" (above, post #12) in response to my question about your hack having a Quotes list that's sortable, orderable and searchable, if you're now saying you'll never have that?

The only question you asked me about that is: "Is your quotes table structured for that?" and yes i replied with "yes" on that question. And look:
http://www.lesane-crooks.com/board/userquote.php

And yes i know yours will be different with searchable features blah blah. I ain't telling you that my quote hack already have an editing feature etc etc. So... could u plz stop with finding another comparing with my hack? I'm glad yours is different otherwise this thread was useless!

[KuraFire]

Boofo: the Letter is for the search index in the upcoming Quote List hack.

Quote:
The optimist thinks that this is the best of all possible worlds, and the pessimist knows it.

Name:
J. Robert Oppenheimer

Letter:
O

(as in, Oppenheimer)

---

Quote:
Woman was God's second mistake.

Name:
Friedrich Nietzsche

Letter:
N


See how it works, now? In the upcoming Quotes List, people can click on a letter (ie. `N`) and it will display all quotes made by people whose last names start with an N. Since you can't index it through the name column (try doing a reg.ex on "Sir General S. Patton" for instance. ) the Letter column is for the search index.
I am guessing you'll now have to fix 27+ quotes in your database?