vb.org Archive - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features)

Page 94 of 181

« First

104

144

Last »

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

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

- vBulletin 3.8 Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=235)

- - Add-On Releases - [AJAX] Helpful Answers - Post Rating System (plus many sub-features) (https://vborg.vbsupport.ru/showthread.php?t=204117)

reddyink

07-26-2009 02:04 AM

Quote:

Originally Posted by tpearl5 (Post 1855465)

FYI, I have 1.9 working with vbplaza (with one small code addition) without a problem...

Appreciate if you can post the code so that others can benefit and this Mod owner can incorporate into the plug-in itself.

Ted S

07-26-2009 03:35 AM

Quote:

Originally Posted by reddyink (Post 1855471)

Appreciate if you can post the code so that others can benefit and this Mod owner can incorporate into the plug-in itself.

It's been posted a few times if you search the mod. The code is not mine to incorporate.

navjotjsingh

07-26-2009 05:46 PM

I am trying this query to add table to the database:

Code:

CREATE TABLE vb_helpfulpost(

                     'postid' int(10) unsigned NOT NULL DEFAULT '0',

                     'threadid' int(10) unsigned NULL,

                  'goodrank' INT(7) UNSIGNED NOT NULL DEFAULT '0',

                  'totalrank' INT(7) UNSIGNED NOT NULL DEFAULT '0',

                  'lastvote' INT UNSIGNED NOT NULL DEFAULT '0',

                  'userid' int(7) unsigned NULL',

                  KEY 'postid' ('postid'),

                  KEY 'goodrank' ('goodrank'),

                  KEY 'totalrank' ('totalrank')

);

But still it says SQL Error :

Code:

#1064 - 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 ''postid' int(10) unsigned NOT NULL DEFAULT '0',

                     'threadid' int(10) unsign' at line 2

How to add this table?

Ted S

07-26-2009 06:58 PM

Remove the word "unsigned" from threadid.

Why are you trying to create this manually?

navjotjsingh

07-26-2009 07:19 PM

Because it didn't got created with the installer. Another error:

Code:

#1064 - 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 ''postid' int(10) unsigned NOT NULL DEFAULT '0',

                     'threadid'' at line 2

Ted S

07-26-2009 10:41 PM

Quote:

Originally Posted by navjotjsingh (Post 1856042)

Because it didn't got created with the installer. Another error:

Code:

#1064 - 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 ''postid' int(10) unsigned NOT NULL DEFAULT '0',

                     'threadid'' at line 2

What version of mySQL are you using?

TRABZONLUKAPLAN

07-27-2009 12:50 AM

Installed but how can we use this like https://vborg.vbsupport.ru/external/2009/07/4.gif instead of "5 out of 2 found this helpful" ? I mean, its enough to learn how can I get the number of users who didnt find the post helpful ?

And one more question. If I delete this addon, the table which is created by the addon in the database will be deleted or not ? Should I do sth extra to deletion ?

Thanks in advance, thanks for this helpful addon.

navjotjsingh

07-27-2009 12:55 AM

MySQL 5.1.30

Ted S

07-27-2009 01:06 AM

Quote:

Originally Posted by TRABZONLUKAPLAN (Post 1856212)

The addon comes with options to use thumb images. You can edit the style / text through your phrase manager.

Quote:

Originally Posted by TRABZONLUKAPLAN (Post 1856212)

And one more question. If I delete this addon, the table which is created by the addon in the database will be deleted or not ? Should I do sth extra to deletion ?

The tables will be removed when you remove the addon.

Ted S

07-27-2009 01:20 AM

Quote:

Originally Posted by navjotjsingh (Post 1856216)

MySQL 5.1.30

Try:

Code:

CREATE TABLE helpfulpost (

`postid` INT(10) NOT NULL DEFAULT '0',

`threadid` INT(10) NULL,

`goodrank` INT(7) UNSIGNED NOT NULL DEFAULT '0',

`totalrank` INT(7) UNSIGNED NOT NULL DEFAULT '0',

`lastvote` INT UNSIGNED NOT NULL DEFAULT '0',

`userid` INT(7) unsigned NULL,

KEY `postid` (`postid`),

KEY `goodrank` (`goodrank`),

KEY `totalrank` (`totalrank`)

);

All times are GMT. The time now is 03:54 AM.

Page 94 of 181

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

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