Ray_Grand
Умник
Переводил систему IRC каналов на MySQL R8, и столкнулся с проблемой, при обновлении выходит ошибка, и при запуске мода, не загружает 2 переменные.
mysql_log
server_log
Сохранение/загрузка
Ещё проблема с двумя переменными, при запуске мода не загружает iNedPass, iLock. А сами каналы загружаются.
mysql_log
PHP:
[DEBUG] ProcessQueryThread() - Executing query UPDATE `irc` SET `iAdmin` = 'Ray_Grand', `iMOTD` = 'alalala', `iPassword` = 'lal2', `iNeedPass` = '1', `iLock` = '0', ...
[ERROR] ProcessQueryThread() - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1 (error ID: 1064)
[DEBUG] ProcessQueryThread() - Error will be triggered to OnQueryError().
PHP:
Error: 1064:You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 1
PHP:
public LoadIRC()
{
new rows, fields;
cache_get_data(rows, fields);
if(rows > 0)
{
for(new i = 0; i < rows; i++)
{
cache_get_field_content(i,"iAdmin",IRCInfo[i][iAdmin],dbHandle,128);
cache_get_field_content(i,"iMOTD",IRCInfo[i][iMOTD],dbHandle,128);
cache_get_field_content(i,"iPassword",IRCInfo[i][iPassword],dbHandle,128);
IRCInfo[i][iNeedPass] = cache_get_row_int(i, 5);
IRCInfo[i][iLock] = cache_get_row_int(i, 5);
printf("IRC:%d Admin:%s MOTD: %s Password: %s NeedPass: %d Lock: %d",i,IRCInfo[i][iAdmin],IRCInfo[i][iMOTD],IRCInfo[i][iPassword],IRCInfo[i][iNeedPass],IRCInfo[i][iLock]);
TOTAL_IRC++;
}
}
printf("Загружено irc каналов: %d", TOTAL_IRC);
return true;
}
public SaveIRC()
{
for(new i=0; i<MAX_IRC; i++)
{
new string[400],query[2350];
format(string,sizeof(string),"UPDATE `irc` SET "),strcat(query,string);
format(string,sizeof(string),"`iAdmin` = '%s', ",IRCInfo[i][iAdmin]),strcat(query,string);
format(string,sizeof(string),"`iMOTD` = '%s', ",IRCInfo[i][iMOTD]),strcat(query,string);
format(string,sizeof(string),"`iPassword` = '%s', ",IRCInfo[i][iPassword]),strcat(query,string);
format(string,sizeof(string),"`iNeedPass` = '%d', ",IRCInfo[i][iNeedPass]),strcat(query,string);
format(string,sizeof(string),"`iLock` = '%d', ",IRCInfo[i][iLock]),strcat(query,string);
mysql_function_query(dbHandle,query,false,"","");
}
return 1;
}
