Welcome to MaxCheaters.com

Register now to gain access to all of our features. Once registered and logged in, you will be able to create topics, post replies to existing threads

Recommended Posts

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]

Share this post


Link to post
Share on other sites
  • Replies 79
  • Created
  • Last Reply

Top Posters In This Topic

Top Posters In This Topic

Popular Posts

Hello, recently I managed to make this Account Manager for L2Off Servers. Few functions and basic structures has been taken from existing account panels. This one is completely  recoded with captcha and it is more secured. Also it is functional and can be embedded to any website easily.   Some Information It's partially tested under IIS Tests have been done ONLY with Gracia Final Server Files but I am 99.99% sure that it will work under Interlude too. If not, contact me

Posted Images

  • 2 weeks later...
  • 2 weeks later...
  • 1 month later...

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.

Share this post


Link to post
Share on other sites
  • 3 months later...

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

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

 

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?

Share this post


Link to post
Share on other sites
  • 2 months later...

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

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.