Pending links

[Hizson]

I know that this has probably been discussed in another post (I searched and couldn't find an answer though) but I still would like to make a request.

I was wondering if it is possible to have something on the frontpage that would let visitors know how many links are awaiting review? I found this on another phpld site (http://www.webverzeichnis-webkatalog.de/en/) but didn't know if the site owner created his own mod or if it can be found here?

Thanks,

Jere

[Ap0s7le]

Hey Jere!

Yeah, this should be simple.

I'll get back with you when I get back, as I'm leaving right now :)

Talk with you soon bro.

-Casey

[Hizson]

Great Casey,

Hope you have a safe trip back home and I look forward to hearing from you then.

Jere

[Timeless]

Hi m8,

i am the owner of the directory that u post on top.

http://www.webverzeichnis-webkatalog.de(German)
http://www.webverzeichnis-webkatalog.de/en (English)

take a look at the wiki:

http://www.phplinkdirectory.com/kb/Coding_PHP_and_Smarty/page_1/Displaying_Total_Number_of_Links_and_Categories.ht ml

that with the pending I have self add, but it was so easy..i had just looked on the admin section, cause there was it done already..:

open the footer.tpl or the main.tpl or wherever u want it and add this one:

{l}Pending Links{/l}: {$stats[1]}

{l}Active Links{/l}: {$stats[0]}

{l}Categories{/l}: {$stats[3]}


then open the index.php, find
echo $tpl->fetch('main.tpl', $id);
and add the following code before:

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


thats it..yw..later

[Hizson]

Thanks Timeless,

It worked perfectly.

You have a very nice looking site. I will be adding links in the near future...that is if you accept non-german sites?
Jere

[Timeless]

Thank you Buddy,

yeah..sure...exactly for that i have the Directory in German and in English. Switch to english and add so many sites u want...i approve daily...

i add now my sites in your directory too...

later

[thompson]

super timeless.

i´m from germany too and i built it in my site www.sportsuche.info too.

thanks for the code.

one question to you:

who has you bild the english language site ? is there a separate installation and database ?