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.

[ZiRu$]

Originally posted by Lesane
I think that every member from a board likes to contribute on his favorite board by adding quotes. My members loved it to contribute to the forum by adding quotes. Adding quotes of their favorite artist/actor or their own quotes. Why would u take this ability away from them?

In my eyes it's like making a new store hack but then let only admins buy things

lol...i'll stick to lesanes

[Lesane]

Originally posted by KuraFire
Second of all, your hack lists quotes in two small lines. I totally don't like that, looked ugly as hell, so that was one more reason for me to make my own hack.

I had it on 1 line but members requested it to have it on 2 lines because of the tables became out of range.

Originally posted by KuraFire
Thirdly, this hack will, one day, incorporate a Quotes listing similar to memberlist.php and will be searchable and orderable by letter. Is your quotes table structured for that? (just wondering )

Ofcourse

Originally posted by KuraFire
Lastly, your hack (last I checked) didn't display the Quoter, only the member who submitted a quote. That's just taking credit away from ALL those people who made the quotes!

It displays the quoter.

[Lesane]

Originally posted by KuraFire
besides, Lesane, why not let your users contribute by donating to The Cause (tm) of your board, eh?

What are you talking about?

[KuraFire]

money, donations, that green stuff...

you can't counter my first reason, can you?

[dimitr|]

Man, why argue on this? If I want the function of having my users submit quote I choose Lesane's. If I just want just the quote function I use Kura's. Ironically, the reason I went with this one instead was not because my board was too big but too small. Most of my users are not proactive and just swing by to read anything new. I doubt they would really use it, hell the PM function hardly gets used. But already someone commented on how they liked the quotes.

[Boofo]

The main reason I want it is because not all quotes added by users are particually that good or different enough to add to the posting. And how do you tell one user that their post is good enough to add and yet tell another user that theirs isn't without causing a lot of hard feelings along the way? This way, it is up to the Admin to post what THEY like and not have to worry about hurting anyone's feelings ot having to justify themselves.

Just my 2 cents worth. :nervous:

[Zarith]

would it be possible to make links to 1 like graphic text my just putting the html tag inside of what would be the quote?

[Floris]

Originally posted by dimitr|
Man, why argue on this? If I want the function of having my users submit quote I choose Lesane's. If I just want just the quote function I use Kura's. Ironically, the reason I went with this one instead was not because my board was too big but too small. Most of my users are not proactive and just swing by to read anything new. I doubt they would really use it, hell the PM function hardly gets used. But already someone commented on how they liked the quotes.

I second that.

[KuraFire]

Zarith, I'm not quite sure I follow you. What exactly do you want??

[KuraFire]

How to add quotes easily through your Admin Panel
(also known as Hack Update to version 1.0.5 )

Step 1: open your admin/index.php and find this line:

PHP Code:

makenavselect("Options","<hr>"); 


Add ABOVE that, this line:

PHP Code:

makenavoption("Add quote","quotes.php?action=add","<br />"); 


Save your admin/index.php and upload the attached quotes.php to your Admin directory (thus, admin/quotes.php is what it should become).

Done.