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';