Like it to show.
Код:
forward OnMDCLookup(playerid, name[]);
public OnMDCLookup(playerid, name[]) {
new msg[128];
new rows,fields;
cache_get_data(rows,fields);
if(rows < 1) {
SendClientMessage(playerid, X11_TOMATO_2, "* MDC: No one on record found!");
return 1;
}
cache_get_row(0, 0, msg);
MDCLookup(playerid, strval(msg));
return 1;
}
MDCLookup(playerid, id) {
new msg[256];
format(msg, sizeof(msg), "SELECT `c1`.`username`,`c1`.`phonenumber`,`c1`.`sex`,`c1`.`id` FROM `characters` AS `c1` WHERE `c1`.`id` = %d",id);
mysql_function_query(g_mysql_handle, msg, true, "OnMDCRetrieve", "d",playerid);
}
forward OnMDCRetrieve(playerid);
public OnMDCRetrieve(playerid) {
new string[128],id_string[128];
new rows, fields;
cache_get_data(rows, fields);
if(rows < 1) return 0;
SendClientMessage(playerid, TEAM_BLUE_COLOR,"______-=MOBILE DATA COMPUTER=-_______");
cache_get_row(0, 0, id_string);
format(string, sizeof(string), "Name : %s", id_string);
SendClientMessage(playerid, X11_WHITE,string);
cache_get_row(0, 1, id_string);
format(string, sizeof(string), "Phone Number : %s", id_string);
SendClientMessage(playerid, X11_WHITE,string);
cache_get_row(0, 2, id_string);
format(string, sizeof(string), "Sex : %s", GetSexName(strval(id_string)));
SendClientMessage(playerid, X11_WHITE,string);
cache_get_row(0, 3, id_string);
new sqlid = strval(id_string);
sendCrimes(playerid, sqlid);
sendTickets(playerid, sqlid);
return 1;
}
forward OnCrimesRetrieve(playerid);
public OnCrimesRetrieve(playerid) {
new rows, fields;
new id_string[128];
new string[128];
cache_get_data(rows, fields);
SendClientMessage(playerid, TEAM_BLUE_COLOR,"______________ * Crimes * _______________");
if(rows > 0) {
for(new i=0;i<rows;i++) {
cache_get_row(i, 2, id_string);
if(!strcmp(id_string, "NULL", true)) {
format(string, sizeof(string), "* Issuer: %s",id_string);
SendClientMessage(playerid, X11_WHITE,string);
}
cache_get_row(i, 3, id_string);
format(string, sizeof(string), "* Reason: %s",id_string);
SendClientMessage(playerid, X11_WHITE,string);
cache_get_row(i, 4, id_string);
if(id_string[0] == '0') {
format(string, sizeof(string), "* Issued: %s",id_string);
SendClientMessage(playerid, X11_WHITE,string);
}
SendClientMessage(playerid, X11_WHITE,"*************************");
}
}
}
forward OnTicketsRetrieve(playerid);
public OnTicketsRetrieve(playerid) {
new rows, fields;
new id_string[128];
new string[128];
cache_get_data(rows, fields);
SendClientMessage(playerid, TEAM_BLUE_COLOR,"______________ * Tickets * _______________");
if(rows > 0) {
for(new i=0;i<rows;i++) {
cache_get_row(i, 2, id_string);
format(string, sizeof(string), "* Issuer: %s",id_string);
SendClientMessage(playerid, X11_WHITE,string);
cache_get_row(i, 3, id_string);
format(string, sizeof(string), "* Reason: %s",id_string);
SendClientMessage(playerid, X11_WHITE,string);
cache_get_row(i, 4, id_string);
format(string, sizeof(string), "* Issued: %s",id_string);
SendClientMessage(playerid, X11_WHITE,string);
SendClientMessage(playerid, X11_WHITE,"*************************");
}
}
}
sendCrimes(playerid, sqlid) {
format(query, sizeof(query), "SELECT `crimes`.`id`,`c1`.`username`,`c2`.`username`,`reason`,`issuetime` FROM `crimes` INNER JOIN `characters` AS `c1` ON `c1`.`id` = `suspect` LEFT JOIN `characters` AS `c2` ON `c2`.`id` = `issuer` WHERE `suspect` = %d",sqlid);
mysql_function_query(g_mysql_handle, query, true, "OnCrimesRetrieve", "d",playerid);
}
sendTickets(playerid, sqlid) {
format(query, sizeof(query), "SELECT `tickets`.`id`,`c1`.`username`,IFNULL(`c2`.`username`,\"Los Santos\"),`reason`,`issuetime` FROM `tickets` INNER JOIN `characters` AS `c1` ON `c1`.`id` = `owner` LEFT JOIN `characters` AS `c2` ON `c2`.`id` = `issuer` WHERE `owner` = %d",sqlid);
mysql_function_query(g_mysql_handle, query, true, "OnTicketsRetrieve", "d",playerid);
}
InsertCrime(target, playerid, crime[]) {
query[0] = 0;
new crime_esc[(64*2)+1];
mysql_real_escape_string(crime, crime_esc);
format(query, sizeof(query), "INSERT INTO `crimes` (`issuer`,`suspect`,`reason`) VALUES (%d, %d, \"%s\")",GetPVarInt(playerid, "CharID"), GetPVarInt(target, "CharID"),crime_esc);
mysql_function_query(g_mysql_handle, query, true, "EmptyCallback", "");
}
SendCrimeMessage(target, playerid, crime[]) {
new msg[128];
format(msg, sizeof(msg), "HQ: All Units APB: Reporter: %s",GetPlayerNameEx(playerid, ENameType_RPName_NoMask));
SendCopMessage(TEAM_BLUE_COLOR, msg);
format(msg, sizeof(msg), "HQ: Crime: %s, Suspect: %s",crime,GetPlayerNameEx(target, ENameType_RPName_NoMask));
SendCopMessage(TEAM_BLUE_COLOR, msg);
return 1;