(Resolvido)Bug sistema kage

[elielder 9]

.Qual servidor ou website você utiliza como base? 

OTX 2.15 8.60 0.4

Qual o motivo deste tópico? 

reiniciei a VPS e começou a dar esse erro:

Está surgindo algum erro? Se sim coloque-o aqui. 

Citar

mysql_real_query(): SELECT `player_storage`.`value`, `player_storage`.`player_id`, `players`.`id`, `players`.`name`, `players`.`town_id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = `players`.`id` and `player_storage`.`value` >300 and `player_storage`.`key` = 7892120 and `players`.`town_id` = 1 GROUP BY `player_storage`.`value` DESC; - MYSQL ERROR: Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'nto4.player_storage.player_id' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by (1055)


[11:56:20.122] [Error - CreatureScript Interface]
[11:56:20.122] data/creaturescripts/scripts/tierlook.lua:onLogin
[11:56:20.122] Description:
[11:56:20.122] data/lib/004-database.lua:82: [Result:getDataString] Result not set!
[11:56:20.122] stack traceback:
[11:56:20.122]  [C]: in function 'error'
[11:56:20.122]  data/lib/004-database.lua:82: in function 'getDataString'
[11:56:20.122]  data/creaturescripts/scripts/tierlook.lua:163: in function <data/creaturescripts/scripts/tierlook.lua:159>
[11:56:20.126] Zetsu has logged out.

[11:56:21.121] [Error - CreatureScript Interface]
[11:56:21.121] In a timer event called from:
[11:56:21.121] data/creaturescripts/scripts/antimc.lua:onLogin
[11:56:21.121] Description:
[11:56:21.121] (internalGetPlayerInfo) Player not found when requesting player info #29

 

Spoiler

 

Você tem o código disponível? Se tiver publique-o aqui: 

lib:
GRADUACAO_STORAGE = 7892120

GRADUACAO_1 = 1
GRADUACAO_2 = 2
GRADUACAO_3 = 3
GRADUACAO_4 = 4
GRADUACAO_5 = 5
GRADUACAO_6 = 6
GRADUACAO_7 = 7
GRADUACAO_8 = 8

GRADUACAO_TYPES = {
    [1] = "Aluno",
    [2] = "Genin",
    [3] = "Chunnin",
    [4] = "Tokubetsu Jounin",
    [5] = "Jounin",
} 

function getPlayerRankGraduacao(cid, cidade)
return db.getResult("SELECT `player_storage`.`value`, `player_storage`.`player_id`, `players`.`id`, `players`.`name`, `players`.`town_id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = `players`.`id` and `player_storage`.`value` >300 and `player_storage`.`key` = 7892120 and `players`.`town_id` = "..cidade.." GROUP BY `player_storage`.`value` DESC;")
end

function getPlayerGraduacao(cid)
    local var = {
        [{0, 29}] = GRADUACAO_1, 
        [{30, 74}] = GRADUACAO_2,
        [{75, 149}] = GRADUACAO_3,
        [{150, 224}] = GRADUACAO_4,
	    [{225, 299}] = GRADUACAO_5,
    }
    local graduacao = getPlayerStorageValue(cid, GRADUACAO_STORAGE) <= 0 and 0 or getPlayerStorageValue(cid, GRADUACAO_STORAGE)
    for v , r in pairs(var) do
        if graduacao >= v[1] and graduacao <= v[2] then
            return r
        end
    end
end
 

 

 

 

tierlook:
 

Spoiler

function onLogin(cid)

local kage = getPlayerRankGraduacao(cid, getPlayerTown(cid))
if getPlayerStorageValue(cid, GRADUACAO_STORAGE) >= 300 then
	if getPlayerName(cid) == kage:getDataString("name") then
		doAddCondition(cid, kages)
		doSendAnimatedText(getPlayerPosition(cid), "Kage!", COLOR_RED)  
		doAddCondition(cid, kageskill)
	elseif getPlayerStorageValue(cid, GRADUACAO_STORAGE) >= kage:getDataInt("value")*0.7 then
		doAddCondition(cid, sannin)
		doAddCondition(cid, sanninskill)
	else	
		doAddCondition(cid, anbu)
		doAddCondition(cid, anbuskill)	
	end
else
	local graduacao = GRADUACAO_TYPES[getPlayerGraduacao(cid)]
	if graduacao == "Genin" then
	doAddCondition(cid, genin)
	elseif graduacao == "Chunnin" then
	doAddCondition(cid, chunnin)
	elseif graduacao == "Tokubetsu Jounin" then
	doAddCondition(cid, tokubetsujounin)
	elseif graduacao == "Jounin" then
	doAddCondition(cid, jounin)
	doAddCondition(cid, jouninskill)
	end
end

 

 

[Shiuns 13]

function onLogin(cid)
	if getPlayerStorageValue(cid, GRADUACAO_STORAGE) >= 300 then
		local kage = getPlayerRankGraduacao(getPlayerTown(cid))
		if kage:getID() ~= -1 then
			if getPlayerName(cid) == kage:getDataString("name") then
				doAddCondition(cid, kages)
				doSendAnimatedText(getPlayerPosition(cid), "Kage!", COLOR_RED) 
				doAddCondition(cid, kageskill)
			elseif getPlayerStorageValue(cid, GRADUACAO_STORAGE) >= kage:getDataInt("value")*0.7 then
				doAddCondition(cid, sannin)
				doAddCondition(cid, sanninskill)
			else	
				doAddCondition(cid, anbu)
				doAddCondition(cid, anbuskill)	
			end
		end
	else
		local graduacao = GRADUACAO_TYPES[getPlayerGraduacao(cid)]
		if graduacao == "Genin" then
			doAddCondition(cid, genin)
		elseif graduacao == "Chunnin" then
			doAddCondition(cid, chunnin)
		elseif graduacao == "Tokubetsu Jounin" then
			doAddCondition(cid, tokubetsujounin)
		elseif graduacao == "Jounin" then
			doAddCondition(cid, jounin)
			doAddCondition(cid, jouninskill)
		end
	end
	return true
end

 

 

e a função na lib deixa assim:

 

function getPlayerRankGraduacao(cidade)
	return db.getResult("SELECT `player_storage`.`value`, `player_storage`.`player_id`, `players`.`id`, `players`.`name`, `players`.`town_id` FROM `player_storage`, `players` WHERE `player_storage`.`player_id` = `players`.`id` and `player_storage`.`value` >300 and `player_storage`.`key` = 7892120 and `players`.`town_id` = "..cidade.." GROUP BY `player_storage`.`value` DESC;")
end

 

[elielder 9]

obrigado por me ajudar, eu não testei oque você me encaminhou pq eu consegui resolver o problema dando um comando na database. não consegui postar aqui, pois tive que sair correndo pro trabalho.

comando usado: SET GLOBAL sql_mode='';