Почему в базе данных не сохраняются данные?

Garthwaite · 5 Фев 2024

Почему в базе данных не сохраняются данные?
Вроде все указал, mysql.log и server.log ничего не выдает про это, база пустая после создания.

PHP:

case DIALOG_CREATE_PICKUP:
{
    if(!response) return true;
    new world, type, model, Float:x, Float:y, Float:z, pickupid, name[64];
    if(sscanf(inputtext, "p<,>iiis[64]", world, type, model, name)) return SPD(playerid, DIALOG_CREATE_PICKUP, DIALOG_STYLE_INPUT, "Äîáàâèòü ïèêàï", "Ââåäèòå ÷åðåç çàïÿòóþ:\n• Âèðòóàëüíûé ìèð\n• Òèï\n• Ìîäåëü\n• Ñòàòóñ\n• Îðãàíèçàöèþ\n• Èìÿ\n\nÏðèìåð: 0, 23, 1239, 0, 0, Âõîä â ìýðèþ", "ÎÊ", "Îòìåíà");
    TOTALPICKUP++;
    GetPlayerPos(playerid, x, y, z);
    pickupid = CreatePickupAC(model, type, x, y, z, world);
    CPickupInfo[pickupid][picPosX] = x;
    CPickupInfo[pickupid][picPosY] = y;
    CPickupInfo[pickupid][picPosZ] = z;
    CPickupInfo[pickupid][picWorld] = world;
    CPickupInfo[pickupid][picType] = type;
    CPickupInfo[pickupid][picModel] = model;
    mysql_format(connects, string, 512, "INSERT INTO "TABLE_PICKUP" (`x`, `y`, `z`, `world`, `type`, `model`, `name`) VALUES (%f, %f, %f, %i, %i, %i, '%s')",
    CPickupInfo[pickupid][picPosX], CPickupInfo[pickupid][picPosY], CPickupInfo[pickupid][picPosZ], CPickupInfo[pickupid][picWorld], CPickupInfo[pickupid][picType],
    CPickupInfo[pickupid][picModel], name);
    mysql_function_query(connects,string,true,"OnPlayerInsertBase","ddd",playerid, pickupid, 2);
    return true;
}

PHP:

case DIALOG_CREATE_MAPICON:
{
    if(!response) return true;
    new model, world, interior, player, Float:distance, Float:x, Float:y, Float:z, mapiconid, name[64];
    if(sscanf(inputtext, "p<,>iiiifs[64]", model, world, interior, player, Float:distance, name)) return SPD(playerid, DIALOG_CREATE_MAPICON, DIALOG_STYLE_INPUT, "Add Mapicon", "Ââåäèòå ÷åðåç çàïÿòóþ:\n• id ìîäåëè\n• Âèðòóàëüíûé ìèð\n• Èíòåðüåð\n• playerid\n• Äèñòàíöèþ\n• Íàçâàíèå\n\nÏðèìåð: 10, -1, -1, -1, 200, LSPD", "ÎÊ", "Îòìåíà");
    if(model < 0 || model > 63) return SPD(playerid, DIALOG_CREATE_MAPICON,DIALOG_STYLE_INPUT, "Add Mapicon", "Ââåäèòå ÷åðåç çàïÿòóþ:\n• id ìîäåëè\n• Âèðòóàëüíûé ìèð\n• Èíòåðüåð\n• playerid\n• Äèñòàíöèþ\n• Íàçâàíèå\n\nÏðèìåð: 10, -1, -1, -1, 200, LSPD", "ÎÊ", "Îòìåíà");
    TOTALMAPICON++;
    GetPlayerPos(playerid, x, y, z);
    mapiconid = CreateDynamicMapIcon(x, y, z, model, 0, world, interior, player, distance);
    MapiconInfo[mapiconid][mPosX] = x;
    MapiconInfo[mapiconid][mPosY] = y;
    MapiconInfo[mapiconid][mPosZ] = z;
    MapiconInfo[mapiconid][mModel] = model;
    MapiconInfo[mapiconid][mWorld] = world;
    MapiconInfo[mapiconid][mInterior] = interior;
    MapiconInfo[mapiconid][mPlayer] = player;
    MapiconInfo[mapiconid][mDistance] = distance;
    mysql_format(connects,string,sizeof(string),"INSERT INTO `log_mapicon` (`x`,`y`,`z`,`world`,`interior`,`model`,`playerid`,`radius`,`name`) VALUES ('%f','%f','%f','%i','%i','%i','%i','%f','%s')", MapiconInfo[mapiconid][mPosX], MapiconInfo[mapiconid][mPosY], MapiconInfo[mapiconid][mPosZ], MapiconInfo[mapiconid][mWorld],
     MapiconInfo[mapiconid][mInterior], MapiconInfo[mapiconid][mModel], MapiconInfo[mapiconid][mPlayer], MapiconInfo[mapiconid][mDistance], name);
    mysql_function_query(connects, string, false, "","");
    format(string, 120, "Mapicon %d: ìîäåëü %i, Ìèð %i, Èíò %i, èãðîê %i, ðàäèóñ %f !", TOTALMAPICON, model, world, interior, player, distance);
    SCM(playerid, -1, string);
}

Чтобы видеть скрытое содержание Зарегистрируйтесь на форуме!

Почему в базе данных не сохраняются данные?

Garthwaite

Новичок