[RS_Jelle]

Originally Posted by Spenser

If rating a file there is an error:


Any clue how to fix this?

Strange, as I'm using sql_prepare which should take care of adding quotes to the value.
You're the first having problems with it :erm:

Try this: open downloads.php and find

PHP Code:

$db->query_write("UPDATE " . TABLE_PREFIX . "dl_files SET `rating`=".$db->sql_prepare($voteinfo['total']/$voteinfo['votes'])." WHERE `id` = ".$file['id']); 


replace with

PHP Code:

$db->query_write("UPDATE " . TABLE_PREFIX . "dl_files SET `rating`='".$db->escape_string($voteinfo['total']/$voteinfo['votes'])."' WHERE `id` = ".$file['id']); 


Originally Posted by darknusens

What are the names of the tables that get written to the database for this mod?
I see there might be about 8 but I'm not sure.
The ones I think they are are,

1. dl_cats

2. dl_comments

3. dl_downloads

4. dl_files

5. dl_images

6. dl_main

7. dl_stats

8. dl_votes

is there any other tables that are associated with downloadsII That I need to know about? The reason I want to know is for backup purposes.

That's all
+ some standard modifications to the user and usergroup table