Messing with the bitgrog tracker!

[Randuin]

I've been trying to mess with the bitgrog tracker, one of the annoyances for me is the fact that it displays the info_hash for normal users instead of a name that you could specify. So I added a new field into the table called "namedesc" and the data type is TEXT and I'm using this line

if( mysql_query( '
                        INSERT INTO files ( info_hash, namedesc , uploaded , size , password , referer , last_seeded )
                        VALUES ( $mysql_info_hash , $namedesc , '
                         . time() 
                         . ','
                         . mysql_escape_string( $size )
                         . ','
                         . mysql_escape_string( md5( $password ) )
                         . ',' 
                         . mysql_escape_string( preg_quote( $referer , "/" ) )
                         . ', time())', $bttrack_db))
				echo "<p>Successfully uploaded " . $info_hash . ".</p>\n";
			else
				echo "<p>There was a problem adding the uploaded file to the files database.</p>\n";

But everytime it's showing up as "There was a problem adding the uploaded file to the files database"

[drew010]

for an explanation of what is going wrong
change
echo "<p>There was a problem adding the uploaded file to the files database.</p>\n";
to
echo "<p>There was a problem adding the uploaded file to the files database. The reason was " . mysql_error() . "</p>\n";

[sidney]

might be because you have time() within single quotes

. ','. time().')', $bttrack_db)) 

[Weedpacket]

Originally posted by sidney
might be because you have time() within single quotes

. ','. time().')', $bttrack_db)) 

[/B]

...or meant to say NOW(), which is what MySQL uses.