Version: 1.00, by magnus
Developer Last Online: Feb 2012
Version: 3.0.0
Rating:
Released: 03-13-2004
Last Update: Never
Installs: 151
No support by the author.
[hr]-[/hr]
QuoteIt! Development has been continued in this thread. Please use this link for the latest version!
[hr]-[/hr]
QuoteIt! 1.2
Description
This hack will allow you to maintain a database of quotes which can be added by users and displayed on FORUMHOME. Admin function includes the ability to delete quotes from the database.
1. If you see no text, you need tu manualy re-enter the phrases.
2. If you upgrade from 3.0.0 to 3.0.1 and you see no QuoteIt, go to ADMIN CP > vB Options > Forum Home... > Dyspay Quote and set to YES.
If you don't have such an option you need to re-enter the setting to the database. Use this install file. It is the same install file only that i remove the CRATE TABLE QUOTE and THE PHRASES. You only need the SETTINGS thing.
Atleast, this is what i did and it worked. So, use my advices at your own risk
1. If you see no text, you need tu manualy re-enter the phrases.
2. If you upgrade from 3.0.0 to 3.0.1 and you see no QuoteIt, go to ADMIN CP > vB Options > Forum Home... > Dyspay Quote and set to YES.
If you don't have such an option you need to re-enter the setting to the database. Use this install file. It is the same install file only that i remove the CRATE TABLE QUOTE and THE PHRASES. You only need the SETTINGS thing.
Atleast, this is what i did and it worked. So, use my advices at your own risk
thank you muchly for this easy fix! i was having the exact problem as listed in your point #2, and you've helped me fix it up in no time flat. thanks again!
Database error in vBulletin 3.0.1:
Invalid SQL:
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
mysql error: Table 'nymfans_vbulletin.quotes' doesn't exist
mysql error number: 1146
Date: Saturday 12th of June 2004 01:25:09 PM
Script: http://www.nymfans.com/
Referer:
Username: Noah
IP Address: --.---.---.---
The DB tables are there (vbulletin_quotes), everything is in the Admin CP. What is up here?
Wierdness. I installed this on my test board and it worked fine. However, when I put it on my real site, it displays no quotes, no links, no nothing. See for yourself.
It is obvious that I did something wrong but I cannot tell what?
Help.
P.S. There is also a line int he instructions that says to add
to the admincp/index.php file. It is strange that nowhere does it add the phrase "moderate_quotes" to the phrases or even tell me to do it.
Can somebody please give me the database queries to run that would completely remove this hack from my database? This way i can remove it then re-add it. Maybe that will help.
... also, this would make a good (and simple) random links/ads display... all one needs to include is a linked image as the quote (and modify the template slightly to remove the submissions for normal users)