Questions

[Frank71]

Hello,

I have some questions to the script, hope you can help.

I want to use it to review my amazon books.
That means I want to include it on every amazon number (asin - letters and numbers) , so the item id must be dynamic and be given by my book number (no setup in database).
And numbers and letters must be possible.
-> will this work ?

In this case I include by example index2.php?&item_id=GGHB234GH
If GGHB234GH is not reviewed I will only see the message "review it" and if there are reviews I can see them.

- In the demo I can't see a member function, so every one can write directly as he like ?

- if there is no, is a member function planed, so users must sign in before the write and they get an unique member name with password, may be in combination to user features from a forum ?

So I can motivate them with "hitlists", profile and so on like amazon.

Is it possible to test the script ?

Sorry for my bad english ;)

Regards from Germany

Frank

[imported_Tim Mousel]

I want to use it to review my amazon books.
That means I want to include it on every amazon number (asin - letters and numbers) , so the item id must be dynamic and be given by my book number (no setup in database).
And numbers and letters must be possible.
-> will this work ?

Yes, it will. You'd need to import the asin into the review_items table under the field of item_id.


- In the demo I can't see a member function, so every one can write directly as he like ?

There is a config.php file in which you can choose to allow anyone to post a review or require that they be registered and logged in.


-So I can motivate them with "hitlists", profile and so on like amazon.

The next version will also include a member profile, etc...see the other post I made about the next version and the new features...


Is it possible to test the script ?

You can test it at http://www.review-script.com/demo.php and the admin at http://www.review-script.com/admin/

You however won't have access to the config.php file for testing.

Tim

[Frank71]

You got mail ;)

Frank

[imported_Tim Mousel]

You do too! :)

[Frank71]

:D
You too, only to be sure the german adress won't be eaten by your spam filter. Up to now no forum confirmation from my site ;)

Frank

[Frank71]

Hello,

you got mail again ;)

May be it interest for all.

<And numbers and letters must be possible.
-<> will this work ?

<Yes, it will. You'd need to import the asin into the review_items table <under the field of item_id

- I tried it, but first step the field is integer so I changed it to varchar, but in this case the rest won't work.
So I added the item manuell, but also I got only errors, by example:
Couldn't execute sql_count, 1054: Unknown column 'B0007UPSXC' in 'where clause'

Last but not least I tried to review a mixed ASIN without adding it into database, but also got:
Warning: mysql_numrows(): supplied argument is not a valid MySQL result resource in /home/www/web18/html/review/index2.php on line 70

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/web18/html/review/index2.php on line 72

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/web18/html/review/index2.php on line 84
Couldn't execute sql_count, 1054: Unknown column 'B0007UPSXC' in 'where clause'

- no idea ;)

Frank

[imported_Tim Mousel]

Hi,

Here is the solution:

In index2.php, find all statements that start out as "select ....." and change
$item_id
to
'$item_id'

Then you need to change two rows in two tables.

In the review table, change review_item_id to a varchar(100) and in review_items table, change item_id to varchar(100). Also, in review_items table for item_id, drop the auto increment.

That should have you up and running...I just tested it.

Let me know if you have problems.

Tim

[Frank71]

Hello Tim,

sorry, as written:

review_form.php?&item_id=B0007UPSXC will still show Couldn't execute query, 1054: Unknown column 'B0007UPSXC' in 'where clause'

-> seems I get it, first I was confused abou the error message, but simple it seems to be the same problem in all other files.

Frank

[imported_Tim Mousel]

Open review_form.php and put the '' around item_id in the select statement. You'll have to do that in all the pages that have a sql query for item_id.

Just to prove to you that this will work:

http://www.golfable.com/review/review_form.php?item_id=Houston_TX_Bay_Oaks_Countr y_Club

Tim