Tool L2Off Account Manager

[Maxtor]

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]

[Paradise]

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

[Equagf]

Can you re-share that donate script , it is removed :/

[LogicalMind]

Can you re-share that donate script , it is removed :/

 

+1

[LooLand]

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 ..

[nekys]

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.

[Paradise]

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 January 4, 2015 by PARADISE

[Outlaw™]

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.

[LogicalMind]

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 January 9, 2015 by LogicalMind

[Paradise]

I don't wanna go off topic but:

 

 

Business Contact Information 
 

Customer Service URL:  http://lineage-destiny.net

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 January 10, 2015 by PARADISE

[Cray-Z]

 

I don't wanna go off topic but:

 

 

Business Contact Information 

 

Customer Service URL:  http://lineage-destiny.net

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?

[Vagrancy™]

i have spoke already with PARADISE and he dont have enough time to work with the project, as he told me is abroad for business...

[Katzolt]

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 :/ ,

[xeL]

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

[Katzolt]

alter  the table with missing columns

ok, perfect'll try...