Esempi in PHP per Create_Index

Esempio n. 1

File: pi_forbid.php Progetto: BackupTheBerlios/verlihub

?>

<FONT class="h2"><?Print $text_pi_forbid;?></FONT>

<BR><BR>

<?
IF(!IsSet($_GET['page']))
	$_GET['page'] = 1;
IF(!IsSet($_GET['orderby']))
	$_GET['orderby'] = $VA_setup['pi_forbid_order_by'];

IF($_GET['filter'] != "" && $_GET['filter_colum'] != "")
	{
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "pi_forbid", $_GET['filter_colum']);

	$query = " WHERE `".$DB_hub->Real_Escape_String($_GET['filter_colum'])."` LIKE '";
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}
	$query .= $DB_hub->Real_Escape_String($_GET['filter']);
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins")
		{$query .= "%";}
	$query .= "'";
	}

$result = $DB_hub->Query("SELECT Count(word) AS `count` FROM pi_forbid".$query);
$count = $result->Fetch_Assoc();
$total = $count['count'];
$result->Free_Result();
$pages = (int)(($total - 1) / $VA_setup['pi_forbid_results']) + 1;

Esempio n. 2

File: conn_types.php Progetto: BackupTheBerlios/verlihub

?>

<FONT class="h2"><?Print $text_conn_types;?></FONT>

<BR><BR>

<?
IF(!IsSet($_GET['page']))
	$_GET['page'] = 1;
IF(!IsSet($_GET['orderby']))
	$_GET['orderby'] = $VA_setup['conn_types_order_by'];

IF($_GET['filter'] != "" && $_GET['filter_colum'] != "")
	{
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "conn_types", $_GET['filter_colum']);

	$query = " WHERE `".$DB_hub->Real_Escape_String($_GET['filter_colum'])."` LIKE '";
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}
	$query .= $DB_hub->Real_Escape_String($_GET['filter']);
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins")
		{$query .= "%";}
	$query .= "'";
	}

$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;

Esempio n. 3

File: setuplist.php Progetto: BackupTheBerlios/verlihub

IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['setuplist_order_by'];}
IF($_GET['page'] == ""){$_GET['page'] = 1;}

IF($_GET['filter_file'] == "VA_config")
	{$query = " WHERE (file LIKE 'verliadmin' OR file LIKE 'config')";}
ELSEIF($_GET['filter_file'] == "defaults")
	{$query = " WHERE file LIKE 'defaults'";}
ELSEIF($_GET['filter_file'] == "VerliAdmin")
	{$query = " WHERE file LIKE 'verliadmin'";}
ELSEIF($_GET['filter_file'] == "config")
	{$query = " WHERE file LIKE 'config'";}

IF($_GET['filter'] != "" && $_GET['filter_colum'] != "")
	{
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "SetupList", $_GET['filter_colum']);
	IF(!$_GET['filter_file'])
		{$query .= " WHERE";}
	IF($_GET['filter_file'])
		{$query .= " AND";}
	$query .= "`".$_GET['filter_colum']."` LIKE '";
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}
	$query .= $DB_hub->Real_Escape_String($_GET['filter']);
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins")
		{$query .= "%";}
	$query .= "'";
	}

$result = $DB_hub->Query("SELECT Count(var) AS `count` FROM SetupList".$query);
$count = $result->Fetch_Assoc();

Esempio n. 4

File: userlog.php Progetto: BackupTheBerlios/verlihub

IF($VA_setup['userlog_min_class'] > USR_CLASS)
	{Die(VA_Error($err_msg_no_access));}
?>

<FONT class="h2"><?Print $text_userlog;?></FONT>

<BR><BR>

<?
IF($_GET['page'] == ""){$_GET['page'] = 1;}
IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['userlog_order_by'];}

IF($_GET['filter'] != "" && $_GET['filter_colum'] && $_GET['filter_type']) {
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "pi_iplog", $_GET['filter_colum']);
	
	IF($_GET['filter_colum'] == "date")
		{$filter = DateToInt($_GET['filter']);}
	ELSE
		{$filter = $_GET['filter'];}
	
	IF($_GET['filter_type'] == "less")
		{$query = " WHERE `".$_GET['filter_colum']."` < '";}
	ELSEIF($_GET['filter_type'] == "greater")
		{$query = " WHERE `".$_GET['filter_colum']."` > '";}
	ELSE
		{$query = " WHERE `".$_GET['filter_colum']."` LIKE '";}

	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}

Esempio n. 5

File: reglist.php Progetto: BackupTheBerlios/verlihub

	$DB_hub->Query("UPDATE reglist SET enabled = 0 WHERE login_last < ".$time." AND ((class = 1 AND ".$disable_class[1]." <= ".USR_CLASS.") OR (class = 2 AND ".$disable_class[2]." <= ".USR_CLASS."))");
	VA_Message($text_affected_rows." : ".$DB_hub->affected_rows, "info32");
}
ELSEIF($_POST['del_ina'] && $_POST['age_ina']) {
	$time = Time() - $_POST['age_ina'] * 86400;
	$DB_hub->Query("DELETE FROM reglist WHERE login_last < ".$time." AND ((class = 1 AND ".$delete_class[1]." <= ".USR_CLASS.") OR (class = 2 AND ".$delete_class[2]." <= ".USR_CLASS."))");
	VA_Message($text_affected_rows." : ".$DB_hub->affected_rows, "info32");
}

IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['reglist_order_by'];}
IF($_GET['page'] == ""){$_GET['page'] = 1;}

