if(mysql_ping(conn->mysqlconn))

    fprintf(stderr, "MySQL Connection _was_ broken or may be broken, I'm not sure exactly what this return value means\n");

  if (mysql_query(conn->mysqlconn, query))

     fprintf(stderr, "%s\n", mysql_error(conn->mysqlconn));

  result = mysql_use_result(conn->mysqlconn);

  distrenresult = malloc(sizeof(struct distrend_mysql_result));

  if(!distrenresult)

    {

      mysql_free_result(result);

      return NULL;

    }

  distrenresult->mysqlresult = result;

  distrenresult->pointlesscheck = FORTY_TWO;

  return distrenresult;

}

int mysqlResultFree(distrend_mysql_result_t result)

{

  if(!result)

    return 0;

  if(result->pointlesscheck != FORTY_TWO)

    fprintf(stderr, "%s:%d: I didn't get the type of handle I wanted\n", __FILE__, __LINE__);

  mysql_free_result(result->mysqlresult);

  free(result);

  return 0;

}

/*

   Individual query functions:

 */

void finish_frame(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum)

{

  char *query;

  distrend_mysql_result_t result;

  _distren_asprintf(&query, "CALL `distren`.`Frame_Complete`(%d,%d,%d);", slavekey, jobkey, framenum);

  result = mysqlQuery(conn, query);

  free(query);

  mysqlResultFree(result);

}

void start_frame(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum)

{

  char *query;

  distrend_mysql_result_t result;

  _distren_asprintf(&query, "CALL `distren`.`Frame_Start`(%d,%d,%d);", slavekey, jobkey, framenum);

  result = mysqlQuery(conn, query);

  free(query);

  mysqlResultFree(result);

}

int change_job_priority(distrend_mysql_conn_t conn, int32_t jobkey, int32_t newpriority)

{

  char *query;

  distrend_mysql_result_t result;

  _distren_asprintf(&query, "UPDATE `distren`.`Job` SET `Priority`=%d WHERE `Job_Key`=%d",

		    newpriority, jobkey);

  result = mysqlQuery(conn, query);

  mysqlResultFree(result);

  return 0;

}

int find_jobframe(distrend_mysql_conn_t conn, int32_t slavekey, int32_t jobkey, int32_t framenum)

{

  distrend_mysql_result_t result;

  char *query;

  MYSQL_ROW row;

  _distren_asprintf(&query, "CALL `distren`.`Frame_Get`(%d);", slavekey);

  result = mysqlQuery(conn, query);

  free(query);

  if(!result)

    return 1;

  row = mysql_fetch_row(result->mysqlresult);

  if(!row)

    return 1;

  mysqlResultFree(result);

  return 0;

}