QuoteIt! Quote Management System v1.2

[docvader]

YOU ARE THE MAN!

Impressive...

(but the "add to quotes" funcition, in each postbit, draws a white page of death).

OOPS. Forgot this:
https://vborg.vbsupport.ru/showpost.php?p=587592&postcount=212

Now it works.

[Deviant++]

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry 'showquote' for key 1

[Deviant++]

SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1

mysql error: Table 'dvdb.quotes' doesn't exist

[Deviant++]

I removed 'showquote' from vb3_setting ..
now it says this

An error occurred while attempting to execute your query. The following information was returned.
error number: 1146
error desc: Table 'dvdb.setting' doesn't exist

but it's still there... vb3_setting I mean .. lol
cause the forums n everything is working fine..

[CtrlAltDel]

1. edit button is your friend
2. mysql error: Table 'dvdb.quotes' doesn't exist, would tend make me believe there is an issue with your quotes table.

[CtrlAltDel]

My bad guys, you need to rerun both queries, one for displaying and one for entering.
You will then need to go to your admincp, and resave the settings even though they may appear set already.

https://vborg.vbsupport.ru/showpost.php?p=599841&postcount=249

[The Realist]

Whats the command to deinstall this from the database so I can reinstall it.

[CtrlAltDel]

open the install_quoteit.php in a text editor
scroll down to the bottom where all the INSERT statements are, change them to correct delete statements, or manually go through the database and find those with phpmyadmin.

need more help, let me know.

[The Realist]

Lost already M8, dont know bugger all about DB's.

Follow instructions man thats me.

Do you have a command I can run?

[The Realist]

Thanks, manually removed and re-run install file.

Still not working in version 3.0.5

[The Realist]

Ran this but it says duplicate entries.

I figured it out.

For some reason the VB 3.0.5/6 upgrade somewhere along the line kills the 'Forum Home Page Settings' database table...or at least nukes the entry needed for the quotes thing. So basically, nothing is broken, but its just like you check the 'off' button for the quotes.

You need to rerun this query.

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('showquote', 'forumhome', '0', '0', 'yesno', 5, 0, 1);


and this one


INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)


If your table has a prefix, put that on there.

Then go into your home page options and re-enable the settings.

Everything should be back to normal now.

[CtrlAltDel]

go into you admincp and make sure you check the two settings for the quotes, save them, and then check.

and what part exactly isnt working?

[The Realist]

I have checked the boxes in options. The quotebox is showing on the homepage but its not looking correct.

See picture attached.

Laters

[CtrlAltDel]

approve your quotes
edit a phrase and save, so the phrases work

[The Realist]

Thanks.

Edited a phase and saved it and now its working, strange?

Also have you any ideas how I can get thetop right tab to blend into my template (see pic)

Thanks.

approve your quotes
edit a phrase and save, so the phrases work

[docvader]

So much for progress. When adding a quote, I get this error:
Database error in vBulletin 3.0.6:

Invalid SQL:
INSERT INTO quotes (quote, author, userid, approved) VALUES ('When losing a battle, whether it be of the body, the mind or the heart, it is only a set up to win the next battle in which the reward is much greater.', 'Tsu Chin', 1, )

mysql error: You have an error in your SQL syntax near ')
' at line 2

mysql error number: 1064

Date: Monday 24th of January 2005 11:31:37 AM
Script: http://x.russbo.com/vb/quotes.php
Referer:
Username: xxx
IP Address: xxxxx


Otherwise, it all seems to work. Any ideas?

rich
http://x.russbo.com/vb/index.php

[CtrlAltDel]

reread my fix, and run the second query
then updated your admin settings and you will be fine

as for The Realist's problems...thats your template just acting odd, just change the template to look like you other boxes and you will be good to go.

[docvader]

Thanks. Think that did it. Impressive how you took command of this hack, you should really think about improving it, since you seem to be the only one that understands it.

Great feature, my members love it. Thanks for helping me get it back online.
rich

[LKJR]

maybe I"m lost mine looks like realist's does with the marks but empty (image attached a page or two back)

the boxes are checked I"ve tried running the queries again with no luck, it just says they already exsist.

Also I noticed I don't have a line in the moderate box in admincp to approve quotes like is shown on the initial post.
maybe that's the problem with mine?

[CtrlAltDel]

you need to edit a phrase and save, to update the phrases database

[LKJR]

