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)

Kirk Fitzgerald 07-06-2012 10:59 PM

Hi there again Ted,

is there a way for me to add the reviewers name and profile link in the reviews?

I've been trying to figure it out myself but, well, let's just say I am no coder. :o

Ted S 07-06-2012 11:38 PM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345646)
Hi there again Ted,

is there a way for me to add the reviewers name and profile link in the reviews?

I've been trying to figure it out myself but, well, let's just say I am no coder. :o

I'm not sure what you mean? Reviews are created under as a post / thread that's from the user posting them. Why would you need to add a review as an admin?

Kirk Fitzgerald 07-06-2012 11:51 PM

1 Attachment(s)
Quote:

Originally Posted by Ted S (Post 2345658)
I'm not sure what you mean? Reviews are created under as a post / thread that's from the user posting them. Why would you need to add a review as an admin?

Sorry, my fault, I didn't explain myself clearly. :o

If you look here you will see a review on my site:
http://www.pipesmokerscubby.com/show...arson-Pleasure

That is a review made by a member, I would like the members name in the main review entry like this:
Attachment 139579

It's just a personal touch I should like, it's no big thing if it is awkward, I can live without it of course, sorry to be such a drag.

Ted S 07-07-2012 12:34 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345660)
Sorry, my fault, I didn't explain myself clearly. :o

If you look here you will see a review on my site:
http://www.pipesmokerscubby.com/show...arson-Pleasure

That is a review made by a member, I would like the members name in the main review entry like this:
Attachment 139579

It's just a personal touch I should like, it's no big thing if it is awkward, I can live without it of course, sorry to be such a drag.

Your screenshot isn't of a review, it's of a product which can be reviewed. The concept is to have a parent product and multiple reviews for it so it's easy to understand items overall...

That said, the user who creates the product is stored in the db so you can quickly hack the template to add this in.

Kirk Fitzgerald 07-07-2012 05:08 AM

Again, sorry, my fault for not being clear, had a very long day and was very tired, sorry about that.

So editing the template is a work around, that is great news and sounds very promising, but like I mentioned, I am no coder and can't figure out how to get the data.

I have created a language phrase so have the text "Listing Created By: " showing but I can't figure out what to use to pull in the users name.

I am using this:
Code:

                                        <div id="pf_createdby">
                                                {vb:phrase prodforums_creator,{vb:raw product.createdby}}
                                        </div><br />

I looked in the database and figured the field I need to call is createdby, either that is wrong or I have missed something, would you be so kind as to help me out here please, can you tell me what I need to use, it would be wonderfully helpful, if you don't mind too much.

Thanks, Kirk. :)

Ted S 07-07-2012 08:42 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345716)
Again, sorry, my fault for not being clear, had a very long day and was very tired, sorry about that.

So editing the template is a work around, that is great news and sounds very promising, but like I mentioned, I am no coder and can't figure out how to get the data.

I have created a language phrase so have the text "Listing Created By: " showing but I can't figure out what to use to pull in the users name.

I am using this:
Code:

                    <div id="pf_createdby">
                        {vb:phrase prodforums_creator,{vb:raw product.createdby}}
                    </div><br />

I looked in the database and figured the field I need to call is createdby, either that is wrong or I have missed something, would you be so kind as to help me out here please, can you tell me what I need to use, it would be wonderfully helpful, if you don't mind too much.

Thanks, Kirk. :)

Your code isn't all that bad -- you'd need to be sure you have {1} for the variable but it's the variable where your issue is...

createdby a user id and to make a name show up you'll have to find the query that pulls in the product info and join the user table, add user.username and then change the variable to {vb:raw product.username}. If that sounds crazy, sorry.

Kirk Fitzgerald 07-07-2012 09:12 AM

Wow, that has totally gone straight over my head.

How do I find out about the query, how do I join user tables?

Sorry for being so dimwitted with all this. :o

MySaltyreef 07-07-2012 11:06 AM

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 ?

MySaltyreef 07-07-2012 11:08 AM

Quote:

Originally Posted by Kirk Fitzgerald (Post 2345746)
Wow, that has totally gone straight over my head.

How do I find out about the query, how do I join user tables?

Sorry for being so dimwitted with all this. :o

dude use google these guys don't have the time to sit and "teach" all information that you need has been explained already on one of the vb forums, otherwise try going to www.vbulletin.com for support

i'm in the same boat as you, info is hard to come by sand i don't know this stuff either i'm just a hobbyist with a forum so its harder for okes likes us :)

Kirk Fitzgerald 07-07-2012 11:29 AM

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 ?

There's a link in the review section to add a review that your members can use to submit listings.

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.


All times are GMT. The time now is 08:53 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.02644 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
  • (2)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