Sessionhash issue after upgrade to VB4

[Jinkasu]

Hello Guys,

I hope this is the right forum topic to post in, I tried to search forum for what I was looking for, but the code for this was wrote by someoen else and I dont exactly know what im looking for to be honest :confused:

I'm having some issues with the script below, and after googling for an hour or so, still havent been able to remedy it.

The code used that worked prior to the VB4 upgrade was :

if ($HTTP_COOKIE_VARS['vbsessionhash']) {
$hash = $HTTP_COOKIE_VARS['vbsessionhash'];
$a1 = mysql_db_query($phpdb,"select username from vbuser u inner join vbsession s on (u.userid = s.userid) where s.sessionhash = '$hash'");
if (mysql_num_rows($a1) == 1) {
$username = strtolower(mysql_result($a1,0,"username"));
$charNameField = mysql_result(mysql_db_query($phpdb,"select replace(varname,'_title','') as field_name from vbphrase where text = 'Character Name' and fieldname = 'cprofilefield'"),0,"field_name");

But since the upgrade, it doesnt work anymore, as its quite an important part of my website, I hope someone can help me.

Thanks in anticipation.

J