thanx allllllllllllot
its great :)

Glad you like ^_^

You're not alone -_-

Mine just sits on ID 1 and once in a blue moon changes to ID 2

Edited: Well it changed to all of them after loads of refreshing.

I know this may sound stupid but how do I get it to get a quote in order?

doesn't work :/

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.

Well it's changed - but now it's sitting on a different one -_-

Any confirmed resolution to the above problems before I install this on my new update? I love it, I just want to make sure it randomizes properly. :)

-Jason

It should work just fine - if it doesn't, it's more likely a problem with your server than the script, really :)

Okay I shall test and report back!

-Jason

Wheres the latest file for this?

I'm having the stuck on a quote problem as well.

At first I had the template called only for users who were logged in (I had done this inadvertantly by putting the call for the home_randomquote template right after the IF statement to test for users.) When it was setup this way, the quote was perfectly random ... However, When I discovered this, I moved the call out side of the user logged in conditional, and it no longer randoms. It stays on the first quote for both logged in and logged out users. I've tried moving it throughout my index.php

Any ideas?

**I FIXED MY PROBLEM**

Changed the random seed by using the following:

srand((double)microtime()*1000000);

$random_number = rand(1,147);

$quot=$DB_site->query_first("SELECT quote,name FROM quotes WHERE id = '$random_number'");

**************

however, you should change the 1,147 to represent the number of quotes you have (this is the range of the random number selected I believe).

I think you can stick in a query to get the number, but i just hard code it...

Good luck !

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....

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 !

You're welcome :)

Exactly what I was looking for

/me clicks install

ever find a way to convert LEsanes over to yours?

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!

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

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? :D

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? :confused:

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. :(

Should be in this thread somewhere, already mentioned etc...

Seems to be working now. Not as random as I'd like, but it's working. I was looking closer in the code and it said the hack is from Lesane. I... umm... don't know it says that because you used part of a hack he did or if I now somehow have his hack mixed up with yours, but changing the the random code in my index.php fixed the hack... whos ever it was. :surprised:

*slaps forehead and rolls eyes*

Lesane's hack is COMPLETELY different and (sorry Lesane) known to be really poorly coded, buggy, etc. etc. and overall just not work.

My hack is completely different from Lesane's, and just so you know: when I recreate my hack for vBulletin 3, there will be an install script that can insert your quotes from Lesane's hack into the new Ultimate Quote Hack (mine) for vB3, if you want.

Well I doubt I will be updating to VB3 since from what I've heard there will be no updating possible from any previous versions of VB. I'm not completely restarting over. Plus my forum prolly already has all the hacks that VB3 does. ;)

Thanks though. It seems to be working now.

However I did have an idea that might get me to switch to your hack. If it would be possible to comment on quotes, that would be cool. I was thinking it would be cool to have who the quote was by hidden to regular members and members had to try and guess where the quote was from. So they could be like movie quotes and it would get some discussion going. The way the hack is going right now, it seems to be working fine, but we don't have many quotes, so as we get more if I notice problems, I may switch over to yours. I think I might have tried yours and had problems with it and my VB version, but I can't remember if it was this hack or another hack.

Commenting on quotes will be an admin-settable option for the Ultimate Quote Hack for vB3.

Hiding the Submitted By will be a usergroup setting, so you can say that usergroup X's quotes will always show the member who submitted, but people from usergroup Y who submit a quote will remain 'hidden'. :)

Do you think it will be possible to use it on a 2.x board? or is it completely different code wise? :(

it'll be vBulletin 3 only, as the code will be 100% different.

Forgive me... I'm a bit of a newbie at this. I've got everything installed and it seems to be working but I can't seem to make it randomize. I know this has been addressed above, but I spent hours trying to figure out what the solution was and couldn't figure it out. I really want to make this work!

So could someone please post a walk-through on fixing the randomizer? Ideally, with a querry instead of a hard-coded random number range.

Thank you, and great hack (if I can get it to work!)

jEd
www.net-benefits.net

that bit of PHP code is NOT from my hack, entirely. "ORDER BY id" did NOT come from _my_ instructions!

It should be ORDER BY RAND(NOW())

Read the first post, or the post above this one, or Boofo's post a bit earlier in this thread (about 15 posts up). You have to use ORDER BY RAND(NOW()) in the query to make it work better.




You can update from 2.2.9 or 2.3.0.

I was running older than that myself, but I just took the queries out of the update scripts, ran those manually, and then I upgraded to vB3. Worked like a charm. It's just a few minor database adjustments that need to be made before you upgrade to vB3 :)

Ok, just to make sure:

In global.php or index.php (depending on where you put the quote) instead of:you should put.

If that's right, I did it and I'm still not getting randomization.

That's right. And you should be getting randomization. Check with your webhost to see about what version MySQL they are running, and whether they shouldn't upgrade it....

Ok, I've added NOW() to the Rand query and it's still not working. I'm running SLQ version 3.23.54 although the The client API built into PHP is only 3.23.49.

Could that be the problem? If not, any other workarounds?

jEd

It could well be because of that, yes. Two versions of MySQL might be conflicting in areas....

Ask your host if they could synchronize that :)

Is the available for vb3.5.3 ?