function searchfor($db, $word, $dbname_select = array(), $table_select = array(), $column_select = array(), $view_columns = array(), $exclude = array())
{
$dbnames = array();
if (count($dbname_select) == 0) {
$dbnametmp = getdatabases($db);
//get all databases
foreach ($dbnametmp as $dbname) {
$dbnames[] = $dbname['Database'];
}
} else {
$dbnames = $dbname_select;
}
$data = array();
foreach ($dbnames as $dbname) {
$ecode = mysql_select_db($dbname, $db);
if (!$ecode) {
echo "Error: e002: Database not exist!\n";
die;
}
$tables = array();
if (count($table_select) == 0) {
$tabletmp = gettables($db, $dbname);
// get all tables in database
foreach ($tabletmp as $tablex) {
$tablename = $tablex['Tables_in_' . $dbname];
if (!in_array($tablename, $exclude)) {
$tables[] = $tablename;
}
}
} else {
$tables = $table_select;
}
$data = array();
foreach ($tables as $table) {
$columns = array();
if (count($column_select) == 0) {
$columnstmp = getcolumns($db, $dbname, $table);
foreach ($columnstmp as $columnx) {
$columns[] = $columnx['Field'];
}
} else {
$columns = $column_select;
}
$like = '';
for ($i = 0; $i < count($columns); $i++) {
$like .= " `" . $columns[$i] . "` like '%" . mysql_real_escape_string($word) . "%'";
if ($i != count($columns) - 1) {
$like .= " OR";
}
}
$order = '';
if (count($view_columns) > 0) {
$order = "ORDER BY";
for ($i = 0; $i < count($view_columns); $i++) {
$order .= " `" . $view_columns[$i] . "` ASC";
if ($i != count($view_columns) - 1) {
$order .= ",";
}
}
}
$query = "SELECT * FROM " . $table . " WHERE " . $like . " " . $order;
//print_r($query);
$sql = mysql_query($query);
if (!$sql) {
echo "Error: e003: Column not exist!\n";
die;
}
while ($sql && ($row = mysql_fetch_assoc($sql))) {
if (count($view_columns) > 0) {
foreach ($row as $key => $val) {
if (!in_array($key, $view_columns)) {
unset($row[$key]);
}
}
}
$data[$dbname][$table][] = $row;
}
}
}
return $data;
}
## SAVE ADMIN
if ($checkstep == 3) {
if ($form[admin_pwd] != $form[admin_pwd2]) {
eval("\$fail = \"" . gettemplate("install.swora.fail.pwdsnotsame") . "\";");
$step = 3;
} else {
$dbdata = getdata("dbdata");
$configtab = getdata("configtab");
$admin = $form;
$successfullinstalledvalues = 0;
$failed = 0;
$failures = "";
savedata($admin, "admin");
if (@mysql_connect($dbdata[host], $dbdata[username], $dbdata[userpwd])) {
if (mysql_select_db($dbdata[db])) {
$tabs = gettables();
$date = time();
$form[admin_pwd] = md5($form[admin_pwd]);
foreach ($insertlater as $tab => $a) {
foreach ($a as $line) {
eval("\$line = \"{$line}\";");
if (mysql_query($line)) {
$successfullinstalledvalues++;
} else {
$failed++;
eval("\$failures[{$failed}] = \"" . mysql_error() . "\";");
}
}
}
eval("\$output .= \"" . gettemplate("install.swora.finished.step3") . "\";");
if ($failed) {
