".$message.""; closetable(); } $error = ""; if (!checkrights("KOM") || !defined("iAUTH") || !isset($_GET['aid']) || $_GET['aid'] != iAUTH) { redirect("../index.php"); } $editlist = ""; $sel = ""; $result2 = dbquery("SELECT * FROM ".$db_prefix."komanda_cats ORDER BY cat_name"); if (dbrows($result2) != 0) { while ($data2 = dbarray($result2)) { $editlist .= "".$data2['cat_name']."\n"; } } $userlist = ""; $useriai = ""; $result3 = dbquery("SELECT * FROM ".$db_prefix."users ORDER BY user_name"); if (dbrows($result3) != 0) { while ($data3 = dbarray($result3)) { $userlist .= "".$data3['user_name']."\n"; } } if(isset($_POST['do']) && $_POST['do'] == "doadd"){ if(!$_POST['slapyvardis']){ showmessage($locale['a21']); $error = 1; }else if(!$_POST['amzius']){ showmessage($locale['a22']); $error = 1; }else if(!$_POST['miestas']){ showmessage($locale['a23']); $error = 1; } else if(!$_POST['pareigos']){ showmessage($locale['a24']); $error = 1; } if ($error == "") { $sndyra = mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")); $newavatar = $_FILES['nuotrauka']; if (!empty($newavatar['name']) && is_uploaded_file($newavatar['tmp_name'])) { $avatarext = strrchr($newavatar['name'],"."); $avatarname = substr($newavatar['name'], 0, strrpos($newavatar['name'], ".")); if (preg_match("/^[-0-9A-Z_\[\]]+$/i", $avatarname) && preg_match("/(\.gif|\.GIF|\.jpg|\.JPG|\.png|\.PNG)$/", $avatarext) && $newavatar['size'] <= 1024*10000) { $avatarname = $avatarname."[".$userdata['user_id'].$sndyra."]".$avatarext; $set_avatar = $avatarname; move_uploaded_file($newavatar['tmp_name'], IMAGES."komanda/".$avatarname); chmod(IMAGES."komanda/".$avatarname,0644); if ($size = @getimagesize(IMAGES."komanda/".$avatarname)) { if ($size['0'] > 120 || $size['1'] > 120) { unlink(IMAGES."komanda/".$avatarname); $set_avatar = ""; } } else { unlink(IMAGES."komanda/".$avatarname); $set_avatar = ""; } } } if($set_avatar == ""){ showmessage($locale['a25']); }else{ $slapyvardis = $_POST['slapyvardis']; $amzius = $_POST['amzius']; $miestas = $_POST['miestas']; $pareigos = $_POST['pareigos']; $kontaktai = $_POST['kontaktai']; $laida = $_POST['laida']; $cat_id = $_POST['catid']; $user_id = $_POST['userid']; $vedejas = $_POST['vedejas']; $nuotrauka = $set_avatar; $result = dbquery("INSERT INTO ".$db_prefix."komanda (slapyvardis, amzius, miestas, pareigos, kontaktai, laida, cat_id, user_id, nuotrauka, vedejas) VALUES ('".$slapyvardis."', '".$amzius."', '".$miestas."', '".$pareigos."', '".$kontaktai."', '".$laida."', '".$cat_id."', '".$user_id."', '".$nuotrauka."', '".$vedejas."')"); showmessage($locale['a31']); } } } if(isset($_POST['do']) && $_POST['do'] == "del"){ $img = dbarray(dbquery("SELECT * FROM ".$db_prefix."komanda WHERE id = '".$_POST['id']."'")); $qery = dbquery("DELETE FROM ".$db_prefix."komanda WHERE id = ".$_POST['id'].""); unlink(IMAGES."komanda/".$img['nuotrauka']); showmessage($locale['a32']); } if(isset($_POST['do']) && $_POST['do'] == "edit"){ $komandosas = dbarray(dbquery("SELECT * FROM ".$db_prefix."komanda WHERE id = '".$_POST['id']."'")); $sel = ($komandosas['cat_id'] == $data2['cat_id'] ? " selected" : ""); $useriai = ($komandosas['user_id'] == $data3['user_id'] ? " selected" : ""); if(!$komandosas){ showmessage($locale['a26']); }else{ opentable($locale['a13']); echo '

'.$locale['a01'].'
'.$locale['a02'].'
'.$locale['a03'].'
'.$locale['a04'].'
'.$locale['a05'].'
'.$locale['a06'].'
'.$locale['a17'].'
'.$locale['a11'].'	'.$userlist.'
'.$locale['a12'].'	'.$editlist.'
'.$locale['a11'].'

'; closetable(); } } if(isset($_POST['do']) && $_POST['do'] == "doedit"){ $komandosas = dbarray(dbquery("SELECT * FROM ".$db_prefix."komanda WHERE id = '".$_POST['id']."'")); if(!$_POST['id'] or !$_POST['slapyvardis']){ showmessage($locale['a26']); }else if($_FILES["nuotrauka"]["error"] > 0){ $result = dbquery("UPDATE ".$db_prefix."komanda SET slapyvardis='".$slapyvardis."', amzius='".$amzius."', miestas='".$miestas."', pareigos='".$pareigos."', kontaktai='".$kontaktai."', laida='".$laida."', cat_id='".$cat_id."', user_id='".$user_id."', vedejas='".$vedejas."' WHERE id='".$_POST['id']."'"); showmessage($locale['a33']); }else{ if ($error == "") { $sndyra = mktime(date("H"),date("i"),date("s"),date("m"),date("d"),date("Y")); $newavatar = $_FILES['nuotrauka']; if (!empty($newavatar['name']) && is_uploaded_file($newavatar['tmp_name'])) { $avatarext = strrchr($newavatar['name'],"."); $avatarname = substr($newavatar['name'], 0, strrpos($newavatar['name'], ".")); if (preg_match("/^[-0-9A-Z_\[\]]+$/i", $avatarname) && preg_match("/(\.gif|\.GIF|\.jpg|\.JPG|\.png|\.PNG)$/", $avatarext) && $newavatar['size'] <= 1024*$goldsettings['maxbanner120x120size']) { $avatarname = $avatarname."[".$userdata['user_id'].$sndyra."]".$avatarext; $set_avatar = $avatarname; move_uploaded_file($newavatar['tmp_name'], IMAGES."komanda/".$avatarname); chmod(IMAGES."komanda/".$avatarname,0644); if ($size = @getimagesize(IMAGES."komanda/".$avatarname)) { if ($size['0'] > 120 || $size['1'] > 120) { unlink(IMAGES."komanda/".$avatarname); $set_avatar = ""; } } else { unlink(IMAGES."komanda/".$avatarname); $set_avatar = ""; } } } } if($set_avatar == ""){ showmessage($locale['a25']); }else{ $result = dbquery("UPDATE ".$db_prefix."komanda SET slapyvardis='".$slapyvardis."', amzius='".$amzius."', miestas='".$miestas."', pareigos='".$pareigos."', kontaktai='".$kontaktai."', laida='".$laida."', cat_id='".$cat_id."', user_id='".$user_id."', vedejas='".$vedejas."', nuotrauka='".$set_avatar."' WHERE id='".$_POST['id']."'"); unlink(IMAGES."komanda/".$komandosas['nuotrauka']); showmessage($locale['a31']); } } } opentable($locale['a14']); echo '

'.$locale['a01'].'
'.$locale['a02'].'
'.$locale['a03'].'
'.$locale['a04'].'
'.$locale['a05'].'
'.$locale['a06'].'
'.$locale['a17'].'
'.$locale['a07'].'	'.$userlist.'
'.$locale['a12'].'	'.$editlist.'
'.$locale['a11'].'

'; closetable(); opentable($locale['k00']); if(dbcount("(*)", DB_PREFIX."komanda") > 0){ if(dbcount("(*)", DB_PREFIX."komanda", "cat_id=1") > 0) { $kad = dbquery("SELECT * from ".DB_PREFIX."komanda WHERE cat_id = '1'"); while($kads = dbarray($kad)) { echo '

Administracija
'; echo ''; echo ' '; echo $locale['k01'].' '.$kads['slapyvardis'].' '; echo ($kads['amzius'] == "" ? "" : "".$locale['k02']." ".$kads['amzius']." "); echo ($kads['miestas'] == "" ? "" : "".$locale['k03']." ".$kads['miestas']." "); echo ($kads['laida'] == "" ? "" : "".$locale['k06']." ".$kads['laida']." "); echo $locale['k04'].' '.$kads['pareigos'].' '; echo $locale['k05'].' '.$kads['kontaktai'].' '; echo '

'; } } else { echo "".$locale['a35'].""; } if(dbcount("(*)", DB_PREFIX."komanda", "cat_id=2") > 0) { $kdj = dbquery("SELECT * from ".DB_PREFIX."komanda WHERE cat_id = '2'"); while($kdjs = dbarray($kdj)) { echo '

Administracija
'; echo ''; echo ' '; echo $locale['k01'].' '.$kdjs['slapyvardis'].' '; echo ($kdjs['amzius'] == "" ? "" : "".$locale['k02']." ".$kdjs['amzius']." "); echo ($kdjs['miestas'] == "" ? "" : "".$locale['k03']." ".$kdjs['miestas']." "); echo ($kdjs['laida'] == "" ? "" : "".$locale['k06']." ".$kdjs['laida']." "); echo $locale['k04'].' '.$kdjs['pareigos'].' '; echo $locale['k05'].' '.$kdjs['kontaktai'].' '; echo '

'; } } else { echo "".$locale['a36'].""; } }else{ echo "".$locale['a34'].""; } closetable(); require_once THEMES."templates/footer.php"; ?>