17.08.2012, 14:17
This is my code to retrieve data from the sqllite database
Is this good at this way or this is a way to simplify this in lesser steps
pawn Код:
stock ret_cDATA(playerid)//I USE THIS TO RETRIEVE THE DATA
{
ret1(playerid);
ret2(playerid);
ret3(playerid);
ret4(playerid);
ret5(playerid);
return 1;
}
stock ret1(playerid)
{
new
Query[ 384 ],
DBResult: Result,
pName[ MAX_PLAYER_NAME ],
Field[ 50 ]
;
GetPlayerName(playerid, pName, sizeof(pName));
format(Query, sizeof(Query), "SELECT * FROM `Accounts` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(pName));
Result = db_query(DATABASE, Query);
if(db_num_rows(Result))
{
db_get_field_assoc(Result, "rSTEP", Field, 30);
pInfo[playerid][prSTEP] = strval(Field);
db_get_field_assoc(Result, "SQ", Field, 50);
pInfo[playerid][pSQ] = strval(Field);
db_get_field_assoc(Result, "SA", Field, 50);
pInfo[playerid][pSA] = strval(Field);
db_get_field_assoc(Result, "IP", Field, 30);
pInfo[playerid][pIP] = strval(Field);
db_get_field_assoc(Result, "REGISTRATIONDATE", Field, 30);
pInfo[playerid][pRDATE] = strval(Field);
db_get_field_assoc(Result, "VIPLEVEL", Field, 30);
pInfo[playerid][pVIPLVL] = strval(Field);
db_get_field_assoc(Result, "ADMINLEVEL", Field, 30);
pInfo[playerid][pADMINLVL] = strval(Field);
}
return 1;
}
stock ret2(playerid)
{
new
Query[ 384 ],
DBResult: Result,
pName[ MAX_PLAYER_NAME ],
Field[ 50 ]
;
GetPlayerName(playerid, pName, sizeof(pName));
format(Query, sizeof(Query), "SELECT * FROM `PersonalInfo` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(pName));
Result = db_query(DATABASE, Query);
if(db_num_rows(Result))
{
db_get_field_assoc(Result, "PLAYERRANK", Field, 30);
pInfo[playerid][pPLAYERRANK] = strval(Field);
db_get_field_assoc(Result, "WANTEDLEVEL", Field, 30);
pInfo[playerid][pWANTEDLVL] = strval(Field);
db_get_field_assoc(Result, "CASH", Field, 30);
pInfo[playerid][pMONEY] = strval(Field);
db_get_field_assoc(Result, "KILLS", Field, 30);
pInfo[playerid][pKILLS] = strval(Field);
db_get_field_assoc(Result, "DEATHS", Field, 30);
pInfo[playerid][pDEATHS] = strval(Field);
db_get_field_assoc(Result, "X", Field, 30);
pInfo[playerid][pX] = strval(Field);
db_get_field_assoc(Result, "Y", Field, 30);
pInfo[playerid][pY] = strval(Field);
db_get_field_assoc(Result, "Z", Field, 30);
pInfo[playerid][pZ] = strval(Field);
db_get_field_assoc(Result, "INTERIOR", Field, 30);
pInfo[playerid][pINTERIOR] = strval(Field);
db_get_field_assoc(Result, "WORLD", Field, 30);
pInfo[playerid][pWORLD] = strval(Field);
db_get_field_assoc(Result, "HEALTH", Field, 30);
pInfo[playerid][pHEALTH] = strval(Field);
db_get_field_assoc(Result, "ARMOR", Field, 30);
pInfo[playerid][pARMOR] = strval(Field);
db_get_field_assoc(Result, "SKIN", Field, 30);
pInfo[playerid][pSKIN] = strval(Field);
}
return 1;
}
stock ret3(playerid)
{
new
Query[ 384 ],
DBResult: Result,
pName[ MAX_PLAYER_NAME ],
Field[ 50 ]
;
GetPlayerName(playerid, pName, sizeof(pName));
format(Query, sizeof(Query), "SELECT * FROM `WeaponInfo` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(pName));
Result = db_query(DATABASE, Query);
if(db_num_rows(Result))
{
db_get_field_assoc(Result, "WEAP1", Field, 30);
pInfo[playerid][pWEAP1] = strval(Field);
db_get_field_assoc(Result, "WEAP1A", Field, 30);
pInfo[playerid][pWEAP1A] = strval(Field);
db_get_field_assoc(Result, "WEAP2", Field, 30);
pInfo[playerid][pWEAP2] = strval(Field);
db_get_field_assoc(Result, "WEAP2A", Field, 30);
pInfo[playerid][pWEAP2A] = strval(Field);
db_get_field_assoc(Result, "WEAP3", Field, 30);
pInfo[playerid][pWEAP3] = strval(Field);
db_get_field_assoc(Result, "WEAP3A", Field, 30);
pInfo[playerid][pWEAP3A] = strval(Field);
db_get_field_assoc(Result, "WEAP4", Field, 30);
pInfo[playerid][pWEAP4] = strval(Field);
db_get_field_assoc(Result, "WEAP4A", Field, 30);
pInfo[playerid][pWEAP4A] = strval(Field);
db_get_field_assoc(Result, "WEAP5", Field, 30);
pInfo[playerid][pWEAP5] = strval(Field);
db_get_field_assoc(Result, "WEAP5A", Field, 30);
pInfo[playerid][pWEAP5A] = strval(Field);
db_get_field_assoc(Result, "WEAP6", Field, 30);
pInfo[playerid][pWEAP6] = strval(Field);
db_get_field_assoc(Result, "WEAP6A", Field, 30);
pInfo[playerid][pWEAP6A] = strval(Field);
}
return 1;
}
stock ret4(playerid)
{
new
Query[ 384 ],
DBResult: Result,
pName[ MAX_PLAYER_NAME ],
Field[ 50 ]
;
GetPlayerName(playerid, pName, sizeof(pName));
format(Query, sizeof(Query), "SELECT * FROM `VehicleInfo` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(pName));
Result = db_query(DATABASE, Query);
if(db_num_rows(Result))
{
db_get_field_assoc(Result, "VEHI1", Field, 30);
pInfo[playerid][pVEHI1] = strval(Field);
db_get_field_assoc(Result, "VEHI2", Field, 30);
pInfo[playerid][pVEHI2] = strval(Field);
db_get_field_assoc(Result, "VEHI3", Field, 30);
pInfo[playerid][pVEHI3] = strval(Field);
db_get_field_assoc(Result, "VEHI4", Field, 30);
pInfo[playerid][pVEHI4] = strval(Field);
db_get_field_assoc(Result, "VEHI5", Field, 30);
pInfo[playerid][pVEHI5] = strval(Field);
}
return 1;
}
stock ret5(playerid)
{
new
Query[ 384 ],
DBResult: Result,
pName[ MAX_PLAYER_NAME ],
Field[ 50 ]
;
GetPlayerName(playerid, pName, sizeof(pName));
format(Query, sizeof(Query), "SELECT * FROM `Misc` WHERE `NAME` = '%s' COLLATE NOCASE", DB_Escape(pName));
Result = db_query(DATABASE, Query);
if(db_num_rows(Result))
{
db_get_field_assoc(Result, "JAILED", Field, 30);
pInfo[playerid][pJAILED] = strval(Field);
db_get_field_assoc(Result, "JAILEDTIME", Field, 30);
pInfo[playerid][pJAILTIME] = strval(Field);
db_get_field_assoc(Result, "WARNINGS", Field, 30);
pInfo[playerid][pWARNINGS] = strval(Field);
db_get_field_assoc(Result, "MUTED", Field, 30);
pInfo[playerid][pMUTED] = strval(Field);
db_get_field_assoc(Result, "COLOR", Field, 30);
pInfo[playerid][pCOLOR] = strval(Field);
}
return 1;
}