Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- session_start();
- require_once 'config.php';
- /**
- * @author barak maron from smartk
- * @copyright 2013
- */
- if(isset($_SESSION['user'])){
- header("Content-Type: text/html; charset=utf-8");
- mysql_query("SET NAMES 'utf8'", $con);
- date_default_timezone_set("Asia/Jerusalem");
- echo '
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html xmlns="http://www.w3.org/1999/xhtml" xml:lang="en" lang="en">
- <head>
- <meta http-equiv="content-type" content="text/html" />
- <meta name="author" content="BarakMaron" />
- <meta charset="utf-8" />
- <link type="text/css" rel="stylesheet" href="style.css" />
- <title>סמראטק</title>
- </head>
- <body dir="rtl">';
- echo $upbar;
- if($_GET['f'] == 1 & $_GET['t'] == 0){
- echo "<a href='frum.php?f=1&t=1'>הצג רעיון</a>";
- $per_page = 5;
- $pages_query = mysql_query("SELECT COUNT(`id`) FROM `ra`");
- $pages = ceil(mysql_result($pages_query, 0) / $per_page);
- $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
- $start = ($page - 1) * $per_page;
- $x = 1;
- $query = mysql_query("SELECT * FROM `ra` ORDER BY `date` DESC LIMIT ".$start.", ".$per_page."");
- echo "<table>
- <thead>
- <tr>
- <td>נושא:</td>
- <td>פותח האשכול:</td>
- <td>תאריך פתיחת האשכול:</td>
- <td>הצבעה:</td>
- </tr>
- </thead>";
- while($query_row = mysql_fetch_assoc($query)){
- if($query_row['1'] == 2 & $query_row['2'] == 2 & $query_row['3'] == 2 & $query_row['4'] == 2 & $query_row['5'] == 2 & $query_row['6'] == 2 & $query_row['7'] == 2 & $query_row['8'] == 2 & $query_row['9'] == 2 & $query_row['10'] == 2 & $query_row['11'] == 2 & $query_row['12'] == 2 & $query_row['13'] == 2 & $query_row['14'] == 2 & $query_row['15'] == 2 & $query_row['16'] == 2){
- $stas = "בעד";
- }elseif($query_row['1'] == 1 & $query_row['2'] == 1 & $query_row['3'] == 1 & $query_row['4'] == 1 & $query_row['5'] == 1 & $query_row['6'] == 1 & $query_row['7'] == 1 & $query_row['8'] == 1 & $query_row['9'] == 1 & $query_row['10'] == 1 & $query_row['11'] == 1 & $query_row['12'] == 1 & $query_row['13'] == 1 & $query_row['14'] == 1 & $query_row['15'] == 1 & $query_row['16'] == 1){
- $stas = "נגד";
- }elseif($query_row['1'] == 0 & $query_row['2'] == 0 & $query_row['3'] == 0 & $query_row['4'] == 0 & $query_row['5'] == 0 & $query_row['6'] == 0 & $query_row['7'] == 0 & $query_row['8'] == 0 & $query_row['9'] == 0 & $query_row['00'] == 0 & $query_row['00'] == 0 & $query_row['02'] == 0 & $query_row['03'] == 0 & $query_row['04'] == 0 & $query_row['05'] == 0 & $query_row['06'] == 0){
- $stas = "עוד לא קובלה החלטה";
- }
- $fuser = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$query_row['iduser']."'"));
- $fres = mysql_fetch_assoc(mysql_query("SELECT * FROM `furms` WHERE `id` = '".$_GET['f']."'"));
- echo '<tr>
- <td><a href="showf.php?f=1&i='.$query_row['id'].'">'.$query_row['sub'].'</a></td>
- <td>'.$fuser['username'].'</td>
- <td>'.$query_row['date'].'</td>
- <td>'.$stas.'</td>';
- if($fres['res'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `ra` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=1' />";
- }
- }elseif($query_row['iduser'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `ra` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=frum.php?f=1' />";
- }elseif(isset($_POST['edit'.$x.''])){
- echo "<META HTTP-EQUIV='Refresh' CONTENT='0;URL=frum.php?f=1&e=1&i=".$query_row['id']."' />";
- }
- echo "</tr>";
- }
- $x++;
- }
- if ($pages > 1 && $page <= $pages) {
- echo '<tr><td>';
- for ($i = 1; $i<=$pages; $i++) {
- echo "<a href=\"frum.php?f=1&page=".$i."\"> ".$i." </a>";
- }
- echo '</tr></td>';
- }
- echo "</table>";
- }elseif($_GET['f'] == 2 & $_GET['t'] == 0){
- echo "<a href='frum.php?f=2&t=1'>פתח אשכול</a>";
- $per_page = 5;
- $pages_query = mysql_query("SELECT COUNT(`id`) FROM `tog` WHERE `idfrum` = '".$_GET['f']."'");
- $pages = ceil(mysql_result($pages_query, 0) / $per_page);
- $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
- $start = ($page - 1) * $per_page;
- $x = 1;
- $query = mysql_query("SELECT * FROM `tog` WHERE `idfrum` = '".$_GET['f']."' ORDER BY `date` DESC LIMIT ".$start.", ".$per_page."");
- echo "<table>
- <thead>
- <tr>
- <td>נושא:</td>
- <td>פותח האשכול:</td>
- <td>תאריך פתיחת האשכול:</td>
- </tr>
- </thead>";
- while($query_row = mysql_fetch_assoc($query)){
- $fuser = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$query_row['iduser']."'"));
- $fres = mysql_fetch_assoc(mysql_query("SELECT * FROM `furms` WHERE `id` = '".$_GET['f']."'"));
- echo '<tr>
- <td><a href="showf.php?f=1&i='.$query_row['id'].'">'.$query_row['sub'].'</a></td>
- <td>'.$fuser['username'].'</td>
- <td>'.$query_row['date'].'</td>';
- if($fres['res'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `tog` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=2' />";
- }
- }elseif($query_row['iduser'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `tog` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=2' />";
- }elseif(isset($_POST['edit'.$x.''])){
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=2&e=1&i=".$query_row['id']."' />";
- }
- echo "</tr>";
- }
- $x++;
- }
- if ($pages > 1 && $page <= $pages) {
- echo '<tr><td>';
- for ($i = 1; $i<=$pages; $i++) {
- echo "<a href=\"frum.php?f=2&page=".$i."\"> ".$i." </a>";
- }
- echo '</tr></td>';
- }
- echo "</table>";
- }elseif($_GET['f'] == 3 & $_GET['t'] == 0){
- echo "<a href='frum.php?f=3&t=1'>פתח אשכול</a>";
- $per_page = 5;
- $pages_query = mysql_query("SELECT COUNT(`id`) FROM `tog` WHERE `idfrum` = '".$_GET['f']."'");
- $pages = ceil(mysql_result($pages_query, 0) / $per_page);
- $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
- $start = ($page - 1) * $per_page;
- $x = 1;
- $query = mysql_query("SELECT * FROM `tog` WHERE `idfrum` = '".$_GET['f']."' ORDER BY `date` DESC LIMIT ".$start.", ".$per_page."");
- echo "<table>
- <thead>
- <tr>
- <td>נושא:</td>
- <td>פותח האשכול:</td>
- <td>תאריך פתיחת האשכול:</td>
- </tr>
- </thead>";
- while($query_row = mysql_fetch_assoc($query)){
- $fuser = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$query_row['iduser']."'"));
- $fres = mysql_fetch_assoc(mysql_query("SELECT * FROM `furms` WHERE `id` = '".$_GET['f']."'"));
- echo '<tr>
- <td><a href="showf.php?f=1&i='.$query_row['id'].'">'.$query_row['sub'].'</a></td>
- <td>'.$fuser['username'].'</td>
- <td>'.$query_row['date'].'</td>';
- if($fres['res'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `tog` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=3' />";
- }
- }elseif($query_row['iduser'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `tog` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=3' />";
- }elseif(isset($_POST['edit'.$x.''])){
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=3&e=1&i=".$query_row['id']."' />";
- }
- echo "</tr>";
- }
- $x++;
- }
- if ($pages > 1 && $page <= $pages) {
- echo '<tr><td>';
- for ($i = 1; $i<=$pages; $i++) {
- echo "<a href=\"frum.php?f=3&page=".$i."\"> ".$i." </a>";
- }
- echo '</tr></td>';
- }
- echo "</table>";
- }elseif($_GET['f'] == 4 & $_GET['t'] == 0){
- echo "<a href='frum.php?f=3&t=1'>פתח אשכול</a>";
- $per_page = 5;
- $pages_query = mysql_query("SELECT COUNT(`id`) FROM `tog` WHERE `idfrum` = '".$_GET['f']."'");
- $pages = ceil(mysql_result($pages_query, 0) / $per_page);
- $page = (isset($_GET['page'])) ? (int)$_GET['page'] : 1;
- $start = ($page - 1) * $per_page;
- $x = 1;
- $query = mysql_query("SELECT * FROM `tog` WHERE `idfrum` = '".$_GET['f']."' ORDER BY `date` DESC LIMIT ".$start.", ".$per_page."");
- echo "<table>
- <thead>
- <tr>
- <td>נושא:</td>
- <td>פותח האשכול:</td>
- <td>תאריך פתיחת האשכול:</td>
- </tr>
- </thead>";
- while($query_row = mysql_fetch_assoc($query)){
- $fuser = mysql_fetch_assoc(mysql_query("SELECT * FROM `user` WHERE `id` = '".$query_row['iduser']."'"));
- $fres = mysql_fetch_assoc(mysql_query("SELECT * FROM `furms` WHERE `id` = '".$_GET['f']."'"));
- echo '<tr>
- <td><a href="showf.php?f=1&i='.$query_row['id'].'">'.$query_row['sub'].'</a></td>
- <td>'.$fuser['username'].'</td>
- <td>'.$query_row['date'].'</td>';
- if($fres['res'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `tog` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=4' />";
- }
- }elseif($query_row['iduser'] == $de['id']){
- echo '<td><form method="post" action="">
- <input name="del'.$x.'" value="מחק" type="submit" />
- <input name="edit'.$x.'" value="ערוך" type="submit" />
- </form></td>';
- if(isset($_POST['del'.$x.''])){
- mysql_query("DELETE FROM `tog` WHERE `id` = '".$query_row['id']."'");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=4' />";
- }elseif(isset($_POST['edit'.$x.''])){
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=4&e=1&i=".$query_row['id']."' />";
- }
- echo "</tr>";
- }
- $x++;
- }
- if ($pages > 1 && $page <= $pages) {
- echo '<tr><td>';
- for ($i = 1; $i<=$pages; $i++) {
- echo "<a href=\"frum.php?f=4&page=".$i."\"> ".$i." </a>";
- }
- echo '</tr></td>';
- }
- echo "</table>";
- }elseif($_GET['t'] == 1){
- $f = $_GET['f'];
- echo '<form method="post">
- <b>נושא:</b>
- <input name="sub" type="text" maxlength="500" /><br />
- <b>ההודעה:</b>
- <textarea maxlength="1000" name="text" value=""></textarea><br />
- <input name="s" value="פרסם" type="submit" />
- </form>';
- if(isset($_POST['s'])){
- if($f == 1){
- mysql_query("INSERT INTO `ra` (`iduser`,`sub`,`msg` ,`date` ,'".$de['id']."')VALUES('".$de['id']."' ,'".$_POST['sub']."' , '".$_POST['text']."', '".date("j/m/Y H:i:s")."', '2')");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=".$f."' />";
- echo "פרסמת בהצלחה!";
- }elseif($f == 2){
- mysql_query("INSERT INTO `tog` (`iduser` ,`idfrum` ,`sub`,`msg` ,`date`)VALUES('".$de['id']."' ,'".$f."' ,'".$_POST['sub']."' , '".$_POST['text']."', '".date("j/m/Y H:i:s")."')");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=".$f."' />";
- echo "פרסמת בהצלחה!";
- }elseif($f == 3){
- mysql_query("INSERT INTO `tog` (`iduser` ,`idfrum` ,`sub`,`msg` ,`date`)VALUES('".$de['id']."' ,'".$f."' ,'".$_POST['sub']."' , '".$_POST['text']."', '".date("j/m/Y H:i:s")."')");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=".$f."' />";
- echo "פרסמת בהצלחה!";
- }elseif($f == 4){
- mysql_query("INSERT INTO `tog` (`iduser` ,`idfrum` ,`sub`,`msg` ,`date`)VALUES('".$de['id']."' ,'".$f."' ,'".$_POST['sub']."' , '".$_POST['text']."', '".date("j/m/Y H:i:s")."')");
- echo "<META HTTP-EQUIV='Refresh' CONTENT='4;URL=frum.php?f=".$f."' />";
- echo "פרסמת בהצלחה!";
- }
- }
- }
- echo '</body>
- </html>';
- }else{
- echo "אנא התחבר <a href='index.php'>כאן</a>";
- }
- ?>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement