/**
* @brief Loads a wiki page
*
* Will attempt to load a wiki page from the database. If revision is not
* specified, the latest revision will be loaded.
*
* @param String $page
* @param Int $revision
* @return Boolean True on success, false otherwise
*/
function loadWikiPage($page, $revision = null)
{
$db = new DatabaseConnection();
list($ns, $name) = $this->splitUri($page, 'wiki');
if (!$revision) {
$pd = $db->getSingleRow("SELECT * FROM wikipages WHERE pagens=%s AND pagename=%s " . "ORDER BY revision DESC LIMIT 1;", $ns, $name);
} else {
$pd = $db->getSingleRow("SELECT * FROM wikipages WHERE pagens=%s AND pagename=%s AND " . "revision<%d ORDER BY revision DESC LIMIT 1;", $ns, $name, $revision);
}
if ($pd) {
$revs = $db->getSingleRow("SELECT revision FROM wikipages WHERE pagens=%s AND pagename=%s", $ns, $name);
foreach ($revs as $rev) {
$this->revisions[] = $rev['revision'];
}
if ($pd['format'] != NULL) {
$this->markup = $pd['markuptype'];
$this->parser = markup::factory($this->markup);
}
$this->content = $pd['content'];
$this->pagerevision = $pd['revision'];
$this->modified = false;
$this->pagens = $pd['pagens'];
$this->pagename = $pd['pagename'];
$this->pagetitle = $pd['pagetitle'];
return true;
} else {
return false;
}
}
function staticText($slug)
{
$db = new DatabaseConnection();
$text = $db->getSingleRow("SELECT * FROM statictext WHERE slug=%s", $slug);
if ($text) {
return $text['content'];
}
}
/**
* Create a new collection using an uri or a pattern
*
* f.ex. tag:foo, category:bar, title:*, *, user:bob
*
*/
public function __construct($selection, Paginator $paginator = null)
{
// Create a collection from a tag, category, title, user etc.
$db = new DatabaseConnection();
$sql = $db->quote('SELECT * FROM galleryitems');
$count = $db->quote('SELECT COUNT(*) AS numitems FROM galleryitems');
// If we have a paginator, make use of it
if ($paginator) {
$sql .= ' ' . $paginator->getSqlLimit();
}
// Then select the rows and the total count
$rs = $db->getRows($sql);
$rsc = $db->getSingleRow($count);
}
/**
* @brief Unlink an identity based on its id.
*
* @param int $iid The identity ID
* @param int $userid The user ID that owns the identity
* @return boolean True on success
*/
static function unlinkIdentity($iid, $userid = null)
{
$db = new DatabaseConnection();
// Default to the active user
if (!$userid) {
$userid = user::getActiveUser()->userid;
}
// And make sure we have an identity to unlink
if ($iid != 0) {
$identities = $db->getRows("SELECT * FROM userengage WHERE userid=%d", user::getActiveUser()->userid);
$identity = $db->getSingleRow("SELECT * FROM userengage WHERE userid=%d AND id=%d", user::getActiveUser()->userid, $iid);
if (count($identities) > 1) {
if ($identity) {
$db->updateRow("DELETE FROM userengage WHERE userid=%d AND id=%d", user::getActiveUser()->userid, $iid);
return true;
}
} else {
view::set('identity', $identity);
return false;
}
} else {
return false;
}
}
/**
* @brief Checks to see if a username is available.
* Keep in mind that if the username is available, true is returned.
* This is contrary to the find() methods.
*
* @see User::find
* @param string $username The username to check
* @return bool True if the username is valid, false otherwise
*/
static function checkUsername($username)
{
$db = new DatabaseConnection();
$record = $db->getSingleRow("SELECT * FROM users WHERE username=%s", $username);
return $record == null;
}
public function export()
{
console::writeLn(__astr('\\b{Exporting tables and data}'));
$db = new DatabaseConnection();
$args = func_get_args();
if (count($args) == 0) {
$args[] = '%';
}
$drop = false;
$data = false;
foreach ($args as $arg) {
try {
if (strtolower($arg) == 'drop') {
$drop = true;
} elseif (strtolower($arg) == 'data') {
$data = true;
} else {
$tbl = $db->getRows("SHOW TABLES LIKE %s", $arg);
foreach ($tbl as $tblc) {
$c = $tblc[0];
console::write(" [app] %-30s ", $c);
// Get the create table syntax
$crs = $db->getSingleRow("SHOW CREATE TABLE " . $c);
$sqlcreate = $crs;
// Get the data
$fsql = fopen(expandpath('app:/sql/' . $c . '.sql'), 'w');
if ($drop) {
fputs($fsql, "DROP TABLE IF EXISTS " . $c . ";\n");
}
fputs($fsql, $crs[1] . "\n");
fclose($fsql);
console::write("SQL ");
if ($data) {
// Export the data as well
$drs = $db->getRows("SELECT * FROM " . $c);
foreach ($drs[0] as $k => $v) {
if ($k != '0' && intval($k) == 0) {
$hdr[] = $k;
}
}
$fdat = fopen(expandpath('app:/sql/' . $c . '.csv'), 'w');
fputcsv($fdat, $hdr, ";", '"');
foreach ($drs as $row) {
$dout = array();
foreach ($row as $i => $h) {
if ($i != '0' && intval($i) == 0) {
$dout[] = $h;
}
}
fputcsv($fdat, $dout, ";");
}
fclose($fdat);
console::write("CSV ");
}
console::writeLn();
}
}
} catch (DatabaseException $e) {
console::writeLn();
console::warn($e->getMessage());
}
}
}
/**
* @brief Load a user record from the database.
*
* @param int $userid The user ID
*/
function loadUser($userid)
{
if (is_numeric($userid)) {
$db = new DatabaseConnection();
$record = $db->getSingleRow("SELECT a.*,u.*,a.id AS userid FROM " . LEPTON_DB_PREFIX . "users a LEFT JOIN " . LEPTON_DB_PREFIX . "userdata u ON a.id=u.id WHERE a.id=%d", $userid);
if ($record) {
$this->assign($record);
} else {
throw new UserException("No such user ({$userid})");
}
} else {
throw new BadArgumentException("User ID must be an integer");
}
}
/**
* @brief Query and return a user record.
* This can be used by the authentication providers in a number of ways
* such as resolving user IDs or using information to look in other
* tables.
*
* @param string $username The username to fetch the record from
* @return array The user record, or null on failure.
*/
public function queryUser($username)
{
$db = new DatabaseConnection();
try {
$userrecord = $db->getSingleRow("SELECT * FROM users WHERE username=%s", $username);
if ($userrecord) {
return $userrecord;
}
return null;
} catch (Exception $e) {
throw $e;
}
}
/**
*
* @param type $key
* @param type $value
*/
public function __set($key, $value)
{
switch ($key) {
case 'amount':
$this->amount = floatval($value);
case 'symbol':
$db = new DatabaseConnection();
$sym = $db->getSingleRow("SELECT * FROM currencyexchange WHERE symbol=%s", $value);
if ($sym) {
$this->symbol = strtoupper($value);
} else {
throw new CurrencyException("No such symbol: " . $value);
}
default:
throw new BadPropertyException($this, $key);
}
}
/**
* Update a wiki page
* @param string $pagename The namespace and page name
* @param string $title The page title
* @param string $content The page content
*/
function updatePage($pagename, $title, $content)
{
$ns = String::getNamespace('default', $pagename);
$uri = String::getLocation($pagename);
$db = new DatabaseConnection();
$author = User::getActiveUserId();
try {
// pull the latest revision of the page
$rs = $db->getSingleRow('SELECT MAX(revision) AS latest FROM wiki WHERE ns=\'%s\' AND uri=\'%s\'', $ns, $uri);
$currev = $rs ? $rs['latest'] : 0;
// set to 0 if no record returned
// bump revision
$currev++;
// and insert the new data
$db->updateRow("INSERT INTO wiki SET content='%s',revision='%d',title='%s',ns='%s',uri='%s',lastedit=NOW(),author='%d'", $content, $currev, $title, $ns, $uri, $author);
} catch (DBXException $e) {
die($e);
}
}
function getKeyForUser($username)
{
$user = User::find($username);
if ($user) {
$userid = $user->userid;
$db = new DatabaseConnection();
$rs = $db->getSingleRow("SELECT * FROM userppp WHERE id=%d", $userid);
if ($rs) {
$codekey = $rs['secretkey'];
} else {
$codekey = null;
}
return $codekey;
} else {
throw new UserException('User not found.');
}
}
private static function updateSets(callback $callback = null)
{
// Update the callback if one is present
if ($callback) {
$callback->call('Updating sets...');
}
// Pull the country list
$db = new DatabaseConnection();
$rs = $db->getRows("SELECT isocode,capital FROM geonames_countryinfo");
foreach ($rs as $cc) {
$f = $db->getSingleRow("SELECT * FROM geonames_datasets WHERE setkey=%s", $cc['isocode']);
if (!$f) {
$db->insertRow("INSERT INTO geonames_datasets (setkey,setname,url,active) VALUES (%s,%s,%s,0)", $cc['isocode'], $cc['capital'], self::getUrl($cc['isocode'] . '.zip'));
}
}
if ($callback) {
$callback->call('All sets updated');
}
}
