want Stats to display at my first page.

[sunpetch]

Hello Guy..

I don;t know if this can do or not..but this is what i am looking for.

I want a stats detail : Top 10 Topics (by Replies) and Top 10 Topics (by Views) to be on my first index page..

I am trying by copy the code from /source/stats.php into my index.html and change index.html to index.php but it is not working T_T.. What should i do ??

Thank you very much

[Ayeka]

For your newly converted index.htm (php) page, do you have it defined as a PHP page:

at the very top, first thing:

Code Select Expand


<?php


at the very bottom:

Code Select Expand


?>


Then it should work, although, I'm not sure if simply copying and pasting the code would give you the desired layout of your page

[sunpetch]

Hi,

Yes, I do put the php code and change the index.html to index.php.... but it is still not working..T_T.. I just copy the code and paste...^_^.. So I believe that it is not enough..Do I have to remove the </html> too ??

I also trying to browse only the soucre/stats.php only ,but nothing happen..there is no display at all...T_T

Is there any file that i have to include them first ??

[Ayeka]

Well you could do something like this:

Code Select Expand


<?php
echo ' Insert all of your HTML stuff in here between single quotes';

   include_once("$sourcedir/stats.php");
   display_stats();
?>


That might work, I haven't really sat down to figure this one out yet.  But it is a cool idea.

[sunpetch]

HI,

Here is what i did... but there is some problem with the URL link T_T ..the  : $scripturl

here is my code

<table>
<?

conn_db();


   $topic_view_result = mysql_query("
      SELECT m.subject, t.ID_TOPIC, t.ID_BOARD, t.numViews
      FROM yabbse_topics AS t,yabbse_messages AS m, yabbse_messages AS mes , yabbse_boards AS b, yabbse_categories AS c
   WHERE m.ID_MSG=t.ID_FIRST_MSG
      AND mes.ID_MSG=t.ID_LAST_MSG
      AND t.ID_BOARD=b.ID_BOARD
      AND c.ID_CAT=b.ID_CAT

   ORDER BY t.numViews DESC limit 10") ;
// it is 'ORDER BY t.numReplies DESC")' for by replies...
// 'limit 10'  is for 10 record shown
while ($row_topic_view = mysql_fetch_array($topic_view_result))
   {
      echo '
                           <tr>
                              <td><font size="2"><a href="' . $scripturl . '?board=' . $row_topic_view['ID_BOARD'] . ';action=display;threadid=' . $row_topic_view['ID_TOPIC'] . ';start=0">' . $row_topic_view['subject'] . '</a></font></td>
                              <td align="right"><font size="2">' . $row_topic_view['numViews'] . '</font></td>
                           </tr>';
   }
function conn_db()
{
mysql_connect ("localhost","root","");
mysql_select_db("yabbse");
return;
}
?>
</table>

[sunpetch]

I belive the  $scripturl didn;t select the right url...T_T..

This is the link that show to me..

http://www.ebetta2u.com/?board=3;action=display;threadid=7;start=0

my yabbse root is www.ebetta2u.com/webboard/

what should i do ??
Thank you

[Anguz]

SSI.php is your answer

http://www.ebetta2u.com/webboard/ssi_examples.php

these'd be the two you want:

<? topTopicsViews(); ?>
<? topTopicsReplies(); ?>