Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- $sql = "select * from content_types_users_entries where user_id='".$usermodel->id."' ".$extra." order by date_added";
- //PERDARYTI SARASA
- //echo $sql;
- $db->query($sql); $i = 0;
- while($line=$db->next_item()){
- //$r[$i]["main"] = $line;
- $db2->query("select unique_title from content_types where id='".$line["c_id"]."'");
- if($line2=$db2->next_item()){
- $name = $line2["unique_title"];
- }
- $sql = "select * from `content_type_".$name."` where language='".$language."' and record_id='".$line["id"]."'";
- //echo $sql."<br />";
- $db2->query($sql);
- $photos = NULL;
- if($line2=$db2->next_item()){
- $r[$i] = $this->convert($line2);
- $photos = $this->checkDataforPhotos($line2["id"],$name);
- }
- //print_r($photos);
- $r[$i]["images"] = $photos;
- $r[$i]["content_type"] = $name;
- $r[$i]["c_id"] = $line["c_id"];
- //$r[$i]["uid"] = $line["id"];
- $r[$i]["user_id"] = $line["user_id"];
- //$r[$i]["id"] = $line["id"];
- $r[$i]["visitors_no"] = $line["visitors_no"];
- $r[$i]["visitors_no_week"] = $line["visitors_no_week"];
- $r[$i]["bold"] = $line["bold"];
- $r[$i]["date_updated"] = $line["date_updated"];
- $r[$i]["date_added"] = $line["date_added"];
- $r[$i]["active"] = $line["active"];
- $r[$i]["usertype"] = $line["usertype"];
- $r[$i]["images_count"] = count($photos);
- $i++;
- //$r[] = $line;
- }
Add Comment
Please, Sign In to add comment