';
feedAddForm($UID);
changePasswordForm();
addUserForm();
newestFeedList();
print '';
listSubscribedFeeds($UID);
/* ------------------------------------------- */
function changePasswordForm(){
print '
'.NL;
}
function addUserForm(){
print ''.NL;
}
function listSubscribedFeeds($uid){
$sql = "SELECT A.id, A.url, A.name
FROM lalina_feeds A, lalina_userfeeds B
WHERE B.user_id = $uid
AND A.id = B.feed_id
ORDER BY A.name, A.url";
$feeds = runSQL($sql);
foreach($feeds as $feed){
print '';
print '
';
print '
';
if(!empty($feed['name'])){
print htmlspecialchars($feed['name']);
}else{
$parts = parse_url($feed['url']);
print htmlspecialchars($parts['host']);
}
print ' ';
print '
';
print '[unsubscribe] ';
print ' ';
print '
';
print '
';
}
}
function feedAddForm($uid){
print ''.NL;
}
function newUser($nu,$p1,$p2){
if(empty($p1)){
msg('Empty Passwords forbidden',-1);
return;
}
if($p1 != $p2){
msg('Passwords do not match',-1);
return;
}
if(!$nu){
msg('No user given',-1);
return;
}
addUser($nu,$p1);
msg('User added.');
}
function changePassword($uid,$p1,$p2){
if(empty($p1)){
msg('Empty Passwords forbidden',-1);
return;
}
if($p1 != $p2){
msg('Passwords do not match',-1);
return;
}
setPassword($uid,$p1);
msg('Password updated');
}
function feedDel($uid,$fid){
if(!is_numeric($fid)) $fid = 0;
if(!$fid) return false;
$sql = "DELETE FROM lalina_userfeeds
WHERE user_id = $uid
AND feed_id = $fid";
runSQL($sql);
$sql = "SELECT COUNT(*) as cnt
FROM lalina_userfeeds
WHERE feed_id = $fid";
$result = runSQL($sql);
if($result[0]['cnt'] > 0){
return;
}
$sql = "DELETE FROM lalina_items
WHERE feed_id = $fid";
runSQL($sql);
$sql = "DELETE FROM lalina_feeds
WHERE id = $fid";
runSQL($sql);
}
function feedAdd($uid){
$url = trim($_REQUEST['url']);
$name = trim($_REQUEST['name']);
if(empty($url)) return false;
$url = addslashes($url);
$name = addslashes($name);
$sql = "INSERT IGNORE INTO lalina_feeds
SET url = '$url',
name = '$name',
added = NOW()";
runSQL($sql);
$sql = "SELECT id FROM lalina_feeds WHERE url = '$url'";
$result = runSQL($sql);
$fid = $result[0]['id'];
if(!$fid) return false;
$sql = "INSERT IGNORE INTO lalina_userfeeds
SET user_id = $uid,
feed_id = $fid";
runSQL($sql);
}
function feedSub($uid,$fid){
if(!is_numeric($fid)) $fid = 0;
if(!$fid) return false;
$sql = "INSERT IGNORE INTO lalina_userfeeds
SET user_id = $uid,
feed_id = $fid";
runSQL($sql);
}
function newestFeedList(){
$sql = "SELECT name, url, id
FROM lalina_feeds
ORDER BY added DESC
LIMIT 10";
$feeds = runSQL($sql);
print '';
print 'Newest feed additions ';
foreach($feeds as $feed){
print '';
}
print ' ';
}
//Setup VIM: ex: et ts=4 enc=utf-8 :
?>