Code AIO Buffer(Admin Command + Skills)

[Prince*]

hallo .. i post this code becaouse more ppls on my msn need this code.. and i search for this on forum and i dont have fount them..

 

Index: java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java
===================================================================
--- java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java	(revision 4443)
+++ java/com/l2jserver/gameserver/model/actor/instance/L2PcInstance.java	(working copy)
@@ -289,7 +289,7 @@
	// Character Character SQL String Definitions:
	private static final String INSERT_CHARACTER = "INSERT INTO characters (account_name,charId,char_name,level,maxHp,curHp,maxCp,curCp,maxMp,curMp,face,hairStyle,hairColor,sex,exp,sp,karma,fame,pvpkills,pkkills,clanid,race,classid,deletetime,cancraft,title,title_color,accesslevel,online,isin7sdungeon,clan_privs,wantspeace,base_class,newbie,nobless,power_grade,createTime) values (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
	private static final String UPDATE_CHARACTER = "UPDATE characters SET level=?,maxHp=?,curHp=?,maxCp=?,curCp=?,maxMp=?,curMp=?,face=?,hairStyle=?,hairColor=?,sex=?,heading=?,x=?,y=?,z=?,exp=?,expBeforeDeath=?,sp=?,karma=?,fame=?,pvpkills=?,pkkills=?,clanid=?,race=?,classid=?,deletetime=?,title=?,title_color=?,accesslevel=?,online=?,isin7sdungeon=?,clan_privs=?,wantspeace=?,base_class=?,onlinetime=?,punish_level=?,punish_timer=?,newbie=?,nobless=?,power_grade=?,subpledge=?,lvl_joined_academy=?,apprentice=?,sponsor=?,varka_ketra_ally=?,clan_join_expiry_time=?,clan_create_expiry_time=?,char_name=?,death_penalty_level=?,bookmarkslot=?,vitality_points=?,language=? WHERE charId=?";
-	private static final String RESTORE_CHARACTER = "SELECT account_name, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, fame, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, title_color, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, punish_level, punish_timer, newbie, nobless, power_grade, subpledge, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level,bookmarkslot,vitality_points,createTime,language FROM characters WHERE charId=?";
+	private static final String RESTORE_CHARACTER = "SELECT account_name, aio, charId, char_name, level, maxHp, curHp, maxCp, curCp, maxMp, curMp, face, hairStyle, hairColor, sex, heading, x, y, z, exp, expBeforeDeath, sp, karma, fame, pvpkills, pkkills, clanid, race, classid, deletetime, cancraft, title, title_color, accesslevel, online, char_slot, lastAccess, clan_privs, wantspeace, base_class, onlinetime, isin7sdungeon, punish_level, punish_timer, newbie, nobless, power_grade, subpledge, lvl_joined_academy, apprentice, sponsor, varka_ketra_ally,clan_join_expiry_time,clan_create_expiry_time,death_penalty_level,bookmarkslot,vitality_points,createTime,language FROM characters WHERE charId=?";

	// Character Teleport Bookmark:
	private static final String INSERT_TP_BOOKMARK = "INSERT INTO character_tpbookmark (charId,Id,x,y,z,icon,tag,name) values (?,?,?,?,?,?,?,?)";
@@ -7163,6 +7163,7 @@
				player.setOnlineTime(rset.getLong("onlinetime"));
				player.setNewbie(rset.getInt("newbie"));
				player.setNoble(rset.getInt("nobless")==1);
+				player.setAIO(rset.getInt("aio") == 1);

				player.setClanJoinExpiryTime(rset.getLong("clan_join_expiry_time"));
				if (player.getClanJoinExpiryTime() < System.currentTimeMillis())
@@ -15095,4 +15096,16 @@
		// Maintain = 1
		return 0;
	}
+	
+	private boolean _AOIBuffer = false;
+	
+	public void setAIO(boolean aio)
+	{
+		_AOIBuffer = aio;
+	}
+	
+	public boolean isAIO()
+	{
+		return _AOIBuffer;
+	}
}

