Jump to content

Recommended Posts

Posted

fixed. change this 

CREATE TABLE [dbo].[user_account](
	[uid] [int] IDENTITY(1,1) NOT NULL,
	[account] [varchar](14) NOT NULL,
	[pay_stat] [smallint] NOT NULL CONSTRAINT [DF_user_account__pay_stat]  DEFAULT ((0)),
	[login_flag] [int] NOT NULL CONSTRAINT [DF_user_account__login_flag]  DEFAULT ((0)),
	[warn_flag] [int] NOT NULL CONSTRAINT [DF_user_account__warn_flag]  DEFAULT ((0)),
	[block_flag] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag]  DEFAULT ((0)),
	[block_flag2] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag2]  DEFAULT ((0)),
	[last_login] [datetime] NULL,
	[confirmation] [varchar] (15) NULL,
	[last_logout] [datetime] NULL,
	[subscription_flag] [int] NOT NULL CONSTRAINT [DF_user_account_subscription_flag]  DEFAULT ((0)),
	[last_game] [int] NULL,
	[last_world] [int] NULL,
	[last_ip] [varchar](15) NULL,
	[block_end_date] [datetime] NULL,
	[forbidden_servers] [binary](16) NULL CONSTRAINT [DF_user_account_forbidden_servers]  DEFAULT ((0)),
	[email] [varchar] (50) NOT NULL DEFAULT 'invalid@email.com',
	[mask] [varchar] (15) NOT NULL DEFAULT '*'
 CONSTRAINT [PK_user_account] PRIMARY KEY CLUSTERED 
