The Ultimate Quote Hack!!

IF THIS HACK DOESN'T RANDOMIZE WELL FOR YOU, DO THIS:
(by Boofo)
"You need to change the RAND() to RAND(NOW()) to make it more random with the new versions of mySQL since version .54

The NOW will seed it and make it more random that it was before. "

That should fix the problem for a lack of randomized quotes.
ALSO NOTE THIS:
There's a bit of code going around that's 'unofficial' (ie. looks like it's from this hack, but it's adjusted and now flawed), saying "ORDER BY id" in the Query that gets the random quote. This is BAD CODE as it doesn't randomize anything at all. It should say "ORDER BY RAND(NOW())" instead.

</end Hack Issue Fix>


*drumroll*

It's here!

What does this hack do:

* it's an extension (big time!) on the Admin-only controlled hack I released earlier. If you installed that hack already, it should be pretty clear for you which steps you should ignore in the Instructions for this hack. What you Cannot ignore is the step about your Admin Panel, and the lines to add to admin/index.php !

* It lists a random quote either on your Forum Home, or in your Header. Next to that, it adds a Quote List, which is just a massive database of quotes that works just like the Memberlist, but with your quotes. It's searchable, and with the Add-on (see post #2!) users can also add quotes in it (which need moderation, before showing up online).

* Quotes can be added, edited and deleted from your Admin Panel. With the add-on, you can moderate quotes from your AP as well.

* There are no hard-coded colors. All colors are taken from your style, so all pages will appear in concordance of whatever style it is you're using.

Install instructions are in the zipfile: uqh_instructions.txt

For the add-on, see the second post, instructions file: w-add_instructions.txt


Have fun!

[KuraFire]

That's WAY more complex than the admin panel home thingy!

Too ****ing complex, for my taste.


This is what to do if you installed Freddie's Quick Stats hack, for your admin panel home:

Find in admin/index.php :

PHP Code:

$mysqlversion = $DB_site->query_first("SELECT VERSION() AS version"); 


ADD BELOW:

PHP Code:

$quotesmod    = $DB_site->query_first("SELECT count(*) AS count FROM quotes WHERE mod='N'"); 


FIND:

PHP Code:

makelabelcode('New Posts Today:', $newposts['count']); 


ADD BELOW:

PHP Code:

makelabelcode("Quotes awaiting <a href=\"quotes.php?s=$session[sessionhash]&action=moderate\">moderation</a>:", $quotesmod['count']); 


(edited: I turned "moderation" into a link, even easier now ^_^)

Again, this is if you have Freddie's hack already installed. If not, then you'll have to do a manual output of some kind. The query to add doesn't need changing, though the output will probably need changing if you don't have Freddie's hack.

And with this, it'll display "Quotes awaiting moderation: [number]" in your Admin Panel Home.

[Boofo]

Thanks, that fixed my problem. It might not be a bad idea to add that to the quotes.php in your hack in case someone esle runs into that.

As far as having to put a name or letter in, with the editing capabilites, that is something that could always be done later if someone decided to go that route. I will never use that on my site as I will not doing the quote listing for the users.

Originally posted by KuraFire
Ah, yes, I haven't htmlspecialchar'd the inputs, since on my own board I use no ""s around quotes. If you want them to display around each quote (ie. "this is a quote") you should better just add &quot; in your templates. Much easier to take them off again if you decide to, at one point.


The other issue: if you save without a letter, the quote will not show up in the Quotes List, Ever. And if you intend to disband the Quoter (Name) part, you can just fill in a dash ( - ) or so for the quoter name, or "Unknown" or whatever. Filling in nothing is a bad idea.

[KuraFire]

to add _what_ to quotes.php ?

The Admin Panel Home moderation queue? That's an admin/index.php hack...

if not, then what?

[Boofo]

The fix you gave me in Post #12, remember?

Originally posted by KuraFire
to add _what_ to quotes.php ?

The Admin Panel Home moderation queue? That's an admin/index.php hack...

if not, then what?

[KuraFire]

Ah, yes, well, since it's a bad idea to have ""s in quotes themselves, why bother, really?

And for those who think their users will accidentally add quotes, there's two things to do: read the whole of this thread (it won't hurt them), or edit that template so that it says "Don't add ""s to your quote!" or whatever.

[Boofo]

Well, whatever you think is fine by me. It was just a suggestion to avoid a lot of questions later. I only wanted it for the editor anyway.

[MrLister]

Thanks, looks great

[Floris]

Ah, very cool, .. Does this also show in the profile of a member the total amount of quotes they have added? And .. does this also show on the frontpage, the total amount of quotes in the database, and maybe on top, top quoter:
Would be nice (no, it would be sweet)

This probably is the reason I haven't seen you on IRC for a while :P You were coding leetnez

[KuraFire]

boofo, btw, that htmlspecialchars fix isn't necessary in this hack. The hack has a TEXTAREA field for the Quote, the former hack (which you have) still used a Text Input field for the quote, but with TEXTAREA ""s don't matter anymore. So people who install this from scratch won't have a problem at all...

[Boofo]

Do I need to upgrade anything then? Or will it work the same after adding what you told me to add? I uploaded the new quote.php (with your fix added) and did the admin/index.php, but other than that I didn't add anything else. Is there anything I should replace?