<?php
require_once "../../maincore.php";
require_once THEMES."templates/admin_header.php";
require_once INFUSIONS."atp_zaidejai/infusion_db.php";
require_once INCLUDES."html_buttons_include.php";
if (!checkrights("FLP") || !defined("iAUTH") || $_GET['aid'] != iAUTH) { redirect("../index.php"); }
if (file_exists(INFUSIONS."atp_zaidejai/locale/".$settings['locale'].".php")) {
	include INFUSIONS."atp_zaidejai/locale/".$settings['locale'].".php";
} else {
	include INFUSIONS."atp_zaidejai/locale/English.php";
}
if (isset($_GET['status']) && !isset($message)) {

   if ($_GET['status'] == "sn") {

      $message = $locale['zaid_010'];

   } elseif ($_GET['status'] == "su") {

      $message = $locale['zaid_011'];

   } elseif ($_GET['status'] == "deln") {

      $message = $locale['zaid_012']."<br />\n<span class='small'>".$locale['zaid_015']."</span>";

   } elseif ($_GET['status'] == "dely") {

      $message = $locale['zaid_013'];

   }

   if ($message) {   echo "<div class='admin-message'>".$message."</div>\n"; }

}

opentable ($locale['zaid_014']);

require_once INFUSIONS."atp_zaidejai/inc/panel_tab.php";

closetable();

if ((isset($_GET['action']) && $_GET['action'] == "delete") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

   $result = dbquery("SELECT * FROM ".DB_ATP_ZAID." WHERE zaid_id='".$_GET['zaid_id']."'");

   if (dbrows($result) != 0) {
      $result = dbquery("DELETE FROM ".DB_ATP_ZAID." WHERE zaid_id='".$_GET['zaid_id']."'");
      redirect(FUSION_SELF.$aidlink."&status=deln");

   } else {
      redirect(FUSION_SELF.$aidlink."&status=dely");
   }

} else {

   if (isset($_POST['save_cat'])) {

      $pav_var = stripinput($_POST['pav_var']);

      $reit = stripinput($_POST['reit']);

        $amzius = stripinput($_POST['amzius']);

      $gim_vieta = stripinput($_POST['gim_vieta']);

        $gyv_vieta = stripinput($_POST['gyv_vieta']);

        $ugis = stripinput($_POST['ugis']);

        $svoris = stripinput($_POST['svoris']);

        $ranka = stripinput($_POST['ranka']);

        $sporte_nuo = stripinput($_POST['sporte_nuo']);

        $treneris = stripinput($_POST['treneris']);

      $info = addslash($_POST['info']);

      $laimejimai = addslash($_POST['laimejimai']);

      if ($pav_var) {

         if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

            $result = dbquery("UPDATE ".DB_ATP_ZAID." SET (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES ('".$pav_var."', '".$reit."', '".$amzius."', '".$gim_vieta."', '".$gyv_vieta."', '".$ugis."', '".$svoris."', '".$ranka."', '".$sporte_nuo."', '".$treneris."', '".$info."', '".$laimejimai."') WHERE zaid_id='".$_GET['zaid_id']."'");

            redirect(FUSION_SELF.$aidlink."&status=su");

         } else {

            $result = dbquery("INSERT INTO ".DB_ATP_ZAID." (zaid_pav_var, zaid_reit, zaid_amzius, zaid_gim_vieta, zaid_gyv_vieta, zaid_ugis, zaid_svoris, zaid_ranka, zaid_sporte_nuo, zaid_treneris, zaid_info, zaid_laimejimai) VALUES('".$pav_var."', '".$reit."', '".$amzius."', '".$gim_vieta."', '".$gyv_vieta."', '".$ugis."', '".$svoris."', '".$ranka."', '".$sporte_nuo."', '".$treneris."', '".$info."', '".$laimejimai."')");

            redirect(FUSION_SELF.$aidlink."&status=sn");

         }

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   }

   if ((isset($_GET['action']) && $_GET['action'] == "edit") && (isset($_GET['zaid_id']) && isnum($_GET['zaid_id']))) {

      $result = dbquery("SELECT * FROM ".DB_ATP_ZAID." WHERE zaid_id='".$_GET['zaid_id']."'");

      if (dbrows($result)) {

         $data = dbarray($result);

         $pav_var = $data['zaid_pav_var'];

         $reit = $data['zaid_reit'];

            $amzius = $data['zaid_amzius'];

         $gim_vieta = $data['zaid_gim_vieta'];

            $gyv_vieta = $data['zaid_gyv_vieta'];

            $ugis = $data['zaid_ugis'];

            $svoris = $data['zaid_svoris'];

            $ranka = $data['zaid_ranka'];

            $sporte_nuo = $data['zaid_sporte_nuo'];

            $treneris = $data['zaid_treneris'];

         $info = $data['zaid_info'];

         $laimejimai = $data['zaid_laimejimai'];

 

         $formaction = FUSION_SELF.$aidlink."&action=edit&zaid_id=".$data['zaid_id'];

         opentable($locale['zaid_016']);

      } else {

         redirect(FUSION_SELF.$aidlink);

      }

   } else {

      $pav_var = "";

      $reit = "";

      $amzius = "";

      $gim_vieta = "";

        $gyv_vieta = "";

        $ugis = "";

        $svoris = "";

        $ranka = "";

        $sporte_nuo = "";

        $treneris = "";

      $info = "";

      $laimejimai = "";

      $formaction = FUSION_SELF.$aidlink;

      opentable($locale['zaid_009']);

   }

	echo "<form name='addcat' method='post' action='$formaction'>\n";
	echo "<table cellpadding='0' cellspacing='0' width='520' class='center'>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_000']."</td>\n";
	echo "<td class='tbl'><input type='text' name='pav_var' value='".$pav_var."' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_028']."</td>\n";
	echo "<td class='tbl'><input type='text' name='reit' value='".$reit."' class='textbox' style='width:30px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_001']."</td>\n";
	echo "<td class='tbl'><input type='text' name='amzius' value='".$amzius."' class='textbox' style='width:100px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_002']."</td>\n";
	echo "<td class='tbl'><input type='text' name='gim_vieta' value='".$gim_vieta."' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_003']."</td>\n";
	echo "<td class='tbl'><input type='text' name='gyv_vieta' value='".$gyv_vieta."' class='textbox' style='width:250px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_004']."</td>\n";
	echo "<td class='tbl'><input type='text' name='ugis' value='".$ugis."' class='textbox' style='width:50px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_005']."</td>\n";
	echo "<td class='tbl'><input type='text' name='svoris' value='".$svoris."' class='textbox' style='width:50px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_006']."</td>\n";
	echo "<td class='tbl'><input type='text' name='ranka' value='".$ranka."' class='textbox' style='width:50px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_007']."</td>\n";
	echo "<td class='tbl'><input type='text' name='sporte_nuo' value='".$sporte_nuo."' class='textbox' style='width:50px;' /></td>\n";
echo "</tr>\n<tr>\n";
	echo "<td width='1%' class='tbl' style='white-space:nowrap'>".$locale['zaid_008']."</td>\n";
	echo "<td class='tbl'><input type='text' name='treneris' value='".$treneris."' class='textbox' style='width:150px;' /></td>\n";
	echo "</tr>\n<tr>\n";
	
	echo "<td valign='top' width='200' class='tbl'>".$locale['zaid_026']."</td>\n";
	echo "<td class='tbl'><textarea name='info' cols='60' rows='10' class='textbox' style='width:340px;'>".$info."</textarea></td>\n";
	echo "</tr>\n<tr>\n";
	echo "<td class='tbl'></td><td class='tbl'>\n";
	echo display_html("inputform", "zaid_info", true)."</td>\n";
	echo "</tr>\n<tr>\n";
	echo "<td valign='top' width='200' class='tbl'>".$locale['zaid_027']."</td>\n";
	echo "<td class='tbl'><textarea name='laimejimai' cols='60' rows='10' class='textbox' style='width:340px;'>".$laimejimai."</textarea></td>\n";
	echo "</tr>\n<tr>\n";
	echo "<td class='tbl'></td><td class='tbl'>\n";
	echo display_html("inputform", "zaid_laimejimai", true)."</td>\n";
	echo "</tr>\n<tr>\n";
	
	echo "<td align='center' colspan='2' class='tbl'>\n";
	echo "<input type='submit' name='save_cat' value='".$locale['zaid_017']."' class='button' /></td>\n";
	echo "</tr>\n</table>\n</form>\n";
	closetable();

	opentable($locale['zaid_018']);
	echo "<table width='520' cellspacing='1' cellpadding='0' class='tbl-border center'>\n";
	$result = dbquery("SELECT * FROM ".DB_ATP_ZAID." ORDER BY zaid_pav_var");
	if (dbrows($result) != 0) {
		$i = 0;
		echo "<tr>\n";
		echo "<td class='tbl2'><b>".$locale['zaid_019']."</b></td>\n";
		echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['zaid_014']."</b></td>\n";
		echo "</tr>\n";
		while ($data = dbarray($result)) {
			$cell_color = ($i % 2 == 0 ? "tbl1" : "tbl2");
			echo "<tr>\n";
			echo "<td class='".$cell_color."'>".$data['zaid_pav_var']."<br />\n";
			echo "<td align='center' width='1%' class='$cell_color' style='white-space:nowrap'><a href='".FUSION_SELF.$aidlink."&action=edit&zaid_id=".$data['zaid_id']."'>".$locale['zaid_020']."</a> -\n";
			echo "<a href='".FUSION_SELF.$aidlink."&action=delete&zaid_id=".$data['zaid_id']."' onclick=\"return confirm('".$locale['zaid_021']."');\">".$locale['zaid_022']."</a></td>\n";
			echo "</tr>\n";
			$i++;
		}
		echo "</table>\n";
	} else {
		echo "<tr><td align='center' class='tbl1'>".$locale['zaid_024']."</td></tr>\n</table>\n";
	}
	require_once INFUSIONS."atp_zaidejai/inc/copy.php";
	closetable();
}

require_once THEMES."templates/footer.php";
?>