Mensajes recientes

Páginas: [1] 2 3 ... 10
1
Equipo de Soporte / Re:java10
« Último mensaje por swarlog en Octubre 17, 2019, 05:19:15 pm »
You are not allowed to view links. Register or Login
hola donde puedo descargar el java 10 pero el exe para instalar diretamente

You are not allowed to view links. Register or Login
2
Equipo de Soporte / java10
« Último mensaje por matyjo300 en Octubre 16, 2019, 07:43:03 pm »
hola donde puedo descargar el java 10 pero el exe para instalar diretamente
3
Objetos y equipos / Re:CriticalError Compilation Pack (C4-Interlude-CT2.3-CT2.5)
« Último mensaje por lantus en Octubre 15, 2019, 05:58:45 pm »
Broken link. Can u re-share?
4
Comandos / Re:[IMP] Cambiar contraseña del jugador con comandos
« Último mensaje por wazarro en Septiembre 29, 2019, 06:21:58 pm »
Se podra modificar para que cambie el PIN code

Este es mi SQL
Código: You are not allowed to view links. Register or Login
DROP TABLE IF EXISTS `characters`;
CREATE TABLE `characters`  (
  `account_name` varchar(45) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `obj_Id` decimal(11, 0) NOT NULL DEFAULT 0,
  `char_name` varchar(35) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL,
  `level` decimal(11, 0) NULL DEFAULT NULL,
  `maxHp` decimal(11, 0) NULL DEFAULT 1,
  `curHp` decimal(18, 0) NULL DEFAULT 1,
  `maxCp` decimal(11, 0) NULL DEFAULT 1,
  `curCp` decimal(18, 0) NULL DEFAULT 1,
  `maxMp` decimal(11, 0) NULL DEFAULT 1,
  `curMp` decimal(18, 0) NULL DEFAULT 1,
  `acc` decimal(11, 0) NULL DEFAULT NULL,
  `crit` decimal(10, 0) NULL DEFAULT NULL,
  `evasion` decimal(11, 0) NULL DEFAULT NULL,
  `mAtk` decimal(11, 0) NULL DEFAULT NULL,
  `mDef` decimal(11, 0) NULL DEFAULT NULL,
  `mSpd` decimal(11, 0) NULL DEFAULT NULL,
  `pAtk` decimal(11, 0) NULL DEFAULT NULL,
  `pDef` decimal(11, 0) NULL DEFAULT NULL,
  `pSpd` decimal(11, 0) NULL DEFAULT NULL,
  `runSpd` decimal(11, 0) NULL DEFAULT NULL,
  `walkSpd` decimal(11, 0) NULL DEFAULT NULL,
  `str` decimal(11, 0) NULL DEFAULT NULL,
  `con` decimal(11, 0) NULL DEFAULT NULL,
  `dex` decimal(11, 0) NULL DEFAULT NULL,
  `_int` decimal(11, 0) NULL DEFAULT NULL,
  `men` decimal(11, 0) NULL DEFAULT NULL,
  `wit` decimal(11, 0) NULL DEFAULT NULL,
  `face` decimal(11, 0) NULL DEFAULT NULL,
  `hairStyle` decimal(11, 0) NULL DEFAULT NULL,
  `hairColor` decimal(11, 0) NULL DEFAULT NULL,
  `sex` decimal(11, 0) NULL DEFAULT NULL,
  `heading` decimal(11, 0) NULL DEFAULT NULL,
  `x` decimal(11, 0) NULL DEFAULT NULL,
  `y` decimal(11, 0) NULL DEFAULT NULL,
  `z` decimal(11, 0) NULL DEFAULT NULL,
  `movement_multiplier` decimal(9, 8) NULL DEFAULT NULL,
  `attack_speed_multiplier` decimal(10, 9) NULL DEFAULT NULL,
  `colRad` decimal(10, 3) NULL DEFAULT NULL,
  `colHeight` decimal(10, 3) NULL DEFAULT NULL,
  `exp` decimal(20, 0) NULL DEFAULT NULL,
  `expBeforeDeath` decimal(20, 0) NULL DEFAULT 0,
  `sp` decimal(11, 0) NULL DEFAULT NULL,
  `karma` decimal(11, 0) NULL DEFAULT NULL,
  `pvpkills` decimal(11, 0) NULL DEFAULT NULL,
  `pkkills` decimal(11, 0) NULL DEFAULT NULL,
  `clanid` decimal(11, 0) NULL DEFAULT NULL,
  `maxload` decimal(11, 0) NULL DEFAULT NULL,
  `race` decimal(11, 0) NULL DEFAULT NULL,
  `classid` decimal(11, 0) NULL DEFAULT NULL,
  `base_class` int(2) NOT NULL DEFAULT 0,
  `deletetime` decimal(20, 0) NULL DEFAULT NULL,
  `cancraft` decimal(11, 0) NULL DEFAULT NULL,
  `title` varchar(16) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL,
  `rec_have` int(3) NOT NULL DEFAULT 0,
  `rec_left` int(3) NOT NULL DEFAULT 0,
  `accesslevel` decimal(4, 0) NULL DEFAULT NULL,
  `online` decimal(1, 0) NULL DEFAULT NULL,
  `onlinetime` decimal(20, 0) NULL DEFAULT NULL,
  `char_slot` decimal(1, 0) NULL DEFAULT NULL,
  `newbie` decimal(1, 0) NULL DEFAULT 1,
  `lastAccess` decimal(20, 0) NULL DEFAULT NULL,
  `clan_privs` int(11) NULL DEFAULT 0,
  `wantspeace` decimal(1, 0) NULL DEFAULT 0,
  `isin7sdungeon` decimal(1, 0) NOT NULL DEFAULT 0,
  `punish_level` int(3) UNSIGNED NOT NULL DEFAULT 0,
  `punish_timer` int(10) UNSIGNED NOT NULL DEFAULT 0,
  `power_grade` decimal(11, 0) NULL DEFAULT NULL,
  `nobless` decimal(1, 0) NOT NULL DEFAULT 0,
  `subpledge` int(1) NOT NULL DEFAULT 0,
  `last_recom_date` decimal(20, 0) NOT NULL DEFAULT 0,
  `lvl_joined_academy` int(1) NOT NULL DEFAULT 0,
  `apprentice` int(1) NOT NULL DEFAULT 0,
  `sponsor` int(1) NOT NULL DEFAULT 0,
  `varka_ketra_ally` int(1) NOT NULL DEFAULT 0,
  `clan_join_expiry_time` decimal(20, 0) NOT NULL DEFAULT 0,
  `clan_create_expiry_time` decimal(20, 0) NOT NULL DEFAULT 0,
  `death_penalty_level` int(2) NOT NULL DEFAULT 0,
  `pc_point` int(5) NOT NULL DEFAULT 0,
  `name_color` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '\0\0\0',
  `title_color` varchar(8) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL DEFAULT '\0\0\0',
  `first_log` int(11) NULL DEFAULT 1,
  `aio` decimal(1, 0) NOT NULL DEFAULT 0,
  `aio_end` decimal(20, 0) NOT NULL DEFAULT 0,
  `arena_wins` decimal(1, 0) NOT NULL DEFAULT 0,
  `arena_defeats` decimal(1, 0) NOT NULL DEFAULT 0,
  `VoteTimeReward` decimal(20, 0) NOT NULL DEFAULT 0,
  `pin` int(4) NULL DEFAULT NULL,
  `pinsubmited` int(1) NULL DEFAULT 1,
  PRIMARY KEY (`obj_Id`) USING BTREE,
  INDEX `clanid`(`clanid`) USING BTREE
) ENGINE = MyISAM CHARACTER SET = latin1 COLLATE = latin1_swedish_ci ROW_FORMAT = Dynamic;

Y este es mi intento por modificarlo T.T

Código: You are not allowed to view links. Register or Login
/*
 * 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 com.l2jfrozen.gameserver.handler.voicedcommandhandlers;

import java.security.MessageDigest;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.util.StringTokenizer;

import com.l2jfrozen.crypt.Base64;
import com.l2jfrozen.util.database.L2DatabaseFactory;
import com.l2jfrozen.gameserver.handler.IVoicedCommandHandler;
import com.l2jfrozen.gameserver.model.actor.instance.L2PcInstance;
import com.l2jfrozen.gameserver.network.serverpackets.ExShowScreenMessage;

/*
 * @Author: Unknow
 */

public class ChangePin implements IVoicedCommandHandler
{
private static final String[] _voicedCommands =
{
"changepin"
};

@Override
public boolean useVoicedCommand(String command, L2PcInstance activeChar, String target)
{
if(command.equalsIgnoreCase("ChangePin") && target != null)
{
StringTokenizer st = new StringTokenizer(target);
try
{
String curpass = null, newpass = null, repeatnewpass = null;

if(st.hasMoreTokens())
curpass = st.nextToken();
if(st.hasMoreTokens())
newpass = st.nextToken();
if(st.hasMoreTokens())
repeatnewpass = st.nextToken();

if(!(curpass == null || newpass == null || repeatnewpass == null))
{
if(!newpass.equals(repeatnewpass))
{
activeChar.sendMessage("The new pin doesn't match with the repeated one!");
return false;
}
if(newpass.length() < 4)
{
activeChar.sendMessage("The new pin is shorter than 4 characters! Please try with a longer one.");
return false;
}
if(newpass.length() > 25)
{
activeChar.sendMessage("The new pin is longer than 25 characters! Please try with a shorter one.");
return false;
}

MessageDigest md = MessageDigest.getInstance("SHA");

byte[] raw = curpass.getBytes("UTF-8");
raw = md.digest(raw);
String curpassEnc = Base64.encodeBytes(raw);
String pass = null;
int passUpdated = 0;

Connection con = null;
con = L2DatabaseFactory.getInstance().getConnection();
PreparedStatement statement = con.prepareStatement("SELECT pin FROM characters WHERE obj_id=?");
statement.setInt(1, activeChar.getObjectId());
ResultSet rset = statement.executeQuery();

if(rset.next())
{
pass = rset.getString("pin");
}

rset.close();
statement.close();

if(curpassEnc.equals(pass))
{
byte[] pin = newpass.getBytes("UTF-8");
pin = md.digest(pin);

PreparedStatement ps = con.prepareStatement("UPDATE characters SET pin=? WHERE obj_id=?");
ps.setInt(2, activeChar.getObjectId());
passUpdated = ps.executeUpdate();
ps.close();
con.close();

if(passUpdated > 0)
{
activeChar.sendMessage("You have successfully changed your pin!");
activeChar.sendPacket(new ExShowScreenMessage("You have successfully changed your pin!#Enjoy :)", 6000));
}
else
{
activeChar.sendMessage("The pin change was unsuccessful!");
activeChar.sendPacket(new ExShowScreenMessage("The pin change was unsuccessful!!#U_u)", 6000));
}
}
else
{
activeChar.sendMessage("CurrentPass doesn't match with your current one.");
return false;
}
}
else
{
activeChar.sendMessage("Invalida Pass data! el Formato es: .ChangePin PassActual NuevaPass ReNuevaPass");
return false;
}
}
catch(Exception e)
{
activeChar.sendMessage("A problem occured while changing pin!");
}
}
else
{
activeChar.sendMessage("To change your current pin, you have to type the command in the following format(without the brackets []): [.ChangePin CurrentPass NewPass NewPass]. You should also know that the pin is case sensitive.");
activeChar.sendPacket(new ExShowScreenMessage("To change your current pin, you have to type the command in the following format(without the brackets []):#[.ChangePin CurrentPass NewPass NewPass]. You should also know that the pin is case sensitive.)", 7000));
return false;
}

return true;
}

@Override
public String[] getVoicedCommandList()
{
return _voicedCommands;
}

}

Desde ya gracias por compartir el de .changepass
5
Listado de Servidores / L2 Hazard High Five 20x
« Último mensaje por fizzworld en Septiembre 25, 2019, 12:46:28 pm »
LINEAGE 2 Hazard
Mid-rate Lineage 2 Hazard High Five 20x server
You are not allowed to view links. Register or Login
You are not allowed to view links. Register or Login


Experience rate: 20x
Skillpoints rate: 20x
Party EXP: 2x
Party SP: 2x
Drop rate: 10x
RaidDropItems: 3x
RaidDropJewely: 1x
Spoil: 10x
Adena drop rate: 20x
Safe Enchant Scrolls: 4
Safe Enchant Scrolls: 20



Lineage 2 High Five server 20x rates, Balanced Server, Olympiad, Castle Sieges, Easy Farming. ALWAYS ONLINE. Updates every week. Join Us!
Dedicated server in Europe
Full GeoData
TVT Event (Daily, every hour), POTW Event, Last Man Standings and many other custom events
Olympiad (every 2 weeks)
Castle Sieges (every 2 weeks)
Instanced Zones with great rewards
Weapon-Type Enhance Backup Stone / Armor-Type Enhance Backup Stone (retail, until 9)
L2Day Event Manager (The Letter Collector Event with scrolls, attributes and epic jewels for rewards) - retail chances
Slash commands: /time /olympiadstat /siegestatus /duel /instancezone /unstuck

Max Buffs: 24 + 4
Max Dances/Songs: 12
Buffs time: 2 hours

Normal Enchant: 66%
Blessed Enchant: 70%
Safe enchant: +4
Max enchant: +20


Baium spawn every 5 days + 2 hours random
Valakas spawn every 6 days + 12 hours random
Antharas spawn every 6 days + 12 hours random

Weekly passive events
Discord server available for everyone - You are not allowed to view links. Register or Login
Frequent updates and daily support (via Discord, FB or Email).



You are not allowed to view links. Register or Login


--
6
Npc´s / Re:[NPC] Super Mobs
« Último mensaje por l2valhein en Septiembre 13, 2019, 10:42:04 pm »
hola buenas tardes,podrias explicarme como hacerlo funcionar en frozen? Gracias ♥
7
Eventos / Re:[Evento] Preguntas
« Último mensaje por lordofcaos en Agosto 22, 2019, 10:41:22 pm »
pregunta del evento de preguntas se tiene que crear un txt con las preguntas y otro txt con las respuestas?
8
Programas adicionales / Re:File Edit DDF!
« Último mensaje por rubiosxe en Julio 31, 2019, 11:51:43 pm »
Link OFF
9
Gracias por el aporte You are not allowed to view links. Register or Login ;)

Saludos ^^
10
Guías e instalación / Aprende a desarrollar tu propio servidor / Muchisimos videtutoriales
« Último mensaje por Reynald0 en Julio 20, 2019, 08:04:16 am »
Aqui les dejo mi canal de YouTube destinado a compartir conocimiento para que puedan desarrollar su propio servidor, es decir, modificar, crear para llevar a cabo su idea.


Tómalo como una librería de videos, afortunadamente todos los videos están en ESPAÑOL.

Canal: You are not allowed to view links. Register or Login

Nota: Si alguien de aqui quiere ir creando un post por cada tutorial de mi canal, no tengo problema. Pero para ser honesto no voy a ser esto, me llevaría bastante tiempo. Como sea, se los dejo a su alcance.
Páginas: [1] 2 3 ... 10