Support Forums - All Posts - XOOPS Web Application System

1

Re: want to understand xoopscomment system ?

2005/10/17 18:18
metin
Just popping in
Posts: 64
Since: 2003/6/21

your code is working but i have a great problem with unactive comments. No matter if I am deleting them or not all comments in pddownloads are counting.

I add at line 69 ( com_status = 2 ) to get the active comments only but my code isn´t working.

Who can help me ?


function tabComments($uids) {

    global $xoopsDB, $periodej;

        $module_handler = xoops_gethandler("module");

        $pdmodule = $module_handler->getByDirname("PDdownloads");

        $sql = "SELECT  COUNT(*)  FROM ".$xoopsDB->prefix("xoopscomments")." WHERE com_uid='$uids' AND com_created > '$periodej' AND com_status = '2'"; 

        if (is_object($pdmodule)) {

            $sql .= " AND com_modid=".$pdmodule->getVar('mid');

        }

    list($comb) = $xoopsDB->fetchRow($xoopsDB->query($sql));

    $abacus = $comb;

    return $abacus;

}

2

Adding Groups & PDdownloads Comments Infos to UserProfile ?

2005/10/2 16:17
metin
Just popping in
Posts: 64
Since: 2003/6/21

we are using 2.0.13 ( www.remixland.de )

Did get help with this code from Mithandir for my userpoints module:


function tabComments($uids) {

    global $xoopsDB, $periodej;

        $module_handler = xoops_gethandler("module");

        $pdmodule = $module_handler->getByDirname("PDdownloads");

        $sql = "SELECT  COUNT(*)  FROM ".$xoopsDB->prefix("xoopscomments")." WHERE com_uid='$uids' AND com_created > '$periodej'";

        if (is_object($pdmodule)) {

            $sql .= " AND com_modid=".$pdmodule->getVar('mid');

        }

    list($comb) = $xoopsDB->fetchRow($xoopsDB->query($sql));

    $abacus = $comb;

    return $abacus;

}

and did add add later this code in index.php at line 142( userpoints ) to see if the user is member of an special group or not:


$member_handler =& xoops_gethandler('member');

$member =& $member_handler->getUser($uid);

