90 lines
2.3 KiB
PHP
90 lines
2.3 KiB
PHP
<?php
|
|
/**
|
|
* @brief IP Address Lookup extension
|
|
* @author <a href='https://www.invisioncommunity.com'>Invision Power Services, Inc.</a>
|
|
* @copyright (c) Invision Power Services, Inc.
|
|
* @license https://www.invisioncommunity.com/legal/standards/
|
|
* @package Invision Community
|
|
* @subpackage Nexus
|
|
* @since 18 Sep 2014
|
|
*/
|
|
|
|
namespace IPS\nexus\extensions\core\IpAddresses;
|
|
|
|
/* To prevent PHP errors (extending class does not exist) revealing path */
|
|
if ( !\defined( '\IPS\SUITE_UNIQUE_KEY' ) )
|
|
{
|
|
header( ( isset( $_SERVER['SERVER_PROTOCOL'] ) ? $_SERVER['SERVER_PROTOCOL'] : 'HTTP/1.0' ) . ' 403 Forbidden' );
|
|
exit;
|
|
}
|
|
|
|
/**
|
|
* IP Address Lookup extension
|
|
*/
|
|
class _Payouts
|
|
{
|
|
/**
|
|
* Supported in the ACP IP address lookup tool?
|
|
*
|
|
* @return bool
|
|
* @note If the method does not exist in an extension, the result is presumed to be TRUE
|
|
*/
|
|
public function supportedInAcp()
|
|
{
|
|
return TRUE;
|
|
}
|
|
|
|
/**
|
|
* Supported in the ModCP IP address lookup tool?
|
|
*
|
|
* @return bool
|
|
* @note If the method does not exist in an extension, the result is presumed to be TRUE
|
|
*/
|
|
public function supportedInModCp(): bool
|
|
{
|
|
return FALSE;
|
|
}
|
|
|
|
/**
|
|
* Find Records by IP
|
|
*
|
|
* @param string $ip The IP Address
|
|
* @param \IPS\Http\Url $baseUrl URL table will be displayed on or NULL to return a count
|
|
* @return \IPS\Helpers\Table|null
|
|
*/
|
|
public function findByIp( $ip, \IPS\Http\Url $baseUrl = NULL )
|
|
{
|
|
/* Return count */
|
|
if ( $baseUrl === NULL )
|
|
{
|
|
return \IPS\Db::i()->select( 'COUNT(*)', 'nexus_payouts', array( "po_ip LIKE ?", $ip ) )->first();
|
|
}
|
|
|
|
$table = \IPS\nexus\Payout::table( array( "po_ip LIKE ?", $ip ), $baseUrl );
|
|
$table->include[] = 'po_ip';
|
|
|
|
return (string) $table;
|
|
}
|
|
|
|
/**
|
|
* Find IPs by Member
|
|
*
|
|
* @code
|
|
return array(
|
|
'::1' => array(
|
|
'ip' => '::1'// string (IP Address)
|
|
'count' => ... // int (number of times this member has used this IP)
|
|
'first' => ... // int (timestamp of first use)
|
|
'last' => ... // int (timestamp of most recent use)
|
|
),
|
|
...
|
|
);
|
|
* @endcode
|
|
* @param \IPS\Member $member The member
|
|
* @return array|NULL
|
|
*/
|
|
public function findByMember( $member )
|
|
{
|
|
return \IPS\Db::i()->select( "po_ip AS ip, count(*) AS count, MIN(po_date) AS first, MAX(po_date) AS last", 'nexus_payouts', array( "po_member=?", $member->member_id ), NULL, NULL, "po_ip" )->setKeyField( 'ip' );
|
|
}
|
|
} |