13.06.2012, 18:22
Can someone help me converting this:
to a normal text file that i use for my saving?
Tell me if you need more codes, because I have no idea how to convert mysql
pawn Код:
stock CheckUser(playerid)
{
new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows()) return 1;
return 0;
}
stock LoadPlayerInfo(playerid)
{
new Query[100]; format(Query, sizeof(Query), "SELECT * FROM users WHERE username = '%s';", GetPlayerNameEx(playerid));
mysql_query(Query);
mysql_store_result();
mysql_fetch_row(Query, "|");
sscanf(Query, "p<|>e<is[25]i>", PlayerInfo[playerid]);
}
stock CheckGangByName(Name[])
{
new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE name = '%s';", Name);
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows()) return 1;
return 0;
}
stock CheckGangById(GangID)
{
new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID;
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows()) return 1;
return 0;
}
stock ResetPlayerInfo(playerid)
{
Invite[playerid] = 0;
PlayerInfo[playerid][Gang] = 0;
}
stock InitMysqlConnection()
{
mysql_init();
mysql_connect(DB_HOST, DB_USER, DB_PASS, DB_DB);
mysql_query(CREATE_DB_USERS);
mysql_query(CREATE_DB_GANGS);
}
stock IsPlayerGangLeader(playerid)
{
new Query[100]; format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d AND owner = '%s';", PlayerInfo[playerid][Gang], GetPlayerNameEx(playerid));
mysql_query(Query);
mysql_store_result();
if(mysql_num_rows()) return 1;
return 0;
}
stock IsMySelf(pID, oID)
{
if(pID == oID) return 1;
return 0;
}
stock GetGangName(GangID)
{
new gName[100], Query[150]; format(Query, sizeof(Query), "SELECT name FROM gangs WHERE id = %d;", GangID);
mysql_query(Query);
mysql_store_result();
mysql_fetch_string(gName);
return gName;
}
stock GetGangMemberCount(gID)
{
new Query[150]; format(Query, sizeof(Query), "SELECT * FROM users WHERE gang = %d;", gID);
mysql_query(Query);
mysql_store_result();
return mysql_num_rows();
}
stock GetGangCount()
{
new Query[150]; format(Query, sizeof(Query), "SELECT * FROM gangs;");
mysql_query(Query);
mysql_store_result();
return mysql_num_rows();
}
stock ShowGangInfoForPlayer(GangID, pID)
{
new tGid, tGname[100], tGOwner[25], Query[150], string[200];
format(Query, sizeof(Query), "SELECT * FROM gangs WHERE id = %d;", GangID);
mysql_query(Query);
mysql_store_result();
if(!mysql_num_rows()) return 0;
mysql_fetch_row(Query, "|");
sscanf(Query, "p<|>is[100]s[25]", tGid, tGname, tGOwner);
format(string, sizeof(string), "Id: %d - Name: %s - Owner: %s - Members: %d", tGid, tGname, tGOwner, GetGangMemberCount(GangID));
return ShowPlayerDialog(pID, DIALOG_GANG_INFO, DIALOG_STYLE_MSGBOX, "Gang info", string, "Cancel", "");
}
stock GetPlayerNameEx(playerid)
{
new pName[25];
GetPlayerName(playerid, pName, 25);
return pName;
}
stock strmatch(const String1[], const String2[])
{
if ((strcmp(String1, String2, true, strlen(String2)) == 0) && (strlen(String2) == strlen(String1))) return true;
else return false;
}
Tell me if you need more codes, because I have no idea how to convert mysql