Filedownloadcount-Quick-Code-Snipped

marcus@localhorst · Post by **marcus@localhorst** » Wed 17. Jan 2007, 16:44

Maybe you've noticed, that the Database Table phpwcms_file contains two rows called f_dlstart and f_dlfinal which counts the downloads of your non picture files (exe,zip,mp3,mpg,avi). Edit: from your -file download contentpart-!
Because I'm to lazy to use a third party dlcounter-hack I've just copy&paste some phpwcms codeparts, to display the counted files inside filecenter. (Under each option of filecenter!

)

open include/inc_tmpl/files.abschluss.tmpl.php
and add the following snipped at the end of file:

Code: Select all

<?php
$file_sql = "SELECT * FROM ".DB_PREPEND."phpwcms_file WHERE  f_trash=0 AND f_dlstart > 0 OR f_dlfinal > 0 ORDER BY f_dlfinal DESC;";

echo "<ul>";
if($file_result = mysql_query($file_sql, $db) or die ("error while listing files")) {
	while($file_row = mysql_fetch_array($file_result)) {
		$filename = html_specialchars($file_row["f_name"]);
		echo "<li><b>".$filename. "</b><br />start: " . $file_row["f_dlstart"]. "| final: " . $file_row["f_dlfinal"]."</li>";
		}
}
echo "</ul>";
?>

PLEASE NOTICE! this is just a hint for people who like to tweak their system, to learn more. This is not a stable or a suggested solution from the phpwcms developer (I think he would not like that ).
Please do not ask for support. Thanks, m.

Post by **Oliver Georgi** » Wed 17. Jan 2007, 17:52

every file downloaded via files content part will be tracked.

OLiver

marcus@localhorst · Post by **marcus@localhorst** » Wed 17. Jan 2007, 17:58

ok, thanks, I've doesn't noticed that, because I provide only mp3 files and these are counted, it seems I misunderstood the function which track the started and full downloads. I'm a bit lazy at the moment .

StudioZ · Post by **StudioZ** » Wed 17. Jan 2007, 20:52

Oliver Georgi wrote:every file downloaded via files content part will be tracked.

OLiver

I would also add this great new improvement that I noticed in pre1.2.9:
"every file downloaded via files content part" is now indexed in the Search

So... if you have a public file named mynewfiletodownload.pdf
and you enter mynew ... the Search will find it. Isn't it great ?

Yeah !

Awesome

Seriously... the only real thing missing to this great and awesome CMS is now.. the espresso machine and the long awaited User management

Yves

phalancs · Post by **phalancs** » Fri 19. Jan 2007, 19:26

this is nice, did not think thta it would be so simple to get the filecounts. Ok but I want the numbers to be displayed next to the file names.
Any Idea where to search?

marcus@localhorst · Post by **marcus@localhorst** » Fri 19. Jan 2007, 19:35

phalancs wrote:this is nice, did not think thta it would be so simple to get the filecounts. Ok but I want the numbers to be displayed next to the file names.
Any Idea where to search?

take a look first into phpwcms.php and searching for

Code: Select all

case: "files"

there you will find all used/included files for the filecenter, or check include/inc_tmpl and include/inc_lib for all files with suffix files.blabla.php
it's a bit difficult to find the right one

the rest should be easy

best marcus

StudioZ · Post by **StudioZ** » Fri 19. Jan 2007, 19:44

phalancs wrote:this is nice, did not think thta it would be so simple to get the filecounts. Ok but I want the numbers to be displayed next to the file names.
Any Idea where to search?

Hi Phalancs,
I just upgraded my site to 1.2.9 and if you visit this page:
http://www.malouin.ws/design/index.php? ... ds-phpwcms

Here is the default template I modified a bit to present the files:

Code: Select all

<!--FILE_SETTINGS_START//-->
; this is formatted like WIN.INI
; please: do not use comments for value lines
icon_path 		= "img/icons/"
icon_name 		= "small_icon_{FILE_EXT}.gif"
file_size_round	= 1
date_format		= "%Y/%m/%d"
; set_locale		= "de_DE@Euro"
set_locale		= "fr_CA"
<!--FILE_SETTINGS_END//-->

