function alterDatabaseColumns($table, $operation, $columns, $file = "", $line = "")
{
foreach ($columns as $column) {
executeQueryForUpdate("ALTER TABLE @{$table} {$operation} {$column}", $file, $line);
}
}
function tranformEnumValuesForClass($field, $className, $file, $line)
{
$values = split(", *", $field->values);
$cidCond = $className == "user" ? "" : "cid={$field->cid} AND ";
G::load($objs, "SELECT id, {$field->columnIndex} FROM @{$className} WHERE {$cidCond} {$field->columnIndex}!=''");
foreach ($objs as $obj) {
$numValues = split(", *", $obj->{$field->columnIndex});
$obj->{$field->columnIndex} = array();
for ($i = 0; $i < count($numValues); $i++) {
if (isset($values[$numValues[$i]])) {
$obj->{$field->columnIndex}[] = $values[$numValues[$i]];
} elseif (in_array($numValues[$i], $values)) {
$obj->{$field->columnIndex}[] = $numValues[$i];
}
}
$newValue = quoteSQL(join(",", array_map(create_function('$v', 'return str_replace(",", ",,", $v);'), $obj->{$field->columnIndex})));
$query = "UPDATE @{$className} SET {$field->columnIndex}='{$newValue}' WHERE id={$obj->id}";
if ($file) {
executeQueryForUpdate($query, $file, $line);
} else {
executeQuery($query);
}
}
}
function updateGlobalstatAndFooter($version)
{
$versionFooterText = addcslashes("Powered by <a href='http://noahsclassifieds.org'>Noah's Classifieds</a> {$version} - \n <a href='http://noahsclassifieds.org' >try Noah's Classifieds V8 e-commerce enabled</a>", "'\\");
executeQueryForUpdate("UPDATE @settings SET versionFooter='{$versionFooterText}' WHERE (locate('livetransactions', versionFooter) AND locate('noahsv8', versionFooter)) OR locate('noahsclassifieds.org', versionFooter)", __FILE__, __LINE__);
executeQueryForUpdate("UPDATE @globalstat SET instver='{$version}'", __FILE__, __LINE__);
}
