25.03.2010, 11:26
Подскажите, правильно ли я делаю запросы?
Код:
//---------------------------------------------------------------------------------------------
stock gs_IsUserRegistered(nick[])
{
new query[256],result[256],rr;
if(mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATABASE,MySQL_PASS))
{
format(query,sizeof(query), "SELECT * FROM \"Users\" WHERE `Username` = '%s'",nick);
mysql_query(query);
mysql_store_result();
if(!mysql_fetch_row(result)) { rr = 0; }else { rr = 1; }
}else{
printf("Function gs_IsUserRegistered(%s) can't be called. Reason: Connection Problem",nick);
rr = 2;
}
return rr;
}
//---------------------------------------------------------------------------------------------
stock gs_RegisterNewUser(nick[],password[])
{
new query[256],rr;
if(mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATABASE,MySQL_PASS))
{
format(query,sizeof(query), "INSERT INTO \"Users\" (Username, Password) VALUES ('%s', '%s')", nick,password);
mysql_query(query);
rr = 1;
}else{
printf("Function RegisterNewUser(%s,%s) can't be called. Reason: Connection Problem",nick,password);
rr = 2;
}
return rr;
}
//---------------------------------------------------------------------------------------------
stock gs_CheckNickNamePassword(nick[],password[])
{
new query[256],result[256],rr;
if(mysql_connect(MySQL_HOST,MySQL_USER,MySQL_DATABASE,MySQL_PASS))
{
format(query,sizeof(query), "SELECT * FROM \"Users\" WHERE `Username` = '%s' AND `Password` = '%s'",nick,password);
mysql_query(query);
mysql_store_result();
if(mysql_fetch_row(result)) { rr = 1; } else { rr = 0; }
}else{
printf("Function gs_CheckNickNamePassword(%s,%s) can't be called. Reason: Connection Problem",nick,password);
rr = 2;
}
return rr;
}
//---------------------------------------------------------------------------------------------

