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 11-19-2005 01:29 AM

Here's the entire template. You're apparently missing the opening <style> tag on the first line which would cause problems. Taking out the closing </table> tag would also cause problems, but it still has nothing to do with the navbar. Did the two navbars appear before or after you changed the template? I can't duplicate either of your problems so it must have something to do with your style or the other modules.

HTML Code:

<style type="text/css">
.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="$vboptions[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="$bbuserinfo['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%"></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="$vboptions[ratequote]==3">
        <tr><td class="alt1" align="left" colspan="3">
        $vbphrase[total_rating]: $randomquote[rating] - $vbphrase[average]: $randomquote[average]
        </td>
</if>

<if condition="$vboptions[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="$vboptions[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>
</table><br />


Mr.Monkey 11-19-2005 01:43 PM

Hey Cap'n, good job on quoteit, but I've managed to break something. I had an old version of quoteit installed, but I reverted all the templates necessary afterwards.
When I try to submit a quote, I get the following error:
Code:


Database error in vBulletin 3.5.1:

Invalid SQL:

                INSERT INTO 1vb3_quotes
                (quote, author, userid, approved, context) VALUES
                ("Test", "Test", 1, 0, "");

MySQL Error  : Unknown column 'context' in 'field list'
Error Number : 1054
Date        : Saturday, November 19th 2005 @ 04:38:35 PM
Script      : http://www.tribeclown.com/vforum/quotes.php
Referrer    : http://www.tribeclown.com/vforum/quotes.php?&do=addquote
IP Address  : 146.115.44.37
Username    : Test
Classname    : vb_database

Any suggestions?

funinthesun 11-19-2005 02:44 PM

I've just installed this and it seemed easy enough to do, however nothing is showing up when I add a quote? When I click to view all quotes it just takes me to the submit quote form. I didn't add the submit posts code, should I of added that as well? The options for showing quotes is in my forum home page options in my admincp which turns it on and off fine but no quotes, what have I done wrong? Also, where can I view all quotes that have been entered in my admincp? Thanks

OneShot 11-19-2005 03:03 PM

Did you check in your AdminCP under Moderation -> Moderate Quotes? Because depending on your settings you have to approve them first.

funinthesun 11-19-2005 03:21 PM

Hi OneShot

No, I hadn't checked but I just looked now and there is no option in the moderation section to moderate posts?

Mr.Monkey 11-19-2005 05:37 PM

Quote:

Originally Posted by Mr.Monkey
Hey Cap'n, good job on quoteit, but I've managed to break something. I had an old version of quoteit installed, but I reverted all the templates necessary afterwards.
When I try to submit a quote, I get the following error:
Code:


Database error in vBulletin 3.5.1:

Invalid SQL:

                INSERT INTO 1vb3_quotes
                (quote, author, userid, approved, context) VALUES
                ("Test", "Test", 1, 0, "");

MySQL Error  : Unknown column 'context' in 'field list'
Error Number : 1054
Date        : Saturday, November 19th 2005 @ 04:38:35 PM
Script      : http://www.tribeclown.com/vforum/quotes.php
Referrer    : http://www.tribeclown.com/vforum/quotes.php?&do=addquote
IP Address  :
Username    : Test
Classname    : vb_database

Any suggestions?

Just in case anyone gets the same message, deleting it from the Plugins section, then reinstalling the .xml seems to have cleared the problem!

funinthesun 11-19-2005 06:32 PM

I'm stumped on this one, I don't know why the quotes aren't showing up. Could it be something to do with my version of mySQL? :(

TygerTyger 11-19-2005 07:03 PM

Quote:

Originally Posted by funinthesun
I'm stumped on this one, I don't know why the quotes aren't showing up. Could it be something to do with my version of mySQL? :(

Hard for anyone to say if you don't tell us what version it is ;)

Cap'n Steve 11-19-2005 07:41 PM

Quote:

Originally Posted by Mr.Monkey
Just in case anyone gets the same message, deleting it from the Plugins section, then reinstalling the .xml seems to have cleared the problem!

Be careful with that, as uninstalling the product will delete all your quotes. I think your original problem was that you had version 1.x installed and never upgraded to 2.0. As long as it works now it's ok, but I'll remember to take that into consideration for the install code.

funinthesun - If there's no "Moderate Quotes" link under Moderation, did you upload includes/xml/cpnav_quoteit.xml? To see quotes in the moderation que without the link, point your browser to admincp/quoteadmin.php?do=moderate

funinthesun 11-20-2005 12:08 AM

Hi Cap'n Steve

Yes, I uploaded the cpnav_quoteit.xml file to includes/xml. I thought it was a simple install to be honest. I've pointed my browser to http://www.mysite.com/quotes.php?do=moderate and it's just a blank white page? :confused:


All times are GMT. The time now is 06:12 PM.

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.02249 seconds
  • Memory Usage 1,790KB
  • 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
  • (2)bbcode_code_printable
  • (1)bbcode_html_printable
  • (3)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (2)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)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