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]

It's a mysql issue of poor randomizing in some cases, sometimes this is fixed by flushing mysql or rebooting the server, sometimes nobody has a clue why it doesn't randomize (anymore).

There is no real need to hardcode your quote count and seed on that using PHP instead, but it's an alternative escape method I guess....

[LilDragonWings]

I'm glad it was a mysql issue I only have ftp access to my server space, although my webhost will perform anything I ask them to, which is really great. Since I'm learning php/mysql as I go--glad I don't have to learn unix at the same time.

The php method was the only work around I found that worked for me, and I needed something that was reliable, and wouldn't hang without me knowing.

Thank you very much for a wonderful hack Kurafire !

[KuraFire]

You're welcome

[Dan]

Exactly what I was looking for

/me clicks install

[TheComputerGuy]

ever find a way to convert LEsanes over to yours?

[Gutspiller]

Did anybody get this problem in their profile once they added this hack: http://www.theforumz.com/forumz/memb...tinfo&userid=1

I think it may have been caused by this hack, but I'm not completely sure. I tried removing the lines that the instructions added into the member.php file, but the problems were still there. Did the query run anything that automatically added tables into that page?

If somebody can help me out or check their own profiles on their board if they've installed this hack, it would be a great help to me.

Thanks a bunch!

[Boofo]

The link takes you to the unregistered page. Maybe post a picture?

[KuraFire]

07-06-03 at 09:10 PM TheComputerGuy said this in Post #95
ever find a way to convert LEsanes over to yours?

not really bothered with it, but know this: I Will be looking into it all for when I create the ultimate quote Hack for vB3. It will contain an upgrade script to upgrade either from Lesane's quote hack (or any other if one exists and is popular) and this version of the hack, so that NO quotes you have will be lost, nor will you have to re-enter all quotes manually for when you upgrade to vBulletin 3.

That good enough for ya?

[Gutspiller]

Yesterday at 12:51 AM Boofo said this in Post #97
The link takes you to the unregistered page. Maybe post a picture?

I fixed it. I think I followed the instructions right, but I had the hacks that display "Percent of Total Views" and "Last Post Date".

I think the instructions were messed up for anybody that may have those hacks installed. I got it working by simply reorganizing some of the basic html.

Thanks though.

BTW are profiles regularly only for registered members?

[Gutspiller]

For some reason, my quote rotation rarely rotates quotes and most of the time it will only display the very first quote that was submitted. (which was mine)

Is anybody else having this problem? I don't have that many quotes submitted, but it should still be fairly random shouldn't it?

Can somebody please help me get it so that they are more random instead of showing the same one over and over? I really want to get this hack working.