www/functions/func_user.php


1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

<?php
function account($db){
        echo "loged in as: " . $_SESSION["username"];
        $safe_name=SQLite3::escapeString("$_SESSION[username]");
        $invite_db = $db->query("SELECT invites FROM user WHERE name='" . $safe_name . "';");
        $invite_ar = $invite_db->fetchArray(SQLITE3_NUM);
        $invite = $invite_ar[0];

        echo "<br><br>";
        echo "You have currently $invite invites. <br>";
	return true;
}

function user_id($db, $user){

	$owner_db = $db->query("SELECT id FROM user WHERE name='" . SQLite3::escapeString($user) . "';");
	$owner_ar = $owner_db->fetchArray(SQLITE3_NUM);
	if(empty($owner_ar[0])){
		return false;
	}

	$owner = $owner_ar[0];
	return $owner;
}