vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.5 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=113)
-   -   QuoteIt! - Quote Database (https://vborg.vbsupport.ru/showthread.php?t=97585)

Cap'n Steve 10-12-2005 06:12 PM

Quote:

Originally Posted by Snort_2005
If we install this and we had the version for 3.0.x installed, would we retain things such as settings and quotes? O_o

You'll still have the quotes, but not the settings.

I have no idea when the next version will be out, sorry. :speechless:

Neutral Singh 10-15-2005 03:52 PM

Quote:

Database error in vBulletin 3.5.0:

Invalid SQL:

SELECT COUNT(*) AS quotes FROM quotes
WHERE AND quotes.average >= 0 AND quotes.rating >= 0 approved = 1;

MySQL Error : 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 'AND quotes.average >= 0 AND quotes.rating >= 0 approved = 1' a
Error Number : 1064
Date : Saturday, October 15th 2005 @ 12:36:13 PM
Script : http://www.sikhphilosophy.net/sikhph...es.php?do=list
I only changed the hook to global_start. Everything else is working except this error when i click view all. Any clues please?

Cap'n Steve 10-16-2005 06:34 AM

Edit the "Random Quote" plugin, and after the last line add this
PHP Code:

$threshold ''


Neutral Singh 10-16-2005 11:59 AM

Sweet, works like a charm now. :) Thanks

Cyricx 10-19-2005 02:50 PM

Figured out my error...

I had forgotten to revert the old templates from the previous Quote It version for 3.0.x

Great hack!! Totally loving this :)

Cyricx 10-19-2005 03:01 PM

Ooo!! Idea for ya!

Quotes: xx

in postbit :)

Basically kinda like post count, but quote count :)

Sure it'd involve adding a field to the user table and then adding a way to increase the count when adding a quote and decrease the count when the quote is being deleted :)

But that would certainly up the traffic on the quotes :)

Cap'n Steve 10-20-2005 04:18 AM

Good idea. It sounds pretty easy to do, so it'll probably be in the next version.

Rabbitoh Warren 10-23-2005 03:52 PM

Apart from the default templates (which I've since edited to my liking, see attachment) this is a great hack. Thanks Steve! :up:

Lea Verou 10-24-2005 02:26 PM

I took today a good look at the templates quote_listquote and quote_listbit cause I wanted to change them to fit the look of my forum better...
The problem with the looks ot this -otherwise excellent- mod is that it uses it's own CSS classes!!!! Why do so and not use vbulletin's classes? It would fit much more if it was done this way and it would also save you the time to make your own CSS classes from vbulletin variables...

edit: Also, by the way, how can I set the default sorting method to show new additions at the top?

Rabbitoh Warren 10-24-2005 03:40 PM

Anyone know how to stop the link to "Submit to Quotes" from appearing when a user is viewing their private messages?

Cyricx 10-24-2005 03:44 PM

Quote:

Originally Posted by Rabbitoh Warren
Anyone know how to stop the link to "Submit to Quotes" from appearing when a user is viewing their private messages?

In your postbit or postbit_legacy template find:

Code:

<!-- BEGIN QuoteIt! -->
<a href="$vboptions[bburl]/quotes.php?$session[sessionurl]do=submitpost&amp;postid=$post[postid]">$vbphrase[submit_to_quotes]</a>
<!-- END QuoteIt! -->

And REPLACE IT with:
Code:

<!-- BEGIN QuoteIt! -->
<if condition="THIS_SCRIPT=='showthread' OR THIS_SCRIPT=='showpost'">
<a href="$vboptions[bburl]/quotes.php?$session[sessionurl]do=submitpost&amp;postid=$post[postid]">$vbphrase[submit_to_quotes]</a> </if>

<!-- END QuoteIt! -->


Rabbitoh Warren 10-24-2005 03:55 PM

Thanks Cyricx, that did the trick. :up:

Cap'n Steve 10-25-2005 03:52 AM

Quote:

Originally Posted by Loukrhtia
I took today a good look at the templates quote_listquote and quote_listbit cause I wanted to change them to fit the look of my forum better...
The problem with the looks ot this -otherwise excellent- mod is that it uses it's own CSS classes!!!! Why do so and not use vbulletin's classes? It would fit much more if it was done this way and it would also save you the time to make your own CSS classes from vbulletin variables...

edit: Also, by the way, how can I set the default sorting method to show new additions at the top?

I could have used more default classes, but I like my pretty buttons. ;) Like I said, it was a nightmare trying to get certain things to look good in every browser and hopefully I'll have time to redesign it soon.

There's no way to sort quotes by date yet. Unfortunately I didn't think of that until after I released version 2.

TwinsForMe 10-25-2005 09:15 PM

On the older version, I had edited FORUMDISPLAY, SHOWTHREAD, and search_results, so the quotes would show up in each forum, when viewing a thread, and after hitting "New Posts". How can I do the same with this version?

Cap'n Steve 10-25-2005 10:15 PM

Just edit the Random Quote plugin so it uses the global_start hook and add this code at the end:
PHP Code:

$threshold ''

Then add the $showrandomquote to whatever templates you want to.

TwinsForMe 10-25-2005 11:12 PM

Thanks. :)

Holidazed 10-27-2005 12:12 AM

I added the latest quote version and the install went smooth. However, after I add my first quote, it does not display on the forumhome page. I just see
Code:

""
When I attempt to edit it, the form is empty as if I never made a quote at all. If when editing, I add text in the fields and press the submit button, I get the same message as Neutral Singh (show below)

Quote:

Originally Posted by Neutral Singh
Please complete all the fields. Press the back button, correct the problem then try again.

In addition, I have the same problem as Don Corleone (shown below)

Quote:

Originally Posted by Don Corleone
I installed this mod, but there is something wrong with the template, take a look:

http://img160.imageshack.us/img160/639/quote8ag.th.jpg

see this empty space?
how do I remove it?

Help!!

Cap'n Steve 10-27-2005 04:09 AM

To fix the spacing, see this post.

For the other problem, do you have quote moderation turned on? You might have to approve the quote. If not, you should redownload and reimport the hack (be sure to allow overwrite and revert your QuoteIt! templates).

Holidazed 10-27-2005 04:27 PM

Thank you. The problem is in my big fat fingers. I had it misconfigured. I also fixed the spacing issue due to y our help.

Thank you

Snort_2005 10-28-2005 05:24 AM

Attempted to install the mod after I had it on vB 3.0.7

Code:

Database error in vBulletin 3.5.0:
 
Invalid SQL:
 
  INSERT INTO vb3_datastore
  (title, data) VALUES
  ("quote_settings", "1:0::1:5:0:::");
 
MySQL Error  : Duplicate entry 'quote_settings' for key 1
Error Number : 1062
Date        : Friday, October 28th 2005 @ 01:05:52 AM
Script      : http://www.zcworld.net/forums/admincp/plugin.php
Referrer    : http://www.zcworld.net/forums/admincp/plugin.php?do=productadd
IP Address  : 216.76.169.190
Username    : Sephiroth
Classname    : vb_database


Cap'n Steve 10-29-2005 03:26 AM

Somehow you kept the settings through the upgrade. It might still work, but if not, edit the product-quoteit.xml file and delete everything between <installcode> and </installcode>. Then reimport the file, making sure "allow overwrite" is checked.

Snort_2005 11-04-2005 04:39 PM

[sql]Database error in vBulletin 3.5.1:

Invalid SQL:

INSERT INTO vb3_setting
(varname, grouptitle, value, defaultvalue, datatype, optioncode, displayorder, advanced, volatile, product)
VALUES
(
'showquote',
'forumhome',
'1',
'0',
'boolean',
'yesno',
90,
0,
1,
'quoteit'
),
(
'ratequote',
'forumhome',
'0',
'0',
'number',
'<select name=\\\"setting[ratequote]\\\" tabindex=\\\"1\\\" class=\\\"bginput\\\">\r\n<option value=\\\"0\\\" \" . iif($setting[\'value\']==0, \'selected=\"selected\"\') . \">\" . $vbphrase[\'disabled\'] . \"</option>\r\n<option value=\\\"1\\\" \" . iif($setting[\'value\']==1, \'selected=\"selected\"\') . \">\" . $vbphrase[\'plus_or_minus\'] . \"</option>\r\n<option value=\\\"2\\\" \" . iif($setting[\'value\']==2, \'selected=\"selected\"\') . \">\" . $vbphrase[\'1_to_5\'] . \"</option>\r\n</select>',
100,
0,
1,
'quoteit'
),
(
'averagethreshold',
'forumhome',
'',
'',
'number',
'',
110,
0,
1,
'quoteit'
),
(
'totalthreshold',
'forumhome',
'',
'',
'number',
'',
120,
0,
1,
'quoteit'
);

