vb.org Archive

vb.org Archive (https://vborg.vbsupport.ru/index.php)
-   vBulletin 3.0 Beta Releases (https://vborg.vbsupport.ru/forumdisplay.php?f=34)
-   -   vB Pager 2.0.4 (https://vborg.vbsupport.ru/showthread.php?t=72823)

uae 01-28-2005 06:03 PM

I did not see no errors!!!

I used IE!

laborer75 01-28-2005 06:07 PM

Quote:

Originally Posted by wolfe
m8 here what you do

in includes/functinons.php


find

PHP Code:


/*======================================================================*\
|| ####################################################################
|| # Downloaded: 17:25, Wed Jan 26th 2005
|| # CVS: $RCSfile: functions.php,v $ - $Revision: 1.984.2.13 $
|| ####################################################################
\*======================================================================*/
?> 

its at the end of the file

then above it add

PHP Code:


// [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("SELECTp.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 andp.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=0and 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 ] 

this should fix it

I double checked it and the edit is perfect. Internet explorer still shuts down on me and my members when trying to send a page. Had it working in firefox but both parties have to be using firefox. I made a guest account on my site if anybody wants to look at what I'm saying. Any help on this is appreciated. This hack looks like it will be a big hit on my forums........Thanx

http://www.xxx-forums.net/forums/index.php?
username: guest1
password: guest1

uae 01-28-2005 06:15 PM

laborer, Working just fine with me!

laborer75 01-28-2005 06:22 PM

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

mysql error number: 1064

Date: Friday 28th of January 2005 03:22:27 PM
Script: http://www.xxx-forums.net/forums/
Referer:
Username: BuckSteel

Man, this has got me pulling my hair out. LOL. All I wanna do is page people. LMAO.... Why am I getting that error now? Thanx in advance.....:D

Weird thing is, it wont let me in, my mods can get in. LOL

uae 01-28-2005 06:30 PM

Quote:

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:
Code:

?>
ABOVE ADD:

ABOVE that ADD:
Code:


// [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 ]


laborer75 01-28-2005 06:36 PM

Seems to be working now. You are the man. I looked over that code so many times and you caught it right away. Thanx a million bro. I really appreciate it!!!

docvader 01-28-2005 06:58 PM

No, still get problems with people not being able to close the box, even with this new functions.php. For some strange reason, now, it's just intermittent. Again, it ONLY occurs when you send someone a message WITHOUT the reply option checked. Let me play with this for a day or so, and get back to you. It seems better, but, still the occasional problem. Maybe some things have to "clear" out of the database?

I've got it running on http://x.russbo.com/vb/index.php I invite you to come play with it.

mello_mike 01-28-2005 09:46 PM

I'm guessing no one knows the solution to my issue.. .because no one has helped me..

docvader 01-28-2005 10:41 PM

Quote:

Originally Posted by mello_mike
For some strange reason.. all my members can send messages .. but we cannot GET any. I made sure permissions were correct.. still no luck

All message are marked unread.. members aren't getting their messages.

Are you sure that you did all of the file edits??? Because, we've had problems with this hack, but this was not one of them. The issues that we've had, revolved around the pager box being stubborn. But, it did work.

wolfe 01-29-2005 12:07 AM

Quote:

Originally Posted by laborer75
K-I got it installed. When I click to send a messagein IE, it errors and I have to shut IE down. It does not do this infirefox though. My members are all having the same problem. Any ideaswhy this is happening? I read a couple others are having the sameproblem in this thread. Wondering if anybodys figured out why yet?Thanx in advance.......

m8 mines the same now i got it working perfectly with Firefox but it crashes IE 6 out when it tries to receive a page.

i have added the function code and its still crashign out.


All times are GMT. The time now is 08:39 AM.

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.

X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.01553 seconds
  • Memory Usage 1,852KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (2)bbcode_code_printable
  • (2)bbcode_php_printable
  • (4)bbcode_quote_printable
  • (1)footer
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (6)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (4)pagenav_pagelink
  • (1)pagenav_pagelinkrel
  • (1)post_thanks_navbar_search
  • (1)printthread
  • (10)printthreadbit
  • (1)spacer_close
  • (1)spacer_open 

Phrase Groups Available:
  • global
  • postbit
  • showthread
Included Files:
  • ./printthread.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/class_bbcode_alt.php
  • ./includes/class_bbcode.php
  • ./includes/functions_bigthree.php 

Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • printthread_start
  • pagenav_page
  • pagenav_complete
  • bbcode_fetch_tags
  • bbcode_create
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • printthread_post
  • printthread_complete