this SELECT are not work
function OnLoginCheck(event, player)
local result = CharDBQuery("SELECT item_template FROM character_inventory WHERE `item_template` = '34470' AND `slot` = '12' AND `guid` = '"..player:GetAccountId().."';");
if (result) then
player:SendBroadcastMessage("OOOOOOOOOOOOOOOOKKKKKKKKKKKKKKKKKKKKKK")
else
player:SendBroadcastMessage("NNNNNNNNNNNNNNNNNNOOOOOOOOOOOOOOOOOOOO")
end
end
RegisterPlayerEvent(3, OnLoginCheck)
why? i dont know, but if i delete this
`item_template` = '34470' AND `slot` = '12' AND
or this
`guid` = '"..player:GetAccountId().."'
this SQL Query are work fine, why this
WHERE `item_template` = '34470' AND `slot` = '12' AND `guid` = '"..player:GetAccountId().."';"
not work???