how do I do that if I can't click on anything? sorry if I'm slow on this. my box is just the lines w/o any kind of clickable linkes or moderation abilities.

https://vborg.vbsupport.ru/attachment.php?attachmentid=23103

[agiacosa]

I'm running 3.0.5 with the patch. I tried running the two queries that do the fix but I get duplicate errors. I have the moderate quotes coming up on admincp but nothing shows up on forumhome.

[LKJR]

have you checked the boxes in forum home settings in your admincp?

[agiacosa]

Yes. Quotes is on and moderation is enabled.

[LKJR]

did you go into the moderation and try to do anything? like save a quote? I think that's what he was saying to do on page 18 of this thing.

[agiacosa]

Looks like you need to go into your admincp, select phrases, click on edit (anyone) and then save.

[agiacosa]

I have no options under Moderate Quotes as it only says no quotes to moderate.

[LKJR]

what did you mean by anyone?

[agiacosa]

the first phrase you see (doesn't matter what it is), just click edit and then saved.

P.S. got mine working. My fault

[LKJR]

sweet it works, but how do I get the moderate quotes stuff into my admincp?

[agiacosa]

log out and come back in

[LKJR]

nevermind I figured it out, is there a way I could put this is without the borders around it? where it was between the forum, and navbar with just text?

[agiacosa]

It's just html in randomquotebits template. Edit that template to your liking. See mine: http://www.aquaticplantcentral.com/forumapc/index.php

[LKJR]

that is exactly what I'm after!!!!

do members still have ability to add quotes? or is it all admin?

can you copy that html code for me so I could just paste it?

[agiacosa]

Functionality hasn't changed. Just the way the quote is displayed.

I changed randomquote template to be:<table cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="80%" align="center">
<thead>
<tr>
<td colspan="2">
</td>
</tr>
</thead>
<tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">
<tr>
<td class="alt1" align="center" colspan="2">
<i>"$randomquote[quote]"</i>
</td>
</tr>
<tr>
<td class="smallfont" align="left">
<if condition="$bbuserinfo['userid']">(<a href=$vboptions[bburl]/quotes.php?do=addquote>$vbphrase[add_a_quote]</a><if condition="$bbuserinfo['permissions']['adminpermissions']"> | <a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a></if> | <a href="$vboptions[bburl]/quotes.php?do=list">$vbphrase[view_all_quotes]</a>)</if>
</td>
<td class="alt1" align="right">
- <b>$randomquote[author]</b>
</td>
</tr>
</tbody>
</table><br />

[LKJR]

would there be a way to move the add quote button to like usercp easily so it wouldn't look so tacky on there or is that quite a bit of work?

[LKJR]

also, manage quotes isn't showing up in the moderator cp
is that a setting I need to change in permissions?

[agiacosa]

would there be a way to move the add quote button to like usercp easily so it wouldn't look so tacky on there or is that quite a bit of work?

I can be done I think by copying the requisite test from the randomquote to the appropriate usercp template.

[CtrlAltDel]

Manage quotes is only in the admincp, if you want it in the modcp, you need to edit the modcp index file like you did for the admincp

as for changing how the quote displays, its just a matter of editing the templates and putting whatever you want wherever you want...heck i have my quote displayed in my navbar.

[docvader]

I have my quotes displayed in my welcome block
http://x.russbo.com/vb/index.php

[deb0]

How does it run on VB306?

[ncangler]

Hi. I appreciate your help on this forum. I'm trying to install the QuoteIt hack on my forum running 3.0.6 and all I'm seeing is a blank bar with a couple of quotation marks and some other symbols. (I attached an image below). I haven't input a quote yet cause I don't see anyplace to do that. CtrlAltDel mentioned on the forum running a Query (below). I'm a newbie to much of this. Could you please tell me where and how to run a query? I really hope I can get this working. Thanks!

I figured it out.

For some reason the VB 3.0.5/6 upgrade somewhere along the line kills the 'Forum Home Page Settings' database table...or at least nukes the entry needed for the quotes thing. So basically, nothing is broken, but its just like you check the 'off' button for the quotes.

You need to rerun this query.

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('showquote', 'forumhome', '0', '0', 'yesno', 5, 0, 1);


and this one


INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)


If your table has a prefix, put that on there.

Then go into your home page options and re-enable the settings.

Everything should be back to normal now.

[Wifey]

