authenticate();
     break;
 case 'checkauth':
     checkauthentication();
     break;
 case 'userinfo':
     getuserinformation();
     break;
 case 'getprivilages':
     getprivilages();
     break;
 case 'getquota':
     getquota();
     break;
 case 'getitems':
     getitems($_POST['playlistid']);
     break;
 case 'uploaditemfile':
     uploaditemfile($_FILES['file'], $_POST['playlistid']);
     break;
 case 'createitementry':
     createitementry($_POST['name'], $_POST['title'], $_POST['description'], $_POST['type'], $_POST['playlistid']);
     break;
 case 'deleteitem':
     deleteitem($_POST['itemid']);
     break;
 case 'getplaylistitems':
     getplaylistitems();
     break;
 case 'uploadplaylistfile':
     uploadplaylistfile($_POST['playlistid'], $_FILES['file']);
            $val["price"] = round($val["price"] * 100) / 100;
            $val["barcode"] = $objp->barcode;
            $val["type"] = "pro";
            echo "INSERT INTO products  values (" . $val["id"] . ", " . $id . ", '" . $val["label"] . "', " . $val["price"] . ")@@";
            //echo "<br>";
            $i++;
        }
    }
}
$objCat = new Categorie($db);
$cats = $objCat->get_full_arbo(0);
$retarray = array();
foreach ($cats as $key => $val) {
    echo "INSERT INTO cats  values (" . $val["rowid"] . ", " . $val["fk_parent"] . ", '" . $val["label"] . "')@@";
    //echo "<br>";
    getitems($val["rowid"]);
}
$resql = $db->query("SELECT DISTINCT p.rowid as id, p.price_ttc as price, p.label as label, p.barcode as barcode FROM " . MAIN_DB_PREFIX . "product as p LEFT JOIN llx_categorie_product as cp ON p.rowid = cp.fk_product LEFT JOIN llx_product_fournisseur_price as pfp ON p.rowid = pfp.fk_product WHERE p.entity IN ({$entity}) AND p.fk_product_type <> '1' AND cp.fk_categorie IS NULL GROUP BY p.rowid, p.ref, p.label, p.barcode, p.price, p.price_ttc, p.price_base_type, p.fk_product_type, p.tms, p.duration, p.tosell, p.tobuy, p.seuil_stock_alerte, p.desiredstock ORDER BY p.ref");
if ($resql) {
    $num = $db->num_rows($resql);
    $i = 0;
    while ($i < $num) {
        $objp = $db->fetch_object($resql);
        $val["id"] = $objp->id;
        $val["label"] = $objp->label;
        $val["price"] = $objp->price;
        $val["barcode"] = $objp->barcode;
        $val["type"] = "pro";
        echo "INSERT INTO products  values (" . $val["id"] . ", 0, '" . $val["label"] . "', " . $val["price"] . ")@@";
        $i++;
    }