/**
* Runs the collection scripts and stores result in memory
*/
void Report::collectData() {
std::string runAs;
// Check our effective username
if( getUser() == "root" ) {
runAs = runProgram( location + "scripts/loggedin.sh", "r");
}
// Local ip
setLocalIp( runProgram(location + "scripts/getlocalip.sh", "r") );
// Wifi hotspots
setWifi( runProgram(location + "scripts/nearbywifi.sh", "r") );
// Traceroute
setTraceroute( runProgram(location + "scripts/traceroute.sh", "r") );
// Webcam
setWebcam(runProgram(location + "scripts/webcam.sh " + runAs, "r"));
// Screenshot
setScreenshot(runProgram(location + "scripts/screenshot.sh " + runAs, "r"));
}
void RomInfo::fillData()
{
if (m_gamename == "")
{
return;
}
MSqlQuery query(MSqlQuery::InitCon());
QString systemtype;
if (m_system != "") {
systemtype += " AND system = :SYSTEM ";
}
QString thequery = "SELECT system,gamename,genre,year,romname,favorite,"
"rompath,country,crc_value,diskcount,gametype,plot,publisher,"
"version,screenshot,fanart,boxart,inetref,intid FROM gamemetadata "
"WHERE gamename = :GAMENAME "
+ systemtype + " ORDER BY diskcount DESC";
query.prepare(thequery);
query.bindValue(":SYSTEM", m_system);
query.bindValue(":GAMENAME", m_gamename);
if (query.exec() && query.next())
{
setSystem(query.value(0).toString());
setGamename(query.value(1).toString());
setGenre(query.value(2).toString());
setYear(query.value(3).toString());
setRomname(query.value(4).toString());
setField("favorite",query.value(5).toString());
setRompath(query.value(6).toString());
setCountry(query.value(7).toString());
setCRC_VALUE(query.value(8).toString());
setDiskCount(query.value(9).toInt());
setGameType(query.value(10).toString());
setPlot(query.value(11).toString());
setPublisher(query.value(12).toString());
setVersion(query.value(13).toString());
setScreenshot(query.value(14).toString());
setFanart(query.value(15).toString());
setBoxart(query.value(16).toString());
setInetref(query.value(17).toString());
setId(query.value(18).toInt());
}
setRomCount(romInDB(m_romname,m_gametype));
// If we have more than one instance of this rom in the DB fill in all
// systems available to play it.
if (RomCount() > 1)
{
query.prepare("SELECT DISTINCT system FROM gamemetadata "
"WHERE romname = :ROMNAME");
query.bindValue(":ROMNAME", Romname());
if (!query.exec())
MythDB::DBError("RomInfo::fillData - selecting systems", query);
while (query.next())
{
if (m_allsystems.isEmpty())
m_allsystems = query.value(0).toString();
else
m_allsystems += "," + query.value(0).toString();
}
}
else
{
m_allsystems = m_system;
}
}
