Reviewpost 3.32 PROBLEM

[orangeflea]

adm-misc.php
adm-product.php
bulkupload.php
editproduct.php
header-inc.php
index.php
pp-inc.php
revshow.php *NEW*
showcat.php
showmembers.php
showproduct.php
uploadproduct.php

languages/english.php

templates/cathead.tmpl
templates/editprofile.tmpl
templates/profile.tmpl
templates/reviewspal.tmpl
templates/revshow.tmpl *NEW*
templates/showproduct.tmpl
templates/showproduct1.tmpl

templates/vb3enhanced/cathead.tmpl
templates/vb3enhanced/editproduct.tmpl
templates/vb3enhanced/profile.tmpl
templates/vb3enhanced/reviewspal.tmpl
templates/vb3enhanced/revshow.tmpl *NEW*
templates/vb3enhanced/showproduct.tmpl
templates/vb3enhanced/showproduct1.tmpl

This problem is about the new review feature. Uploaded all of these, and it's still not showing. Just take a look at the screenshots I've uploaded all the darn files)...

EDIT: Bulkupload.php and english.php were also uploaded, just doesn't show in the screenshots

[Chuck S]

I think you grabbed it before it was updated as the links in profile template where an afterthought and not part of the initial download yesterday morning

redownload it

[orangeflea]

That solved the problem.

I've managed to add a link to members reviews on their vBulletin profiles and vBulletin postbit (I used phrase manager to do it), but I get a mysql error whenever I click on links to reviews from members that never posted a review:

Warning: mysql_fetch_row(): supplied argument is not a valid MySQL result resource in /home2/xxxx/public_html/reviews/revshow.php on line 74

How can that be fixed?

I know I employed an unconventional method, but I really want this feature displayed in their vbulletin profile along with their reviewpost profile. I don't know anything about setting conditions and ifs. Please help. This is the final leg of my journey with this.

[Chuck S]

redownload the build and upload the language file english.php and revshow.php

[orangeflea]

YES! *throws fist like Howard Dean* HEEEYA!!

[orangeflea]

All right, I'm not going to give up on the alphabetical listing thing just yet. This is not a new problem, but an old annoyance that we can remove once and for all! Don't give up on me now, Chuck!

How is it that when you sort the products in order of title, using standard reviewpost feature, the script is able to do it perfectly --- it grabs the first letter of the title, nothing else, to sort the list. But we can't use the preexisting ability to sort products slightly different?

There's something missing here...

[Chuck S]

Your not providing examples here. I show things work fine and even provided links.

You need to realize a search result and a sort are two separate things. I explained that if you have a multi word title it will find or search either word

Now you may sort however you wish but the results are sorted on the manufacter field

[orangeflea]

90% of my products have titles with multiple words.

Let's say I had a bunch of reviews for movies, and someone clicked on "H" (to find, for example, "Hard to Kill," with Steven Seagal).

The first movie on the results list will be something like "From Hell" or "The Witching Hour" because those titles have words that start with the letter "H". I'd be fine with it if those wrong results were pushed to the very end of the list or something, but they get in the way of the TRUE results (i.e., movie titles that BEGIN with the letter "H").

EDIT: Just provided you an example. I know you don't like to be PM'd, but I don't want to advertise my site.

[Chuck S]

Well when posting examples you need to post them here unless asked otherwise. It is customary on any support forum that you post explicit examples.

As I have said if your using multiple word titles there is nothing we can do for you. All you can do is change your sort to what you think would work best for you situation.

In our provided code I have made the default sort manufacturer which I think is the most logical considering our product has both a manufacturer and title field which most everyone uses and which are searched by those letters. I know you dont use manu.

You might want to do sort by title so change the sort 7 to sort 8 in your showcat script

Now

[orangeflea]

You might want to do sort by title so change the sort 7 to sort 8 in your showcat script

Did that, no change.

Man, this sucks. I know it's not impossible to do, because Reviewpost is flexible enough to allow for virtually every other form of searches. Isn't there some code you can see from other sites that have the sorting thing right, and just infuse it to this thing?

You've seen my review area. The alphabetical sort thing is practically useless in my case, wouldn't you say?

I'm not giving up on this.

[Chuck S]

well our product is coded for how it works meaning the manufacturer field is first so thats the default recommended search. I gave you a suggestion for you site see my site here is a clear example manu and title

http://www.reeftalk.com/reviews/show...a&cat=8&limit=

If your using multi word titles there is nothing I can suggest cause your going to return any result where a word begins with say T. THATS SIMPLE MYSQL AND HOW IT WORKS

Man in the house EXAMPLE

The House EXAMPLE

House of Template EXAMPLE

Now given that explanation very simple if you sort by title it is definately sorted correctly like this that I can see

House of Template

Man in the house

The House

So how is that wrong?

No actually I have not seen your review site cause I refuse to look at PM's when I dont ask for them. But you know what I took a peak and it displays fine. It is sorted exactly as I noted in my post here

[orangeflea]

No actually I have not seen your review site cause I refuse to look at PM's when I dont ask for them. But you know what I took a peak and it displays fine. It is sorted exactly as I noted in my post here

Wtf, man. I don't want my URL spidered here. It's not like I ask for support through PMs. I just give you the URL, and expect the support to be handled on the threads themselves.

Anyway, I'm not going to explain the importance of true alphabetic listing because it's obvious that you don't get (or want to get) the picture. Sometimes a user or member cannot remember the title of a movie or book but remember that it started with "an H or something" so they look for products that BEGIN with the letter "H."

And I refuse to believe that is the function and limitaton of MySQL. If that were the case, you wouldn't be able to have alphabetic sorting on the vbulletin board members list, but you can...and it does it perfectly (even with members with multiple words in their names). So what does the members list sorting for vbulletin do right that reviewpost can't?

[Chuck S]

You are not getting what I am saying. Your using a 3-5 word title

There when you issue a mysql query and do this

AND title LIKE '%h%'

it will return every result with a word that begins with h very simple

Your results are valid and they are also validly being sorted by title when returned. You can always redownload and make sure your using the latest showcat

[orangeflea]

So if it's a MySQL issue, then how does vBulletin sort out the members list alphabetically like I want it, even though users have multiple words in their user names?

[Chuck S]

Did you replace you showcat file?

[orangeflea]

Downloaded the new batch of files and now it's working. Thanks, Chuck. I don't mean to give you or the staff a hard time, I just want the best out of my products.