Basic Question ... [Archive] - Five Star Forums

jmueller

12-23-2004, 03:16 AM

Just installed the script, need clarity on a couple things.

Your setup refers to 'categories' and 'items' ...
We have 400+ content pages, each of which we want to
add review functionality.

Does that mean we need to (first) create 400+ items in the script?

Or...

We have the ability to auto-create the review (url's with unique id's) links on our content pages... They would be sequential from 1 to 400.

But, it sounds like we need to create the links first in the script?
And then manually create corresponding links in the content?

I'm seeing a lot of manual work here. Please tell me I'm wrong.

Thanks.

Jim

g r o w t h t r a c. com

Anonymous

12-23-2004, 08:00 PM

Hi,

There needs to be something in the review_item table so the script will know what item is being reviewed. Normally the database is imported into the review_item table and is no big deal. Because you don't have a database, your situation is different.

You don't need to worry about the categories. You could add 400 items through the admin panel or a shortcut you could take would be to insert a numerical value for item_id in the review_item table. A basic script could insert 1-400 in this field. With that method the script would know what item was being reviewed. The biggest drawback to this method is that each review page would not say the name of the item being reviewed, but since the review would be on the product page it would not be a big deal. Some areas of the script would need to be changed where it tries to display the name/description of the product.

Let me know your thoughts.

Tim

jmueller

12-23-2004, 09:03 PM

I'm getting the feeling that we have the wrong script.

This script is more for reviewing "products" -- not content.

jmueller

12-23-2004, 09:32 PM

Tim
Okay- that could would work.

Using a script, bulk load the REVIEW_ITEMS table with 400+ records.

I won't worry about the display formatting-- I assume I can tweak that later.

So, Tim... would you be willing to create such a SQL script for me?

Basically, we need this:

```````````````````````````
Create 1,000 records

item_id sequential
item_name sequential -- 1 to 1,000 (no leading zeros)
item_desc = Article
category = Article

```````````````````````````

Thanks!
Jim

imported_Tim Mousel

12-23-2004, 11:00 PM

I wrote the script and emailed it to you.

Tim

imported_Tim Mousel

12-23-2004, 11:01 PM

I'm getting the feeling that we have the wrong script.

This script is more for reviewing "products" -- not content.

Just to clarify, it will work perfectly fine for reviewing content...the problem is that you don't have your data stored in a mysql database.

Tim

jmueller

12-23-2004, 11:09 PM

Tim, thank you for the script (and the prompt response).
I'll keep you posted.

Jim

jmueller

12-23-2004, 11:18 PM

Another question please:

I'm working on integrating the various pages and forms in to our site.

I've made changes to several of your php pages-- index2, body, save form_submit, guidelines -- but I can't find how to fit these in to our site 'template'. Is that done with includes? Or...?

Please save me some time and clue me in. :lol:
Thanks!

Jim

imported_Tim Mousel

12-24-2004, 12:07 AM

Edit /review/body.php

jmueller

12-24-2004, 02:26 AM

DISREGARD I got it.

Okay.

Tim, As a reference, I'm looking for a <body> tag somewhere-- can't find it. ??

BTW The script you sent me worked fine. Thanks.

Anonymous

12-24-2004, 04:21 PM

Tim

Well, I'm probably the only guy coding on Christmas Eve. If you're busy, I understand...

I'm trying to integrate the Review feature into our article pages.

I know how to add a unique Review link to a page-- that's not what I need.

Instead, I'm looking for something like this:
http://www.golfable.com/golfcourses/courses/Houston_TX_Houston_Hills_Golf_Course

Note the corresponding review info is at the bottom of the product page,
similar to Amazon pages.

I guess I would expect to add a php include to each of the pages...?

Help.

Thanks, and have a great Christmas.

Jim

jmueller

12-24-2004, 10:34 PM

DISREGARD I got it.

imported_Tim Mousel

12-25-2004, 04:37 AM

OK, glad you got it. I'm assuming you found the review_insert feature in the readme file.

You're not the only person online christmas eve, but definitely one of the few!! :)

Happy Holidays,

Tim

jmueller

12-25-2004, 07:06 AM

Almost there...

Hey Tim

http://www.growthtrac.com/artman/publish/article_74.php

Please scroll down on the above page; look for Article Reviews heading,
toward the bottom.

Note the Continue to Page 2 link at the bottom. Click on the link.

I would expect to see additional Reviews.
I do not. What is this page?

Also, on the above page my CSS styles are lost because
it doesn't utilize the 'body' template.

Thoughts?

Note, if I increase my $NumReviews, the above link goes away.

Merry Christmas to you too!
Jim

imported_Tim Mousel

12-25-2004, 10:39 PM

For now, I suggest setting $NumReviews to a higher number until I can recall the solution.

Merry Christmas!

Tim

jmueller

12-26-2004, 01:02 AM

Hi Tim

No urgency here. I'll adjust $NumReviews.

Jim