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__); }