little-e

#include <stdio.h>
#include <stdlib.h>
#include <string.h>
#include <sys/types.h>
#include <sys/stat.h>
#include <pwd.h>
#include <unistd.h>
#include <fcntl.h>
#include <grp.h>

 /* gcc hello.c -o hello -I/usr/include/mysql/ -std=gnu99 -lmysqlclient */
 /* Simple C program that connects to MySQL Database server*/
#include <mysql.h>
#include <stdio.h>
int main() {
   MYSQL *conn;
   MYSQL_RES *res;
   MYSQL_ROW row;
   char *server = "localhost";
    char *user = "root";
   char *password = "bleh";
   char *database = "oxwall";
   conn = mysql_init(NULL);

   FILE *pfd = popen( "wc -l /usr/local/sbin/memcached-1.4.22/lines | gawk '{print $1}'", "r" );
const size_t BUFSZ = 1024;
char *buf = malloc( BUFSZ );
size_t bufPos = 0;
while (1)
 {
  bufPos += fread( buf+bufPos, 1, BUFSZ, pfd );
  if ( !feof(pfd) )
   {
    buf = realloc( buf, bufPos + BUFSZ );
   }
    else
    {
    break;
   }
}
pclose( pfd );
free( buf );

int exsdeaewzs;
exsdeaewzs = atoi(buf);

   /* Connect to database */
   if (!mysql_real_connect(conn, server,
         user, password, database, 0, NULL, 0)) {
      fprintf(stderr, "%s\n", mysql_error(conn));
      exit(1);
   }

   char* wzarsa = "SELECT zcdafxe FROM xtwarxzws ORDER BY id DESC LIMIT 1";

   mysql_query(conn, wzarsa);

   res = mysql_use_result(conn);

   while ((row = mysql_fetch_row(res)) != NULL)
      printf("%s \n", row[0]);

   char* sql = malloc(100);
   char append[256];

   /* sql = "INSERT INTO xtwarxzws VALUES('zcdafxe', 671)"; */

   strcpy(sql, "INSERT INTO xtwarxzws VALUES('zcdafxe', ");
   sprintf(append,"%d",exsdeaewzs);
   strcat(sql, append);
   strcat(sql, "\x29");

   if (mysql_query(conn, sql)) {
      fprintf(stderr, "%s\n", mysql_error(conn));
      exit(1);
   }

   mysql_free_result(res);
   mysql_close(conn);




}