Jump to content

L2Off Account Manager


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]
Link to comment
Share on other sites

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

Link to comment
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
Link to comment
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.

Link to comment
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
Link to comment
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
Link to comment
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?

Link to comment
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 :/ ,

Link to comment
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

Link to comment
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.
Note: Your post will require moderator approval before it will be visible.

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.




×
×
  • Create New...