Based on the error message:
Database error in vBulletin 3.0.6:
Invalid SQL:
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
mysql error: Table 'thestudi_cafe.quotes' doesn't exist
mysql error number: 1146

I wonder if the coding is pulling the 'database name' instead of the 'database prefix' (vb_). I'd really like to get this fixed but right now I'm just getting database errors. So I need to uninstall the hack. What files or database additions are made by the install program?

Thanks.

Edit your index.php.
find:
change to:
That's the only place i could find where the coder missed a table prefix, for the rest all looked nice coded.

PS I have feeling that if you would read this thread from teh beginning, that this solution would already be there somewhere.

That didn't do it.

BTW I have read this thread start to finish. But I took your advice and went through them all again. I came across one post about earlier MySQL versions with an attached code fix to work on the earlier versions. After making that change everything worked! Apparently all of us that are/were having the 'databasename'.quotes doesn't exist error just have earlier versions of MySQL.

Thanks to all for your help.

Well i'll leave it to magnus then, but i think this is what should have fixed it

Marco, I reloaded clean files, went through the install again, made your suggested change, all with the same result. Then it all started working about five minutes ago. Bizarre! Only a couple of minor quirks to fix but it seems to be working. It apparently was the earlier version of MySQL fix.

Does anyone else have the Add A Quote entry screen layout that mine is showing in the attached image? Seems like the first entry box should be located beside the "Quote Author" item.

I went into the addquote template and changed the code to clean this up. It now looks like the window below.

Magnus,

I saw this on someone's site that uses vBadvanced and it looks very interesting. Is it easy for someone to add their own quotes and have those pull automatically and change daily? or do they pull randomly?

Thanks
J

It is setup for registered members and admins to add quotes. Quotes that members add go into a moderation que and are not posted to confirmed by the admin, although you can turn the moderation feature off if you desire. The quotes are setup to randomly change with page refreshes.