111
Catzwolf
Re:myReviews v2.1 module update!
  • 2004/10/17 4:01

  • Catzwolf

  • Home away from home

  • Posts: 1392

  • Since: 2007/9/30


Quote:

Kalobotz wrote:
Ok, I'll try to contact phphpbb and find out which functions they are and then it would probably be best to change them in myReviews next release. Till then I can't do much.

Thanks all


Really with all respect, you should actually change all you function names within your own module. This will save you hunting around as to why your own module wont work with others and it will keep your own house cleen and you wont have to worry about other modules.

We have renamed every or near all functions in all the WF modules for future reference.

112
karedokx
Re:myReviews v2.1 module update!
  • 2004/10/17 12:30

  • karedokx

  • Quite a regular

  • Posts: 319

  • Since: 2004/7/1 6


after i complete my article module for my website using the wf-sections (and still waiting desperately for liquid to complete and publish the bug fixes to the current beta), i plan to start working on (movie) reviews feature in my website.

really hope myReviews and wf-sections can work together and don't have any conflicts

113
Kalobotz
Re:myReviews v2.1 module update!
  • 2004/10/17 13:30

  • Kalobotz

  • Not too shy to talk

  • Posts: 133

  • Since: 2004/5/26


It doesn't seem like the Reviw ID numbers are showing up anywhere

114
Kalobotz
Re:myReviews v2.1 module update!
  • 2004/10/17 15:05

  • Kalobotz

  • Not too shy to talk

  • Posts: 133

  • Since: 2004/5/26


I am getting this error with SQL debugging on in the SPAW pages:

le="color: #000000"><?php SELECT articleid, title FROM xoops_wfs_article ORDER BY title Error number: 1146 Error message: Table 'thinkres_xoop1.xoops_wfs_article' doesn't exist SELECT storyid, title FROM xoops_stories ORDER BY title Error number: 1146 Error message: Table 'thinkres_xoop1.xoops_stories' doesn't exist


I don't have wfsections installed

Here is the full code

le="color: #000000"><?php Here is the whole SQL output: SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 1) ORDER BY conf_order ASC SELECT sess_data FROM xoops_session WHERE sess_id = 'b50fe3ac6e65d4a2bcc2cecf590e7415' SELECT * FROM xoops_users WHERE uid=1 SELECT * FROM xoops_modules WHERE dirname = 'myReviews' SELECT * FROM xoops_config WHERE (conf_modid = 9) ORDER BY conf_order ASC SELECT * FROM xoops_modules WHERE dirname = 'spaw' SELECT articleid, title FROM xoops_wfs_article ORDER BY title Error number: 1146 Error message: Table 'thinkres_xoop1.xoops_wfs_article' doesn't exist SELECT storyid, title FROM xoops_stories ORDER BY title Error number: 1146 Error message: Table 'thinkres_xoop1.xoops_stories' doesn't exist SELECT * FROM xoops_config WHERE (conf_modid = 0 AND conf_catid = 3) ORDER BY conf_order ASC SELECT COUNT(*) FROM xoops_banner SELECT * FROM xoops_banner LIMIT 1, 1 UPDATE xoops_banner SET impmade = impmade+1 WHERE bid = 2 SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name = 'block_read' AND gperm_modid = 1 AND gperm_groupid IN (1,2) SELECT b.* FROM xoops_newblocks b, xoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=1 AND b.visible=1 AND m.module_id IN (0,9) AND b.bid IN (1,2,3,4,5,6,7,8,9,10,11,12,36,37,38,33,34,35) ORDER BY b.weight,b.bid SELECT COUNT(*) FROM xoops_priv_msgs WHERE (read_msg = 0 AND to_userid = 1) SELECT * FROM xoops_modules WHERE (hasmain = 1 AND isactive = 1 AND weight > 0) ORDER BY weight ASC, mid ASC SELECT * FROM xoops_group_permission WHERE (gperm_name = 'module_read' AND gperm_modid = 1 AND (gperm_groupid = 1 OR gperm_groupid = 2)) SELECT COUNT(*) FROM xoops_online WHERE online_uid=1 UPDATE xoops_online SET online_updated=1098027064, online_module = 9 WHERE online_uid = 1 SELECT * FROM xoops_online SELECT COUNT(*) FROM xoops_online WHERE online_module = 9 SELECT * FROM xoops_myReviews_reviews WHERE lid=4 AND reviewuser=1 SELECT cid FROM xoops_myReviews_downloads WHERE lid=4 SELECT rid, ratingcat FROM xoops_myReviews_ratingcat WHERE cid=1 SELECT title FROM xoops_myReviews_downloads WHERE lid=4 SELECT review FROM xoops_myReviews_reviews WHERE lid=4 AND reviewuser=1 SELECT rating FROM xoops_myReviews_votedata WHERE lid=4 AND ratinguser=1 SELECT rating, ratingcat FROM xoops_myReviews_votecat WHERE lid=4 AND ratinguser=1 ORDER BY ratingcat Total: 28 queries Blocks User Menu: No Cache Login: No Cache Main Menu: No Cache Who's Online: No Cache Total: 4 blocks Execution Time XOOPS took 0.31595897674561 seconds to load.


Looks like this may have something to do with the SPAW module. I'll just put in a custom SPAW.

115
hightyde
Re:myReviews v2.1 module update!
  • 2004/11/21 8:27

  • hightyde

  • Just popping in

  • Posts: 86

  • Since: 2003/7/11


