Ahhh I knew it! Thanks bob for the reply, I thought I was going to wait another day D:. Okay, give me a second, I'm hexing it now.. I'll be looking for an IP, any suggestions? XD
orr. wait, did you say I could use another .exe to get to my server?
Ahhh I knew it! Thanks bob for the reply, I thought I was going to wait another day D:. Okay, give me a second, I'm hexing it now.. I'll be looking for an IP, any suggestions? XD
orr. wait, did you say I could use another .exe to get to my server?
You can... 1871 or 1873 are pretty good for a trial run on the repack you are using IMHO... and hexing the client is pretty much easier than messing with the registry and Idata.bmp shizzle anyway.
You can't miss it, it's a plain ASCII string less than 512 bytes from the end of the file. Specifically, he patched out the code that would otherwise read from "Server1" registry entry... if Server1 is live, the client doesn't look for Server2 or Server3, they are only there to fall back on. (during maintainence or such)
I can't find that code D: I found like 2 ip's and changed them but nothing else. Those two ip's were nowhere near the end of the file though so they are probably not right. How should it look like anyways? (xxx.xxx.xxx.xxx)? and where can I get the 1871 exe :(Originally Posted by bobsobol
Actually I think it worked.. but it says the password is wrong.. I checked carefully and it can't be wrong. Is it because MySQL express uses a pasword hash?
EDIT: There is no password hash, the password worked as I typed it.. (not sure what happened) Thanks so much bob.. <333 (turns out I actually got the right ip in the hex editer)
Last edited by poopsie; 24-10-09 at 12:01 AM.
Okay... that is confused.
1871 and 1873 stickied thanks to DK >here<
MySQL doesn't have an Express version, and PT doesn't work with MySQL.
No SQL uses a hash password, (too insecure) and logging in to PT game.exe has nothing to do with your SQL password.
What is quite common, is "password incorrect" when ODBC is not configured correctly, or (if you use them instead) SQL.dll and Clan.dll are not properly edited.
Last edited by bobsobol; 24-10-09 at 12:20 AM.
Actually some mySQL tables use a hash algorithm, I've seen it before (they have the value, but then the server itself decrypts it). And I think mySQL can hash values if it wants to, you just have to set it.
And yes, logging into my account was what I was talking about not the game.exe XD. The game.exe worked excellently.
Anyways, it seems I did the ODBC correctly, but I'm not terribly sure what it does actually ( I just followed directions :,()
Hashing records, and hashing passwords are two different things. A hash match can speed up a record search, it isn't used as the only means of identifying a password, as that would effectively mean that more than one password would work to access the account. Encryption of passwords is used, and the encryption will be performed in accordance with a key, which may or may not be a hash value of some other indeterminate data.
Buy MySQL is no good for PT, and will interfere with it's operation.
If you use SQL.dll then ODBC isn't used (apparently) as SQL.dll accesses the database via MDAC... if you don't use SQL.dll (or it's not configured correctly) then the server will fall back to ODBC.
ODBC, MDAC and NCLI are APIs for database access, and allow you to use an external database rather than programming your own into your application.
What "account" are you trying to log in to? Your game account, PC account, ISP account, Server account, GM account, SQL account? ... hell you could be talking about a hotmail account.
If (as I suspect) you mean logging in to SQL via MS-SQL-SMS (SQL Management) then the most common reason for not being able to log in via the password you set is because that account has been locked out, and on modern hardware the most common reason for a root (administrator) account being locked out of SQL is the ODBC control panel described in this, and many older guides.
The only cure I know of is to roll back and try again, except that I would always apply the ODBC connection directly in the registry without the ODBC "Database Sources" applet.
Oh, I guess I should have been more clear. I was talking about my Private server game account I manually created in MySQL. Not my SQL account. I'm not terribly experienced in this area, so I'm sorry if I sound a bit confusing to you D: (it sounds good in my head :D).
EDIT: Do you know, by any chance, where the character information is stored in MySQL?
EDIT2: Well it looks like the character information is stored in dataserver/userdata/
Last edited by poopsie; 24-10-09 at 08:04 PM.
MySQL has nothing to do with PT... it WILL NOT WORK!!!No where. As you cannot use MySQL with PT servers. NOTHING from PT is stored in MySQL. The only things PT actually stores in Microsoft SQL are user names, passwords, Clan registration, SoD2 scores and some error logging.
Unfortunately everything else is stored via the file system, not in the database.
Correct.
To be totally clear:-
MySQL = a very good cross platform SQL database engine we cannot use for PT.
MS SQL Server = a not so good commercial SQL database engine sold by Microsoft with buggy SQL syntax, poor scalability and only available for Microsoft operating systems which we have to use in PT because of the cookie SQL syntax hard coded into it.
If you have installed MySQL, there is no need to look for any other problem... this is it.
If you are repeatedly making typos saying MySQL when you mean MS SQL, please stop it.
Last edited by bobsobol; 24-10-09 at 08:24 PM.
Yes, MSSQL stored Login's and passwords, that's not nothing -_-. I've read somewhere that it is possible to use SQL as a data source instead of the .dats. I think it might have been you, I'll have to double check.MySQL has nothing to do with PT... it WILL NOT WORK!!!
No where. As you cannot use MySQL with PT servers. NOTHING from PT is stored in MySQL. The only things PT actually stores in Microsoft SQL are user names, passwords, Clan registration, SoD2 scores and some error logging.
Unfortunately everything else is stored via the file system, not in the database.
Correct.
To be totally clear:-
MySQL = a very good cross platform SQL database engine we cannot use for PT.
MS SQL Server = a not so good commercial SQL database engine sold by Microsoft with buggy SQL syntax, poor scalability and only available for Microsoft operating systems which we have to use in PT because of the cookie SQL syntax hard coded into it.
If you have installed MySQL, there is no need to look for any other problem... this is it.
If you are repeatedly making typos saying MySQL when you mean MS SQL, please stop it.
Ohh Yes, I am using MS SQL with this pt server. I do have MySQL though, just not using it with the pt server XD (I guess I can't, but I didn't even try). Anyways, there is no problem, I am on my server as I type. I am just playing with some things now (trying to get multimanager to work, it says It can't find/ or cannot access the sql server). Besides that, everything seems to be running smoothly.
so do brazil gostei desse forum to me esforçando pra tentar entender algo aqui auhauhuha
RaGEZONE rules state that if you are going to post in a language other than "English" you should provide some form of translation.Would do nicely if I'm not mistaken.
Man, I can`t find out how to connect to my server...
Look, the only thing I could do, was to set up my hotuk file...
Look, I dont, know what client to download, what to do after installing the client, what file to run to be able to connect to server... Please help xD
(I dont`t know why, but looks like it`s missing the final part of the thread, why?
After how to create monsters, it doesn`t appear nothing more, that is the part of how to connect)
Waiting for reply ^^
Excelent tutorial, for what I could understand.
The server client got to be the same as the game client, use the search function and the right words in order to find what you're looking for. So just make sure they match and thats pretty much it. Oh try not to use your IP, go for localhost while you're testing your server + it makes it all much easier. And yes the final part of the guide IS missing, because something got screwed up while swezid were editing the guide some years ago. But it doesn't seem like hes coming back since he've been off for such a long while. Anyhow im sure there are other people in this section that may help you to make your server work :)
Peace
Last edited by Fili0kuZ; 13-08-12 at 09:51 PM.
Link is dead
Reply With Quote