(
	[account] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
 CONSTRAINT [UQ_user_account_uid] UNIQUE NONCLUSTERED 
(
	[uid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] 

to this:

CREATE TABLE [dbo].[user_account](
	[uid] [int] IDENTITY(1,1) NOT NULL,
  [account] varchar(14) COLLATE Korean_Wansung_CI_AS NOT NULL,
	[pay_stat] [smallint] NOT NULL CONSTRAINT [DF_user_account__pay_stat]  DEFAULT ((0)),
	[login_flag] [int] NOT NULL CONSTRAINT [DF_user_account__login_flag]  DEFAULT ((0)),
	[warn_flag] [int] NOT NULL CONSTRAINT [DF_user_account__warn_flag]  DEFAULT ((0)),
	[block_flag] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag]  DEFAULT ((0)),
	[block_flag2] [int] NOT NULL CONSTRAINT [DF_user_account__block_flag2]  DEFAULT ((0)),
	[last_login] [datetime] NULL,
	[confirmation] [varchar] (15) NULL,
	[last_logout] [datetime] NULL,
	[subscription_flag] [int] NOT NULL CONSTRAINT [DF_user_account_subscription_flag]  DEFAULT ((0)),
	[last_game] [int] NULL,
	[last_world] [int] NULL,
  [last_ip] varchar(15) COLLATE Korean_Wansung_CI_AS NULL,
	[block_end_date] [datetime] NULL,
	[forbidden_servers] [binary](16) NULL CONSTRAINT [DF_user_account_forbidden_servers]  DEFAULT ((0)),
	[email] [varchar] (50) NOT NULL DEFAULT 'invalid@email.com',
	[mask] [varchar] (15) NOT NULL DEFAULT '*'
 CONSTRAINT [PK_user_account] PRIMARY KEY CLUSTERED 
(
	[account] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY],
 CONSTRAINT [UQ_user_account_uid] UNIQUE NONCLUSTERED 
(
	[uid] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
Posted

This has nothing to do with the sql script. Charset should be the same everywhere in order to work. Propably there was a difference.

  • 2 weeks later...
  • 2 weeks later...
Posted

Has anyone had the problem of not display the page to register accounts? I only work on the login page and password recovery. Register withe page ..

  • 1 month later...
Posted

Has anyone had the problem of not display the page to register accounts? I only work on the login page and password recovery. Register withe page ..

You need mssql support on PHP. If you are on shared webhosting, you need to contact your provider. If you are at localhost, you need to install/ enable php mssql/ sybase.

  • 3 months later...
Posted (edited)

Hello, I was and I will be off for some more time. That's the reason I'm not updating the account panel. As soon as I get enough time I'll post a new version.

Btw... Seriously? Some guys selling my account panel with donation system for 100 euros? Are you kidding me?

If you are interested, soon I'll post info how to get the donation manager and vote reward system or both.

Edited by PARADISE
Posted

Hello, I was and I will be off for some more time. That's the reason I'm not updating the account panel. As soon as I get enough time I'll post a new version.

Btw... Seriously? Some guys selling my account panel with donation system for 100 euros? Are you kidding me?

If you are interested, soon I'll post info how to get the donation manager and vote reward system or both.

Please do so, many peple were trying to contact you to purchase the donation system side.

Posted (edited)

Hello, I was and I will be off for some more time. That's the reason I'm not updating the account panel. As soon as I get enough time I'll post a new version.

Btw... Seriously? Some guys selling my account panel with donation system for 100 euros? Are you kidding me?

If you are interested, soon I'll post info how to get the donation manager and vote reward system or both.

 

Well my friend, you are selling it for 100 € also..

 

 

 

------------------------------

www.l2votesystem.com

Edited by LogicalMind
Posted (edited)

I don't wanna go off topic but:

 

 

Business Contact Information 
 

Customer Service URL:  http://lineage-destiny.netpixel.gif

Amount received:   €79.00 EUR

Fee amount:   €0.00 EUR

Net amount:   €79.00 EUR

Date:   Jul 21, 2014 Time:   13:38:44 GMT+03:00

Status:    Completed

Subject: Lineage][FunFactory has just sent you €79.00 EUR with PayPal

 
 
Plus its my work, not stolen,
Edited by PARADISE
Posted

 

I don't wanna go off topic but:

 

 

Business Contact Information 

 

Customer Service URL:  http://lineage-destiny.netpixel.gif

Amount received:   €79.00 EUR

Fee amount:   €0.00 EUR

Net amount:   €79.00 EUR

Date:   Jul 21, 2014 Time:   13:38:44 GMT+03:00

Status:    Completed

Subject: Lineage][FunFactory has just sent you €79.00 EUR with PayPal

 
 
Plus its my work, not stolen,

 

it's for donation manager?

  • 2 months later...
Posted

hi guys , i have already database lin2db with all accounts , so who can use this Account manager without delete my already table "" user_account "" ? and when receive email activation and click these link to activate , nothing happens , cant log :/ ,

Posted

hi guys , i have already database lin2db with all accounts , so who can use this Account manager without delete my already table "" user_account "" ? and when receive email activation and click these link to activate , nothing happens , cant log :/ ,

alter  the table with missing columns

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now



  • Posts

    • what pack you use  send me on discord for it
    • package custom.events.RandomZoneEvent; import java.io.File; import java.util.ArrayList; import java.util.List; import java.util.Random; import java.util.concurrent.ScheduledFuture; import org.w3c.dom.Document; import org.w3c.dom.Node; import org.l2jmobius.commons.threads.ThreadPool; import org.l2jmobius.commons.time.SchedulingPattern; import org.l2jmobius.commons.time.TimeUtil; import org.l2jmobius.commons.util.IXmlReader; import org.l2jmobius.gameserver.managers.ZoneManager; import org.l2jmobius.gameserver.model.StatSet; import org.l2jmobius.gameserver.model.actor.Creature; import org.l2jmobius.gameserver.model.actor.Npc; import org.l2jmobius.gameserver.model.actor.Player; import org.l2jmobius.gameserver.model.quest.Event; import org.l2jmobius.gameserver.model.zone.ZoneId; import org.l2jmobius.gameserver.model.zone.ZoneType; import org.l2jmobius.gameserver.model.zone.type.RandomZone; import org.l2jmobius.gameserver.util.Broadcast; /** * Random Zone Event - Activates one random PvP zone temporarily. No modifica la clase de la zona: usa flags PvP en runtime. * @author Juan */ public class RandomZoneEvent extends Event { private static final String CONFIG_FILE = "data/scripts/custom/events/RandomZoneEvent/config.xml"; private static int EVENT_DURATION_MINUTES = 15; private static boolean _isActive = false; private ScheduledFuture<?> _eventTask = null; private final List<ZoneType> _availableZones = new ArrayList<>(); private ZoneType _activeZone = null; public RandomZoneEvent() { loadConfig(); loadZones(); registerZoneListeners(); } /** * Registra listeners a TODAS LAS ZONAS random */ private void registerZoneListeners() { for (ZoneType zone : _availableZones) { addEnterZoneId(zone.getId()); addExitZoneId(zone.getId()); LOGGER.info("[RandomZoneEvent] Registered listener for zone: " + zone.getName()); } } private void loadConfig() { new IXmlReader() { @Override public void load() { parseDatapackFile(CONFIG_FILE); } @Override public void parseDocument(Document doc, File file) { forEach(doc, "event", eventNode -> { final StatSet att = new StatSet(parseAttributes(eventNode)); final String name = att.getString("name"); for (Node node = eventNode.getFirstChild(); node != null; node = node.getNextSibling()) { if ("schedule".equals(node.getNodeName())) { final StatSet attributes = new StatSet(parseAttributes(node)); final String pattern = attributes.getString("pattern"); final SchedulingPattern schedulingPattern = new SchedulingPattern(pattern); final StatSet params = new StatSet(); params.set("Name", name); params.set("SchedulingPattern", pattern); final long delay = schedulingPattern.getDelayToNextFromNow(); getTimers().addTimer("Schedule_" + name, params, delay + 5000, null, null); LOGGER.info("[RandomZoneEvent] Event " + name + " scheduled at " + TimeUtil.getDateTimeString(System.currentTimeMillis() + delay)); } } }); } }.load(); } private void loadZones() { for (ZoneType zone : ZoneManager.getInstance().getAllZones(RandomZone.class)) { if ((zone.getName() != null) && zone.getName().toLowerCase().startsWith("random_zone")) { _availableZones.add(zone); LOGGER.info("[RandomZoneEvent] Loaded zone: " + zone.getName() + " (id=" + zone.getId() + ")"); } } LOGGER.info("[RandomZoneEvent] Total random zones loaded: " + _availableZones.size()); } @Override public void onTimerEvent(String event, StatSet params, Npc npc, Player player) { if (event.startsWith("Schedule_")) { eventStart(null); final SchedulingPattern schedulingPattern = new SchedulingPattern(params.getString("SchedulingPattern")); final long delay = schedulingPattern.getDelayToNextFromNow(); getTimers().addTimer(event, params, delay + 5000, null, null); LOGGER.info("[RandomZoneEvent] Rescheduled for " + TimeUtil.getDateTimeString(System.currentTimeMillis() + delay)); } } @Override public boolean eventStart(Player eventMaker) { if (_isActive) { if (eventMaker != null) { eventMaker.sendMessage("RandomZoneEvent already active."); } return false; } if (_availableZones.isEmpty()) { Broadcast.toAllOnlinePlayers("[RandomZoneEvent] No zones configured."); return false; } _isActive = true; Broadcast.toAllOnlinePlayers("⚔️ Random Zone Event has started!"); _eventTask = ThreadPool.schedule(this::activateRandomZone, 5_000); return true; } private void activateRandomZone() { _activeZone = _availableZones.get(new Random().nextInt(_availableZones.size())); _activeZone.setEnabled(true); Broadcast.toAllOnlinePlayers("🔥 Random Zone Event: " + _activeZone.getName() + " is now PvP for " + EVENT_DURATION_MINUTES + " minutes!"); _eventTask = ThreadPool.schedule(this::eventStop, EVENT_DURATION_MINUTES * 60 * 1000L); } @Override public boolean eventStop() { if (!_isActive) { return false; } _isActive = false; if (_eventTask != null) { _eventTask.cancel(true); _eventTask = null; } if (_activeZone != null) { _activeZone.setEnabled(false); Broadcast.toAllOnlinePlayers("🏁 Random Zone Event ended. " + _activeZone.getName() + " is back to normal."); _activeZone = null; } else { Broadcast.toAllOnlinePlayers("🏁 Random Zone Event ended."); } return true; } @Override public void onEnterZone(Creature creature, ZoneType zone) { if (!_isActive || (_activeZone == null)) { return; } if ((zone == _activeZone) && creature.isPlayable()) { creature.setInsideZone(ZoneId.PVP, true); if (creature.isPlayer()) { creature.sendMessage("Esta zona está en modo PvP temporalmente."); } } } @Override public void onExitZone(Creature creature, ZoneType zone) { if (!_isActive || (_activeZone == null)) { return; } if ((zone == _activeZone) && creature.isPlayable()) { creature.setInsideZone(ZoneId.PVP, false); if (creature.isPlayer()) { creature.sendMessage("Abandonaste la zona PvP temporal."); } } } @Override public boolean eventBypass(Player player, String bypass) { return true; } @Override public String onEvent(String event, Npc npc, Player player) { return super.onEvent(event, npc, player); } @Override public String onFirstTalk(Npc npc, Player player) { return null; } public static void main(String[] args) { new RandomZoneEvent(); } } i have this but its not working
    • ZonePvPSpawnBossRadio=0 ZonePvPSpawnBossBarakiel=0 at the Customs.ini in L2Server folder. Im prety sure this is it because i had the same problem with you in cruma 1 floor for example and i couldn't fix it but i fixed it finally by changing these 2 lines
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock