[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!!!

[NumL0ck]

gonna work without java? only in navicat?

[Joκκєrino]

First you have to edit UPDATE_CHARACTER and RESTORE_CHARACTER as you said .

[NumL0ck]

but i say then i edit it, i can't create char, but why i don't know...

[Joκκєrino]

Buddy , first you have to edit

 

From

 

    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=? WHERE obj_id=?";
   private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level FROM characters WHERE obj_id=?";

 

to

 

    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,todaypvps=?,pvplord=? WHERE obj_id=?";
    private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level,todaypvps,pvplord FROM characters WHERE obj_id=?";

 

After that , you have to do what i said :

 

Open navicat, your connection, your database, table named characters.sql, file, design table, then add todaypvps and pvplord as int with lenght from 2 to 5 (depends how many players you have because they can make 10.000 pvp's in 1 day ), save it, restart server, and try create another character.

 

Follow these steps and it gonna work .

 

And that's it , this gonna work .

[NumL0ck]

MAN, LISTEN!

THEN I EDIT THIS

    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=? WHERE obj_id=?";
   private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level FROM characters WHERE obj_id=?";

i CAN'T create char, i don't know why!!! :((

[Joκκєrino]

MAN, LISTEN!

THEN I EDIT THIS

    private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,str=?,con=?,dex=?,_int=?,men=?,wit=?,face=?,hairStyle=?,hairColor=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,pvpkills=?,pkkills=?,rec_have=?,rec_left=?,clanid=?,maxload=?,race=?,classid=?,deletetime=?,title=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,in_jail=?,jail_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,last_recom_date=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=? WHERE obj_id=?";
   private static final String RESTORE_CHARACTER = "SELECT account_name, obj_Id, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, acc, crit, evasion, mAtk, mDef, mSpd, pAtk, pDef, pSpd, runSpd, walkSpd, str, con, dex, _int, men, wit, face, hairStyle, hairColor, sex, heading, x, y, z, movement_multiplier, attack_speed_multiplier, colRad, colHeight, exp, expBeforeDeath, sp, karma, pvpkills, pkkills, clanid, maxload, race, classid, deletetime, cancraft, title, rec_have, rec_left, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, in_jail, jail_timer, newbie, nobless, power_grade, subpledge, last_recom_date, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level FROM characters WHERE obj_id=?";

i CAN'T create char, i don't know why!!! :((

 

Please stop caps looking . I'm here to help you , or i can leave you alone .

 

After editing this , you have to do what i said on last post :

 

Open navicat, your connection, your database, table named characters.sql, file, design table, then add todaypvps and pvplord as int with lenght from 2 to 5 (depends how many players you have because they can make 10.000 pvp's in 1 day ), save it, restart server, and try create another character.

 

Follow these steps and it gonna work .

 

[NumL0ck]

Thanks all working, i create daypvp, daypk, but i need voicecommand .getstatus

then i wrote .getstatus sendMessage( Daypvp: 0 Daypk: 0 )

but i can't create, i'm to newbie...

[vampir]

u have got half way done :)

now u just need to make this variables increase and reset everyday, read my first post again and think of what u have to do now :)

[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("getstats"))
                  {
                	  DayPvpandPk(activeChar);
                	  activeChar.sendMessage("[Today PvPs: "+DayPvp()+"] [Today PKs: "+DayPk()+"");
                   }
    return true;
}              
              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)
            	  {
            	          
            	  }
              }
              protected StatsSet _StateSet;
              public String[] getVoicedCommandList()

              {

                      return VOICED_COMMANDS;

              }

      }

please help me to make it, this is Example, but i CAN'T create i'm to newbie...

[Joκκєrino]

From now , i finished my work . Good luck vampire . I'm not sure how i can make a sheduler . I'm gonna take a look at topic at every post .

 

Good luck NumL0ck , hope my advices helped you :D .

[NumL0ck]

Yes you and vampir best, I love this forum!!!

[vampir]

change:

SELECT todaypvps,char_name FROM characters WHERE accesslevel=? ORDER BY todaypvps DESC LIMIT 1

to

SELECT todaypvps FROM characters WHERE charId=?

This will give us player's todaypvps.

change preparedstatement = connection.setInt(1, 0); - it was for access level = 0

to preparedstatement = connection.setInt(1, l2pcinstance.getObjectId()); - getObjectId() is same thing as charId

 

Lets make ne variable that will store our pvp point.

before "try" add int dailyPvp = 0;

now inside if (rSet.next())

we need to set this variable as

dailyPvp = rSet.getInt("todaypvps");

 

Ok, so far we are taking variables from database, but they will still be 0 all the time :O

So, we need to increase this variable in database when player gets pvp, go to L2PcInstance class and find method that increase pvp point, tell me when u are done :)

 

[NumL0ck]

i do that because i have

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

and i need only voiced command .getstatus

then player say .getstatus

sendMessage( Daypvp: 0 Daypk: 0 )

I install all day pvp master system and i use daypvp like example and i maked daypk:D

[vampir]

i do that because i have

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

and i need only voiced command .getstatus

then player say .getstatus

sendMessage( Daypvp: 0 Daypk: 0 )

I install all day pvp master system and i use daypvp like example and i maked daypk:D

i understand, i am trying to help u with what u wanna do so try to do what i wrote :P

[NumL0ck]

okey i go, and?