/info advanced v.4.1

[llamavani]

my first post in this forum

go to data/talkactions/scripts new"playerinfo

function onSay(cid, words, param, channel)
	if(param == "") then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Command param required.")
		return TRUE
	end

	local pid = getPlayerByNameWildcard(param)
	if(not pid or (isPlayerGhost(pid) == TRUE and getPlayerAccess(pid) > getPlayerAccess(cid))) then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player " .. param .. " not found.")
		return TRUE
	end

	local tmp = {accountId = getPlayerAccountId(pid), ip = getPlayerIp(pid)}
	local pos = getCreaturePosition(pid)
	doPlayerPopupFYI(cid, "Information about player\nName: " .. getCreatureName(pid) .. "\nGUID: " .. getPlayerGUID(pid) .. "\nGroup: " .. getPlayerGroupName(pid) .. "\nAccess: " .. getPlayerAccess(pid) .. "\nVocation: " .. getVocationInfo(getPlayerVocation(pid)).name .. "\nStatus:\nLevel - " .. getPlayerLevel(pid) .. ", Magic Level - " .. getPlayerMagLevel(pid) .. ", Speed - " .. getCreatureSpeed(pid) .. "\nHealth - " .. getCreatureHealth(pid) .. " / " .. getCreatureMaxHealth(pid) .. ", Mana - " .. getCreatureMana(pid) .. " / " .. getCreatureMaxMana(pid) .. "\nSkills:\nFist - " .. getPlayerSkillLevel(pid,0) .. ", Club - " .. getPlayerSkillLevel(pid,1) .. ", Sword - " .. getPlayerSkillLevel(pid,2) .. ", Axe - " .. getPlayerSkillLevel(pid,3) .. "\nDistance - " .. getPlayerSkillLevel(pid,4) .. ", Shielding - " .. getPlayerSkillLevel(pid,5) .. ", Fishing - " .. getPlayerSkillLevel(pid,6) .. "\nCash:\nCrystal - " .. getPlayerItemCount(pid, 2160) .. ", Platinum - " .. getPlayerItemCount(pid, 2152) .. ", Gold - " .. getPlayerItemCount(pid, 2148) .. "\nBalance: " .. getPlayerBalance(pid) .. "\nPosition: [X - " .. pos.x .. " | Y - " .. pos.y .. " | Z - " .. pos.z .. "]\n\nInformation about account\nName: " .. getPlayerAccount(pid) .. "\nID: " .. tmp.accountId .. "\nNotations: " .. getNotationsCount(tmp.accountId) .. "\nIP: " .. doConvertIntegerToIp(tmp.ip) .. " (" .. tmp.ip .. ")")
	return TRUE
end

go to data/talkactions/talkactions.xml and add this

<talkaction log="yes" words="/info" access="5" script="playerinfo.lua"/>

^^ rep++

 

[hodleo]

hm there're already released some of this but keep scripting

 

[Texon]

Nice .
Gz..

 

[JDB]

What query do you have to execute to see the players password?

 

[hodleo]

What query do you have to execute to see the players password?

player_id -> getPlayerGUID(cid)

"SELECT `password` FROM `accounts` WHERE `id` = "player_id"