FUNCTION Query($query) {
$result = MySQL_Query($query, $this->DB) OR Die(VA_Message("MySQL Error #".MySQL_ErrNo()." :\n".MySQL_Error()."\n".$query, "bug"));
$this->affected_rows = MySQL_Affected_Rows($this->DB);
$this->mysql_queries++;
RETURN NEW result($result);
}
$result = $DB_hub->Query("SELECT Count(identifier) AS `count` FROM conn_types".$query);
$count = $result->Fetch_Assoc();
$total = $count['count'];
$result->Free_Result();
$pages = (int)(($total - 1) / $VA_setup['conn_types_results']) + 1;
$first = $VA_setup['conn_types_results'] * ($_GET['page'] - 1);
$colums = $VA_setup['conn_types_identifier'] + $VA_setup['conn_types_description'];
$colums += $VA_setup['conn_types_tag_min_slots'] + $VA_setup['conn_types_tag_max_slots'];
$colums += $VA_setup['conn_types_tag_min_limit'] + $VA_setup['conn_types_tag_min_ls_ratio']+2;
$query = "SELECT * FROM conn_types".$query;
$query .= " ORDER BY ".$DB_hub->Real_Escape_String($_GET['orderby'])." LIMIT ".$first.",".$VA_setup['conn_types_results'];
IF($debug[2]) {
VA_Message($query, "bohyn32");
Print "<BR>";
}
IF($pages > 1)
{Navigation();}
?>
<TABLE class="fs9px b1">
<TR>
<FORM action="index.php?<?Print Change_URL_Query("q", "edittype");?>" method="post">
<TD class="bg_light" colspan=<?Print $colums;?>><INPUT type="submit" value="<?Print $text_add_new_type;?>"></TD>
</FORM>
</TR><TR>
<FORM aciton="index.php" method="get">
<TD class="bg_light right" colspan=<?Print $colums;?> nowrap>
{VA_Message($err_msg_enter_subject, "warning");}
StoreQueries();
//Return to messanger
Header("Location: index.php?".Change_URL_Query("q", "messanger"));
}
?>
<FONT class="h2"><?Print $text_send_message;?></FONT>
<BR><BR>
<?
IF($VA_setup['messanger_min_class'] > USR_CLASS)
{Die(VA_Message($err_msg_no_access, "error"));}
IF($_GET['receiver'])
{$_POST['receiver'] = $_GET['receiver'];}
?>
<FORM action="index.php?<?Print Change_URL_Query("receiver", "");?>" method="post">
<TABLE class="fs9px b1">
<TR>
<TD class="bg_light b"><?Print $text_sender;?> : </TD>
<TD class="bg_light b">
<?IF(USR_CLASS == 0)
{?><INPUT class="w300px" name="sender" type="text" value="<?Print $_POST['sender'];?>"><?}
ELSE
{Print $_COOKIE['nick'];}?>
</TD>
IF(ValidateIP($_GET['ip'])) $query .= " AND ip LIKE '".$_GET['ip']."'";
$query .= " AND (`date_limit` > UNIX_TIMESTAMP() OR `date_limit` IS NULL)";
$result = $DB_hub->Query($query);
}
ELSE
{
$result = $DB_hub->Query("SELECT nick, ip FROM banlist WHERE ip LIKE '".$_GET['ip']."' AND (`date_limit` > UNIX_TIMESTAMP() OR `date_limit` IS NULL)");
}
IF($result->num_rows) {
$ban = $result->Fetch_assoc();
Header("Location: index.php?".Change_URL_Query("q", "unban_request", "nick", urlencode($ban['nick']), "ip", $ban['ip']));
Die();
}
ELSE
VA_Message($text_banfree, "info32");
RETURN TRUE;
}
?>
<FORM action="index.php" method="get">
<INPUT name="q" type="hidden" value="bantest">
<TABLE class="b1 fs10px">
<TR>
<TD class="b bg_light right"> <?Print $text_nick;?> : </TD>
<TD class="b bg_light"><INPUT class="w160px" name="nick" type="text" value="<?IF(Defined("USER_NICK")){Print USER_NICK;} ELSE{Print $_GET['nick'];}?>"></TD>
</TR><TR>
<TD class="b bg_light right"> <?Print $text_ip;?> : </TD>
<TD class="b bg_light"><INPUT class="w160px" name="ip" type="text" value="<?IF($_GET['ip']){Print $_GET['ip'];} ELSE{Print $_SERVER['REMOTE_ADDR'];}?>"></TD>
VerliAdmin is distributed in the hope that it will be useful,
but WITHOUT ANY WARRANTY; without even the implied warranty of
MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
GNU General Public License for more details.
You should have received a copy of the GNU General Public License
along with VerliAdmin; if not, write to the Free Software
Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307 USA
*/
IF($_POST['submit']) {
//Add / edit trigger
IF($VA_setup['file_trigger_edit_class'] > USR_CLASS) {
Die(VA_Message($err_msg_no_access));
}
$_POST['command'] = $DB_hub->Real_Escape_String($_POST['command']);
$_POST['def'] = $DB_hub->Real_Escape_String($_POST['def']);
$_POST['send_as'] = $DB_hub->Real_Escape_String($_POST['send_as']);
$_POST['descr'] = $DB_hub->Real_Escape_String($_POST['descr']);
$flags = Array_Sum($_POST['flags']);
$query = "REPLACE INTO file_trigger \n";
$query .= "(command, send_as, def, descr, min_class, max_class, flags) \n";
$query .= "VALUES ('".$_POST['command']."', '".$_POST['send_as']."', '".$_POST['def']."', '".$_POST['descr']."', '".$_POST['min_class']."', '".$_POST['max_class']."', '".$flags."')";
$DB_hub->Query($query);
StoreQueries();
<? WHILE($row = $result->Fetch_Assoc()) {
Print "<A href=\"language.php?".Change_URL_Query("lang", $row['language'])."\">";
Print "<IMG src=\"img/".$row['language']."flag.gif\" width=22 height=15 alt=\"".StrToUpper($row['language'])."\">";
?> </A>
<IMG src="img/space.gif" width=4 height=15>
<? }
?> </TD>
</TR>
</TABLE>
<? BREAK;
//---------------------------------------------------------------------
CASE 2 :
Die(VA_Message("Not yet implemented", "error"));
IF(!Defined(SQLITE_ASSOC))
Die(VA_Message("SQLite support missing", "error"));
// $sqlite_db = SQLite_Open("language/".LANG);
$result = SQLite_Query($sqlite_db, "SELECT DISTINCT language FROM va_languages ORDER BY language");
?>
<TABLE align="right" class="rightpanel" width=0>
<TR>
<TD valign="middle" align="center" nowrap>
<IMG src="img/space.gif" width=4 height=15>
<? WHILE($row = SQLite_Fetch_Array($result, SQLITE_ASSOC)) {
Print "<A href=\"language.php?".Change_URL_Query("lang", $row['language'])."\">";
Print "<IMG src=\"img/".$row['language']."flag.gif\" width=22 height=15 alt=\"".StrToUpper($row['language'])."\">";
?> </A>
<IMG src="img/space.gif" width=4 height=15>
<? }
?> </TD>
SET status = 4, op = '".USR_NICK."', time_op = UNIX_TIMESTAMP(), answer = '".$_POST['answer']."'
WHERE nick LIKE '".$_POST['nick']."' AND ip = '".$_POST['ip']."'";
$DB_hub->Query($query);
Header("Location: index.php?".Change_URL_Query("q", "unban_admin"));
}
ELSEIF($_POST['refuse'] && $_POST['answer'] != "") {
//Refuse unban (status 5)
$query = "UPDATE va_unban \n";
$query .= "SET status = 5, op = '".USR_NICK."', time_op = UNIX_TIMESTAMP(), answer = '".$_POST['answer']."' \n";
$query .= "WHERE nick LIKE '".$_POST['nick']."' AND ip = '".$_POST['ip']."'";
$DB_hub->Query($query);
Header("Location: index.php?".Change_URL_Query("q", "unban_admin"));
}
ELSEIF(!$_POST['answer'] && ($_POST['register'] || $_POST['unban_nick'] || $_POST['unban_ip'] || $_POST['unban'] || $_POST['refuse'])) {
//No answer sent
VA_Message($err_msg_no_answer, "error");
}
?>
<FONT class="h2"><?Print $text_unbans;?></FONT>
<BR><BR>
<?
IF(!IsSet($_GET['page']))
{$_GET['page'] = 1;}
$result = $DB_hub->Query("SELECT Count(nick) AS `count` FROM va_unban WHERE status = 0");
$count = $result->Fetch_Assoc();
IF(IsSet($_GET['err']))
{
$error = "err_msg_".$_GET['err'];
Die(VA_Message($$error, "error"));}
//If user is not loged in include login form (expect about, stats,
//chpass, messages and unban_request page)
ELSEIF(!USR_CLASS && $_GET['q'] != "about" && $_GET['q'] != "stats" && $_GET['q'] != "chpass" && $_GET['q'] != "messages" && $_GET['q'] != "unban_request" && $_GET['q'] != "bantest")
{Include "login.php";}
//Otherwise include required page
ELSEIF($_GET['q'] != "" && $_GET['q'] != "none") {
if(substr_count($_GET['q'], "/")) die("Hacking attempt. You bastard.");
IF(!Include $_GET['q'].".php") {
//If include fails (page is not found or sytax error in script
//display error message)
VA_Message($err_msg_not_such_page, "error");
}
}
//I don`t remember why it is there ;o))
ELSEIF($_GET['q'] == "none")
{}
ELSE
{//No page is selected so print database info
?>
<BR><BR>
<?IF($newlogin) {
Include "userinfo.php";
}?>
<TABLE class="b1 fs9px">
