Hi berzem, there is currently a review module called CJ-reviews that can be used with lots of hacking on your part, if however you are not into getting down and dirty a more generic review module is currently under development, if you do a search on this forum for reviews or myReviews you will find some recent threads pertaining to this topic. I am almost finished with the first development cycle of the generic myReviews module and will be distributing stable beta's to a selected few testers within the week, followed by a official release by the end of the month.
Keep on Xoopsing
Riaan
http://www.craftsonline.co.za

Hi Bo3b, there is currently a few threads dealing with the review module, I include these for your interest.

https://xoops.org/modules/newbb/viewtopic.php?forum=4&topic_id=17830

https://xoops.org/modules/newbb/viewtopic.php?forum=30&topic_id=18375

https://xoops.org/modules/newbb/viewtopic.php?forum=4&topic_id=18586


Please feel free to join in the development or specifications of what is going to be a great review module. Keep on Xoopsing.

Grotmis
Riaan
http://www.craftsonline.co.za

Hi there, if you look closely to your sql code you will see that you are overwriting the avatar_id that is an auto_increment field, every time you run a new file in the format above you will overwrite the information in the table at worst or be given a reffirrential integrity error at best.

#
# Table structure for table `avatar`
#

CREATE TABLE avatar (
avatar_id mediumint(8) unsigned NOT NULL auto_increment,
avatar_file varchar(30) NOT NULL default '',
avatar_name varchar(100) NOT NULL default '',
avatar_mimetype varchar(30) NOT NULL default '',
avatar_created int(10) NOT NULL default '0',
avatar_display tinyint(1) unsigned NOT NULL default '0',
avatar_weight smallint(5) unsigned NOT NULL default '0',
avatar_type char(1) NOT NULL default '',
PRIMARY KEY (avatar_id),
KEY avatar_type (avatar_type,avatar_display)
) TYPE=MyISAM;

Always try to use sql that specifies the collumn to insert to like:
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs001.gif', 'Animaniacs001.gif', 'image/gif', 1, 'S');
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs002.gif', 'Animaniacs002.gif', 'image/gif', 1, 'S');
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs003.gif', 'Animaniacs003.gif', 'image/gif', 1, 'S');
INSERT INTO `xoops_avatar` (`avatar_file`, `avatar_name`, `avatar_mimetype`, `avatar_display`, `avatar_type`) VALUES ('Animaniacs004.gif', 'Animaniacs004.gif', 'image/gif', 1, 'S');


Grotmis
Riaan
http://www.craftsonline.co.za

There is a CJ-Reviews module that is an adaptation of the myReviews module available in Beta state that does reviews, apart from some other modules can be hacked to do reviews on a limited schale. If you are looking for a full review module with categories and graphic slides the myReviews module is going to be your best bet. There is currently a thread in the module request forum dealing with the myReviews module, feel free to join that and give some feedback and input.

Grotmis
Riaan

Hi Guys, over the next few days I will be stabilizing the myReview code to the point we can call it Beta and release it for testing. It will not have all the functionaly on the wishlist, but it will be stable and usable by the general public if we test it propperly. This will include different category trees, but still with the same rating criteria, Integration into the install framework of xoops, working with php global off, take out all hardcoded looky feely colours, NO php errors in debug mode, no SQL errors in debug mode, Comment block integration, most importantly the language files must work for the whole module (admin part and user part) and maybe some smaller things too.
After that I will be taking the most important features and adding them while trying to release a new beta of that code in 30 days (if only I didn't have to work for a living )
If you guys start drawing up the wishlist I will do my best to give you a stable working module.

Grotmis
Riaan
http://www.craftsonline.co.za

Hi tc, I like your site look, very msn I don't undestand a word, but it look cool. Are you going to run banners in the open space at the top?

Hi m0nty, censura is not a XOOPS module, but a standalone php program, their lik is:
http://www.incursio.com/products/censura/index.html

Hi ajaxbr, the myReviews module is an adaptation of the myDownloads module, so you are right the base programming in that module is suited for reviews. I would like to take a look at what you have done with the module. Hopefully I would have stabilized the reviews module in the not to distant future.

Grotmis
Riaan
http://www.craftsonline.co.za

Hi m0nty, I am currently enhancing the myReview module and would like to use your input to drive the process forward. Would you be interested in testing the module? Are you looking at something like the Censura review module that is not open source?

Grotmis
Riaan
http://www.craftsonline.co.za

I have been using xcgal on my site and it is great, has all the features and more and was by far the easiest to setup. I can recommend it

Grotmis
Riaan
http://www.craftsonline.co.za/