Directory Stats for PHPLD

[Alam]

Friends,

I know many of u have already this type of scripts but I have developed it again and want to share with you. Please don't take it otherwise.

Copyright???(multiple copy and editing is highly appricitiated )

change the database connection part for your database connection.
Open index.php in a code viewer and just place the code and save.

NB: Please visit my sites to view the result (Urlcabin Web Directory - DirectoryMX - ActiveCabin.com - directory.activewebtool.com)


<?

// This script has been written by Alam (alam19bd@yahoo.com) and any can use it, change it and delete it without my permission

// Database connection
$db="databasename"; // Please write your database name here
$db_server="dbservername"; // Please write your server name here (nornamlly localhost)
$db_id="databaseID"; // Please write your database ID here
$db_password="databasePWD"; // Please write your database Password here

$link=mysql_connect("$db_server","$db_id","$db_pas sword");
if(!mysql_select_db("$db"))
{
echo "Connection failed!";
}
?>


<div align=center>

Category:

<?
// Total Category
$category_table="PLD_CATEGORY";

$q = "select count(*) from $category_table";
$r = mysql_query($q,$link);
while($a=mysql_fetch_array($r)){
echo $a[0];
}
?>

- Active Links:

<?
// Total Active Links
$link_table="PLD_LINK";

$q = "select count(*) from $link_table where STATUS=2";
$r = mysql_query($q,$link);
while($a=mysql_fetch_array($r)){
echo $a[0];
}
?>

- Pending Links:

<?
// Total Pending Links
$link_table="PLD_LINK";

$q = "select count(*) from $link_table where STATUS=1";
$r = mysql_query($q,$link);
while($a=mysql_fetch_array($r)){
echo $a[0];
}
?>

</div>

[temi]

This is brilliant Alam, thanks for sharing, reputation added

[Alam]

wow,
tnx a lottttttttttttttttt

[OldWelshGuy]

What does this script do?

Excuse my ignorance

[temi]

Alam did not explain what it does properly, it output PHPLD stats on the footer of a PHPLD directory linke on the footer of the example site he gave. By defaul, PHPLD does not do that.

[Alam]

temi,

Thanks a lot for your kind cooperation

I had got to say details about the script

This script will work on phpld directory and show the total category, total active links and pending links in footer of the page. So anyone can ezly see and get idea about your site stats. Thats all

[rakib]

Alam, great! this is a great.

[OldWelshGuy]

Ah nice piece of code. I use esyndicat which does this anyhow. I think it is also a good guide to directory owners that you have to carry out some work on empty cats.

[Alam]

Dear mate,

Please leave ur site address here if you add my script there. I wanna see the result in ur site :P

[3wlink]

Thanks a lot to u Alam for the nice piece of work, and also for sharing it with us