<div style="margin-top: 0px; padding-top: 0px; border-top: 0px dotted #CCCCCC;">
<!--FILE_ENTRY_START//-->
	<div class="fileEntry" style="margin-bottom:10px; padding-bottom: 10px; border-bottom: 0px dotted #CCCCCC;">
			[FILE_IMAGE_ELSE]<img src="{FILE_ICON}" alt="" border="0" />[/FILE_IMAGE_ELSE]
			[FILE_IMAGE]<img src="{FILE_IMAGE}" alt="" border="" />[/FILE_IMAGE]
			<a href="{FILE_LINK}"{FILE_TARGET}>[FILE_TITLE]{FILE_TITLE}[/FILE_TITLE][FILE_TITLE_ELSE]{FILE_NAME}[/FILE_TITLE_ELSE]</a>
		<br />[FILE_DESCRIPTION]
		{FILE_DESCRIPTION}<br />[/FILE_DESCRIPTION]
		File updated: {FILE_DATE} | Size: {FILE_SIZE}<br /> 
		Downloads: {FILE_DOWNLOADS}
		<br />
	</div>
<!--FILE_ENTRY_END//-->
</div>

and now... to have the numbers to be displayed next to the file names, I would modify the template like this (see: {FILE_DOWNLOADS} portion):

Code: Select all

<!--FILE_ENTRY_START//-->
	<div class="fileEntry" style="margin-bottom:10px; padding-bottom: 10px; border-bottom: 0px dotted #CCCCCC;">
			[FILE_IMAGE_ELSE]<img src="{FILE_ICON}" alt="" border="0" />[/FILE_IMAGE_ELSE]
			[FILE_IMAGE]<img src="{FILE_IMAGE}" alt="" border="" />[/FILE_IMAGE]
			<a href="{FILE_LINK}"{FILE_TARGET}>[FILE_TITLE]{FILE_TITLE}[/FILE_TITLE][FILE_TITLE_ELSE]{FILE_NAME}[/FILE_TITLE_ELSE]</a>&nbsp;Downloads:&nbsp;{FILE_DOWNLOADS}  
		<br />[FILE_DESCRIPTION]
		{FILE_DESCRIPTION}<br />[/FILE_DESCRIPTION]
		File updated: {FILE_DATE} | Size: {FILE_SIZE}
		<br />
	</div>
<!--FILE_ENTRY_END//-->
</div>

Cheers,

Yves

marcus@localhorst · Post by **marcus@localhorst** » Fri 19. Jan 2007, 19:50

just want to say, my hack is for the backend!
Yves means the frontend, if I'm right?!

StudioZ · Post by **StudioZ** » Fri 19. Jan 2007, 19:57

marcus@localhorst wrote:just want to say, my hack is for the backend!
Yves means the frontend, if I'm right?!

Yes. You are right marcus

I guess my reflexes brings me to be just more of a frontend guy
than a backend guy

I always hate to have to hack.

Could be my age ?

Cheers,

Yves

phalancs · Post by **phalancs** » Thu 15. Mar 2007, 01:16

Hey Yves!
Wow, this is great, exactly what i have thought about, thanx a lot for sharing

Will try it as soon as possible!

BTW: what kind of DHTML menu are you using :O

StudioZ · Post by **StudioZ** » Thu 15. Mar 2007, 01:57

phalancs wrote:... BTW: what kind of DHTML menu are you using :O

Hi Phalancs

I am using a commercial feature,
introduced and supported by Oliver since 1.2.8:
deluxe-menu

You will find all the details at: http://www.deluxe-menu.com

If you search the forums for "deluxe-menu"
you will tips and tricks to get it started pretty fast.

Cheers,

Yves

FKU · Post by **FKU** » Tue 24. Apr 2007, 23:27

I'am also using the commercial script deluxe-menu for this site:

http://www.amerika-holzer.at/a/index.ph ... ,0,0,1,0,0 - (Not finished yet - beta stadium)

It is possible that for example only the last point of of each menu strukture is clickable?

At the moment you can click at every element in the menu-structure! That causes a lot of work - (articlelist pages).

For example:

Hotel (dropdown - no article content is shown)
Willkommen (clickable - article content)
Übersicht (clickable - article content)
Bilder (clickable - article content)
Kulinarik (dropdown - no article content is shown)
Über uns (clickable - article content)

Thanks Florian

StudioZ · Post by **StudioZ** » Wed 25. Apr 2007, 00:04

Hello Florian,

If I well understand your needs then...
I would suggest you edit each Category per your needs
for those you don't want to appear in the menu,
by ticking the "hide" option in the "frontend menu status:"

Something else you might consider is...
using the powerfull redirects options (see: "redirect to:")
and this, available both at Article and Category level.

Cheers,

Yves

Filedownloadcount-Quick-Code-Snipped

Filedownloadcount-Quick-Code-Snipped

wow

Re: wow

Deluxe_menu - Settings