1
Hey guys,
Got a question for you.... How could I extract a particular field from the xoops_users table and stick all of the results in an array() function? Basically what I am wanting to do is customize my sig script so that only members of my site are allowed to use the script. Its a basic if statement, but it needs to check the array to see if a the bf2pid number is included in the array. If its not it generates an error for the end user. That way I can secure the script a little bit better than how I have it.
One thing that you might want to know is that this script resides on another machine other than the one that the site is on. Therefore, I cant use the typical xoopsDB calls.
Here is the array that I have to work with, this is one that I wrote, but I don't think its working correctly.
mysql_select_db($database_bf2online, $bf2online);
$r = "SELECT bf2pid FROM xoops_users WHERE bf2pid > 0";//<------specify the table name you are storing your PIDS in
$result = mysql_query($r, $bf2online) or die("Help I can't connect");
$num_results = mysql_num_rows($result);
$AllowedPID = array('any');
Basically, I want only the pids that are in the database, as I have quite a few members that sign up for an account and don't update thier profile with thier pid. You are probably wondering what pid means, well its the number that EA assigns you when you buy the game and setup your online BF2 account. This number is associated with your overall score and all of the awards that you have accumulated while you are playing online. For example, mine is 43378148.
Most of my members don't update thier profile with this number, and my site is setup to do much more than generate stats sigs, it stores the stats for each member also. But to do that I need thier pid. So to make a long story short this is why I need to get this array going.
Any help with this would be super!
Thanks fellow xoopsers!