Quick question - I have this hack working perfectly and I LOVE it, so thanks first off. Now, I was wondering if there is any way to keep a certain usergroup from adding quotes besides guests?

Thanks!

[CtrlAltDel]

How does it run on VB306?
works great on 3.0.6, follow the fix in my sig to get it up and running, along with refreshing your phrases.

[CtrlAltDel]

Quick question - I have this hack working perfectly and I LOVE it, so thanks first off. Now, I was wondering if there is any way to keep a certain usergroup from adding quotes besides guests?

Thanks!
it would be easy enough, you just need to change the code found in lines ~58-65 of quotes.php to an if condition that matched whom you wanted to be able to post quotes.

or you can add additional if statements there, testing for invalid usergroup ids..not too bad to put together.

[Borgs8472]

Hi everyone.

I was trying to trim the quote bar to remove the 'random quote' bit, when I collapsed the table and lost the random quote alltogether.

I tried reinstalling the templates, but now I keep getting:
The following error occurred when attempting to evaluate this template:

Parse error: parse error, unexpected T_STRING, expecting ']' in /usr/local/psa/home/vhosts/wordforge.net/httpdocs/forum/includes/adminfunctions_template.php(3037) : eval()'d code on line 18

This is likely caused by a malformed conditional statement. It is highly recommended that you fix this error before continuing, but you may continue as-is if you wish.


when I save the randomquote template!

The quote will not show up whatever I've tried. :(

Suggestions?

[kizzmet]

I figured it out.

For some reason the VB 3.0.5/6 upgrade somewhere along the line kills the 'Forum Home Page Settings' database table...or at least nukes the entry needed for the quotes thing. So basically, nothing is broken, but its just like you check the 'off' button for the quotes.

You need to rerun this query.

INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('showquote', 'forumhome', '0', '0', 'yesno', 5, 0, 1);


and this one


INSERT INTO setting (varname, grouptitle, value, defaultvalue, optioncode, displayorder, advanced, volatile) VALUES ('moderatequotes', 'forumhome', '0', '0', 'yesno', 6, 0, 1)


If your table has a prefix, put that on there.

Then go into your home page options and re-enable the settings.

Everything should be back to normal now.


Thank you Meester life saver!

[kizzmet]

Is there a way to get it to show only on the CMPS page and not the forum index page?

Using VB 3.0.6

[KW802]

Is there a way to get it to show only on the CMPS page and not the forum index page?

Using VB 3.0.6Did you search the thread for "CMPS"? ;)

https://vborg.vbsupport.ru/showpost.php?p=543545

[CtrlAltDel]

Hi everyone.

I was trying to trim the quote bar to remove the 'random quote' bit, when I collapsed the table and lost the random quote alltogether.

I tried reinstalling the templates, but now I keep getting:



when I save the randomquote template!

The quote will not show up whatever I've tried. :(

Suggestions?
that error usually comes out when there is a syntax error in the file that gets named there
check for missing braces and semi-colons

[rex_b]

works for me.

Thanks.

[The Realist]

Installed and working fine, but its thrown a wobbly on my template. Does anyone know how to fix this (see attached pic)

Laters

[CtrlAltDel]

like anything else, you do that by editing the template and taking it out if you dont want it

s'not brain surgery

[The Realist]

I did not ask for your unhelpful, unneeded comments. All I need is for someone to explain this:

One you add the quote, how does it get to look like the rest of the forum and where do I do this so called editing.


like anything else, you do that by editing the template and taking it out if you dont want it

s'not brain surgery

[PET]

well, for me...it dosn't want to work anymore :( Since i have my upgrade done...

[CtrlAltDel]

PET: did you check the links in my sig, they have a few things that may help clear up your issues.

The Realist: In your original post, if you were referring to the thing in the top right, you can edit that out, but editing the quote templates. Personally I just put it in the NavBar on my forum home and have it just display the quote and username.

[PET]

PET: did you check the links in my sig, they have a few things that may help clear up your issues.

The Realist: In your original post, if you were referring to the thing in the top right, you can edit that out, but editing the quote templates. Personally I just put it in the NavBar on my forum home and have it just display the quote and username.
thanks :)

[Borgs8472]

that error usually comes out when there is a syntax error in the file that gets named there
check for missing braces and semi-colons
I know, but I checked so many times now, I'm just installing the out-of-the-tin system but it keeps throwing that error and obviously not displaying on my forum home. :(

