[SOLVED] SQL Help
 

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

*Note that $userid is feeding the correct value

I am running this on paidsub_build and paidsub_delete.

Note that the explode works fine in useradmin_update_save where it is fed
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 ;)

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".

I tried:

and

both did nothing and did not produce any errors.

Edit: i will try your edited fix now

I think you'd want

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


or I could be wrong. :)

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:

The other option does nothing.

Try this:

The above did nothing. No errors either.

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

For reference the following query runs fine:

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

Could this be the problem:

Once again the code will run fine it it is fed 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:

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:

does nothing

however from useradmin_update_save I can do:

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:
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:
--------------- 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:

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

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


then view the page source.