/**
* @param $table
* @param null $where
* @return int
*/
public function count($table, $where = NULL)
{
if (empty($this->_reader)) {
return $this->_writer->count($table, $where);
} else {
return $this->_reader->count($table, $where);
}
}
function login()
{
if (session_id() == '') {
session_start();
}
if (isset($_POST["mail"]) & isset($_POST["password"]) & isset($_POST["cre"])) {
if ($_POST["mail"] != "" and $_POST["password"] != "" and $_POST["cre"] != "") {
$mail = $_POST["mail"];
$password = $_POST["password"];
$role = $_POST["cre"];
require_once 'SessionManager.php';
$session_manager = new SessionManager();
require_once 'medoo.min.php';
$database = new medoo();
$count = $database->count("triotrack_users", ["email" => "{$mail}"]);
if ($count > 0) {
$profile = $database->get("triotrack_users", ["username", "password", "salt", "client"], ["email" => "{$mail}"]);
if ($role === "admin") {
if ($profile["password"] === sha1($password . $profile["salt"])) {
$username = $profile["username"];
$client = $profile["client"];
$cookie = array("email" => "{$mail}", "username" => "{$username}", "password" => "{$password}", "client" => "{$client}", "role" => "{$role}");
$encoded_cookie = $session_manager->encode_session(json_encode($cookie));
$_SESSION["user_id"] = $encoded_cookie;
setcookie("user_id", $encoded_cookie, time() + 86400 * 1, "/");
// 86400 = 1 day
echo "admin";
exit;
} else {
echo "failed";
exit;
}
} else {
if ($profile["client"] === $password) {
$username = $profile["username"];
$client = $profile["client"];
$cookie = array("email" => "{$mail}", "username" => "{$username}", "password" => "{$password}", "client" => "{$client}", "role" => "{$role}");
$encoded_cookie = $session_manager->encode_session(json_encode($cookie));
$_SESSION["user_id"] = $encoded_cookie;
setcookie("user_id", $encoded_cookie, time() + 86400 * 1, "/");
// 86400 = 1 day
echo "client";
exit;
} else {
echo "failed";
exit;
}
}
}
} else {
echo "failed";
}
exit;
}
}
}
if (!preg_match("/^[0-9a-zA-ZÄÜÖ_.-]+@[0-9a-z.-]+\\.[a-z]{2,6}\$/", $email)) {
$fehler['email'] = "<font color=#cc3333>Please enter a <strong>e-mail-address</strong>.\n<br /></font>";
}
if (!$password) {
$fehler['password'] = "******";
}
if (strlen($password) < 8) {
$fehler['password'] = "******";
}
if ($repassword != $password) {
$fehler['repassword'] = "******";
}
$database = new medoo(['database_type' => 'mysql', 'database_name' => $dbname, 'server' => $servername, 'username' => $username, 'password' => $dbpassword]);
//$datas = $database->select("tmpapplicant", "*");
$countuser = $database->count("applicant", ["username" => $name]);
if ($countuser > 0) {
$fehler['name'] = "<font color=#cc3333><strong>User Name</strong> already exists..<br /></font>";
}
$countemail = $database->count("tmpapplicant", ["email" => $email]);
if ($countemail > 0) {
$fehler['email'] = "<font color=#cc3333><strong>e-mail-address</strong> already exists.\n<br /></font>";
}
if (!isset($fehler)) {
//echo "done";
//include("validatelogin.php");
$action = "upload.php";
$passwordhash = md5($password);
}
}
?>
* Date: 02.02.2016
* Time: 23:38
*/
require_once 'vendor/autoload.php';
//open database connection
$database = new medoo(['database_type' => 'mysql', 'database_name' => 'r8db', 'server' => '172.16.2.109', 'username' => 'admin', 'password' => 'admin', 'charset' => 'utf8']);
$user_id = $database->select("user", ["[>]entry" => "user_id"], ["entry.entry_id"], ["entry_id" => 10]);
$user = $database->get('user', ['[>]entry' => "user_id"], ['user_id', 'email', 'username', 'admin', 'nsfw'], ['entry_id' => 10]);
$html = '<link rel="stylesheet" href="https://maxcdn.bootstrapcdn.com/bootstrap/3.3.6/css/bootstrap.min.css"><div class="container"><div class="row">';
$html .= '<form class="clearfix" method="get">
<div class="form-group col-sm-4"><label for="action">Action</label><select class="form-control" name="action" id="action"><option value="show">show</option><option value="delete">delete</option><option value="add">add</option><option value="set">set</option></select></div>
<div class="form-group col-sm-4"><label for="amount">Amount</label><input class="form-control" type="number" name="amount" id="amount" value=""></div>
<div class="form-group col-sm-4"><label>Functions</label><div><button type="submit" class="btn btn-primary">Submit</button> <button type="reset" class="btn btn-warning">Reset</button></div></div>
</form>';
$html .= '</div><div class="row"><div class="col-sm-12">';
$count = $database->count('entry');
$database->query('ALTER TABLE "entry" AUTO_INCREMENT = ' . ($count + 1));
if (isset($_GET['action'])) {
$amount = isset($_GET['amount']) && is_numeric($_GET['amount']) ? intval($_GET['amount']) : 100;
if ($_GET['action'] == 'delete' && $count != 0) {
$database->delete('entry', ['ORDER' => 'entry_id DESC', 'LIMIT' => $amount]);
} elseif ($_GET['action'] == 'delete') {
$html .= 'Where nothing is, nothing can be removed.';
} elseif ($_GET['action'] == 'add') {
for ($i = $count + 1; $i < $count + $amount + 1; ++$i) {
$data = ['user_id' => 1, 'category_id' => 1, 'title' => 'Dummy #' . $i, 'desc' => 'Lorem Ipsum', 'image' => 'https://placehold.it/400x400'];
$database->insert('entry', $data);
}
} elseif ($_GET['action'] == 'set') {
$database->delete('entry', ['LIMIT' => 99999999999999]);
$count = $database->count('entry');
/**
* Controlla che sia ancora possibile iscriversi all'aula studio
*
* @param medoo $database Connessione con il database
* @param int $id
* @return boolean
*/
function tempopomeriggio($database, $id)
{
return $database->count("aule", array("AND" => array("id" => $id, "#data[>]" => "NOW()"))) != 0;
}
/**
* @param string $table
* @param array $join
* @param string|array $column
* @param array $where
* @return bool|int
*
* Or,
* @param string $table
* @param array $where
* @return bool|int
*/
public function count($table, $join = null, $column = null, $where = null)
{
$re = parent::count($table, $join, $column, $where);
$this->lastSql = $this->last_query();
$this->lastError = $this->error();
return $re;
}
/**
* Return the number of rows in the table
* @param string $where
* @param bool $extCall
* @return bool|int
* @throws FatalError
*/
public function getNumOfRows($where = '', $extCall = false)
{
$this->gp->checkAccess(__FUNCTION__, $extCall);
return $this->dbConnection->count($this->dbTable, $where);
}
$app = new \Slim\Slim(array('view' => new \Slim\Views\Twig()));
$app->view()->parserExtensions = array(new \Slim\Views\TwigExtension());
$database = new medoo($config['database']);
/*
* Go away message for stray users
*/
$app->get('/', function () {
echo 'This is the validation endpoint for the womath research project.';
echo 'You need to use the link in the email to validate.';
})->name('root');
/*
* Validation endpoints
*/
$app->get('/:uuid/correct', function ($uuid) use($app, $database) {
// ID must exist
if ($database->count('people', ['uuid' => $uuid]) !== 1) {
return $app->render('error.twig');
}
// Mark entry as correct
$database->update('people', ['validation' => 'correct'], ['uuid' => $uuid]);
// Say thank you
$company = $database->select('people', ['company_name'], ['uuid' => $uuid])[0]['company_name'];
return $app->render('correct.twig', ['company' => $company, 'uuid' => $uuid]);
})->name('correct');
$app->get('/:uuid/wrong', function ($uuid) use($app, $database) {
// ID must exist
if ($database->count('people', ['uuid' => $uuid]) !== 1) {
return $app->render('error.twig');
}
// Mark entry as wrong
$database->update('people', ['validation' => 'wrong'], ['uuid' => $uuid]);
<?php
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/7/8
* Time: 16:18
*/
require_once '../../parameter/Medoo/Resource/medoo.php';
$mydb = new medoo('meetingmanage');
$num = $mydb->count('update');
$id = 90000 + $num;
$mydb->insert('update', array('ID' => $id, 'DATE' => date('Y/m/d')));
//获得room id 全部
$arr_id = $mydb->select('rooms', 'ROOM_ID', array('STATE[!]' => 0));
$num_id = count($arr_id);
//var_dump($arr_id);
//
//循环滚动{
for ($i = 0; $i < $num_id; $i++) {
$sta = $mydb->select('rooms', array('ONE1', 'ONE2', 'ONE3', 'ONE4', 'ONE5', 'ONE6', 'TWO1', 'TWO2', 'TWO3', 'TWO4', 'TWO5', 'TWO6', 'THREE1', 'THREE2', 'THREE3', 'THREE4', 'THREE5', 'THREE6'), array('ROOM_ID' => $arr_id[$i]));
$state = $sta[0];
echo $state['TWO1'];
$mydb->update('rooms', array('ONE1' => $state['TWO1'], 'ONE2' => $state['TWO2'], 'ONE3' => $state['TWO3'], 'ONE4' => $state['TWO4'], 'ONE5' => $state['TWO5'], 'ONE6' => $state['TWO6'], 'TWO1' => $state['THREE1'], 'TWO2' => $state['THREE2'], 'TWO3' => $state['THREE3'], 'TWO4' => $state['THREE4'], 'TWO5' => $state['THREE5'], 'TWO6' => $state['THREE6'], 'THREE1' => 0, 'THREE2' => 0, 'THREE3' => 0, 'THREE4' => 0, 'THREE5' => 0, 'THREE6' => 0), array('ROOM_ID' => $arr_id[$i]));
}
function controleer_email($email)
{
$database = new medoo();
$emailExists = $database->count("gebruikers", ["AND" => ["email" => $email]]);
/* If exectly one user has been found */
if ($emailExists == 1) {
return false;
} else {
return true;
}
}
if (isset($_SESSION['isLoggedIn'], $_SESSION['email']) && $_SESSION['isLoggedIn'] == "true") {
$user = $database->get("gebruikers", "*", ["AND" => ["email" => $_SESSION['email']]]);
//print_r($user);
include 'assets/html/nav.html';
include 'assets/html/login_success.html';
include 'phpAPI/home.php';
//header("Location: /wedstrijdplatform/#/spelpagina"); //dit mag hier niet, zorgt voor eindeloze redirect ( na post ziet hij dat er al een sessie is dus komt hij hier en gaat hij nogmaals doorverwijzen
//naar spelpagina, en dit blijft zich herhalen, dit stond hier omdat je als je al ingelogd bent, dat je automatisch de spelpagina ziet en niet opnieuw moet inloggen)
include "assets/html/footer.html";
//session_destroy(); //moet weg, staat hier enkel voor test
} else {
if (isset($_POST['inputEmail'], $_POST['inputPassword'])) {
$database = new medoo();
$email = trim($_POST['inputEmail']);
/* Check for correct email and password */
$emailExists = $database->count("gebruikers", ["AND" => ["email" => $email]]);
/* If exectly one user has been found */
if ($emailExists == 1) {
$enteredPassword = trim($_POST['inputPassword']);
$user = $database->get("gebruikers", "*", ["AND" => ["email" => $email]]);
//print_r($user);
$dbpassword = $user['wachtwoord'];
if (password_verify($enteredPassword, $dbpassword)) {
$_SESSION['email'] = $email;
$_SESSION['isLoggedIn'] = "true";
/*include 'html/nav.html';
echo "<h1>User was get from post!</h1>"; /////////////////////////////////delete
include 'html/login_success.html';
echo "<h1>Normal user logged in.</h1>";
include 'php/home.php';*/
header("Location: /wedstrijdplatform/#/spelpagina");
/**
*获得自身的注册数和认证数&订单数,如果我是主管，将学校列表写入session
*/
protected function get_self_counter()
{
$local = new medoo();
$db = new maindb();
$register = $db->count('p_user', '*', array('invite' => $_SESSION['userinfo']['ekey']));
$authority = $db->count('p_user', '*', array('AND' => array('invite' => $_SESSION['userinfo']['ekey'], 'auth' => 1)));
$orders = $local->count('orders', '*', array('ekey' => $_SESSION['userinfo']['ekey']));
unset($db);
unset($local);
if ($_SESSION['userinfo']['auth'] == 1) {
//主管，写入学校列表
$_SESSION['school'] = school_handler::through_area_get_school($_SESSION['userinfo']['province']);
}
$_SESSION['userinfo']['register'] = $register;
$_SESSION['userinfo']['authority'] = $authority;
$_SESSION['userinfo']['orders'] = $orders;
}
/**
* Created by PhpStorm.
* User: KeenSting
* Date: 2015/10/15
* Time: 17:09
*/
require_once '../../../medoo/medoo.php';
require_once '../../../medoo/maindb.php';
$type = $_POST['type'];
$begin = ($_POST['index'] - 1) * 20;
$local = new medoo();
$remote = new maindb();
//管理员查全部的
if ($type == 'admin') {
$re = $local->select('ambassador', '*', array('auth[>]' => 0, 'LIMIT' => [$begin, 20]));
} elseif ($type == 'manager') {
$province = $_POST['province'];
$re = $local->select('ambassador', '*', array('AND' => array('province' => $province, 'auth' => 2), 'LIMIT' => [$begin, 20]));
}
//统一去远端数据库匹配数据
foreach ($re as &$v) {
$reg = $remote->count('p_user', '*', array('invite' => $v['ekey']));
$aut = $remote->count('p_user', '*', array('AND' => array('invite' => $v['ekey'], 'auth' => 1)));
$orders = $local->count('orders', '*', array('ekey' => $v['ekey']));
$v['reg'] = $reg;
$v['aut'] = $aut;
$v['ord'] = $orders;
}
unset($remote);
unset($local);
echo json_encode(array('index' => $_POST['index'], 'list' => $re));
echo 'error';
} else {
if ($re[0]['province'] != $_SESSION['userinfo']['province'] && $_SESSION['userinfo']['auth'] == 1) {
echo 'unauthrized';
exit;
}
//key拥有者所在学校的数据
$reg = $remote->count('p_user', '*', array('school' => $re[0]['school']));
$aut = $remote->count('p_user', '*', array("AND" => array('school' => $re[0]['school'], 'auth' => 1)));
$reg_in = $remote->count('p_user', '*', array("AND" => array('school' => $re[0]['school'], 'invite[!]' => '')));
$aut_in = $remote->count('p_user', '*', array("AND" => array('school' => $re[0]['school'], 'invite[!]' => '', 'auth' => 1)));
$school_data = array('reg' => $reg, 'aut' => $aut, 'reg_in' => $reg_in, 'aut_in' => $aut_in, 'reg_na' => $reg - $reg_in, 'aut_na' => $aut - $aut_in);
$re[0]['reg'] = $remote->count('p_user', '*', array('AND' => array('invite' => $re[0]['ekey'], 'reg_time[>]' => $begin, 'reg_time[<]' => $end)));
$re[0]['aut'] = $remote->count('p_user', '*', array('AND' => array('invite' => $re[0]['ekey'], 'auth_time[>]' => $begin, 'auth' => 1, 'auth_time[<]' => $end)));
$re[0]['my_auth'] = $_SESSION['userinfo']['auth'];
$re[0]['ord'] = $local->count('orders', '*', array('AND' => array('ekey' => $re[0]['ekey'], 'u_time[>]' => $begin, 'u_time[<]' => $end)));
echo json_encode(array('info' => $re[0], 'data' => $school_data));
}
exit;
} elseif ($type == 'school') {
//按照学校查询
$name = $_POST['name'];
$begin = $_POST['begin'];
$end = $_POST['end'];
if ($_SESSION['userinfo']['auth'] == 2) {
$name = $_SESSION['userinfo']['school'];
}
if ($_SESSION['userinfo']['auth'] == 1 && !in_array($name, $_SESSION['school'])) {
echo 'noschool';
exit;
}
//查询一次远端数据库，匹配订单状态
$item = $remote->select('p_order', '*', array('id' => $id));
if (empty($item)) {
echo 'noinfo';
} elseif ($item[0]['state'] < 2) {
echo 'unfinish';
} else {
//todo
//可能会添加几个大使开放所有订单种类
$sid = $item[0]['sid'];
$sell_info = $remote->select('p_sell_goods', 'ccid', array('id' => $sid));
$ccid = $sell_info[0];
if ($ccid != 100) {
echo 'type';
exit;
}
$check = $local->count('orders', '*', array('order_id' => $id));
if ($check == 1) {
echo 'repeat';
exit;
}
$re = $local->insert('orders', array('ekey' => $_SESSION['userinfo']['ekey'], 'state' => 0, 'price' => $item[0]['price'], 'u_time' => time(), 'c_time' => $item[0]['time'], 'order_id' => $id, 'type' => 0, 'act_id' => 0));
if ($re != 0) {
echo 'ok';
} else {
echo 'error';
}
//todo 写
//入本地
}
//print_r($item);
