Сообщение от
Tracker1
Выведи запрос, который получается, перед посылкой в базу.
Алсо. strcat не самый удачный вариант. Используй русифицированный компилятор: там можно константные строки любой длинны указывать.
PHP код:
public OnHouseSave(houseid)
{
new strall[1024],strc[1024];
strcat(strall, "UPDATE `"Houses"` SET `hOwned` = '%d', `hOwner` = '%e', `hEnterX` = '%f', `hEnterY` = '%f', `hEnterZ` = '%f', `hExitX` = '%f', `hExitY` = '%f', `hExitZ` = '%f', `hCarX` = '%f', `hCarY` = '%f', `hCarZ` = '%f', `hCarFA` = '%f', `SafeX` = '%f', `SafeY` = '%f',`SafeZ` = '%f', `SafeFA` = '%f',");
strcat(strall, " `ShkafX` = '%f', `ShkafY` = '%f', `ShkafZ` = '%f', `ShkafFA` = '%f', `HoloX` = '%f', `HoloY` = '%f', `HoloZ` = '%f', `HoloFA` = '%f', `hLevel` = '%d', `hPrice` = '%d', `hLock` = '%d', `hTakings` = '%d', `hInt` = '%d', `hHel` = '%d', `hClass` = '%d' WHERE `hID` = '%d'");
strc = strall;
mysql_format(MYSQL_ARG, asd, sizeof(asd),strc,
HouseInfo[houseid][hOwned],
HouseInfo[houseid][hOwner],
HouseInfo[houseid][hEnterX],
HouseInfo[houseid][hEnterY],
HouseInfo[houseid][hEnterZ],
HouseInfo[houseid][hExitX],
HouseInfo[houseid][hExitY],
HouseInfo[houseid][hExitZ],
HouseInfo[houseid][hCarX],
HouseInfo[houseid][hCarY],
HouseInfo[houseid][hCarZ],
HouseInfo[houseid][hCarFA],
HouseInfo[houseid][SafeX],
HouseInfo[houseid][SafeY],
HouseInfo[houseid][SafeZ],
HouseInfo[houseid][SafeFA],
HouseInfo[houseid][ShkafX],
HouseInfo[houseid][ShkafY],
HouseInfo[houseid][ShkafZ],
HouseInfo[houseid][ShkafFA],
HouseInfo[houseid][HoloX],
HouseInfo[houseid][HoloY],
HouseInfo[houseid][HoloZ],
HouseInfo[houseid][HoloFA],
HouseInfo[houseid][hLevel],
HouseInfo[houseid][hPrice],
HouseInfo[houseid][hLock],
HouseInfo[houseid][hTakings],
HouseInfo[houseid][hInt],
HouseInfo[houseid][hHel],
HouseInfo[houseid][hClass],
HouseInfo[houseid][hID]
);
mysql_tquery(MYSQL_ARG, asd, "", "");
return true;
}
Типо такого? Но почему-то опять все координаты стали равны. Сохранение также не корректное.
- - - Добавлено - - -
Пишу так - работает.
PHP код:
public OnHouseSave(houseid)
{
new strall[2048];
strcat(strall,"UPDATE `"Houses"` SET `hOwned` = '%d', `hOwner` = '%e', `hEnterX` = '%f', `hEnterY` = '%f', `hEnterZ` = '%f', `hExitX` = '%f', `hExitY` = '%f', `hExitZ` = '%f',");
strcat(strall," `hLevel` = '%d', `hPrice` = '%d', `hLock` = '%d', `hTakings` = '%d', `hInt` = '%d', `hHel` = '%d', `hClass` = '%d' WHERE `hID` = '%d'");
mysql_format(MYSQL_ARG, asd, sizeof(asd), strall,
HouseInfo[houseid][hOwned],
HouseInfo[houseid][hOwner],
HouseInfo[houseid][hEnterX],
HouseInfo[houseid][hEnterY],
HouseInfo[houseid][hEnterZ],
HouseInfo[houseid][hExitX],
HouseInfo[houseid][hExitY],
HouseInfo[houseid][hExitZ],
HouseInfo[houseid][hLevel],
HouseInfo[houseid][hPrice],
HouseInfo[houseid][hLock],
HouseInfo[houseid][hTakings],
HouseInfo[houseid][hInt],
HouseInfo[houseid][hHel],
HouseInfo[houseid][hClass],
HouseInfo[houseid][hID]
);
mysql_tquery(MYSQL_ARG, asd, "", "");
return true;
}
Пишу так - не работает.
PHP код:
public OnHouseSave(houseid)
{
new strall[2048];
strcat(strall,"UPDATE `"Houses"` SET `hOwned` = '%d', `hOwner` = '%e', `hEnterX` = '%f', `hEnterY` = '%f', `hEnterZ` = '%f', `hExitX` = '%f', `hExitY` = '%f', `hExitZ` = '%f',");
strcat(strall," `hCarX` = '%f', `hCarY` = '%f', `hCarZ` = '%f', `hCarFA` = '%f', `SafeX` = '%f', `SafeY` = '%f', `SafeZ` = '%f', `SafeFA` = '%f',");
strcat(strall," `ShkafX` = '%f', `ShkafY` = '%f', `ShkafZ` = '%f', `ShkafFA` = '%f', `HoloX` = '%f', `HoloY` = '%f', `HoloZ` = '%f', `HoloFA` = '%f',");
strcat(strall," `hLevel` = '%d', `hPrice` = '%d', `hLock` = '%d', `hTakings` = '%d', `hInt` = '%d', `hHel` = '%d', `hClass` = '%d' WHERE `hID` = '%d'");
mysql_format(MYSQL_ARG, asd, sizeof(asd), strall,
HouseInfo[houseid][hOwned],
HouseInfo[houseid][hOwner],
HouseInfo[houseid][hEnterX],
HouseInfo[houseid][hEnterY],
HouseInfo[houseid][hEnterZ],
HouseInfo[houseid][hExitX],
HouseInfo[houseid][hExitY],
HouseInfo[houseid][hExitZ],
HouseInfo[houseid][hCarX],
HouseInfo[houseid][hCarY],
HouseInfo[houseid][hCarZ],
HouseInfo[houseid][hCarFA],
HouseInfo[houseid][SafeX],
HouseInfo[houseid][SafeY],
HouseInfo[houseid][SafeZ],
HouseInfo[houseid][SafeFA],
HouseInfo[houseid][ShkafX],
HouseInfo[houseid][ShkafY],
HouseInfo[houseid][ShkafZ],
HouseInfo[houseid][ShkafFA],
HouseInfo[houseid][HoloX],
HouseInfo[houseid][HoloY],
HouseInfo[houseid][HoloZ],
HouseInfo[houseid][HoloFA],
HouseInfo[houseid][hLevel],
HouseInfo[houseid][hPrice],
HouseInfo[houseid][hLock],
HouseInfo[houseid][hTakings],
HouseInfo[houseid][hInt],
HouseInfo[houseid][hHel],
HouseInfo[houseid][hClass],
HouseInfo[houseid][hID]
);
mysql_tquery(MYSQL_ARG, asd, "", "");
return true;
}
- - - Добавлено - - -
Сообщение от
Tracker1
Выведи запрос, который получается, перед посылкой в базу.
Алсо. strcat не самый удачный вариант. Используй русифицированный компилятор: там можно константные строки любой длинны указывать.
Можно поподробнее?