Help on script: Kicking a player with a certain item in his inventory

[alkhaleej]

Can anyone please help me on this script:

 

I want to kick a certain player that is online if he has a certain item in his inventory and will delete that entry from `inventory` table afterwards. I have a script below but it is not doing anything except for the delete part.

 

 

query_sql "SELECT `char_id` FROM `inventory` WHERE `nameid` = '1599'",.@IHLD;
query_sql "SELECT `name` FROM `char` WHERE `char_id` = '.@IHLD'",.@IHLDNAME$;
atcommand "@kick "+.@IHLDNAME$;
query_sql "DELETE FROM `inventory` WHERE `nameid` = '1599'";

Edited November 9, 2013 by alkhaleej

[Patskie]

This?

-    script    Sample    -1,{
    OnPCLoginEvent:
        if ( countitem(1599) ) {
            delitem 1599, countitem(1599);
            atcommand "@kick " +strcharinfo(0);
        }
        end;
}

[alkhaleej]

Thanks sir but can I use it without the ONPCLoginEvent? I will use this under a case switch?

[Patskie]

Depends upon your idea on how to deal with it

[alkhaleej]

Thanks sir but can I use it without the ONPCLoginEvent? I will use this under a case switch?

 

Double post. I'll try it sir.

Edited November 9, 2013 by alkhaleej

[Capuche]

You want an npc ig ?

prontera,150,150,5	script	boum	456,{
	if ( getgmlevel() < 60 ) end;
	input .item_id;
	if ( getiteminfo( .item_id,1 ) == -1 ) {
		message "wrong item id";
		end;
	}
	addrid 0;
	if ( getgmlevel() >= 60 ) end;
	.@amount = countitem( .item_id );
	if ( .@amount ) {
		delitem .item_id, .@amount;
		atcommand "@kick "+ strcharinfo(0);
	}
	end;
}

[alkhaleej]

thank u very much for your replies. what I actually want is for this to be a part of another function that has a case

 

function a

switch

case

[Capuche]

It's too vague for me... I don't get what you want sorry.

[Patskie]

Yeah maybe you can elaborate more on what the function do.