function Analyze($userid, &$results) { //set some variables $forenamelist = array(); $surnamelist = array(); $schoolist = array(); $citylist = array(); $colorlist = array(); $avatarlist = array(); $agelist = array(); $males = 0; $females = 0; $usercount = 0; $currentUser = array(); //connect to the database $con = mysqli_connect("eu-cdbr-azure-west-a.cloudapp.net", "b8592f1b44ff9a", "fecb2128", "TeamProject"); //In this part the lists will become populated //with data from the database $query = "SELECT * FROM UserP"; $result = mysqli_query($con, $query); //Run through the database and populate the lists while ($row = mysqli_fetch_assoc($result)) { if ($row['ID'] == $userid) { //if the result is the current user pass the array $currentUser = $row; } else { //if the result is another user add values to the arrays $forenamelist[] = $row['Forename']; $surnamelist[] = $row['Surname']; $schoolist[] = $row['School']; $citylist[] = $row['City']; $colorlist[] = $row['Color']; $avatarlist[] = $row['Avatar']; $agelist[] = $row['Age']; if ($row['Gender'] == "male") { $males++; } else { $females++; } } $usercount++; } //time to compare the current user to the others in the database require "utility.php"; //Match data and add results to the results list $matches = Match($forenamelist, $currentUser['Forename']); $results[0] = array("Forename Matches", $matches); $matches = Match($surnamelist, $currentUser['Surname']); $results[1] = array("Surname Matches", $matches); $matches = Match($schoolist, $currentUser['School']); $results[2] = array("School Matches", $matches); $matches = Match($citlist, $currentUser['City']); $results[3] = array("City Matches", $matches); $matches = Match($colorlist, $currentUser['Color']); $results[4] = array("Color Matches", $matches); $matches = Match($avatarlist, $currentUser['Avatar']); $results[5] = array("Avatar Matches", $matches); $matches = Match($agelist, $currentUser['Age']); $results[6] = array("Age Matches", $matches); //Check the user's gender add the last basic stats to the list if ($currentUser['Gender'] == "male") { $gender = $males; } else { $gender = $females; } $results[7] = array("Gender Matches", $gender); $results[8] = array("Total Users", $usercount); //Initiliaze some arrays $currInterests = array(); $othInterests = array(); $x = 0; //Populate the interest lists $query = "SELECT InterestName,UserID FROM Interest,InterestList \n WHERE Interest.InterestID = InterestList.InterestID"; $result = mysqli_query($con, $query); while ($row = mysqli_fetch_assoc($result)) { if ($row['UserID'] == $currentUser['ID']) { $currInterests[] = $row['InterestName']; } else { $othInterests[] = $row['InterestName']; } } //compare user's interests to others' foreach ($currInterests as $value) { foreach ($othInterests as $val) { if ($value == $val) { $x++; } } $results[] = array($value, $x); $x = 0; } mysqli_close($con); }
updateOrders("sales_orders", "1", $s_pieces_left, $result_sales_id); //Εισαγωγή αγοροπωλησίας στον πίνακα match & //Ενημέρωση τιμής μετοχής μετά την αγοροπωλησία (παίρνει την τιμή της εντολής αγοράς) Match($insert_pur_id, $result_sales_id, $insert_stock_id, $insert_pieces, $insert_price); updatewallet($result_s_user, $insert_user_id, $insert_pieces, $insert_price); } //2 - Μερικό match εντολών: αριθμός μετοχών εντολής πώλησης < αριθμός μετοχών εντολής αγοράς if ($insert_price >= $result_s_price && $insert_pieces > $result_s_pieces) { $p_pieces_left = $insert_pieces - $result_s_pieces; //***tha mporousa na to midenizw $result_s_pieces //Ενημέρωση κατάστασης εντολών αγοράς και πώλησης updateOrders("pur_orders", "1", $p_pieces_left, $insert_pur_id); updateOrders("sales_orders", "3", $result_s_pieces, $result_sales_id); //Εισαγωγή αγοροπωλησίας στον πίνακα match & //Ενημέρωση τιμής μετοχής μετά την αγοροπωλησία (παίρνει την τιμή της εντολής αγοράς) Match($insert_pur_id, $result_sales_id, $insert_stock_id, $result_s_pieces, $insert_price); updatewallet($result_s_user, $insert_user_id, $result_s_pieces, $insert_price); } } } echo 'Η Εντολή Αγοράς Καταχωρήθηκε!'; } else { echo 'Δεν είναι αρκετά τα χρήματα σας για την Καταχώρηση της παρούσας Ενοτλής Αγοράς!'; } } //*****FUNCTIONS********** //Ενημέρωση κατάστασης εντολών αγοράς και πώλησης function updateOrders($table, $state, $pieces, $id) { $pieces2 = (int) $pieces; $id2 = (int) $id;
function nav_menu() { $res = select_table('main_menu1'); foreach ($res as $row) { $res_menu = sub_menu($row['m_menu_id']); if ($res_menu) { echo "<li class='nav-item dropdown'>"; echo "<a class='dropdown-toggle' data-toggle='dropdown' data-hover='dropdown' data-delay='0' data-close-others='false' href=#>{$row['m_menu_name']}<i class='fa fa-angle-down'></i></a>"; echo "<ul class='dropdown-menu'>"; foreach ($res_menu as $res_sub) { echo "<li><a href={$res_sub['s_menu_link']}>{$res_sub['s_menu_name']}</a></li>"; } echo "</ul>"; echo "</li>"; } else { echo "<li class='" . Match($row['m_menu_link']) . " nav-item'><a href={$row['m_menu_link']}>{$row['m_menu_name']}</a>"; echo "</li>"; } } // Latest News function show_latest_news() { $result = select_table('news'); echo '<marquee direction="up" scrolldelay="50" scrollamount="3" truespeed height="400px" onmouseover="this.stop()" onmouseout="this.start()" behavior="scroll" style="height:400px;">'; echo '<div id="news_ticker">'; echo '<ul>'; foreach ($result as $row) { if ($row['new'] == 1) { $new = '<sup> <img src="images/new.gif"></sup>'; } else { $new = ''; } echo '<div class="blog-list-post clearfix">'; echo '<div class="blog-list-details">'; echo '<li>'; echo '<h5 class="blog-list-title"><a href="' . $row['url'] . '" >' . $row['title'] . $new . '</a></h5>'; echo "<p class='blog-list-meta small-text'>{$row['description']}</p>"; echo '</li>'; echo '</div>'; echo '</div>'; } echo '</ul>'; echo '</div>'; echo '</marquee>'; } // Events function show_event() { $result = select_table('events'); foreach ($result as $row) { $date = explode('-', $row['event_date']); $month = $date[1]; $month = get_month($month); $month = substr($month, 0, 3); //Strip January to Jan $day = $date[2]; echo "<div class='event-small-list clearfix'>"; echo "<div class='calendar-small'>"; echo "<span class='s-month'>{$month}</span>"; echo "<span class='s-date'>{$day}</span>"; echo "</div> "; echo "<div class='event-small-details'>"; echo "<h5 class='event-small-title'><a href={$row['url']}>{$row['title']}</a></h5>"; echo "<p class='event-small-meta small-text'>{$row['description']}</p>"; echo "</div> "; echo "</div>"; } } // Links function show_important_link() { $result = select_table('imp_links'); foreach ($result as $row) { echo '<div class="blog-list-post clearfix">'; echo '<div class="blog-list-details">'; echo "<h5 class='blog-list-title'><a href={$row['url']}>{$row['title']}</a></h5>"; echo '</div>'; echo '</div>'; } } function show_footer_link($footer) { global $db; $query = $db->query("SELECT title, url FROM footer_pages WHERE num= {$footer}"); $query = $query->fetchAll(PDO::FETCH_ASSOC); foreach ($query as $row) { echo '<li><a href="' . $row['url'] . '"><i class="fa fa-caret-right"></i>' . $row['title'] . '</a></li>'; } } function show_gallery_images() { global $db; $query = $db->query("SELECT name, thumb_name_263 FROM images"); $query = $query->fetchAll(PDO::FETCH_ASSOC); foreach ($query as $row) { echo '<div class="col-md-3 mix students" data-cat="2">'; echo '<div class="gallery-item">'; echo '<a class="fancybox" rel="gallery1" href="gallery/' . $row['name'] . '">'; echo '<div class="gallery-thumb">'; echo '<img src="gallery/thumb263/' . $row['thumb_name_263'] . '" alt="" />'; echo '</div>'; echo '</a>'; echo '</div>'; echo '</div>'; } } function show_gallery_images1() { global $db; $query = $db->query("SELECT name, thumb_name_70 FROM images LIMIT 8"); $query = $query->fetchAll(PDO::FETCH_ASSOC); foreach ($query as $row) { echo ' <div class="thumb-small-gallery">'; echo '<a class="fancybox" rel="gallery1" href="gallery/' . $row['name'] . '" title="Gallery Tittle One">'; echo '<img src="gallery/thumb263/' . $row['thumb_name_70'] . '" alt="" />'; echo '</a> </div>'; } } function get_month($key) { switch ($key) { case '01': return "January"; break; case '02': return "Febuary"; break; case '03': return "March"; break; case '04': return "April"; break; case '05': return "May"; break; case '06': return "June"; break; case '07': return "July"; break; case '08': return "August"; break; case '09': return "September"; break; case '10': return "October"; break; case '11': return "November"; break; case '12': return "December"; break; } } function create_archive($date) { foreach ($date as $year => $month) { $occurences = array_count_values($month); echo "<li><a href='#'>{$year}</a></li>"; $month = array_unique($month); asort($month); foreach ($month as $key) { echo "<ul><li><a href='archive/{$year}/{$key}'>" . get_month($key) . "</a>(" . $occurences[$key] . ")</li></ul>"; } } } function show_archive() { global $db; $query = $db->query("SELECT Time FROM page"); $query = $query->fetchAll(); $tmp_arr = array(); foreach ($query as $time) { $tmp = explode('-', $time['Time']); $year = $tmp[0]; $month = $tmp[1]; if (!isset($tmp_arr[$year])) { $tmp_arr[$year] = array(); } array_push($tmp_arr[$year], $month); // $tmp_arr[$year] = array_unique($tmp_arr[$year]); // print_r($tmp_arr); } create_archive($tmp_arr); } }
<!-- ******NAV****** --> <nav class='main-nav' role='navigation'> <div class='container'> <div class='navbar-header'> <button class='navbar-toggle' type='button' data-toggle='collapse' data-target='#navbar-collapse'> <span class='sr-only'>Toggle navigation</span> <span class='icon-bar'></span> <span class='icon-bar'></span> <span class='icon-bar'></span> </button><!--//nav-toggle--> </div><!--//navbar-header--> <div class='navbar-collapse collapse' id='navbar-collapse'> <ul class='nav navbar-nav'> <!-- <li class='active nav-item'><a href='/cms/index.php'>Home</a></li> --> <?php echo "<li class='" . Match("index") . " nav-item'><a href='/cms/index.php'>Home</a>"; ?> <?php nav_menu(); ?> </ul><!--//nav--> <ul class="nav navbar-nav navbar-right"> <li><form class="navbar-form search-form" role='search' method='post' action='search.php'> <div class="input-group"> <input type="text" class="form-control" name='keyword' placeholder='Search the site...'> <div class="input-group-btn"> <button type='submit' name='submit' class='btn btn-theme'>Go</button> </div> </div> </form></li>