Index: data/scripts/handlers/MasterHandler.java
===================================================================
--- data/scripts/handlers/MasterHandler.java	(revision 7689)
+++ data/scripts/handlers/MasterHandler.java	(working copy)
@@ -30,6 +30,7 @@
import handlers.actionhandlers.L2SummonAction;
import handlers.actionhandlers.L2SummonActionShift;
import handlers.actionhandlers.L2TrapAction;
+import handlers.admincommandhandlers.AdminAIO;
import handlers.admincommandhandlers.AdminAdmin;
import handlers.admincommandhandlers.AdminAnnouncements;
import handlers.admincommandhandlers.AdminBBS;
@@ -297,6 +298,7 @@

	private static void loadAdminHandlers()
	{
+		AdminCommandHandler.getInstance().registerAdminCommandHandler(new AdminAIO());
		AdminCommandHandler.getInstance().registerAdminCommandHandler(new AdminAdmin());
		AdminCommandHandler.getInstance().registerAdminCommandHandler(new AdminAnnouncements());
		AdminCommandHandler.getInstance().registerAdminCommandHandler(new AdminBan());
Index: data/scripts/handlers/admincommandhandlers/AdminAIO.java
===================================================================
--- data/scripts/handlers/admincommandhandlers/AdminAIO.java	(revision 0)
+++ data/scripts/handlers/admincommandhandlers/AdminAIO.java	(revision 0)
@@ -0,0 +1,266 @@
+/*
+ * This program is free software: you can redistribute it and/or modify it under
+ * the terms of the GNU General Public License as published by the Free Software
+ * Foundation, either version 3 of the License, or (at your option) any later
+ * version.
+ * 
+ * This program is distributed in the hope that it will be useful, but WITHOUT
+ * ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS
+ * FOR A PARTICULAR PURPOSE. See the GNU General Public License for more
+ * details.
+ * 
+ * You should have received a copy of the GNU General Public License along with
+ * this program. If not, see <http://www.gnu.org/licenses/>.
+ */
+package handlers.admincommandhandlers;
+
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.util.logging.Level;
+import java.util.logging.Logger;
+
+import com.l2jserver.L2DatabaseFactory;
+import com.l2jserver.gameserver.datatables.SkillTable;
+import com.l2jserver.gameserver.handler.IAdminCommandHandler;
+import com.l2jserver.gameserver.model.L2Object;
+import com.l2jserver.gameserver.model.L2Skill;
+import com.l2jserver.gameserver.model.actor.instance.L2PcInstance;
+
+public class AdminAIO implements IAdminCommandHandler
+{
+	private static Logger _log = Logger.getLogger(AdminAIO.class.getName());
+	
+	private static final String[] ADMIN_COMMANDS = { "admin_addaio", "admin_removeaio" };
+	
+	public boolean useAdminCommand(String command, L2PcInstance activeChar)
+	{
+		if (command.startsWith("admin_addaio"))
+		{
+			L2Object target = activeChar.getTarget();
+			L2PcInstance player = null;
+			if (target == null)
+			{
+				return false;
+			}
+			
+			if (target instanceof L2PcInstance)
+			{
+				player = (L2PcInstance) target;
+			}
+			else
+			{
+				return false;
+			}
+			
+			if (!player.isAIO())
+			{
+				player.setAIO(true);
+				System.out.println(player.getObjectId());
+				handleAIOadd(player);
+				activeChar.sendMessage("You gave AIO Status to: " + target.getName());
+				player.sendMessage("You are an AIO now, Congratulations!");
+				_log.fine("[GM]" + activeChar.getName() + " gave AIO Status to " + player.getName() + "( " + player.getObjectId() + " ).");
+				Connection con = null;
+				try
+				{
+					con = L2DatabaseFactory.getInstance().getConnection();
+					
+					PreparedStatement statement = con.prepareStatement("UPDATE characters SET aio = 1 WHERE charId = ?");
+					statement.setInt(1, player.getObjectId());
+					statement.execute();
+					statement.close();
+				}
+				catch (Exception e)
+				{
+					_log.log(Level.WARNING, "Could not set AIO stats of char:", e);
+				}
+				finally
+				{
+					L2DatabaseFactory.close(con);
+				}
+			}
+			else
+			{
+				activeChar.sendMessage(target.getName() + ": Already have AIO Stats.");
+			}
+		}
+		else if (command.startsWith("admin_removeaio"))
+		{
+			L2Object target = activeChar.getTarget();
+			L2PcInstance player = null;
+			
+			if (target == null)
+			{
+				return false;
+			}
+			
+			if (target instanceof L2PcInstance)
+			{
+				player = (L2PcInstance) target;
+			}
+			else
+			{
+				return false;
+			}
+			
+			if (player.isAIO())
+			{
+				player.setAIO(false);
+				handleAIOremove(player);
+				activeChar.sendMessage(target.getName() + " has lost the AIO Status.");
+				player.sendMessage("You are no longer an AIO.");
+				_log.fine("[GM]" + activeChar.getName() + " removed AIO Status from " + player.getName() + "( " + player.getObjectId() + " ).");
+				
+				Connection con = null;
+				try
+				{
+					con = L2DatabaseFactory.getInstance().getConnection();
+					
+					PreparedStatement statement = con.prepareStatement("UPDATE characters SET aio = 0 WHERE charId = ?");
+					statement.setInt(1, player.getObjectId());
+					statement.execute();
+					statement.close();
+				}
+				catch (Exception e)
+				{
+					_log.log(Level.WARNING, "Could not set AIO status on char:", e);
+				}
+				finally
+				{
+					L2DatabaseFactory.close(con);
+				}
+			}
+			else
+			{
+				activeChar.sendMessage(target.getName() + ": Doesn't have AIO Status.");
+			}
+		}
+		return true;
+	}
+	
+	public void handleAIOadd(L2PcInstance player)
+	{
+		player.addSkill(SkillTable.getInstance().getInfo(5491, 1), true); //Decrease Bow/Crossbow Atk. Spd.
+		player.addSkill(SkillTable.getInstance().getInfo(58, 55), true);//Elemental Heal
+		player.addSkill(SkillTable.getInstance().getInfo(141, 3), true);//Weapon Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(142, 5), true);//Armor Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(163, 1), true);//Spellcraft
+		player.addSkill(SkillTable.getInstance().getInfo(164, 3), true);//Quick Recycle
+		player.addSkill(SkillTable.getInstance().getInfo(213, 8), true);//Boost Mana
+		player.addSkill(SkillTable.getInstance().getInfo(214, 1), true);//Mana Recovery
+		player.addSkill(SkillTable.getInstance().getInfo(228, 3), true);//Fast Spell Casting
+		player.addSkill(SkillTable.getInstance().getInfo(229, 7), true);//Fast Mana Recovery
+		player.addSkill(SkillTable.getInstance().getInfo(234, 41), true);//Robe Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(235, 41), true);//Robe Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(244, 3), true);//Armor Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(249, 42), true);//Weapon Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(264, 1), true);//Song of Earth
+		player.addSkill(SkillTable.getInstance().getInfo(265, 1), true);//Song of Life
+		player.addSkill(SkillTable.getInstance().getInfo(266, 1), true);//Song of Water
+		player.addSkill(SkillTable.getInstance().getInfo(267, 1), true);//Song of Warding
+		player.addSkill(SkillTable.getInstance().getInfo(268, 1), true);//Song of Wind
+		player.addSkill(SkillTable.getInstance().getInfo(269, 1), true);//Song of Hunter
+		player.addSkill(SkillTable.getInstance().getInfo(270, 1), true);//Song of Invocation
+		player.addSkill(SkillTable.getInstance().getInfo(271, 1), true);//Dance of the Warrior
+		player.addSkill(SkillTable.getInstance().getInfo(272, 1), true);//Dance of Inspiration
+		player.addSkill(SkillTable.getInstance().getInfo(273, 1), true);//Dance of the Mystic
+		player.addSkill(SkillTable.getInstance().getInfo(274, 1), true);//Dance of Fire
+		player.addSkill(SkillTable.getInstance().getInfo(275, 1), true);//Dance of Fury
+		player.addSkill(SkillTable.getInstance().getInfo(276, 1), true);//Dance of Concentration
+		player.addSkill(SkillTable.getInstance().getInfo(277, 1), true);//Dance of Light
+		player.addSkill(SkillTable.getInstance().getInfo(285, 27), true);//Higher Mana Gain
+		player.addSkill(SkillTable.getInstance().getInfo(304, 1), true);//Song of Vitality
+		player.addSkill(SkillTable.getInstance().getInfo(305, 1), true);//Song of Vengeance
+		player.addSkill(SkillTable.getInstance().getInfo(306, 1), true);//Song of Flame Guard
+		player.addSkill(SkillTable.getInstance().getInfo(307, 1), true);//Dance of Aqua Guard
+		player.addSkill(SkillTable.getInstance().getInfo(308, 1), true);//Song of Storm Guard
+		player.addSkill(SkillTable.getInstance().getInfo(309, 1), true);//Dance of Earth Guard
+		player.addSkill(SkillTable.getInstance().getInfo(310, 1), true);//Dance of the Vampire
+		player.addSkill(SkillTable.getInstance().getInfo(311, 1), true);//Dance of Protection
+		player.addSkill(SkillTable.getInstance().getInfo(329, 1), true);//Health
+		player.addSkill(SkillTable.getInstance().getInfo(331, 1), true);//Skill Mastery
+		player.addSkill(SkillTable.getInstance().getInfo(349, 1), true);//Song of Renewal
+		player.addSkill(SkillTable.getInstance().getInfo(363, 1), true);//Song of Meditation
+		player.addSkill(SkillTable.getInstance().getInfo(364, 1), true);//Song of Champion
+		player.addSkill(SkillTable.getInstance().getInfo(365, 1), true);//Siren's Dance
+		player.addSkill(SkillTable.getInstance().getInfo(366, 1), true);//Dance of Shadows
+		player.addSkill(SkillTable.getInstance().getInfo(367, 1), true);//Dance of Medusa
+		player.addSkill(SkillTable.getInstance().getInfo(437, 1), true);//Song of Silence
+		player.addSkill(SkillTable.getInstance().getInfo(1011, 18), true);//Heal
+		player.addSkill(SkillTable.getInstance().getInfo(1013, 32), true);//Recharge
+		player.addSkill(SkillTable.getInstance().getInfo(1016, 9), true);//Resurrection
+		player.addSkill(SkillTable.getInstance().getInfo(1027, 15), true);//Group Heal
+		player.addSkill(SkillTable.getInstance().getInfo(1032, 3), true);//Invigor
+		player.addSkill(SkillTable.getInstance().getInfo(1035, 4), true);//Mental Shield
+		player.addSkill(SkillTable.getInstance().getInfo(1036, 2), true);//Magic Barrier
+		player.addSkill(SkillTable.getInstance().getInfo(1040, 3), true);//Shield
+		player.addSkill(SkillTable.getInstance().getInfo(1044, 3), true);//Regeneration
+		player.addSkill(SkillTable.getInstance().getInfo(1045, 6), true);//Blessed Body
+		player.addSkill(SkillTable.getInstance().getInfo(1047, 4), true);//Mana Regeneration
+		player.addSkill(SkillTable.getInstance().getInfo(1048, 6), true);//Blessed Soul
+		player.addSkill(SkillTable.getInstance().getInfo(1059, 3), true);//Empower
+		player.addSkill(SkillTable.getInstance().getInfo(1062, 2), true);//Berserker Spirit
+		player.addSkill(SkillTable.getInstance().getInfo(1068, 3), true);//Might
+		player.addSkill(SkillTable.getInstance().getInfo(1069, 42), true);//Sleep
+		player.addSkill(SkillTable.getInstance().getInfo(1077, 3), true);//Focus
+		player.addSkill(SkillTable.getInstance().getInfo(1078, 6), true);//Concentration
+		player.addSkill(SkillTable.getInstance().getInfo(1085, 3), true);//Acumen
+		player.addSkill(SkillTable.getInstance().getInfo(1086, 2), true);//Haste
+		player.addSkill(SkillTable.getInstance().getInfo(1087, 3), true);//Agility
+		player.addSkill(SkillTable.getInstance().getInfo(1126, 6), true);//Servitor Recharge
+		player.addSkill(SkillTable.getInstance().getInfo(1127, 12), true);//Servitor Heal
+		player.addSkill(SkillTable.getInstance().getInfo(1204, 2), true);//Wind Walk
+		player.addSkill(SkillTable.getInstance().getInfo(1217, 33), true);//Greater Heal
+		player.addSkill(SkillTable.getInstance().getInfo(1218, 33), true);//Greater Battle Heal
+		player.addSkill(SkillTable.getInstance().getInfo(1219, 33), true);//Greater Group Heal
+		player.addSkill(SkillTable.getInstance().getInfo(1240, 3), true);//Guidance
+		player.addSkill(SkillTable.getInstance().getInfo(1242, 3), true);//Death Whisper
+		player.addSkill(SkillTable.getInstance().getInfo(1243, 6), true);//Bless Shield
+		player.addSkill(SkillTable.getInstance().getInfo(1254, 6), true);//Mass Resurrection
+		player.addSkill(SkillTable.getInstance().getInfo(1257, 3), true);//Decrease Weight
+		player.addSkill(SkillTable.getInstance().getInfo(1258, 4), true);//Restore Life
+		player.addSkill(SkillTable.getInstance().getInfo(1259, 4), true);//Resist Shock
+		player.addSkill(SkillTable.getInstance().getInfo(1268, 4), true);//Vampiric Rage
+		player.addSkill(SkillTable.getInstance().getInfo(1303, 2), true);//Wild Magic
+		player.addSkill(SkillTable.getInstance().getInfo(1304, 3), true);//Advanced Block
+		player.addSkill(SkillTable.getInstance().getInfo(1311, 6), true);//Body of Avatar
+		player.addSkill(SkillTable.getInstance().getInfo(1323, 1), true);//Noblesse Blessing
+		player.addSkill(SkillTable.getInstance().getInfo(1355, 1), true);//Prophecy of Water
+		player.addSkill(SkillTable.getInstance().getInfo(1356, 1), true);//Prophecy of Fire
+		player.addSkill(SkillTable.getInstance().getInfo(1357, 1), true);//Prophecy of Wind
+		player.addSkill(SkillTable.getInstance().getInfo(1363, 1), true);//Chant of Victory
+		player.addSkill(SkillTable.getInstance().getInfo(1388, 3), true);//Greater Might
+		player.addSkill(SkillTable.getInstance().getInfo(1389, 3), true);//Greater Shield
+		player.addSkill(SkillTable.getInstance().getInfo(1425, 1), true);//Purification Field
+		player.addSkill(SkillTable.getInstance().getInfo(4699, 12), true);//Blessing of Queen
+		player.addSkill(SkillTable.getInstance().getInfo(4703, 12), true);//Gift of Seraphim
+		player.addSkill(SkillTable.getInstance().getInfo(1476, 3), true);//Appetite for Destruction
+		player.addSkill(SkillTable.getInstance().getInfo(1479, 3), true);//Magic Impulse
+		player.addSkill(SkillTable.getInstance().getInfo(1478, 3), true);//Protection Instinct
+		player.sendSkillList();
+		player.broadcastUserInfo();
+	}
+	
+	public void handleAIOremove(L2PcInstance player)
+	{
+		//What if the player is buffer and we remove one of it's own skills?
+		//Let's remove all skills and give it all the skills up to it's level
+		for (L2Skill skill : player.getAllSkills())
+		{
+			player.removeSkill(skill);
+		}
+		player.giveAvailableSkills();
+		player.sendSkillList();
+		player.broadcastUserInfo();
+	}
+	
+	public String[] getAdminCommandList()
+	{
+		return ADMIN_COMMANDS;
+	}
+}

 

 

the enxt code are for the aio buffers can not paricipate for olympiad macth:

-		if (noble.getKarma() > 0)
-		{
-       	noble.sendMessage("You can't participate to Olympiad with karma.");
-        	return false;
-               }
+
+		if (noble.isgold())
+		{
+			noble.sendMessage("You can't paricipaate because you are AIO Buffer");
+		}

 

 

here is sql for update mysql for is same with code....

 

if you know how youc an add more box in tables you don't want this sql..

ALTER TABLE `characters` ADD `aio` TINYINT NOT NULL DEFAULT '0' AFTER `account_name`;
INSERT INTO `l2jdb`.`admin_command_access_rights` (`adminCommand`,`accessLevels`,`confirmDlg`)
VALUES
('admin_addaio', '1', 'false'),
('admin_removeaio', '1', 'false');

 

 

 

If you want more help with sql post here..

 

Edited January 10, 2023 by Vision

[Matim]

Read section rules.

 

Edit your thread and add proper [TAG] in your topic title.

 

Otherwise I will lock it.

[crazyshock]

thanks, possible for vip?

[ArkeyWave]

thanks, possible for vip?

 

WTF!?

 

Anyway .. Thanks for sharing ... i found this on L2JFrozen Pack, but skill list for AIO player was able to be edited in config files ;)

[Eimanto]

He's offering to make the files only for V.I.P. users of maxcheaters forum.

 

Um, this AIO buffer is only for AIO based servers. Or it would work on, for example, acis/teon/equal?

[Madboy]

He's offering to make the files only for V.I.P. users of maxcheaters forum.

 

Um, this AIO buffer is only for AIO based servers. Or it would work on, for example, acis/teon/equal?

 

AIO based servers? Do you know what is a aio buffer?

 

 

 

Anyway nice share is usefull for low rates server. and thanks again for share!

[Eimanto]

AIO based servers? Do you know what is a aio buffer?

 

 

 

Anyway nice share is usefull for low rates server. and thanks again for share!

 

Doh..

 

Aio= All in one yeah? Just misunderstood the function of it, because of bad information of my native language forums;]

[paparas21]

this aio system it doesn't work for l2jserver interlude

[bobzih]

In L2JBlack, already contain this L2JBlack Pack Aio Configs for more with the owner himself can modify the skill very good: D

[l2phanton]

Work in the last revision of l2jserver ?

[vampir]

cant u just check it?

[bjorkker02]

Tyvm Prince*

Based on this code, I also managed to lock my AIOs going out of towns !

[CarmineAngelo]

tested and doesn't work.

[bobzih]

from what I saw in the code but it works perfectly

[saunier]

yes it works