[jwocky]

Originally Posted by SirAdrian

Foreach is very useful again (and in this case, all the loops are really)...

I would do something like this:

PHP Code:

// ...

$users = getNames();

foreach ($users as $user)
{
    // $user[0] = username
    // $user[1] = start date
    // $user[2] = end date
} 


Just a note, I changed my code earlier to a simplified version without updating the output, so check back on that. Anyway, inside this foreach loop, $user would be an array containing the user currently being processed. In here, you would display / do whatever you plan to do with each user.

Edit: echo $users[0] won't work because it is an array. It will just display "Array". To display anything, you will have to know the exact value you are searching for (or use a loop, which goes through them all). An example would be

PHP Code:

echo $users[0][0]; 


which would display the username of the first user.

@acidburn: the data is in a text file, so queries are no good here.

Adrian, absolutly perfect... this works perfectly for me. I'm still finishing up this section of my process, but basicly this is what i'm having it do, I'm having it take the first date (the start date) and compare it to today's date and my if->then statement combined with your foreach statement has done the trick so far.

FOr now I put in echo commands just to see if it was working so far, I will now replace those with the actual function I want it to do, which has to do with changing the usergroupd of that user... This will take a bit more research

PHP Code:

function comparestart($today,$users)
    {

    foreach ($users as $user)
    {
            // $user[0] = username
            // $user[1] = start date
            // $user[2] = end date
    /* echo $user[1]; */
    echo "<BR>";
        if ($today==$user[1])
        {
        echo $user[1];
        }

    } 

    } 


Ok...

Now on to Stage 3..

Now that this script effectivly checks the user list from a text file and checks the date against todays date, it then effectivly sorts out whos date matchs todays date.

(note in previous posts I was using actual usernames, now I will swith to userid #s to keep things simple for now.. so $user is now a number instead of a name)

Now I have it calling a function called promote() which will take that user and move him from his current usergroup to usergroup #9

I'm using this call:

PHP Code:

function promote($username)
{

$vbulletin->db->query_write("UPDATE user SET usergroupid = '" . "9" . "' WHERE userid IN (" . $username . ")"
echo $username . " promoted!!" . "<BR>";

} 


Now this is not working.. I think the problem might not be just a problem with bad database query instructions, but a bigger problem. Namely, how in the world does this script know which database to use, etc etc.. Again i'm very new to this, so is there some initialization I should put at the begining of my php file to tell it what $vbulletin is, etc and where to find my databases?