vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 4.x Add-ons (https://vborg.vbsupport.ru/forumdisplay.php?f=245)
-   -   Major Additions - Product Review Forums ? Research, Review & Compare Items (https://vborg.vbsupport.ru/showthread.php?t=269808)

Ted S 07-07-2012 06:09 PM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345769)
There's a link in the review section to add a review that your members can use to submit listings.

Very politely said given the context :D

Quote:

Originally Posted by MySaltyreef (Post 2345764)
i like it but i need something where my members can create their own product review in a given forum instead of me having to add it via the admin cp, are you working on something like this ?

Reviews are written through product listings and always by the user. In fact if you looked at the mod you'd see that there's no way for an admin to write one without going into the user interface themselves... The admin only lets you make products.

Ted S 07-07-2012 06:15 PM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345769)
I have already tried to do it myself by searching the net for info chap and have failed, which is why I am asking the one guy who will know how to do it properly. I have absolutely no idea what most sites are going on about when they talk about mysql queries, let alone translating it to search for something in my own database.

A join brings two tables together... For example for your needs:

SELECT <all the existing fields>,user.userid,user.username
FROM " . TABLE_PREFIX . "pf_product.createdby = user.userid
JOIN user ON pf_product

You'd work this into the query in the hook showthread_post_start

If you have a closed area of your forum for products play around with the code. While I understand it's not simple templates the best way to take control is by tweaking which leads to learning.

looker2010 07-07-2012 10:28 PM

The description of the added product text fields are not showing nor are the image urls,social media urls etc. Please advise

http://www.beektime.com/showthread.p...ee-Farm-Queens

Kirk Fitzgerald 07-08-2012 05:21 AM

Quote:

Originally Posted by looker2010 (Post 2345934)
The description of the added product text fields are not showing nor are the image urls,social media urls etc. Please advise

http://www.beektime.com/showthread.p...ee-Farm-Queens

You need to edit your forum "The Good, Bad and Ugly Reviews" in the admin panel and check the option 'Enable Product Review Forum Features?' and save.

PattiOz 07-08-2012 05:29 AM

I have installed to test on my local PC. Getting error:

Parse error: syntax error, unexpected $end in C:\xampp\htdocs\mysite\forum\admincp\productforums .php on line 1397

Any help is welcome!

Kirk Fitzgerald 07-08-2012 05:31 AM

Quote:

Originally Posted by Ted S (Post 2345869)
A join brings two tables together... For example for your needs:

SELECT <all the existing fields>,user.userid,user.username
FROM " . TABLE_PREFIX . "pf_product.createdby = user.userid
JOIN user ON pf_product

You'd work this into the query in the hook showthread_post_start

If you have a closed area of your forum for products play around with the code. While I understand it's not simple templates the best way to take control is by tweaking which leads to learning.

I really appreciate how much help you are being but this still doesn't make any sense to me at all, I have absolutely no idea how I would work a query into that hook. :erm:

I think it would be best for me to just accept the mod the way it works as is, I am finding myself feeling real stupid here and it's not going my self confidence any good at all. :)

Thanks for being so patient with me, this is a truly fantastic mod and you are a very good person for providing such a great mod and for being so helpful. :up:

Regards, Kirk. :)

Kirk Fitzgerald 07-08-2012 05:35 AM

Quote:

Originally Posted by PattiOz (Post 2345977)
I have installed to test on my local PC. Getting error:

Parse error: syntax error, unexpected $end in C:\xampp\htdocs\mysite\forum\admincp\productforums .php on line 1397

Any help is welcome!

Have you edited the admincp/productforums.php file, if not the file may have been corrupted during download, try re-downloading and replace that file with the new one.

Ted S 07-08-2012 05:38 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345978)
I really appreciate how much help you are being but this still doesn't make any sense to me at all, I have absolutely no idea how I would work a query into that hook. :erm:

I think it would be best for me to just accept the mod the way it works as is, I am finding myself feeling real stupid here and it's not going my self confidence any good at all. :)

Thanks for being so patient with me, this is a truly fantastic mod and you are a very good person for providing such a great mod and for being so helpful. :up:

Regards, Kirk. :)

Fair enough... If you change your mind, w3schools has some great basic mysql tutorials.

PattiOz 07-08-2012 06:41 AM

Will do Kirk! I did this, though:

Open: forumdisplay.php in a text editor

Find:

$templater = vB_Template::create('threadbit');

Replace with:

if($foruminfo['productforumsbits']){
$thread['pf_rating'] = vb_number_format($thread['pf_rating'],1);
$templater = vB_Template::create('prodforums_threadbit');
} else {
$templater = vB_Template::create('threadbit');
}

PattiOz 07-08-2012 06:57 AM

No luck yet Kirk. Same error. It's a fresh VB 4.2 install, no other mods, just been skinning the template.


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

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.02695 seconds
  • Memory Usage 1,746KB
  • 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
  • (7)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