2019-01-13, 06:35 AM
I have following code in my test2.php file:
$db->update_query('userfields', array("fid".$mybb->settings['drs_setting_user_fid'] => "NULL"), '
Let's assume "fid".$mybb->settings['drs_setting_user_fid']" is just fid1.
Here, I set fid1 to "NULL" value, but after I have done above code in PHP, and run "SELECT * FROM
[attachment=41434]
Blank row between slutty and mcjesus shouldn't even be shown there. I mean, entire row.
All it does is just make fid1 field blank field, but not setting fid1 to NULL to avoid being searched by that select sql command.
How can I make that fid1 actuall NULL that cannot be searched by "SELECT * FROM
$db->update_query('userfields', array("fid".$mybb->settings['drs_setting_user_fid'] => "NULL"), '
ufid
= ' . (int)$user['uid'],"",true);Let's assume "fid".$mybb->settings['drs_setting_user_fid']" is just fid1.
Here, I set fid1 to "NULL" value, but after I have done above code in PHP, and run "SELECT * FROM
mybb_userfields
WHERE fid1 IS NOT NULL" in myphpadmin, it still search that fid['drs_setting_user_fid']. It shouldn't even be shown. But it shows like following picture:[attachment=41434]
Blank row between slutty and mcjesus shouldn't even be shown there. I mean, entire row.
All it does is just make fid1 field blank field, but not setting fid1 to NULL to avoid being searched by that select sql command.
How can I make that fid1 actuall NULL that cannot be searched by "SELECT * FROM
mybb_userfields
WHERE fid1 IS NOT NULL"?