}
}
return "ok";
}
if ($_GET["vlic"]) {
$ch = curl_init();
curl_setopt($ch, CURLOPT_URL, "http://www.w3sistemas.com/clientes/licencia.php?key=" . md5(strtoupper($_GET["key"]) . "octa") . "&e=" . tr567());
curl_setopt($ch, CURLOPT_RETURNTRANSFER, 1);
$xd = curl_exec($ch);
curl_close($ch);
$data = json_decode(base64_decode($xd), true);
if ($data[status] == "ok") {
$dbmain = @sqlite_open("../../main/main.octa");
$x = @sqlite_query($dbmain, "drop table tblicencia");
sqlite_query($dbmain, "CREATE TABLE [tblicencia] ([code] VARCHAR(32) NULL,[cliente] VARCHAR(32) NULL,[rif] VARCHAR(32) NULL,[empresas] INTEGER DEFAULT '1' NULL,[usuarios] INTEGER DEFAULT '1' NULL,[expira] INTEGER DEFAULT '0' NULL,\n\t[erp] INTEGER DEFAULT '1' NULL,[ecommerce] INTEGER DEFAULT '1' NULL,[mobile] INTEGER DEFAULT '1' NULL,[pos] INTEGER DEFAULT '1' NULL)");
sqlite_query($dbmain, "insert into tblicencia (code,cliente,rif,empresas,usuarios,expira,mobile,ecommerce,pos,erp) values ('" . tr567() . "','" . $data[cliente] . "','" . $data[rif] . "','" . $data[empresas] . "','" . $data[usuarios] . "','" . $data[expira] . "','" . $data[mobile] . "','" . $data[ecommerce] . "','" . $data[pos] . "','" . $data[erp] . "')");
}
echo json_encode($data);
}
if ($_GET["vsql"]) {
$ic = 0;
$dbmain = @sqlite_open("../../main/main.octa");
$server = @sqlite_fetch_array(sqlite_query($dbmain, "SELECT * FROM tbconexion"), SQLITE_ASSOC);
if ($con = @mssql_connect($server[servidor], $server[login], $server[password])) {
$sql = mssql_query("select name from sys.databases");
while ($base = mssql_fetch_array($sql)) {
if ($sq2 = @mssql_query("select * from " . $base["name"] . ".dbo.tbdefinicion")) {
$data["base"][] = $base["name"];
$ic++;
}
}
$result = $dbhandle->query($query);
return $result;
}
function sqlite_fetch_array(&$result, $type)
{
$i = 0;
while ($result->columnName($i)) {
$columns[] = $result->columnName($i);
$i++;
}
$resx = $result->fetchArray(SQLITE3_ASSOC);
return $resx;
}
}
$dbmain = sqlite_open("../../main/main.octa") or die("not!");
$rows = sqlite_fetch_array(sqlite_query($dbmain, "SELECT count(*) as count FROM tblicencia where code like '" . tr567() . "%'"), SQLITE_ASSOC);
$pasa = $rows['count'] > 0 ? true : false;
if ($pasa === true) {
switch ($response) {
case "user_logged":
//echo session_id()."<br>";
//var_dump($_SESSION);
die(is_array($_SESSION["octa-lite-user"]) ? "true" : "false");
break;
case "sql_connect":
$mserver = @sqlite_fetch_array(sqlite_query($dbmain, "SELECT * FROM tbconexion"), SQLITE_ASSOC);
die(@mssql_connect($mserver[servidor], $mserver[login], $mserver[password]) ? "true" : "false");
break;
case "exists_databases":
$rows2 = @sqlite_fetch_array(sqlite_query($dbmain, "SELECT count(*) as count FROM tbempresas"), SQLITE_ASSOC);
die($rows2['count'] > 0 ? "true" : "false");
