Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php
- //// GLOBALS /////
- ///////////////////////////////////
- // SQL QUERYS /////////////////////
- ///////////////////////////////////
- $SQL_News_Select = "SELECT * FROM `news` ORDER BY `id` DESC LIMIT 0,10";
- $SQL_Rdm_WhatsNew = "SELECT * FROM `whatsNew` ORDER BY `id` DESC LIMIT 0,4";
- $SQL_Rdm_OTW = "SELECT * FROM `onTheWay` ORDER BY `id` DESC LIMIT 0,1";
- $SQL_Rdm_siteStats_Check = "SELECT * FROM `Unique_Yr` WHERE `ip` = '".$_SERVER['REMOTE_ADDR']."'";
- $SQL_Rdm_siteStats = "SELECT * FROM `Unique_Yr`";
- $SQL_Rdm_siteStats_Today = "SELECT * FROM `Unique_Yr` WHERE `date` = '".date("d-M-y")."'";
- $SQL_Rdm_siteStats_Insert = "INSERT INTO `Unique_Yr` (ip, date) VALUES ('".$_SERVER['REMOTE_ADDR']."','".date("d-M-y")."')";
- $SQL_Rdm_sales = "SELECT * FROM `sales` ORDER BY `sold` DESC LIMIT 0,5";
- $SQL_Rdm_Testimonials = "SELECT * FROM `testimonials` LIMIT 0,8";
- $SQL_PDB_Gather = "SELECT * FROM `prod_priv_gather`";
- $SQL_PDB_Leveling = "SELECT * FROM `prod_priv_leveling`";
- $SQL_PDB_PVP = "SELECT * FROM `prod_priv_pvp`";
- $SQL_PDB_Packs = "SELECT * FROM `prod_priv_packs`";
- $SQL_PDB_Admisc = "SELECT * FROM `prod_admisc`";
- //////////////////////////////////
- // PAGES /////////////////////////
- //////////////////////////////////
- /// WHATS NEW
- MySQLConnect();
- MySQLSelDB("reeciebo_siteroot");
- $query = mysql_query($SQL_Rdm_WhatsNew) or die(mysql_error());
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) {
- $result = "<span class='specialtext'>".mysql_result($query, $i, "content")."</span><br/><span class='contenttext'>".mysql_result($query, $i, "date")."<br/>------------</span><br/>";
- $whatsNew = $whatsNew.$result;
- }
- /// TOP SELLERS
- MySQLSelDB("reeciebo_customer");
- $query = mysql_query($SQL_Rdm_sales) or die(mysql_error());
- $numRows = mysql_num_rows($query);
- $counter = 1;
- $i = 0;
- while ($i < $numRows) {
- $result = "<span class='specialtext' style='text-align: left;'>".$counter.". ".mysql_result($query, $i, "name")."</span><span class='contenttext'> - ".mysql_result($query, $i, "sold")."</span><br/>";
- $topSellers = $topSellers.$result;
- $i++;
- $counter++;
- }
- /// SITE STATS
- MySQLSelDB("reeciebo_sitestats");
- $query = mysql_query($SQL_Rdm_siteStats_Check) or die(mysql_error());
- if (mysql_num_rows($query) > 0) {
- $result = mysql_result($query, 0, "visits");
- $result++;
- $SQL_Rdm_siteStats_Update = "UPDATE `Unique_Yr` SET `date` = '".date("d-M-y")."', `visits` = '".$result."' WHERE `ip` = '".$_SERVER['REMOTE_ADDR']."'";
- $query = mysql_query($SQL_Rdm_siteStats_Update) or die(mysql_error());
- }else{
- $query = mysql_query($SQL_Rdm_siteStats_Insert) or die(mysql_error());
- }
- $query = mysql_query($SQL_Rdm_siteStats);
- $totalUnique = mysql_num_rows($query);
- $query = mysql_query($SQL_Rdm_siteStats_Today);
- $totalToday = mysql_num_rows($query);
- $siteStats = "<span class='specialtext'>Uniques Today: ".$totalToday."<br/>Total Uniques: ".$totalUnique."</span>";
- /// ON THE WAY
- MySQLSelDB("reeciebo_siteroot");
- $query = mysql_query($SQL_Rdm_OTW) or die(mysql_error());
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) {
- $result = mysql_result($query, $i, "content");
- $status = mysql_result($query, $i, "status");
- $oTw = "<span class='specialtext'>".$result." <span class='contenttext'>STATUS [".$status."%]</span><br/>";
- }
- /// TESTIMONIALS
- $query = mysql_query($SQL_Rdm_Testimonials) or die(mysql_error());
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) {
- $name = mysql_result($query, $i, "name") or die(mysql_error());
- $content = mysql_result($query, $i, "content") or die(mysql_error());
- $content = substr($content, 0, 90)."..' <a href='index.php?p=testimonials'><span class='littletext'>Read More</span></a>";
- $testimonials = "<span class='specialtext'>".$testimonials."'".$content."</span><br/><span class='contenttext'>".$name."</span><br/><br/>";
- }
- /////// NEWS///////////////
- if ($_GET['p'] == "news" || !$_GET['p']) {
- MySQLConnect();
- MySQLSelDB("reeciebo_siteroot");
- $query = mysql_query($SQL_News_Select) or die(mysql_error());
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) {
- $subject = mysql_result($query, $i, 'subject');
- $author = mysql_result($query, $i, 'author');
- $date = mysql_result($query, $i, 'date');
- $news_content = mysql_result($query, $i, 'contents');
- $cont = $cont."<tr><td height='23' colspan='2' bgcolor='#90b7e2'><span class='headertext'> ".$subject."</span></td></tr><tr><td bgcolor='#fbfbfb'> </td><td bgcolor='#fbfbfb'><span class='contenttext'>".$news_content."<br/><br/></span></td></tr><tr><td colspan='2' align='right' bgcolor='#fbfbfb'><span class='littletext'>Posted by <u>".$author."</u> on ".$date." <br/><br/></span></td></tr>";
- }
- $pageContents = Table_Create("NEWS", $cont);
- }
- /////////////// NEWS END /////////
- /////// PRODUCT DATABASE /////////
- if ($_GET['p'] == "pdb") {
- MySQLConnect();
- MySQLSelDB("reeciebo_siteroot");
- $query = mysql_query($SQL_PDB_Gather);
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_gather` in $GATHER[$i]['arg']
- $GATHER[$i]['prodname'] = mysql_result($query, $i, "prodname");
- $GATHER[$i]['prodcost'] = mysql_result($query, $i, "prodcost");
- $GATHER[$i]['prodlink'] = mysql_result($query, $i, "prodlink");
- $GATHER[$i]['proddesc'] = mysql_result($query, $i, "proddesc");
- $GATHER[$i]['prodimages'] = mysql_result($query, $i, "prodimages");
- }
- $query = mysql_query($SQL_PDB_Leveling);
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_leveling` in $LEVELING[$i]['arg']
- $LEVELING[$i]['prodname'] = mysql_result($query, $i, "prodname");
- $LEVELING[$i]['prodcost'] = mysql_result($query, $i, "prodcost");
- $LEVELING[$i]['prodlink'] = mysql_result($query, $i, "prodlink");
- $LEVELING[$i]['proddesc'] = mysql_result($query, $i, "proddesc");
- }
- $query = mysql_query($SQL_PDB_PVP);
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_pvp` in $PVP[$i]['arg']
- $PVP[$i]['prodname'] = mysql_result($query, $i, "prodname");
- $PVP[$i]['prodcost'] = mysql_result($query, $i, "prodcost");
- $PVP[$i]['prodlink'] = mysql_result($query, $i, "prodlink");
- $PVP[$i]['proddesc'] = mysql_result($query, $i, "proddesc");
- }
- $query = mysql_query($SQL_PDB_Packs);
- $numRows = mysql_num_rows($query);
- for ($i=0; $i < $numRows; $i++) { // Storing Data from `prod_priv_packs` in $PACKS[$i]['arg']
- $PACKS[$i]['prodname'] = mysql_result($query, $i, "prodname");
- $PACKS[$i]['prodcost'] = mysql_result($query, $i, "prodcost");
- $PACKS[$i]['prodlink'] = mysql_result($query, $i, "prodlink");
- $PACKS[$i]['proddesc'] = mysql_result($query, $i, "proddesc");
- }
- // Start Organising the tables.
- /// Gathering Table
- $temp = "<tr><td bgcolor='#fbfbfb'><br/>";
- $i = 0;
- $x = 1;
- $temp = $temp." <u>GATHERING</u><br/>";
- while ($GATHER[$i]) {
- $temp = $temp." ".$x.". <a href='#".$GATHER[$i]['prodlink']."'>".$GATHER[$i]['prodname']."</a> - ".substr($GATHER[$i]['proddesc'], 0, 60).".. <a href='#".$GATHER[$i]['prodlink']."'><span class='littletext'>Read More</span></a><br/>";
- $i++;
- $x++;
- }
- /// Leveling Table
- $i = 0;
- $x = 1;
- $temp = $temp."<br/> <u>LEVELING</u><br/>";
- if (!$LEVELING[$i]) { $temp = $temp." No profiles found..<br/>"; }
- while ($LEVELING[$i]) {
- $temp = $temp." ".$x.". <a href='#".$LEVELING[$i]['prodlink']."'>".$LEVELING[$i]['prodname']."</a> - ".substr($LEVELING[$i]['proddesc'], 0, 60).".. <a href='#".$LEVELING[$i]['prodlink']."'><span class='littletext'>Read More</span></a><br/>";
- $i++;
- $x++;
- }
- /// PVP Table
- $i = 0;
- $x = 1;
- $temp = $temp."<br/> <u>PVP</u><br/>";
- while ($PVP[$i]) {
- $temp = $temp." ".$x.". <a href='#".$PVP[$i]['prodlink']."'>".$PVP[$i]['prodname']."</a> - ".substr($PVP[$i]['proddesc'], 0, 60).".. <a href='#".$PVP[$i]['prodlink']."'><span class='littletext'>Read More</span></a><br/>";
- $i++;
- $x++;
- }
- /// PACKS Table
- $i = 0;
- $x = 1;
- $temp = $temp."<br/> <u>PACKS</u><br/>";
- while ($PACKS[$i]) {
- $temp = $temp." ".$x.". <a href='#".$PACKS[$i]['prodlink']."'>".$PACKS[$i]['prodname']."</a> - ".substr($PACKS[$i]['proddesc'], 0, 60).".. <a href='#".$PACKS[$i]['prodlink']."'><span class='littletext'>Read More</span></a><br/>";
- $i++;
- $x++;
- }
- $temp = $temp."<br/></td></tr>";
- $jump2 = Table_Create("<span id='top'>PRODUCT JUMP</span>", $temp);
- unset($temp);
- // Generate Tables for each Product
- ///Gathering
- $tableID = 0;
- for ($i=0; is_array($GATHER[$i]); $i++) {
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5'> <span class='specialtext'>Price: €".$GATHER[$i]['prodcost']."</span></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#fbfbfb'></td><td bgcolor='#fbfbfb'> Images:<p>".$GATHER[$i]['prodimages']."</p></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5'> Description:<span class='specialtext'><p>".$GATHER[$i]['proddesc']."</p></span></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5' align='right'> <img src='content/images/buynow.png'/></td></tr>";
- $table[$tableID] = "<p><a href='#top'>Back to TOP</a></p>".Table_Create("<span id='".$GATHER[$i]['prodlink']."'>".strtoupper($GATHER[$i]['prodname'])."</span>", $temp[$i]);
- $tableID++;
- }
- ///Leveling
- for ($i=0; is_array($LEVELING[$i]); $i++) {
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5'> <span class='specialtext'>Price: €".$LEVELING[$i]['prodcost']."</span></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#fbfbfb'></td><td bgcolor='#fbfbfb'> Images:<p>".$LEVELING[$i]['prodimages']."</p></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5'> Description:<span class='specialtext'><p>".$LEVELING[$i]['proddesc']."</p></span></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5' align='right'> <img src='content/images/buynow.png'/></td></tr>";
- $table[$tableID] = "<p><a href='#top'>Back to TOP</a></p>".Table_Create("<span id='".$LEVELING[$i]['prodlink']."'>".strtoupper($LEVELING[$i]['prodname'])."</span>", $temp[$i]);
- $tableID++;
- }
- ///PVP
- unset($temp);
- for ($i=0; is_array($PVP[$i]); $i++) {
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5'> <span class='specialtext'>Price: €".$PVP[$i]['prodcost']."</span></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#fbfbfb'></td><td bgcolor='#fbfbfb'> Images:<p>".$PVP[$i]['prodimages']."</p></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5'> Description:<span class='specialtext'><p>".$PVP[$i]['proddesc']."</p></span></td></tr>";
- $temp[$i] = $temp[$i]."<tr><td bgcolor='#f5f5f5'></td><td bgcolor='#f5f5f5' align='right'> <img src='content/images/buynow.png'/></td></tr>";
- $table[$tableID] = "<p><a href='#top'>Back to TOP</a></p>".Table_Create("<span id='".$PVP[$i]['prodlink']."'>".strtoupper($PVP[$i]['prodname'])."</span>", $temp[$i]);
- $tableID++;
- }
- foreach ($table as $value) {
- $productTables = $productTables.$value;
- }
- $pageContents = $jump2.$productTables."<br/>Total Tables: ".$tableID;
- }
- //////////////////////////////////
- // FUNCTIONS /////////////////////
- //////////////////////////////////
- function MySQLConnect() {
- $host = "localhost";
- $user = "removed";
- $pass = "removed";
- $conn = mysql_connect($host, $user, $pass) or die(mysql_error());
- }
- function MySQLSelDB($db) {
- $seldb = mysql_select_db($db) or die(mysql_error());
- }
- function Table_Create($pageHeader, $pageBlob) {
- return "<table width='95%' border='0' cellspacing='0' cellpadding='5'><tr><td colspan='2' align='center' height='22' background='images/navextension.jpg'><span class='headertext'>".$pageHeader."</span></td></tr>".$pageBlob."</table>";
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement