Totally blank page ?

[mistypotato]

Is there an obvious reason why this is resulting in a blank page ?

 

print "userid is $userid";

[awpti]

Look at your error_log file.

[Fadion]

Is there any code above that or it's just that line?

[mistypotato]

it says unexpected ';'

 

This is direcltly above it....

 

$userdata->save();

//BEGIN Insert Data into history

 

print "userid is $userid";

 

 

 

 

 

 

   

 

 

 

[Fadion]

Mate, post the whole code!!

 

EDIT: You edited your post.

 

Post more code, is it a problem for you?

[mistypotato]

Sorry....just dont know HOW much to post.

 

But, in the meantime, I looked at the SQL server logs and it looks like everything is working EXCEPT, it's substituting THIS for the value of the variable....

 

'Resource id #22'

 

 

[Fadion]

I'm sure you don't have a 10.000 lines of code script, so post some lines above the problematic line so we can understand the problem.

[mistypotato]

<?php
// ###################### Start process logout #######################
function process_logout()
{
global $vbulletin;

// clear all cookies beginning with COOKIE_PREFIX
$prefix_length = strlen(COOKIE_PREFIX);
foreach ($_COOKIE AS $key => $val)
{
	$index = strpos($key, COOKIE_PREFIX);
	if ($index == 0 AND $index !== false)
	{
		$key = substr($key, $prefix_length);
		if (trim($key) == '')
		{
			continue;
		}
		vbsetcookie($key, '', 1);
	}
}

if ($vbulletin->userinfo['userid'] AND $vbulletin->userinfo['userid'] != -1)
{
	// init user data manager
	$userdata =& datamanager_init('User', $vbulletin, ERRTYPE_SILENT);
	$userdata->set_existing($vbulletin->userinfo);
	$userdata->set('lastactivity', TIMENOW - $vbulletin->options['cookietimeout']);
	$userdata->set('lastvisit', TIMENOW);
	$userdata->save();


//BEGIN Insert Data into history
//print "userid is $userid";
//$rlemail = $vbulletin->db->query_first("SELECT email FROM " . TABLE_PREFIX . "user WHERE userid = " . $vbulletin->userinfo['userid'] . ) or die(" rlemail error: $userid" . mysql_error());
    


mysql_connect("localhost","user","1234567") or die ("Unable to connect to MySQL server.");
$rlemail = mysql_query("SELECT email FROM Myforum.user WHERE userid = " . $vbulletin->userinfo['userid'] . "") or die(" rlemail error: ".$vbulletin->userinfo['userid']. mysql_error());
    $db = mysql_select_db("Mycustomers") or die ("Unable to select requested database.");
 $totalrows = mysql_num_rows($rlemail);
       //print "$totalrows";
	//print "rlemail is $rlemail";
	//$rlemail = "admin@MyCustomers.com";		
	$Update2 = mysql_query("UPDATE Mycustomers.customers SET lastforumvisit = Now() WHERE Email = '$rlemail'") or die(" Update2 Insert error:" . mysql_error());

// END Insert Data into history


	// make sure any other of this user's sessions are deleted (in case they ended up with more than one)
	$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "session WHERE userid = " . $vbulletin->userinfo['userid']);
}

$vbulletin->db->query_write("DELETE FROM " . TABLE_PREFIX . "session WHERE sessionhash = '" . $vbulletin->db->escape_string($vbulletin->session->vars['dbsessionhash']) . "'");

if ($vbulletin->session->created == true)
{
	// if we just created a session on this page, there's no reason not to use it
	$newsession =& $vbulletin->session;
}
else
{
?>

[revraz]

One problem you have is you are doing your first QUERY before you even select your DB.

Your second problem is you are using $rlemail in your UPDATE query when $rlemail is a Resource ID, not a email data field.

[DeanWhitehouse]

have you turned error reports on??

 

error_reporting(E_ALL);