[uae]

Originally Posted by laborer75

Odd.......wont work for me and now I get this error when trying to goto my forums.....

Database error in vBulletin 3.0.3:

Invalid SQL: SELECTp.pagerid, p.parentpid, p.fromuserid, p.touserid, u.username,p.message, p.msgdate, p.canreply, p.hidden FROM pager as p left join user as u on(u.userid=p.fromuserid) WHERE p.delsent=0 and p.active=1 andp.touserid=1 order by msgdate
mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'SELECTp.pagerid, p.parentpid, p.fromuserid, p.touserid, u.usern

Hey, there should be one space in that query, after SELECT!

DO the changes again for functions.php

Here it is again,

FIND AT THE END:

?>

ABOVE ADD:

ABOVE that ADD:

 
// [START HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 7 ]
 function can_pager($type=0, $usrid=0)
  {
  global $vboptions, $bbuserinfo;
  if ($usrid==0)
   $usrid = $bbuserinfo[userid];
  if ($usrid==0)
   return false;
  if ($vboptions[vbpager_on_off]=="0")
	return false;
 $gid_m  = $vboptions[vbpager_usergroup_member]; 
 $gid_g  = $vboptions[vbpager_usergroup_guest];
 $uid_m  = $vboptions[vbpager_userid_member];
 $uid_g  = $vboptions[vbpager_userid_guest];

 if (!($gid_m))
  $gid_m = "-1"; 
 if (!($gid_g))
  $gid_g = "-1";
 if (!($uid_m))
  $uid_m = "-1";
 if (!($uid_g))
  $uid_g = "-1";

 $uids = explode(',', str_replace(' ', '', $uid_g));
 foreach($uids AS $ids)
  if ($usrid==$ids)
   {
	 $vboptions[vbpager_canpager] = 1;
	  return true; 
   }
if ($type==0)
 {
 $uids = explode(',', str_replace(' ', '', $uid_m));
 foreach($uids AS $ids)
  if ($usrid==$ids)
   {
	 $vboptions[vbpager_canpager] = 1;
	  return true; 
   }
 }
 $uids = explode(',', str_replace(' ', '', $gid_g));
 foreach($uids AS $ids)
  if ($bbuserinfo[usergroupid]==$ids)
   {
	 $vboptions[vbpager_canpager] = 1;
	  return true; 
   }
	$mids = explode(',', str_replace(' ', '', $bbuserinfo[membergroupids]));
  foreach($uids AS $id)
	{
  foreach($mids AS $ids)
   if ($id==$ids)
	 {
		 $vboptions[vbpager_canpager] = 1;
		 return true; 
	  }
   }
if ($type==0)
 {
 $uids = explode(',', str_replace(' ', '', $gid_m));
 foreach($uids AS $ids)
  if ($bbuserinfo[usergroupid]==$ids)
   {
	 $vboptions[vbpager_canpager] = 1;
	  return true; 
   }
	$mids = explode(',', str_replace(' ', '', $bbuserinfo[membergroupids]));
  foreach($uids AS $id)
	{
  foreach($mids AS $ids)
   if ($id==$ids)
	 {
		 $vboptions[vbpager_canpager] = 1;
		 return true; 
	  }
   }
 }
  $vboptions[vbpager_canpager] = 0;
  return false;
  }
 function show_pager()
  {
  global $vboptions, $vbphrase, $bbuserinfo, $DB_site;
 if ($bbuserinfo[userid]!=0)
  {
 $pagerinfo = $DB_site->query_first("SELECT p.pagerid, p.parentpid, p.fromuserid, p.touserid, u.username, p.message, p.msgdate, p.canreply, p.hidden FROM " .  TABLE_PREFIX . "pager as p left join " .  TABLE_PREFIX . "user as u on (u.userid=p.fromuserid) WHERE p.delsent=0 and p.active=1 and p.touserid=". $bbuserinfo['userid'] ." order by msgdate");
	 $pagerinfo[timesent] = vbdate($vboptions['dateformat'], $pagerinfo[msgdate], true) . " " . vbdate($vboptions['timeformat'], $pagerinfo[msgdate]);  
  if (!($pagerinfo))
   {
  $show[pager]   = "";
  $show[pagererror] = 1;
  $nopager  = 1;
   }
   else
	 {
  if ($pagerinfo[hidden])
	 $pagerinfo[username] = $vbphrase['vbpager_na'];
  elseif($pagerinfo[username]=="")
   $pagerinfo[username] = $vbphrase['guest'];
	 }
  }
 elseif ( ($bbuserinfo[userid]==0) and ($vboptions[sessionid]!="") )
  {
  $userexist = $DB_site->query_first("SELECT sessionhash from " .  TABLE_PREFIX . "session where sessionhash='" . $vboptions[sessionid] . "'");
  if ($userexist)
  $pagerinfo = $DB_site->query_first("SELECT p.pagerid, p.parentpid, p.fromuserid, p.touserid, u.username, p.message, p.msgdate, p.hidden, p.canreply FROM " .  TABLE_PREFIX . "pager as p left join " .  TABLE_PREFIX . "user as u on (u.userid=p.fromuserid) WHERE p.active=1 and delsent=0 and p.tosessionid='". $vboptions[sessionid] ."' order by msgdate");
  if(!($pagerinfo))
   {
   $show[pager]   = "";
   $show[pagererror] = 1;
   $nopager  = 1;
   }
  else
	   {
	 $pagerinfo[timesent] = vbdate($vboptions['dateformat'], $pagerinfo[msgdate], true) . " " . vbdate($vboptions['timeformat'], $pagerinfo[msgdate]); 
  if ($pagerinfo[hidden])
	 $pagerinfo[username] = $vbphrase['vbpager_na'];
  elseif($pagerinfo[username]=="")
   $pagerinfo[username] = $vbphrase['guest'];
	   }
  }
   if (!$pagerinfo[pagerid])
 if ($bbuserinfo[pager] > 0)
  {
  $result = $DB_site->query("UPDATE ". TABLE_PREFIX . "user set pager=pager - 1 where 
userid = " . $bbuserinfo[userid] . "");
  return false;
  }
  return $pagerinfo;
  }
// [END HACK='vB Pager' AUTHOR='WwW.UAEWEB.COM' VERSION='2.0.4' CHANGEID= 7 ]