Help Event Reward Item

[cicos]

Hello guys i got Elfocrash player of the hour event i modify it for l2jfrozen but i cant add reward item to winner i try many code's but nah.. someone can help me please?

need to add code here ( //TODO Your reward should go here. )

code:https://pastebin.com/k0rvzw72

[wongerlt]

import com.l2jfrozen.gameserver.model.L2World;

String player_name = getTopZonePvpName();
Announcements.getInstance().announceToAll("The Player of the Hour is " + player_name + " with "+getTopZonePvpCount()+ " pvps");
 
L2PcInstance player = L2World.getInstance().getPlayer(player_name);
if(player!=null){
//if online
player.addItem("VoteReward", 57, 10, null, true); // 10 adenas
//if online end
}else{
//if offline
Connection con = null;
		try 
		{
			con = L2DatabaseFactory.getInstance().getConnection();
                PreparedStatement statement = con.prepareStatement("INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, `loc`, `loc_data`) VALUES ((select obj_id from characters where char_name='"+player_name+"'), (SELECT MAX(object_id)+1 FROM items AS object_id), '57', '1', 'INVENTORY', '0')");
                statement.execute();
                statement.close();
               }
               catch (Exception e)
               {
               e.printStackTrace();
               }
			   finally
				{
			CloseUtil.close(con);
		}
// if offline end
}
//TODO Your reward should go here.

simple, not tested so idk its work or no.

[cicos]

1 hour ago, wongerlt said:

import com.l2jfrozen.gameserver.model.L2World;

String player_name = getTopZonePvpName();
Announcements.getInstance().announceToAll("The Player of the Hour is " + player_name + " with "+getTopZonePvpCount()+ " pvps");
 
L2PcInstance player = L2World.getInstance().getPlayer(player_name);
if(player!=null){
//if online
player.addItem("VoteReward", 57, 10, null, true); // 10 adenas
//if online end
}else{
//if offline
Connection con = null;
		try 
		{
			con = L2DatabaseFactory.getInstance().getConnection();
                PreparedStatement statement = con.prepareStatement("INSERT INTO `items` (`owner_id`, `object_id`, `item_id`, `count`, `loc`, `loc_data`) VALUES ((select obj_id from characters where char_name='"+player_name+"'), (SELECT MAX(object_id)+1 FROM items AS object_id), '57', '1', 'INVENTORY', '0')");
                statement.execute();
                statement.close();
               }
               catch (Exception e)
               {
               e.printStackTrace();
               }
			   finally
				{
			CloseUtil.close(con);
		}
// if offline end
}
//TODO Your reward should go here.

simple, not tested so idk its work or no.

i am trying now