/**
 * This function recursively creates the children pages for the given $cpage_id.
 *
 * @param ADONewConnection $db The database connection
 * @param integer $cpage_id
 * @param integer $COMMUNITY_ID The community ID of the community to copy.
 * @param integer $new_parent_id
 * @param integer $new_community_id
 * @param integer the proxy id for the user who owns the community.
 */
function create_child_pages($db, $cpage_id, $COMMUNITY_ID, $new_parent_id, $new_community_id, $proxy_id)
{
    $query = "\tSELECT *\n\t\t\t\tFROM " . DATABASE_NAME . ".`community_pages`\n\t\t\t\tWHERE `community_id` = " . $COMMUNITY_ID . "\n\t\t\t\tAND `parent_id` = " . $db->qstr($cpage_id) . "\n\t\t\t\tORDER BY cpage_id ASC";
    $community_pages_arr = $db->GetAll($query);
    if ($community_pages_arr) {
        //insert every child page.
        foreach ($community_pages_arr as $page) {
            $page["parent_id"] = $new_parent_id;
            $new_cpage_id = insert_community_page($db, $page, $new_community_id, $proxy_id);
            create_child_pages($db, $page["cpage_id"], $COMMUNITY_ID, $new_cpage_id, $new_community_id, $proxy_id);
        }
    }
}
Beispiel #2
0
 /**
  * See ADOConnection::GetAll()
  *
  * @access  public
  * @param   mixed
  * @return  mixed
  */
 public function _getAll($sql)
 {
     return $this->db->GetAll($sql);
 }