I get that error when I try and save the quotelistbit too!

*sob*

[deb0]

It doesn't work in 3.07. followed instructions precisely, yet nothing shows on forum home.

Any ideas?

[deb0]

works great on 3.0.6, follow the fix in my sig to get it up and running, along with refreshing your phrases.

I ran these sql queries and I get:

An error occurred while attempting to execute your query. The following information was returned.
error number: 1062
error desc: Duplicate entry 'moderatequotes' for key 1

This is an awesome mod, if I could just get it to work

[deb0]

I can't find any of these TEMPLATES that are supposed to be there. In the install script I see it updating all my styles then I notice at the bottom it says

New templates added to styleid 16
Click on "Apply Database Modifications" to continue.

Shouldn't it apply to ALL my style? How can I tell which is Style 16?

Help!

[The Realist]

Go to Styles and Templates and click Style Manager, put your mouse over each template and look at the bottom of your browser window, it will show as an example /index.php?s=&styleid=xx.

The xx is your style ID for that template.

Laters


I can't find any of these TEMPLATES that are supposed to be there. In the install script I see it updating all my styles then I notice at the bottom it says

New templates added to styleid 16
Click on "Apply Database Modifications" to continue.

Shouldn't it apply to ALL my style? How can I tell which is Style 16?

[deb0]

thx for your help. Man, I don't know what's up with this hack. Why is it defaulting to my default style anyway? And why is it that I can see NONE of the templates installed under that style or anyother?

[CtrlAltDel]

Sorry guys, I've been busy and I have not taken the time to install 3.0.7 on my site yet nor update this if needed yet, I'll try and get to that this weekend.

[venomx]

I have this running fine on 3.0.7

[pagekeeper]

Great hack, i've installed it but im getting a wierd error, in the admin section i cant see the quote's tab, although i can click it, but cant actually see anything .. also the quotes itself dont appear ... and the forumhome page is blank but the quote box is there ?? i've ran the install already with no errors..

[ncangler]

I have tried to install this and have run the queries but get the following error message when I activate the Quotes in AdminCP:

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 have "vb_" as the database prefix. Do I need to change something in order for the vb_quotes database to be seen? Any help is appreciated.

[CtrlAltDel]

Great hack, i've installed it but im getting a wierd error, in the admin section i cant see the quote's tab, although i can click it, but cant actually see anything .. also the quotes itself dont appear ... and the forumhome page is blank but the quote box is there ?? i've ran the install already with no errors..
edit a phrase and save
its the phrase issue

[CtrlAltDel]

did you run the install script all the way through?

[ncangler]

Yes the install was run with no errors all the way through. I even tried running it again and received a duplicate error message. I looked at the database with phpmyadmin and there is a "vb_quotes" field in the "thestudi_cafe" database. Since the error says "mysql error: Table 'thestudi_cafe.quotes' doesn't exist", I'm assuming it is trying to connect with the database 'thestudi_cafe' in field 'quotes' and should be calling field 'vb_quotes'. So is there someplace in one of the programs where I can add the 'vb_' database prefix or another way to get it to recognize this?

If I activate the quotes hack in AdminCP I get the error message.
BTW I can see the "moderate quotes" in AdminCP with no problem.

Thanks for your help!
Randy

did you run the install script all the way through?

[CtrlAltDel]

problem is your database names are incorrect

you have one database
studi_cafe and then you have another thestudi_cafe

which one is correct, and where is the other one coming from?

If the databases are right, check your config.php for proper table prefix settings

[CtrlAltDel]

I have this running fine on 3.0.7
Ok I looked at the upgrade to 3.0.7 (now that another is probably about to come out)

You need to run my 5->6 fix, and then fix your templates and make sure they are setup how you want. I ran into an instance of my navbar template being reset.

[ncangler]

I only have one database 'thestudi_cafe'. I have no idea where the other one is showing up from. That was a typo in my original email that I just saw and fixed. To recap...one database (thestudi_cafe) which contains 'vb_quotes' field. Thanks for your help.
Randy

problem is your database names are incorrect

you have one database
studi_cafe and then you have another thestudi_cafe

which one is correct, and where is the other one coming from?

If the databases are right, check your config.php for proper table prefix settings

[ncangler]

I checked the config.php setup and it was all correct. The database prefix was correctly set as 'vb_'. I don't know what the problem could be.

