#!/usr/bin/php
<?php
        ## CONFIG
## SET LOGIN TO MYSQL HERE
$dbhost = 'localhost';
$dbuser = 'login';
$dbpass = 'pass';
$dbname = 'nickdb';
$nickdbtable = "UserNames";
$conn = @mysql_connect($dbhost, $dbuser, $dbpass);

$select = @mysql_select_db($dbname);
if(!$conn) {
    print "Cant Build Connection Database!!";
    exit();
}
if(!$select) {
    print "Check Database Selection!!";
    exit();
}




######DONT EDIT BELOW HERE, UNLESS YOU KNOW WHAT YOU ARE DOING ########################
$arg = $argv[1];     // argument from tcl
if(empty($arg)) {
echo "You missing name here\n";
exit();
} else {
    $getgrp     = "SELECT * FROM ".$nickdbtable." WHERE ftpUser ='$arg'";
    $query      = @mysql_query($getgrp);
    $rows       = @mysql_num_rows($query);
    if($rows == 0) {
        $getgrp     = "SELECT * FROM ".$nickdbtable." WHERE ircUser ='$arg'";
    $query      = @mysql_query($getgrp);
    $rows       = @mysql_num_rows($query);
        if($rows == 0) {
        echo "Cant find either $arg registered as username or ircname\n";
        exit();

    }
}

    $value = @mysql_fetch_array($query);
    $ftpUser = $value['ftpUser'];
    $ircUser = $value['ircUser'];
    $groups = $value['groups'];
    $flags = $value['flags'];
    $time = $value['time'];
    $time = @date("d M Y H:i",$time);
    $output = "\0038FTP\003 \002".$ftpUser."\002 \0035::\003 \0038IRC\003 \002".$ircUser."\002 \0035::\003 \0038GROUP\003 \002".$groups."\002 \0035::\003 \0038FLAGS\003 \002".$flags."\002 \0035::\003 \0038LAST INVITE\003 \002".$time."\002\n";
    echo $output;
}

?>