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:

SELECT articleidtitle 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

Here is the whole SQL output:

SELECT FROM xoops_config WHERE (conf_modid AND conf_catid 1ORDER BY conf_order ASC 
SELECT sess_data FROM xoops_session WHERE sess_id 
'b50fe3ac6e65d4a2bcc2cecf590e7415' 
SELECT FROM xoops_users WHERE uid=
SELECT 
FROM xoops_modules WHERE dirname 'myReviews' 
SELECT FROM xoops_config WHERE (conf_modid 9ORDER BY conf_order ASC 
SELECT 
FROM xoops_modules WHERE dirname 'spaw' 
SELECT articleidtitle 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 AND conf_catid 3ORDER BY conf_order ASC 
SELECT COUNT
(*) FROM xoops_banner 
SELECT 
FROM xoops_banner LIMIT 1
UPDATE xoops_banner SET impmade 
impmade+1 WHERE bid 
SELECT DISTINCT gperm_itemid FROM xoops_group_permission WHERE gperm_name 
'block_read' AND gperm_modid AND gperm_groupid IN (1,2
SELECT b.* FROM xoops_newblocks bxoops_block_module_link m WHERE m.block_id=b.bid AND b.isactive=AND b.visible=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,35ORDER BY b.weight,b.bid 
SELECT COUNT
(*) FROM xoops_priv_msgs WHERE (read_msg AND to_userid 1
SELECT FROM xoops_modules WHERE (hasmain AND isactive AND weight 0ORDER BY weight ASCmid ASC 
SELECT 
FROM xoops_group_permission WHERE (gperm_name 'module_read' AND gperm_modid AND (gperm_groupid OR gperm_groupid 2)) 
SELECT COUNT(*) FROM xoops_online WHERE online_uid=
UPDATE xoops_online SET online_updated
=1098027064online_module 9 WHERE online_uid 
SELECT 
FROM xoops_online 
SELECT COUNT
(*) FROM xoops_online WHERE online_module 
SELECT 
FROM xoops_myReviews_reviews WHERE lid=AND reviewuser=
SELECT cid FROM xoops_myReviews_downloads WHERE lid
=
SELECT rid
ratingcat FROM xoops_myReviews_ratingcat WHERE cid=
SELECT title FROM xoops_myReviews_downloads WHERE lid
=
SELECT review FROM xoops_myReviews_reviews WHERE lid
=AND reviewuser=
SELECT rating FROM xoops_myReviews_votedata WHERE lid
=AND ratinguser=
SELECT rating
ratingcat FROM xoops_myReviews_votecat WHERE lid=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

if(isset($HTTP_POST_VARS['rate']) or isset($HTTP_GET_VARS['rate'])){
    
$sort _MD_RATING;
    
$sortDB "rating";


INTO

if(isset($HTTP_GET_VARS['rate'])){

    
$sort _MD_RATING;

    
$sortDB "rating";



AND LINE 125

$query "SELECT lid, cid, title, hits, rating, votes FROM ".$xoopsDB->prefix("myReviews_downloads")." WHERE status>0 AND rating>0 AND (cid=$cid";


INTO

$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

$query .= ") ORDER BY ".$sortDB." ASC";


To

$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

Login

Who's Online

229 user(s) are online (151 user(s) are browsing Support Forums)


Members: 0


Guests: 229


more...

Donat-O-Meter

Stats
Goal: $100.00
Due Date: Apr 30
Gross Amount: $0.00
Net Balance: $0.00
Left to go: $100.00
Make donations with PayPal!

Latest GitHub Commits