vBulletin 4.2.5 Nightmare: MySQLi destroyed Sidebar Custom Code.

[MacroPhotoPro]

My brother is designed MySQL code for the sidebar to our site.

All was wonderful, for many years ...

Then, we 'upgraded' from vBulletin 4.2.2 (which ran the MySQL code we put together)
... but now the vBulletin 4.2.5. (and our new webhost) runs MySQLi ... and we have no idea how to get our side carts functional again. Here is our (failed) attempt to re-do the code:

$local_dev = FALSE;
   if ($local_dev) { echo "<link rel='stylesheet' type='text/css' href='styles/additional.css' />"; }
   if ($local_dev==TRUE) {
      
      // Establish a Local MySQL connection
      $host = 'localhost:3306';
      $user = 'xxxxxxx';
      $pass = 'xxxxxxx';
      $con = mysqli_connect($host,$user,$pass,TRUE);
      $con_user = mysqli_connect($host,$user,$pass,TRUE);
      $con_tol =  mysqli_connect($host,$user,$pass,TRUE);
      
      // User Identity Variables
      $user_id = 2;
      $usergroupid = 5;
      $security_token = 0;    

      // Website configurations     
      $baseurl = "localhost/macrophoto/";
      
   } else {

      // database connection: macrophoto 
      $host = 'localhost';
      $user = 'xxxxxxx';
      $pass = 'xxxxxxx';
      $con = mysqli_connect($host,$user,$pass,TRUE);

      // database connection: Forum database
      $host = 'localhost';
      $user = 'xxxxxxx';
      $pass = 'xxxxxxx';
      $con_user = mysqli_connect($host,$user,$pass,TRUE);
      
         // database connection: treeoflife
         $host = 'localhost';
         $user = 'xxxxxxx';
         $pass = 'xxxxxxx';
         $con_tol = mysqli_connect($host,$user,$pass,TRUE);

      // Website configurations     
      $baseurl = "www.thenaturephotographer.club";
   }
   $SQL_QRY = "
      SELECT
         pic_id, pic_user_id, pic_folder, pic_title, pic_subtitle
      FROM
         xxxxxxx.xxxxxxx
      WHERE
         pic_folder>1
      ORDER BY pic_uploaded DESC
      LIMIT 0,5
   ";
   $result = mysqli_query($SQL_QRY, $con);
   $cart = "<table  style='margin-top:10px;' width='100%' >";
   $i = 0;
   while ($row=mysqli_fetch_array($result)){
      
      $i++;
      
      // grab the data
      $pic_id = $row["pic_id"];
      $user_id = $row["pic_user_id"];
      $folder_id = $row["pic_folder"];
      $title = $row["pic_title"];
      $subtitle = $row["pic_subtitle"];
      if (!empty($subtitle)) { $title = "$title ($subtitle)"; }
      
      $size = "tiny";
      $url_mosaic          = "http://$baseurl"."image_mosaic.php";
      
      // Get the images
      $field = "pic_path";
      $path = "'thumbnails/', pic_user_id, '/', "; 
      $SQL_QRY = "SELECT concat($path"."pic_user_id, '_thumb_', LPAD(pic_id, 10, '0'), '_$size.', pic_ext ) as '$field' FROM macrophoto.pics WHERE pic_id=$pic_id";
      $result2 = mysql_query($SQL_QRY, $con);
      $row = mysqli_fetch_array($result2);
      $img_path = $row[$field];
      $size = getimagesize($img_path);
      $width = $size[0];
      $height = $size[1];
      
      // Username
      $field = "username"; 
      $SQL_QRY = "SELECT $field FROM natureforum.vbuser WHERE userid=$user_id";
      $value_result = mysqli_query($SQL_QRY, $con_user);
      if ($value_result != NULL ) {
         $row = mysqli_fetch_array($value_result);
         $user_name = $row[$field];
      } else {
         $user_name = "";
      }     
      
      // Avatar
      $field = "avatarrevision";
      $SQL_QRY = "SELECT $field FROM natureforum.vbuser WHERE userid='$user_id'";
      $result3 = mysqli_query($SQL_QRY, $con_user);
      $row = mysqli_fetch_array($result3);
      $av_idx = $row[$field];
      $avatar_path = "./customavatars/thumbs/avatar$user_id"."_$av_idx.gif";
      if (!file_exists($avatar_path)) { $avatar_path = "./images/misc/unknown.gif"; }
      $avatar = "<img style='width=100%;max-width:30px;' src='$avatar_path'>";
      $profile_url = "member.php?$user_id";
      $avatar = "<a href='$profile_url' target='profile' title='$user_name'>$avatar</a>";

      // Get a Link to the View page
      if ($local_dev) {
         $view_path = "$baseurl"."image_view.php?username=$user_name&folder_id=$folder_id&pic_id=$pic_id&thumb_size=$size";
      } else {
         $view_path = "$user_name/$folder_id/$pic_id";
      }
      
      if ($width>$height) { $measure="width"; } else { $measure="height"; }
      $img = "<img style='$measure:100%;min-$measure:200px;max-$measure:210px;box-shadow: 5px 5px 5px #1c1d1f;margin-bottom:15px;margin-left:10px;' src='$img_path' title='$title'>";
      $link = "<a href='$view_path' target='view'>$img</a>";
      $user = "<font size='-1'><a href='$url_mosaic?user_id=$user_id' target='user'>$user_name</a></font>";
      
      if ($i==5) {$px = "0px";}  else { $px="1px"; }
      
      $cart .= "<tr' ><td style='padding-top:5px;border-bottom:$px dotted;' align='left' valign='top' width='10%' >$avatar</td><td style='padding-top:5px;border-bottom:$px dotted;' valign='middle' align='center' >$link</td></tr>";
            
   }
   $cart .= "</table>";
return $cart;

Can anyone please point out our coding errors?

Would be very grateful!

[Dave]

Take a look at https://www.phpclasses.org/blog/pack...to-MySQLi.html

[MacroPhotoPro]

Thanks, Dave, I will try!

[Dead Eddie]

I noticed this:

PHP Code:

$result2 = mysql_query($SQL_QRY, $con); 


[MacroPhotoPro]

Thanks