The Arcive of Official vBulletin Modifications Site.

Html33 · #1 05-21-2009, 06:00 AM

Hello, in question with this thread; https://vborg.vbsupport.ru/showthrea...78#post1814178

I have managed to make it so that i can import the php page using $status using this code in a plguin;

ob_start();
include('status.php');
$status = ob_get_contents();
ob_end_clean();

in the global start. When using this code here;

PHP Code:


			
<table width="100%" border="0" align="center">



  <tr>



    <td height="21"><p><a href="http://dhgaming.com/call-duty-4/6565-call-duty-4-server-up-pc.html"><center><img src="images/head/RS_private.PNG" border="0" /></center></a>



      <center><?



//RSpserver



$info["address"]="75.127.117.56";



$info["port"]="43594";







$infocount = 0;



$timeout = 2;







for ($i=0; $i<=$infocount; $i++){



$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);



if ($fp) {



echo "<center><img src='status/rspserver/online.gif' />";



}else{



echo "<center><img src='status/rspserver/offline.gif' />";



}



}



?></center>



    </p></td>



    <td><a href="http://dhgaming.com/"><center><img src="images/head/liveforspeed.png" border="0" /></center></a> 



      <center><?



//LFS



$info["address"]="75.127.117.56";



$info["port"]="4574";







$infocount = 0;



$timeout = 2;







for ($i=0; $i<=$infocount; $i++){



$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);



if ($fp) {



echo "<center><img src='status/rspserver/online.gif' />";



}else{



echo "<center><img src='status/rspserver/offline.gif' />";



}



}



?></center></td>



    <td><a href="http://dhgaming.com/call-duty-4/6565-call-duty-4-server-up-pc.html"><center><img src="images/head/COD4.png" border="0" /></center></a> 



      <center><center><?



//COD4



$info["address"]="75.127.117.56";



$info["port"]="28960";







$infocount = 0;



$timeout = 2;







for ($i=0; $i<=$infocount; $i++){



$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);



if ($fp) {



echo "<center><img src='status/rspserver/online.gif' />";



}else{



echo "<center><img src='status/rspserver/offline.gif' />";



}



}



?></center><center></td>



    <td><p><a href="http://dhgaming.com/ventrilo-server/6781-connection-detials.html#post27761"><center><img src="images/head/ventrilo.png" border="0" /></center></a>



      <center><?



//vent



$info["address"]="75.127.117.56";



$info["port"]="3784";







$infocount = 0;



$timeout = 2;







for ($i=0; $i<=$infocount; $i++){



$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);



if ($fp) {



echo "<center><img src='status/rspserver/online.gif' />";



}else{



echo "<center><img src='status/rspserver/offline.gif' />";



}



}



?></center>



    </p></td>



    <td><a href="http://dhgaming.com/arcade.php"><center><img src="images/head/arcade.png" border="0" /></center></a></td>



  </tr>



</table>

Vbulletin will return an error of;

Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT * FROM credits_bank WHERE userid = 57 AND status = 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, May 21st 2009 @ 01:54:40 AM
Error Date : Thursday, May 21st 2009 @ 01:54:48 AM
Script : http://dhgaming.com/index.php
Referrer :
IP Address : 8*.1*2.7*.***
Username : m
Classname : vB_Database
MySQL Version :

If i rename the script in the FTP so the plguin can't load it, it works fine.

What's the problem?

Dismounted · #2 05-21-2009, 10:18 AM

<a href="http://www.vbulletin.com/docs/html/troubleshoot_mysql_goneaway" target="_blank">Lost connection to MySQL server during query</a>

Html33 · #3 05-21-2009, 03:08 PM

thanks for the responce, but i can't understand how to fix it.

The script i mad has a time out of 2 seconds, so that sholden't be a problem, should it?

Lynne · #4 05-21-2009, 03:39 PM

Are you putting that exact code into the global_start plugin? You should really not do echos but instead assign it to variables and spit the variables out in a template. I don't know if that is the problem, but it might help. Where is that database call from cuz it isn't in your plugin.

Html33 · #5 05-21-2009, 07:23 PM

Right, the way it is configured is as below

Plugin;

Then in my FTP i have a file called " status.php " which is what the plugin refers too. This allows me to have $status

Within this status.php i have the following code;

PHP Code:


			
<table width="100%" border="0" align="center">

  <tr>

    <td height="21"><p><a href="http://dhgaming.com/call-duty-4/6565-call-duty-4-server-up-pc.html"><center><img src="images/head/RS_private.PNG" border="0" /></center></a>

      <center><?

//RSpserver

$info["address"]="75.127.117.56";

$info["port"]="43594";



$infocount = 0;

$timeout = 2;



for ($i=0; $i<=$infocount; $i++){

$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);

