xoops forums

Forum Index


Board index » All Posts (culex)




culex

Module Developer
Posted on: 2005/3/11 11:56
culex
culex (Show more)
Module Developer
Posts: 711
Since: 2004/9/23
#481

myReviews RSC 2.1 - Changes to make it work

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)


culex

Module Developer
Posted on: 2005/3/11 11:48
culex
culex (Show more)
Module Developer
Posts: 711
Since: 2004/9/23
#482

Re: Did anyone had this?

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)


culex

Module Developer
Posted on: 2004/11/19 9:48
culex
culex (Show more)
Module Developer
Posts: 711
Since: 2004/9/23
#483

Re: Discography Help/Fixes/Updates/

Using Cd base often causes the script to cash ('Could not add data'). I have found that changing the integer (tinyint) to simply 'int' in the sqlfile helps.

Timyint = Integer (whole number) data from 0 through 255. Storage size is 1 byte.

Int = Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes.

Well anyways ... this did the trick in my case

my sqlfile for Cd Base can be downloaded here..Culex.dk under downloads ;)


culex

Module Developer
Posted on: 2004/11/18 10:33
culex
culex (Show more)
Module Developer
Posts: 711
Since: 2004/9/23
#484

Re: Module request - discography module

Using Cd base often causes the script to cash ('Could not add data'). I have found that changing the integer (tinyint) to simply 'int' in the sqlfile helps.

Timyint = Integer (whole number) data from 0 through 255. Storage size is 1 byte.

Int = Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). Storage size is 4 bytes.

Well anyways ... this did the trick in my case

my sqlfile for Cd Base can be downloaded here.. www.culex.dk



TopTop
« 1 ... 46 47 48 (49)