rendered paste bodyfunction 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;}