if($tokens2[1] == "!" && $tokens2[2] == "#vhosts" && $tokens2[3] == ":!approve") { $u_qry = mysql_query("select `nick`,`virtualhost`,`cloakhost` from `users_on` where `nick`='".$source2."'"); $u = mysql_fetch_array($u_qry); $v_qry = mysql_query("select `adminhost`,`status`,`nick` from `vhosts` where `nick`='".$source2."'"); $v = mysql_fetch_array($v_qry); if($u['virtualhost'] == "*") { $host = $u['cloakhost']; } else { $host = $u['virtualhost']; } if(($u['hostname'] == $u['realhost'] || $host == $v['adminhost']) && $v['status'] == "Admin") { if($tokens2[4] == "") { sock(":Vhosts ! #vhosts :7Try adding a nickname, idiot!"); } else { $t_qry = mysql_query("select `adminhost`,`status`,`nick` from `vhosts` where `nick`='".$tokens2[4]."'"); $t_cnt = mysql_num_rows($t_qry); if($t_cnt != 1) { sock(":Vhosts ! #vhosts :7Try a nickname that exists..."); } else { $t = mysql_fetch_array($t_qry); if($t['status'] != "Pending") { sock(":Vhosts ! #vhosts :7Try a nickname that is awaiting approval smartass..."); } else { mysql_query("update `vhosts` set `status`='Normal',`credit`='10',`logs`=logs+1 where `nick`='".$tokens2[4]."'"); sock(":Vhosts ! #private :".$source2." approved ".$tokens2[4]."'s registration."); sock(":Vhosts ! #vhosts :7".$tokens2[4]." can now use the Vhost system."); mysql_query("insert into `vhost_logs` (`nick`,`log`,`timestamp`) values ('".$tokens2[4]."', 'Registration approved by ".$source2.".', '".time()."')"); } } } } else { sock(":Vhosts ! #vhosts :7Access denied."); sock(":Vhosts ! #private :".$source2." tried using !approve but was denied access."); } } --- SHOULD BECOME --- if($command == '!approve') { $v_qry = db_query('SELECT adminhost,status,nick FROM '.$config['db']['prefix'].'vhosts WHERE nick="'.$source.'"'); $v = db_fetch_array($v_qry); $host = ($usrinfo['virtualhost'] == '*' ? $usrinfo['cloakhost'] : $usrinfo['virtualhost']); if((($usrinfo['hostname'] == $v['realhost'] || $host == $v['adminhost']) && $v['status'] == 'Admin') || (IsOper($source) && $config['vhosts']['operadmin']) || in_array($source,$config['vhosts']['pm_admin']))) { if($buffer[4] == "") { notice($bot,$source,'7Missing nickname parameter.'); } else { $t_qry = db_query('SELECT adminhost,status,nick FROM '.$config['db']['prefix'].'vhosts WHERE nick="'.$buffer[4].'"'); $t_cnt = db_num_rows($t_qry); if($t_cnt != 1) { notice($bot,$source,'7Nickname '.$buffer[4].' has not registered.'); } else { $t = db_fetch_array($t_qry); if($t['status'] != "Pending") { notice($bot,$source,'7Nickname '.$buffer[4].' is not pending approval.'); } else { db_query('UPDATE '.$config['db']['prefix'].'vhosts SET tatus="Normal",credit=10,logs=logs+1 WHERE nick="'.$buffer[4].'"'); if(isset($config['vhosts']['logchan'])) { privmsg($bot,$config['vhosts']['logchan'],$source.' approved '.$buffer[4].'\'s registration.'); } privmsg($bot,$config['vhosts']['channel'],'7'.$buffer[4].' can now use the Vhost system.'); db_query('INSERT INTO '.$config['db']['prefix'].'vhost_logs (nick,log,timestamp) VALUES ("'.$buffer[4].'","Registration approved by '.$source.'.", UNIX_TIMESTAMP())'); } } } } else { notice($bot,$source,'7Access denied.'); if(isset($config['vhosts']['logchan'])) { privmsg($bot,$config['vhosts']['logchan'],$source.' tried using !approve but was denied access.'); } } }