Hondaklubben

Kod: Markera allt

<?
guestbook = new Comment (DB_USERS_TABLE, DB_GUESTBOOKS_TABLE);
if (isset(_POST['savegb']))
{
    if (strlen(_POST['message']) > 4)
    {
     guestbook->set ('owner', _GET[user]);
        guestbook->set ('author', login->getUserId ());
     guestbook->set ('text', _POST [message]);
  guestbook->write ();
        unset(_POST['message']);
    }
    else
        get_error("Du måste minst skriva 5 tecken i ett inlägg!");
}

if (isset(_GET['remove']))
{
    guestbook->load(_GET['remove']);
    if (guestbook->get('author') == login->getUserId () || guestbook->get ('owner') == login->getUserId () || privs->ownPrivs (array (PRIV_GUESTBOOK_ALTER)))
        guestbook->delete (_GET['remove']);
}

if (isset(_GET['user']) && _GET['user'] != login->getUserId())
    uId = _GET['user'];
else
    uId = login->getUserId();

if (profile->load(uId))
{
    guestbook_load = guestbook->loadComments (uId);

    data = profile->load(uId);

    if (data->activated == Y)
    {
     include("pages/cm/tpl/guestbook_tpl.php");
     echo "<table width="100%" border="0" cellpadding="3" cellspacing="0">";
     if (!empty(guestbook_load[0]->text))
     {
         for (i = 0; i < count (guestbook_load); i++)
         {
             if (i%2)
                 bgcolor = "#DFE8FF";
             else
                 bgcolor = "#FFFFFF";

             modify_string = (login->getUserId () == guestbook_load [i] ->owner || login->getUserId () == guestbook_load[i]->author || privs->ownPrivs (array (PRIV_GUESTBOOK_ALTER))) ? '    <b>-></b> <a href="javascript:Confirm('Är du säker på att du vill ta bort inlägget?', 'index.php?page=cmgb&user=' . uId . '&remove=' . guestbook_load[i]->uid .'');">Ta bort</a>    <b>-></b> <a href="index.php?page=cmgb&user=' . guestbook_load [i] ->author . '">Besvara</a>' : '';

             data = profile->load(guestbook_load[i]->author);

             content = nl2br(htmlspecialchars (guestbook_load [i] ->text, ENT_QUOTES));
             footer = nl2br("skrivet av <a href="index.php?page=profile&user=" . guestbook_load[i]->author . "">" . htmlspecialchars(guestbook_load[i]->user_name, ENT_QUOTES) . "</a> ".data->sex.getAge(data->birthdate).", ".date ("j/n Y kl. H:i", guestbook_load[i]->unix_timestamp) . modify_string);

             if (i > 0)
             {
                 echo "
                 <tr>
                    <td><hr color="#666666" size="1"></td>
                 </tr>
                 ";
             }

             echo "
             <tr bgcolor="bgcolor">
                <td>content</td>
             </tr>
             <tr bgcolor="bgcolor">
                <td height="5"></td>
             </tr>
             <tr bgcolor="bgcolor">
                <td>footer</td>
             </tr>
             ";
         }
     }
     else
     {
         echo "
         <tr>
            <td height="15"></td>
         </tr>
         <tr>
            <td align="center"><b>data->user_name har inte fått några gästboksinlägg ännu =(</b></td>
         </tr>
         ";
     }
     echo "</table>";
     include("pages/cm/tpl/bottom_tpl.php");
    }
    else
    {
     cmErrTop = "Ett fel inträffade när sidan laddades";
     cmErrText = "Användaren du söker har blivit avstängd!";
     include("pages/cm/error.php");
    }
}
else
{
    cmErrTop = "Ett fel inträffade när sidan laddades";
    cmErrText = "Användaren du söker finns ej i vår medlemsdatabas!";
    include("pages/cm/error.php");
}
?>

Kod: Markera allt

<?php

require_once "db_mysql.class.php";

class Comment
{

    var _dbConn;

    var _dbCommentsTable;

    var _dbUsersTable;

    var _comment;

    function Comment (dbUsersTable, dbCommentsTable)
    {
        this->_dbConn = &DbResource::instance ();
        this->_dbUsersTable = dbUsersTable;
        this->_dbCommentsTable = dbCommentsTable;
    }

    function load (uid)
    {
        if (this->_comment = this->_dbConn->getRow ("SELECT a.*,UNIX_TIMESTAMP(a.`timestamp`) AS `unix_timestamp`,b.`user_name` FROM `" . this->_dbCommentsTable . "` a,`" . this->_dbUsersTable . "` b WHERE a.`author`=b.`uid` AND a.`uid`='" . uid . "' LIMIT 0,1")) {
            return true;
        }
        return false;
    }

    function write ()
    {
        if (this->_dbConn->query ("INSERT INTO `" . this->_dbCommentsTable . "` (`uid`, `timestamp`, `owner`, `author`,`header`, `text`, `ip`) VALUES ('" . md5_uniqid () . "', NOW(), '" . this->_comment->owner . "', '" . this->_comment->author . "', '" . this->_comment->header . "','" . this->_comment->text . "','" . getenv("REMOTE_ADDR") . "')")) {
            return true;
        }
        return false;
    }

    function update (uid)
    {
        if (this->_dbConn->query ("UPDATE `journal` SET `header`='" . this->_comment->header . "',`text`='" . this->_comment->text . "' WHERE `uid`='" . uid . "' LIMIT 1")) {
            return false;
        }
        return false;
    }

    function delete (uid)
    {
        if (this->_dbConn->query ("UPDATE `". this->_dbCommentsTable ."` SET `deleted`='1' WHERE `uid`='" . uid . "' LIMIT 1")) {
            return false;
        }
        return false;
    }

    function loadComments (owner_uid)
    {
        if (result = this->_dbConn->getResults ("SELECT a.`uid`,UNIX_TIMESTAMP(a.`timestamp`) AS `unix_timestamp`,a.`owner`,a.`author`,b.`user_name`,a.`header`,a.`text` FROM `" . this->_dbCommentsTable . "` a,`" . this->_dbUsersTable . "` b WHERE a.`owner`='" . owner_uid . "' AND a.`author`=b.`uid` AND deleted != '1' ORDER BY a.`id`  DESC")) {
            return result;
        }
        return false;
    }

    function set (param, value)
    {
        this->_comment->param = value;
        return true;
    }

    function get (param)
    {
        return this->_comment->param;
    }

    function countComments (owner_uid)
    {
        if (result = this->_dbConn->getRow ("SELECT COUNT(`id`) AS `count` FROM `" . this->_dbCommentsTable . "` WHERE `owner`='" . owner_uid . "' LIMIT 0,1")) {
            return result->count;
        }
        return false;
    }

    function countWrittenByUid (uid)
    {
        if (result = this->_dbConn->getRow ("SELECT COUNT(`id`) AS `count` FROM `" . this->_dbCommentsTable . "` WHERE `author`='" . uid . "' LIMIT 0,1")) {
            return result->count;
        }
        return false;
    }

}

?>

Kod: Markera allt

<? static l = 1; // SIDAN
res_per_page = 50; // ANTALET SIDOR ?>

  <? 
  
    res =& DBConn->query("SELECT * FROM MINTABELL");} 
    if (PEAR::isError(res)) {die(res->getMessage());}
  // to make sure where you are in the documents (wich page)
  
  if( !isset(_GET['page'])){ // gör ingenting } // FINNS INGEN SIDA, därför blir sidan till sida 1.
  else {l = _GET['page'];}  // vi tilldelar l sidan som användaren har valt i get.
  echo(res->numRows(). " document(s) found <br>"); // valfritt (
  
  if(res->numRows() > res_per_page) // antalet träffar får inte plats.
  //anledningen till att jag kör prevnext här är att jag vill skriva ut knapparna innan innehållet.
  {prevnext(l, letters,next, res);} // så kör vi metoden prevnext.
  
  if(res->numRows() < res_per_page) // vi får plats och då kör vi som vanligt.
  {
      while( res->fetchInto(row) ) 
      {
    echo("<div id="post">n");
          
          echo("<h3>" . row['RUBRIK'] . "</h3>");
          echo("brödtext kanske :" . row['cusname'] . "</a></p></li>n");
          //och så fortsätter du vräka på med det du vill ha här.
        }
    echo("</div>");
      }
      else
      {
    from = 0;
    from = (l - 1) * res_per_page;
    to = from + res_per_page;
    foreach(range(from, to) as rownum)   // vår range, dvs inom vilket intervall som skall tittas på.
    {
        if (!row = res->fetchrow(fetchmode, rownum)) // as long as we have rows left we continue to carry them out.
        {break;}
        
      echo("<h3>" . row['RUBRIK'] . "</h3>");
      echo("brödtext kanske :" . row['cusname'] . "</a></p></li>n");
      //och så fortsätter du vräka på med det du vill ha här.
      //varning, det KAN bli så att du är tvungen att ange row[0] för första kolumnen istället för row[id] som ofta är första kolumnen.
      // alltså echo("<h3>" . row['3'] . "</h3>"); om RUBRIK är kolumn3.
    }
      }
      
      
    
      // a function in order to display previous and nextbuttons
      function prevnext(l, letters, next, res)
      {
      
      if(l > 1)
        {
      prev = l - 1;
      echo('<p><a href="?st=guestbook.inc&page='. prev .'">previous '. res_per_page .'</a>'); //st är alltså parametern på att det är den här sidan som skall hämtas.
        }
        else 
        {echo('<p>previous '. res_per_page );}
        echo("nnnn");
        next = l + 1;
        if(res->numrows() > to ){echo('<a href="?st=guestbook.inc&page='. next .'&letters='. letters .'">next '. res_per_page .'</a></p>');}
        else {echo'next '. res_per_page .'</p>';}
        
      }

?>

Kod: Markera allt

   guestbook_load = guestbook->loadComments (uId);

Kod: Markera allt

   guestbook_load = guestbook->loadComments (uId, _GET['offset']);

Kod: Markera allt

   function loadComments (owner_uid)
   {
       if (result = this->_dbConn->getResults ("SELECT a.`uid`,UNIX_TIMESTAMP(a.`timestamp`) AS `unix_timestamp`,a.`owner`,a.`author`,b.`user_name`,a.`header`,a.`text` FROM `" . this->_dbCommentsTable . "` a,`" . this->_dbUsersTable . "` b WHERE a.`owner`='" . owner_uid . "' AND a.`author`=b.`uid` AND deleted != '1' ORDER BY a.`id`  DESC")) {
           return result;
       }
       return false;
   }

Kod: Markera allt

   function loadComments (owner_uid, offset=0)
   {
       offset = addslashes(offset);
       if (result = this->_dbConn->getResults ("SELECT a.`uid`,UNIX_TIMESTAMP(a.`timestamp`) AS `unix_timestamp`,a.`owner`,a.`author`,b.`user_name`,a.`header`,a.`text` FROM `" . this->_dbCommentsTable . "` a,`" . this->_dbUsersTable . "` b WHERE a.`owner`='" . owner_uid . "' AND a.`author`=b.`uid` AND deleted != '1' ORDER BY a.`id`  DESC LIMIT 'offset', 30")) {
           return result;
       }
       return false;
   }