Suche

[sascha]

Hey @ll!!

Hab mir gerade das Gummipunkte Modul von http://www.rinaldo2000at.de geholt!!!
Hab s auch erfolgreich Installiert, aber ich habe bemerkt das man keine Punkte für forum beiträge bekommt!!!
Kann mir jemand von euch vielleicht dabei helfen die Gummipunkte so zu erweitern das man punkte für denn seiten aufruf(loggin), E-Gallery, UserGästebuch, Gästebuch bekommt!!
Hier noch der Code von der gp.funk.php


<?php

/************************************************************************/
/* PHP-NUKE: Gummipunkte System                                         */
/* ============================                                         */
/*                                                                      */
/* Gives your User Points for there work                                */
/*                                                                      */
/* Copyright (c) 2002 by Sebastian Maier (sebastian.m@ier.info)         */
/* http://www.m@ier.info                                                */
/*                                                                                                         */
/* This program is free software. You can redistribute it and/or modify */
/* it under the terms of the GNU General Public License as published by */
/* the Free Software Foundation; either version 2 of the License.       */
/************************************************************************/



function gpdb($gummipunkte, $username) {
global $prefix, $dbi, $user, $cookie;

      if ($username=="") {
         die();

      }
      $check = sql_query("select * from $prefix"._gummipunkte." where uname='$username'", $dbi);
      $checkit = sql_num_rows($check);
      
      if($checkit==0){
         $gpi = sql_query("INSERT INTO $prefix"._gummipunkte." (uname,punkte) VALUES ('$username','$gummipunkte')", $dbi);
      }
      if($checkit==1){
         $gpi = sql_query("update $prefix"._gummipunkte." set punkte='$gummipunkte' WHERE uname='$username'", $dbi);
      }
}

function gpcount($uname) {
   $cpunkte = gpcpunkte($uname);
   $ppunkte = gpppunkte($uname);
   $newpunkte = $cpunkte + $ppunkte;
   gpdb($newpunkte, $uname);
   return $newpunkte;

}


function gpcpunkte($uname) {
   global $prefix, $dbi, $gummipunkte, $user_prefix;
   $getuid = sql_query("select uid from $user_prefix"._users." where uname='$uname'", $dbi);
   list($uid) = sql_fetch_row($getuid, $dbi);

   $result = sql_query("select tid from $prefix"._comments." where name='$uname'", $dbi);
   $kommentare = sql_num_rows($result);
   $result = sql_query("select sid from $prefix"._stories." where informant='$uname'", $dbi);
   $artikel = sql_num_rows($result);
   $result = sql_query("select post_id from $prefix"._posts." where poster_id='$uid'", $dbi);
   $posts = sql_num_rows($result);
   $result = sql_query("select lid from $prefix"._links_links." where submitter='$uname'", $dbi);
   $links = sql_num_rows($result);
   $result = sql_query("select lid from $prefix"._downloads_downloads." where submitter='$uname'", $dbi);
   $downloads = sql_num_rows($result);
   $gummipunkte=($artikel*10)+($kommentare*5)+($posts*1)+($links*3)+($downloads*3);
   return $gummipunkte;
}

function gpppunkte($uname) {
global $prefix, $dbi;

   $getppunkte = sql_query("select ppunkte from $prefix"._gummipunkte." where uname='$uname'", $dbi);
   list($ppunkte) = sql_fetch_row($getppunkte, $dbi);
   return $ppunkte;
}

function topgp() {
global $cat, $language, $prefix, $dbi, $topg;
require_once("includes/gpconfig.php");
   $result = sql_query("select * from $prefix"._gummipunkte." WHERE active='0' ORDER by punkte DESC", $dbi);
   $numrows = sql_num_rows($result);
      if ($numrows == 0) {
         return;
      }
      else {
         $list = "<font size=\"2\"><b><center>Top $topg</center></b><br><div align=\"left\">";
         $i=1;
         if($topg > $numrows) {
                      $topg = $numrows;
         }
            while($i <= $topg) {         
               list($uname,$punkte) = sql_fetch_row($result, $dbi);
                  $name = $uname;
                  $list .="<b>$i.</b> <a href=\"modules.php?name=Your_Account&op=userinfo&uname=".$name."\">$name</a>, $punkte Punkte</b><br>";
                  $i++;
         
            }
            $list .="</div>";
      }
      return $list;
}


