[ RELEASE ] DBO.ACCOUNTS QUICK EDITOR

[Mighty81]

Habs nun hin bekommen konnte das PW ändern und nun läuft wieder alles.

Wenn das wirklich vorkommt das sich die Anmeldemaske resettet dann tuts mir leid das ich das Programm verdächtigt habe.
Jedenfalls läuft nun wieder alles und ich hoffe das das nicht zu oft vorkommt.

PS: Nicht immer gleich so aufregen wenn einer mal was fragt ...

[c1ph3r]

Originally Posted by Mighty81

Habs nun hin bekommen konnte das PW ändern und nun läuft wieder alles.

Wenn das wirklich vorkommt das sich die Anmeldemaske resettet dann tuts mir leid das ich das Programm verdächtigt habe.
Jedenfalls läuft nun wieder alles und ich hoffe das das nicht zu oft vorkommt.

PS: Nicht immer gleich so aufregen wenn einer mal was fragt ...

Poste beim nächsten mal die Fehlermeldung direkt als Screen. Das macht die Hilfe einfacher.

[marekrndr]

No, my program does not steal, save or publish you DB information.

[c1ph3r]

He thought your tool has changed his dbpassword but it was his own mistake i guess.

[TheChinStrap]

Originally Posted by marekrndr

Thanks for the feedback TheChinStrap. I didn't figure that a simple Process.Start would require that.

System.Diagnostics.Process.Start() for some reason, at least in my experience, behaves a bit funny when you use a url to try to open up the default browser. Just toss in a try statement to use ie in the case it doesn't find the default and should be all gravy:

string myUrl = "http://myurl.com";

try
{
    Process.Start(myUrl);
}
catch (System.ComponentModel.Win32Exception ex)
{
    if (ex.ErrorCode == -2147467259)
    { Process.Start("iexplore", myUrl); }

    else
    { MessageBox.Show(ex.ToString()); }
}

Hope that helps, though I'm certain you didn't need much of a hand.

[eziorav]

hi marek
could you help in this problème

i think i know the problème
i have to change the dbo.account colonne but im using stars online files
could you edit the programme to be used as stars online auth database

[marekrndr]

First you have **** loads of failed logins (you clearly don't know them). Then you got no idea how to properly type in a name for a new account (None..). Then you managed to connect SOMEWHERE, but it's not Auth..

And just to wrap this up.. What's the dbo.Accounts for Stars Online files then?

[eziorav]

Originally Posted by marekrndr

First you have **** loads of failed logins (you clearly don't know them). Then you got no idea how to properly type in a name for a new account (None..). Then you managed to connect SOMEWHERE, but it's not Auth..

i now what kind of problèms are those on top
i didn't mean the new account and failed logins
the problème is that the colomn used for your programme are not the same as the files i used
___________________________________________

Originally Posted by marekrndr

And just to wrap this up.. What's the dbo.Accounts for Stars Online files then?

Dbo.account
SELECT TOP 1000 [account]
,[account_id]
,[creationDate_]
,[creatorId_]
,[email]
,[password]
,[pk_]
,[portId_]
,[type_]
,[updateDate_]
,[updatorId_]
FROM [Auth].[dbo].[Account]

[ismokedrow]

I don't know what kind of screwed Auth you have, but this is the auth table I have used for every epic I've worked on from 6.1 to 7.4 v2

USE [auth]
GO

/****** Object:  Table [dbo].[Accounts]    Script Date: 12/10/2012 7:43:41 AM ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

SET ANSI_PADDING ON
GO

CREATE TABLE [dbo].[Accounts](
	[account_id] [int] IDENTITY(1,1) NOT NULL,
	[login_name] [nvarchar](31) NULL,
	[password] [nvarchar](32) NULL,
	[pcbang] [int] NULL,
	[block] [int] NULL,
	[withdraw_remain_time] [int] NULL,
	[age] [int] NULL,
	[auth_ok] [int] NULL,
	[last_login_server_idx] [int] NULL,
	[event_code] [int] NULL,
	[server_list_mask] [nvarchar](31) NULL,
	[result] [int] NULL,
	[ip] [varchar](50) NULL,
	[game_code] [nvarchar](50) NULL,
	[gamecode] [varchar](50) NULL,
	[login_event] [int] NULL,
	[email] [nvarchar](30) NULL,
 CONSTRAINT [PK_Accounts] PRIMARY KEY CLUSTERED 
(
[account_id] ASC
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY]
) ON [PRIMARY]

GO

SET ANSI_PADDING OFF
GO

[marekrndr]

Ok, I can't do it at the moment. I'll finish some **** up in this crib and I'll redo it.

Stars Online Auth.. It's named eeee there.

[eziorav]

Originally Posted by marekrndr

Ok, I can't do it at the moment. I'll finish some **** up in this crib and I'll redo it.

Stars Online Auth.. It's named eeee there.

ok waiting for you to redo it
yes it's eeee

[eziorav]

up up

[eziorav]

up up

[TheChinStrap]

Originally Posted by eziorav

up up

Wow.. Mate, in the time you've spent bumping this thread and waiting for Marek to make edits you could have learned C# and made a program for yourself. Seriously, I learned through code samples on codeproject () and stackoverflow ().
It's real simple, watch;
step 1: go to google.com
step 2: input the following site:stackoverflow.com what I want to know
step 3: Read!

 MessageBox.Show("F- for effort and initiative.");

Originally Posted by glandu2

if your try to write in a user folder (that is, not in read-only folder like C:\windows, C:\Program files, C:\, ...) you should not need this, and that could be too complicated to do (3 clicks instead of only 2 is too many)

I said that, because i hate when programs wants to have admin right while doing nothing that would need them (like rappelz ...) . If every programs use admin right only if they need them, even if you download bunch of viruses, UAC should be enough as a anti-virus (at least if there is no security flaw in the uac used by these viruses)

And if you want to automatically have admin rights, you should use a manifest file with

    <security>
      <requestedPrivileges>
        <requestedExecutionLevel level="requireAdministrator" uiAccess="false"/>
      </requestedPrivileges>
     </security>

Agreed, but, I've noticed Marek likes to add auto-updating to some of his software. If he's using Microsoft Click-once it won't work with an ex level of req admin. One of the main reasons i never use it.

[marekrndr]

Oh lol I totally forgot this thread. I'm not going to edit anything for that no good DB. Use a proper one.