<commit_before><?php
	$IC = new Item();
	$device = $IC->typeObject("device");


	$query = new Query();

	$query->sql("SELECT * FROM ".$device->db_useragents." WHERE device_id = 6510");
	$useragents = $query->results();
	foreach($useragents as $useragent) {
		print $useragent["useragent"]."<br>";

		if(!preg_match("/Desire S|Desire_S|DesireS/", $useragent["useragent"]) && $useragent["useragent"] && $useragent["useragent"] != '"') {
			print "INSERT INTO ".$device->db_unidentified." VALUES(DEFAULT, ".$useragent["useragent"].", '', '".SITE_UID."', CURRENT_TIMESTAMP)<br>";
			$query->sql("INSERT INTO ".$device->db_unidentified." VALUES(DEFAULT, ".$useragent["useragent"].", '', ".SITE_UID.", CURRENT_TIMESTAMP)");
			print "DELETE FROM ".$device->db_useragents." WHERE id = ".$useragent["id"]."<br>";
			$query->sql("DELETE FROM ".$device->db_useragents." WHERE id = ".$useragent["id"]);

		}
		

//		print_r($useragent);
		// $query->sql("INSERT INTO ".$device->db_unidentified." WHERE device_id = 6510");
		// $query->sql("DELETE FROM ".$device->db_useragents." WHERE device_id = 6510");
		
	}

//	print_r($devices);
?><commit_msg>fucking error<commit_after><?php
	$IC = new Item();
	$device = $IC->typeObject("device");


	$query = new Query();

	$query->sql("SELECT * FROM ".$device->db_useragents." WHERE device_id = 6510");
	$useragents = $query->results();
	foreach($useragents as $useragent) {
		print $useragent["useragent"]."<br>";

		if(!preg_match("/Desire S|Desire_S|DesireS/", $useragent["useragent"]) && $useragent["useragent"] && $useragent["useragent"] != '"') {
			print "INSERT INTO ".$device->db_unidentified." VALUES(DEFAULT, '".$useragent["useragent"]."', '', '".SITE_UID."', CURRENT_TIMESTAMP)<br>";
			print $query->sql("INSERT INTO ".$device->db_unidentified." VALUES(DEFAULT, '".$useragent["useragent"]."', '', '".SITE_UID."', CURRENT_TIMESTAMP)");
			print "DELETE FROM ".$device->db_useragents." WHERE id = ".$useragent["id"]."<br>";
			$query->sql("DELETE FROM ".$device->db_useragents." WHERE id = ".$useragent["id"]);

		}
		

//		print_r($useragent);
		// $query->sql("INSERT INTO ".$device->db_unidentified." WHERE device_id = 6510");
		// $query->sql("DELETE FROM ".$device->db_useragents." WHERE device_id = 6510");
		
	}

//	print_r($devices);
?>
{'fraction_non_alphanumeric': 0.2388451443569554, 'fraction_numerical': 0.010498687664041995, 'mean_word_length': 5.0986666666666665, 'pattern_counts': {'":': 0, '<': 11, '<?xml version=': 0, '>': 39, 'https://': 0, 'lorem ipsum': 0, 'www.': 0, 'xml': 0}, 'pii_count': 0, 'substrings_counts': 0, 'word_list_counts': {'cursed_substrings.json': 0, 'profanity_word_list.json': 0, 'sexual_word_list.json': 0, 'zh_pornsignals.json': 0}}
{'dir': 'git-commits-cleaned', 'id': '3731625', 'n_tokens_mistral': 881, 'n_tokens_neox': 787, 'n_words': 140}