Trying to access array offset on value of type bool in

Posted: Tue Apr 18, 2023 4:14 am

Since yesterday testing and couldn't find any error. Today morning I decided to activate a block to see if the all function are in order then it came this one.

Notice: Trying to access array offset on value of type bool in /www.bestbuildpc.org/admin/modules/blocks.php on line 963

Code:

function ChangeStatus($bid, $ok=0) {


   global $prefix, $db, $admin_file;


   $bid = intval($bid);


   $row = $db->sql_fetchrow($db->sql_query('SELECT `active FROM `' . $prefix . '_blocks` WHERE `bid`=\'' . $bid . '\''));


   $active = intval($row['active']);


   if (($ok) OR ($active == 1)) {


      if ($active == 0) {


         $active = 1;


      } elseif ($active == 1) {


         $active = 0;


      }


      $result2 = $db->sql_query('UPDATE `' . $prefix . '_blocks` SET `active`=\'' . $active . '\' WHERE `bid`=\'' . $bid . '\'');


      Header('Location: ' . $admin_file . '.php?op=BlocksAdmin');


   } else {


      $row3 = $db->sql_fetchrow($db->sql_query('SELECT `title`, `content`, `url`, `bposition` FROM `' . $prefix . '_blocks` WHERE `bid`=\'' . $bid . '\''));


      $title = $row3['title'];


      $content = $row3['content'];


      $url = $row3['url'];


      $bposition = $row3['bposition'];


      include_once('header.php');


      GraphicAdmin();


      echo '<br />';

Site Admin Joined: Aug 22, 2007 Posts: 1772

You should really compare at first your files with the files from the core-package. It seems you made changes on it. [ Only registered users can see links on this board! Get registered or login! ]

From all what I can see, you missed an ` in the first query on the active-field:

php Code:

// yours


$row = $db->sql_fetchrow($db->sql_query('SELECT `active FROM `' . $prefix . '_blocks` WHERE `bid`=\'' . $bid . '\''));





// try this


$row = $db->sql_fetchrow($db->sql_query('SELECT `active` FROM `' . $prefix . '_blocks` WHERE `bid`=\'' . $bid . '\''));

Posted: Tue Apr 18, 2023 6:16 pm

Yes, my mistake grrrrrr. Bang Head

Thanks