Ok sure, can you help me display files from particular roles? I posted a question before about it.
To do the download tracker:
in wp-filebase.php
go down to where it says “//database settings”
add this line:
$wpdb->wpfilebase_file_download_manager = $wpdb->prefix . 'wpfb_file_download_manager';
just after:
$wpdb->wpfilebase_files_id3 = $wpdb->prefix . ‘wpfb_files_id3’;
Now go to setup.php
go down to this function “static function SetupDBTables()”
add this
$tbl_file_download_manager = $wpdb->prefix . 'wpfb_file_download_manager';
after
$tbl_files_id3 = $wpdb->prefix . 'wpfb_files_id3';
add this just under that before the $queries
$queries[] = “CREATE TABLE IF NOT EXISTS $tbl_file_download_manager (
tracker_id bigint(20) unsigned NOT NULL auto_increment,
dl_file_id bigint(20) unsigned NOT NULL default ‘0’,
dl_file_name varchar(127) NOT NULL default ”,
dl_user_id bigint(20) unsigned NOT NULL default ‘0’,
dl_user_name varchar(127) NOT NULL default ”,
dl_company_name varchar(127) NOT NULL default ”,
dl_time timestamp default CURRENT_TIMESTAMP,
PRIMARY KEY (tracker_id)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1″;
scroll down to the bottom function DropDBTables()
and replace the definition of $tables with this:
$tables = array($wpdb->wpfilebase_files, $wpdb->wpfilebase_files_id3, $wpdb->wpfilebase_cats, $wpdb->wpfilebase_file_download_manager);
Now go to File.php and scroll down to function Download()
I put my code in after the //count download section inside the Download() funtion just cause it looks nice. Add this to it:
if(!$is_admin) {
$wpdb->query( $wpdb->prepare(
"
INSERT INTO $wpdb->wpfilebase_file_download_manager
( dl_file_id, dl_file_name, dl_user_id, dl_user_name, dl_company_name)
VALUES ('%d', '%s', '%d', '%s', '%s')
",
array(
$this->file_id,
$this->file_name,
$current_user->ID,
$current_user->user_login,
$user_role
)
) );
}
Now all you have to do is save all that stuff, deactivate and then reactive the plugin (which will run the setup file and do your tables).
To call data from it is pretty simple just use standard SQL requests (you can put this in your templates or what ever or even just make a short code of it):
$userdownloads = $wpdb->get_results(
"
SELECT dl_file_name, dl_user_name, dl_company_name, dl_time
FROM $wpdb->wpfilebase_file_download_manager
WHERE dl_company_name != 'administrator'
"
);
foreach ( $userdownloads as $userdownload )
{
echo 'Company: ' . $userdownload ->dl_company_name . "<br />";
echo 'User: ' . $userdownload ->dl_user_name . "<br />";
echo 'Download time: ' . $userdownload ->dl_time . "<br />";
echo 'File name: ' . $userdownload ->dl_file_name . "<br /><br />";
}
and voila! you have it.
Enjoy
