Want to take info from location and use it to query database

[Quarterbore]

I have a pet project to log all activity of a couple IP Hosts because of some issues I have been having... I have tools like the AEMultiple account detector and Multiple account registration detector in place and they have enabled me to handle new accounts but these trolls have resorted to browsing my site as guests and then e-mailing their nonsense.

So, I have been on a mission to identify these trolls and now it has just become kind of a fun technical challange to tighten up my website security and I want to release what I have done as a hack but I want to get one more thing added....

The following is done ONLY to visitors to my site that meet specific requirements (IE Usergroup = "0" AND Host = "AOL") but I can change those settings on the fly as necessary...
-----------------------------------------------------------------

Here is my question, my logging program determines the location of the person on my site and outputs the location like this:

/forums/showthread.php?t=19670
/forums/showthread.php?t=9356&page=2
/forums/search.php?searchid=35344
/forums/showpost.php?p=71629
/forums/showpost.php?p=71629&postcount=3
/forums/forumdisplay.php?f=49
/forums/member.php?u=3

What I need help understanding, even at a basic level (and I know this is not basic) is how can I create a series of conditionals to determine if the page is one of the following:

PART 1
showthread.php?t=
search.php?searchid=
forumdisplay.php?f=
/forums/member.php?u=

And then get the numeric ID

PART 2
19670
35344
49
3

...so that I can then query the database based on that numeric ID to get the corresponding information as the functions_online.php file does using the function convert_ids_to_titles()

STEP 3
Thread Title
Search Term
Forum Name
Member Profile Looked at

This will make reviewing my logs to find a troll with rather unusual interests to be quickly identified and with their IP and host being logged with this information is allows for corrective measures to be out into place.

I know how to use the pregmatch to get the info from STEP 1 but I do not know how I can get the numeric value from STEP 2 and put that into a variable. I do know how to do STEP 3 however!

So, can someone direct me to an online tutorial or just work up ONE example to get me started and I can then use my logs to work out how to do the rest...

So, can someone help me do JUST This one?

PHP Code:

// In the real world the following will be generated by server - defined as an example
$URL_logged = '/forums/showthread.php?t=9356&page=2'; 

if (preg_match ("/showthread.php/i", $URL_logged))  
{ 
// Define the location 
$page = 'Viewing Thread'; 
// in here I need to get the numeric value following the showthread.php?t= string above
// ----------------------------------------------
// --------- THIS IS WHERE I NEED HELP!!! ------
// ----------------------------------------------
$threadid = '9356'; 

//Then I can get the Name of the thread 

$results = $db->query_read("
    SELECT title, threadid, forumid, postusername
     FROM " . TABLE_PREFIX . "thread
     WHERE threadid = $threadid
     LIMIT 1"); 
while ($threadinfo = $db->fetch_array($results))
   {
    echo $page . ': ';
    echo $threadinfo[title] . '<br />';
    echo $URL_logged . '<br />';
    echo 'Forum: ' . $threadinfo[forumid] . '<br />';
    echo ' Posted By: ' . $threadinfo[postusername] . '<br />';

    } 

} 


[nico_swd]

PHP Code:


$URL_logged = '/forums/showthread.php?t=9356&page=2';  


if (preg_match ("/showthread.php\?(t|p)=([0-9]{1,10})/i", $URL_logged, $threadinfo))  
{ 
// Define the location 
$page = 'Viewing Thread'; 
// in here I need to get the numeric value following the showthread.php?t= string above
// ----------------------------------------------
// --------- THIS IS WHERE I NEED HELP!!! ------
// ----------------------------------------------
$threadid = $threadinfo[2];

echo $threadid; 


[Quarterbore]

Thank you SO VERY MUCH again for solving one of these preg_match questions for me!

Can you, or anyone else, confirm my "guess" that the (t|p) part of that code means that this is a variable with a value that follows it? I am also confident that the "t|p" serves as an "OR".

Regardless, I have been able to work out the rest of the versions of this code that I need and I am able to continue working on my hack. It is amaing how much information we can get if you start parcing these various page and variables for a potential problem user

Poor trolls will need to find a new hobby soon as I will be able to identify them before they even post at this rate....

[nico_swd]

Yeah, it would match either t or p. Note that you have to select from different tables, depending on the first match. Something like this

PHP Code:


if ($threadinfo[1] == 'p')
{
    $query = "
        SELECT * FROM ". TABLE_PREFIX . "post
        WHERE postid = ". $threadinfo[2];
}
else
{
    $query = "
        SELECT * FROM ". TABLE_PREFIX ."thread
        WHERE threadid = ". $threadinfo[2];
}