xoops forums

Forum Index


Board index » All Posts (metin)




metin

Just popping in
Posted on: 2005/10/17 18:18
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#1

Re: want to understand xoopscomment system ?

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


metin

Just popping in
Posted on: 2005/10/2 16:17
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#2

Adding Groups & PDdownloads Comments Infos to UserProfile ?

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 ?


metin

Just popping in
Posted on: 2005/10/2 15:27
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#3

PDdownloads Submitter Rating Listing ?

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.


??


metin

Just popping in
Posted on: 2005/10/1 19:07
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#4

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

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.


metin

Just popping in
Posted on: 2005/9/30 17:33
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#5

Re: want to understand xoopscomment system ?

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.


metin

Just popping in
Posted on: 2005/9/30 15:20
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#6

Re: want to understand xoopscomment system ?

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.


metin

Just popping in
Posted on: 2005/9/30 15:07
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#7

want to understand xoopscomment system ?

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 ?


metin

Just popping in
Posted on: 2005/9/29 17:56
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#8

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

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.


metin

Just popping in
Posted on: 2005/9/29 17:53
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#9

Re: how can i do a user points system ?

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.


metin

Just popping in
Posted on: 2005/9/6 12:07
metin
metin (Show more)
Just popping in
Posts: 64
Since: 2003/6/21
#10

2.0.13 group change box & posting counting problem

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 ?



TopTop
(1) 2 3 4 ... 6 »