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]

Change this query in index.php

SELECT COUNT(id) AS usertotal FROM quote WHERE ok='Y'

to:

SELECT COUNT(*) AS usertotal FROM quote WHERE mod='Y'

and try again?

[Russ]

Removed -0 I'm silly.

[KuraFire]

Originally posted by Russ
We edited this hack ALOT on our site and now it's alot more managable by the Admins.

You're confusing my hack with Lesane's. Mine is perfectly manageable.

Originally posted by Russ
* Allow approval of quotes from one link on the Admin list, without going into the quote, checking yes, and hitting ok.

You don't have to do that with my hack. If you see a quote that needs editing, you edited, if not, you have to hit only 1 single button to moderate all new quotes at once.

So, again, I think you're looking at Lesane's hack...

Originally posted by Russ
* Allows viewing of only the quotes that need approving on the admin list, as well as still the full list.

So does mine, no need to alter that....

Originally posted by Russ
* Displays how many quotes are waiting approval directly underneath the quote on the frontpage - to admins only.

Erm, I have that for admin/index.php - can be added just as easily to ForumHome, of course...

Originally posted by Russ
That, and we've made it's size alot smaller because I didn't think it needed an entire category box for it - check it out on http://forums.buffydownunder.com

Attached a screenie of the admin versions...

And now I'm Quite sure that you are using Lesane's hack, since you're listing 577 quotes on a SINGLE page (that takes quite a while to load) whereas I have a searchable, paged database with an index by letter.

Sorry, but even your hacked version of Lesane's hack is something I wouldn't trade in for my own, Ever. And I really don't see how it's "more manageable" than my hack. I Really don't see it, all I see is that mine is still better, no offense.

And what do you mean by "an entire category box" ???

[Russ]

gulp wwhoopsies,
[high]* Russ rushes to remove previous post [/high]

[Russ]

OK

So now that my attention has been drawn..

any quick way to ditch Lesane's one and install this one?

[KuraFire]

well, just remove the files and file-hacks from Lesane's hack, and install this one including the 2nd post addition And the Admin Panel Extra hack that is on the first page in this thread. However, you'll want to preserve your current quotes table, so you'll have to modify that.

[Russ]

hmm, well that'll take too long

Thanks though.

[KuraFire]

Your loss man.

[Warlord]

*Hits the install button*

Nice hack bro.

[KuraFire]

Okay, I'm gonna put it like this:

if you want the user-tracking add-on (to see which user added what quote(s), and the total being visible in their profile), please e-mail me at:

faruk AT kurafire DOT com

and do not, I repeat, do NOT PM me about it. I can hardly keep track of PM's, let alone any requests made in PM's.

I have one counter-demand though: I'll need to see your board before I send you the add-on instructions. So please include your board URL in the mail.