if (is_object($member)) {

$cur_groups = $member->getGroups();

        }



        

        if ($xoopsUser->isAdmin(0)) {

                if (in_array(8, $cur_groups)) {

                    echo "<td align='center' class = 'even'>"._UPTUYES."</td>";

        }

        else {

        echo "<td align='center' class = 'even'><b>"._UPTUNO."</b></td>";

        }

I want to add PDdownloads Comments & Which Group member the user is Infos to the userprofile of every member.

What would you say ?

3

PDdownloads Submitter Rating Listing ?

2005/10/2 15:27
metin
Just popping in
Posts: 64
Since: 2003/6/21

I want to make an Submitter Rating TopList. All Votes from an submitter should be added to get a List of best rated submitters.

Here´s our topten.php file ( .zip format )

want to make a new php file for this.

it would be also ok when i would get a listing of the subcategories, cause every submitter have his own categorie.

??

4

[Meaning?] Error: .../databasefactory.php line 34

2005/10/1 19:07
metin
Just popping in
Posts: 64
Since: 2003/6/21

our XOOPS 2.0.13 site is down till 2 hours. I could login in for seconds but get everytime this error:

-------------------

This page cannot be displayed due to an internal error.

If you are the administrator of this site, please visit the XOOPS Troubleshooting Page for assistance.

Error [Xoops]: Unable to connect to database in file class/database/databasefactory.php line 34

---------------

i thought at first server connection but after 2 hourse i don´t know what else the problem could be.

Ftp is working.

----------------

i should have read other topics about this problem. Did find infos now. no connection to server. but we didn´t have this problem until now. Did install userpoints 3 days ago and changed and added code ( extra field to see if the member is in the special group ). I can´t login now to see if the site works without this module now but i will try. No other chance.

5

Re: want to understand xoopscomment system ?

2005/9/30 17:33
metin
Just popping in
Posts: 64
Since: 2003/6/21

mithandir i thank you very very much.

did change the code and it works.

i will add at next the group & rank where the user is to the list but think that should not be a great problem. Another idea is to subtract points if an user downloads an track. ok i am working on that.

You did help me a lot thanks again.

6

Re: want to understand xoopscomment system ?

2005/9/30 15:20
metin
Just popping in
Posts: 64
Since: 2003/6/21

we are using 2.0.13 ( www.remixland.de )

thank you very much.

but i don´t now where i have to use this code.

& how have to be the code in userpoints ( when i don´t change xoopscomment system counting ) ? This module is counting all comments.

i think the changes there have to be in funcs.php but im not sure.

7

want to understand xoopscomment system ?

2005/9/30 15:07
metin
Just popping in
Posts: 64
Since: 2003/6/21

my intention is to count only comments from one modul ( pd-downloads ) in userposts but don´t understand xoopscomment system really.

How does it work ? and is it possible to count only comments from one module ?

8

Re: search only for users without comments in one modul ?

2005/9/29 17:56
metin
Just popping in
Posts: 64
Since: 2003/6/21

want to solve the problem with userpoints module. Here is the userpoints module original !!

I now only want to count comments from only one modul ( pd-downloads ). Not all comments. It would solve my problem.

It´s really important and would be very nice to get help !!

Did look at the php code but find it too difficult.

9

Re: how can i do a user points system ?

2005/9/29 17:53
metin
Just popping in
Posts: 64
Since: 2003/6/21

sorry i am reading your post now.

here is the userpoints module original !!

i only want to count comments from only one modul ( pd-downloads ). Not all comments. It´s really important and would be very nice to get help !! Did look at the php code but find it too difficult.

10

2.0.13 group change box & posting counting problem

2005/9/6 12:07
metin
Just popping in
Posts: 64
Since: 2003/6/21

When i search for members with less than 1 or 2 post as example the results are often that the profile shows 1 post but the member have 8 forum posts ( as ex.). Or 0 and in profile listing are comments or other postings which didn´t counted. Another interesting problem is that one comment posting in news module listed double ( as news and comment ) in profile page ( sometimes ).

and another question about admin groups displaying at the end of a group page. There were at the beginning ( 6 months ago ) 2 boxes, where members could be transfered to an group or back. But after a time one of the boxes isn´t there and the possibility not given. The members at the left box are not visible too and the box is empty.

Is it normal when more and more users registrated to the site that this boxes doesn´t work later ? Is there a limitation that after as example 500 members this doesnt work anymore ?

We did change from wbb to XOOPS in march of this year and normally would have 25000 members, but with our site terms we had to delete members with no or only one posting after a month so we have now only 900 members. Not much i think and can´t understand why the boxes doesn´t works.

Do someone else had those problems and could solve them ?

Stats
Goal:	$100.00
Due Date:	Apr 30
Gross Amount:	$0.00
Net Balance:	$0.00
Left to go:	$100.00

Forum Index

Re: want to understand xoopscomment system ?

Adding Groups & PDdownloads Comments Infos to UserProfile ?

PDdownloads Submitter Rating Listing ?

[Meaning?] Error: .../databasefactory.php line 34

Re: want to understand xoopscomment system ?

Re: want to understand xoopscomment system ?

want to understand xoopscomment system ?

Re: search only for users without comments in one modul ?

Re: how can i do a user points system ?

2.0.13 group change box & posting counting problem

Login

Search

Recent Posts

Re: Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Rebuilding and Updating a 20 years old Xoops Website from 2.0.18? to 2.5.11

Re: NewBB v 5.1.0 b 6

Re: NewBB v 5.1.0 b 6

NewBB v 5.1.0 b 6

Re: XOOPS 2.5.11 search user is not working

Re: oledrion

Re: oledrion

Re: oledrion

Re: oledrion

Who's Online

Donat-O-Meter

Latest GitHub Commits

{{ record.sha.slice(0, 7) }} - {{ record.commit.message | truncate }}