MySQL Error : Duplicate entry 'ratequote' for key 1
Error Number : 1062
Date : Friday, November 4th 2005 @ 12:38:57 PM
Script : http://www.zcworld.net/forums/admincp/plugin.php
Referrer : http://www.zcworld.net/forums/adminc...?do=productadd
IP Address : 216.76.169.217
Username : Sephiroth
Classname : vb_database[/sql]

That's after I edited the xml. o_O;

edit: However, http://www.zcworld.net/forums/quotes.php just gives me a white screen.

Cap'n Steve 11-04-2005 11:29 PM

Delete everything between <options> and </options> and try again.

Gaffer 11-05-2005 02:22 AM

how the heck do i make it so the quotes show on all pages threw the template navbar.

thats where i ran the last version of the quoteit but this one even though thats where i put it only loads on home

Cap'n Steve 11-05-2005 07:37 AM

Follow the instructions in this post to add it to every page.

funinthesun 11-10-2005 01:14 AM

Interesting mod, might install later, thanks :)

Snort_2005 11-13-2005 09:22 PM

Thank you. :)

*clicks install*

Greebo 11-14-2005 11:36 AM

I'm having what seems to be a different problem. I've got the quotes showing up in my portal homepage, but whenever anyone, myself included, attempts to add a quote, edit a quote, or view all quotes (in short any access to quotes.php) all we get is a blank page with just html and body tags in it.

Any ideas?

OneShot 11-14-2005 04:26 PM

Installed it - great Mod. One Question tho, is it possible to make the number of Quotes to moderate appear in the AdminCP Control Panel Home below Threats, Events and so on to moderate?

Cheers
OS

TygerTyger 11-14-2005 07:22 PM

Quote:

Originally Posted by OneShot
Installed it - great Mod. One Question tho, is it possible to make the number of Quotes to moderate appear in the AdminCP Control Panel Home below Threats, Events and so on to moderate?

Cheers
OS

Yeah, I was gonna suggest that. There's also a missing phrase: quote_x_has_been_approved.

Couple of other suggestions from me, the Quote Number (#X) goes up one for every submitted qotm, regardless of whether or not it actually gets approved. So you end up with quote numbers scattered all over the place and people asking where the missing numbers are.

And would it be possible for number of ratings (Total Ratings:) to count the number of times a quote has been rated, as opposed to adding up the scores it has been given? A quote gets rated twice and already has a Total Rating of 10, which is rather confusing to say the least.

It's a great mod anyway, love it :D

Cap'n Steve 11-15-2005 04:07 AM

Quote:

Originally Posted by OneShot
One Question tho, is it possible to make the number of Quotes to moderate appear in the AdminCP Control Panel Home below Threats, Events and so on to moderate?

Not yet. I'll put that on the list to be included in the next version.

Quote:

Originally Posted by TygerTyger
And would it be possible for number of ratings (Total Ratings to count the number of times a quote has been rated, as opposed to adding up the scores it has been given?

$randomquote[votes] holds the number of votes. I'll take a look at getting the ids in order, and I already know about the phrase. It's not missing, I just can't seem to find the right phrasegroup for it.

Quote:

Originally Posted by Greebo
I've got the quotes showing up in my portal homepage, but whenever anyone, myself included, attempts to add a quote, edit a quote, or view all quotes (in short any access to quotes.php) all we get is a blank page with just html and body tags in it.

I really have no idea. Could you put the quotes.php file back up so I can take a look at it?

GrendelKhan{TSU 11-15-2005 06:17 AM

please tell me this is a fully phrased hack!! :)



I'm all over it if it is...looks great!! :D :D

TygerTyger 11-15-2005 10:53 AM

Certainly is phrased :)

I'm allllllmost done setting this to use much less tables, but I'm stuck. On the FORUMHOME I have it set so that if the rating dropdown is available, the average vote scores etc don't show. Once you've voted, it is reversed. This works fine on FORUMHOME using the basic <if><else /></if> that's already in place in the mod, but it doesn't work on the View All Quotes page? The <else /> part just doesn't display.

And secondly the last things I need to customise are $sortby and $votebutton, I can't find where to do so for this mod? Are they standard vBulletin variables and not specific to the mod?

Edit: Hm, the title of my View All Quotes page is Array[bbtitle]?

Cap'n Steve 11-15-2005 11:19 PM

Quote:

Originally Posted by TygerTyger
And secondly the last things I need to customise are $sortby and $votebutton, I can't find where to do so for this mod? Are they standard vBulletin variables and not specific to the mod?

Edit: Hm, the title of my View All Quotes page is Array[bbtitle]?

$sortby and $votebutton are both generated in the quotes.php file. To fix the title, find all instances of "$vbulletin->options" in your templates and replace them with "$vboptions". To know what's wrong with your <if> statement, I'd have to see the template.

Borgs8472 11-17-2005 02:30 AM

Thanks for a great port of your hack steve.

Only one problem left, even with context on, the context field is not filled in with a thread reference, it is blank.

Any ideas why this could be or how to fix? Thanks :)

Borgs8472 11-17-2005 02:51 AM

Quote:

Originally Posted by Cap'n Steve
Just edit the Random Quote plugin so it uses the global_start hook and add this code at the end:
PHP Code:

$threshold ''

Then add the $showrandomquote to whatever templates you want to.

btw, 'woo!'

Cap'n Steve 11-18-2005 05:54 AM

Quote:

Originally Posted by Borgs8472
Only one problem left, even with context on, the context field is not filled in with a thread reference, it is blank.

Any ideas why this could be or how to fix? Thanks :)

It should be added to the context after the quote is submitted. It doesn't show up in the box right now.

nexus851 11-18-2005 11:44 AM

Seems after i installed the quoteit, i have 2 title bars.. (top one is the CMPS title, and the bottom is the Quoteit title) I want to get rid of one of the bar so it doesnt look funny... Can anyone help me with this? Do i remove or replace a code? Here's my quoteit_random template:


PHP Code:

.vote {
    
color:$stylevar[smallfont_fgcolor];
    
font-family:'trebuchet ms',helvetica,sans-serif;
    
font-size:110%;
    
font-weight:bold;
    
background-color:$stylevar[button_bgcolor];
<if 
condition="$vbulletin->options[ratequote]==1">
    
width:25px;
    
height:25px;
</if>
    
border-top-color:$stylevar[alt2_bgcolor];
    
border-left-color:$stylevar[alt2_bgcolor];
    
border-right-color:$stylevar[alt1_bgcolor];
    
border-bottom-color:$stylevar[alt1_bgcolor];
    
filter:progid:DXImageTransform.Microsoft.Gradient
    
(GradientType=0,StartColorStr='#aa$gradient1',EndColorStr='#aa$gradient2');}
}
</
style>
<
table class="tborder" cellpadding="$stylevar[cellpadding]cellspacing="0" border="0" width="$stylevar[tablewidth]align="center">
<
thead>
    <
tr>
        <
td class="tcat">
            
$vbphrase[random_quote]
        </
td><td class="tcat" align="right">
            <
div align="right">

            (<
a href="$vboptions[bburl]/quotes.php?do=addquote">$vbphrase[add_a_quote]</a>

            <if 
condition="$vbulletin->userinfo['permissions']['adminpermissions']">
                 | <
a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a> | <a href="$vboptions[bburl]/quotes.php?do=editquote&quoteid=$randomquote[quoteid]">$vbphrase[edit_this_quote]</a>
            </if>

             | <
a href="$vboptions[bburl]/quotes.php?do=list">$vbphrase[view_all_quotes]</a>)
        </
div>
               </
td><td class="tcat" style="width:15px;">
              <
