I'm not familiar with that mod, do the codes work in a normal post? You can also try saving the QuoteIt! options again.

Hi, I'm looking to apply a very simple random quotation function on my vBulletin. I found yours, I found it much more than what I'm wanting. I was wondering if you--the author of the modification showcased on this thread--might have interest in undertaking such a project? I posted much detail about my request here.

Regards,

Kevin

I probably won't have time, but it looks like what you want is pretty simple. I don't think you'll have a problem finding someone to write it (or you could probably write it yourself if you don't mind spending some time reading tutorials).

Well, I am trying to learn about coding on the vBulletin software, but I've been using it for only a few days (converted from phpBB2, the only forum software I've used beforehand), so I've got a lot of reading to do.

If you do end up having some free time, and would choose to attempt to code my requested modification, I would much appreciate that. Here is the URL for more info and download of the modification I used on my phpBB installation: http://www.phpbbhacks.com/viewhack.php?id=431
There's very little code. I believe it was one or two edits and the uploading of the text file.

So, I screwed up when I upgraded my forum from 3.5.4 to 3.6.8

I uninstalled all hacks for a fresh clean install.
But I do have a functioning backup of the 3.5.4 with hacks still installed.

What I'm trying to do is restore the quotes
Namely;
vb3_quote.sql & vb3_quoteratings.sql

I exported the files from the AdminCP in VB.
I put them in the root directory via FTP.
I'm ready to add them via SSH.
I can't get MyPHPAdmin to work.

Basically I don't want to overwrite the current database, I want to append to it.

So I have SecureCRT and I'm ready to do the SSH upload.

I've been trying to read up on this, but I am confused and I don't want to nuke my current database.

Suggestions / Help Appreciated!
- Ant

Hi Steve,
have been using this mod for a while now and quotes are starting to build up. I have noticed however that my users quote count (in stats section on postbit) is showing as 0 (even for those who have posted quotes. Am I missing something??

Also,

I removed a fair bit of the script to reduce the size of the box on my forum index (as most people do). I now note that there is no-where to rate quotes. Is there a way to add the rate this quote etc in the Quotes page (seen after clicking view all quotes)?

Antwerp - If you open your backup SQL file in a text editor, you should be able to see what part is the table structure and what part is the actual data. If you just delete the table structure parts, the data might be able to be inserted without problems. The only conflict I could think of is the id column of the quotes table, which is the same number as the quoteid column of the quoteratings table. If new quotes have been added to your database since you upgraded, you'll have to adjust these numbers to avoid conflict (any number will work, as long as it's consistent). Be sure to backup your current database before you try anything.

expatdirectory - Try the "Rebuild Quote Counts" option in your control panel. If you open the product XML file in a text editor and search for the name of the template (quote_randomquote for the home page, quote_listbit for the main quotes page, etc.) you'll find the default template and should be able to spot the portion that handles ratings. Look for this:

Thanks for you response.

Now, is the only way to upload the tables through MyPHPAdmin?

Yes, unless you have shell access on your server.

Uninstalled. I have rebuilt bitfields like it says to in the instructions, but i still can't moderate quotes.