Sarah
21.07.2019, 21:21
Всем привет, захотел узнать, лучше будет загружать данные вот так:
mysql_function_query(mysql_connect_id, "SELECT * FROM `kydato`", "@_LoadFrac");
@_LoadFrac();
@_LoadFrac() {
new fields;
cache_get_data(TOTALFRAC, fields);
for(new i, id; i < TOTALFRAC; i++) {
id = cache_get_field_content_int(i, "ID", mysqlc);
cache_get_field_content(i, "Name", Frac[id][fName], mysqlc, 32);
cache_get_field_content(i, "Leader", Frac[id][fLeader], mysqlc, 32);
cache_get_field_content(i, "Assistant", Frac[id][fAssistant], mysqlc, 32);
}
printf("%d - uploaded fractions", TOTALFRAC);
return true;
}
Или так:
cache = mysql_query(1, "SELECT * FROM `fraction`"), rows = cache_num_rows();
if(rows) {
TOTALFRAC = rows;
new str[213+MAX_PLAYER_NAME+11+7];
for(new i, id; i < TOTALFRAC; i++) {
id = cache_get_field_content_int(i, "f_id", 1);
cache_get_field_content(i, "f_name", FracInfo[id][fName], 1, 32);
cache_get_field_content(i, "f_leader", FracInfo[id][fLeader], 1, 32);
cache_get_field_content(i, "f_assistant", FracInfo[id][fAssistant], 1, 32);
}
printf("-> FRACTION | %d - uploaded.", TOTALFRAC);
}
else print("-> FRACTION | not uploaded.");
cache_delete(cache);
mysql_function_query(mysql_connect_id, "SELECT * FROM `kydato`", "@_LoadFrac");
@_LoadFrac();
@_LoadFrac() {
new fields;
cache_get_data(TOTALFRAC, fields);
for(new i, id; i < TOTALFRAC; i++) {
id = cache_get_field_content_int(i, "ID", mysqlc);
cache_get_field_content(i, "Name", Frac[id][fName], mysqlc, 32);
cache_get_field_content(i, "Leader", Frac[id][fLeader], mysqlc, 32);
cache_get_field_content(i, "Assistant", Frac[id][fAssistant], mysqlc, 32);
}
printf("%d - uploaded fractions", TOTALFRAC);
return true;
}
Или так:
cache = mysql_query(1, "SELECT * FROM `fraction`"), rows = cache_num_rows();
if(rows) {
TOTALFRAC = rows;
new str[213+MAX_PLAYER_NAME+11+7];
for(new i, id; i < TOTALFRAC; i++) {
id = cache_get_field_content_int(i, "f_id", 1);
cache_get_field_content(i, "f_name", FracInfo[id][fName], 1, 32);
cache_get_field_content(i, "f_leader", FracInfo[id][fLeader], 1, 32);
cache_get_field_content(i, "f_assistant", FracInfo[id][fAssistant], 1, 32);
}
printf("-> FRACTION | %d - uploaded.", TOTALFRAC);
}
else print("-> FRACTION | not uploaded.");
cache_delete(cache);