481
culex
myReviews RSC 2.1 - Changes to make it work
  • 2005/3/11 11:56

  • 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)



482
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)



483
culex
Re: Discography Help/Fixes/Updates/
  • 2004/11/19 9:48

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


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 ;)



484
culex
Re: Module request - discography module
  • 2004/11/18 10:33

  • culex

  • Module Developer

  • Posts: 711

  • Since: 2004/9/23


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)



Login

Who's Online

176 user(s) are online (116 user(s) are browsing Support Forums)


Members: 0


Guests: 176


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