if (self::$installed && \Lobby\Apps::exists($appID) && $key != "") {
$sql = self::$dbh->prepare("SELECT COUNT(`name`) FROM `" . self::$prefix . "data` WHERE `name` = ? AND `app`=?");
$sql->execute(array($key, $appID));
if ($sql->fetchColumn() != 0) {
$sql = self::$dbh->prepare("UPDATE `" . self::$prefix . "data` SET `content` = ?, `updated` = NOW() WHERE `name` = ? AND `app` = ?");
$sql->execute(array($value, $key, $appID));
return true;
} else {
$sql = self::$dbh->prepare("INSERT INTO `" . self::$prefix . "data` (`app`, `name`, `content`, `created`, `updated`) VALUES (?, ?, ?, NOW(), NOW())");
return $sql->execute(array($appID, $key, $value));
}
} else {
return false;
}
}
/**
* Remove App Data
*/
public static function removeData($appID = "", $keyName)
{
if (self::$installed) {
if ($keyName != "" && $appID != "") {
$sql = self::$dbh->prepare("DELETE FROM `" . self::$prefix . "data` WHERE `name`=? AND `app`=?");
$sql->execute(array($keyName, $appID));
return true;
}
}
}
}
\Lobby\DB::init();
