<?php

/*---------------------------------------------------+

|    <span style="border-bottom: 1px dotted black;">PHP</span>-Fusion 6 Content Management System

+---------------------------------------------------------+

|    Copyright (c) 2005 Nick Jones

|    <a href='http://www.php-fusion.co.uk/' target='_blank'><span style='color:005C5B'>http://www.php-fusion.co.uk/</span></a>

+---------------------------------------------------------+

|    Released under the terms & conditions of v2 of the

|    GNU General Public License. For details refer to

|    the included gpl.txt file or visit <a href='http://gnu.org' target='_blank'><span style='color:005C5B'>http://gnu.org</span></a>

+---------------------------------------------------------*/

require_once "maincore.php";

require_once "subheader.php";

require_once "side_left.php";

include LOCALE.LOCALESET."admin/downloads.php";

 

 

$result = dbquery("SELECT * FROM ".$db_prefix."download_cats");

if (dbrows($result) != 0) {

   if ($step == "delete") {

      $result = dbquery("DELETE FROM ".$db_prefix."downloads WHERE download_id='$download_id'");

      redirect("news.php");

 

 

    }

    if (isset($_POST['save_download'])) {

        $download_title = stripinput($_POST['download_title']);

        $download_description = addslash($_POST['download_description']);

        $download_url = stripinput($_POST['download_url']);

        $download_license = stripinput($_POST['download_license']);

        $download_os = stripinput($_POST['download_os']);

        $download_version = stripinput($_POST['download_version']);

        $download_filesize = stripinput($_POST['download_filesize']);

    if ($step == "edit") {

         $download_datestamp = isset($_POST['update_datestamp']) ? ", download_datestamp='".time()."'" : "";

         $result = dbquery("UPDATE ".$db_prefix."downloads SET download_title='$download_title', download_description='$download_description', download_url='$download_url', download_cat='$download_cat', download_license='$download_license', download_os='$download_os', download_version='$download_version', download_filesize='$download_filesize'".$download_datestamp." WHERE download_id='$download_id'");

         redirect("news.php");

      } else {

         $result = dbquery("INSERT INTO ".$db_prefix."downloads (download_title, download_description, download_url, download_cat, download_license, download_os, download_version, download_filesize, download_datestamp, download_count) VALUES ('$download_title', '$download_description', '$download_url', '$download_cat', '$download_license', '$download_os', '$download_version', '$download_filesize', '".time()."', '0')");

         redirect("news.php");

        }

    }

    if ($step == "edit") {

        $result = dbquery("SELECT * FROM ".$db_prefix."downloads WHERE download_id='$download_id'");

        $data = dbarray($result);

        $download_title = $data['download_title'];

        $download_description = stripslashes($data['download_description']);

        $download_url = $data['download_url'];

        $download_license = $data['download_license'];

        $download_os = $data['download_os'];

        $download_version = $data['download_version'];

        $download_filesize = $data['download_filesize'];

        $formaction = FUSION_SELF.$aidlink."&amp;step=edit&amp;download_cat_id=$download_cat_id&amp;download_id=$download_id";

        opentable($locale['470']);

    } else {

        $download_title = "";

        $download_description = "";

        $download_url = "";

        $download_license = "";

        $download_os = "";

        $download_version = "";

        $download_filesize = "";

        $formaction = FUSION_SELF.$aidlink;

        opentable($locale['471']);

    }

    $editlist = ""; $sel = "";

    $result2 = dbquery("SELECT * FROM ".$db_prefix."download_cats ORDER BY download_cat_name");

    if (dbrows($result2) != 0) {

        while ($data2 = dbarray($result2)) {

            if ($step == "edit") $sel = ($data['download_cat'] == $data2['download_cat_id'] ? " selected" : "");

            $editlist .= "<option value='".$data2['download_cat_id']."'$sel>".$data2['download_cat_name']."</option>\n";

        }

    }

    echo "<form name='inputform' method='post' action='$formaction'>

<table align='center' cellpadding='0' cellspacing='0' width='460'>

<tr>

<td width='80' class='tbl'>".$locale['480']."</td>

<td class='tbl'><input type='text' name='download_title' value='$download_title' class='textbox' style='width:380px;'></td>

</tr>

<tr>

<td width='80' class='tbl'>".$locale['482']."</td>

<td class='tbl'><input type='text' name='download_url' value='$download_url' class='textbox' style='width:380px;'></td>

</tr>

<tr>

<td width='80' class='tbl'>".$locale['483']."</td>

<td class='tbl'><select name='download_cat' class='textbox'>

$editlist</select></td>

</tr>

<tr>

<td align='center' colspan='2' class='tbl'>";

    if ($step == "edit") echo "<input type='checkbox' name='update_datestamp' value='1'> ".$locale['489']."<br><br>\n";

    echo "<input type='submit' name='save_download' value='".$locale['488']."' class='button'></td>

</tr>

</table>

</form>\n";

    closetable();

 

 

 

}

 

echo "</td>\n";

require_once "side_right.php";

require_once BASEDIR."footer.php";

?>