19.03.2012, 11:04
Quote:
|
Originally Posted by s0up
 зачем тут format в запросах?
Code:
stock LoadNews()
{
mysql_query("SELECT date, title FROM news ORDER BY id DESC LIMIT 0, 10");
mysql_store_result();
NewsStartText[0] = EOS;
if (mysql_num_rows() != 0)
{
new Field[2048], i;
while (mysql_fetch_row_format(Field))
{
sscanf(Field,"p<|>s[24]s[128]", NewsInfo[i][newsDate], NewsInfo[i][newsTitle]);
format(NewsStartText, sizeof(NewsStartText), "%s{8D8DFF}%s|{FFFFFF}%s\n", NewsStartText, NewsInfo[i][newsDate], NewsInfo[i][newsTitle]);
i++;
}
mysql_free_result();
mysql_query("SELECT newstext FROM news ORDER BY id DESC LIMIT 0, 10");
mysql_store_result();
i = 0;
while (mysql_fetch_row_format(NewsInfo[i++][newsText])){}
}
else format(NewsStartText,sizeof(NewsStartText), "Новостей нет.");
return 1;
}
|