div style="float:right;" align="right">
            <
a href="#top" onclick="return toggle_collapse('forumhome_randomquote')"><img id="collapseimg_forumhome_randomquote" src="$stylevar[imgdir_button]/collapse_tcat$vbcollapse[collapseimg_forumhome_randomquote].gif" alt="" border="0" /></a></div>

        </
td>
    </
tr>
</
thead>
<
tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">
    <
tr><td class="alt1" width="30%">

<
img src="$vboptions[bburl]/plasma/misc/pickup_final.gif" width="80" height="80">

</
td>
        <
td class="alt1"><div style="font-style:italic;margin-right:10%;">
        <
p>&quot;$randomquote[quote]&quot;</p>
        <
p style="font-weight:bold;margin-left:25%;">- $randomquote[author]<if condition="$randomquote[context]"> ($randomquote[context])</if></p>
        </
div>
        </
td><td class="alt1" valign="top">
            <
a style="float:$stylevar[right];" href="$vboptions[bburl]/quotes.php?do=view&quoteid=$randomquote[quoteid]">#$randomquote[quoteid]</a>
        
</td>

    </
tr>
<if 
condition="$vbulletin->options[ratequote]==3">
    <
tr><td class="alt1" align="left" colspan="3">
    
$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
    </
td>
</if>

<if 
condition="$vbulletin->options[ratequote]==1">
    <
tr><td class="alt1" align="left">
    
$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
    </
td>
    <
td class="alt1" align="right" colspan="2">$vbphrase[rate_this_quote]: 
    <
form name="rateplus" action="$vboptions[bburl]/quotes.php">
    <
input type="hidden" name="do" id="do" value="rate" />
    <
input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]/>
    <
input type="hidden" name="vote" id="vote" value="plus" />
    <
input type="submit" value="+" class="vote" />
    </
form>
    &
nbsp;
    <
form name="rateminus" action="$vboptions[bburl]/quotes.php">
    <
input type="hidden" name="do" id="do" value="rate" />
    <
input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]/>
    <
input type="hidden" name="vote" id="vote" value="minus" />
    <
input type="submit" value="-" class="vote" /></form>
    </
td>
</if>
<if 
condition="$vbulletin->options[ratequote]==2">
    <
tr><td class="alt1" align="left">
    
$vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
    </
td>
    <
td class="alt1" align="right" colspan="2">$vbphrase[rate_this_quote]:
    <
form name="voting" id="voting" action="$vboptions[bburl]/quotes.php">
    <
input type="hidden" name="do" id="do" value="rate" />
    <
input type="hidden" name="quoteid" id="quoteid" value="$randomquote[quoteid]/>
    <
select name="vote" id="vote" onchange="document.voting.submit();">
    <
option value=""></option>
    <
option value="1">&nbsp;&nbsp;1&nbsp;&nbsp;</option>
    <
option value="2">&nbsp;&nbsp;2&nbsp;&nbsp;</option>
    <
option value="3">&nbsp;&nbsp;3&nbsp;&nbsp;</option>
    <
option value="4">&nbsp;&nbsp;4&nbsp;&nbsp;</option>
    <
option value="5">&nbsp;&nbsp;5&nbsp;&nbsp;</option>
    </
select>
    </
form>
    </
td>
</if>

</
tr>
</
tbody


Cap'n Steve 11-18-2005 08:32 PM

I can't see your site right now, do you mean you have a second navbar? The quote shouldn't have anything to do with that. Is that your entire quote_randomquote template? I can see already that you're missing a couple lines if it is.

nexus851 11-18-2005 09:20 PM

yeah, 2 navbars. 1 navbar is from the CMPS module, and the other is from the template module i guess..

yeah, that is my entire _quote_randomquote template. If im missing lines, please post
them or revise so that one of the title bar dissapears.

P.S- I had to remove the "/table" line from the bottom of the template because it was messing up the tables of any modules i put after this quoteit module. By removing it, it fixed the problem...


All times are GMT. The time now is 04:17 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01837 seconds
  • Memory Usage 1,942KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (4)bbcode_code_printable
  • (4)bbcode_php_printable
  • (13)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (40)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete