Forum Replies Created

Viewing 5 replies - 1 through 5 (of 5 total)
  • Forum: Hacks
    In reply to: API issue
    Thread Starter sgilleland1

    (@sgilleland1)

    Sorry, it I wasn’t clear….the 404 is the problem I am trying to figure out.

    If it is any help, here is the api code

    <?php
    ob_start();
    require_once(“database.php”);
    require_once(“../wp-blog-header.php”);
    $dbconnnection = new DB();
    $dbconnnection->fun_db_connect();

    $start =$_REQUEST[‘start’];
    $category =$_REQUEST[‘category’];

    if(!isset($category) OR trim($category)==””) {
    $record = ‘Category name required’;
    $dbconnnection->sendResponse(‘3’,$record);
    exit;
    }
    $idObj = get_category_by_slug($category);

    if(trim($idObj->slug)==””) {
    $record = ‘Category not found’;
    $dbconnnection->sendResponse(‘3’,$record);
    exit;
    }

    if(trim($start)==””) {
    $start=0;
    }

    $query = “SELECT * FROM wp_posts p
    LEFT OUTER JOIN wp_term_relationships r ON r.object_id = p.ID
    LEFT OUTER JOIN wp_term_taxonomy x ON x.term_taxonomy_id = r.term_taxonomy_id
    LEFT OUTER JOIN wp_terms t ON t.term_id = x.term_id
    WHERE p.post_status = ‘publish’
    AND p.post_type = ‘post’
    AND t.slug = ‘”.$idObj->slug.”‘ limit $start,20″;
    $res = mysql_query($query);
    $rows=mysql_num_rows($res);

    if($rows >0) {
    $post=””;
    $data=””;
    while($data=mysql_fetch_assoc($res)){
    $meta_values_video = get_post_meta( $data[‘ID’], ‘_my_meta_value_key’, true );
    $meta_values_video_thumbnail = get_post_meta( $data[‘ID’], ‘_video_thumbnail’, true );
    $meta_post_thumbnail=wp_get_attachment_image_src( get_post_thumbnail_id( $data[‘ID’] ), ‘single-post-thumbnail’ );

    $data[‘video_url’]=$meta_values_video;
    $data[‘video_thumbnail’]=$meta_values_video_thumbnail;
    $data[‘post_thumbnail’]=$meta_post_thumbnail[0];
    //$data[‘post_thumbnail’]=$meta_post_thumbnail[0];
    $data[‘post_content’]=htmlentities($data[‘post_content’]);

    $post[]=$data;
    }

    $dbconnnection->sendResponse(‘3’,$post);
    exit;

    } else {

    $record = ‘Post not found’;
    $dbconnnection->sendResponse(‘3’,$record);

    exit;

    }
    ?>

    Forum: Hacks
    In reply to: API issue
    Thread Starter sgilleland1

    (@sgilleland1)

    Yes, this is an API that was written for WordPress and this is the result when it is ran.

    Thread Starter sgilleland1

    (@sgilleland1)

    Fantastic…that is the answer I was looking for.

    Again sorry for the classified posting…I thought maybe the developer of this would possibly do development for a living and be possibly looking for business.

    Thank you again for your quick responses!

    Thread Starter sgilleland1

    (@sgilleland1)

    Sorry it doesn’t….So here is what I am trying to accomplish…

    I have a WP site full of training videos…we have eMember (membership plugin) that currently allows access to premium content. eMember is connected to eStore (plugin) that allows for payment of membership.

    I am creating an iOS app and the developer needs to access the WP eMember for the login credentials of the app.

    I was hoping that this was something that a WP developer could start with as a foundation to begin that bridge.

    I just want to be able to somewhat know what to expect from a developer…I don’t want them to build something from scratch for my solution if your plugin is a good starting point.

    Again, thank you.

    Thread Starter sgilleland1

    (@sgilleland1)

    No problem….sorry. I didn’t know whether this plugin would get me in the right direction as far as being able to connect to the third party plugins (eMember and eStore). I have submitted to a freelance website and was hoping this plugin would give us a head start….can you help me on that question?

    Thanks
    Skip

Viewing 5 replies - 1 through 5 (of 5 total)