mysql_query("INSERT INTO posts SET to_id='$id',from_id='$session',post='$post',type='$action_type',date='$date'");
$post_id = mysql_insert_id();
$query = mysql_query("SELECT id,to_id,from_id,post,type,state,date FROM posts WHERE id='$post_id' AND state='0' ORDER BY id DESC LIMIT 15");
print posts($query, "newPost");
if($id!=$session)
{
mysql_query("INSERT INTO notifications SET user_id='$id', from_id='$session', post_id='$post_id', action_type='$action_type', date='$date'");
}
}
?>
now the includes file is below , it includes the functions , and the connections...
includes.php
$num_likes = mysql_num_rows(mysql_query("SELECT id FROM db_like WHERE post_id='$id'"));
if($num_likes == 0)
{
$num_likes = '';
}
else if($num_likes == 1)
{
$num_likes = $num_likes." person likes this";
}
else
{
$num_likes = $num_likes." people like this";
}
$query_like = mysql_fetch_assoc(mysql_query("SELECT id FROM db_like WHERE post_id='$id' AND from_id='$session'"));
if($query_like)
{$like_unlike = "unlike";}
else
{$like_unlike = "like";}
and finaly here is the script for the $logoptions , i think this is where everything is not working... i have $session=$logOptions_id in the add/post.php but here is the script.
checkuserlog.php (whole script)
PHP Code:
<?php
session_start(); // Start Session First Thing
// Force script errors and warnings to show on page in case php.ini file is set to not display them
error_reporting();
ini_set('display_errors', '1');
//-----------------------------------------------------------------------------------------------------------------------------------
include_once "connect_to_mysql.php"; // Connect to the database
$dyn_www = $_SERVER['HTTP_HOST']; // Dynamic www.domainName available now to you in all of your scripts that include this file
//------ CHECK IF THE USER IS LOGGED IN OR NOT AND GIVE APPROPRIATE OUTPUT -------
$logOptions = ''; // Initialize the logOptions variable that gets printed to the page
// If the session variable and cookie variable are not set this code runs
if (!isset($_SESSION['idx'])) {
if (!isset($_COOKIE['idCookie'])) {
$logOptions = '<a href="http://' . $dyn_www . '/webinter/register.php">Register Account</a>
|
<a href="http://' . $dyn_www . '/webinter/login.php">Log In</a>';
}
}
// If session ID is set for logged in user without cookies remember me feature set
if (isset($_SESSION['idx'])) {
$decryptedID = base64_decode($_SESSION['idx']);
$id_array = explode("p3h9xfn8sq03hs2234", $decryptedID);
$logOptions_id = $id_array[1];
$logOptions_username = $_SESSION['username'];
$logOptions_username = substr('' . $logOptions_username . '', 0, 15); // cut user name down in length if too long
// Check if this user has any new PMs and construct which envelope to show
$sql_pm_check = mysql_query("SELECT id FROM private_messages WHERE to_id='$logOptions_id' AND opened='0' LIMIT 1");
$num_new_pm = mysql_num_rows($sql_pm_check);
if ($num_new_pm > 0) {
$PM_envelope = '<a href="pm_inbox.php"><img src="./images/pm2.gif" width="18" height="11" alt="PM" /></a>';
} else {
$PM_envelope = '<a href="pm_inbox.php"><img src="./images/pm1.gif" width="18" height="11" alt="PM" /></a>';
}
// Ready the output for this logged in user
$logOptions = $PM_envelope . '
<a href="http://' . $dyn_www . '/webinter/profile.php?id=' . $logOptions_id . '">Profile</a>
|
<div class="dc">
<a href="#" onclick="return false">Account <img src="./images/darr.gif" width="10" height="5" alt="Account Options" border="0"/></a>
<ul>
<li><a href="http://' . $dyn_www . '/webinter/edit_profile.php">Account Options</a></li>
<li><a href="http://' . $dyn_www . '/webinter/pm_inbox.php">Inbox Messages</a></li>
<li><a href="http://' . $dyn_www . '/webinter/pm_sentbox.php">Sent Messages</a></li>
</ul>
</div>
} else if (isset($_COOKIE['idCookie'])) {// If id cookie is set, but no session ID is set yet, we set it below and update stuff
$decryptedID = base64_decode($_COOKIE['idCookie']);
$id_array = explode("nm2c0c4y3dn3727553", $decryptedID);
$userID = $id_array[0];
$userPass = $_COOKIE['passCookie'];
// Get their user first name to set into session var
$sql_uname = mysql_query("SELECT username FROM myMembers WHERE id='$userID' AND password='$userPass' LIMIT 1");
$numRows = mysql_num_rows($sql_uname);
if ($numRows == 0) {
echo '<script language="Javascript">';
echo 'window.location="index.php"';
echo '</script>';
exit();
}
while($row = mysql_fetch_array($sql_uname)){
$username = $row["username"];
}
$_SESSION['id'] = $userID; // now add the value we need to the session variable
$_SESSION['idx'] = base64_encode("g4p3h9xfn8sq03hs2234$userID");
$_SESSION['username'] = $username;
$logOptions_id = $userID;
$logOptions_uname = $username;
$logOptions_uname = substr('' . $logOptions_uname . '', 0, 15);
/////////// Update Last Login Date Field /////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////////
mysql_query("UPDATE myMembers SET last_log_date=now() WHERE id='$logOptions_id'");
// Ready the output for this logged in user
// Check if this user has any new PMs and construct which envelope to show
$sql_pm_check = mysql_query("SELECT id FROM private_messages WHERE to_id='$logOptions_id' AND opened='0' LIMIT 1");
$num_new_pm = mysql_num_rows($sql_pm_check);
if ($num_new_pm > 0) {
$PM_envelope = '<a href="pm_inbox.php"><img src="./images/pm2.gif" width="18" height="11" alt="PM" /></a>';
} else {
$PM_envelope = '<a href="pm_inbox.php"><img src="./images/pm1.gif" width="18" height="11" alt="PM" /></a>';
}
// Ready the output for this logged in user
$logOptions = $PM_envelope . '
<a href="http://' . $dyn_www . '/profile.php?id=' . $logOptions_id . '">Profile</a>
|
<div class="dc">
<a href="#" onclick="return false">Account <img src="./images/darr.gif" width="10" height="5" alt="Account Options" border="0"/></a>
<ul>
<li><a href="http://' . $dyn_www . '/webinter/edit_profile.php">Account Options</a></li>
<li><a href="http://' . $dyn_www . '/webinter/pm_inbox.php">Inbox Messages</a></li>
<li><a href="http://' . $dyn_www . '/webinter/pm_sentbox.php">Sent Messages</a></li>
</ul>
</div>