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;
}