- Регистрация
- 2 Май 2019
- Сообщения
- 35
- Лучшие ответы
- 0
- Репутация
- 0
Ошибка: 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 ''clans'' at line 1
Паблик: LoadClans
Запрос : SELECT * FROM 'clans'
|||||||||||||||||||||||||||||||
Запрос: mysql_tquery(1, "SELECT * FROM 'clans'", "LoadClans", "");
Сам паблик
PB:LoadClans()
{
new rows,fiel;
cache_get_data(rows,fiel);
if(rows)
{
new string[90];
for(new i = 0; i < rows; i++)
{
Clan[clId] = cache_get_field_content_int(i, "id");
Clan[clCreateTime] = cache_get_field_content_int(i, "create_time");
Clan[clCreateAdmin] = cache_get_field_content_int(i, "create_admin");
cache_get_field_content(i, "name", Clan[Clans][clName]);
Clan[clX] = cache_get_field_content_float(i, "x");
Clan[clY] = cache_get_field_content_float(i, "y");
Clan[clZ] = cache_get_field_content_float(i, "z");
Clan[clA] = cache_get_field_content_float(i, "a");
Clan[clStatus] = cache_get_field_content_int(i, "status");
Clan[clPrice] = cache_get_field_content_int(i, "price");
Clan[clOwner] = cache_get_field_content_int(i, "owner");
if(Clan[clStatus] == 0)
{
Clan[clArea] = CreateDynamicSphere(Clan[clX], Clan[clZ], Clan[clA], 1.2);
Clan[clPickup] = CreateDynamicPickup(1314, 23, Clan[clX], Clan[clZ], Clan[clA]);
format(string, sizeof string, "%s\nЧтобы купить /buyclan\nЦена: %d", Clan[Clans][clName], Clan[clPrice]);
Clan[clLabel] = CreateDynamic3DTextLabel(string, 0xA41C1CFF, Clan[clX], Clan[clZ], Clan[clA], 20.0);
}
}
Clans = rows;
}
return 1;
}
Паблик: LoadClans
Запрос : SELECT * FROM 'clans'
|||||||||||||||||||||||||||||||
Запрос: mysql_tquery(1, "SELECT * FROM 'clans'", "LoadClans", "");
Сам паблик
PB:LoadClans()
{
new rows,fiel;
cache_get_data(rows,fiel);
if(rows)
{
new string[90];
for(new i = 0; i < rows; i++)
{
Clan[clId] = cache_get_field_content_int(i, "id");
Clan[clCreateTime] = cache_get_field_content_int(i, "create_time");
Clan[clCreateAdmin] = cache_get_field_content_int(i, "create_admin");
cache_get_field_content(i, "name", Clan[Clans][clName]);
Clan[clX] = cache_get_field_content_float(i, "x");
Clan[clY] = cache_get_field_content_float(i, "y");
Clan[clZ] = cache_get_field_content_float(i, "z");
Clan[clA] = cache_get_field_content_float(i, "a");
Clan[clStatus] = cache_get_field_content_int(i, "status");
Clan[clPrice] = cache_get_field_content_int(i, "price");
Clan[clOwner] = cache_get_field_content_int(i, "owner");
if(Clan[clStatus] == 0)
{
Clan[clArea] = CreateDynamicSphere(Clan[clX], Clan[clZ], Clan[clA], 1.2);
Clan[clPickup] = CreateDynamicPickup(1314, 23, Clan[clX], Clan[clZ], Clan[clA]);
format(string, sizeof string, "%s\nЧтобы купить /buyclan\nЦена: %d", Clan[Clans][clName], Clan[clPrice]);
Clan[clLabel] = CreateDynamic3DTextLabel(string, 0xA41C1CFF, Clan[clX], Clan[clZ], Clan[clA], 20.0);
}
}
Clans = rows;
}
return 1;
}