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!

[Marshalus]

Question, I have vBPortal on my site, and want to run this hack on all pages. I added the required code to global.php, but it doesn't display on vBPortal pages, just normal vBulletin pages.

Anyone know what I need to edit in vBPortal to get this to work?

http://www.federationstudios.net (no quotes)
http://www.federationstudios.net/forums (with quotes)

[KuraFire]

at the end of the first page we already encountered problems with that... :/

Don't think that he (whoever he was - can't remember right now) managed to get it working, though....

[Bro_Joey_Gowdy]

This hack works great !!


First go here and see the problem :

(note: you may need to refresh until you see the longer quotes)


http://www.joeygowdy.com/forum/


How can I get them to 'carriage return' or 'break' occasionally ?

Not sure - but I believe the error is on my behalf -

I edited the header template and changed a few things around to display the quotes on the top right side of the forum.

(note: listed in bold is what I modified)

<!-- logo and buttons -->
<center>
<table border="0" width="100%" cellpadding="0" cellspacing="0">
<tr>
<td valign="top" align="left" background="http://www.joeygowdy.com/forum/images/menu_background.gXX"><a href="index.php?s=$session[sessionhash]"><img src="http://www.joeygowdy.com/forum/images/logo_JesusBridgestheGap.gif" border="0" alt="$bbtitle"></a></td>
<td valign="bottom" align="right" nowrap background="http://www.joeygowdy.com/forum/images/menu_background.gif">
<center><font face="verdana,arial,helvetica" size="1" class="sf"> <BR><b><font color="#red">$thequote $thequoter </font></b><br><br><br><br><br><br><br></font></center>

<!-- toplinks -->
$register_or_controlpanel
<a href="calendar.php?s=$session[sessionhash]"><img src="http://www.joeygowdy.com/forum/images/top_calendar.gif" alt="Calendar" border="0"></a>
<a href="memberlist.php?s=$session[sessionhash]"><img src="http://www.joeygowdy.com/forum/images/top_members.gif" alt="Find other members" border="0"></a>
<a href="misc.php?s=$session[sessionhash]&action=faq"><img src="http://www.joeygowdy.com/forum/images/top_faq.gif" alt="Frequently Asked Questions" border="0"></a>
<a href="search.php?s=$session[sessionhash]"><img src="http://www.joeygowdy.com/forum/images/top_search.gif" alt="Search" border="0"></a>
<a href="index.php?s=$session[sessionhash]"><img src="http://www.joeygowdy.com/forum/images/top_home.gif" alt="Home" border="0"></a>
<!-- <a href="member.php?s=$session[sessionhash]&action=logout"><img src="http://www.joeygowdy.com/forum/images/top_logout.gif" alt="Logout" border="0"></a> -->
&nbsp;
<!-- /toplinks -->
</td>
</tr>
</table>
<!-- /logo and buttons -->

<!-- content table -->
<table bgcolor="#FFFFFF" width="100%" cellpadding="6" cellspacing="0" border="0">
<tr>
<td>

<!-- kaotixVIBEinc -->
<script>
<!--
function jumpPage(newLoc) {
newPage = newLoc.options[newLoc.selectedIndex].value
if (newPage != "") { window.location.href = newPage }
}
// -->
</script>
<!-- /kaotixVIBEinc -->

[KuraFire]

just put <br /> inside the longer quotes wherever you want it to start on a new line.

[Bro_Joey_Gowdy]

Works great !!

Thanks !!

Knew it was an error on my behalf.

[Night Owl]

I originally installed this hack and the addon while running vbulletin 2.2.5. It worked great! Then I upgrade to 2.2.6 and installed vbportal.

So, I reinstalled this hack. The quote list is working, the admin cp quote add section is working (both on vbulletin and vbportal. My ONLY trouble is that the quotes aren't showing. Wugh

Any ideas?

http://www.sybermoms.com/forums/index.php

Here is the link to my vbportal main page:

http://www.sybermoms.com/index.php

[KuraFire]

Where are your quotes to appear? And also, where did you put the quote extraction query? (in which file)

[Night Owl]

OK, I figured out how to make the quotes appear.

However, I have had to restrict who's online access to certain groups on my board because of a security problem. But I want those restricted groups to be able to view the quoter list. How can I change the code to enable that?

[Marshalus]

Did you get it working in vBPortal?

[Night Owl]

I gave up on getting it to work in vbportal. Don't really want it there anyway. But I would really like to be able to let all my members submit quotes, even if they can't view the who's online.