10.09.2015, 13:28
Hello,
I use mysql and im trying to make bussines system. I have a little problem - I can't save players name into bussines info "Owner"...here is everything:
This is when player clicks buy:
and here is onshopbuy function
It works until last 2 lines(saving owners name)
I use mysql and im trying to make bussines system. I have a little problem - I can't save players name into bussines info "Owner"...here is everything:
This is when player clicks buy:
Код:
new query[100]; mysql_format(mysql, query, sizeof(query), "SELECT * FROM `shop` WHERE `ID` = %d", Player[playerid][Entering]); mysql_tquery(mysql, query, "OnShopBuy", "i", playerid);
Код:
public OnShopBuy(playerid) { new cijena; cijena = cache_get_field_content_int(0, "Cijena"); if(GetPlayerMoney(playerid) < cijena) return SendClientMessage(playerid, -1, ""COL_RED"[Greљka] "COL_WHITE"Nemate dovoljno novaca"); if(Player[playerid][Firma] > 0) return SendClientMessage(playerid, -1, ""COL_RED"[Greљka]"COL_WHITE" Vec imate firmu!"); GivePlayerMoney(playerid, -cijena); Player[playerid][Firma] = cache_get_field_content_int(0, "ID"); indialog[playerid] = 0; new query[128], name[24]; GetPlayerName(playerid, name, sizeof(name)); mysql_format(mysql, query, sizeof(query), "UPDATE `shop` SET `Owner` = %s WHERE `ID` = %d", name, Player[playerid][Firma]); mysql_tquery(mysql, query, "", ""); return 1; }