function log_event($event, $errno)
{
global $userdata, $pdp;
if (!$this->id || !$pdp->settings['do_log']) {
return false;
}
$ok = dbquery("INSERT INTO " . DB_PDP_LOG . "" . " SET" . " download_id='" . $this->id . "'," . " user_id='" . $userdata['user_id'] . "'," . " log_timestamp='" . time() . "'," . " log_type='" . $event . "'," . " log_errno='" . $errno . "'");
/*FIXME
dbquery("UPDATE ".DB_PDP_DOWNLOADS."
SET
dl_mtime='".time()."'
WHERE download_id='".$this->id."'");
*/
if ($pdp->settings['pm_after_changes'] && ff_db_count("(*)", DB_PDP_LOG, "(download_id='" . $this->id . "')") % $pdp->settings['pm_after_changes'] === 0) {
$this->send_pm_mail($pdp->settings['neupm'], PDP_PM_CHANGES);
}
if ($event == PDP_EV_NEWCOMMENT && $pdp->settings['new_comm_pm']) {
$this->send_pm_mail($this->data['user_id'], PDP_PM_COMMENT);
} elseif ($event == PDP_EV_BROKEN && $pdp->settings['defektpm']) {
$this->send_pm_mail($pdp->settings['defektpm'], PDP_PM_BROKEN);
} elseif ($event == PDP_EV_CHECK) {
$this->send_pm_mail($pdp->settings['neupm'], PDP_PM_CHECK);
} elseif ($event == PDP_EV_PUBLISHED) {
$this->send_pm_mail($this->data['user_id'], PDP_PM_ACCEPTED);
} elseif ($event == PDP_EV_NEWDOWNLOAD) {
$this->send_pm_mail($pdp->settings['neupm'], PDP_PM_NEW);
}
return true;
}
$name = $data['download_title'];
$ver = $data['download_version'];
$url = $_POST['down'][$id];
$size = $data['download_filesize'];
$datestamp = $data['download_datestamp'];
$cat_id = $_POST['cat'][$id];
$lid = $_POST['license'][$id];
$desc = addslash($data['download_description']);
$ok = dbquery("INSERT INTO " . DB_PDP_DOWNLOADS . "" . " SET" . " cat_id='{$cat_id}', dl_name='{$name}'," . " dl_desc='{$desc}'," . " user_id='" . $userdata['user_id'] . "'," . " license_id='{$lid}', lizenz_okay='N'," . " lizenz_packet='N'," . " dl_count='" . $data['download_count'] . "'," . " dl_mtime='{$datestamp}', dl_ctime='{$datestamp}'," . " dl_status='" . PDP_PRO_ON . "'");
$id = mysql_insert_id();
$ok = dbquery("INSERT INTO " . DB_PDP_FILES . "" . " SET" . " download_id='{$id}'," . " file_version='{$ver}'," . " file_desc=''," . " file_url='{$url}'," . " file_size='{$size}'," . " file_timestamp='{$datestamp}'");
}
// count cat downloads
$query_id = dbquery("SELECT cat_id" . " FROM " . DB_PDP_CATS . "");
while ($data = dbarray($query_id)) {
$count = ff_db_count("(*)", DB_PDP_DOWNLOADS, "(cat_id='" . $data['cat_id'] . "'" . " AND dl_status='" . PDP_PRO_ON . "')");
$mysql[] = "UPDATE " . DB_PDP_CATS . "" . " SET" . " count_downloads='" . $count . "'" . " WHERE cat_id='" . $data['cat_id'] . "'";
}
fallback(FUSION_SELF . "?do_import=no");
}
/*
* CREATE CAT SEL
*/
$all_cats = array();
$query_id = dbquery("SELECT cat_name, top_cat, cat_id, cat_upload_access" . " FROM " . DB_PDP_CATS . "" . " ORDER BY cat_order ASC");
while ($data = dbarray($query_id)) {
$all_cats[$data['cat_id']] = array("name" => $data['cat_name'], "parentcat" => $data['top_cat'], "access" => $data['cat_upload_access']);
}
function pdp_tmp_show_cat($parentid, $cat_array, $level, $sel_this)
{
$retval = "";
$href .= "#comm" . $comment_id;
} elseif (isset($_POST['delete_comments']) && iPDP_MOD) {
$do_calc_comments = true;
if (!isset($_POST['comment'])) {
fallback(FUSION_SELF . "?did=" . $download->id);
}
$errors = 0;
foreach ($_POST['comment'] as $id => $val) {
if (!dbquery("DELETE FROM " . DB_PDP_COMMENTS . " WHERE comment_id='" . $id . "'" . " AND download_id='" . $download->id . "'")) {
++$errors;
}
}
} elseif (isset($_GET['subscibe']) && $pdp->settings['allow_notify'] && iMEMBER) {
$do_calc_subscribers = true;
if ($_GET['subscibe'] == "1") {
$ok = dbquery("INSERT INTO " . DB_PDP_NOTIFY . "" . " SET" . " user_id='" . $userdata['user_id'] . "'," . " download_id='" . $download->id . "'," . " visited='yes'," . " details='0'");
} else {
$ok = dbquery("DELETE FROM " . DB_PDP_NOTIFY . "" . " WHERE user_id='" . $userdata['user_id'] . "'" . " AND download_id='" . $download->id . "'");
}
$download->log_event(PDP_EV_SUBSCRIBE, 0);
}
if ($do_calc_avg) {
$ok = dbquery("UPDATE " . DB_PDP_DOWNLOADS . "\n\t\tSET\n\t\tavg_vote='" . pdp_calc_avg_vote($download->id) . "',\n\t\tcount_votes='" . ff_db_count("(*)", DB_PDP_VOTES, "(download_id='" . $download->id . "')") . "'\n\t\tWHERE download_id='" . $download->id . "'");
} elseif ($do_calc_comments) {
$ok = dbquery("UPDATE " . DB_PDP_DOWNLOADS . "\n\t\tSET\n\t\tcount_comments='" . ff_db_count("(*)", DB_PDP_COMMENTS, "(download_id='" . $download->id . "')") . "'\n\t\tWHERE download_id='" . $download->id . "'");
} elseif ($do_calc_subscribers) {
$ok = dbquery("UPDATE " . DB_PDP_DOWNLOADS . "\n\t\tSET\n\t\tcount_subscribers='" . ff_db_count("(*)", DB_PDP_NOTIFY, "(download_id='" . $download->id . "')") . "'\n\t\tWHERE download_id='" . $download->id . "'");
}
if ($errors == 0) {
fallback($href);
}
<th width="16"></th>
</tr>
</thead>
<tbody>';
$count = 1;
} else {
if (!isset($_GET['new'])) {
fallback(FUSION_SELF . "?new=1");
}
echo "<p>" . $locale['PRP825'];
}
foreach ($cats_for_table as $cid => $data) {
$edit_icon = '<a href="' . FUSION_SELF . '?id=' . $cid . '&edit=1">' . '<img src="../icons/edit.png" alt="' . $locale['prp_edit'] . '" title="' . $locale['prp_edit'] . '" class="noborder"></a>';
$sorting = explode(' ', $data['sorting']);
$dl_count = ff_db_count('(*)', DB_PRP_DOWNLOADS, "(cat_id='{$cid}')");
$child_cats = ff_db_count('(*)', DB_PRP_CATS, "(top_cat='{$cid}')");
if ($dl_count || $child_cats) {
$del_icon = "<img src='../icons/nodelete.gif'" . " alt='' class='noborder'>";
} else {
$del_icon = "<a href='" . FUSION_SELF . "?id={$cid}&del=1'" . " title='" . $locale['prp_delete'] . "'>" . "<img src='../icons/editdelete.png'" . " alt='" . $locale['prp_delete'] . "' title='" . $locale['prp_delete'] . "' class='noborder'></a>";
}
if ($dl_count) {
$view_icon = '<a href="reviews.php?show=cat&id=' . $cid . '"><img src="../icons/viewmag.png" class="noborder" alt="' . $locale['prp_view'] . '" title="' . $locale['prp_view'] . '"></a>';
} else {
$view_icon = '';
}
// $order_cols = "<td class='$tbl'>".str_repeat(" ", $data['level']*5)
// .$data['order'].":".$data['level']."</td>";
$order_cols = "";
for ($i = 0; $i < $data['level']; ++$i) {
$order_cols .= "<td></td>";
* (at your option) any later version. *
***************************************************************************/
require_once '../include/admin.php';
if (!iPDP_ADMIN) {
fallback('../index.php');
}
/*
* GUI
*/
require_once '../include/db_update.php';
opentable($locale['PDP016']);
pdp_admin_menu();
$obsolete = array('locale_utf8', 'icons/warning.gif', 'icons/screenshot.gif', 'icons/comments.gif', 'icons/delete.gif', 'include/getvcode.php');
foreach ($obsolete as $file) {
if (file_exists(INFUSIONS . 'pro_download_panel/' . $file)) {
show_info(sprintf($locale['pdp_obsolete'], $file));
}
}
// some statics
echo '<dl>
<dt>' . $locale['pdp_downloads'] . ':</dt>
<dd>' . ff_db_count('(*)', DB_PDP_DOWNLOADS, '') . '</dd>
<dt>' . $locale['PDP820'] . ':</dt>
<dd>' . ff_db_count('(*)', DB_PDP_CATS, '') . '</dd>
<dt>' . $locale['PDP800'] . ':</dt>
<dd>' . ff_db_count('(*)', DB_PDP_LICENSES, '') . '</dd>
<dt>' . $locale['PDP019'] . ':</dt>
<dd>' . ff_db_count('(*)', DB_PDP_FILES, '') . '</dd>
</dl>';
closetable();
require_once '../include/die.php';
/***************************************************************************
* awEventCalendar *
* *
* Copyright (C) 2006-2008 Artur Wiebe *
* wibix@gmx.de *
* *
* This program is free software; you can redistribute it and/or modify *
* it under the terms of the GNU General Public License as published by *
* the Free Software Foundation; either version 2 of the License, or *
* (at your option) any later version. *
***************************************************************************/
if (!defined('IN_FUSION')) {
die;
}
$can_admin = iAWEC_ADMIN || iMEMBER && $event['user_id'] == $userdata['user_id'];
$cur_logins = ff_db_count("(*)", AWEC_DB_LOGINS, "(ev_id='" . $event['ev_id'] . "' AND login_status='1')");
$max_logins = $event['ev_max_logins'];
/****************************************************************************
* FUNCS
*/
function send_pm($to_id, $subject, $body, $smilies)
{
global $locale, $userdata, $settings;
if (iMEMBER) {
$from_id = $userdata['user_id'];
} else {
$from_id = 0;
}
if (!$to_id || $from_id == $to_id) {
return true;
}
if ($last_status != $ev['ev_status']) {
if ($last_status >= 0) {
echo '
</ul>
</li>';
}
$last_status = $ev['ev_status'];
echo '
<li>' . $locale['awec_status_desc'][$last_status] . '
<ul>';
}
echo '
<li>' . $ev['start'];
if (iAWEC_ADMIN || $ev['ev_status'] == AWEC_DRAFT || $awec_settings['user_can_edit'] && $ev['ev_status'] != AWEC_PENDING) {
echo ' [<a href="edit_event.php?id=' . $ev['ev_id'] . '">' . $locale['awec_edit'] . '</a>]';
}
echo ' <a href="view_event.php?id=' . $ev['ev_id'] . '">' . $ev['ev_title'] . '</a>';
if ($ev['ev_allow_logins']) {
$logins = ff_db_count("(*)", AWEC_DB_LOGINS, "(ev_id='" . $ev['ev_id'] . "')");
echo ' (' . $logins . ' ' . $locale['awec_logins'] . ')';
}
echo '</li>';
}
if (dbrows($res)) {
echo '
</ul>
</li>
</ul>';
}
closetable();
require_once 'include/die.php';
function pdp_menu()
{
global $locale, $pdp, $userdata;
$user_links = array();
$admin_links = array();
$user_links[] = "<a href='download.php'>" . $locale['PDP037'] . "</a>";
$user_links[] = "<a href='download.php?catid=0'>" . $locale['PDP820'] . "</a>";
$user_links[] = "<a href='search.php'>" . $locale['PDP040'] . "</a>";
if (iMEMBER || iPDP_ADMIN || iPDP_MOD) {
if (ff_db_count('(*)', DB_PDP_CATS, groupaccess('cat_upload_access'))) {
$user_links[] = "<a href='edit_desc.php'>" . $locale['PDP038'] . "</a>";
}
if (ff_db_count('(*)', DB_PDP_DOWNLOADS, "user_id='" . $userdata['user_id'] . "'") || ff_db_count('(*)', DB_PDP_NOTIFY, "user_id='" . $userdata['user_id'] . "'")) {
$user_links[] = "<a href='profile.php" . "?id=" . $userdata['user_id'] . "'>" . $locale['PDP160'] . "</a>";
}
}
if (iPDP_MOD) {
$admin_links[] = '<a href="mod.php">' . $locale['pdp_moderator'] . '</a>';
}
if (iPDP_ADMIN) {
$admin_links[] = '<a href="admin/admin.php">' . $locale['PDP016'] . '</a>';
}
$admin_links[] = '<a href="copyright.php">' . $locale['PDP039'] . '</a>';
pdp_render_menu($user_links, $admin_links);
}
case "1.7.9":
$new_ver = "1.7.10";
$set_tbl = DB_PREFIX . "pdp_settings";
//
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_downloads" . " ADD KEY (cat_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_downloads" . " ADD KEY (user_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_downloads" . " ADD KEY (license_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_comments" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_files" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_log" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_images" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_notify" . " ADD KEY (user_id, download_id)";
// count comments
$query_id = dbquery("SELECT dl_id FROM " . DB_PREFIX . "pdp_downloads");
while ($data = dbarray($query_id)) {
$comm_count = ff_db_count("(*)", "pdp_comments", "(dl_id='" . $data['dl_id'] . "')");
$avg = pdp_calc_avg_vote($data['dl_id']);
$mysql[] = "UPDATE " . DB_PREFIX . "pdp_downloads" . " SET" . " count_comments='" . $comm_count . "'" . " WHERE dl_id='" . $data['dl_id'] . "'";
}
break;
case '1.7.10':
$new_ver = '1.8.0';
$set_tbl = DB_PREFIX . "pdp_settings";
//
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_cats\n\t\tADD COLUMN cat_download_access tinyint(3) unsigned NOT NULL default '0'";
$mysql[] = "UPDATE " . DB_PREFIX . "pdp_cats\n\t\tSET\n\t\tcat_download_access=cat_access";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_settings\n\t\tADD COLUMN download_restricted text NOT NULL";
$mysql[] = "UPDATE " . DB_PREFIX . "pdp_settings\n\t\tSET\n\t\tdownload_restricted='" . stripinput($locale['PDP407']) . "'";
/*!!!NO BREAK!!!*/
/*!!!NO BREAK!!!*/
case '1.8.0':
$href .= "#comm" . $comment_id;
} elseif (isset($_POST['delete_comments']) && iPRP_MOD) {
$do_calc_comments = true;
if (!isset($_POST['comment'])) {
fallback(FUSION_SELF . "?did=" . $review->id);
}
$errors = 0;
foreach ($_POST['comment'] as $id => $val) {
if (!dbquery("DELETE FROM " . DB_PRP_COMMENTS . " WHERE comment_id='" . $id . "'" . " AND review_id='" . $review->id . "'")) {
++$errors;
}
}
} elseif (isset($_GET['subscibe']) && $prp->settings['allow_notify'] && iMEMBER) {
$do_calc_subscribers = true;
if ($_GET['subscibe'] == "1") {
$ok = dbquery("INSERT INTO " . DB_PRP_NOTIFY . "" . " SET" . " user_id='" . $userdata['user_id'] . "'," . " review_id='" . $review->id . "'," . " visited='yes'," . " details='0'");
} else {
$ok = dbquery("DELETE FROM " . DB_PRP_NOTIFY . "" . " WHERE user_id='" . $userdata['user_id'] . "'" . " AND review_id='" . $review->id . "'");
}
$review->log_event(PRP_EV_SUBSCRIBE, 0);
}
if ($do_calc_avg) {
$ok = dbquery("UPDATE " . DB_PRP_DOWNLOADS . "\n\t\tSET\n\t\tavg_vote='" . prp_calc_avg_vote($review->id) . "',\n\t\tcount_votes='" . ff_db_count("(*)", DB_PRP_VOTES, "(review_id='" . $review->id . "')") . "'\n\t\tWHERE review_id='" . $review->id . "'");
} elseif ($do_calc_comments) {
$ok = dbquery("UPDATE " . DB_PRP_DOWNLOADS . "\n\t\tSET\n\t\tcount_comments='" . ff_db_count("(*)", DB_PRP_COMMENTS, "(review_id='" . $review->id . "')") . "'\n\t\tWHERE review_id='" . $review->id . "'");
} elseif ($do_calc_subscribers) {
$ok = dbquery("UPDATE " . DB_PRP_DOWNLOADS . "\n\t\tSET\n\t\tcount_subscribers='" . ff_db_count("(*)", DB_PRP_NOTIFY, "(review_id='" . $review->id . "')") . "'\n\t\tWHERE review_id='" . $review->id . "'");
}
if ($errors == 0) {
fallback($href);
}
function pdp_update_cat_downloads($cat_id)
{
$count = ff_db_count("(*)", DB_PDP_DOWNLOADS, "(cat_id='" . $cat_id . "' AND dl_status='" . PDP_PRO_ON . "')");
dbquery("UPDATE " . DB_PDP_CATS . "\n\t\tSET\n\t\tcount_downloads='" . $count . "'\n\t\tWHERE cat_id=" . $cat_id);
}
/*
* show all
*/
$query_id = dbquery("SELECT CHAR_LENGTH(license_text) AS length," . " license_id, license_name" . " FROM " . DB_PRP_LICENSES . "" . " ORDER BY license_name ASC");
if (dbrows($query_id)) {
echo "<table align='center' cellspacing='1' class='tbl-border'>\n<thead>\n<tr>\n\t<th class='tbl2' width='16'></th>\n\t<th class='tbl2' width='150'>" . $locale['PRP002'] . " [<a href='" . FUSION_SELF . "?new=1'>" . $locale['prp_new'] . "]</a></th>\n\t<th class='tbl2'>" . $locale['PRP801'] . "</th>\n\t<th class='tbl2' colspan='2'># " . $locale['prp_reviews'] . "</th>\n\t<th class='tbl2' width='16'></th>\n</tr>\n</thead>\n<tbody>";
} else {
if (!isset($_GET['new'])) {
fallback(FUSION_SELF . "?new=1");
}
echo "<p>" . $locale['PRP802'];
}
$lcount = 0;
while ($data = dbarray($query_id)) {
$id = $data['license_id'];
$count = ff_db_count("(*)", DB_PRP_DOWNLOADS, "(license_id='{$id}')");
if ($count) {
$del_icon = '<img src="../icons/nodelete.gif" alt="">';
} else {
$del_icon = '<a href="' . FUSION_SELF . '?id=' . $id . '&del=1"' . " title='" . $locale['prp_delete'] . "'>" . '<img src="../icons/editdelete.png" alt="' . $locale['prp_delete'] . '" title="' . $locale['prp_delete'] . '" class="noborder"></a>';
}
if ($count) {
$view_icon = '<a href="reviews.php?show=license&id=' . $id . '"><img src="../icons/viewmag.png" class="noborder" alt="' . $locale['prp_view'] . '" title="' . $locale['prp_view'] . '"></a>';
} else {
$view_icon = '';
}
echo '
<tr class="tbl' . (++$lcount % 2 + 1) . '">
<td>
<a href="' . FUSION_SELF . '?id=' . $id . '&edit=1"><img src="../icons/edit.png" alt="' . $locale['prp_edit'] . '" title="' . $locale['prp_edit'] . '" class="noborder"></a>
</td>
<td align="right">' . $locale['PRP458'] . ':</td>
<td><input type="text" class="textbox" name="max_pics" size="3"
value="' . $review->data['max_pics'] . '"></td>
<td><input type="submit" class="button" name="set_max_pics"
value="' . $locale['PRP453'] . '"></td>
</tr>
<tr>
<td align="right">' . $locale['PRP457'] . ':</td>
<td><input type="text" class="textbox" name="count" size="7"
value="' . $review->data['dl_count'] . '" /></td>
<td><input type="submit" class="button" name="setcount"
value="' . $locale['PRP453'] . '" /></td>
</tr>
<tr>
<td align="right">' . $locale['PRP061'] . ':</td>
<td>' . ff_db_count("(*)", DB_PRP_NOTIFY, "(review_id='" . $review->id . "')") . '</td>
<td></td>
</tr>
</tbody>
</table>
<fieldset>
<legend>' . $locale['prp_dir_files'] . ':</legend>
' . $prp->settings['upload_file'] . '
<select name="dir_files">' . $sel_dir_files . '
</select>
<input type="submit" class="button" name="set_dir_files"
value="' . $locale['PRP453'] . '" />
</fieldset>
</form>
<ul>';
if (iAWEC_POST) {
echo '
<li><a href="' . $path . '/edit_event.php">' . $locale['EC200'] . '</a></li>';
}
echo '
<li><a href="' . $path . '/my_events.php">' . $locale['EC204'] . '</a></li>
<li><a href="' . $path . '/my_logins.php">' . $locale['EC206'] . '</a></li>';
if (iSUPERADMIN) {
echo '
<li><a href="' . $path . '/admin.php">' . $locale['EC700'] . '</a></li>';
}
echo '
</ul>';
}
if (iAWEC_ADMIN && ff_db_count("(*)", AWEC_DB_EVENTS, "(ev_status='" . AWEC_PENDING . "')")) {
echo '
<p>
<div style="text-align:center;">
<strong><a href="' . $path . '/new_events.php">' . $locale['EC203'] . '</a></strong>
</div>
</p>';
}
/*
* show next x days
*/
if ($awec_settings['next_days_in_panel']) {
$from_time = $awec_now;
$to_time = $from_time + ($awec_settings['next_days_in_panel'] - 1) * 86400;
$events = array();
$needle = array('from' => date('Y-m-d', $from_time), 'to' => date('Y-m-d', $to_time));
$download->fallback_download();
}
require_once 'include/edit.php';
$action = FUSION_SELF . '?did=' . $download->id;
$pic = array('pic_id' => 0, 'pic_desc' => '', 'pic_url' => '');
if (isset($_GET['pic_id']) && isNum($_GET['pic_id'])) {
$res = dbquery("SELECT pic_id, pic_desc, pic_url\n\t\tFROM " . DB_PDP_IMAGES . "\n\t\tWHERE download_id='" . $download->id . "'\n\t\t\tAND pic_id='" . $_GET['pic_id'] . "'");
if (!dbrows($res)) {
fallback(FUSION_SELF . '?did=' . $download->id);
}
$pic = dbarray($res);
$action .= '&pic_id=' . $pic['pic_id'];
}
$upload_dir = $pdp->settings['upload_image'];
$upload_dir_access = is_writeable($upload_dir);
$more_pics = $download->data['max_pics'] == 0 || ff_db_count("(*)", DB_PDP_IMAGES, "download_id='" . $download->id . "'") < $download->data['max_pics'];
/****************************************************************************
* ACTION
*/
$do_pm = false;
$log = false;
$log_errno = 0;
$log_event = PDP_EV_INVALID;
if (isset($_POST['save']) && ($more_pics || $pic['pic_id'])) {
$pic['pic_desc'] = trim(stripinput($_POST['desc']));
$pic['pic_url'] = stripinput($_POST['url']);
// UPLOAD
if (isset($_FILES['upload']) && $_FILES['upload']['error'] != PDP_EFILE) {
$log_event = PDP_EV_PICUPLOAD;
/*FIXME
if(!$more_pics) {
}
}
// subscibers
echo '
<dt><strong>' . $locale['PRP061'] . ':</strong></dt>
<dd>' . ff_db_count("(*)", DB_PRP_NOTIFY, "(review_id='" . $review->id . "')") . '</dd>';
if ($do_del) {
$ok = dbquery("DELETE FROM " . DB_PRP_NOTIFY . "" . " WHERE review_id='" . $review->id . "'");
if ($ok) {
echo $deleted_msg;
}
}
// logs
echo '
<dt><strong>' . $locale['PRP454'] . ':</strong></dt>
<dd>' . ff_db_count("(*)", DB_PRP_LOG, "(review_id='" . $review->id . "')") . '</dd>';
if ($do_del) {
$ok = dbquery("DELETE FROM " . DB_PRP_LOG . " WHERE review_id='" . $review->id . "'");
if ($ok) {
echo $deleted_msg;
}
}
// files
$res = dbquery("SELECT file_url, file_id\n\tFROM " . DB_PRP_FILES . "\n\tWHERE review_id='" . $review->id . "'");
echo '
<dt><strong>' . $locale['PRP019'] . ':</strong></dt>
<dd>' . dbrows($res) . '</dd>';
if (dbrows($res) && !is_writeable($prp->settings['upload_file'])) {
echo "<dd><span class='small2'>" . str_replace("%s", "<b>" . $prp->settings['upload_file'] . "</b>", $locale['PRP885']) . "</span></dd>";
}
if (dbrows($res)) {
<input type="text" class="textbox" name="days" value="180" size="3">
<label>' . $locale['EC721'] . '</label>
<p>
<label><input type="checkbox" name="del_events" />
' . $locale['awec_confirm_del'] . '</label>
</p>
<input type="submit" class="button" value="' . $locale['EC305'] . '">
</form>';
closetable();
/****************************************************************************
* GUI
*/
opentable($locale['awec_old_events']);
$count = ff_db_count("(*)", AWEC_DB_EVENTS, "ev_repeat='0' AND CURDATE()>=ev_start");
echo '<p>
' . $locale['EC716_'] . '
</p>
' . $count . ' ' . $locale['EC001'] . '
<form method="get" action="' . FUSION_SELF . '">
<input type="hidden" name="days" value="0" />
<p>
<label><input type="checkbox" name="del_events" />
' . $locale['awec_confirm_del'] . '</label>
</p>
<input type="submit" class="button" value="' . $locale['EC305'] . '">
</form>';
require_once INCLUDES . 'photo_functions_include.php';
if (!$review->can_edit) {
$review->fallback_review();
}
require_once 'include/edit.php';
$action = FUSION_SELF . '?did=' . $review->id;
$pic = array('pic_id' => 0, 'pic_desc' => '', 'pic_url' => '');
if (isset($_GET['pic_id']) && isNum($_GET['pic_id'])) {
$res = dbquery("SELECT pic_id, pic_desc, pic_url\n\t\tFROM " . DB_PRP_IMAGES . "\n\t\tWHERE review_id='" . $review->id . "'\n\t\t\tAND pic_id='" . $_GET['pic_id'] . "'");
if (!dbrows($res)) {
fallback(FUSION_SELF . '?did=' . $review->id);
}
$pic = dbarray($res);
$action .= '&pic_id=' . $pic['pic_id'];
}
$more_pics = $review->data['max_pics'] == 0 || ff_db_count("(*)", DB_PRP_IMAGES, "review_id='" . $review->id . "'") < $review->data['max_pics'];
/****************************************************************************
* ACTION
*/
$do_pm = false;
$log = false;
$log_errno = 0;
$log_event = PRP_EV_INVALID;
if (isset($_POST['save'])) {
$pic['pic_desc'] = trim(stripinput($_POST['desc']));
// UPLOAD
if (isset($_FILES['upload']) && $_FILES['upload']['error'] != PRP_EFILE) {
$log_event = PRP_EV_PICUPLOAD;
if (!$more_pics) {
$review->log_event($log_event, PRP_EMAXREACHED);
fallback(FUSION_SELF . '?did=' . $review->id . '&errno=' . PRP_EMAXREACHED);
function set_status($status)
{
if ($status == $this->status) {
return true;
}
$ok = dbquery("UPDATE " . DB_PDP_DOWNLOADS . "" . " SET dl_status='" . $status . "'" . " WHERE download_id='" . $this->id . "'");
if ($this->status == PDP_PRO_ON || $status == PDP_PRO_ON) {
$count = ff_db_count("(*)", DB_PDP_DOWNLOADS, "(cat_id='" . $this->data['cat_id'] . "'" . " AND dl_status='" . PDP_PRO_ON . "')");
dbquery("UPDATE " . DB_PDP_CATS . " SET" . " count_downloads='" . $count . "'" . " WHERE cat_id='" . $this->data['cat_id'] . "'");
}
$this->status = $status;
return $ok;
}
}
}
// subscibers
echo '
<dt><strong>' . $locale['PDP061'] . ':</strong></dt>
<dd>' . ff_db_count("(*)", DB_PDP_NOTIFY, "(download_id='" . $download->id . "')") . '</dd>';
if ($do_del) {
$ok = dbquery("DELETE FROM " . DB_PDP_NOTIFY . "" . " WHERE download_id='" . $download->id . "'");
if ($ok) {
echo $deleted_msg;
}
}
// logs
echo '
<dt><strong>' . $locale['PDP454'] . ':</strong></dt>
<dd>' . ff_db_count("(*)", DB_PDP_LOG, "(download_id='" . $download->id . "')") . '</dd>';
if ($do_del) {
$ok = dbquery("DELETE FROM " . DB_PDP_LOG . " WHERE download_id='" . $download->id . "'");
if ($ok) {
echo $deleted_msg;
}
}
// files
$res = dbquery("SELECT file_url, file_id\n\tFROM " . DB_PDP_FILES . "\n\tWHERE download_id='" . $download->id . "'");
echo '
<dt><strong>' . $locale['PDP019'] . ':</strong></dt>
<dd>' . dbrows($res) . '</dd>';
if (dbrows($res) && !is_writeable($pdp->settings['upload_file'])) {
echo "<dd><span class='small2'>" . str_replace("%s", "<b>" . $pdp->settings['upload_file'] . "</b>", $locale['PDP885']) . "</span></dd>";
}
if (dbrows($res)) {
<td align="right">' . $locale['PDP458'] . ':</td>
<td><input type="text" class="textbox" name="max_pics" size="3"
value="' . $download->data['max_pics'] . '"></td>
<td><input type="submit" class="button" name="set_max_pics"
value="' . $locale['PDP453'] . '"></td>
</tr>
<tr>
<td align="right">' . $locale['PDP457'] . ':</td>
<td><input type="text" class="textbox" name="count" size="7"
value="' . $download->data['dl_count'] . '" /></td>
<td><input type="submit" class="button" name="setcount"
value="' . $locale['PDP453'] . '" /></td>
</tr>
<tr>
<td align="right">' . $locale['PDP061'] . ':</td>
<td>' . ff_db_count("(*)", DB_PDP_NOTIFY, "(download_id='" . $download->id . "')") . '</td>
<td></td>
</tr>
</tbody>
</table>
<fieldset>
<legend>' . $locale['pdp_dir_files'] . ':</legend>
' . $pdp->settings['upload_file'] . '
<select name="dir_files">' . $sel_dir_files . '
</select>
<input type="submit" class="button" name="set_dir_files"
value="' . $locale['PDP453'] . '" />
</fieldset>
</form>
case "1.7.9":
$new_ver = "1.7.10";
$set_tbl = DB_PREFIX . "pdp_settings";
//
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_downloads" . " ADD KEY (cat_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_downloads" . " ADD KEY (user_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_downloads" . " ADD KEY (license_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_comments" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_files" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_log" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_images" . " ADD KEY (download_id)";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_notify" . " ADD KEY (user_id, download_id)";
// count comments
$query_id = dbquery("SELECT download_id\n\t\tFROM " . DB_PREFIX . "pdp_downloads");
while ($row = dbarray($query_id)) {
$comm_count = ff_db_count("(*)", DB_PREFIX . "pdp_comments", "(download_id='" . $row['download_id'] . "')");
$mysql[] = "UPDATE " . DB_PREFIX . "pdp_downloads" . " SET" . " count_comments='" . $comm_count . "'" . " WHERE download_id='" . $row['download_id'] . "'";
}
break;
case '1.7.10':
$new_ver = '1.8.0';
$set_tbl = DB_PREFIX . "pdp_settings";
//
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_cats\n\t\tADD COLUMN cat_download_access tinyint(3) unsigned NOT NULL default '0'";
$mysql[] = "UPDATE " . DB_PREFIX . "pdp_cats\n\t\tSET\n\t\tcat_download_access=cat_access";
$mysql[] = "ALTER TABLE " . DB_PREFIX . "pdp_settings\n\t\tADD COLUMN download_restricted text NOT NULL";
$mysql[] = "UPDATE " . DB_PREFIX . "pdp_settings\n\t\tSET\n\t\tdownload_restricted='" . stripinput($locale['PDP407']) . "'";
/*!!!NO BREAK!!!*/
/*!!!NO BREAK!!!*/
case '1.8.0':
$new_ver = '1.8.1';
