function generaterandnumber($tablename, $colname, $connection)
{
$pk;
do {
$pk = guidv4(openssl_random_pseudo_bytes(16));
$sqlcheck = "SELECT {$colname} FROM {$tablename} WHERE {$colname} = '{$pk}'";
$rs = $connection->query($sqlcheck);
} while ($rs->num_rows !== 0);
return $pk;
}
function PunkRecordIntakeHandler()
{
global $l;
$l = new llog();
global $generalAuthKey;
if (authorized($generalAuthKey)) {
$l->a("Started DataIntakeHandler<br>");
$status = 0;
if (isset($_FILES['uploadedfile'])) {
$ulfilename = base64_encode($_FILES['uploadedfile']['name']);
$ulsize = base64_encode($_FILES['uploadedfile']['size']);
} else {
$ulfilename = null;
$ulsize = null;
}
$filename = "coal_temp/" . "data." . guidv4() . ".stt";
if (isset($_FILES['uploadedfile'])) {
if (move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $filename)) {
} else {
$status = 2;
$l->a("error 2<br>");
}
} else {
$status = 6;
$l->a("error 6<br>");
}
$csum = new Csum(null, $filename);
$insertion = store(file_get_contents($filename), $csum);
$id = $insertion['id'];
$status = $insertion['status'];
$db = new FractureDB('futuqiur_ember');
if (isset($_REQUEST['punkUser'])) {
$addedTree = $db->addRow('trees', 'user, collection, number, csum', "'" . $_REQUEST['punkUser'] . "', '" . $_REQUEST['punkCollection'] . "', '" . $id . "', '" . $csum->len . '|' . $csum->md5 . '|' . $csum->sha . '|' . $csum->s512 . "'");
}
if (check($status, true)) {
echo $id . '|' . $csum->len . '|' . $csum->md5 . '|' . $csum->sha . '|' . $csum->s512;
}
}
}
function coalFromUpload()
{
global $l;
$l->a("Started coalFromUpload<br>");
$status = 0;
if (isset($_FILES['uploadedfile'])) {
$ulfilename = base64_encode($_FILES['uploadedfile']['name']);
$ultype = base64_encode($_FILES['uploadedfile']['type']);
$ulsize = base64_encode($_FILES['uploadedfile']['size']);
$tmpname = base64_encode($_FILES['uploadedfile']['tmp_name']);
$ferror = base64_encode($_FILES['uploadedfile']['error']);
} else {
$ulfilename = null;
$ultype = null;
$ulsize = null;
$tmpname = null;
$ferror = null;
}
$metadata = base64_encode(var_export($_FILES, true));
$filename = "coal_temp/" . "data." . guidv4() . ".cot";
if (isset($_FILES['uploadedfile'])) {
if (move_uploaded_file($_FILES['uploadedfile']['tmp_name'], $filename)) {
} else {
$status = 2;
$l->a("error 2<br>");
}
} else {
$status = 6;
$l->a("error 6<br>");
}
$csum = new Csum(null, $filename);
$coal_creation = coalFromFile($filename, $csum);
$coal_creation['details']['ulfilename'] = $ulfilename;
$coal_creation['details']['ultype'] = $ultype;
$coal_creation['details']['ulsize'] = $ulsize;
$coal_creation['details']['tmpname'] = $tmpname;
$coal_creation['details']['error'] = $ferror;
$coal_creation['details']['metadata'] = $metadata;
$coal_creation['status'] = status_add($status, $coal_creation['status']);
return $coal_creation;
}
<?php
include 'sqlInfo.php';
include 'sendEmail.php';
$person = json_decode(file_get_contents('php://input'));
$hash = password_hash($person->passwd, PASSWORD_DEFAULT);
$guid = guidv4();
try {
$conn = new PDO("mysql:host={$servername};dbname={$dbname}", $username, $password);
$conn->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
$emailCheck_sql = $conn->prepare("SELECT CUSTOMER_ID FROM CUSTOMER WHERE LOGIN_EMAIL_ADDRESS = ?;");
$person_sql = $conn->prepare("INSERT INTO PERSON(F_NAME, L_NAME, STREET_ADDRESS, CITY, STATE, ZIPCODE, PHONE_NUMBER, CELL_NUMBER) \n \t\t\t\t\t\t\t\t\t VALUES (?,?,?,?,?,?,?,?)");
$customer_sql = $conn->prepare("INSERT INTO CUSTOMER(PERSON_PERSON_ID, LOGIN_EMAIL_ADDRESS) VALUES (?,?)");
$login_sql = $conn->prepare("INSERT INTO LOGIN(EMAIL_ADDRESS, PASSWORD, ROLE, CODE, VERIFIED, LAST_LOGIN) VALUES (?,?,?,?,?,?)");
$stmt = $conn->prepare("SELECT PERSON_ID FROM PERSON WHERE F_NAME = ? AND L_NAME = ?;");
$emailCheck_sql->execute(array($person->email));
while ($check = $emailCheck_sql->fetch()) {
$customer_id = $check[0];
break;
}
if (!isset($customer_id)) {
$person_sql->execute(array($person->firstname, $person->lastname, $person->street, $person->city, $person->state, $person->zipcode, $person->homenumber, $person->cellnumber));
$stmt->execute(array($person->firstname, $person->lastname));
while ($row = $stmt->fetch()) {
$person_id = $row[0];
break;
}
$customer_sql->execute(array($person_id, $person->email));
$login_sql->execute(array($person->email, $hash, customer, $guid, 0, '1900-01-01'));
//$message = sendEmail('<*****@*****.**>',$person->email,'Email Verification',"<html><body>Thank You For Registering With FVTaxPrep\n\nPlease Click The Following Link To Confirm Your Account: <a href = 'www.fvtaxprep.com/data/validate.php?email=".$person->email."&code=".guid."'>www.fvtaxprep.com</a></body></html>");
echo "User has been created.";
} else {
echo "Error: " . $sql . "<br>" . $conn->error;
}
} else {
echo "0 results";
}
$conn->close();
}
if (isset($_POST["register"])) {
# print_r($_POST);
$name = $_POST["name"];
$email = $_POST["email"];
$password = $_POST["password"];
$table_name = "users";
$register_guid = guidv4();
$form_data = array('name' => $name, 'email' => $email, 'register_password' => $password, 'register_verified' => 'false');
// Users
//Check if user is already registered
$conn = connectDb();
if ($conn->connect_error) {
die("Connection failed: " . $conn->connect_error);
}
$sql = "SELECT * FROM users WHERE email='" . $email . "' AND register_verified='true'";
$result = $conn->query($sql);
#echo "$result->num_rows".$result->num_rows;
if ($result->num_rows > 0) {
echo "Sorry this user is already registered, you will need to login.";
} else {
//Create User and Send Verification Email
$conn = connectDb();
/*
* LibreNMS
*
* Copyright (c) 2014 Neil Lathwood <https://github.com/laf/ http://www.lathwood.co.uk/fa>
*
* This program is free software: you can redistribute it and/or modify it
* under the terms of the GNU General Public License as published by the
* Free Software Foundation, either version 3 of the License, or (at your
* option) any later version. Please see LICENSE.txt at the top level of
* the source code distribution for details.
*/
$enabled = dbFetchCell("SELECT `value` FROM `callback` WHERE `name` = 'enabled'");
if ($enabled == 1) {
if (dbFetchCell("SELECT `value` FROM `callback` WHERE `name` = 'uuid'") == '') {
dbInsert(array('name' => 'uuid', 'value' => guidv4(openssl_random_pseudo_bytes(16))), 'callback');
}
$uuid = dbFetchCell("SELECT `value` FROM `callback` WHERE `name` = 'uuid'");
$queries = array('alert_rules' => 'SELECT COUNT(`severity`) AS `total`,`severity` FROM `alert_rules` WHERE `disabled`=0 GROUP BY `severity`', 'alert_templates' => 'SELECT COUNT(`id`) AS `total` FROM `alert_templates`', 'api_tokens' => 'SELECT COUNT(`id`) AS `total` FROM `api_tokens` WHERE `disabled`=0', 'applications' => 'SELECT COUNT(`app_type`) AS `total`,`app_type` FROM `applications` GROUP BY `app_type`', 'bgppeer_state' => 'SELECT COUNT(`bgpPeerState`) AS `total`,`bgpPeerState` FROM `bgpPeers` GROUP BY `bgpPeerState`', 'bgppeer_status' => 'SELECT COUNT(`bgpPeerAdminStatus`) AS `total`,`bgpPeerAdminStatus` FROM `bgpPeers` GROUP BY `bgpPeerAdminStatus`', 'bills' => 'SELECT COUNT(`bill_type`) AS `total`,`bill_type` FROM `bills` GROUP BY `bill_type`', 'cef' => 'SELECT COUNT(`device_id`) AS `total` FROM `cef_switching`', 'cisco_asa' => 'SELECT COUNT(`oid`) AS `total`,`oid` FROM `ciscoASA` WHERE `disabled` = 0 GROUP BY `oid`', 'mempool' => 'SELECT COUNT(`cmpName`) AS `total`,`cmpName` FROM `cmpMemPool` GROUP BY `cmpName`', 'current' => 'SELECT COUNT(`current_type`) AS `total`,`current_type` FROM `current` GROUP BY `current_type`', 'dbschema' => 'SELECT COUNT(`version`) AS `total`, `version` FROM `dbSchema`', 'snmp_version' => 'SELECT COUNT(`snmpver`) AS `total`,`snmpver` FROM `devices` GROUP BY `snmpver`', 'os' => 'SELECT COUNT(`os`) AS `total`,`os` FROM `devices` GROUP BY `os`', 'type' => 'SELECT COUNT(`type`) AS `total`,`type` FROM `devices` GROUP BY `type`', 'hardware' => 'SELECT COUNT(`device_id`) AS `total`, `hardware` FROM `devices` GROUP BY `hardware`', 'ipsec' => 'SELECT COUNT(`device_id`) AS `total` FROM `ipsec_tunnels`', 'ipv4_addresses' => 'SELECT COUNT(`ipv4_address_id`) AS `total` FROM `ipv4_addresses`', 'ipv4_macaddress' => 'SELECT COUNT(`port_id`) AS `total` FROM ipv4_mac', 'ipv4_networks' => 'SELECT COUNT(`ipv4_network_id`) AS `total` FROM ipv4_networks', 'ipv6_addresses' => 'SELECT COUNT(`ipv6_address_id`) AS `total` FROM `ipv6_addresses`', 'ipv6_networks' => 'SELECT COUNT(`ipv6_network_id`) AS `total` FROM `ipv6_networks`', 'xdp' => 'SELECT COUNT(`id`) AS `total`,`protocol` FROM `links` GROUP BY `protocol`', 'ospf' => 'SELECT COUNT(`device_id`) AS `total`,`ospfVersionNumber` FROM `ospf_instances` GROUP BY `ospfVersionNumber`', 'ospf_links' => 'SELECT COUNT(`device_id`) AS `total`,`ospfIfType` FROM `ospf_ports` GROUP BY `ospfIfType`', 'arch' => 'SELECT COUNT(`pkg_id`) AS `total`,`arch` FROM `packages` GROUP BY `arch`', 'pollers' => 'SELECT COUNT(`id`) AS `total` FROM `pollers`', 'port_type' => 'SELECT COUNT(`port_id`) AS `total`,`ifType` FROM `ports` GROUP BY `ifType`', 'port_ifspeed' => 'SELECT COUNT(`ifSpeed`) AS `total`,ROUND(`ifSpeed`/1000/1000) FROM `ports` GROUP BY `ifSpeed`', 'port_vlans' => 'SELECT COUNT(`device_id`) AS `total`,`state` FROM `ports_vlans` GROUP BY `state`', 'processes' => 'SELECT COUNT(`device_id`) AS `total` FROM `processes`', 'processors' => 'SELECT COUNT(`processor_id`) AS `total`,`processor_type` FROM `processors` GROUP BY `processor_type`', 'pseudowires' => 'SELECT COUNT(`pseudowire_id`) AS `total` FROM `pseudowires`', 'sensors' => 'SELECT COUNT(`sensor_id`) AS `total`,`sensor_class` FROM `sensors` GROUP BY `sensor_class`', 'storage' => 'SELECT COUNT(`storage_id`) AS `total`,`storage_type` FROM `storage` GROUP BY `storage_type`', 'toner' => 'SELECT COUNT(`toner_id`) AS `total`,`toner_type` FROM `toner` GROUP BY `toner_type`', 'vlans' => 'SELECT COUNT(`vlan_id`) AS `total`,`vlan_type` FROM `vlans` GROUP BY `vlan_type`', 'vminfo' => 'SELECT COUNT(`id`) AS `total`,`vm_type` FROM `vminfo` GROUP BY `vm_type`', 'vmware' => 'SELECT COUNT(`id`) AS `total` FROM `vmware_vminfo`', 'vrfs' => 'SELECT COUNT(`vrf_id`) AS `total` FROM `vrfs`', 'mysql_version' => 'SELECT 1 AS `total`, @@version AS `version`');
foreach ($queries as $name => $query) {
$data = dbFetchRows($query);
$response[$name] = $data;
}
$output = array('uuid' => $uuid, 'data' => $response);
$data = json_encode($output);
$submit = array('data' => $data);
$fields = '';
foreach ($submit as $key => $value) {
$fields .= $key . '=' . $value . '&';
}
rtrim($fields, '&');
/**
* Returns a randomly generated version 4 UUID
* @return string
*/
function generateUUIDv4()
{
return guidv4(openssl_random_pseudo_bytes(16));
}
