xoops forums

Forum Index


Board index » All Posts (Roby73)




Roby73

Friend of XOOPS
Posted on: 2011/8/21 0:50
Roby73
Roby73 (Show more)
Friend of XOOPS
Posts: 262
Since: 2011/6/15
#241

Re: XOOPS Basic Module Pack - Beta 1: MyLinks

The problem of the total link by category is in the file /include/funcions.php
in query:
$query "SELECT COUNT(*) FROM " $xoopsDB->prefix("mylinks_links") . " WHERE `cid` IN {$catIds}";
    if (
'' != $status){
        
$status  = (== intval($status)) ? 1;
        
$query .= " AND status='{$status}'";
    }

if status is equal to 2 (updated link) is not counted. Do not read the value in the database if is equal to 2.

If force control "AND status>0" the total is correct


Roby73

Friend of XOOPS
Posted on: 2011/8/20 0:35
Roby73
Roby73 (Show more)
Friend of XOOPS
Posts: 262
Since: 2011/6/15
#242

Re: XOOPS Basic Module Pack - Beta 1: MyLinks

Other probable bug in mylinks.
The number of total links reported is not equal with the sum of the links displayed in the categories.

The total displayed is correct.

ES:

category1(4) category2(6) category3(6) <---- 16 links total wrong

Total links (20) <--- this is correct!

In the file myblocksadmin.php missing definition costant language. (search costants in /module/system/admin.)
_MI_MYLINKS_BNAME1
_MI_MYLINKS_BNAME2
_MI_MYLINKS_BNAME3

The costants are located in modinfo.php

Sorry for bad english


Roby73

Friend of XOOPS
Posted on: 2011/8/19 23:07
Roby73
Roby73 (Show more)
Friend of XOOPS
Posts: 262
Since: 2011/6/15
#243

Re: XOOPS Basic Module Pack - Beta 1: MyLinks

Thanks!!!


Roby73

Friend of XOOPS
Posted on: 2011/8/19 0:12
Roby73
Roby73 (Show more)
Friend of XOOPS
Posts: 262
Since: 2011/6/15
#244

Re: XOOPS Basic Module Pack - Beta 1: marquee

Module marquee
No images in /Frameworks/moduleclasses/moduleadmin/images/admin and /action.




Roby73

Friend of XOOPS
Posted on: 2011/8/17 14:13
Roby73
Roby73 (Show more)
Friend of XOOPS
Posts: 262
Since: 2011/6/15
#245

Re: XOOPS Basic Module Pack - Beta 1: mylinks

There is a problem in the file topten.php
In the line 78, there is a double "WHERE" in the query. Replece second WHERE with AND?


Roby73

Friend of XOOPS
Posted on: 2011/8/16 14:08
Roby73
Roby73 (Show more)
Friend of XOOPS
Posts: 262
Since: 2011/6/15
#246

Re: XOOPS Basic Module Pack - Beta 1: MyLinks

I'm testing module mylinks.
I have a problem with page navigation.
Error is:
0,010694 - SELECT l.lidl.cidl.titlel.urll.logourll.statusl.datel.hitsl.ratingl.votesl.commentst.description FROM mylinks_links lmylinks_text t WHERE cid='7' AND l.lid=t.lid AND status>0 ORDER BY titleA LIMIT 1010 Error number1054 Error messageUnknown column 'titleA' in 'order clause'


Code link titeleA and other are put in the query.

My xoops version: 2.5.1a
Php version: 5.2.17

Sorry for my bad english



TopTop
« 1 ... 22 23 24 (25)