if ($fp) {

echo "<center><img src='status/rspserver/online.gif' />";

}else{

echo "<center><img src='status/rspserver/offline.gif' />";

}

}

?></center>

    </p></td>

    <td><a href="http://dhgaming.com/"><center><img src="images/head/liveforspeed.png" border="0" /></center></a> 

      <center><?

//LFS

$info["address"]="75.127.117.56";

$info["port"]="4574";



$infocount = 0;

$timeout = 2;



for ($i=0; $i<=$infocount; $i++){

$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);

if ($fp) {

echo "<center><img src='status/rspserver/online.gif' />";

}else{

echo "<center><img src='status/rspserver/offline.gif' />";

}

}

?></center></td>

    <td><a href="http://dhgaming.com/call-duty-4/6565-call-duty-4-server-up-pc.html"><center><img src="images/head/COD4.png" border="0" /></center></a> 

      <center><center><?

//COD4

$info["address"]="75.127.117.56";

$info["port"]="28960";



$infocount = 0;

$timeout = 2;



for ($i=0; $i<=$infocount; $i++){

$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);

if ($fp) {

echo "<center><img src='status/rspserver/online.gif' />";

}else{

echo "<center><img src='status/rspserver/offline.gif' />";

}

}

?></center><center></td>

    <td><p><a href="http://dhgaming.com/ventrilo-server/6781-connection-detials.html#post27761"><center><img src="images/head/ventrilo.png" border="0" /></center></a>

      <center><?

//vent

$info["address"]="75.127.117.56";

$info["port"]="3784";



$infocount = 0;

$timeout = 2;



for ($i=0; $i<=$infocount; $i++){

$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout);

if ($fp) {

echo "<center><img src='status/rspserver/online.gif' />";

}else{

echo "<center><img src='status/rspserver/offline.gif' />";

}

}

?></center>

    </p></td>

    <td><a href="http://dhgaming.com/arcade.php"><center><img src="images/head/arcade.png" border="0" /></center></a></td>

  </tr>

</table>

Then on my FORUMHOME template i have this

Quote:

$status

at the place i want the code to appear.

Doing all of that stops the ENTIRE forum from working, not just the home page.

which returns the error off;

Quote:

Database error in vBulletin 3.7.4:

Invalid SQL:
SELECT * FROM credits_bank WHERE userid = 57 AND status = 1;

MySQL Error : MySQL server has gone away
Error Number : 2006
Request Date : Thursday, May 21st 2009 @ 01:54:40 AM
Error Date : Thursday, May 21st 2009 @ 01:54:48 AM
Script : http://dhgaming.com/index.php
Referrer :
IP Address : 8*.1*2.7*.***
Username : m
Classname : vB_Database
MySQL Version :

Lynne · #6 05-21-2009, 07:36 PM

I would not be doing it that way at all, so I don't know that you want to listen to my advice. But, if you only want this on the forumhome page (index.php), then I would pick a plugin that is only called on that page and put the php in there and assign the 'echo' outputs to variables and then eval the template at the end of the plugin to spit it all out in the forumhome page somewhere.

ie - a template called "my_template":

HTML Code:

<table width="100%" border="0" align="center"> 
  <tr> 
    <td height="21"><p><a href="http://dhgaming.com/call-duty-4/6565-call-duty-4-server-up-pc.html"><center><img src="images/head/RS_private.PNG" border="0" /></center></a> 
      <center>
$var1
</center> 
    </p></td> 
    <td><a href="http://dhgaming.com/"><center><img src="images/head/liveforspeed.png" border="0" /></center></a>  
      <center>
$var2
etc

plugin:

PHP Code:


			
$info["address"]="75.127.117.56"; 
$info["port"]="43594"; 

$infocount = 0; 
$timeout = 2; 

for ($i=0; $i<=$infocount; $i++){ 
$fp = @fsockopen ($info["address"], $info["port"], $errno, $errstr, $timeout); 
if ($fp) { 
$var1= "<center><img src='status/rspserver/online.gif' />"; 
}else{ 
$var1= "<center><img src='status/rspserver/offline.gif' />"; 
} 
}
etc

eval('$mystuff = "' . fetch_template('my_template') . '";');

And then put $mystuff into the FORUMHOME template where you want it (or use one of the template_hooks.

I have NOT tried this at all and I'm sure it would need some tweeking including figuring out which hook location is best.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.07191 seconds Memory Usage 2,241KB Queries Executed 11 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (1)ad_showthread_firstpost (1)ad_showthread_firstpost_sig (1)ad_showthread_firstpost_start (1)bbcode_html (3)bbcode_php (3)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)navbar (3)navbar_link (120)option (6)post_thanks_box (6)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (6)post_thanks_postbit_info (6)postbit (6)postbit_onlinestatus (6)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.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/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.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 showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!