drupal_add_js cannot find my javascript file
It is most likely a path issue, you should be able to use the DRUPAL_ROOT constant to get the correct one:

$path = DRUPAL_ROOT . '/sites/www.example.com/footer.js';
drupal_add_js($path);