Avatar billede sux Nybegynder
09. januar 2002 - 16:40 Der er 12 kommentarer og
1 løsning

Hjælp til lille udviddelse af Phorum script!!

Det er garanteret ikke så svært for den hard core ekspert, men er der nogen her som kender Phorum (version 3.3.2) og / eller som kan fortælle mig, hvordan man laver det sådan, at man kan se antallet af indlæg for en registreret bruger ved de indlæg vedkommendes deltager i? (dvs read.php)

Scriptet til at vise antallet af indlæg for en registreret bruger ligger allerede i vedkommendes profil (dvs. profile.php), men jeg vil ogso gerne have det stående på indlægssiden som nævnt - og jeg kan ikke overskue flytningen selv?
Avatar billede sux Nybegynder
09. januar 2002 - 16:55 #1
Phorum er en stor djævel
Avatar billede budda Nybegynder
09. januar 2002 - 19:49 #2
Det er jo bare at lave en
$antalringetoner = mysql_query(\"SELECT COUNT(*) AS total FROM users WHERE id LIKE \'$id\'\") or die(mysql_error());
echo \"Antal indlæg : \".mysql_result($antalringetoner,0).\" \";
Avatar billede sux Nybegynder
09. januar 2002 - 19:50 #3
Ehh - mener du det??

En joke?

Vil du ikke forklare nærmere?
Avatar billede sux Nybegynder
09. januar 2002 - 19:53 #4
Så ovenstående kan bare smækkes ind i read.php ??
Kender den godt: \'$id\' ??
Avatar billede sux Nybegynder
09. januar 2002 - 20:36 #5
Okay her kommer den.
Der hvor scriptet skal ind er markeret med:

// DET ER HER DET SKER
// DET ER HER DET SKER
// DET ER HER DET SKER

<?php
////////////////////////////////////////////////////////////////////////////////
//                                                                            //
//  Copyright (C) 2000  Phorum Development Team                              //
//  http://www.phorum.org                                                    //
//                                                                            //
//  This program is free software. You can redistribute it and/or modify    //
//  it under the terms of either the current Phorum License (viewable at    //
//  phorum.org) or the Phorum License that was distributed with this file    //
//                                                                            //
//  This program is distributed in the hope that it will be useful,          //
//  but WITHOUT ANY WARRANTY, without even the implied warranty of          //
//  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.                    //
//                                                                            //
//  You should have received a copy of the Phorum License                    //
//  along with this program.                                                //
////////////////////////////////////////////////////////////////////////////////
// $Id: read.php,v 1.78 2001/12/17 23:53:50 ts77 Exp $
 
  $read=true;

  require \"./common.php\";
  require \"$include_path/read_functions.php\";

  $thread=(int)initvar(\"t\");
  $action=(int)initvar(\"a\");
  $id=(int)initvar(\"i\");

  if(isset($v)) $v==\'f\' ? $flat=1 : $flat=0;

  if($num==0 || $ForumName==\'\'){
    Header(\"Location: $forum_page.$ext?$GetVars\");
    exit;
  }
  if(empty($id) && empty($action)){
    Header(\"Location: $list_page.$ext?f=$num$GetVars\");
    exit;
  }

  $phcollapse=\"phorum-collapse-$ForumTableName\";
  $phflat=\"phorum-flat-$ForumTableName\";
  $new_cookie=\"phorum-new-$ForumTableName\";
  $haveread_cookie=\"phorum-haveread-$ForumTableName\";

  if($UseCookies){

    if(IsSet($flat)){
      $$phflat=$flat;
      SetCookie(\"phorum-flat-$ForumTableName\",$flat,time()+ 31536000);
    }
    elseif(!isset($$phflat)){
      $$phflat=$ForumFlat;
    }

    if(!IsSet($$new_cookie)){
      $$new_cookie=\'0\';
    }

    $use_haveread=false;
    if(IsSet($$haveread_cookie)) {
      $arr=explode(\".\", $$haveread_cookie);
      $old_message=@reset($arr);
      array_walk($arr, \"explode_haveread\");
      $use_haveread=true;
    }
    else{
      $old_message=$$new_cookie;
    }

  }
  else{
    if(IsSet($flat)){
      $$phflat=$flat;
    }
    else{
      $$phflat=$ForumFlat;
    }
    if(IsSet($collapse)){
      $$phcollapse=$collapse;
    }
    else{
      $$phcollapse=$ForumCollapse;
    }
  }

  if(initvar(\"admview\")!=1) {
    $limitApproved=\" and approved=\'Y\'\";
  } else {
    $limitApproved=\"\";
  }

  if($action!=0 && ($action==1 || $action==2)){

    if($DB->type==\"sybase\") {
      $limit=\"\";
      $q->query($DB, \"set rowcount $ForumDisplay\");
    }
    elseif($DB->type==\"postgresql\"){
      $limit=\"\";
      $q->query($DB, \"set QUERY_LIMIT TO 1\");
    }
    else{
      $limit=\" limit 1\";
    }
    if ($ForumMultiLevel==2){
        $SQL = \"Select modifystamp from $ForumTableName where thread=$thread $limitApproved $limit\";
        $q->query($DB,$SQL);
        $thms=$q->field(\"modifystamp\", 0);
    }
    switch($action){
      case 2:
        $cutoff_thread=$thread-$cutoff;
        if ($ForumMultiLevel==2){
            $sSQL=\"Select thread, id from $ForumTableName where modifystamp < $thms $limitApproved order by modifystamp desc $limit\";
        } else {
            $sSQL=\"Select thread, id from $ForumTableName where thread<$thread and thread>$cutoff_thread and id=thread $limitApproved order by thread desc $limit\";
        }
        break;
      case 1:
        $cutoff_thread=$thread+$cutoff;
        if ($ForumMultiLevel==2){
            $sSQL=\"select thread, id from $ForumTableName where modifystamp>$thms $limitApproved order by modifystamp $limit\";
        } else {
            $sSQL=\"Select thread, id from $ForumTableName where thread<$cutoff_thread and thread>$thread and id=thread $limitApproved order by thread asc $limit\";
        }
        break;
    }

    $msg = new query($DB, $sSQL);


    if($DB->type==\"postgresql\"){
      $q->query($DB, \"set QUERY_LIMIT TO \'0\'\");
    }

    if($msg->numrows()==0){
      Header(\"Location: $list_page.$ext?f=$num$GetVars\");
      exit;
    }

    $tres=$msg->getrow();
    Header(\"Location: $read_page.$ext?f=$num&i=$tres[id]&t=$tres[thread]$GetVars\");
    exit();

  }

  $sSQL = \"Select * from $ForumTableName where thread=$thread $limitApproved order by id\";

  $msg_list = new query($DB, $sSQL);

  $rec=$msg_list->getrow();
  $x=0;
  While(is_array($rec)){
    $headers[]=$rec;
    if($rec[\"id\"]==$id) $loc=$x;
    if($ForumSecurity!=SEC_NONE && $rec[\"userid\"]>0) $ids[]=$rec[\"userid\"];
    $rec=$msg_list->getrow();
    $x++;
  }

  // Get the user info.  I curse PG for not having Left Joins.
  if(@is_array($ids)){

    $SQL=\"select id, name, email, signature from $pho_main\".\"_auth where id in (\".implode(\",\", $ids).\")\";
    $q->query($DB, $SQL);
    $rec=$q->getrow();
    While(is_array($rec)){
      $users[$rec[\"id\"]]=$rec;
      $rec=$q->getrow();
    }

    $SQL=\"select user_id from $pho_main\".\"_moderators where forum_id=$f or forum_id=0 and user_id in (\".implode(\",\", $ids).\")\";
    $q->query($DB, $SQL);
    $rec=$q->getrow();
    While(is_array($rec)){
      $moderators[$rec[\"user_id\"]]=true;
      $rec=$q->getrow();
    }

  }

  if ($$phflat) {
    $sSQL = \"SELECT $ForumTableName.id AS id, $ForumTableName.thread AS thread, body from $ForumTableName, \".$ForumTableName.\"_bodies WHERE $ForumTableName.approved = \'Y\' AND $ForumTableName.thread = \".$thread.\" AND $ForumTableName.id = \".$ForumTableName.\"_bodies.id ORDER BY id\";
  } else {
    $sSQL = \"Select * from $ForumTableName\".\"_bodies where id=\".$id;
  }

  $msg_body = new query($DB, $sSQL);

  $rec=$msg_body->getrow();
  While(is_array($rec)){
    $bodies[]=$rec;
    $rec=$msg_body->getrow();
  }

  $msg_body->free();

  $header_rows=count($headers);
  $body_rows=count($bodies);

  $next_thread = \"f=$num&t=$thread&a=2$GetVars\";
  $prev_thread = \"f=$num&t=$thread&a=1$GetVars\";

  if(!$$phflat){

    if($loc+1==$header_rows){
      $next_link = $next_thread;
    }
    else{
      $next_loc = $loc+1;
      $next_id = $headers[$next_loc][\"id\"];
      $next_link = \"f=$num&i=$next_id&t=$thread$GetVars\";
    }

    if($loc==0){
      $prev_link = $prev_thread;
    }
    else{
      $prev_loc = $loc-1;
      $prev_id = $headers[$prev_loc][\"id\"];
      $prev_link = \"f=$num&i=$prev_id&t=$thread$GetVars\";
    }

    if(empty($haveread[$id]) && $UseCookies && $id > $old_message){
      if(empty($$haveread_cookie)){
        $haveread[$$new_cookie] = true;
        $$haveread_cookie=$$new_cookie;
      }
      $$haveread_cookie.=\".\";
      $$haveread_cookie.=\"$id\";
      $haveread[$id] = true;
      SetCookie(\"phorum-haveread-$ForumTableName\",$$haveread_cookie,0);
    }

    $max_id=$id;
  }
  else{
    $prev_link=$prev_thread;
    $next_link=$next_thread;
    $lNextMessage=$lNextTopic;
    $lPreviousMessage=$lPreviousTopic;
    if($UseCookies){
      $madechange=false;
      @reset($headers);
      $row=@current($headers);
      while(!empty($row[\"id\"])){
        if(empty($haveread[$row[\"id\"]]) && $row[\"id\"] > $old_message){
          $madechange=true;
          if(empty($$haveread_cookie)){
            $haveread[$$new_cookie] = true;
            $$haveread_cookie=$$new_cookie;
          }
          $$haveread_cookie.=\".\";
          $$haveread_cookie.=$row[\"id\"];
        }
        $haveread[$row[\"id\"]] = true;
        $max_id=$row[\"id\"];
        $row=next($headers);
      }
      if ($madechange) {
        SetCookie($haveread_cookie,$$haveread_cookie,0);
      }
    }
  }

  if($UseCookies){
    if($$new_cookie<$max_id){
      $$new_cookie=$max_id;
      SetCookie($new_cookie,$$new_cookie,time()+ 31536000);
    }
  }

  $subject = chop($headers[$loc][\"subject\"]);

  $rawsub=ereg_replace(\"</*b>\", \"\", $subject);
  $title = \" - \".$rawsub;

  include phorum_get_file_name(\"header\");

  $toThread = $thread + 1;

//////////////////////////
  // START NAVIGATION    //
  //////////////////////////

    $menu=array();

    if(!$$phflat)
      addnav($menu2, $lReplyMessage, \"$read_page.$ext?f=$f&i=$id&t=$t$GetVars#REPLY\");

    if($ActiveForums>1)
      // Forum List
      addnav($menu2, $lForumList, \"$forum_page.$ext?f=$ForumParent$GetVars\");
    // New Topic
    addnav($menu1, $lStartTopic, \"$post_page.$ext?f=$num$GetVars\");
    // Go To Top
    addnav($menu1, $lGoToTop, \"$list_page.$ext?f=$num$GetVars\");
    // Go To Topic
    if ($ForumMultiLevel==2) {
      // Float to Top
      addnav($menu1, $lGoToTopic, \"$list_page.$ext?f=$num&t=\".$headers[0][\"modifystamp\"].\"&a=3$GetVars\");
    } else {
      addnav($menu1, $lGoToTopic, \"$list_page.$ext?f=$num&t=$toThread&a=3$GetVars\");
    }
    if($$phflat==0){
      // Flat View
      addnav($menu2, $lReadFlat, \"$read_page.$ext?f=$num&i=$id&t=$thread&v=f$GetVars\");
    } else {
      // Threaded View
      addnav($menu2, $lReadThreads, \"$read_page.$ext?f=$num&i=$id&t=$thread&v=t$GetVars\");
    }
    // Search
    addnav($menu1, $lSearch, \"$search_page.$ext?f=$num$GetVars\");

    // Log Out/Log In
    if($ForumSecurity){
      if(!empty($phorum_auth)){
        addnav($menu2, $lLogOut, \"login.$ext?logout=1$GetVars\");
        addnav($menu2, $lMyProfile, \"profile.$ext?f=$f&id=$phorum_user[id]$GetVars\");
      }
      else{
        addnav($menu1, $lLogIn, \"login.$ext?f=$num$GetVars\");
      }
    }

    $TopLeftNav=getnav($menu1);
    $LowLeftNav=getnav($menu2);

    $menu=array();
    // Prev Thread
    addnav($menu, $lPreviousTopic, \"$read_page.$ext?$prev_thread$GetVars\");
    // Next Thread
    addnav($menu, $lNextTopic, \"$read_page.$ext?$next_thread$GetVars\");

    $ThreadNav=getnav($menu);

    $menu=array();
    // Previous Message
    addnav($menu, $lPreviousMessage, \"$read_page.$ext?$prev_link\");
    // Next Message
    addnav($menu, $lNextMessage, \"$read_page.$ext?$next_link\");

    $MessageNav=getnav($menu);

  //////////////////////////
  // END NAVIGATION      //
  //////////////////////////

?>
<script language=\"JavaScript\" type=\"text/javascript\">

function delmsg(url){
ans=window.confirm(\"<?php echo $lDelMessageWarning; ?>\");
  if(ans){
    window.location.replace(url);
  }
}
</script>
<table width=\"<?php echo $ForumTableWidth; ?>\" cellspacing=\"0\" cellpadding=\"3\" border=\"0\">
<tr>
    <td width=\"100%\" align=\"left\" <?php echo bgcolor($ForumNavColor); ?>><?php echo $TopLeftNav; ?></td>
    <td nowrap align=\"right\" <?php echo bgcolor($ForumNavColor); ?>><?php echo $MessageNav; ?></tr>
</table>
<?php if ($header_rows==0 || $body_rows==0) { ?>
<table class=\"PhorumListTable\" width=\"<?php echo $ForumTableWidth; ?>\" cellspacing=\"0\" cellpadding=\"2\" border=\"0\">
<tr>
    <td <?php echo bgcolor($ForumTableHeaderColor); ?>><FONT color=\"<?php echo $ForumTableHeaderFontColor; ?>\">&nbsp;<?php echo $lViolationTitle; ?></font></td>
</tr>
<tr>
    <td <?php echo bgcolor($ForumTableBodyColor2); ?> valign=\"TOP\"><table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\">
<tr>
    <td <?php echo bgcolor($ForumTableBodyColor2); ?> width=\"100%\" valign=\"top\"><font color=\"<?php echo $ForumTableBodyFontColor2; ?>\"><?php echo $lNotFound; ?></td>
</tr>
</table>
</td>
</tr>
</table>

<?php }else{
  @reset($headers);
  @reset($bodies);
  $head_row=@current($headers);
  $body_row=@current($bodies);
  while(is_array($head_row) && is_array($body_row)){
    if($head_row[\"id\"]==$body_row[\"id\"]){

      $rec_id=$head_row[\"id\"];
      $subject = chop($head_row[\"subject\"]);
      $datestamp = date_format($head_row[\"datestamp\"]);
      $body = $body_row[\"body\"];
      $host=\"\";
      $profile_link=\"\";
      $reply_url=\"$read_page.$ext?f=$f&i=$rec_id&t=$t$GetVars#REPLY\";

      if($head_row[\"userid\"]>0 && isset($users[$head_row[\"userid\"]])){
        $user=$users[$head_row[\"userid\"]];
        $author=$qauthor=$user[\"name\"];
        $email=$user[\"email\"];
        $host=\"\";





// DET ER HER DET SKER
// DET ER HER DET SKER
// DET ER HER DET SKER





        $author = \"<a href=\\\"$forum_url/profile.$ext?f=$ForumId&id=$head_row[userid]$GetVars\\\" title=\\\"Tjek profilen\\\">$author</a> S K A L    I N D  H E R \";
        //uthor .= (empty($phorum_user[\"moderator\"])) ? $lMember : $lModerator;
        // replace sig

        if(strstr($body, PHORUM_SIG_MARKER)){
          $body=str_replace(PHORUM_SIG_MARKER, $user[\"signature\"], $body);
        }
      }
      else{
        $author=$qauthor=chop($head_row[\"author\"]);
        $email = chop($head_row[\"email\"]);
        if($email!=\"\"){
          $author = \"<a href=\\\"mailto:\".htmlencode($email).\"?subject=$rawsub\\\">$author</a>\";
        }
        $host=\"\";
      }
      if($head_row[\"id\"]==$i){
          $qauthor=ereg_replace(\"<b>|</b>\", \"\", $qauthor);
          $qsubject=ereg_replace(\"<b>|</b>\", \"\", $subject);
      }
?>
<a name=\"reply_<?php echo $head_row[\"id\"]; ?>\"></a>
<table class=\"PhorumListTable\" width=\"<?php echo $ForumTableWidth; ?>\" cellspacing=\"0\" cellpadding=\"2\" border=\"0\">
<tr>
    <td <?php echo bgcolor($ForumTableHeaderColor); ?>><FONT size=\"3\" face=\"Arial, Helvetica, sans-serif\" class=\"PhorumTableHeader\" color=\"<?php echo $ForumTableHeaderFontColor; ?>\"><b>&nbsp;<?php echo $subject; ?></b></font></td>
</tr>
<tr>
    <td <?php echo bgcolor($ForumTableBodyColor2); ?> valign=\"TOP\"><table width=\"100%\" cellspacing=\"0\" cellpadding=\"5\" border=\"0\">
<tr>
    <td <?php echo bgcolor($ForumTableBodyColor2); ?> width=\"100%\" valign=\"top\"><font class=\"PhorumMessage\" color=\"<?php echo $ForumTableBodyFontColor2; ?>\">
<?php echo $lAuthor;?>:&nbsp;<?php echo $author; ?>&nbsp;<?php echo $host; ?><br>
<?php echo $lDate;?>:&nbsp;&nbsp;&nbsp;<?php echo $datestamp; ?><br>
<?php

    // exec read_header plugins
    @reset($plugins[\"read_header\"]);
    while(list($key,$val) = each($plugins[\"read_header\"])) {
      $val($rec_id);
    }

    if ($AllowAttachments && $ForumAllowUploads == \'Y\') {
      $SQL=\"Select id, filename from $ForumTableName\".\"_attachments where message_id=$rec_id\";
      $q->query($DB, $SQL);
      while($rec=$q->getrow()){
        $filename=\"$AttachmentDir/$ForumTableName/$rec_id\".\"_$rec[id]\".strtolower(strrchr($rec[\"filename\"], \".\"));
        $size=filesize($filename);
        if($size<1024) $size=1024;
        $size=round($size/1024).\"k\";
        echo \"$lFormAttachment:&nbsp; <a href=\\\"$forum_url/download.$ext/$num,$rec_id,$rec[id]/$rec[filename]\\\">$rec[filename]</A> ($size)</font><BR>\\n\";
      }
    }
    echo \'<br>\';

    $qbody=$body;

    $body=format_body($body);
?>
<font face=\"Courier New, Courier, mono\"  class=\"PhorumMessage\" ><?php echo $body; ?></font><p>
</td>
</tr>
</table>
</td>
</tr>
<?php if(!$$phflat){ ?>
<?php if(!empty($phorum_user[\"moderator\"])){ ?>
<tr>
<td valign=\"TOP\" width=\"100%\" align=\"RIGHT\" <?php echo bgcolor($ForumTableBodyColor2); ?>>
<table>
<tr>
<td valign=\"TOP\" width=\"100%\" align=\"LEFT\" <?php echo bgcolor($ForumTableBodyColor2); ?>>
<FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lModerators; ?></font>
<br><?php echo \"<a href=\\\"$forum_url/moderator.$ext?mod=edit&f=$ForumId&i=$id&t=$thread$GetVars\\\">\";?><FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lModEdit; ?></a></font>
<br><a href=\"java script:delmsg(\'<?php echo \"$forum_url/moderator.$ext?mod=delete&f=$ForumId&i=$rec_id&t=$thread$GetVars\";?>\')\"><FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lModDelete; ?></a></font>
</td>
</tr>
</table>
</td>
</tr>
<?php } // if($phorum_user ...
?>
</table>
<table width=\"<?php echo $ForumTableWidth; ?>\" cellspacing=\"0\" cellpadding=\"3\" border=\"0\">
<tr>
    <td valign=\"TOP\" width=100% <?php echo bgcolor($ForumNavColor); ?>><a href=\"<?php echo $reply_url; ?>\"><FONT color=\'<?php echo $ForumNavFontColor; ?>\' class=\"PhorumNav\"><?php echo $LowLeftNav; ?></font></a></td>
    <td valign=\"TOP\" align=\"RIGHT\" nowrap <?php echo bgcolor($ForumNavColor); ?>><?php echo $ThreadNav; ?></td>
</tr>
</table>
<p>
<?php }else{ ?>
<tr>
    <td valign=\"TOP\" width=\"100%\" align=\"RIGHT\" <?php echo bgcolor($ForumTableBodyColor2); ?>><a href=\"<?php echo $reply_url; ?>\"><FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lReplyMessage; ?></a></font><br>
<?php if(!empty($phorum_user[\"moderator\"])){ ?>
<table>
<tr>
<td valign=\"TOP\" width=\"100%\" align=\"LEFT\" <?php echo bgcolor($ForumTableBodyColor2); ?>>
<FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lModerators; ?></font>
<br><?php echo \"<a href=\\\"$forum_url/moderator.$ext?mod=edit&f=$ForumId&i=$rec_id&t=$thread$GetVars\\\">\";?><FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lModEdit; ?></a></font>
<br><a href=\"java script:delmsg(\'<?php echo \"$forum_url/moderator.$ext?mod=delete&f=$ForumId&i=$rec_id&t=$thread$GetVars\";?>\')\"><FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\"><?php echo $lModDelete; ?></a></font>
</td>
</tr>
</table>
<?php } // if($phorum_user ...
?>
</td>
</tr>
</table>
<?php } ?>
<?php
      $body_row=next($bodies);
      if(is_array($body_row)){
?>
<table width=\"<?php echo $ForumTableWidth; ?>\" cellspacing=\"0\" cellpadding=\"0\" border=\"0\">
<tr>
    <td width=\"100%\"><FONT color=\'<?php echo $ForumTableBodyFontColor1; ?>\' class=\"PhorumNav\">&nbsp;</font></td>
</tr>
</table>
<?php
      }
    }
    $head_row=next($headers);
  }
?>
<?php
  if(!$$phflat){
    if(!$ForumMultiLevel){
      include \"$include_path/threads.php\";
    }
    else{
      include \"$include_path/multi-threads.php\";
    }
  }
  else{
?>
<table width=\"<?php echo $ForumTableWidth; ?>\" cellspacing=\"0\" cellpadding=\"3\" border=\"0\">
<tr>
    <td width=\"100%\" align=\"left\" <?php echo bgcolor($ForumNavColor); ?>><?php echo $LowLeftNav; ?></td>
    <td nowrap align=\"right\" <?php echo bgcolor($ForumNavColor); ?>><?php echo $MessageNav; ?></tr>
</table>
<?php
    unset($TopLeftNav);
  }
  unset($author);
  unset($email);
  unset($subject);
?>
<a name=\"REPLY\"></a>
<br /><br />
<?php
}
    require \"$include_path/form.php\";
    include phorum_get_file_name(\"footer\");
?>
Avatar billede sux Nybegynder
09. januar 2002 - 20:37 #6
Gider du hjælpe ?
Avatar billede sux Nybegynder
09. januar 2002 - 20:50 #7
Før at jeg selv kan gøre noget må jeg jo lige vide hvad funktionen gør:

mysql_query(\"SELECT COUNT(*) AS total FROM fora_1 WHERE id LIKE \'$userid\'\") or die(mysql_error());

Før er det meget svært at bruge det til noget - med mindre der vil hjælpe
Avatar billede budda Nybegynder
09. januar 2002 - 21:11 #8
$id
er brugeren id
Avatar billede budda Nybegynder
09. januar 2002 - 21:12 #9
Den tæller antal indlæg i fora_1 hvor brugerid er det samme som $userid
Avatar billede gimmy Nybegynder
09. januar 2002 - 21:30 #10
du skal vel først connecte til mysql og vælge db. Derefter skal du lave en forespørgsel hvor du hiver de(t) date ud du ønsker.
Dette kunne godt være noget i stil med hvad budda skriver, men det skal selvfølgelig tilpasses din db-struktur.
Du skal lave en query (forespørgsel) som den budda angiver, men hvorfor ikke bruge = i stedet for LIKE?

SELECT COUNT(*) AS antal_for_den_enkelte_bruger FROM tabelnavn WHERE id = $variabel_der_indeholder_bruger_id_svarende_til_den_i_databasen
  - det er vist lidt mere forklarende ;)
Avatar billede sux Nybegynder
09. januar 2002 - 22:53 #11
Takker for hjælpen - fandt ud af det ...
Avatar billede sux Nybegynder
09. januar 2002 - 23:09 #12
Dette blev mine endelige løsning:

$antal_indlaeg = mysql_query(\"SELECT COUNT(userid) AS total FROM fora_1 WHERE userid = \'$head_row[userid]\' \") or die(mysql_error());

Er det ikke det bedste ?
Avatar billede budda Nybegynder
10. januar 2002 - 19:31 #13
Det er OK!
Jeg ville nok count(*)
Avatar billede Ny bruger Nybegynder

Din løsning...

Tilladte BB-code-tags: [b]fed[/b] [i]kursiv[/i] [u]understreget[/u] Web- og emailadresser omdannes automatisk til links. Der sættes "nofollow" på alle links.

Loading billede Opret Preview
Kategori
Vi tilbyder markedets bedste kurser inden for webudvikling

Log ind eller opret profil

Hov!

For at kunne deltage på Computerworld Eksperten skal du være logget ind.

Det er heldigvis nemt at oprette en bruger: Det tager to minutter og du kan vælge at bruge enten e-mail, Facebook eller Google som login.

Du kan også logge ind via nedenstående tjenester