[Request] Daily status, please all good devs come here!

[NumL0ck]

Hello MXC!

Who can make java code for interlude, then you wrote .getstats to you show

Today [PVP] : 0 [Deaths] : 0 [PK] : 0

and...

Cancel Skill after x time you receive back your loosing buffs.

Big big thanks!!! Big big thanks!!! Big big thanks!!! Big big thanks!!!

[vampir]

if u did what i wrote, now find a method in L2PcInstance where pvp points are increased and give send it here.

[NumL0ck]

		setPvpKills(getPvpKills() + 1);

	setDayPvp(getDayPvp() + 1);

and Pk

		setPkKills(getPkKills() + 1);

	setDayPk(getDayPk() + 1);

[vampir]

lets make pvp points first.

replace setDayPvp(getDayPvp() + 1); with addDayPvp();

and now create new method in L2PcInstance at the end:

private void addDayPvp()

{

//inside this method we will increase number in database. Find an example of code that is using INSERT INTO statement and send it here

}

[NumL0ck]

i have this

public void setDayPvp(int dayPvp){

_daypvp = dayPvp;

}

 

public int getDayPvp(){

return _daypvp;

}

[vampir]

i have this

public void setDayPvp(int dayPvp){

_daypvp = dayPvp;

}

 

public int getDayPvp(){

return _daypvp;

}

so change it :)

[NumL0ck]

okey i change it, what we do now?

[vampir]

lets make pvp points first.

replace setDayPvp(getDayPvp() + 1); with addDayPvp();

and now create new method in L2PcInstance at the end:

private void addDayPvp()

{

//inside this method we will increase number in database. Find an example of code that is using INSERT INTO statement and send it here

}

[NumL0ck]

i don't understand.

if you understand you can search it

http://maxcheaters.com/forum/index.php?topic=237353.0

[vampir]

sorry, i wasnt at the code clear enough, delete this lines:

+        if(isPvpMaster())
+        masterkills++;
+        
+        switch(masterkills){
+        	case 4:
+        		getStatus().setCurrentCp(getMaxCp());
+        		getStatus().setCurrentHp(getMaxHp());
+        		getStatus().setCurrentMp(getMaxMp());
+        		sendMessage("You rewarded with full hp,cp,mp cause of your pvp master's ability");
+        		masterkills = 0;
+        		break;
+        		default:
+        			;
+        }

u dont need them, also delete this from your command:

public void DayPvpandPk(L2PcInstance l2pcinstance)
              {
            	  try
            	  {
            		  Connection connection = L2DatabaseFactory.getInstance().getConnection();
            		  PreparedStatement preparedstatement = connection.prepareStatement("SELECT todaypvps,char_name FROM characters WHERE accesslevel=? ORDER BY todaypvps DESC LIMIT 1");
            		  preparedstatement = connection.setInt(1, 0);
            		  ResultSet resultset = preparedstatement.executeQuery();
  					
  					if (rSet.next())
  					{
  						newPvpLord = rSet.getString("char_name");
  						topTodayPvps = rSet.getInt("todaypvps");
  					}
  					
  					rSet.close();
  					stm.close();
  					

            	  }
            	  catch(SQLException sqlexception)
            	  {
            	          
            	  }
              }

replace DayPvp() with activeChar.getDayPvp() and tell me about the results :)

[NumL0ck]

allright, but why after 5 min add daypvp then i kill player or only add in navicat after restart...

[vampir]

i dont understand anything but your daily pvps should work right now as normal pvp scores, they do?

[NumL0ck]

package com.l2jfrozen.gameserver.handler.voicedcommandhandlers;
    
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.Calendar;

import com.l2jfrozen.util.database.L2DatabaseFactory;
import com.l2jfrozen.gameserver.model.entity.Announcements;
import com.l2jfrozen.gameserver.templates.StatsSet;
import com.l2jfrozen.gameserver.thread.ThreadPoolManager;
import com.l2jfrozen.gameserver.model.L2World;
import com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance;
import com.l2jfrozen.gameserver.handler.IVoicedCommandHandler;
import com.l2jfrozen.gameserver.network.serverpackets.CreatureSay;
import com.l2jfrozen.gameserver.network.clientpackets.Say2;

/**
* Allow player to enable or disable Experience and SP Gain.
*/

           public class getstatus implements IVoicedCommandHandler

                {

              private static final String[] VOICED_COMMANDS =

              {
                      "getstatus"
              };

       

              public boolean useVoicedCommand(String command, L2PcInstance activeChar, String params)

              {
            	  
                  if (command.equalsIgnoreCase("getstatus"))
                  {
                	  DayPvpandPk(activeChar);
                   }
    return true;
}              
              public void DayPvpandPk(L2PcInstance l2pcinstance)
              {
          		int DayPvp = 0;
          		int DayPk = 0;
        		Connection con = null;
        		PreparedStatement state = null;
        		ResultSet rset = null;
            	  try
            	  {
          			con = L2DatabaseFactory.getInstance().getConnection();
        			state = con.prepareStatement("SELECT daypvp,daypk FROM characters WHERE charId=?");
        			rset = state.executeQuery();
        			if(rset.next())
        			{
        			DayPvp = rset.getInt("daypvp");
        			DayPk = rset.getInt("daypvp");
        			}
        			
        			state.close();
        			rset.close();
        			
        			for(L2PcInstance p : L2World.getInstance().getAllPlayers()){
        				{
        					p.broadcastUserInfo();
        					
        					p.sendMessage("Today PvPs: "+DayPvp);
        					p.sendMessage("Today PKs: "+DayPk);
        				}
        			}
            	  }
        					catch (Exception e)
        					{ }
        					finally
        					{
        					try
        					{
        					con.close();
        					}
        					catch (Exception e)
        					{ }
        					}
        					}
              public String[] getVoicedCommandList()

              {

                      return VOICED_COMMANDS;

              }

      }

i maked this, no errors, but DON'T working... and your example don't working...

[vampir]

ech... coz u arent listening. Told u to delete DayPvpandPk :)

[NumL0ck]

but if i delete daypvpandpk and replace DayPvp() with activeChar.getDayPvp() nothing happens

[vampir]

u have to replace  DayPvpandPk(activeChar); with activeChar.sendMessage("Daily pvps:"+activeChar.getDayPvp());