[ RELEASE ] DBO.ACCOUNTS QUICK EDITOR

Page 2 of 3 1 2 3
12/03/2012 12:39 Mighty81#16
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 ...
12/03/2012 12:51 c1ph3r#17
Quote:
Originally Posted by Mighty81 View Post
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.
12/03/2012 12:52 marekrndr#18
No, my program does not steal, save or publish you DB information.
12/03/2012 13:16 c1ph3r#19
He thought your tool has changed his dbpassword but it was his own mistake i guess.
12/05/2012 09:39 TheChinStrap#20
Quote:
Originally Posted by marekrndr View Post
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:

Code:
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.
12/09/2012 23:00 eziorav#21
hi marek
could you help in this problème
[Only registered and activated users can see links. Click Here To Register...]
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
12/10/2012 13:45 marekrndr#22
First you have shit 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?
12/10/2012 13:57 eziorav#23
Quote:
Originally Posted by marekrndr View Post
First you have shit 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
___________________________________________
Quote:
Originally Posted by marekrndr View Post
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]
12/10/2012 14:45 ismokedrow#24
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

Code:
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
12/10/2012 15:14 marekrndr#25
Ok, I can't do it at the moment. I'll finish some shit up in this crib and I'll redo it.

Stars Online Auth.. It's named eeee there.
12/10/2012 15:44 eziorav#26
Quote:
Originally Posted by marekrndr View Post
Ok, I can't do it at the moment. I'll finish some shit 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
12/13/2012 21:36 eziorav#27
up up
12/15/2012 21:29 eziorav#28
up up
01/04/2013 13:32 TheChinStrap#29
Quote:
Originally Posted by eziorav View Post
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 ([Only registered and activated users can see links. Click Here To Register...]) and stackoverflow ([Only registered and activated users can see links. Click Here To Register...]).
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!

Code:
 MessageBox.Show("F- for effort and initiative.");
Quote:
Originally Posted by glandu2 View Post
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
Code:
    <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.
01/04/2013 14:42 marekrndr#30
Oh lol I totally forgot this thread. I'm not going to edit anything for that no good DB. Use a proper one. ;)
Page 2 of 3 1 2 3