Any updates on this great module?

116
doors
Re: myReviews v2.1 module update!
  • 2005/1/30 6:55

  • doors

  • Just popping in

  • Posts: 2

  • Since: 2005/1/29


Quote:

BTW, is there going to be anyway to turn off some of the menu options like "We Recommend", "Love at First Sight" etc?

You are able to turn off any menu item by commenting the 2 line out in the xoops_version.php file ie if you do not want to have the hall of fame the section would look like this: remember to keep the numbering in sequence.

// Menu
$modversion['hasMain'] = 1;

$modversion['sub'][1]['name'] = _MI_myReviews_SMNAME3;
$modversion['sub'][1]['url'] = "submit.php";

$modversion['sub'][2]['name'] = _MI_myReviews_SMNAME1;
$modversion['sub'][2]['url'] = "topten.php?hit=1";

$modversion['sub'][3]['name'] = _MI_myReviews_SMNAME2;
$modversion['sub'][3]['url'] = "topten.php?rate=1";

$modversion['sub'][4]['name'] = _MI_myReviews_SMNAME4;
$modversion['sub'][4]['url'] = "randomfile.php";

//$modversion['sub'][5]['name'] = _MI_myReviews_SMNAME5;
//$modversion['sub'][5]['url'] = "halloffame.php";

$modversion['sub'][5]['name'] = _MI_myReviews_SMNAME6;
$modversion['sub'][5]['url'] = "onion.php?rate=1";
Quote:

And Is there a way to add a "Sorry no Reviews in this section" blurb when a user hits a section in the browse area with no reviews. Like if they click on the "A" in browse mode and there aren't any reviews in that category.

I will add this to the todo list. Good suggestion!

Grotmis
Riaan


I've commented out the menu items that appear in the sidebar...thanks for that. I'd really like to pare down the options underneath the actual review itself as well... "love it", etc. Is their something I'm missing?

Also, I'm attempting to do a Japanese localization for this great module.. could anybody point me to a which files to look in to find and replace, for example, the "browse" and "submit" buttons? I've found and replaced a lot of text, but I'm having trouble tracking down some of them.

With that being said, if somebody could point me towards a localization that has already been done, well all the better!

Cheers
Jeff

117
animas
Did anyone had this?
  • 2005/2/10 11:47

  • animas

  • Quite a regular

  • Posts: 206

  • Since: 2005/1/30


Firstly very useful module and feature rich too.

I am having some problem with My Reviews 2.1 RC1
When user click Reviews link the page shows reveiws(Latest Listings) reviews and the following codes(more that 50 lines) just after description of EACH review.

Quote:

\n"; //Start with the Review Display //Do the overall rating Display first //$formatted_date = formatTimestamp($reviewtimestamp); $review = $myts->makeTareaData4Show($review,1); //$reviewuname = XoopsUser::getUnameFromId($reviewuser); $resulttot=$xoopsDB->query("SELECT rating FROM ".$xoopsDB->prefix("myReviews_votedata")." WHERE lid = $lid"); $totalraw=0;


And so on...

How to fix it?

118
konaafob
Re: Did anyone had this?
  • 2005/2/27 13:51

  • konaafob

  • Just popping in

  • Posts: 57

  • Since: 2005/1/10


Hi,
This module is great. I am having following problems.
1. No Image ( image) shows up if I try to upload .jpg file
2. If I upload .gif file it works fine but permission problem. I have to physically go to the image file that has been created in shot directory and give read permission.

I checked all permissions on directories and looks fine. If anyone knows the fix then please let me know.

thanks in Advance.

-- Kona

119
culex
Re: Did anyone had this?
  • 2005/3/11 11:48

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


In file topten.php
---------------------

Change line 91 - 96

le="color: #000000"><?php if(isset($HTTP_POST_VARS['rate']) or isset($HTTP_GET_VARS['rate'])){ $sort = _MD_RATING; $sortDB = "rating";


INTO

le="color: #000000"><?php if(isset($HTTP_GET_VARS['rate'])){ $sort = _MD_RATING; $sortDB = "rating";



AND LINE 125

le="color: #000000"><?php $query = "SELECT lid, cid, title, hits, rating, votes FROM ".$xoopsDB->prefix("myReviews_downloads")." WHERE status>0 AND rating>0 AND (cid=$cid";


INTO

le="color: #000000"><?php $query = "SELECT lid, cid, title, hits, rating, votes FROM ".$xoopsDB->prefix(myReviews_downloads)." WHERE (status>0 AND rating>0 AND cid=$cid";


///////////////////////////////////////////////////////

Make the same changes in Onion.php,recommendit.php and loveit.php

Other errors: in onion.php,recommendit.php and loveit.php

remove ')' from line 40 this causes MySQL error 1064

FROM

le="color: #000000"><?php $query .= ") ORDER BY ".$sortDB." ASC";


To

le="color: #000000"><?php $query .= " ORDER BY ".$sortDB." ASC";


This ought to clear up some errors :o)

120
wcrwcr
Re: Did anyone had this?
  • 2005/3/22 17:27

  • wcrwcr

  • Home away from home

  • Posts: 1114

  • Since: 2003/12/12


Hi culex and guys

I?ve been trying to find where to download the last release of this mod but i coudn?t find It anywhere.

Can anyone send the last review to me?


Thanks in advance,
Wilson