function search() { $x = $_GET['category']; $key = $_GET['keywords']; $cat = ""; if ($x > -1) { $cat = "AND category='{$x}'"; } $sqlS = "SELECT `item_number`, `title`,`subtitle`,`price`, icon FROM `items_available` WHERE MATCH(`title`,`subtitle`,`description`) AGAINST('{$key}') {$cat}"; display_items($sqlS); }
} } // The following actions may only be performed by an admin user if (check_admin_user()) { switch ($action) { case 'create-mail': display_mail_form(get_email()); break; case 'create-list': display_list_form(get_email()); break; case 'store-list': if (store_list($_SESSION['admin_user'], $_POST)) { echo "<p style=\"padding-bottom: 50px\">New list added.</p>"; display_items('All Lists', get_all_lists(), 'information', 'show-archive', ''); } else { echo "<p style=\"padding-bottom: 50px\">List could not be\n stored. Please try again.</p>"; } break; case 'send': send($_GET['id'], $_SESSION['admin_user']); break; case 'view-mail': display_items('Unsent Mail', get_unsent_mail(get_email()), 'preview-html', 'preview-text', 'send'); break; } } /********************************************************************** * Section 4: display footer *********************************************************************/ do_html_footer();
//Select the results of the query in the format (query,row,column) $result = mysql_query("SELECT * FROM items WHERE {$display}='{$disptitle}' ORDER BY {$sortby}"); echo "<div id='sectiontitle'><h1>{$disptitle}</h1></div>"; $noresultsurl = '?tid=' . $tid; break; case "all": $result = mysql_query("SELECT * FROM items ORDER BY {$sortby}"); echo "<div id='sectiontitle'><h1>" . $l_nav_allitems . "</h1></div>"; $noresultsurl = ''; break; case "today": $today = date("Y-m-d"); $todayf = date("jS M Y"); $result = mysql_query("SELECT * FROM items WHERE date='{$today}' ORDER BY {$sortby}"); echo "<div id='sectiontitle'><h1>" . $l_nav_today . ": {$todayf}</h1></div>"; $noresultsurl = ''; break; } $numberrows = mysql_num_rows($result); sort_form($display, $section, $tid, $sortby); if ($numberrows == 0) { $message = $display == "today" ? $l_msg_notoday : $l_msg_noitems; echo "<div class='inform'><img src='images/information.png' alt='' /> " . $message . " <a href='edit.php{$noresultsurl}'>" . $l_msg_addsome . "</a></div>"; } else { display_items($display, $section, $tid, $sortby); } if (isset($_POST['submit'])) { $section = $_POST['section']; $sortby = $_POST['sort']; } include 'includes/footer.php';
<link rel="stylesheet" href="css/index.css"/> </head> <body> <div id="wrapper"> <?php headerSearch(); ?> <aside id="main_aside"> <?php side_cat(); ?> </aside> <section id="main_section"> <?php $sqlDis = "SELECT `item_number`, `title`,`subtitle`,`icon`,`price` FROM items_available ORDER BY bids DESC, title LIMIT 5"; display_items($sqlDis); ?> <!--<div id='item_box'><img src='images\cat\building\bridge.jpg' width='300px' height='200px'/> <div class='subtitles'> <h2><a href='display.php'> Bridge </a></h2> <br/> The bridge on river of italy </div> <div class="price"> Rs. 200/- </div> </div> <div id='item_box'><img src='images\cat\building\bridge.jpg' width='300px' height='200px'/> <div class='subtitles'> <h2><a href='display.php'> Bridge </a></h2> <br/> The bridge on river of italy </div> <div class="price"> Rs. 200/- </div> </div> <div id='item_box'><img src='images\cat\building\bridge.jpg' width='300px' height='200px'/> <div class='subtitles'> <h2><a href='display.php'> Bridge </a></h2> <br/> The bridge on river of italy </div> <div class="price"> Rs. 200/- </div> </div>--> </section> </body>
break; //192.168.20.202email port:8089 //192.168.20.202email port:8089 case 'send': send($_GET['id'], $_SESSION['admin_user'], $_POST['emailtest']); break; case 'view-mail': display_items('Unsent Mail', get_unsent_mail(get_user()), 'preview-html', 'preview-text', 'send'); break; case 'subscribe': subscribe(get_user(), $_GET['id']); display_items('Subscribed Lists', get_subscribed_lists(get_user()), 'information', 'show-archive', 'subscribe'); break; case 'unsubscribe': unsubscribe(get_user(), $_GET['id']); display_items('Subscribed Lists', get_subscribed_lists(get_user()), 'information', 'show-archive', 'unsubscribe'); break; case 'modify': $list = address_book(); $subscribers = get_subscribers($_GET['id']); ?> <ul class="nav nav-tabs"> <li class="active"><a data-toggle="tab" href="#menu1">Subscribers</a></li> <li ><a onclick="changeAllClass('menu1','tab-pane fade');" data-toggle="tab" href="#home">Address Book</a></li> </ul> <div class="tab-content"> <div id="menu1" class="tab-pane fade in active"> <?php for ($i = 0; $i < count($subscribers); $i++) {
<ul> <li><a href="" ft:key="milestone" ft:value="0.1 Yahtzee">0.1 Yahtzee</a></li> <li><a href="" ft:key="milestone" ft:value="0.2 Booyah">0.2 Booyah</a></li> <li><a href="" ft:key="milestone" ft:value="0.3 Lobsterman">0.3 Lobsterman</a></li> </ul> <h2>Components</h2> <ul> <li><a href="" ft:key="component" ft:value="Groups">Groups</a></li> <li><a href="" ft:key="component" ft:value="Wiki">Wiki</a></li> <li><a href="" ft:key="component" ft:value="Sysadmin">Sysadmin</a></li> </ul> </div> <div id="content"> <div id="groupby" style="display: none"> Group by: <select> <option value="milestone">Milestone</option> <option value="milestone">Component</option> </select> </div> <div id="tickets"> <?php display_items(); ?> </div> </div> <?php require_once 'footer.php';
<?php # # Load up files # require_once 'functions.php'; # # Route URLS # if ($_GET['action'] == 'display_items') { $filter = $_GET['key']; $groupby = $_GET['groupby']; display_items($filter, $groupby); } elseif ($_POST['action'] == 'update_ticket') { update_ticket(); } else { require_once 'display.php'; }