PHP db_getPackageStatus Examples

Example #1

File: db.php Project: jhena005/vlabsdevelopment

function db_changePackageStatus($packageId)
{
    $status = db_getPackageStatus($packageId);
    if ($status == 0) {
        $newstatus = 1;
    } else {
        $newstatus = 0;
    }
    $sql = "UPDATE module_vlabs_shoppingcart_store_inventory SET active = " . $newstatus . " WHERE id= " . $packageId;
    return eF_executeQuery($sql);
}

Example #2

File: db.php Project: arshanam/Moodle-ITScholars-LMS

function db_changePackageStatus($packageId)
{
    $status = db_getPackageStatus($packageId);
    if ($status == 0) {
        $newstatus = 1;
    } else {
        $newstatus = 0;
    }
    $sql = "UPDATE mdl_shoppingcart_store_inventory SET active = " . $newstatus . " WHERE id= " . $packageId;
    return execute_sql($sql, false);
}