Paidia an mporite na me help me 2 sovara error game server console

[BlackKiss]

to proto error den xero gt me kani dsconnecte mipos den exo arketi ram exo 3 GB kai sikono game server console login server console ena l2 kai to antivirus to kaspersky mipos ftei to system den xero ginete auto kai otan katebazo to parathiro tou l2 mou skai DC

 

 

to deutero malon einai me enan code pou ebala gia to set hero code einai aftos

 

Index: /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminAdmin.java
===================================================================
--- /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminAdmin.java	(revision 40)
+++ /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminAdmin.java	(revision 45)
@@ -55,5 +55,5 @@
	private static final String[] ADMIN_COMMANDS = {"admin_admin", "admin_admin1", "admin_admin2", "admin_admin3", "admin_admin4", "admin_admin5",
		"admin_gmliston", "admin_gmlistoff", "admin_silence", "admin_diet", "admin_tradeoff", "admin_reload", "admin_set", "admin_set_menu", "admin_set_mod",
-		"admin_saveolymp", "admin_sethero", "admin_manualhero"};
+		"admin_saveolymp", "admin_manualhero"};

	private static final int REQUIRED_LEVEL = Config.GM_MENU;
@@ -102,18 +102,4 @@
			catch(Exception e){e.printStackTrace();}
			activeChar.sendMessage("olympiad stuff saved!!");
-		}
-		else if(command.startsWith("admin_sethero")){
-				L2PcInstance target = null;
-	            
-				if (activeChar.getTarget() != null && activeChar.getTarget() instanceof L2PcInstance)
-				{
-					target = (L2PcInstance)activeChar.getTarget();
-					target.setHero(target.isHero()? false : true);
-				}
-				else
-				{
-					target = activeChar;
-					target.setHero(target.isHero()? false : true);
-				}
		}
		else if(command.startsWith("admin_manualhero"))
Index: /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminHero.java
===================================================================
--- /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminHero.java	(revision 45)
+++ /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/handler/admincommandhandlers/AdminHero.java	(revision 45)
@@ -0,0 +1,132 @@
+/*
+ * 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 net.sf.l2j.gameserver.handler.admincommandhandlers;
+
+import java.sql.Connection;
+import java.sql.PreparedStatement;
+import java.sql.ResultSet;
+
+import org.apache.commons.logging.Log;
+import org.apache.commons.logging.LogFactory;
+
+import net.sf.l2j.Config;
+import net.sf.l2j.L2DatabaseFactory;
+import net.sf.l2j.gameserver.GmListTable;
+import net.sf.l2j.gameserver.handler.IAdminCommandHandler;
+import net.sf.l2j.gameserver.model.L2Object;
+import net.sf.l2j.gameserver.model.actor.instance.L2PcInstance;
+import net.sf.l2j.gameserver.network.SystemMessageId;
+import net.sf.l2j.gameserver.serverpackets.SystemMessage;
+
+public class AdminHero implements IAdminCommandHandler{
+	private static String[] _adminCommands = {"admin_sethero"};
+	private final static Log _log = LogFactory.getLog(AdminHero.class.getName());
+	private static final int REQUIRED_LEVEL = Config.GM_MENU;
+
+	public boolean useAdminCommand(String command, L2PcInstance activeChar){
+		if (!Config.ALT_PRIVILEGES_ADMIN){
+			if (!(checkLevel(activeChar.getAccessLevel()) && activeChar.isGM())){
+				return false;
+			}
+		}
+		if (command.startsWith("admin_sethero")){
+			L2Object target = activeChar.getTarget();
+			L2PcInstance player = null;
+			SystemMessage sm = new SystemMessage(SystemMessageId.S1_S2);
+			if (target instanceof L2PcInstance){
+				player = (L2PcInstance)target;
+			}else{
+				player = activeChar;
+			}
+
+			if (player.isHero()){
+				player.setHero(false);
+				sm.addString("You are no longer a server hero.");
+				GmListTable.broadcastMessageToGMs("GM "+activeChar.getName()+" removed hero stat of player"+ target.getName());
+				Connection connection = null;
+				try{
+					connection = L2DatabaseFactory.getInstance().getConnection();
+
+					PreparedStatement statement = connection.prepareStatement("SELECT obj_id FROM characters where char_name=?");
+					statement.setString(1,target.getName());
+					ResultSet rset = statement.executeQuery();
+					int objId = 0;
+					if (rset.next()){
+						objId = rset.getInt(1);
+					}
+					rset.close();
+					statement.close();
+
+					if (objId == 0) {connection.close(); return false;}
+
+					statement = connection.prepareStatement("UPDATE characters SET hero=0 WHERE obj_id=?");
+					statement.setInt(1, objId);
+					statement.execute();
+					statement.close();
+					connection.close();
+				}
+				catch (Exception e){
+					_log.warn("could not set Hero stats of char:", e);
+				}
+				finally{
+					try { connection.close(); } catch (Exception e) {}
+				}
+			}else{
+				player.setHero(true);
+				sm.addString("You are now a server Hero, Congratulations!");
+				GmListTable.broadcastMessageToGMs("GM "+activeChar.getName()+" has given Hero status to "+target.getName()+".");
+				Connection connection = null;
+				try{
+					connection = L2DatabaseFactory.getInstance().getConnection();
+
+					PreparedStatement statement = connection.prepareStatement("SELECT obj_id FROM characters where char_name=?");
+					statement.setString(1,target.getName());
+					ResultSet rset = statement.executeQuery();
+					int objId = 0;
+					if (rset.next()){
+						objId = rset.getInt(1);
+					}
+					rset.close();
+					statement.close();
+
+					if (objId == 0) {connection.close(); return false;}
+
+					statement = connection.prepareStatement("UPDATE characters SET hero=1 WHERE obj_id=?");
+					statement.setInt(1, objId);
+					statement.execute();
+					statement.close();
+					connection.close();
+				}
+				catch (Exception e){
+					_log.warn("could not set Hero stats of char:", e);
+				}
+				finally{
+					try { connection.close(); } catch (Exception e) {}
+				}
+
+			}
+			player.sendPacket(sm);
+			player.broadcastUserInfo();
+			if(player.isHero() == true){}
+		}
+		return false;
+	}
+   public String[] getAdminCommandList() {
+		return _adminCommands;
+	}
+	private boolean checkLevel(int level){
+		return (level >= REQUIRED_LEVEL);
+	}
+}
Index: /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/GameServer.java
===================================================================
--- /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/GameServer.java	(revision 30)
+++ /trunk/L2J_Gameserver/java/net/sf/l2j/gameserver/GameServer.java	(revision 45)
@@ -92,4 +92,5 @@
import net.sf.l2j.gameserver.handler.admincommandhandlers.AdminHeal;
import net.sf.l2j.gameserver.handler.admincommandhandlers.AdminHelpPage;
+import net.sf.l2j.gameserver.handler.admincommandhandlers.AdminHero;
import net.sf.l2j.gameserver.handler.admincommandhandlers.AdminInvul;
import net.sf.l2j.gameserver.handler.admincommandhandlers.AdminKick;
@@ -529,4 +530,5 @@
		_adminCommandHandler.registerAdminCommandHandler(new AdminHeal());
		_adminCommandHandler.registerAdminCommandHandler(new AdminHelpPage());
+		_adminCommandHandler.registerAdminCommandHandler(new AdminHero());
		_adminCommandHandler.registerAdminCommandHandler(new AdminShutdown());
		_adminCommandHandler.registerAdminCommandHandler(new AdminSpawn());

[A√imas†i©™]

file m nomize dn exei simasia autos o kodikas giati to error vgenei sth sintaksi apo mysql gia ksanakane install thn DB sou h kane ena backup pou eixes...

an exeis pragmata mesa pou dn 8es na xa8oune kane ena backup kane 3ana install thn DB des an anigei kai meta perna sigkekrimena templates apo to backup

 

[Flash™]

file mou  ayto to error  sto bgazei gia ton logo oti  exeis  3exasei na baleis  to 'hero'  sto characters.sql

 

oriste kai to java code pou to exei mesa kai den to briskh  kai sou to bgazei to error

 

tatement = connection.prepareStatement("UPDATE characters SET hero=0 WHERE obj_id=?");

 

---

diladi  mporeis na kaneis to e3eis na peraseis ayto edw

 

ALTER TABLE `characters` ADD `hero` TINYINT NOT NULL DEFAULT '0' AFTER `nobless`;

 

kai na eisai ok

[A√imas†i©™]

file mou  ayto to error  sto bgazei gia ton logo oti  exeis  3exasei na baleis  to 'hero'  sto characters.sql

 

oriste kai to java code pou to exei mesa kai den to briskh  kai sou to bgazei to error

 

tatement = connection.prepareStatement("UPDATE characters SET hero=0 WHERE obj_id=?");

 

---

diladi  mporeis na kaneis to e3eis na peraseis ayto edw

 

ALTER TABLE `characters` ADD `hero` TINYINT NOT NULL DEFAULT '0' AFTER `nobless`;

 

kai na eisai ok

ontws nomiza oti 8a to eixe apo mono tou alla ekana la8os ... :D

[BlackKiss]

file Flash™ apla se proskinao me ekanes theo epiase to perasa mesa sta sql ton code kai to ekana execute sql files file apla proskino

elega tha mou eperne 20 meres psaxnontas :P kai pali se afxaristo kai ton panos9999 pou asxolithike me tin lisi tou problimatos pou ixa

ALA FILE NA SE ROTISO KAI KATI ALO TO 1 ERROR APO TI LETE NA MOU PETAI DC OTAN EIMAI MESA STO L2 MOU PETAI DC OTAN KATEBAZO TO PARATHIRO MOU PETAI DC KAI SE NET OXI MONO STO PC MOU TI PREPI NA PROKALI TO DC AA NAI EXO KANI KAI POLYMORPH SYSTEM LETE GIA AFTO NA MOU PETAI DC I NA EINAI TO SYSTEM TOU L2

[FighterBoss]

file Flash™ apla se proskinao me ekanes theo epiase to perasa mesa sta sql ton code kai to ekana execute sql files file apla proskino

elega tha mou eperne 20 meres psaxnontas :P kai pali se afxaristo kai ton panos9999 pou asxolithike me tin lisi tou problimatos pou ixa

ALA FILE NA SE ROTISO KAI KATI ALO TO 1 ERROR APO TI LETE NA MOU PETAI DC OTAN EIMAI MESA STO L2 MOU PETAI DC OTAN KATEBAZO TO PARATHIRO MOU PETAI DC KAI SE NET OXI MONO STO PC MOU TI PREPI NA PROKALI TO DC AA NAI EXO KANI KAI POLYMORPH SYSTEM LETE GIA AFTO NA MOU PETAI DC I NA EINAI TO SYSTEM TOU L2

Είσαι κάτι φταίει από το client σου και πετάει dc.

Ξανακάνε το download καλύτερα..