TalkAction Change Account Information & Player Names In-game

JDB · Apr 13, 2010

The Forgotten Server 0.3.6pl1
This is not really that special, but it is very helpful to have. I thought it might save people some time instead of accessing their databases.

Features:

Checks if the new name already exists or not.
Checks if the new account number already exists or not.
While changing the players name, it will check if he is name locked or not.

Examples:

Code:

/pass <player_name_here>, <new_password_here>
/acc <player_name_here>, <new_account_here>
/name <player_name_here>, <new_name_here>

data/talkactions/talkactions.xml

PHP:

<talkaction log="yes" words="/pass;/acc;/name" access="5" event="script" value="account.lua"/>

data/talkactions/scripts/account.lua

Code:

function onSay(cid, words, param, channel)
	local p = string.explode(param, ',')
	if(param == "") then
		doPlayerSendCancel(cid, "Command requires param.")
		return true
	end
	if(words == "/pass") then
		if(db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1) then
			return doPlayerSendCancel(cid, "Sorry, but player [" .. p[1] .. "] does not exist.")
		end
		return db.executeQuery("UPDATE `accounts` SET `password` = '" .. p[2] .. "' WHERE name = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have changed " .. p[1] .. "'s account password to " .. p[2] .. ".")
	end
	if(words == "/acc") then
		if(db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1) then
			return doPlayerSendCancel(cid, "Sorry, but player [" .. p[1] .. "] does not exist.")
		elseif(db.getResult("SELECT `id` FROM `accounts` WHERE `name` = " .. db.escapeString(p[2]) .. ";"):getID() == 1) then
			return doPlayerSendCancel(cid, "Sorry, but account [" .. p[2] .. "] already exists.")
		end
		return db.executeQuery("UPDATE `accounts` SET `name` = '" .. p[2] .. "' WHERE name = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have changed " .. p[1] .. "'s account number to " .. p[2] .. ".")
	end
	if(words == "/name") then
		if(db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1) then
			return doPlayerSendCancel(cid, "Sorry, but player [" .. p[1] .. "] does not exist.")
		elseif(isPlayerBanished(p[1], PLAYERBAN_LOCK)) then
			return doPlayerSendCancel(cid, "Sorry, but " .. p[1] .. " is name locked.")
		elseif(db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[2]) .. ";"):getID() == 1) then
			return doPlayerSendCancel(cid, "Sorry, but the name [" .. p[2] .. "] already exists.")
		end
		return db.executeQuery("UPDATE `players` SET `name` = '" .. p[2] .. "' WHERE name = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have changed " .. p[1] .. "'s name to " .. p[2] .. ".")
	end
end

Scorpvm · Apr 13, 2010

Lol nice!

Sync · Apr 13, 2010

nice bro

Mattt · Apr 13, 2010

nice one!

Fallen · Apr 13, 2010

nice, saves alot of time

Cykotitan · Apr 13, 2010

...

Code:

function onSay(cid, words, param, channel)
	local p = string.explode(param, ',')
	return param == "" and doPlayerSendCancel(cid, "Command requires param.") or words == "/pass" and (db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1 and doPlayerSendCancel(cid, "Sorry, but player [" .. p[1] .. "] does not exist.") or db.executeQuery("UPDATE `accounts` SET `password` = '" .. p[2] .. "' WHERE name = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have changed " .. p[1] .. "'s account password to " .. p[2] .. ".")) or words == "/acc" and (db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1 and doPlayerSendCancel(cid, "Sorry, but player [" .. p[1] .. "] does not exist.") or db.getResult("SELECT `id` FROM `accounts` WHERE `name` = " .. db.escapeString(p[2]) .. ";"):getID() == 1 and doPlayerSendCancel(cid, "Sorry, but account [" .. p[2] .. "] already exists.") or db.executeQuery("UPDATE `accounts` SET `name` = '" .. p[2] .. "' WHERE name = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have changed " .. p[1] .. "'s account number to " .. p[2] .. ".")) or words == "/name" and (db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[1]) .. ";"):getID() == -1 and doPlayerSendCancel(cid, "Sorry, but player [" .. p[1] .. "] does not exist.") or isPlayerBanished(p[1], PLAYERBAN_LOCK) and doPlayerSendCancel(cid, "Sorry, but " .. p[1] .. " is name locked.") or db.getResult("SELECT `id` FROM `players` WHERE `name` = " .. db.escapeString(p[2]) .. ";"):getID() == 1 and doPlayerSendCancel(cid, "Sorry, but the name [" .. p[2] .. "] already exists.") or db.executeQuery("UPDATE `players` SET `name` = '" .. p[2] .. "' WHERE name = '" .. p[1] .. "';") and doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "You have changed " .. p[1] .. "'s name to " .. p[2] .. "."))
end

JDB · Apr 13, 2010

I could have made it like that, but it's not as easy for most people to configure.

Thanks for the comments.

//JDB

JNLPB · Apr 13, 2010

Nice script! But I have this error:

[13/04/2010 15:07:05] data/talkactions/scripts/account.lua:24: attempt to call global 'isPlayerBanned' (a nil value)
[13/04/2010 15:07:05] stack traceback:
[13/04/2010 15:07:05] data/talkactions/scripts/account.lua:24: in function <data/talkactions/scripts/account.lua:1>

Can u help me?

JDB · Apr 13, 2010

I have no such error using 0.3.6pl1. That function must not be working on your version.

JNLPB · Apr 13, 2010

Hehe, thnx anyway

edit:

problem solved xD

richux · Apr 14, 2010

lol, you guys fucking rock! ;]

JDB · Apr 21, 2010

Bringing it up!

frigo · Apr 22, 2010

Wooow, nice one, thanks ^^

Azcarer · Apr 22, 2010

Critico · Apr 26, 2010

Bug: unlimited number of letters of the nickname

Cykotitan · Apr 26, 2010

Looks like OP didn't think this through.

JDB · May 6, 2010

Critico said:
Bug: unlimited number of letters of the nickname

Well if you have a problem with "God's" giving names that are 25 character's long, then I think you should reevaluate your situation.

Fallen · May 9, 2010

JDB said:
Well if you have a problem with "God's" giving names that are 25 character's long, then I think you should reevaluate your situation.

loool, pwntt

ChiSka · May 10, 2010

Need That Script Work FOr Points Can?

calum69 · May 11, 2010

can you make it so a player can change his own name when he wants with a command like /name "new player name"

TalkAction Change Account Information & Player Names In-game

OtLand Veteran

Member

Ø,ø

I'm cool I swear

Freelancer

Experienced G'

OtLand Veteran

New Member

OtLand Veteran

New Member

Tibera.org

OtLand Veteran

New Member

HEJJJJ!! :D

Sexy

Experienced G'

OtLand Veteran

Freelancer

Avera.Sytes.Net

New Member

Similar threads