function user_insert($dbh,$upts,$uid,$time,$gid,$uhash)
{
try
	{
		$uuid=str_replace(".".$gid,"",$uid);
		$stmt1 = $dbh->query("SELECT COUNT(*) from `banned` WHERE tb_uid = '$uuid'");
		$result1 = $stmt1->fetchColumn();
		if ($result1 > 0)
			$upts=0;
		if ($upts>0)
		{
			$stmt = $dbh->prepare("INSERT INTO users_table (tb_pts, tb_time, tb_uid, tb_gid) VALUES(:upts, :time, :uid, :gid)
			ON DUPLICATE KEY UPDATE tb_pts = GREATEST(:upts2, tb_pts), tb_time = :time2, tb_gid = :gid2");
			$stmt ->bindparam(':upts', $scdc, PDO::PARAM_STR);
			$stmt ->bindparam(':time', $time, PDO::PARAM_STR);
			$stmt ->bindparam(':uid', $uid, PDO::PARAM_STR);
			$stmt ->bindparam(':gid', $gid, PDO::PARAM_STR);
			$stmt ->bindparam(':upts2', $scdc, PDO::PARAM_STR);
			$stmt ->bindparam(':time2', $time, PDO::PARAM_STR);
			$stmt ->bindparam(':gid2', $gid, PDO::PARAM_STR);

			$stmt->execute();
			echo "1";
		}
		else
			echo "0";
	}
	catch (PDOExecption $ex)
	{
		echo "0";
	}
	//$dbh = null;
}

INSERT INTO users_table (tb_pts, tb_time, tb_uid, tb_gid) VALUES(:upts, :time, :uid, :gid)
	ON DUPLICATE KEY UPDATE tb_pts = GREATEST(:upts, tb_pts), tb_time = :time, tb_gid = :gid

CREATE TABLE IF NOT EXISTS `user_table` (
  `tb_uid` varchar(32) NOT NULL,
  `tb_pts` int(11) NOT NULL,
  `tb_gid` varchar(10) NOT NULL,
  `tb_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `user_table`
 ADD PRIMARY KEY (`tb_uid`), ADD UNIQUE KEY `hs_uid` (`tb_uid`);

CREATE TABLE IF NOT EXISTS `users_table` (
  `tb_uid` int(16) NOT NULL,
  `tb_pts` int(11) NOT NULL,
  `tb_gid` varchar(10) NOT NULL,
  `tb_time` datetime NOT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;


ALTER TABLE `users_table`
 ADD UNIQUE KEY `uid` (`tb_uid`,`tb_gid`);