Requesting 2 Scripts

[Sonnyxz]

Hello, I'm asking for two simple scripts, their definition is below:

First Script :

I would like a script when the player dies if it has magic level above 150, it loses at least one magic level, why not know what happens after he passes the magic level of 150 when he dies loses only 3% of its magic level ...

Second Script :

Well personally I would like a script to remove frags (Only one Frag) of players for each 1kk Frag, I even have a script here, the more it removes all the frags at once ... I would like to remove only one frag.

Sorry for my bad english, I'm using google translator.

Thanks in advance and..
Rep++

 

[_Arthur]

You didn't give much detail, but here..

Second as a MOD:

fragremove.xml

<?xml version="1.0" encoding="UTF-8"?>
<mod name="Frag Remover" version="1.1" author="Arthur" contact="otland.net" enabled="yes">
	<action itemid="xxxx" event="script"><=!=[=C=D=A=T=A=[
			db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `unjustified` = 1 AND `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ")")
			doSendMagicEffect(getPlayerPosition(cid), CONST_ME_MAGIC_RED)
			doSendAnimatedText(getPlayerPosition(cid), "Removed !", 180)
			doRemoveItem(item.uid, 1)
		end
		return true
	]=]=></action>
</mod>

 

[Sonnyxz]

thanks for trying to help me...
more this mod removes all the frags at once, which would remove a 1 in a frag, you know?

 

[Cykotitan]

Rather

db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `unjustified` = 1 AND `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ") LIMIT 1;")

 

[_Arthur]

Second as a MOD:

fragremove.xml

<?xml version="1.0" encoding="UTF-8"?>
<mod name="Frag Remover" version="1.1" author="Arthur" contact="otland.net" enabled="yes">
	<action itemid="xxxx" event="script"><=!=[=C=D=A=T=A=[
			db.executeQuery("UPDATE `killers` SET `unjustified` = 0 WHERE `unjustified` = 1 AND `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ") LIMIT 1;")
			doSendMagicEffect(getPlayerPosition(cid), CONST_ME_MAGIC_RED)
			doSendAnimatedText(getPlayerPosition(cid), "Removed !", 180)
			doRemoveItem(item.uid, 1)
		end
		return true
	]=]=></action>
</mod>

ty cykofag.

damn LIMIT 1. c,c

 

[knightxd]

_Arthur, like that it will only remove the frag is player have one frag.. he wants is just to remove one frag.. here

<?xml version="1.0" encoding="UTF-8"?>
<mod name="Frag Remover" version="1.1" author="Arthur" contact="otland.net" enabled="yes">
	<action itemid="xxxx" event="script"><=!=[=C=D=A=T=A=[
local frags = getPlayerFrags(cid)
local n = frags-1
                   db.executeQuery("UPDATE `killers`SET `unjustified` = "..n.." WHERE `unjustified` = "..frags.."  AND `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ")")
			doSendMagicEffect(getPlayerPosition(cid), CONST_ME_MAGIC_RED)
			doSendAnimatedText(getPlayerPosition(cid), "Removed !", 180)
			doRemoveItem(item.uid, 1)
		end
		return true
 ]=]=></action>
</mod>

 

[Cykotitan]

_Arthur, like that it will only remove the frag is player have one frag.. he wants is just to remove one frag.. here

<?xml version="1.0" encoding="UTF-8"?>
<mod name="Frag Remover" version="1.1" author="Arthur" contact="otland.net" enabled="yes">
	<action itemid="xxxx" event="script"><=!=[=C=D=A=T=A=[
local frags = getPlayerFrags(cid)
local n = frags-1
                   db.executeQuery("UPDATE `killers`SET `unjustified` = "..n.." WHERE `unjustified` = "..frags.."  AND `id` IN (SELECT `kill_id` FROM `player_killers` WHERE `player_id` = " .. getPlayerGUID(cid) .. ")")
			doSendMagicEffect(getPlayerPosition(cid), CONST_ME_MAGIC_RED)
			doSendAnimatedText(getPlayerPosition(cid), "Removed !", 180)
			doRemoveItem(item.uid, 1)
		end
		return true
 ]=]=></action>
</mod>

No, there is a row for each frag. Column unjustified can only be 0 or 1.

 

[_Arthur]

owned

 

[Cykotitan]

You failed at this too :3
bye.

 

[_Arthur]

bosnigger

 

[Sonnyxz]

none of the scripts posted worked...
An error occurred in console

OTSYS_SQLITE3_PREPARE(): SQLITE ERROR: near "LIMIT": syntax error (UPDATE "killers" SET "unjustified" = 0 WHERE "unjustified" = 1 AND "id" IN (SELECT "kill_id" FROM "player_killers" WHERE "player_id" = 3) LIMIT 1

appreciate everyone's help, I will be waiting waiting ...

 

[_Arthur]

none of the scripts posted worked...
An error occurred in console



appreciate everyone's help, I will be waiting waiting ...

Way to tell us you're using SQLITE.. <,<

 

[Sonnyxz]

this new mod that you posted only works in mysql?

 

[_Arthur]

can you even execute.db queries in sqlite?

I'm not familiar with it anyhow.

 

[knightxd]

pwned me haha but cyko, how the hell it load all frags on the function "getPlayerFrags(cid)" it loads all entryes on db?

 

[Sonnyxz]

thank Arthur and Cykotitan, I'm using the mysql databas in now and is working perfectly, now we just need another script

Rpp + + for the two who helped me!