'; feedAddForm($UID); changePasswordForm(); addUserForm(); newestFeedList(); print ''; listSubscribedFeeds($UID); /* ------------------------------------------- */ function changePasswordForm(){ print '
'.NL; print '
'.NL; print 'Change your password'.NL; print ''.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''.NL; print '
'.NL; print '
'.NL; } function addUserForm(){ print '
'.NL; print '
'.NL; print 'Create new user'.NL; print ''.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''.NL; print '
'.NL; 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 ''.$feed['url'].''; print '
'; print '
'; } } function feedAddForm($uid){ print '
'.NL; print '
'; print 'Subscribe to new Feed'.NL; print ''.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''; print '
'.NL; print ''.NL; print '
'.NL; print ''.NL; print '
'.NL; 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 ''; print ''; if(!empty($feed['name'])){ print htmlspecialchars($feed['name']); }else{ $parts = parse_url($feed['url']); print htmlspecialchars($parts['host']); } print ''; print ''; print '
'; } print '
'; } //Setup VIM: ex: et ts=4 enc=utf-8 : ?>