Jump to content

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

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.

 Share




  • Posts

    • Promotional banners:  
    • We have added few new features for Second Edition of L2Etina. Check them out:   While streaming L2Etina, you will now receive L2Coins automatically.   Dwarves who have set private workshop, now automatically sell Crystallization to nearby players. For this service, they receive 10% of created crystals.   Before closing game, you will now see amount of earned experience, adena, total play time and acquired items.   You can now check Ranking of current and previous edition. This window can be found in Main Menu.   Party Window now have a special spot, showing if member has Noble Blessing.   Players from South America will be able to connect to the server by proxy.   Players who have supported first edition by donation, will now 2 weeks of free premium.   We have rewritten description of every buff, so they are now clear and handy. Vote rewards will be different for new edition, but exact items are not decided yet.   When spoil is successfull, you will now see special popup window. When you target monster who has been spoiled, you will see Spoil as a debuff.   Buff Store now have possibility to refuse to buff someone. Retail version of party matching was added back. Offline private stores now automatically disappear after 5 days. There are plenty more improvements and fixes, like ability to disable skill bar, multiple fixes to epic bosses, adjustments to aggro.
    • First of all thank you for fast answer. I have changed internal as you said but didn't work sir.
    • The difference isn't paying upfront or at the end of each week. The major difference is that paying clans to join, leads to leaders making random weak sides who play just for money and creates an extremely toxic fake competition in-game (i.e. l2 dex, e-global, valhalla and this kind of servers). Paying clans just to join absolutely kills the rivalry between them as there are no real losers and winners. Everyone gets paid at the end of every week so who cares right ?   Rewarding the winners with cash gives a massive motive to the leaders to create strong sides and try their best to win without giving any advantage to any clan (unlike paying people to join and basically giving them free premiums and whatnot). In this case, there will always be losers and winners and the rivalry will be kept alive.   I hope that clears up the massive difference between the 2 scenarios. Look at all those big russian servers. No1 makes fraps flaming about which side is better. Everyone cares about daily 9v9s or organized ones. There is no clan identity anymore because leaders simply don't care. They have been so detached from the clan's identity that most of the times the leader's CP holds a different name to the side's. This is a very important point to think about. 
    • change the server.ini  InternalHostname = 127.0.0.1     and try
  • 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 Disbaled AdBlock