<?
class func{
    var $host = "localhost";
    var $user = "user";
    var $pass = "pass";

    function login($username,$password){
        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $username = htmlentities($username);
        $username = mysql_real_escape_string($username);
        $query = "select username,password,salt from users where username='$username'";

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $user = mysql_result($r,0,"username");
        $pass = mysql_result($r,0,"password");
        $salt = mysql_result($r,0,"salt");

        $password = md5($salt.$password.$salt);

        if($pass == $password){
            return 1;
        }else{
            return 0;
        }
    }

    function userid($username){
        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $username = htmlentities($username);
        $username = mysql_real_escape_string($username);
        $query = "select id from users where username='$username'";

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $uid = mysql_result($r,0);

        return $uid;
    }

    function username($userid){
        $query = "select username from users where id='$userid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $uname = mysql_result($r,0);

        return $uname;
    }

    function userg($gid){
        $query = "select color,title,avatar from usergroups where id='$gid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $color = mysql_result($r,0,"color");
        $title = mysql_result($r,0,"title");
        $avatar = mysql_result($r,0,"avatar");

        return $color.">>".$title;
    }

    function gid($userid){
        $query = "select usergroupid from users where id='$userid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $gid = mysql_result($r,0);

        $gid = $this->userg($gid);

        return $gid;
    }

    function date($date){
        $mon = substr($date, -8, -6);
        $mon = str_replace("0","",$mon);
        $day = substr($date, -6, -4);
        $day = str_replace("0","",$day);
        $eday = substr($date, -5, -4);
        $yea = substr($date, -4);

        switch($mon){
            case "1":
                $month = "January";
            break;

            case "2":
                $month = "Febuary";
            break;

            case "3":
                $month = "March";
            break;

            case "4":
                $month = "April";
            break;

            case "5":
                $month = "May";
            break;

            case "6":
                $month = "June";
            break;

            case "7":
                $month = "July";
            break;

            case "8":
                $month = "August";
            break;

            case "9":
                $month = "September";
            break;

            case "10":
                $month = "October";
            break;

            case "11":
                $month = "November";
            break;

            case "12":
                $month = "December";
            break;
        }

        switch($eday){
            case "0":
                $end = "th";
            break;

            case "1":
                $end = "st";
            break;

            case "2":
                $end = "nd";
            break;

            case "3":
                $end = "rd";
            break;

            case "4":
                $end = "th";
            break;

            case "5":
                $end = "th";
            break;

            case "6":
                $end = "th";
            break;

            case "7":
                $end = "th";
            break;

            case "8":
                $end = "th";
            break;

            case "9":
                $end = "th";
            break;
        }

        return $month." ".$day.$end.", ".$yea;
    }

    function time($time){
        $hou = substr($time, -4, -2);
        $hou = str_replace("0","",$hou);
        $min = substr($time, -2);
        $pam = "am";

        if($hou > 12){
            $hou = $hou - 12;
            $pam = "pm";
        }

        return $hou.":".$min." ".$pam;
    }

    function editpost($postid,$userid,$content){
        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $date = date("mdY");
        $con = mysql_real_escape_string($content);
        $query = "update news set content = '$con' edit = '1',edit_user = '$userid',edit_date = '$date' WHERE id = '$postid' LIMIT 1";

        $r = mysql_query($query) OR die("ERROR - QUERY");

        if(!$r){
            return 0;
        }else{
            return 1;
        }
    }

    function subpost($userid,$content){
        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $date = date("mdY");
        $time = strftime("%H%M");
        $con = mysql_real_escape_string($content);
        $query = "insert news set userid = '$userid',date = '$date',time = '$time',content = '$con'";

        $r = mysql_query($query) OR die("ERROR - QUERY");

        if(!$r){
            return 0;
        }else{
            return 1;
        }
    }

    function post_exist($id){
        $query = "select * from news where id='$id'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $ck = mysql_num_rows($r);

        if($ck == 0){
            return 0;
        }else{
            return 1;
        }
    }

    function pullcontent($postid){
        $query = "select userid,time,date,content from news where id='$postid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $content = mysql_result($r,0,"content");
        $user = mysql_result($r,0,"userid");
        $date = mysql_result($r,0,"date");
        $time = mysql_result($r,0,"time");

        $uname = $this->username($user);
        $uname = htmlentities($uname);
        $date = $this->date($date);
        $time = $this->time($time);

        return $uname.">>".$date.">>".$time.">>".$content;
    }

    function findedit($postid){
        $query = "select edit from news where id='$postid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $edit = mysql_result($r,0);

        if($edit == "1"){
            return 1;
        }else{
            return 0;
        }
    }

    function pulleditu($postid){
        $query = "select edit_user,edit_date from news where id='$postid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $edit_u = mysql_result($r,0,"edit_user");
        $edit_d = mysql_result($r,0,"edit_date");

        $uname = $this->username($edit_u);
        $uname = htmlentities($uname);
        $date = $this->date($edit_d);

        return "Post Edited on $date by $uname";
    }

    function pulleditd($postid){
        $query = "select edit_date from news where id='$postid'";

        $con = mysql_connect($this->host,$this->user,$this->pass) OR die("ERROR - QUERY");
        mysql_select_db("fame_zap",$con) OR die("ERROR - DATABASE");

        $r = mysql_query($query) OR die("ERROR - QUERY");
        $edit_d = mysql_result($r,0);

        return $edit_d;
    }
}

$funcl = new func;
?>