Jump to content
  • 0

Question

Posted

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

2 answers to this question

Recommended Posts

  • 0
Posted
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.

  • 0
Posted
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

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

×
×
  • Create New...