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

Page 23 of 38

« First

Last »

Show 40 post(s) from this thread on one page

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)

Deyth

12-30-2004 03:50 PM

I added the hack, followed the instructions, turned it on, and I don't see anything. Is it because there are no quotes in the table? If so, how are quotes to be submitted?

Deyth

12-30-2004 04:10 PM

It's showing up in one style but not the other yet I modified the FORUMHOME template in both the same way.

Edit:
Turns out the installation only put in custom templates for one style instead of all. Anyone know a quick fix for this?

Deyth

12-30-2004 04:46 PM

I found a hack that does this easily and am sharing it here for anyone else that will encounter this same problem later. You have to copy over quotelistbit, quote_addquote, quote_delquote, quote_listquote, randomquote.

Deyth

12-30-2004 08:22 PM

Your query isn't checking quotes.approved = 1

[QUOTE=Giveit2u43]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') . '";');

Quote:

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

CtrlAltDel

12-31-2004 04:17 AM

Quote:

Originally Posted by Deyth

yeah just make your default style another style
run the install script and just install the templates and they'll get laid down

it runs on 3.0.3, thats what im running and my addon works with that too

yeah my addon wasnt perfect, thanks for the clean up guys

anarchystar

01-09-2005 07:23 AM

I tried to install quote-it 1.2 in vB 3.0.5 into my test site and got the following error when I turned the option on.

Code:

Database error in vBulletin 3.0.5:



Invalid SQL: 

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

                

mysql error: Table 'database_-_test.quotes' doesn't exist



mysql error number: 1146

I turned it off again, and everything is fine. I'm wondering if this problem is specific to 3.0.5?

Deyth

01-09-2005 03:27 PM

Quote:

Originally Posted by anarchystar

I tried to install quote-it 1.2 in vB 3.0.5 into my test site and got the following error when I turned the option on.

Code:

Database error in vBulletin 3.0.5:



Invalid SQL: 

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

                

mysql error: Table 'database_-_test.quotes' doesn't exist



mysql error number: 1146

I turned it off again, and everything is fine. I'm wondering if this problem is specific to 3.0.5?

It's saying the quotes table doesn't exist. I don't think any vBulletin upgrades would drop tables it doesn't even expect to be there.

Silverdawn222

01-09-2005 03:31 PM

Edit: Never mind, fixed my own problem.

Deyth

01-09-2005 04:29 PM

Looks like the upgrade from 3.0.3 to 3.0.5 knocked it out for me too although I can't figure out why yet. Did anyone else do the upgrade?

Deyth

01-09-2005 04:39 PM

Ok it knocked out the settings. Just rerun these 2 queries:

Code:

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



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

That will get them to display at least. I'm still getting errors when I try to add, it's missing the value for $vboptions[moderatequotes] even though I figured the above would insert it.

All times are GMT. The time now is 01:51 PM.

Page 23 of 38

« First

Last »

Show 40 post(s) from this thread on one page

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.02138 seconds Memory Usage 1,745KB 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_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
Messages: