in which table the account and pw of admintoolclient are stored?
edit: well i cannot log into admintool, it says its unregistered account or sumthin
Printable View
in which table the account and pw of admintoolclient are stored?
edit: well i cannot log into admintool, it says its unregistered account or sumthin
Sure, I have no problem working together to get this project working.Quote:
Originally Posted by joemcoy
I didn't create the missing admintool tables so my admintool dosn't work like yours does.
Can you create accounts in admintool? For me the most important thing currently is to get the login working, to do that we need to create the AuthLogin SP OR figure out the session issue under Japan billingtype.
Edit: After studying the admintool a bit the key might very well be in the admintool to understand more of how the User tables are built.
You this certainty to put well I did not find none select that it makes a search in the Account table, therefore admin tool uses a data base the part to satisfy login in it.
I go my job now and later i post the admintool database.
to put I know that the columns of account are:
UID
Name
Pass
Level
IP
any others
Quote:
Originally Posted by Tyfix
Please check your PM box joemcoy :)
Sounds good, i'll be awaiting your return.Quote:
Originally Posted by joemcoy
I tried input a couple tables i hexedited from the admintool but it dosn't work quite right. I get a login box but get unregistered account even when i insert my data manually in the db ;)
db 'SELECT uid, strAdminID, strPasswd, strLevel, strName, strIP, CONVERT(varchar(11),dateRegit,102) FROM tblToolAdmin WHERE strAdminID=',27h,'%s',27h,0
db 'SELECT strAdminID, strName, strIP, convert(varchar(11),dateRegit,102), strLevel FROM tblToolAdmin WHERE strAdminID=',27h,'%s',27h,0
tblAdminTool = table name?
uid = table row name?
strAdminID = table row name?
strPasswd = table row name?
strLevel = table row name?
strName = table row name?
strIP = table row name?
CONVERT(varchar(11),dateRegit,102) whats this?
WHERE strAdminID=',27h,'%s',27h,0 and this?
Just trying to understand :>
edit:
db 'SELECT binZone FROM tblToolAdmin WHERE uid=%d',0
binZone = another table row?
Where do you get binZone from?Quote:
Originally Posted by jencxxl
SELECT <row1>, <row2>, <row3> FROM <Table> WHERE <row1> = 1
That's how a query works pretty much.. the SELECT part are the rows you want to pull from the table.. FROM is the table you want to pull the selected rows from and WHERE is the condition that has to be true to pull a row.
For example.. SELECT UID, name FROM Table WHERE UID = 1
Will pull UID and NAME from Table but only the rows where UID equal 1.
In exe you dont see any querys you have use one trace SQL or trace ODBC to see all querys.
Quote:
Originally Posted by jencxxl
here is admintool.db
Where did you get that? And could you export it and allow us to download it pls? :)Quote:
Originally Posted by WAII888
its just a picture of tables, could you please export and upload real one :P
Would you mind explaining how thats done at least the very basics? Pleas :)Quote:
Originally Posted by joemcoy
Found it in AdminManagerServer somewhere while looking thrue it.Quote:
Where do you get binZone from?
Open Data Sources (ODBC) Program in Administrative Tools.Quote:
Originally Posted by jencxxl
Click on Tracing tab.
Click Browse and select where to store the logfile (Desktop for instance)
Tick the Machine-Wide tracing for all identities.
Click on Start Tracing Now button.
Open your server files as usual and go do some stuff.
Check the trace log.
Hmm yeah i see it now. No idea what its used for.Quote:
Originally Posted by jencxxl
Ok, i got rid of the spLoginAuthMyth error, it needed 3 arguments, accname,password and ip. Now i get Failed to open session error if i try to login with manually inserted acc and pw in Account table.
Edit: Its nice to see that it also says "Please try again later" :)
Maybe this session has something to do with the session logs?
Lovely. I don't know where this session is supposed to be.. maybe we are missing a session table?Quote:
Originally Posted by znookie