QuoteIt! Quote Management System v1.2

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

Yes, you can use multi-line quotes.

Information
Requested by djohn (re: https://vborg.vbsupport.ru/showthread.php?t=62420)

Thanks to Giveit2u43 for the username code!

Tested on RC4, should work on RC1+

Version History
v1.0 - Initial Release
v1.1 - Added ability to list all quotes as well as direct quote linking
v1.2 - Added quote moderation abilities

Planned Features
v2.0
- Quote rating system
- Top {X} Quotes

If you use this, please click

[hr]-[/hr]
UPGRADES

v1.1 -> v1.2 UPGRADE INSTRUCTIONS

v1.0 -> v1.1 UPGRADE INSTRUCTIONS

[hr]-[/hr]
3RD PARTY MODIFICATIONS/ADD-ONS

[high]1. Add QuoteIt! to your vbIndex homepage! by [name]Giveit2u43[/name][/high]
[high]2. Add Who's Online Locations for QuoteIt! by [name]Acido[/name][/high]

[iamboard]

I have a list of about 250 quotes that I want to put in. Is there a way to do an import if I can put these quotes into some time of importable format?

Thanks

[CtrlAltDel]

Yes the easiest way is to format them as SQL statements and then insert them with phpmyadmin or however you like to run sql commands against your database.

If you would like help writing out a SQL statement (you could just export your current quotes table to see what it would look like) I could help you out.

[iamboard]

Originally Posted by CtrlAltDel

Yes the easiest way is to format them as SQL statements and then insert them with phpmyadmin or however you like to run sql commands against your database.

If you would like help writing out a SQL statement (you could just export your current quotes table to see what it would look like) I could help you out.

ctrlaltdel,

The quotes I have right now are all simply individual sentences. I have no experience with sql. I was hoping to put them maybe in a comma delimited format or something like that and import them. However, maybe a cut and paste method would be the easiest since I don't get very deep technically....your thoughts?

Thanks

[seangworld]

OK, ive gone thru some re-installing of my vbulletins a few times cuz i cant seem to decide what domain i really wanna use, and so whatever. lol

but basically, i JUST got around to upgrading my vb to 3.0.7 and re-installing this hack (1.2) and it works just fine. thought i'd let everyone know that.

also, for those that are writing the instructions and getting any upgrades to this hack ready in the future, it'd be nice if the instructions included step 7: edit and save any of the phrases without changing anything and then hit refresh on your forum and everything will be working fine.

ya, that woulda saved me about 15 minutes of looking for the answer to my question, lol, which i found on page 4 in the replies to this thread.

cyaz!

[Dark Aura]

Okay i tried to install this, but I have never run queries before why do I keep getting this error?

An error occurred while attempting to execute your query. The following information was returned.
error number: 1064
error desc: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'http://www.silent-imperfection.net/admincp/install_quoteit.php'

I have installed hacks before just not ones with queries, and they all work fine

[Marco van Herwaarden]

The line you are showing is not a query, but the path to the install script.

[Dolamite]

anyone seen this one yet?

Database error in vBulletin 3.0.7:

Invalid SQL:
CREATE TABLE quotes (
`quoteid` int(10) unsigned NOT NULL auto_increment,
`quote` mediumtext NOT NULL,
`author` mediumtext NOT NULL,
`userid` int(10) unsigned NOT NULL default '0',
`approved` smallint(5) unsigned NOT NULL default '0',
PRIMARY KEY (`quoteid`,`quoteid`),
KEY `approved` (`approved`)
) TYPE=MyISAM AUTO_INCREMENT=1

mysql error: Duplicate column name 'quoteid'

mysql error number: 1060

[Marco van Herwaarden]

You have the column 'quoteid' 2 times in the primary key.

[Dolamite]

heh... marco... this ain't my code man :P i was just following the installation instructions....

it does seem to be there twice though.... not my doing..... but removing that 2nd instance seems to have solved the problem... so thanks for your help

[Dolamite]

well i said it was working.... but none of the admin menus got installed ... i've beening going thru adding some of this stuff manually.....

one thing i can't get is... how to show it on pages other than FORUMHOME.... such as my portal for example....