function writecache()
{
// flush temporary cache to the actual tables
global $dblink, $tbl, $crack_cas, $cid, $agid, $superhash, $hlist;
mysqli_query_wrapper($dblink, "UPDATE tmphlcracks SET zaps=1 WHERE cracked>0");
if ($superhash) {
mysqli_query_wrapper($dblink, "UPDATE hashlists SET cracked=cracked+(SELECT IFNULL(SUM(cracked),0) FROM tmphlcracks) WHERE id={$hlist}");
}
mysqli_query_wrapper($dblink, "UPDATE hashlists JOIN tmphlcracks ON hashlists.id=tmphlcracks.hashlist SET hashlists.cracked=hashlists.cracked+tmphlcracks.cracked");
mysqli_query_wrapper($dblink, "INSERT IGNORE INTO zapqueue (hashlist,agent,time,chunk) SELECT hashlistusers.hashlist,hashlistusers.agent,{$crack_cas},{$cid} FROM hashlistusers JOIN tmphlcracks ON hashlistusers.hashlist=tmphlcracks.hashlist AND tmphlcracks.zaps=1 WHERE hashlistusers.agent!={$agid}");
// increase the timer so the chunks won't time out
$crack_cas = time();
mysqli_query_wrapper($dblink, "UPDATE chunks SET cracked=cracked+(SELECT IFNULL(SUM(cracked),0) FROM tmphlcracks),solvetime={$crack_cas} WHERE id={$cid}");
mysqli_query_wrapper($dblink, "UPDATE tmphlcracks SET cracked=0,zaps=0");
}
function delete_agent($agent)
{
// delete agent
global $dblink;
$vysledek1 = mysqli_query_wrapper($dblink, "DELETE FROM assignments WHERE agent={$agent}");
$vysledek2 = $vysledek1 && mysqli_query_wrapper($dblink, "DELETE FROM errors WHERE agent={$agent}");
$vysledek3 = $vysledek2 && mysqli_query_wrapper($dblink, "DELETE FROM hashlistusers WHERE agent={$agent}");
$vysledek4 = $vysledek3 && mysqli_query_wrapper($dblink, "DELETE FROM zapqueue WHERE agent={$agent}");
// orphan the chunks
$vysledek5 = $vysledek4 && mysqli_query_wrapper($dblink, "UPDATE hashes JOIN chunks ON hashes.chunk=chunks.id AND chunks.agent={$agent} SET chunk=NULL");
$vysledek6 = $vysledek5 && mysqli_query_wrapper($dblink, "UPDATE hashes_binary JOIN chunks ON hashes_binary.chunk=chunks.id AND chunks.agent={$agent} SET chunk=NULL");
$vysledek7 = $vysledek6 && mysqli_query_wrapper($dblink, "UPDATE chunks SET agent=NULL WHERE agent={$agent}");
$vysledek8 = $vysledek7 && mysqli_query_wrapper($dblink, "DELETE FROM agents WHERE id={$agent}");
return $vysledek8;
}
