vb.org Archive - QuoteIt! Quote Management System v1.2

vb.org Archive (https://vborg.vbsupport.ru/index.php)

- vBulletin 3.0 Full Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=33)

- - QuoteIt! Quote Management System v1.2 (https://vborg.vbsupport.ru/showthread.php?t=62470)

Nice hack. Installed it on my testsystem and its running fine.
Looking forward to verison 2. :)

My members are loving this hack and having great fun adding quotes.. One feature they did request was that It showed up the name of the member who submitted the quote.. I`ll be adding this myself on my installation but thought it might be a nice addition for the official version, maybe with an admin on/off option??

Quote:

Originally Posted by Giveit2u43

Yea, that'll be added. I store the userid of the person who submitted the quote, so it's just a matter of tossing $randomquote[userid] out somewhere.

Quote:

Originally Posted by magnus

Yea, that'll be added. I store the userid of the person who submitted the quote, so it's just a matter of tossing $randomquote[userid] out somewhere.

Yeah just noticed that as I was looking at the code.. I changed your query to:

Code:

$result_quote = $DB_site->query("

                        SELECT quotes.*,user.username AS quotename FROM ".TABLE_PREFIX."quotes AS quotes

                        LEFT JOIN ".TABLE_PREFIX."user AS user ON (user.userid = quotes.userid)

                        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[username] = $quote[quotename];

                }

                $DB_site->free_result($result_quote);

        

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

and then you can place $randomquote[username] where you want the submitters username to show :)

v1.0 -> v1.1 UPGRADE INSTRUCTIONS

1. Download the quoteit1.1.zip from the first post, and upload the new quotes.php to your forum ROOT directory.

2. Run the following SQL query (or, you can insert the following phrase manually into the GLOBAL category):
[SQL]
INSERT INTO phrase (languageid, varname, text, phrasetypeid) VALUES (0, 'view_all_quotes', 'View All', 1);
[/SQL]

3. Edit the randomquote TEMPLATE:

Find:

HTML Code:

<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>)</if>

REPLACE with:

HTML Code:

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

4. Create the following NEW templates:

TEMPLATE: quote_listquote

HTML Code:

$stylevar[htmldoctype]

<html dir="$stylevar[textdirection]" lang="$stylevar[languagecode]">

<head><title>$vboptions[bbtitle] - $vbphrase[random_quote]</title>

$headinclude

</head>

<body>

$header

$navbar



<table class="tborder" cellpadding="$stylevar[cellpadding]" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">

<thead>

        <tr>

                <td class="tcat" colspan="2">

                        <a style="float:$stylevar[right]" 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>

                        $vbphrase[random_quote]

                </td>

        </tr>

</thead>

<tbody id="collapseobj_forumhome_randomquote" style="$vbcollapse[collapseobj_forumhome_randomquote]">

$quotelistbit

</tbody>

</table><br />

$pagenav



$footer

</body>

</html>

TEMPLATE: quotelistbit

HTML Code:

<table class="tborder" cellpadding="3" cellspacing="0" border="0" width="$stylevar[tablewidth]" align="center">

        <tr>

                <td class="alt1 smallfont" align="left">

                Added by: <a href="$vboptions[bburl]/member.php?userid=$randomquote[userid]">$randomquote[username]

                </td>

                <td class="alt1" align="right">

                <a href="$vboptions[bburl]/quotes.php?do=view&quoteid=$randomquote[quoteid]">#$randomquote[quoteid]</a>

                </td>

        </tr>

        <tr>

                <td class="alt1" align="center" colspan="2">

                <i>"$randomquote[quote]"</i>

                </td>

        </tr>

        <tr>

                <td class="alt1 smallfont" align="left">

                <if condition="$bbuserinfo['permissions']['adminpermissions']">(<a href="$vboptions[bburl]/quotes.php?do=delquote&quoteid=$randomquote[quoteid]">$vbphrase[delete_this_quote]</a>)</if>

                </td>

                <td class="alt1" align="right">

                - <b>$randomquote[author]</b>

                </td>

        </tr>

</table>

Done !!

"this is a test" ( | | )test quote <-- is what i see. No username and no link to submit or display all quotes :(

Quote:

Originally Posted by NuclioN

"this is a test" ( | | )test quote <-- is what i see. No username and no link to submit or display all quotes :(

I had the same problem, but when I clicked edit on one of the phrases and saved it without doing anything in the admincp it fixed it somehow.

Does anyone know why I get this error message on the indexpage?

Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /usr/home/sites/xxxxxx/www/forum/index.php(115) : eval()'d code on line 19

Parse error: parse error, expecting `']'' in /usr/home/sites/xxxxxxx/www/forum/index.php(115) : eval()'d code on line 19

Quote:

Originally Posted by NuclioN

"this is a test" ( | | )test quote <-- is what i see. No username and no link to submit or display all quotes :(

Yea, like kie said. Open up the phrase manager, click "edit" on any thread (it doesn't matter which), and then click save. In some cases you need to reload(?) the phrase database. I have no idea why, but I've run into this myself before.

Quote:

Originally Posted by kie

Looks like a cut & paste gone wrong? I'm assuming line 19 is the QuoteIt! code. It looks like you left off a few trailing characters, open up the readme file and cut/paste again.

X vBulletin 3.8.12 by vBS Debug Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)bbcode_code_printable (4)bbcode_html_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)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
Messages:

Phrase Groups Available:

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01379 seconds Memory Usage 1,769KB 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 (1)bbcode_code_printable (4)bbcode_html_printable (5)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)pagenav (1)pagenav_curpage (3)pagenav_pagelink (1)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
Messages: