Advertisement
Guest User

Untitled

a guest
Feb 8th, 2016
88
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
PHP 11.50 KB | None | 0 0
  1. <?php
  2.  
  3.  
  4. if ($_SESSION[giris] == '' || $_SESSION[giris_rand] == '') {
  5. echo'<h1>Yetki Yok</h1>';
  6. }elseif ($_SESSION[giris]!=$_SESSION[giris_rand]) {echo'<h1>Yetki Yok</h1>';}
  7. else {
  8.  
  9.  
  10. $durum = mysql_real_escape_string($_GET[durum]);
  11. //Tüm Bannerlar
  12. if ($durum == 'goster') {
  13. echo'<h3 class="reallynow"><span>Tüm Bannerlar</span></h3>
  14. <ul class="liste">';
  15.  
  16. $sql = mysql_query("select * from $banner_tbl order by id desc");
  17. while ($row = mysql_fetch_array($sql)){
  18.  
  19. echo'<li><label for="" class="label1" style="width:800px;float:left;">
  20. <span style="float:left;width:300px;">'.$row[isim].'</span>
  21. <span style="float:left;width:300px;">'.$row[width].'/'.$row[height].'px</span>
  22. <span style="float:left;width:100px;">';
  23. if ($row[tip] == '1') {echo'Sadece Resim';}
  24. elseif ($row[tip] == '2') {echo'JQuery Slider';}
  25. elseif ($row[tip] == '3') {echo'Cu3er';}
  26. echo'</span>
  27. </label><div style="text-align:right">';
  28.  
  29.  
  30. if ($GLOBALS[banner_silme]=="1") {
  31. echo'<label class="label2"><a onclick="return confirm(\"Silmek istiyormusunuz?\");" href= "index.php?islem=banner&durum=sil&id='.$row[id].'"><img title="Sil" src= "img/delete.png" style="height:12px;"/></a></label>'; }
  32.  
  33. if ($GLOBALS[banner_duzenleme]=="1") {
  34. echo'<label class="label2"><a href= "index.php?islem=banner&durum=duzenle&id='.$row[id].'"><img title="Düzenle" src= "img/edit.png" style="height:12px;"/></a></label>'; }
  35.  
  36. if ($GLOBALS[banner_resim_ekle]=="1") {
  37. echo'<label class="label2"><a href= "index.php?islem=banner&durum=resim_ekle&id='.$row[id].'"><img title="Resim Ekle" src= "img/image.png" style="height:12px;"/></a></label>'; }
  38.  
  39. echo'</div></li>';
  40. }
  41. echo'</ul>';
  42. }
  43. //Banner Ekle
  44. elseif ($durum == 'ekle') {
  45. echo'<h3 class="reallynow"><span>Banner Ekle</span></h3>
  46. <ul class="listee">';
  47. echo'
  48. <form action="" method="post">';
  49.  
  50.  
  51. echo'
  52. <li><label class="formlabel1">Banner İsmi</label><input name="isim" type="text" class="admin-input"/></li>
  53.  
  54. <li><label class="formlabel1">Boyutlar</label> <input name="width" style="width:30px;margin-right:0px;" type="text" class="admin-input"/>-<input name="height" style="width:30px;margin-right:5px;" type="text" class="admin-input"/>px</li>
  55.  
  56. <li><label class="formlabel1">Banner Tipi</label>
  57. <select class="secimkutusu" name="tip">
  58. <option value="1">Sadece Resim</option>
  59. <option value="2">Jquery Slider</option>
  60. </select>
  61. </li>';
  62.  
  63.  
  64. echo'
  65. <li><label class="formlabel1"></label><input type="submit" name="submit" value="Kaydet" class="admin-button"/></li>
  66. </form>
  67. ';
  68. echo'</ul>';
  69.  
  70. if ($_POST[submit]) {
  71.  
  72. $ekle = mysql_query("insert into $banner_tbl (isim,width,height,tip)values('$_POST[isim]','$_POST[width]','$_POST[height]','$_POST[tip]')");
  73. header("location:index.php?islem=banner&durum=goster");
  74. }
  75. }
  76.  
  77. //Banner Düzenle
  78. elseif ($durum == 'duzenle') {
  79. $id=mysql_real_escape_string($_GET[id]);
  80. $bilgi = mysql_fetch_array(mysql_query("select * from $banner_tbl where id = '$id'"));
  81. echo'<h3 class="reallynow"><span>Banner Düzenle</span></h3>
  82. <ul class="listee">';
  83. echo'
  84. <form action="" method="post">
  85. <li><label class="formlabel1">Banner İsmi</label><input value="'.$bilgi[isim].'" name="isim" type="text" class="admin-input"/></li>
  86.  
  87. <li><label class="formlabel1">Boyutlar</label> <input name="width" value="'.$bilgi[width].'" style="width:30px;margin-right:0px;" type="text" class="admin-input"/>-<input name="height" value="'.$bilgi[height].'" style="width:30px;margin-right:5px;" type="text" class="admin-input"/>px</li>
  88.  
  89. <li><label class="formlabel1">Banner Tipi</label>
  90. <select class="secimkutusu" name="tip">
  91. <option value="1" '; if ($bilgi[tip] == '1') {echo'selected="selected" ';}echo'>Sadece Resim</option>
  92. <option value="2" '; if ($bilgi[tip] == '2') {echo'selected="selected" ';}echo'>Jquery Slider</option>
  93. </select>
  94. <input type="hidden" name="id" value="'.$id.'"/>
  95. </li>
  96.  
  97. <li><label class="formlabel1"></label><input type="submit" name="submit" value="Kaydet" class="admin-button"/></li>
  98. </form>
  99. ';
  100. echo'</ul>';
  101.  
  102. if ($_POST[submit]) {
  103. $update = mysql_query("update $banner_tbl set isim = '$_POST[isim]',width = '$_POST[width]',height = '$_POST[height]', tip = '$_POST[tip]' where id = '$_POST[id]'");
  104. header("location:index.php?islem=banner&durum=goster");
  105. }
  106. }
  107. //Resim ekle
  108. elseif ($durum == 'resim_ekle'){
  109. echo'<h3 class="reallynow"><span>Resim Ekle</span></h3>';
  110. echo'<ul class="listee">';
  111. $id=mysql_real_escape_string($_GET[id]);
  112. $sira_sql = mysql_fetch_array(mysql_query("select * from $banner_resim_tbl where banner_id = '$id' order by sira desc"));
  113. $sira = $sira_sql[sira]+1;
  114.  
  115. if ($GLOBALS[banner_resim_ekle]=="1") {
  116. echo'
  117. <form action="" method="post" enctype="multipart/form-data">
  118. <li><label class="formlabel1">Banner Resmi</label><input name="resim" type="file" style="border:none;font-family:tahoma;font-size:11px;" class="admin-input"/></li>
  119.  
  120. <li><label class="formlabel1">Sıra</label><input name="sira" type="text" value="'.$sira.'" style="width:100px;" class="admin-input"/></li>';
  121.  
  122. for ($g=0;$g<=$dilsay;$g++){
  123. $d='dil_'.$g;
  124. $dil=$site[$d];
  125. if ($dil!=''){
  126. echo'<li><label class="formlabel1">Banner Açıklama ('.$dil.')</label><textarea name="aciklama_'.$g.'" style="width:300px;font-size:11px; font-family:tahoma; height:30px;border:1px solid #C3D7DB; "></textarea></li>';
  127. }}
  128.  
  129.  
  130. echo'
  131. <li><label class="formlabel1"></label><input type="submit" name="submit" value="Kaydet" class="admin-button"/></li>
  132. </form>
  133. '; }
  134. if ($_POST[submit]) {
  135.  
  136. if ($_FILES[resim][tmp_name]) {
  137. $uzanti = strstr($_FILES[resim]['name'], '.');
  138. $name=time();
  139. $names="up/".$name.$uzanti;
  140. $file = '../up/'.$name.$uzanti;
  141. if ($uzanti == '.jpg' || $uzanti == '.JPG' || $uzanti == '.gif' || $uzanti == '.GIF' || $uzanti == '.png' || $uzanti == '.PNG') {
  142. move_uploaded_file($_FILES[resim][tmp_name],$file);
  143. }
  144. $resim_ekle_kayit = mysql_query("insert into $banner_resim_tbl (banner_id,resim,sira,aciklama_0,aciklama_1,aciklama_2,aciklama_3,aciklama_4,aciklama_5,aciklama_6) values ('$id','$names','$sira','$_POST[aciklama_0]','$_POST[aciklama_1]','$_POST[aciklama_2]','$_POST[aciklama_3]','$_POST[aciklama_4]','$_POST[aciklama_5]','$_POST[aciklama_6]')");
  145. $header="index.php?islem=banner&durum=resim_ekle&id=$id";
  146. header("location:$header");
  147. }
  148. }
  149. echo'
  150. <div style="float:left; width:100%; height:auto; margin-top:10px;">
  151. ';
  152. $sql = mysql_query("select * from $banner_resim_tbl where banner_id = '$id' order by sira asc");
  153. while ($row = mysql_fetch_array($sql)){
  154. echo'<div style="width:940px; height:100px; margin-bottom:10px;"><img src= "../'.$row[resim].'" style="height:100px; max-width:600px;float:left;"/>';
  155.  
  156. if ($GLOBALS[banner_resim_ekle]=="1") {
  157. echo'
  158. <div style="float:left;width:150px; margin-left:10px; height:60px;padding-top:40px;">
  159.  
  160. <a href= "index.php?islem=banner&durum=resim_duzenle&gel='.$id.'&id='.$row[id].'"><img src= "img/edit.png" style="height:12px;" title="Düzenle"/></a>
  161.  
  162.  
  163. <a onclick="return confirm(\\'Silmek istiyormusunuz?\\');" href= "index.php?islem=banner&durum=resim_sil&gel='.$_GET[id].'&id='.$row[id].'"><img src= "img/delete.png" style="height:12px;" title="Sil"/></a>
  164.  
  165. <form action="" method="post" style="display:inline">
  166. <input type="text" name="sira" value="'.$row[sira].'" style="width:30px;margin-left:10px;padding:2px;font-size:11px; font-family:tahoma;"/>
  167. <input type="submit" name="sira_submit" value="Kaydet" style="font-weight:bold;padding:2px;"/>
  168. <input type="hidden" value="'.$row[id].'" name="id"/>
  169. </form>
  170. ';
  171.  
  172. if ($_POST[sira_submit]) {
  173.      
  174. $site = mysql_query("update $banner_resim_tbl set sira = '$_POST[sira]' where id ='$_POST[id]'");
  175. echo "update $banner_resim_tbl set sira = '$_POST[sira]' where id ='$_POST[id]'";
  176. header("location:index.php?islem=banner&durum=resim_ekle&id=$_GET[id]");
  177.  
  178. }
  179.  
  180. echo'</div></div>';}}
  181. echo'</div>';
  182. }
  183. //Banner Düzenle
  184. elseif ($durum == 'resim_duzenle') {
  185.  
  186. echo'<h3 class="reallynow"><span>Resim Düzenle</span></h3>';
  187. echo'<ul class="listee">';
  188. $id=mysql_real_escape_string($_GET[id]);
  189. $bilgi = mysql_fetch_array(mysql_query("select * from $banner_resim_tbl where id = '$id'"));
  190.  
  191. echo'
  192. <form action="" method="post" enctype="multipart/form-data">
  193. <li><label class="formlabel1">Banner Resmi</label><input name="resim" type="file" style="border:none;font-family:tahoma;font-size:11px;" class="admin-input"/></li>
  194.  
  195. <li><label class="formlabel1">Sıra</label><input name="sira" type="text" value="'.$bilgi[sira].'" style="width:100px;" class="admin-input"/></li>';
  196.  
  197. for ($g=0;$g<=$dilsay;$g++){
  198. $d='dil_'.$g;
  199. $dil=$site[$d];
  200. if ($dil!=''){
  201. echo'<li><label class="formlabel1">Banner Açıklama ('.$dil.')</label><textarea name="aciklama_'.$g.'" style="width:300px;font-size:11px; font-family:tahoma; height:30px;border:1px solid #C3D7DB; ">'.$bilgi[aciklama_.$g].'</textarea></li>';
  202. }}
  203.  
  204. echo'
  205. <li><label class="formlabel1"></label><input type="submit" name="submit" value="Kaydet" class="admin-button"/></li>
  206. </form>
  207. ';
  208.  
  209. if ($_POST[submit]) {
  210.  
  211. if ($_FILES[resim][tmp_name]) {
  212. $uzanti=substr($_FILES['resim']['name'],-3);
  213. $name=time();
  214. $names="up/".$name.'.'.$uzanti;
  215. $file = '../up/'.$name.'.'.$uzanti;
  216. if($uzanti=="png" || $uzanti=="PNG" || $uzanti=="jpg" || $uzanti=="JPG" || $uzanti=="gif" || $uzanti="GIF")
  217. {move_uploaded_file($_FILES[resim][tmp_name],$file);
  218.  
  219. $resim_bul_sql = mysql_fetch_array(mysql_query("select * from $banner_resim_tbl where id ='$id'"));
  220. $resim_sil = "../".$resim_bul_sql[resim];
  221. unlink($resim_sil);
  222.  
  223. $update = mysql_query("update $banner_resim_tbl set resim = '$names',aciklama_0 = '$_POST[aciklama_0]',aciklama_1 = '$_POST[aciklama_1]',aciklama_2 = '$_POST[aciklama_2]',aciklama_3 = '$_POST[aciklama_3]',aciklama_4 = '$_POST[aciklama_4]',aciklama_5 = '$_POST[aciklama_5]',aciklama_6 = '$_POST[aciklama_6]',sira = '$_POST[sira]' where id ='$id'");
  224. header("location:index.php?islem=banner&durum=resim_ekle&id=$_GET[gel]");
  225.  
  226. }}else{
  227.  
  228. $update = mysql_query("update $banner_resim_tbl set aciklama_0 = '$_POST[aciklama_0]',aciklama_1 = '$_POST[aciklama_1]',aciklama_2 = '$_POST[aciklama_2]',aciklama_3 = '$_POST[aciklama_3]',aciklama_4 = '$_POST[aciklama_4]',aciklama_5 = '$_POST[aciklama_5]',aciklama_6 = '$_POST[aciklama_6]',sira = '$_POST[sira]' where id ='$id'");
  229. header("location:index.php?islem=banner&durum=resim_ekle&id=$_GET[gel]");
  230.  
  231.  
  232. }
  233.  
  234.  
  235.  
  236. }
  237.  
  238.  
  239.  
  240. }
  241. //Banner Sİl
  242. elseif ($durum == 'resim_sil') {
  243. $id=mysql_real_escape_string($_GET[id]);
  244. $gel=mysql_real_escape_string($_GET[gel]);
  245. $sil_sql = mysql_fetch_array(mysql_query("select * from $banner_resim_tbl where id = '$id'"));
  246. $sil = "../".$sil_sql[resim];
  247. unlink($sil);
  248. $silim = mysql_query("delete from $banner_resim_tbl where id = '$id'");
  249.  
  250. $sql=mysql_query("Select * from $banner_resim_tbl where banner_id='$gel' order by sira ASC ");
  251. $x=1;
  252. while ($str=mysql_fetch_array($sql)) {
  253. mysql_query("Update $banner_resim_tbl set sira='$x' where id='$str[id]'");
  254. $x++;    
  255. }
  256. //$toplam_resim_sayi = mysql_num_rows(mysql_query("select * from $banner_resim_tbl where banner_id = '$sil_sql[banner_id]'"));
  257. //echo $toplam_resim_sayi;
  258.  
  259. //for ($i=1;$i<=$toplam_resim_sayi;$i++){
  260.  
  261.  
  262.  
  263. //}
  264.  
  265. $head = "index.php?islem=banner&durum=resim_ekle&id=$_GET[gel]";
  266. header("location:$head");
  267. }
  268. //Banner Grup Sil
  269. elseif ($durum == 'sil') {
  270. $id=mysql_real_escape_string($_GET[id]);
  271. $bul_sql = mysql_query("select * from $banner_resim_tbl where banner_id = '$id'");
  272. while ($bul = mysql_fetch_array($bul_sql)){
  273. $sil = "../".$bul[resim];
  274. echo $sil;
  275. unlink($sil);
  276. }
  277. $sil1 = mysql_query("delete from $banner_resim_tbl where banner_id = '$id'");
  278. $sil2 = mysql_query("delete from $banner_tbl where id = '$id' ");
  279. header("location:index.php?islem=banner&durum=goster");
  280. }}
  281. ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement