Example #1
0
<?php

require '../init.php';
require '../tools.php';
try {
    Database::runQuery("DELETE FROM brew WHERE id = :brewid LIMIT 1", array("brewid" => (int) $_POST['brewId']));
    success();
} catch (PDOException $e) {
    fail("Error in api/schedule/create.php: " . $e->getMessage());
}
Example #2
0
 public function storeAddress($searchId, $paramAdd, $paramCom)
 {
     $db = new Database();
     $query = "select * from searchAddresses where searchId='{$searchId}'";
     $result = mysql_query($query) or die(mysql_error());
     $row = mysql_num_rows($result);
     if ($row > 0) {
         $rw = mysql_fetch_array(mysql_query($query));
         $id = $rw['id'];
         $query = "update searchAddresses set paramAddress='{$paramAdd}', paramComments='{$paramCom}' where id='{$id}'";
         $result = $db->runQuery($query);
     } else {
         $db->runQuery("insert into searchAddresses (searchId, paramAddress, paramComments) values ('{$searchId}','{$paramAdd}','{$paramCom}')");
     }
 }
Example #3
0
<?php

require '../init.php';
require '../tools.php';
if (!isLoggedIn()) {
    fail("Only logged in users can get recipes");
}
$beerId = htmlspecialchars($_GET['beerId']);
$query = "SELECT \n        beer.id,\n        beer.name,\n        beer.beerTypeId,\n        beer.beerType,\n        beer.createdBy,\n        user.username\n    FROM\n        (SELECT\n            beer.id,\n            beer.name,\n            beer.beerTypeId,\n            beerType.name as beerType,\n            beer.createdBy\n        FROM beer INNER JOIN beerType\n            ON beer.beerTypeId = beerType.id)\n        AS beer\n    INNER JOIN user\n        ON beer.createdBy = user.id\n    WHERE beer.id= :id\n    LIMIT 1";
$bind_params = array("id" => $beerId);
if ($data = Database::runQuery($query, $bind_params)) {
    success($data[0]);
}
fail("Error in beer/get.php");
Example #4
0
<?php

require '../utilities/init.php';
require '../utilities/tools.php';
$data = Database::runQuery("SELECT * FROM keg WHERE id = :id", array("id" => $_GET['kegId']));
$keg = $data[0];
// Grab the first result (should only be one)
?>
<form id="updateKegForm" method="post" action="<?php 
echo getBaseUrl();
?>
api/keg/update.php">
    <input type="hidden" name="kegId" id="kegId" value="<?php 
echo $keg['id'];
?>
">
    <div id="errorMessage" class="alert alert-danger text-center" role="alert" style="display: none;"></div>
    <div class="form-group">
        <label for="serialNum">Serial Number</label>
        <input type="text" class="form-control" id="serialNum" name="serialNum" maxlength="50" required value="<?php 
echo $keg['serialNum'];
?>
">
    </div>
</form>
Example #5
0
<!-- Local JavaScript -->
<script src="js/docs.js"></script>
<script src="js/github.info.js"></script>
<script src="js/custom.js"></script>

<title>Metro UI CSS : Metro Bootstrap CSS Library</title>
</head>
<body class="metro">
<?php 
if (isset($_GET['jid'])) {
    $id = $_GET['jid'];
}
include 'functions.php';
$handle = new Database();
$result = $handle->runQuery("SELECT JobId, JobTitle, JobDepartment, JobLocation, JobShortDesc, JobDetailDesc, JobCreated from webx_jobs WHERE JobActive = 1 AND JobId = '" . $handle->decryption($id) . "' ORDER BY JobOrderBy");
?>
<header class="bg-dark" data-load="header.php"></header>
<div class="">
    <!--<div style="background: url(images/b1.jpg) top left no-repeat; background-size: cover; height: 300px;">
        <div class="container" style="padding: 50px 20px">
            <h1 class="fg-white">Abx</h1>
            <h2 class="fg-white">Metro UI CSS a set of styles to create a site<br /> with an interface similar to Windows 8.</h2>
            <a href="https://github.com/olton/Metro-UI-CSS/archive/master.zip" class="place-left button bg-darkRed bg-hover-red fg-white fg-hover-white bd-orange" style="margin-top: 10px">
                <h3 style="margin: 10px 40px">Download <span class="icon-download-2 on-right"></span></h3>
            </a>
        </div>
    </div>-->
    <?php 
while ($row = $result->fetch_array(MYSQLI_ASSOC)) {
    ?>
Example #6
0
echo $data['supplier'];
?>
">
    </div>
    <div class="form-group">
        <label for="quantity">Quantity</label>
        <input type="number" class="form-control" id="quantity" name="quantity" value='<?php 
echo $data['quantity'];
?>
' required>
    </div>
    <div class="form-group">
        <label for="unitId">Units</label>
        <select name="unitId" class="form-control">
            <?php 
$units = Database::runQuery("SELECT * FROM unit");
foreach ($units as $unit) {
    if ($unit['id'] == $data['unitId']) {
        $selected = "selected";
    } else {
        $selected = "";
    }
    echo "<option value='{$unit['id']}' {$selected}>{$unit['name']}</option>";
}
?>
        </select>
    </div>
    <div class="form-group">
        <label for="lowValue">Low Value</label>
        <input type="number" class="form-control" id="lowValue" name="lowValue" value='<?php 
echo $data['lowValue'];
Example #7
0
<?php

require '../init.php';
require '../tools.php';
$dateStart = $_GET['start'] . " 00:00:00";
$dateEnd = $_GET['end'] . " 23:59:59";
$returnJSON = array();
$events = Database::runQuery("SELECT\n\t\tbrew.id AS brewId,\n\t\tbrew.brewStart,\n\t\tbrew.brewEnd,\n\t\tbrew.quantity,\n\t\tbrew.beerid,\n\t\tbrew.userid,\n\t\tbeer.name AS beerName,\n\t\tu.username as username,\n\t\tu.id as userId\n\tFROM\n\t\tbrew\n\tLEFT OUTER JOIN\n\t\tbeer ON beerid = beer.id\n\tLEFT OUTER JOIN\n\t\t`user` AS u ON userid = u.id\n\tWHERE :start1 BETWEEN brewStart AND brewEnd\n\tOR\t:end1 BETWEEN brewStart AND brewEnd\n\tOR brewStart BETWEEN :start2 AND :end2\n\tOR brewEnd BETWEEN :start3 AND :end3", array("start1" => $dateStart, "start2" => $dateStart, "start3" => $dateStart, "end1" => $dateEnd, "end2" => $dateEnd, "end3" => $dateEnd));
foreach ($events as $event) {
    $returnJSON[] = array('title' => $event['beerName'] . " - " . $event['brewId'] . " - " . $event['username'], 'id' => $event['brewId'], 'start' => $event['brewStart'], 'end' => $event['brewEnd'], 'editable' => $event['userid'] == $_SESSION['userId'] ? true : false, 'color' => $event['userid'] == $_SESSION['userId'] ? "#337ab7" : "#7BA9D0");
}
echo json_encode($returnJSON);
Example #8
0
<?php

require '../init.php';
require '../tools.php';
try {
    $data = Database::runQuery("INSERT INTO keg (serialNum) VALUES (:serialNum)", array("serialNum" => $_POST['serialNum']));
    success();
} catch (PDOException $e) {
    fail("Error in api/update.php: " . $e->getMessage());
}
Example #9
0
<?php

require '../init.php';
require '../tools.php';
$query = "SELECT \n        keg.id as kegId,\n        keg.serialNum,\n        kegorder.id as kegOrderId,\n        kegorder.customerId as customerId,\n        customer.firstName as customerFirstName,\n        customer.lastName as customerLastName\n    FROM keg\n    LEFT OUTER JOIN \n        (SELECT * FROM kegorder WHERE returned = 0) AS kegorder\n        ON kegorder.kegId=keg.id\n    LEFT OUTER JOIN customer ON kegorder.customerId = customer.id\n    GROUP BY keg.id";
if ($data = Database::runQuery($query)) {
    success($data);
}
fail("Error in keg/getAll.php");
Example #10
0
<?php

require '../init.php';
require '../tools.php';
$brewStart = new DateTime($_POST['brewStart']);
$brewStart = $brewStart->format("Y-m-d H:i:s");
$brewEnd = new DateTime($_POST['brewEnd']);
$brewEnd = $brewEnd->format("Y-m-d H:i:s");
try {
    $data = Database::runQuery("UPDATE brew\n                                SET brewStart = :brewStart,\n                                    brewEnd = :brewEnd,\n                                    quantity = :quantity,\n                                    beerId = :beerId,\n                                    userId = :userId\n                                WHERE id = :brewId", array("brewStart" => $brewStart, "brewEnd" => $brewEnd, "quantity" => (int) $_POST['quantity'], "beerId" => (int) $_POST['beerId'], "userId" => (int) $_POST['userId'], "brewId" => (int) $_POST['brewId']));
    if ($data) {
        success();
    } else {
        fail("Error in api/schedule/create.php: {$data} not valid");
    }
} catch (PDOException $e) {
    fail("Error in api/schedule/create.php: " . $e->getMessage());
}
Example #11
0
 public static function getCopenameFromId($userid)
 {
     try {
         $data = Database::runQuery("SELECT username, copename FROM user WHERE userid = :userid", array("userid" => $userid));
         if ($data[0]['copename']) {
             return $data[0]['copename'];
         } else {
             return $data[0]['username'];
         }
     } catch (Exception $e) {
         echo "getCopenameFromId Error: " . $e->getMessage();
     }
 }
Example #12
0
<?php

require '../init.php';
require '../tools.php';
$dateTime = new DateTime($_POST['dateTime']);
$dateTime = $dateTime->format("Y-m-d H:i:s");
try {
    $data = Database::runQuery("INSERT INTO fermentation(value, dateTime, typeId, unitId, brewId, userId)\r\n                                VALUES (:value, :dateTime, :typeId, :unitId, :brewId, :userId)", array("value" => (double) $_POST['value'], "dateTime" => $dateTime, "typeId" => (int) $_POST['quantity'], "unitId" => (int) $_POST['unitId'], "brewId" => (int) $_POST['beerId'], "userId" => $_SESSION['userId']));
    if ($data) {
        success();
    } else {
        fail("Error in api/analytics/addAnalytics.php: {$data} not valid");
    }
} catch (PDOException $e) {
    fail("Error in api/analytics/addAnalytics.php: " . $e->getMessage());
}
fail("Testing Fail");
Example #13
0
 public static function editGame($gameDetails)
 {
     $return = array();
     if (!is_array($gameDetails)) {
         $return['status'] = 'error';
         $return['message'] = 'Expecting an Array';
         return $return;
     }
     $primaryInsert = "";
     $primaryVal = "";
     $secondaryInsert = "";
     $secondaryVal = "";
     $bind_array = array("title" => $gameDetails['title'], "description" => $gameDetails['description'], "instruction" => $gameDetails['instruction'], "discussion" => $gameDetails['discussion'], "icon" => $gameDetails['icon'], "gameid" => $gameDetails['gameid']);
     if ($gameDetails['primary_type'] == "None") {
         $gameDetails['primary_type'] = "NULL";
         $primaryUpdate = ", primary_type = NULL";
     } else {
         $primaryUpdate = ", primary_type = :primary_type";
         $bind_array['primary_type'] = $gameDetails['primary_type'];
     }
     if ($gameDetails['secondary_type'] == "None") {
         $gameDetails['secondary_type'] = "NULL";
         $secondaryUpdate = ", secondary_type = NULL";
     } else {
         $secondaryUpdate = ", secondary_type = :secondary_type";
         $bind_array['secondary_type'] = $gameDetails['secondary_type'];
     }
     if ($gameDetails['primary_type'] != 'NULL' or $gameDetails['secondary_type'] != "NULL") {
         if ($gameDetails['primary_type'] == $gameDetails['secondary_type']) {
             $return['status'] = 'error';
             $return['message'] = "Primary Type and Secondary Type Must Be Different";
         }
     }
     try {
         Database::runQuery("UPDATE game \n                                SET icon = :icon, \n                                    title = :title, \n                                    description = :description, \n                                    instruction = :instruction, \n                                    discussion = :discussion\n                                    {$primaryUpdate} \n                                    {$secondaryUpdate}\n                                WHERE gameid = :gameid", $bind_array);
         $return['status'] = 'success';
         return $return;
     } catch (Exception $e) {
         $return['status'] = 'error';
         $return['message'] = 'Database Error';
         return $return;
     }
 }
Example #14
0
<?php

require '../utilities/init.php';
require '../utilities/tools.php';
?>
<form id="createBrewForm" method="post" action="<?php 
echo getBaseUrl();
?>
api/schedule/create.php">
    <div id="errorMessage" class="alert alert-danger text-center" role="alert" style="display: none;"></div>
    
    <div class="form-group">
        <label for="beerId">Beer</label>
        <select name="beerId" class="form-control">
            <?php 
$beers = Database::runQuery("SELECT * FROM beer");
foreach ($beers as $beer) {
    echo "<option value='{$beer['id']}'>{$beer['name']}</option>";
}
?>
        </select>
    </div>
    <div class="form-group">
        <label for="brewStart">Start Brew</label>
        <div class="input-group date datepicker" id="startDatepicker">
            <input type="text" class="form-control" name="brewStart">
            <span class="input-group-addon">
                <span class="glyphicon glyphicon-calendar"></span>
            </span>
        </div>
    </div>
Example #15
0
<?php

/*
 *
 *** PocketMine-MP Crash Archive ***
 *
 * This program is free software: you can redistribute it and/or modify
 * it under the terms of the GNU Lesser General Public License as published by
 * the Free Software Foundation, either version 3 of the License, or
 * (at your option) any later version.
 *
 * @author PocketMine Team
 * @link http://www.pocketmine.net/
 * 
 *
*/
define("ARCHIVE_ROOT", realpath(dirname(__FILE__)) . DIRECTORY_SEPARATOR);
if (php_sapi_name() !== "cli") {
    exit;
}
require_once "src/config.php";
require_once "src/Database.php";
$db = new Database();
if ($argv[1] === "delete") {
    $reportId = (int) $argv[2];
    $db->runQuery("DELETE FROM crash_report WHERE id = {$reportId};");
    unlink("reports/" . sha1($reportId . SECRET_SALT) . ".log");
    echo "Report {$reportId} deleted!\n";
}
Example #16
0
<?php

include 'functions.php';
$handle = new Database();
$output_dir = "uploads/";
if (isset($_SESSION['UserId'])) {
    if (isset($_FILES["user-resume"])) {
        //Filter the file types , if you want.
        if ($_FILES["user-resume"]["error"] > 0) {
            echo "Error: " . $_FILES["file"]["error"] . "<br>";
        } else {
            //move the uploaded file to uploads folder;
            move_uploaded_file($_FILES["user-resume"]["tmp_name"], $output_dir . $_FILES["user-resume"]["name"]);
            $name = $_FILES["user-resume"]["name"];
            $userid = $_SESSION['UserId'];
            $result = $handle->runQuery("select count(*) as count from webx_users_resume where UserId = '" . $userid . "'");
            $row = $result->fetch_array(MYSQLI_ASSOC);
            if (!empty($row['count'])) {
                $result = $handle->runQuery("update webx_users_resume set ResumeName = '" . $name . "' where UserId = '" . $userid . "'");
            } else {
                $result = $handle->runQuery("insert into webx_users_resume(UserId, ResumeName) values('" . $userid . "', '" . $name . "')");
            }
            echo "Resume Updated";
        }
    }
} else {
    echo "Something went wrong please login";
}
Example #17
0
<?php

require_once "config.php";
try {
    $types = array();
    $typesDB = Database::runQuery("SELECT * FROM type");
    foreach ($typesDB as $type) {
        $types[$type['typeid']] = $type['keyword'];
    }
    $config['smarty']->assign('types', $types);
    $config['smarty']->display('game/new_game.tpl');
} catch (Exception $e) {
    echo "Error: " . $e->getMessage();
}
Example #18
0
<?php

require '../utilities/init.php';
require '../utilities/tools.php';
?>
<form id="createBeerRecipeForm" method="post" action="<?php 
echo getBaseUrl();
?>
api/beer/create.php">
    <div id="errorMessage" class="alert alert-danger text-center" role="alert" style="display: none;"></div>
    <div class="form-group">
        <label for="name">Beer Name</label>
        <input type="text" class="form-control" id="name" name="name" maxlength="50" required>
    </div>
    <div class="form-group">
        <label for="beerTypeId">Beer Type</label>
        <select name="beerTypeId" class="form-control">
            <?php 
$beerTypes = Database::runQuery("SELECT * FROM beerType ORDER BY name");
foreach ($beerTypes as $beerType) {
    echo "<option value='{$beerType['id']}'>{$beerType['name']}</option>";
}
?>
        </select>
    </div>
</form>
Example #19
0
<?php

include "database.php";
$db = new Database("localhost", "root", "");
$db->useDb("my_db");
$users = $db->runQuery("SELECT * FROM user");
//Insert into database;
if (isset($_POST['submit'])) {
    $name = $_POST['name'];
    $password = $_POST['password'];
    $sql = "INSERT INTO user ( name, password) VALUES ( '{$name}', '{$password}' )";
    $db->runQuery($sql);
    header("Location:viewUser.php");
}
Example #20
0
 public function getDeckGames($limit = 100, $offset = 0)
 {
     $limit = (int) $limit;
     $offset = (int) $offset;
     $games = array();
     $data = Database::runQuery("SELECT gameid FROM game WHERE deckid = {$this->deckid} LIMIT {$limit} OFFSET {$offset}");
     foreach ($data as $game) {
         $games[] = new Game((int) $game['gameid']);
     }
     return $games;
 }
Example #21
0
<?php

require '../init.php';
require '../tools.php';
try {
    $brews = Database::runQuery("SELECT\n    \t\tbrew.id AS brewId,\n    \t\tbrew.brewStart,\n    \t\tbrew.brewEnd,\n    \t\tbrew.quantity,\n    \t\tbrew.beerid,\n    \t\tbrew.userid,\n    \t\tbeer.name AS beerName,\n    \t\tu.username as username,\n    \t\tu.id as userId\n    \tFROM\n    \t\tbrew\n    \tLEFT OUTER JOIN\n    \t\tbeer ON beerid = beer.id\n    \tLEFT OUTER JOIN\n    \t\t`user` AS u ON userid = u.id");
    success($brews);
} catch (PDOException $e) {
    fail("Error in api/getBrews: " . $e->getMessage());
}
?>
	
Example #22
0
<?php

require '../init.php';
require '../tools.php';
$brewStart = new DateTime($_POST['brewStart']);
$brewStart = $brewStart->format("Y-m-d H:i:s");
$brewEnd = new DateTime($_POST['brewEnd']);
$brewEnd = $brewEnd->format("Y-m-d H:i:s");
try {
    $data = Database::runQuery("INSERT INTO brew (brewStart, brewEnd, quantity, beerId, userId)\n                                VALUES (:brewStart, :brewEnd, :quantity, :beerId, :userId)", array("brewStart" => $brewStart, "brewEnd" => $brewEnd, "quantity" => (int) $_POST['quantity'], "beerId" => (int) $_POST['beerId'], "userId" => $_SESSION['userId']));
    if ($data) {
        success();
    } else {
        fail("Error in api/schedule/create.php: {$data} not valid");
    }
} catch (PDOException $e) {
    fail("Error in api/schedule/create.php: " . $e->getMessage());
}
fail("Testing Fail");
Example #23
0
 function GetStateCount($state)
 {
     $ok = parent::runQuery("SELECT COUNT(*) FROM `baseline` WHERE state=" . $state);
     $result = parent::getResult();
     $row = $result->fetch_row();
     return intval($row[0]);
 }