Jump to content

filh

New Members
  • Posts

    3
  • Joined

  • Last visited

filh's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. I don't want to make unnecesesarry changes on files.
  2. Thank you for your answer. I have a web app that created by a freelancer. I can't reach him now. He had made some bug fixes on DB. He didn't update DB re-install instructions after his bug fixes. I'm creating the DB as first stand. But I've accidentally deleted DB. Retrieved the DB. Didn't run. I'm little to no knowledge about PHP though. Logs don't point an error. The cause of my doubt on this particle the logs fall onto; Adding video XXXXXXXXX Removing duplicate video id XXXXXXXXX Adding video XXXXXXXXX Removing duplicate video id XXXXXXXXX Adding video XXXXXXXXX Removing duplicate video id XXXXXXXXX ... In this scenario while all files are safe DB can be modified (that only leans on my logic not PHP/MySQL information) This app were working perfect 4 days ago. I didn't make any modification on anything. Just retrieve the DB from DB instructions but it's missing. Don't would like to touch PHP part. Would like to do something on DB. This is a little bit bigger part; $this->log("Adding video ".$data['vid']); $src = !empty($data['src_hq']) ? $data['src_hq'] : $data['src']; mysql_query("INSERT INTO videos VALUES(0, '".mysql_real_escape_string($data['vid'])."', '".mysql_real_escape_string($data['owner'])."', '".mysql_real_escape_string($data['title'])."', '".mysql_real_escape_string($data['description'])."', '".mysql_real_escape_string($src)."', '".mysql_real_escape_string($data['thumbnail_link'])."', '".mysql_real_escape_string($data['length'])."', '', '', NOW(), 0, '')"); //remove if duplicate if(mysql_error()){ foreach($this->video_ids as $kk => $dd){ if($dd == $data['vid']){ $this->log("Removing duplicate video id : ".$dd); unset($this->video_ids[$kk]); break; } } } There must be something to do on DB.
  3. mysql_query("INSERT INTO videos VALUES(0, '".mysql_real_escape_string($data['vid'])."', '".mysql_real_escape_string($data['owner'])."', '".mysql_real_escape_string($data['title'])."', '".mysql_real_escape_string($data['description'])."', '".mysql_real_escape_string($src)."', '".mysql_real_escape_string($data['thumbnail_link'])."', '".mysql_real_escape_string($data['length'])."', '', '', NOW(), 0, '')");
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.