SQL Value +1

[StikxX]

can someone tell me how to add the value in

inuse 

plus one?

            if ($lKey->Get('hwid') != '' && $lKey->Get('hwid') != $hwid){
                $result = array("success"=>"false", "reason"=>"");
                echo Encryption::Encrypt(json_encode($result));
                $lKey->Update('inuse', + 1);
                $lKey->Save();
                die();
            } 

[Zvoni]

I don’t see a SQL-Statement…

[techgnome]

I "do" ... but it's PHP, not VB so it's another lost thread that's going to get all the wrong responses...

stand by, asking the mods to move it...


-tg

EDIT - while it is a DB question, because of the library and technoloigy being used, it's less appropriate for the DB area, as it doesn't relate to general SQL ... but rather a mis use of a library in a specific language...

[techgnome]

                $lKey->Update('inuse', + 1);
                $lKey->Save();

You're not updating the data there ... you're setting it to 1. You need to get the current value, +1 it, THEN use that result in the update.

-tg

[StikxX]

Sorry, I don't know much about PHP and I'm trying my hand at it.

in the cell "inuse" is 1
if the stored hwid is wrong at

if ($lKey->Get('hwid') != '' && $lKey->Get('hwid') != $hwid){
                $result = array("success"=>"false", "reason"=>"Current Key is locked to different HWID, please contact product owner.");
                $lKey->Get('inuse');
                $lKey->Set('inuse', $inuse);
                $lKey->Save();
                echo Encryption::Encrypt(json_encode($result));
                die();
            } 

the cell "inuse" + 1 should be added, which is then in the cell 2.

This is all the code:

<?php
include('config/init.php');
if (isset($_POST['action'])){

    if ($_POST['action'] == 'init'){
        Encryption::Init(Config::Get('system.secret_app_key'));
    }
}
else {
    $request = file_get_contents('php://input');
    $decrypted = Encryption::Decrypt($request);
    $json = json_decode($decrypted, true);
    if (isset($json['action']) == false)
    {
        $result = array("success"=>"false", "reason"=>"No API call specified.");
        echo Encryption::Encrypt(json_encode($result));
        die();
    }
    else {

        $action = $json['action'];
        if ($action == "login") {
            $key = $json['key'];
            $hwid = $json['hwid'];
            $used = '1';
            $inuse = + 1;
            $app = $json['app'];
            $lKey = new LicenseKey();
            if ($lKey->Load(array('license_key'=>$key)) == false){
                $result = array("success"=>"false", "reason"=>"Specified License Key was not found in our database.");
                echo Encryption::Encrypt(json_encode($result));
                die();

            if ($lKey->Get('hwid') != '' && $lKey->Get('hwid') != $hwid){
                $result = array("success"=>"false", "reason"=>"Current Key is locked to different HWID, please contact product owner.");
                $lKey->Get('inuse');
                $lKey->Set('inuse', $inuse);
                $lKey->Save();
                echo Encryption::Encrypt(json_encode($result));
                die();
            }
            $result = array("success"=>"true", "reason"=>"You have been logged in.", "expires_on"=>Utils::GetDateNice($lKey->Get('expires_on')));
            echo Encryption::Encrypt(json_encode($result));
            Session::Set('key', $key);
            Session::Set('app_id', $app);
            Session::Set('hwid', $hwid);
            $onl = new OnlineUser();
            $onl->Update();
            die();
        }

    }
}

i think this is wrong

                $lKey->Get('inuse');
                $lKey->Set('inuse', $inuse);
                $lKey->Save(); 

[StikxX]

no one has an idea?