</thead>
<tbody id="the-list">
<?php
if (!empty($rows)) {
foreach ($rows as $row) {
$permission = $row['permissions'] == 'yes' ? '<img src="' . $plugin_url . '/img/unlock.gif" alt="unlock.gif">' : '<img src="' . $plugin_url . '/img/lock.png" alt="lock.png">';
echo " <tr>\n";
echo " <td><img src=\"" . $plugin_url . "/img/icons/" . $row['icon'] . "\" alt=\"" . $row['icon'] . "\"></td>\n";
echo " <td class=\"alternate\"><a href=\"javascript: void(0);\" title=\"" . __('Click me!', 'downloads-manager') . "\" onClick=\"javascript: get_dm_code(event, '" . $row['id'] . "');\">" . $row['id'] . "</a></td>\n";
echo " <td class=\"alternate\"><a href=\"" . $row['link'] . "\">" . stripslashes($row['name']) . "</a></td>\n";
echo " <td class=\"alternate\">" . FileSizeOf($row['link']) . "</td>\n";
echo " <td class=\"alternate\">" . stripslashes($row['catname']) . "</td>\n";
echo " <td class=\"alternate\">" . date('d/m/Y', $row['date']) . "</td>\n";
echo " <td class=\"alternate\">" . $permission . "</td>\n";
echo " <td class=\"alternate\">" . $row['clicks'] . "</td>\n";
echo " <td class=\"alternate\">" . dm_avarage($row['date'], $row['clicks']) . "</td>\n";
echo " <td class=\"alternate\"><a href=\"#delete\" onClick=\"RemoveDownload('" . $row['id'] . "', '" . $row['name'] . "', '" . basename($row['link']) . "', '" . $row['link'] . "');\" class=\"delete\">" . __('Delete', 'downloads-manager') . "</a></td>";
echo " <td class=\"alternate\"><a href=\"#edit\" onClick=\"EditDownload('" . $row['id'] . "', '" . $row['name'] . "', '" . $row['catname'] . "', '" . $row['icon'] . "', '" . $row['description'] . "', '" . $row['permissions'] . "', '" . $row['link'] . "', '" . date('d/m/Y', $row['date']) . "', '" . $row['clicks'] . "');\" class=\"edit\">" . __('Edit', 'downloads-manager') . "</a></td>\n";
echo " </tr>\n";
}
} else {
echo " <tr>\n";
echo " <td class=\"alternate\" colspan=\"10\" style=\"text-align: center;\">" . __('There are no downloads!', 'downloads-manager') . "</td>\n";
echo " <tr>\n";
}
?>
</tbody>
</table>
</div>
<a name="edit"></a>
function dm_get_new_download($before, $after, $limit = 10, $av = false, $ct = false)
{
global $wpdb, $table_prefix;
$rows = $wpdb->get_results("SELECT d.id as id, d.name as name, d.link as link, d.clicks as clicks, d.date as date, d.category as category, c.name as catname FROM " . $table_prefix . "dm_downloads d, " . $table_prefix . "dm_category c WHERE d.category=c.id ORDER BY d.date DESC LIMIT 0, {$limit}");
$link = '/?file_id=%d';
echo '<ul>';
foreach ($rows as $row) {
$avarage = $av ? ' - ' . dm_avarage($row->date, $row->clicks) . ' ' . __('Clicks per day', 'downloads-manager') : '';
$cat = $ct ? ' - ' . __('Category', 'downloads-manager') . ': <b>' . $row->catname . '</b>' : '';
printf($before . '<b><a href="' . get_bloginfo('siteurl') . $link . '">' . $row->name . '</a></b>' . $cat . $avarage . ' ' . $after, $row->id);
}
echo '</ul>';
}
<tr>
<td style="text-align: center">
<?php
echo '<b><a href="' . $dm_first->link . '">' . $dm_first->name . '</a></b> - ' . date("d/m/Y", $dm_first->date);
?>
<br />
<?php
echo '<b>' . __('Clicks', 'downloads-manager') . ':</b> ' . $dm_first->clicks . ' - <b>' . dm_avarage($dm_first->date, $dm_first->clicks) . '</b> ' . __('Clicks per day', 'downloads-manager');
?>
</td>
</tr>
<tr>
<td style="text-align: center; background: #ccc;"><b><?php
_e('Last Download Added', 'downloads-manager');
?>
:</b></td>
</tr>
<tr>
<td style="text-align: center">
<?php
echo '<b><a href="' . $dm_last->link . '">' . $dm_last->name . '</a></b> - ' . date("d/m/Y", $dm_last->date);
?>
<br />
<?php
echo '<b>' . __('Clicks', 'downloads-manager') . ':</b> ' . $dm_last->clicks . ' - <b>' . dm_avarage($dm_last->date, $dm_last->clicks) . '</b> ' . __('Clicks per day', 'downloads-manager');
?>
</td>
</tr>
</table>
</div>
</div>
