Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <?php session_start();
- include('DBlogin.php');
- include('remember.php'); ?>
- <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"
- "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
- <html>
- <head>
- <title>Rally Together Landing</title>
- <link rel="stylesheet" type="text/css" href="css/default/style.css" />
- <link rel="stylesheet" type="text/css" href="css/custom-theme/jquery-ui-1.8.21.custom.css" />
- <script src="js/jquery.js"></script>
- <script src="js/jquery-ui.js"></script>
- <?php
- if (!isset($_SESSION['uid'])) {
- $result = mysql_query("SELECT * FROM recent_updates WHERE public != 0");
- $updates = mysql_fetch_array($result);
- }
- elseif (isset($_SESSION['uid'])) {
- $result = mysql_query("SELECT * FROM users WHERE uid=" . $_SESSION['uid'] . "");
- $cur_user = mysql_fetch_array($result);
- $ufriends = explode(';', $cur_user['friends']);
- $ufsql = trim(implode(',',$ufriends),',');
- $uevents = explode(';', $cur_user['events']);
- $uesql = trim(implode(',',$uevents),',');
- $urequests = explode(';', $cur_user['requests']);
- $ursql = trim(implode(',',$urequests),',');
- if (!empty($ufriends)) {
- $megaresult = mysql_query("
- ( SELECT *, 1 as ORD FROM recent_updates WHERE update_type='10'
- LIMIT 1
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='10'
- LIMIT 1,9
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='2' AND
- ( target_id IN (" . $ufsql . ") )
- AND
- ( source_id IN (" . $ufsql . ") )
- OR
- (
- ( target_id IN (" . $cur_user['uid'] . ") )
- AND
- ( source_id IN (" . $ufsql . ") )
- )
- OR
- (
- ( target_id IN (" . $ufsql . ") )
- AND
- ( source_id IN (" . $cur_user['uid'] . ") )
- )
- LIMIT 0,10
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='4' AND
- (
- ( target_id IN (" . $ufsql . ") )
- AND
- ( source_id IN (" . $ufsql . ") )
- )
- OR
- (
- ( target_id IN (" . $cur_user['uid'] . ") )
- AND
- ( source_id IN (" . $ufsql . ") )
- )
- OR
- (
- ( target_id IN (" . $ufsql . ") )
- AND
- ( source_id IN (" . $cur_user['uid'] . ") )
- )
- LIMIT 0,10
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='3' AND
- target_id IN (" . $uesql . ")
- LIMIT 0,10
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='3' AND
- target_id IN (" . $ursql . ")
- LIMIT 0,10
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='5' AND
- target_id IN (" . $ursql . ")
- LIMIT 0,10
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE update_type='11' AND
- (
- target_id IN (" . $uesql . ")
- OR
- target_id IN (" . $ursql . ")
- )
- AND
- (
- source_id IN (" . $ufsql . ")
- )
- LIMIT 0,10
- )
- UNION
- ( SELECT *, 2 as ORD FROM recent_updates WHERE public != 0 LIMIT 0,10 )
- ORDER BY ORD ASC, time_un DESC");
- $feed = mysql_fetch_array($megaresult);
- }
- }
- ?>
- </head>
- <body id="index">
- <!-- includes menu bar -->
- <?php include('menu.php'); ?>
- <div id="index_wrapper">
- <div id="home_header">
- <br>
- <h1>Header</h1>
- <h4>Slogan.</h4>
- </div>
- <div id="home_content">
- <div id="home_left_col">
- </div>
- <div id="home_right_col">
- </div>
- </div>
- </div>
- <?php include('footer.php'); ?>
- </body>
- </html>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement