Project: Wordpress Plugin Photo Video Store 18.05

Vulnerability: #8928920 (2018-07-26 19:06:05)

Warning

There are many false positives, or unexploitable vulnerabilities. Please create working "PoC" exploit before reporting anything to vendor!

Details:

Sink @FUNCTION::mysqli_query
Risk _REQUEST
/photo-video-store/includes/payments/paypal/notification.php:52 (show/hide source)
32  		//Recurring subscriptions
33  		 if (!is_wp_error($response) and strstr($response['body'], 'VERIFIED')) {
34  			if ( $_REQUEST["txn_type"] == "subscr_signup" )
35  			{
36  				$sql = "update " . PVS_DB_PREFIX . "subscription_list set subscr_id='" .
37  					pvs_result( $_REQUEST["subscr_id"] ) . "' where id_parent=" . ( int )$_REQUEST["item_number"];
38  				$db->execute( $sql );
39  				exit();
40  			}
41  
42  			if ( $_REQUEST["txn_type"] == "subscr_payment" and $_REQUEST["payment_status"] ==
43  				"Completed" )
44  			{
45  				$sql = "select * from " . PVS_DB_PREFIX . "subscription_list where id_parent=" . ( int )
46  					$_REQUEST["item_number"];
47  				$ds->open( $sql );
48  				if ( ! $ds->eof )
49  				{
50  					if ( $ds->row["payments"] == 0 )
51  					{
52 pvs_subscription_approve( $_REQUEST["item_number"] );
53 pvs_send_notification( 'subscription_to_user', $_REQUEST["item_number"] ); 54 pvs_send_notification( 'subscription_to_admin', $_REQUEST["item_number"] );
Threat level 1

Callstack:

TMySQLConnection::execute /photo-video-store/includes/functions/mysqldb.php:19 (show/hide source)
1  <?php
2  // Exit if accessed directly.
3  if ( ! defined( 'ABSPATH' ) )
4  {
5  	exit;
6  }
7  
8  class TMySQLConnection
9  {
10  	var $connection;
11  
12  	function connect()
13  	{
14  		$this->connection = mysqli_connect( DB_HOST, DB_USER, DB_PASSWORD, DB_NAME );
15  	}
16  
17  	function execute( $query )
18  	{
19 if ( $mysqli_result = mysqli_query( $this->connection, $query ) )
20 { 21 return $mysqli_result;
TMySQLQuery::open /photo-video-store/includes/functions/mysqldb.php:52 (show/hide source)
32  }
33  
34  class TMySQLQuery
35  {
36  	var $connection;
37  	var $result;
38  	var $row;
39  	var $trow;
40  	var $eof;
41  	var $addnew;
42  	var $source;
43  	var $rc;
44  
45  	function __construct()
46  	{
47  		$this->connection = new TMySQLConnection;
48  	}
49  
50  	function open( $query )
51  	{
52 $this->result = $this->connection->execute( $query );
53 $this->movenext(); 54 }
@FUNCTION::pvs_affiliate_add_commission /photo-video-store/includes/functions/functions.php:7668 (show/hide source)
7648  						$user_info->ID . ",'" . $type . "'," . $id . "," . $user_info2-> aff_commission_buyer .
7649  						"," . $total . "," . pvs_get_time( date( "H" ), date( "i" ), date( "s" ), date( "m" ),
7650  						date( "d" ), date( "Y" ) ) . "," . $user_info->aff_referal . ",1)";
7651  					$db->execute( $sql );
7652  					pvs_send_notification( "commission_to_affiliate", $user_info->ID, "S" . $id,
7653  						"", $total );
7654  				}
7655  			}
7656  		}
7657  
7658  		if ( $type == "credits" )
7659  		{
7660  			$sql = "select user,credits from " . PVS_DB_PREFIX .
7661  				"credits_list where id_parent=" . ( int )$id;
7662  			$dp->open( $sql );
7663  			if ( ! $dp->eof )
7664  			{
7665  				$total = 0;
7666  				$sql = "select price from " . PVS_DB_PREFIX . "credits where id_parent=" . $dp->
7667  					row["credits"];
7668 $dt->open( $sql );
7669 if ( ! $dt->eof ) 7670 {
@FUNCTION::pvs_subscription_approve /photo-video-store/includes/functions/functions.php:6950 (show/hide source)
6930  }
6931  
6932  
6933  
6934  
6935  
6936  /**
6937   * Approve subscription
6938   *
6939   * @param  int $pid subscription order ID.
6940   */
6941  function pvs_subscription_approve( $pid )
6942  {
6943  	global $db;
6944  
6945  	$sql = "update " . PVS_DB_PREFIX .
6946  		"subscription_list set approved=1,payments=1 where id_parent=" . ( int )$pid;
6947  	$db->execute( $sql );
6948  
6949  	//Affiliate commission
6950 pvs_affiliate_add_commission( $pid, "subscription" );
6951 6952 //Create invoice
@INLINE::/photo-video-store/includes/payments/paypal/notification.php /photo-video-store/includes/payments/paypal/notification.php:52 (show/hide source)
32  		//Recurring subscriptions
33  		 if (!is_wp_error($response) and strstr($response['body'], 'VERIFIED')) {
34  			if ( $_REQUEST["txn_type"] == "subscr_signup" )
35  			{
36  				$sql = "update " . PVS_DB_PREFIX . "subscription_list set subscr_id='" .
37  					pvs_result( $_REQUEST["subscr_id"] ) . "' where id_parent=" . ( int )$_REQUEST["item_number"];
38  				$db->execute( $sql );
39  				exit();
40  			}
41  
42  			if ( $_REQUEST["txn_type"] == "subscr_payment" and $_REQUEST["payment_status"] ==
43  				"Completed" )
44  			{
45  				$sql = "select * from " . PVS_DB_PREFIX . "subscription_list where id_parent=" . ( int )
46  					$_REQUEST["item_number"];
47  				$ds->open( $sql );
48  				if ( ! $ds->eof )
49  				{
50  					if ( $ds->row["payments"] == 0 )
51  					{
52 pvs_subscription_approve( $_REQUEST["item_number"] );
53 pvs_send_notification( 'subscription_to_user', $_REQUEST["item_number"] ); 54 pvs_send_notification( 'subscription_to_admin', $_REQUEST["item_number"] );