[Mod] Add Statistics to Homepage

[Jappi]

Hi,

I don't know, if anybody use tis small Mod.

{image broken and removed}

By this way, thanks to all people who develop mods and send tips.

Jappi

Sorry, that I announce myself only today

At first create a new File like "statistic.php", insert following Code:

<?PHP
//Statistik
$total_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 2");
$tpl->assign('total_links', $total_links);
 
$pending_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 1");
$tpl->assign('pending_links', $pending_links);
 
$today_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `DATE_ADDED` >= CURRENT_DATE");
$tpl->assign('today_links', $today_links);
 
$categorys = $db->GetOne("SELECT COUNT(*) FROM `{$tables['category']['name']}` WHERE `PARENT_ID` = 0 ");
$tpl->assign('categorys', $categorys);
 
$subcategorys = $db->GetOne("SELECT COUNT(*) FROM `{$tables['category']['name']}` WHERE `PARENT_ID` > 0 ");
$tpl->assign('subcategorys', $subcategorys);
//Ende Statistik
?>

next open index.php and search for:

// Paging 4
$tpl->assign('list_total', count($count));
// End Paging 4

and insert Code below.

require_once 'statistic.php';

Now you can use the 5 variables in your templates whereever you want.

For example in my left.tpl:

<p id="statistic">
<span class="statistic">
{$categorys}

{$subcategorys}


{$total_links}

{$pending_links}

{$today_links}

</span>
{l}Categorys:{/l}

{l}Subcategorys:{/l}

{l}Entries{/l}

{l}Total:{/l}

{l}Pending:{/l}

{l}Today:{/l}
</p>

If you want use this Layout, insert in your main.css:

#statistic {
margin: 0px;
padding: 13px;
border: 1px solid #8B008B;
font-size: 7pt;
line-height: 12px;
}
.statistic {
float: right;
font-weight: bold;
padding-right: 5px;
text-align: right;
}

Ok, have fun

I hope phpLD 3.0 use the same tablefields as 2.0

Jappi

[Jappi]

Sorry, i mean naturally, need and not to use.

Simply Integration.
Sorry for my bad english, look at my sign :roll:

Jappi

[bobby9101]

i would use it if you could send the code

[tomsa]

yes, if you release a mod i think i will use it

[Jappi]

Sorry, that I announce myself only today

At first create a new File like "statistic.php", insert following Code:

<?PHP
//Statistik
$total_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 2");
$tpl->assign('total_links', $total_links);

$pending_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `STATUS` = 1");
$tpl->assign('pending_links', $pending_links);

$today_links = $db->GetOne("SELECT COUNT(*) FROM `{$tables['link']['name']}` WHERE `DATE_ADDED` >= CURRENT_DATE");
$tpl->assign('today_links', $today_links);

$categorys = $db->GetOne("SELECT COUNT(*) FROM `{$tables['category']['name']}` WHERE `PARENT_ID` = 0 ");
$tpl->assign('categorys', $categorys);

$subcategorys = $db->GetOne("SELECT COUNT(*) FROM `{$tables['category']['name']}` WHERE `PARENT_ID` > 0 ");
$tpl->assign('subcategorys', $subcategorys);
//Ende Statistik
?>

next open index.php and search for:

// Paging 4
$tpl->assign('list_total', count($count));
// End Paging 4

and insert Code below.

require_once 'statistic.php';

Now you can use the 5 variables in your templates whereever you want.

For example in my left.tpl:

<p id="statistic">
<span class="statistic">
{$categorys}

{$subcategorys}


{$total_links}

{$pending_links}

{$today_links}

</span>
{l}Categorys:{/l}

{l}Subcategorys:{/l}

{l}Entries{/l}

{l}Total:{/l}

{l}Pending:{/l}

{l}Today:{/l}
</p>

If you want use this Layout, insert in your main.css:

#statistic {
margin: 0px;
padding: 13px;
border: 1px solid #8B008B;
font-size: 7pt;
line-height: 12px;
}
.statistic {
float: right;
font-weight: bold;
padding-right: 5px;
text-align: right;
}

Ok, have fun

I hope phpLD 3.0 use the same tablefields as 2.0

Jappi

[Momo]

Thanks a lot for this mod, I have used this for the statistics on my directory: http://ipage.info

[rogue]

many thanks, a complete script idiot like me got this up and running!

[anon]

bah! don't be so hard on yourself. Just think of it as not being versed enough(yet)

[bobby9101]

yeah i once was terrible at scripting i am not really that good yet
but hey i am coming along

[kentuckyslone]

I am using 3.0.4 I could not locate

// Paging 4
$tpl->assign('list_total', count($count));
// End Paging 4

anywhere in index.php

Am I missing something or is this for a different version?
I would like to use this if I can make it work.

Thanks!

[neurosis4u]

i have it working with a little change...

instead of building a new php file called statistics.php i put the code for this file directly in index php, right above
echo $tpl->fetch('main.tpl', $id);

[mrbadgolf]

I cannot find that in 3.04 either

[neurosis4u]

look at the end of the file

//Make output
echo $tpl->fetch ('main.tpl', $id);

[mrbadgolf]

Im sorry, didnt make myself clear, I cannot locate

// Paging 4
$tpl->assign('list_total', count($count));
// End Paging 4

in the index.php file of 3.0.4

[Irka]

Very coooooool mod!!! Super i'll use it for all my sites !!!!!

[arindra]

very nice mod.

[balkanboy]

I used this mod in new design I am making. It will be available for free at www.phpldtemplates.info
I changed html code and css also to make better control of it. You can see work in progres here: http://img63.imageshack.us/img63/5756/screen0tr.gif
Also tell me your homepage url so I can credit you on my site when I release this one.

[CyberGrenade]

Thanks for the MOD. This opens up lots of doors. You can use this to get lots of data and display it on the main pages.

Thanks for the ideas.

[devilishqueen]

which folder should create that statistic.php file? root?

[bobby9101]

yeah in root