Skip to content
db_isuser.php 939 B
Newer Older
<?php
ini_set('display_errors', false);
require_once('db_conf.inc.php');

try{
    // Connect database
    $db = new mysqli($db_host, $db_user, $db_pass, $db_name);
    result_false(mysqli_connect_errno());

    // Get arguments
    $arg_email = '';

    result_false(count($argv) != 3);
    $arg_email = $argv[1].'@'.$argv[2];

    // check for existing user
    $dbmail = $db->real_escape_string($arg_email);
    $query = $db->prepare("SELECT count(*) AS usercount FROM xmpp_user WHERE jid LIKE ? AND active='y' AND server_id=?");
    $query->bind_param('si', $arg_email, $isp_server_id);
    $query->execute();
    $query->bind_result($usercount);
    $query->fetch();
    $query->close();

    result_false($usercount != 1);
    result_true();

}catch(Exception $ex){
    echo 0;
    exit();
}

function result_false($cond = true){
    if(!$cond) return;
    echo 0;
    exit();
}
function result_true(){
    echo 1;
    exit();
}