If the databases are right, check your config.php for proper table prefix settings

[CtrlAltDel]

that leads me to believe that you should redownload and install the quotes.php file

[ncangler]

I redownloaded the quotes.php file and replaced in the forum root folder. Same problem, no change.

that leads me to believe that you should redownload and install the quotes.php file

[ncangler]

The problem appears to be that 'quotes' is trying to access a table called 'quotes' in the database 'thestudi_cafe' and there isn't one because the table is called 'vb_quotes', as the 'vb_' prefix is used on all my MySQL tables for the forum. So where in the program is the path information for the tables that be missing the database prefix?

I am a novice at this stuff but I think you can see by my sites that I've figured out how to implement the modifications you guys that are much more experienced and intelligent than I have come up with (for which I am very grateful!). So I don't think I've screwed something in the installation as I've followed the instructions to the 't'.

Thanks for your help in finding this. I really want to get this working for my members.

[CtrlAltDel]

this script doesn't explicitly define the table prefix in the code. it reads the prefix from your config file. Best bet is to go replace all the 'TABLE_PREFIX' with what your table prefix really is. Not sure how else to help you on the table prefix error.

[ncangler]

I just tried that and it still doesn't work. How can I uninstall the whole system? I'm getting database errors from visitors trying to click on the "submit post to the quotes database." Thanks.

[kealoha]

I'm getting the same error as ncangler :(

[ncangler]

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.

this script doesn't explicitly define the table prefix in the code. it reads the prefix from your config file. Best bet is to go replace all the 'TABLE_PREFIX' with what your table prefix really is. Not sure how else to help you on the table prefix error.

[Marco van Herwaarden]

