tcsms/file_clean.php at main · VinnyVideo/tcsms · GitHub

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
<?php

set_time_limit(0);

require "./lib/std.php";
require "./file.lib.php";

$STD = new std;

$dbc = mysql_connect("localhost", "user", "password") or mysql_error();
mysql_select_db("dbname", $dbc) or mysql_error($dbc);

$do = new directoryObject( $_SERVER['DOCUMENT_ROOT'] . "/file/2" );
$flist = $do->traverse();

$linked = 0;
$unlinked = 0;

while ( $obj = $flist->getFile() ) {

	$query = mysql_query("SELECT r.*, g.* FROM tsms_resources r LEFT JOIN tsms_res_games g ON (r.eid = g.eid) WHERE r.type=2 AND g.file = '{$obj->name}'", $dbc);
	if (!$query)
		exit ("Error: " . mysql_error());

	if ( mysql_num_rows( $query ) > 0 ) {
		echo $obj->name . "<br>";
		$linked++;
	} else {
		echo "<font color='red'>{$obj->name}</font><br>";
		$unlinked++;

		$do->deleteFile( $obj->path );
	}
}

echo "<br>Linked: $linked<br>Unlinked: $unlinked<br>";

/*


$query = mysql_query("SELECT r.*, g.* FROM tsms_resources r LEFT JOIN tsms_res_games g ON (r.eid = g.eid) WHERE r.type=2", $dbc);
if (!$query)
	exit ("Error: " . mysql_error());

echo "<pre>";
while ($row = mysql_fetch_assoc($query))
{
	$q2 = mysql_query("SELECT COUNT(*) AS cnt, IFNULL(SUM(score), 0) AS scr FROM tsms_res_reviews WHERE gid = {$row['rid']}", $dbc);
	$r2 = mysql_fetch_assoc($q2);

	mysql_query("UPDATE tsms_res_games SET num_revs = '{$r2['cnt']}', rev_score = '{$r2['scr']}' WHERE eid = '{$row['eid']}'", $dbc) or exit(mysql_error());
	echo "{$row['eid']}, {$r2['cnt']}, {$r2['scr']}\n";
}
echo "</pre>";*/

?>