Example #1
0
 function edit_html_article($data, $cid, $uid)
 {
     $title = trim($data['title_updated']);
     //$video = trim($data['video_updated']);
     $body = trim($data['ck_updated']);
     //$cat_id = $data['edit_category'];
     $helper_obj = new Helper();
     $db_functions_obj = new DbFunctions();
     $tag_obj = new Tag();
     $cat_obj = new Category();
     $image1 = "";
     if (isset($_FILES['image1_updated'])) {
         $image1_type = explode(".", $_FILES['image1_updated']['name']);
         $image1 = $helper_obj->generate_name() . '.' . $image1_type[1];
         move_uploaded_file($_FILES["image1_updated"]["tmp_name"], VIDEOS_IMAGES_PATH_UPLOAD . $image1);
         $im = $helper_obj->img_resize(VIDEOS_IMAGES_PATH_UPLOAD . $image1, 620);
         $helper_obj->imageToFile($im, VIDEOS_IMAGES_PATH_UPLOAD . $image1, 100);
         $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_THUMBNAIL_PATH_UPLOAD . $image1, THUMBNAIL_W, THUMBNAIL_H, THUMBNAIL_R, THUMBNAIL_ENABLE);
         $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_PATH_FEATURE_UPLOAD . $image1, FEATURE_W, FEATURE_H, THUMBNAIL_R, THUMBNAIL_ENABLE);
         //woman app
         if ($cid == 49) {
             $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_THUMBNAIL_320x272_PATH_UPLOAD . $image1, IMAGE_320x272_W, IMAGE_320x272_H, THUMBNAIL_R, THUMBNAIL_ENABLE);
             $helper_obj->resize_crob_image(VIDEOS_IMAGES_PATH_UPLOAD . $image1, VIDEOS_IMAGES_THUMBNAIL_320x352_PATH_UPLOAD . $image1, IMAGE_320x352_W, IMAGE_320x352_H, THUMBNAIL_R, THUMBNAIL_ENABLE);
         }
     }
     $pgrate_id = $data['edit_pgrate'];
     $vid = $data['edit_article'];
     $section = $data['section_updated'];
     $time = time();
     /*$query = "UPDATE articles_html set title = '$title', body = '$body', category_id = '$cat_id',
       pg_rated_id = '$pgrate_id', updated_by = '$uid', updated_date = '$time', video = '$video' ";*/
     $query = "UPDATE articles_html set title = '{$title}', body = '{$body}',\n                                    pg_rated_id = '{$pgrate_id}', updated_by = '{$uid}', updated_date = '{$time}' ";
     if ($image1 != "") {
         $query .= " ,image = '{$image1}'";
     }
     $query .= " ,section = '{$section}'";
     $query .= " WHERE client_id = '{$cid}' AND id = '{$vid}'";
     //   echo($query);
     //update tags
     //1- delete old tags
     //2- add new tags
     $db_functions_obj->delete_article_tags($vid);
     foreach ($data['edit_tag'] as $tag_id) {
         $tag_obj->add_tags_to_article($vid, $tag_id);
     }
     $this->delete_article_categories($vid);
     foreach ($data['edit_category'] as $cid) {
         $cat_obj->add_categories_to_article($vid, $cid);
     }
     $result = $this->conn->db_query($query);
 }