Maxtor 181 Posted July 6, 2014 Posted July 6, 2014 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] Quote Share this post Link to post Share on other sites
Paradise 30 Posted July 6, 2014 Posted July 6, 2014 This has nothing to do with the sql script. Charset should be the same everywhere in order to work. Propably there was a difference. Quote Share this post Link to post Share on other sites
Equagf 0 Posted July 15, 2014 Posted July 15, 2014 Can you re-share that donate script , it is removed :/ Quote Share this post Link to post Share on other sites
LogicalMind 2 Posted July 19, 2014 Posted July 19, 2014 Can you re-share that donate script , it is removed :/ +1 Quote Share this post Link to post Share on other sites
LooLand 0 Posted August 3, 2014 Posted August 3, 2014 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 .. Quote Share this post Link to post Share on other sites
nekys 2 Posted September 28, 2014 Posted September 28, 2014 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. Quote Share this post Link to post Share on other sites
Paradise 30 Posted January 3, 2015 Posted January 3, 2015 (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 January 4, 2015 by PARADISE Quote Share this post Link to post Share on other sites
Outlaw™ 1 Posted January 8, 2015 Posted January 8, 2015 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. Quote Share this post Link to post Share on other sites
LogicalMind 2 Posted January 9, 2015 Posted January 9, 2015 (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 January 9, 2015 by LogicalMind Quote Share this post Link to post Share on other sites
Paradise 30 Posted January 10, 2015 Posted January 10, 2015 (edited) 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 Quote Share this post Link to post Share on other sites
Cray-Z 0 Posted January 10, 2015 Posted January 10, 2015 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? Quote Share this post Link to post Share on other sites
Vagrancy™ 4 Posted January 12, 2015 Posted January 12, 2015 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... Quote Share this post Link to post Share on other sites
Katzolt 0 Posted April 7, 2015 Posted April 7, 2015 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 :/ , Quote Share this post Link to post Share on other sites
xeL 17 Posted April 7, 2015 Posted April 7, 2015 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 Quote Share this post Link to post Share on other sites
Katzolt 0 Posted April 7, 2015 Posted April 7, 2015 alter the table with missing columns ok, perfect'll try... Quote Share this post Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.