Edit your index.php.
find:
$result_quote = $DB_site->query("
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1

change to:
$result_quote = $DB_site->query("
SELECT * FROM ". TABLE_PREFIX . "quotes WHERE approved=1 ORDER BY rand() LIMIT 1

That's the only place i could find where the coder missed a table prefix, for the rest all looked nice coded.

[Marco van Herwaarden]

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

[ncangler]

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.

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

[Marco van Herwaarden]

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

[ncangler]

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.

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

[ncangler]

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.

[ncangler]

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

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.

[iamboard]

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

[ncangler]

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.

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

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

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

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

[Dolamite]

ok... 3 posts in a row (sorry)... but just wanted to give more info.... as i've tried everything i can think of and still no luck....

i use vbadvanced and i edited the navbar where the quotes show up there. They only show up once you are on the FORUMHOME (index.php), but do not show up on my main page (which i use portal.php).... I can get normal text to show up ex: TEST $showrandomquote

TEST will show up on the main page of the portal, and then if you click to the forums page then you see TEST + the quote....

i've looked through phrases + templates etc.... I can't figure out why it simply will not just show up....

any help appreciated...

[Dolamite]

the conversation with myself continues.....

it seems the phrases didn't get installed properly by the install script....

does anyone have a list of the phrases, perhaps i could install them manually....

ok actually maybe they are installed..... but they can't read from .... or soemthing

man this hack needs updated....

[Dark Aura]

I have the same error as you Dolamite, but I don't understand installing hacks very well I am new to this so I need simply instructions to fix it *blush*...

[Dolamite]

what i can't understand is why the phrases aren't being read.... they are there in the hprase manager but anything related to this hack which uses a phrase is just blank....

[Dolamite]

i just ran all the queries listed for upgrading.... just in case... still no luck...

i think i'm going to have to not use this hack..... anyone know of another quote hack that works with 3.0.7?

i could probably get a book on programming php.... read it.... write my own hack..... before this one gets updated :P

j/k but it is rather frustrating.... i've been at this most of an entire day....will soembody please...... save me....

[venomx]

I have it working fine on 3.0.7

Try editing a phrase then saving it. You dont have to make changes.

[Dolamite]

i did that for a few... and does seem that it might work... however searching for some of them has no results....i'm not even sure they are phrases i guess.... a complete list of them all would be nice

$randomquote[author]
$randomquote[quote]

neither of those produced a result when searching for phrases.....

[Dolamite]

did a complete re-install of this hack.... and did the manual editing as you suggested.... and its working.....

i am still having trouble getting $showrandomquote to work inside the navbar template though... if anyone has thoughts on that....

and sorry for .... spammin....this thread to death...

[seangworld]

ok, i waited for something like a week to see if my quoteit will start working and whatnot on my forum, plus i was adding a few quotes of mine into the db via my forum.

problem: the quotes ain't changing everyday, or at all for that matter.

missing a cron job or what? if so, it's not in the zip and i dont know how to write cron jobs. please let me know how to fix this minor problem. :P

[Dolamite]

ok i got it.... for anyone else who might want to do this....

below require_once('./global.php');(in your portal.php, adv_index.php whatever)

add:

// ### QUOTEIT ################################################## #######
if ($vboptions['showquote'])
{
$result_quote = $DB_site->query("
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
");

while ($quote = $DB_site->fetch_Array($result_quote)) {
$randomquote[quoteid] = $quote[quoteid];
$randomquote[quote] = $quote[quote];
$randomquote[author] = $quote[author];
$randomquote[userid] = $quote[userid];
$randomquote[approved] = $quote[approved];
}
$DB_site->free_result($result_quote);

eval('$showrandomquote .= "' . fetch_template('randomquote') . '";');

}

eval('$navbar = "' . fetch_template('navbar') . '";');

that last bit is what finally did it for me:

eval('$navbar = "' . fetch_template('navbar') . '";');

[seangworld]

ok i got it.... for anyone else who might want to do this....

below require_once('./global.php');(in your portal.php, adv_index.php whatever)

add:

[QUOTE] // ### QUOTEIT ################################################## #######
if ($vboptions['showquote'])
{
$result_quote = $DB_site->query("
SELECT * FROM quotes WHERE approved=1 ORDER BY rand() LIMIT 1
");

while ($quote = $DB_site->fetch_Array($result_quote)) {
$randomquote[quoteid] = $quote[quoteid];
$randomquote[quote] = $quote

that last bit is what finally did it for me:

eval('$navbar = "' . fetch_template('navbar') . '";');
still waiting for an answer to my last reply above. :/

[Lionel]

I am using this as a jokes system. Would love to see ratings.

[seangworld]

well, my quotes won't frickin rotate for ++++, and i have it set so it doesnt need to be moderated.

whatever, they don't support afterall i guess....

[CtrlAltDel]

seangworld: your quote may not be rotating properly due to the SQL statement that is selecting the quote...check that to see if the SQL statement is correct.

ratings are something that would be nice as well lionel, i'll see what i can do

[Cap'n Steve]

After a long wait, I'm proud to release QuoteIt! 2.0. It's got some major improvements, I suggest everyone with version 1.2 installed go check it out.

[YLP1]

After a long wait, I'm proud to release QuoteIt! 2.0. It's got some major improvements, I suggest everyone with version 1.2 installed go check it out.

Wow...thanks a bunch....but what a stinker.... I just found this excellent mod and installed it today....now it's 2.0 for me.

Thanks a bunch installing now...

[Dark Aura]

Okay I keep getting this error, I tried re-installing the hack but it wouldn't work, would someone tell me how to fix it or be willingly to fix it for me *blush*. Please put it basically not gd with understanding all this VB, PHP etc stuff!

Invalid SQL:
CREATE TABLE vb3_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'

[CtrlAltDel]

PRIMARY KEY (`quoteid`,`quoteid`),

remove one of the quoteid's

[Bubble #5]

Which templates are modified by the installer?

[Bubble #5]

I went into the addquote template and changed the code to clean this up.
Yes it looks better :) Could you post the code here for us please?

[Bubble #5]

Which templates are modified by the installer?
Anyone...? Please.

[Cap'n Steve]

This hack is no longer supported, as I said in my post above, you should install this one instead.

To answer your question, the installer doesn't actually modify any existing templates, but to use the random quote you have to modify the FORUMHOME template by hand.

[MP3]

thanks alooooooooot

[Megareus Rex]

Just installed it, and have a small problem.

The Quote Moderation thing only displays one quote. How can I change it?

[Bubble #5]

as I said in my post above, you should install this one instead.
90% of 2.0 is overkill for our needs and would not be used :( Thanks anyway though...

[Dark Aura]

PRIMARY KEY (`quoteid`,`quoteid`),

remove one of the quoteid's

how do I do that?

[Cap'n Steve]

As I mentioned earlier, this hack is old and you should use the new version.

If you're still set on using this one, though, open install_quoteit.php, find:

PRIMARY KEY (`quoteid`,`quoteid`),

and replace it with:

PRIMARY KEY (`quoteid`),