cicos Posted July 12, 2019 Share Posted July 12, 2019 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 Link to comment Share on other sites More sharing options...
0 wongerlt Posted July 12, 2019 Share Posted July 12, 2019 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. Link to comment Share on other sites More sharing options...
0 cicos Posted July 12, 2019 Author Share Posted July 12, 2019 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 Link to comment Share on other sites More sharing options...
Question
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
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Please sign in to comment
You will be able to leave a comment after signing in
Sign In Now