function gpdbedit($username, $punkte) {
global $prefix, $dbi;

   $check = sql_query("select * from $prefix"._gummipunkte." where uname='$username'", $dbi);
   $checkit = sql_num_rows($check);
   list($ppunkte) = sql_fetch_row($check, $dbi);

      if($checkit==1){
            $newpunkte = ($ppunkte + $punkte);
            $gpi = sql_query("update $prefix"._gummipunkte." set ppunkte='$newpunkte' WHERE uname='$username'", $dbi);
      }
      else {

         $return = "$username ist nicht angelegt!";

         return $return;

      }
}

?>

[Robert1968]

 $result = sql_query("select ratingdbid from $prefix"._downloads_votedata." where ratinguser='$uname'", $dbi);
    $downloads = sql_num_rows($result, $dbi);
    $result = sql_query("select tid from $prefix"._pollcomments." where name='$uname'", $dbi);
    $umfragen = sql_num_rows($result, $dbi);
    $result = sql_query("select ratingdbid from $prefix"._links_votedata." where ratinguser='$uname'", $dbi);
    $links = sql_num_rows($result, $dbi);
   
    $result = sql_query("select tid from $prefix"._comments." where name='$uname'", $dbi); #kommentare
    $kommentare=sql_num_rows($result, $dbi);
    $result = sql_query("select sid from $prefix"._stories." where informant='$uname'", $dbi); #artikel
    $artikel=sql_num_rows($result, $dbi);
   
    $resultx=sql_query("select uid from $prefix"._users." where uname='$uname'", $dbi);
    $gbu=sql_fetch_array($resultx, $dbi);
    $uid=$gbu["uid"];
   
    $result=sql_query("select id from $prefix"._reviews." where reviewer='$uname'", $dbi);
    $testbericht=sql_num_rows($result, $dbi);
    $result=sql_query("select cid from $prefix"._reviews_comments." where userid='$uname'", $dbi);
    $revcom=sql_num_rows($result, $dbi);
   
    $result=sql_query("select cid from $prefix"._links_links." where submitter='$uname'", $dbi);
    $linksubmit=sql_num_rows($result, $dbi);
    $result=sql_query("select cid from $prefix"._downloads_downloads." where submitter='$uname'", $dbi);
    $downsubmit=sql_num_rows($result, $dbi);        
   
    $result=sql_query("select pid from $prefix"._gallery_pictures." where submitter='$uname'", $dbi);        
    $galsubmit=sql_num_rows($result, $dbi);
             
    $resultguestb=sql_query("select name from $prefix"._nukebook." where name='$uname'", $dbi);
    $guestb = sql_num_rows($resultguestb, $dbi);    
                   
    $result= sql_query("select pid from $prefix"._xmb_posts." where author='$uname'", $dbi);
    $fposts=sql_num_rows($result, $dbi);
    $result= sql_query("select tid from $prefix"._xmb_threads." where author='$uname'", $dbi);
    $fthreads=sql_num_rows($result, $dbi);
   
   $gummipunkte=($artikel*10)+($kommentare*2)+($galsubmit*3)+($testbericht*5)+($downsubmit*3)+($linksubmit*3)+($revcom*2)+($fposts*2)+($fthreads*3)+($gb1*2)+($gb2*1)+($umfragen*2)+($downloads*2)+($links*2)+($guestb*2);
   return $gummipunkte;


das musst du alles eintragen
damit ist die Gallery,XForum,Uploads,Links,Uploadkomments und votes, Linkcomments und votes, Artikel und comments, Pollcomments, und testberichte abgedeckt

Jedoch muss die jemand anderes sagen was du für das Usergästebuch und das 'Gästebuch' verwenden musst da hab ich ein anderes am laufen und du musst diesen eintrag ändern!
Gruß

hab das ganze gerade mal versucht.

das xforum scheint nicht zu funktionieren ?!
obwohl der sql querry stimmen müsste