!delete Comand

[Andrekkzie]

I need a command for deleting ppl but when i deleted a person i want to say Name has been deleted for breaking the rules!

 

[GarQet]

I should work:
data/talkactions/scripts/delete.lua

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) and getPlayerGhostAccess(pid) > getPlayerGhostAccess(cid))) then
		doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player " .. param .. " not found.")
		return true
	end

	doBroadcastMessage("" .. getCreatureName(pid) .." has been deleted for breaking the rules!")
	doRemoveCreature(pid, true)
	db.executeQuery("DELETE from `players` WHERE `name` = " .. getCreatureName(pid) .. " LIMIT 1")
	return true
end

 

[Andrekkzie]

thx

 

[Andrekkzie]

didn't work :/

 

[Dankoo]

If you're using 0.4 change

db.executeQuery("DELETE from `players` WHERE `name` = " .. getCreatureName(pid) .. " LIMIT 1")

to

db.query("DELETE from `players` WHERE `name` = " .. getCreatureName(pid) .. " LIMIT 1")

Any error messages?

 

[Andrekkzie]

I haven put that but i don't need any special command for do it?

 

[Dankoo]

I haven put that but i don't need any special command for do it?

facepalm

talkactions.xml

<talkaction log="yes" words="/delete" access="5" event="script" value="delete.lua"/>

Name the script GarQet made as delete.lua and put in talkactions/scripts

Example of use: /delete Garqet

Then just click here to finish http://otland.net/reputation.php?do=addreputation&p=1270599 :]

of course, rep GarQet too!! http://otland.net/reputation.php?do=addreputation&p=1270451

 

[Andrekkzie]

ok hold on

 

[Andrekkzie]

15:50 Kyle has been deleted for breaking the rules!

But anyway when im going to put my acc again in the character lits still appears the character and i login with the deleted character and nothing happens :/

 

[GarQet]

And click here: http://otland.net/reputation.php?do=addreputation&p=1270451

 

[Andrekkzie]

Lol is not done help me to finish and i add u rep

 

[Dankoo]

Lol is not done help me to finish and i add u rep

We're helping you because we please, don't be such an ass, solve your own problems then.

I'm outta this topic

PS: GarQet, repped

 

[Andrekkzie]

Lol i already gave u rep whats ur problem?

 

[BeniS]

you want to make sure they are offline before deleting too.

 

[Darkhaos]

Didn't work because you're not using db.escapeString or ''
Try this

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

	local c = db.executeQuery
	if not c then
		c = db.query
	end
 
	local pid = getPlayerByNameWildcard(param)
	if(not pid or (isPlayerGhost(pid) and getPlayerGhostAccess(pid) > getPlayerGhostAccess(cid))) then
		return doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player " .. param .. " not found.")
	end

	doRemoveCreature(pid)
	local query = c("delete from players where name = " .. db.escapeString(getCreatureName(pid)) .. ";")
	if not query then
		return doPlayerSendTextMessage(cid, MESSAGE_STATUS_CONSOLE_BLUE, "Player " .. getCreatureName(pid) .. " cannot be deleted.")
	end

	return doBroadcastMessage(getCreatureName(pid) .." has been deleted for breaking the rules!")
end

 

[Dankoo]

Lol i already gave u rep whats ur problem?

Just got pissed to be put at stake, like "I'll only do that if you finish the damn code you're suppose to finish" :s

As if the good will itself wasn't enough for it.