public static function fromDB($id)
{
global $wicker;
$instance = new self();
$instance->connectToDatabase();
if (substr($id, 0, 3) == "[C]") {
$id = substr($id, 3);
$statement = $wicker->db->con()->prepare("SELECT * FROM `caps` WHERE `checksum` = ?");
} else {
$statement = $wicker->db->con()->prepare("SELECT * FROM `caps` WHERE `id` = ?");
}
$statement->execute(array($id));
$info = $statement->fetchObject();
$instance->id = $info->id;
$instance->location = $info->location;
$instance->repaired = $info->repaired;
$instance->raw = $info->raw;
$instance->checksum = $info->checksum;
$instance->complete = $info->complete;
$instance->runtime = $info->runtime;
$instance->status = $info->status;
$instance->password = $info->password;
$instance->timestamp = $info->timestamp;
$instance->size = $info->size;
$instance->bssid = $info->bssid;
$instance->essid = $info->essid;
$instance->packets = $info->packets;
return $instance;
}
public static function fromDB($scan, $bssid)
{
global $wicker;
$instance = new self();
$instance->connectToDatabase();
$statement = $instance->db->con()->prepare("SELECT * FROM `aps` WHERE `scan_id` = ? AND `bssid` = ?");
$statement->execute(array($scan, $bssid));
$info = $statement->fetchObject();
$instance->id = $info->id;
$instance->scan_id = $info->scan_id;
$instance->ind_scan_id = $info->ind_scan_id;
$instance->bssid = $info->bssid;
$instance->first_seen = $info->first_seen;
$instance->last_seen = $info->last_seen;
$instance->channel = $info->channel;
$instance->privacy = $info->privacy;
$instance->cipher = $info->cipher;
$instance->authentication = $info->authentication;
$instance->power = $info->power;
$instance->beacons = $info->beacons;
$instance->ivs = $info->ivs;
$instance->essid = $info->essid;
$instance->latitude = $info->latitude;
$instance->longitude = $info->longitude;
$instance->key = $info->key;
$instance->handshake = $info->handshake;
return $instance;
}
public static function fromDB($scan, $ap, $mac)
{
global $wicker;
$instance = new self();
$instance->connectToDatabase();
$statement = $instance->db->con()->prepare("SELECT * FROM `clients` WHERE `scan_id` = ? AND `ap_id` = ? AND `mac` = ?");
$statement->execute(array($scan, $ap, $mac));
$info = $statement->fetchObject();
$instance->id = $info->id;
$instance->scan_id = $info->scan_id;
$instance->ap_id = $info->ap_id;
$instance->mac = $info->mac;
$instance->first_seen = $info->first_seen;
$instance->last_seen = $info->last_seen;
$instance->power = $info->power;
$instance->packets = $info->packets;
$instance->bssid = $info->bssid;
$instance->probed = $info->probed;
return $instance;
}
public static function fromDB($id, $attack = 1)
{
global $wicker;
$instance = new self();
$instance->connectToDatabase();
$statement = $wicker->db->con()->prepare("SELECT * FROM attacks WHERE cap_id = ? AND attack = ?");
$statement->execute(array($id, $attack));
$info = $statement->fetchObject();
$instance->id = $info->id;
$instance->cap_id = $info->cap_id;
$instance->attack = $info->attack;
$instance->status = $info->status;
$instance->status_text = $info->status_text;
$instance->password = $info->password;
$instance->tmpfile = $info->tmpfile;
$instance->runtime = $info->runtime;
$instance->current = $info->current;
$instance->rate = $info->rate;
$instance->auth = $info->auth;
$instance->pid = $info->pid;
return $instance;
}
public static function fromDB($id)
{
global $wicker;
$instance = new self();
$instance->connectToDatabase();
if (substr($id, 0, 3) == "[G]") {
$id = substr($id, 3);
$statement = $instance->db->con()->prepare("SELECT * FROM `scans` WHERE `guid` = ?");
} else {
$statement = $instance->db->con()->prepare("SELECT * FROM `scans` WHERE `id` = ?");
}
$statement->execute(array($id));
$info = $statement->fetchObject();
$instance->id = $info->id;
$instance->guid = $info->guid;
$instance->time = $info->time;
$instance->status = $info->status;
$instance->individual = $info->individual;
$instance->aps = $info->aps;
$instance->clients = $info->clients;
$instance->wep = $info->wep;
$instance->pid = $info->pid;
return $instance;
}
