Pagina 1 din 2

[Tutorial Top 10-20 posturi pagina externa

Scris: 22-Sep-2012, 18:57:58
de Gotyc
Author: Stefan
Prima data editam:

Cod: Selectaţi tot

  // Cate topicuri sa apara?
$topicnumber =10;

Cod: Selectaţi tot

   // Calea catre forum
 $urlPath = "./forum/";

Cod: Selectaţi tot

   // Unde se afla configul ?
include './forum/config.php';

Cod: Selectaţi tot

<?php

    // Cate topicuri sa apara?
    $topicnumber =10;
    // Calea catre forum
    $urlPath = "./forum/";

    // Unde se afla configul ?
    include './forum/config.php';

    $table_topics = $table_prefix. "topics";
    $table_forums = $table_prefix. "forums";
    $table_posts = $table_prefix. "posts";
    $table_users = $table_prefix. "users";
    $link = mysql_connect("$dbhost", "$dbuser", "$dbpasswd") or die("Could not connect");
    mysql_select_db("$dbname") or die("Could not select database");

    $query = "SELECT t.topic_id, t.topic_title, t.topic_last_post_id, t.forum_id, p.post_id, p.poster_id, p.post_time, u.user_id, u.username
    FROM $table_topics t, $table_forums f, $table_posts p, $table_users u
    WHERE t.topic_id = p.topic_id AND
    f.forum_id = t.forum_id AND
    t.forum_id != 4 AND
    t.topic_status <> 2 AND
    p.post_id = t.topic_last_post_id AND
    p.poster_id = u.user_id
    ORDER BY p.post_time DESC LIMIT $topicnumber";
    $result = mysql_query($query) or die("Query failed");                           
 ?>
<table class="table table-condensed">
  <thead>
<tr class="text-warning">
<td> Topic </td>
<td> Nume     </td>

</tr>
</thead>
<tbody> 


    <?
    while ($row = mysql_fetch_array($result, MYSQL_ASSOC)) {
if(strlen($row["topic_title"])>12)
{
$topic = "".substr($row["topic_title"],0,12)."..";
}
else
{
$topic = $row["topic_title"];
}

$date =  date('d-m, g:i', $row["post_time"]);
if(strlen($date)>12)
{
$data= "".substr($date,0,12)."..";
}
else
{
$data = $date;
}

if(strlen($row["username"])>9)
{
$nume = "".substr($row["username"],0,9)."..";
}
else
{
$nume = $row["username"];
}

    echo  "<tr><td><a href='$urlPath/viewtopic.php?f=$row[forum_id]&t=$row[topic_id]&p=$row[post_id]#p$row[post_id]' TARGET='_blank'>".$topic.
    "</a></td><td width='15%'><a href='$urlPath/memberlist.php?mode=viewprofile&u=$row[user_id]'>".$nume."</td><td>".$data."</td></tr>";
    }
    ?>
   </tbody>
    </table>
   

<?
    mysql_free_result($result);
    mysql_close($link);
    ?>



Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 24-Iun-2013, 21:41:25
de Wji
As dori sa folosesc si eu acest script dar nu exista vreo vulnerabilitate la el ?

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 26-Iun-2013, 16:46:22
de Ivan Petre Paul
Un demo?

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 13-Iul-2013, 20:11:27
de Gotyc

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 18-Iul-2013, 15:59:29
de Ivan Petre Paul
Not Found

The requested URL /test/top20.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 30-Sep-2013, 01:04:24
de Gotyc
Verifica acum > Top 20

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 30-Sep-2013, 08:13:51
de Anişor
Nu e prea maret ce ai facut tu intrucat cu top five se poate face acelasi lucru dar iti admir curajul.
Keep it up, poate pe viitor ne aduci ceva mai maret. C'ya!

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 30-Sep-2013, 12:31:19
de Gotyc
DA bun , dar top five il poti pune in alta pagina ? gen eu vreau sa-mi fac index din php inainte de forum.. pentru asta am gandit acest script:)

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 30-Sep-2013, 17:18:43
de Anişor
Daca vrei iti demonstrez ca se poate adauga in alta pagina :D

Re: [Tutorial Top 10-20 posturi pagina externa

Scris: 30-Sep-2013, 23:19:25
de Gotyc
Fie cum zici tu

Eu doar am scos scriptul..