IF($_GET['filter'] != "" && $_GET['filter_colum'] && $_GET['filter_type'])
	{
	IF($VA_setup['create_indexes'])
                Create_Index($DB_hub, "reglist", $_GET['filter_colum']);
	IF($_GET['filter_colum'] == "reg_date" || $_GET['filter_colum'] == "login_last" || $_GET['filter_colum'] == "logout_last" || $_GET['filter_colum'] == "error_last")
		{$filter = DateToInt($_GET['filter']);}
	ELSE
		{$filter = $_GET['filter'];}

	IF($_GET['filter_type'] == "less")
		{$query = " WHERE `".$_GET['filter_colum']."` < '";}
	ELSEIF($_GET['filter_type'] == "greater")
		{$query = " WHERE `".$_GET['filter_colum']."` > '";}
	ELSE
		{$query = " WHERE `".$_GET['filter_colum']."` LIKE '";}

	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}
	$query .= $DB_hub->Real_Escape_String($filter);

Esempio n. 6

File: messanger.php Progetto: BackupTheBerlios/verlihub

IF($_POST['delete'])
	{$DB_hub->Query("DELETE FROM pi_messages WHERE `sender` = '".$_POST['sender']."' AND `date_sent` = '".$_POST['date_sent']."' AND `receiver` LIKE '".USR_NICK."'");}
?>

<FONT class="h2"><?Print $text_messanger;?></FONT>

<BR><BR>

<?
$query = " WHERE `receiver` LIKE '".USR_NICK."'";

IF($_GET['filter'] != "" && $_GET['filter_colum'] != "")
	{
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "pi_messages", $_GET['filter_colum']);
	
	IF($_GET['filter_colum'] == "date_sent" || $_GET['filter_colum'] == "date_expires")
		{$filter = DateToInt($_GET['filter']);}
	ELSE
		{$filter = $_GET['filter'];}
	
	IF($_GET['filter_type'] == "less")
		{$query = " WHERE `".$_GET['filter_colum']."` < '";}
	ELSEIF($_GET['filter_type'] == "greater")
		{$query = " WHERE `".$_GET['filter_colum']."` > '";}
	ELSE
		{$query = " WHERE `".$_GET['filter_colum']."` LIKE '";}
	
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}

Esempio n. 7

File: file_trigger.php Progetto: BackupTheBerlios/verlihub

?>

<FONT class="h2"><?Print $text_file_trigger;?></FONT>

<BR><BR>

<?
IF(!IsSet($_GET['page']))
	$_GET['page'] = 1;
IF(!IsSet($_GET['orderby']))
	$_GET['orderby'] = $VA_setup['file_trigger_order_by'];

IF($_GET['filter'] != "" && $_GET['filter_colum'] != "")
	{
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "file_trigger", $_GET['filter_colum']);
	
	$query = " WHERE `".$DB_hub->Real_Escape_String($_GET['filter_colum'])."` LIKE '";
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}
	$query .= $DB_hub->Real_Escape_String($_GET['filter']);
	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "begins")
		{$query .= "%";}
	$query .= "'";
	}

$result = $DB_hub->Query("SELECT Count(command) AS `count` FROM file_trigger".$query);
$count = $result->Fetch_Assoc();
$total = $count['count'];
$result->Free_Result();
$pages = (int)(($total - 1) / $VA_setup['file_trigger_results']) + 1;

Esempio n. 8

File: stats.php Progetto: BackupTheBerlios/verlihub

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(USR_CLASS < $VA_setup['stats_min_class'])
	{Die(VA_Message($err_msg_no_access, "error"));}


IF($VA_setup['create_indexes']) {
	Create_Index($DB_hub, "kicklist", "op");
	Create_Index($DB_hub, "banlist", "nick_op");
	Create_Index($DB_hub, "unbanlist", "unban_op");
	Create_Index($DB_hub, "kicklist", "ip");
	Create_Index($DB_hub, "banlist", "nick");
	}
?>
<FONT class="h2"><?Print $text_stats;?></FONT>

<BR><BR>

<?
GetTables($DB_hub);

IF($VA_setup['stats_plugin'] && IsSet($tables['pi_stats'])) {
	IF(!IsSet($_GET['month']))
		{
		$_GET['month'] = Date(n);
		$_GET['year'] = Date(Y);
		}

Esempio n. 9

File: unbanlist.php Progetto: BackupTheBerlios/verlihub

IF($VA_setup['unbanlist_min_class'] > USR_CLASS)
	{Die(VA_Message($err_msg_no_access, "error"));}?>

<FONT class="h2"><?Print $text_unbanlist;?></FONT>

<BR><BR>

<?
IF($_GET['page'] == ""){$_GET['page'] = 1;}
IF($_GET['orderby'] == ""){$_GET['orderby'] = $VA_setup['unbanlist_order_by'];}

IF($_GET['filter'] != "" && $_GET['filter_colum'] != "")
	{
	IF($VA_setup['create_indexes'])
		Create_Index($DB_hub, "unbanlist", $_GET['filter_colum']);

	IF($_GET['filter_colum'] == "date_start" || $_GET['filter_colum'] == "date_limit" || $_GET['filter_colum'] == "date_unban")
		{$filter = DateToInt($_GET['filter']);}
	ELSE
		{$filter = $_GET['filter'];}
	
	IF($_GET['filter_type'] == "less")
		{$query = " WHERE `".$_GET['filter_colum']."` < '";}
	ELSEIF($_GET['filter_type'] == "greater")
		{$query = " WHERE `".$_GET['filter_colum']."` > '";}
	ELSE
		{$query = " WHERE `".$_GET['filter_colum']."` LIKE '";}

	IF($_GET['filter_type'] == "contains" || $_GET['filter_type'] == "ends")
		{$query .= "%";}