All pastes #11123 Raw Edit

Unnamed

public php v1 · immutable
#11123 ·published 2005-05-06 16:44 UTC
rendered paste body
function sql_check_query($x){	global $sql_tables_prefix;	if($sql_tables_prefix){		$rules = array("^SELECT.+FROM +`",								"^SELECT.+FROM",								"^INSERT.+INTO +`",								"^INSERT.+INTO",								"^DELETE.+FROM +`",								"^DELETE.+FROM",								"^UPDATE +`[^`]+` +SET",								"^UPDATE.+SET",								"^DROP +TABLE +IF +EXISTS +`[^`]+`",								"^DROP +TABLE +IF +EXISTS",								"^DROP +TABLE +`[^`]+`",								"^DROP +TABLE",								"^CREATE +TABLE +`[^`]+`",								"^CREATE +TABLE"								);		$matches = array("^SELECT(.+)FROM +`([^`]+)`",										"^SELECT(.+)FROM +([^ ]+)",										"^INSERT(.+)INTO +`([^`]+)`",										"^INSERT(.+)INTO +([^ ]+)",										"^DELETE(.+)FROM +`([^`]+)`",										"^DELETE(.+)FROM +([^ ]+)",										"^UPDATE +`([^`]+)` +SET",										"^UPDATE +([^ ]+) +SET",										"^DROP +TABLE +IF +EXISTS +`([^`]+)`",										"^DROP +TABLE +IF +EXISTS +([^ ]+)",										"^DROP +TABLE `+([^`]+)`",										"^DROP +TABLE +([^ ]+)",										"^CREATE +TABLE +`([^`]+)`",										"^CREATE +TABLE +([^ (]+)"										);		$replacements = array("SELECT\\1FROM `{$sql_tables_prefix}_\\2`",												"SELECT\\1FROM {$sql_tables_prefix}_\\2",												"INSERT\\1INTO `{$sql_tables_prefix}_\\2`",												"INSERT\\1INTO {$sql_tables_prefix}_\\2",												"DELETE\\1FROM `{$sql_tables_prefix}_\\2`",												"DELETE\\1FROM {$sql_tables_prefix}_\\2",												"UPDATE `{$sql_tables_prefix}_\\1` SET",												"UPDATE {$sql_tables_prefix}_\\1 SET",												"DROP TABLE IF EXISTS `{$sql_tables_prefix}_\\1`",												"DROP TABLE IF EXISTS {$sql_tables_prefix}_\\1",												"DROP TABLE `{$sql_tables_prefix}_\\1`",												"DROP TABLE {$sql_tables_prefix}_\\1",												"CREATE TABLE `{$sql_tables_prefix}_\\1`",												"CREATE TABLE {$sql_tables_prefix}_\\1"												);		$x = trim($x); for($i=0;$i<count($rules);$i++) if( eregi($rules[$i],$x)) { $x = eregi_replace($matches[$i], $replacements[$i], $x); break; }	}	return $x;}