MySQL based on Linux by C

int LoginJudge(USER_ACCOUNT req){

     int i=0;  char *name;  char *reqname;   char *password;  char *reqpass;   reqname=req.Name;  reqpass=req.Password;

  if(!(mysql_connect(&mysql,NULL,"root","1111")))   return FALSE;  if(mysql_select_db(&mysql,"serverdb"))   return FALSE;  if (mysql_query(&mysql,"select name,password from main" ))   return FALSE;  if(!(res=mysql_store_result(&mysql)))   return FALSE;  while((row=mysql_fetch_row(res)))   {      name=row[0];    password=row[1];    if (!strcmp(name,reqname))     {      if(!strcmp(password,reqpass))      return TRUE;      else      return FALSE;     }   }  if(! mysql_eof(res))  return FALSE;  mysql_free_result(res);  mysql_close(&mysql);  return FALSE;}

int authority(char *name){ long iBackValue; char *cDBname; char *cDBauthority; char *cQuename; char *cValueOne; char *cValueTwo;

 cQuename=name; cValueOne="1"; cValueTwo="2"; if(!(mysql_connect(&mysql,NULL,"root","1111")))  return FALSE; if(mysql_select_db(&mysql,"serverdb"))  return FALSE; if (mysql_query(&mysql,"select name,authority from main" ))  return FALSE; if(!(res=mysql_store_result(&mysql)))  return FALSE; while((row=mysql_fetch_row(res)))  {     cDBname=row[0];   cDBauthority=row[1];   if (!strcmp(cDBname,cQuename))    {     if(!strcmp(cValueOne,cDBauthority))      {       iBackValue=1;       if(!strcmp(cValueTwo,cDBauthority))       iBackValue=2;      }     else      iBackValue=3;          }  }

  if(! mysql_eof(res))  return FALSE;  mysql_free_result(res);  mysql_close(&mysql);  return iBackValue;}