[SOLVED] SQL Help

[ZERO <ibis>]

I am running into a strange problem where the function below is not working:

*Note that $userid is feeding the correct value

PHP Code:

$sbquery2 = $db->query_read("
            SELECT " . TABLE_PREFIX . "user.membergroupids
            FROM " . TABLE_PREFIX . "user
            WHERE " . TABLE_PREFIX . "user.userid = $userid
        ");
        
        $sbrow2 = $db->fetch_array($sbquery2);
        $sbmemgroups = $sbrow2['membergroupids'];
    }

    $sbusergroups = explode(",", $sbmemgroups); 


I am running this on paidsub_build and paidsub_delete.

Note that the explode works fine in useradmin_update_save where it is fed

PHP Code:

$userdata->fetch_field('membergroupids') 


This leads me to believe that I am doing something wrong with the sql however it does not generate any errors.

Thanks for the help

[kh99]

My guess is that the array key is TABLE_PREFIX . "user.membergroupids" and not just "membergroupids".

ETA: If that's the problem, the easiest thing to do would be to just change the first line of SQL to read "SELECT membergroupids".

[ZERO <ibis>]

I tried:

PHP Code:

$sbmemgroups = $sbrow2['" . TABLE_PREFIX . "user.membergroupids']; 


and

PHP Code:

$sbmemgroups = $sbrow2['user.membergroupids']; 


both did nothing and did not produce any errors.

Edit: i will try your edited fix now

[kh99]

I think you'd want

$sbmemgroups = $sbrow2[TABLE_PREFIX . 'user.membergroupids'];

or else just change the first line of your SQL to be

SELECT membergroupids

or I could be wrong.

[ZERO <ibis>]

Invalid SQL:

SELECT vbb_membergroupids
FROM vbb_user
WHERE vbb_user.userid = 1;

MySQL Error : Unknown column 'vbb_membergroupids' in 'field list'

This was the error for:

PHP Code:

$sbmemgroups = $sbrow2[TABLE_PREFIX . 'user.membergroupids']; 


The other option does nothing.

[kh99]

Try this:

PHP Code:

$sbquery2 = $db->query_read("
            SELECT membergroupids
            FROM " . TABLE_PREFIX . "user
            WHERE userid = $userid
        ");
        
        $sbrow2 = $db->fetch_array($sbquery2);
        $sbmemgroups = $sbrow2['membergroupids'];
    }

    $sbusergroups = explode(",", $sbmemgroups); 


[ZERO <ibis>]

The above did nothing. No errors either.

--------------- Added [DATE]1306027999[/DATE] at [TIME]1306027999[/TIME] ---------------

For reference the following query runs fine:

PHP Code:

$sbquery = $db->query_read("
            SELECT " . TABLE_PREFIX . "userfield.field9
            FROM " . TABLE_PREFIX . "userfield
            WHERE " . TABLE_PREFIX . "userfield.userid = $userid
        ");

        $sbrow = $db->fetch_array($sbquery);
        $sbaid = $sbrow['field9']; 


[kh99]

Originally Posted by ZERO <ibis>

For reference the following query runs fine:

OK, sorry, I guess i was wrong about what the problem was. Anyone else?

[ZERO <ibis>]

Could this be the problem:

PHP Code:

foreach($sbusergroups as $sbgroup)
    {
        $sbgroupint = intval($sbgroup); 


Once again the code will run fine it it is fed

PHP Code:

$userdata->fetch_field('membergroupids') 


from useradmin_update_save which suggests that the problem is not in this part but in the sql of getting membergroupids directly from the database.

--------------- Added [DATE]1306036694[/DATE] at [TIME]1306036694[/TIME] ---------------

I have even tried:

$membergroupids = fetch_membergroupids_array($user, false);

still not working correctly... no errors I am making the changes directly in the function directly without using the hook to avoid any complications. I know the above function should be working as it is used as part of the default vb code within the same function.

but then doing:

PHP Code:

$sbusergroups = $sbmemgroups;

foreach($sbusergroups as $sbgroup)
    {
        $sbgroupint = intval($sbgroup); 


does nothing

however from useradmin_update_save I can do:

PHP Code:

$sbmemgroups = $userdata->fetch_field('membergroupids');

$sbusergroups = explode(",", $sbmemgroups);

foreach($sbusergroups as $sbgroup)
    {
        $sbgroupint = intval($sbgroup); 


and that works without any problem... all I want is to be able to get the member groups of the user in paidsub_build and process it though:

PHP Code:

foreach($sbusergroups as $sbgroup)
    {
        $sbgroupint = intval($sbgroup); 


just as I am able to do from useradmin_update_save

--------------- Added [DATE]1306050752[/DATE] at [TIME]1306050752[/TIME] ---------------

I think there may be a way to get the output I want via the fetch_membergroupids_array function but I do not know how to use it.

As stated above as long as I can get something that works as the below does but for paidsub_buid I am good:

PHP Code:

$sbmemgroups = $userdata->fetch_field('membergroupids');

$sbusergroups = explode(",", $sbmemgroups);

foreach($sbusergroups as $sbgroup)
    {
        $sbgroupint = intval($sbgroup); 


--------------- Added [DATE]1306057439[/DATE] at [TIME]1306057439[/TIME] ---------------

Ok so here is what I did to test this out:

I fed the data directly from txt files so that I could see that the functions run correctly. The program grabs no data externally just runs identical code on the paidsub_build hook and the useradmin_update_save hook.

When run from the paidsub_build it never runs completely but useradmin_update_save works. They both use exactly the same code. Example:

PHP Code:

$sbmemgroups2 = file_get_contents('data2.txt');
    
$sbusergroups = explode(",", $sbmemgroups2);

foreach($sbusergroups as $sbgroup)
    {
        $sbgroupint = intval($sbgroup);

if ($sbgroupint == 16)
        {
            $sbpaid = true;
        }
} 


The contents of data2.txt are not changed. When run via useradmin_update_save returns true and when run via paidsub_build returns false...

[kh99]

Is the code you posted the entire plugin? Are you sure the paidsub_build hook is even getting executed? Where are you checking the "returned" value?

The only thing I can think of from what you posted is that the paidsub_build hook is in a function and the other hook isn't, so if you're trying to set a global you probably need to add a "global $sbpaid;" line (or else set an existing global instead).

Also, sometimes you can debug by echoing an HTML comment, like

echo "<!-- sbusergroups = $sbusergroups -->\r\n"

then view the page source.