vb.org Archive - QuoteIt! - Quote Database

Page 15 of 42

« First

Last »

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

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)

lexx27

11-29-2005 01:13 AM

I think there is a modification at vbadvanced page

Warrior

12-02-2005 12:02 PM

Quote:

Originally Posted by Mr.Monkey

Can anyone suggest what I should add into the "adv_portal_moderation" to get the link to the quotes to moderate to show correctly on my quick moderate module in vbAdvanced?

I am also interested in this... did I miss it somewhere?

Bubble #5

12-04-2005 05:17 AM

Quote:

Originally Posted by Cap'n Steve

The easy way to only allow administrators would be to edit quotes.php

Is there a way to only have admins add the quotes? The code above is only for editing the quotes. Maybe add a conditional before where it says "add a quote, show all quotes"? I'm not sure what the correct conditional would be though, or where to add it. Maybe in the templates? Thanks.

Gio Takahashi

12-04-2005 06:51 AM

HTML Code:

Database error in vBulletin 3.5.1:



Invalid SQL:



                                        UPDATE quotes SET

                                        votes = votes + 1,

                                        rating = rating + 2,

                                        average = rating / votes

                                                WHERE quoteid = 385;



MySQL Error  : Unknown column 'votes' in 'field list'

Error Number : 1054

Date         : Sunday, December 4th 2005 @ 12:50:29 AM

Script       : [url]http://www.unitedempire.net/forum//quotes.php?do=rate&quoteid=385&vote=2[/url]

Referrer     : [url]http://www.unitedempire.net/forum/index.php[/url]

IP Address   : 71.3.5.169

Username     : Gio Takahashi

Classname    : vb_database

BTW, I did have QuoteIt for Vb 3.0. Anyway, anything I can do to fix it? Should I just manually add the collumn or not?

Cap'n Steve

12-04-2005 07:27 PM

I'm guessing you had QuoteIt! 1.2 but never upgraded to 2.0, right? I never even considered that situation when I released this version. :ermm: The next version should handle the upgrade better, but until then these queries should fix it:

Code:

UPDATE $TPquotes ADD COLUMN (votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0, rating MEDIUMINT(10) NOT NULL DEFAULT 0, average FLOAT(3, 2) NOT NULL DEFAULT 0.00, context VARCHAR(250))

Code:

ALTER TABLE $TPquotes ADD INDEX rating

Code:

ALTER TABLE $TPquotes ADD INDEX average

Just replace $TP with your table prefix.

Cap'n Steve

12-04-2005 07:52 PM

For those interested, I've added instructions for adding quotes to the vBadvanced quick moderation in this post.

Bubble #5

12-04-2005 10:47 PM

Why doesn't this hack work in the header?

We added $showrandomquote (as mentioned in this thread) and made the changes to the plugin, but it still doesn't show up :(

What would block it from showing up?

Cap'n Steve

12-04-2005 11:06 PM

To only allow administrators to add quotes, in quotes.php, find

PHP Code:


		
			
require_once('./global.php');

below that, add

PHP Code:


		
			
    if ($_REQUEST['do'] == 'add' OR $_REQUEST['do'] == 'addquote' OR $_REQUEST['do'] == 'editquote' OR $_REQUEST['do'] == 'edit' OR $_REQUEST['do'] == 'submitpost' OR $_REQUEST['do'] == 'submit') {

    if (!$vbulletin->userinfo['permissions']['adminpermissions'])     {

        print_no_permission();

        exit;

    }

}

I'm not sure about your other error, could you attach a saved html page where the quotes should be showing up in the header?

Gio Takahashi

12-05-2005 01:40 AM

Quote:

Originally Posted by Cap'n Steve

Code:

UPDATE $TPquotes ADD COLUMN (votes SMALLINT(10) UNSIGNED NOT NULL DEFAULT 0, rating MEDIUMINT(10) NOT NULL DEFAULT 0, average FLOAT(3, 2) NOT NULL DEFAULT 0.00, context VARCHAR(250))

Code:

ALTER TABLE $TPquotes ADD INDEX rating

Code:

ALTER TABLE $TPquotes ADD INDEX average

Just replace $TP with your table prefix.

a bit of an issue: I had to manually add in the columns because the syntax you gave does not seem to work.

Yes I replaced $TP with the correct table prefixes..well I don't use prefixes at all anyway >>.

none of the queries work at all.

Cap'n Steve

12-05-2005 03:57 AM

That's weird, do you remember the error it showed?

All times are GMT. The time now is 09:40 AM.

Page 15 of 42

« First

Last »

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01475 seconds Memory Usage 1,756KB 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 (6)bbcode_code_printable (1)bbcode_html_printable (2)bbcode_php_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
Messages: