function generate() { global $argv, $title; $db = new DB(); $sphinx = new Sphinx(); $sphinxDir = count($argv) > 2 ? rtrim($argv[2], '/') : ""; $sphinxConf = count($argv) > 3 ? rtrim($argv[3], '/') : ""; $sphinxConf = $sphinx->generateSphinxConf($sphinxDir, $sphinxConf); printf("Wrote configuration to: %s\n", $sphinxConf); $sql = sprintf("UPDATE site " . "SET value = %s " . "WHERE setting = 'sphinxconfpath'", $db->escapeString($sphinxConf)); $db->exec($sql); return true; }