PT Server at Linux

This is beta of PT Server working under Linux. Clans are not added yet so don't tell me that they are not working.
I hope you guys can find some bugs, so far I was not able to find any that are Linux specific.


What do you need:

VirtualBox VM:

https://rapidshare.com/files/3883794...p_9.20_.7z.001
https://rapidshare.com/files/6802856...p_9.20_.7z.002
https://rapidshare.com/files/4109414...p_9.20_.7z.003
https://rapidshare.com/files/3423557...p_9.20_.7z.004
https://rapidshare.com/files/1166672...p_9.20_.7z.005
https://rapidshare.com/files/9188468...p_9.20_.7z.006
https://rapidshare.com/files/1165814...p_9.20_.7z.007
https://rapidshare.com/files/1873908...p_9.20_.7z.008
https://rapidshare.com/files/7452915...p_9.20_.7z.009
https://rapidshare.com/files/2422593...p_9.20_.7z.010
https://rapidshare.com/files/2777979...p_9.20_.7z.011
https://rapidshare.com/files/5671809...p_9.20_.7z.012
https://rapidshare.com/files/2546346...p_9.20_.7z.013
https://rapidshare.com/files/1601317...p_9.20_.7z.014
https://rapidshare.com/files/2469063...p_9.20_.7z.015
https://rapidshare.com/files/4156878...p_9.20_.7z.016
https://rapidshare.com/files/1507750...p_9.20_.7z.017
https://rapidshare.com/files/4130155...p_9.20_.7z.018
https://rapidshare.com/files/7249104...p_9.20_.7z.019
https://rapidshare.com/files/1829801...p_9.20_.7z.020


MD5 : b3961a94fcc5de277f836b8c30f4f5af
SHA1 : 08c49bdcab515ea01b2e9f709b1a7f686eae31f8
CRC32 : 44c8fcd8
File Size : 4,094,791,400

VirtualBox:

https://www.virtualbox.org/wiki/Downloads

How to setup connection?

On VirtualBox:

http://forum.ragezone.com/attachment...1&d=1334308093

On Windows:

You need to add loopback adapter and configure it (see picture below)

http://forum.ragezone.com/attachment...1&d=1334308093

Recommended client:

test kPT 1.98.9 (server is using "char" and "Field" folders from that version).
Look for PristonTale(test)_Setup(1989).exe on google if you don't have this client yet.

You will need those lines in ptReg.rgx

Code:

---

"Server1" "192.168.56.102"
"Server2" "192.168.56.102"
"Server3" "192.168.56.102"

---

But you can use yours as long as you remember to replace "char" and "Field" folders.

You should be able to ping your server now (ping -t 192.168.56.102).

You are free to change IP, server or client as long as you know what you are doing.
SQL.dll, Clan.dll and libmySQL.dll in server folder are essential.
If you are planing to replace this server with yours than you have to copy them.

Passwords for user account, root account, MySQL and so on...

ALL passwords are set to 123456

Spoiler:

1, 2, 3, 4, 5 - YouTube

I added 6 for confusion ;)

Where is the server?

/home/pristontale/.wine/drive_c/PristonTale/GameServer/

server4096K.exe (kPT Protocols, Port 10009)

Are those server files good?

This is mix of Operz jPT and bobsobol PPT + some tools.

What's not working?

- .net 1.1 tools are broken (only on Debian Sid, but this will be fixed)
- no clans (clan system is not added yet)

No more bugs so far...

Is it faster?

On small scale, I don't see difference.
On big scale, someone with 100+/200+ players server need to tell me.
I'm very interested in "data". If anyone willing to test Linux server I would appreciate it.

Any tutorial how to make it from scratch?

Not yet.

duude I read "Priston Tale pServer F.A.Q." and its clear about PT on Linux, its not working

Must be outdated :)

What's the best way to start server?

From terminal:
wine server4096K.exe

Account and password to login?

Acc: a
Pass: a

Acc: b
Pass: b

Acc: c
Pass: c

Acc: d
Pass: d

Why Linux?

BECAUSE

( •_•)

LINUX

( •_•)>⌐■-■

IS COOL

(⌐■_■)





PS. Anyone remember on what PHP version clan files "supposed" to work according to Gregoo?

Everyone break out your Unix Manuals. ^_^

Spoiler:

That's a Unix book.

BTW... Strictly speaking, it's still not running on Linux, but thanks to Wine, it is running without Windows.

It's kinda like Java doesn't actually run on Windows, Mac or Linux... yet all three, and many other systems can run Java applications via a JVM. Same thing. :D:

Split into multiple files and uploaded.

That reminds me about some Java project which will let me use .ASP files on linux.
Don't know why but PHP is "transparent" for PT :/
Gregoo was talking about PHP version that might work with PT but can't find this post. Maybe it was deleted when he rage quit.

I can start thinking about PT Server without GUI.

I believe that was the premiss of his "IIS, Yes Sir!" guide. PHP works fine for all PT functions in IIS, but neither it nor many other SSS work well if you use Apache.

Is there a problem with Apache::ASP? Mono provides excellent ASP.net operation, I believe.

Quote:

---

Originally Posted by bobsobol

Is there a problem with Apache::ASP? Mono provides excellent ASP.net operation, I believe.

---

Quote:

---

VBScript or JScript supported?
Only Perl scripting is supported with this module.

---

I'm testing ArrowHead but so fart there is error:

Code:

---

File /var/lib/tomcat6/webapps/ROOT/ServerMain/sod2info.asp line 16: Cast Exception: java.lang.NumberFormatException: For input string: "&H0D"
        at com.tripi.asp.Types.coerceToInteger(Types.java:94)
        at com.tripi.asp.VBScriptGlobals$ChrFunction.execute(VBScriptGlobals.java:632)
        at com.tripi.asp.AbstractFunctionNode.execute(AbstractFunctionNode.java:62)
        at com.tripi.asp.GetIndexNode.execute(GetIndexNode.java:178)
        at com.tripi.asp.SetValueNode.execute(SetValueNode.java:124)
        at com.tripi.asp.BlockNode.execute(BlockNode.java:155)
        at com.tripi.asp.AspThread.run(AspThread.java:79)
        at java.lang.Thread.run(Thread.java:679)
File /var/lib/tomcat6/webapps/ROOT/ServerMain/sod2info.asp line 16: File unknown line unknown: Cast Exception: java.lang.NumberFormatException: For input string: "&H0D"

---

I think I will try different version of Java.

Bob you are good at VB, can I rewrite this:

Dim strSplit, strSplit2
strSplit = Chr("&H" & "0D")
strSplit2 = Chr("&H" & "7C")

to something that will work?
Those lines giving me error in every file.

__EDIT__

Mono will run .ASPX files but not .ASP, I don't wan't to use my all .ASPX version because there was a bug showing incorrect clan :/

You mean

Code:

---

Dim strSplit, strSplit2
strSplit = Chr(13)
strSplit2 = Chr(124)

---

I think it's become a mess while trying to escape the ampersands in the hex constants. As pure vb6, not ASP vb code it should be:-

Code:

---

Dim strSplit, strSplit2
strSplit = Chr(&h0D)
strSplit2 = Chr(&h7C)

---

To my eye, there are extra quotation marks in there that would break out to:-

Code:

---

Dim strSplit, strSplit2
strSplit = Chr("&h0D")
strSplit2 = Chr("&h7C")

---

Which is invalid, because the Chr() function is something like:-

Code:

---

Byte Chr(ByRef val As Byte)

---

While vb should automatically typecast val as Byte on passing to the function, based upon the prototype, it can't cast Type String to Type Byte without using the Chr() function... Which is what it's trying to pass it to... so it's never going to work. (edit: I guess it could, but that would produce both variables being equal to 38, or &h26... the ASCII value of the character "&" :(:)

My guess, if it works on ASP in IIS is that it's either taking advantage of, or working around a bug in ASP / IIS.

Regardless, if you are happy to represent the character as decimal, rather than hex in your source, you don't need to break out the hex constant identifier "&h".

See how that works out. (1st code snippet)

--- EDIT ---
TBH, I'd be happier with 100% ASP or 100% php. I can't read ASP.net and can't think of a good reason to use 2 server side scripting language modules in any server.

P.S. Am I right in thinking the only problem with Perl is that it's engine tends to be slow under heavy load? (Perl scripts rock in shell scripting)

Ok, this works:

strSplit = Chr(&h0D)
strSplit2 = Chr(&h7C)

but also this works (no case sensitive?):
strSplit = Chr(&H0D)
strSplit2 = Chr(&H7C)

and this:
strSplit = Chr(&H&0D)
strSplit2 = Chr(&H&7C)


I assume that 1st one will give me same results as on IIS?

__edited 1st one

No... the "&h" is not case sensitive, and neither is the hex number. "&h0D" or "&H0d" is normal. Most people like to use case to distinguish the &h identifier from the hex digits that follow.

As for IIS, I'm surprised that your original worked. But am aware that the IIS pre-parseing to separate raw HTML from Server Side Scripting can have strange effects on the script code.

My clan system does not work at all :/
Good thing about this is that php still could work.

I did not run clan system for ages.
Just to clarify, all I need to run is:

*CLAN_SERVER 192.168.56.102 80
and .asp pages?

Do you have some packet dumps from character login without clan? I would like to see how check "is in clan" look like.

___

OK I think I see where problem is. %s in client is not replaced by IP.
IPs are taken from registry?

They are taken from client hotuk.ini, which I believe the registry code would normally replace. But since I reverse the priority and store no client config in the registry, I couldn't say for sure.

Code:

---

*ODBC_TABLE_PLAY
*ODBC_TABLE_PASSWORD
*ODBC_TABLE_IDNAME
*ODBC_TABLE
*ODBC_PASSWORD
*ODBC_ACCOUNT
*ODBC_NAME
*CLAN_SERVER
*GAME_SERVER

---

All (potentially) part of the client hotuk.ini. :blink:

Can't remember what I did, but I did get the client picking up manually entered Clan data from a different PC to the game server using something like these. I thought there was a DATASERVER_IP and DATASERVER_PORT command but I don't see it in the clients now... so I guess I'm miss-remembering. (mistaken memory)

Don't work on my client and I can't figure out from where it should take parameters. Other info like account id or server name are correct.

Can you check:

Code:

---

lea    eax, [esp+1Ch+szUrl] ; Load Effective Address
push    offset HttpSServerm_14 ; "http://%s/servermain/sod2info.asp?userid=%s&chname=%s&gserver=%s&index=%d"

---

your result?

%s <- should be IP here...

You need to set BP there and click on lady SOD manager. (it might make url string 2nd time you click)

It look like ArrowHead is giving error in packet but I would like to fix this missing IP problem before I go back to PHP.

I can't. Secretary Karina has never said anything to me on any of my servers... she doesn't work. Since I've never needed to use her (I don't really know what she is supposed to do) I never tried to fix.

Give SoD score =P
But url string should be formed anyway.

O well, I guess I will force IPs on client later.

As to the packet "corruption" I believe that is what Gregoo has told us many times. Apache breaks packets down at different points, and because the PT client doesn't use Windows HTTP GET APIs but WinSock TCP/IP Client ones, it doesn't read a page, but a packet. IIS issues one packet for the page, but Apache issues the prologue in one packet and the page content in another... or, something similar. (he has explained the technical details better elsewhere on more than one... probably more than 2 occasions)

I think there are other servers which format packets similar to IIS, and I'm fairly certain that if you used MS Proxy server, between Apache and PT Client, it may well reformat the responses.

Quote:

---

Originally Posted by Vormav

Don't work on my client and I can't figure out from where it should take parameters. Other info like account id or server name are correct.

Can you check:

Code:

---

lea    eax, [esp+1Ch+szUrl] ; Load Effective Address
push    offset HttpSServerm_14 ; "http://%s/servermain/sod2info.asp?userid=%s&chname=%s&gserver=%s&index=%d"

---

your result?

%s <- should be IP here...

You need to set BP there and click on lady SOD manager. (it might make url string 2nd time you click)

It look like ArrowHead is giving error in packet but I would like to fix this missing IP problem before I go back to PHP.

---

I'd leave this question open for someone else to answer.

I'm looking for Sun Active Server Pages 4.0.3 (linux version) this is discontinued but it look like it disappeared from the internet >___>
This cross-platform solution could fix clans on linux.

I believe it is a)not free, b)not open source c)not exactly discontinued.

I think it's Sun ONE Active Server Pages which is now a feature of the Sun ONE (Sun Open Net Environment) which was available up to Version 6 SP4, for sure, and then seems to have become Sun ONE Studio, for which there is clearly a version 8. Beyond that, and the Oracle take-over I'm not sure what it may be called.


It is cross-platform because it runs only on the Sun JRE/JVM, and contains ActiveDirectory, and other Network directories, Email, Collaboration, Web and FTP services with server side scripting and built in web control panels, and in the studio versions it even seems to contain a C++ compiler... in Java... how odd. :/:

Despite being Java only, different installation packages where released for each supported platform. Originally (version 4) there was Windows, Unix and Solaris. But later there seem to be installers for AIX and other Unix variants too.

I don't think you can "download" this for free, and I certainly don't think you can share it with us for free. :wink:

--- EDIT ---
BTW... That strange code:-

Code:

---

strSplit = Chr(&h0D)
strSplit2 = Chr(&h7C)

---

You know we both missed the obvious equivalent:-

Code:

---

strSplit = Chr(13)
strSplit2 = "|"

---

:lol:

--- EDIT2---
Looks like it became Sun Java System Web Server which was, at some point BSD license with Open Source core technologies, as well as free software. (though I'm sure Richard Stallman and the GNU/FSF wouldn't consider it "free" at all) This could be as "free" and "open source" as Mac OS X, which is also BSD licensed with an Open Source policy on most of it's core technologies.

I note that while the commercial Sun Java System Web Server clearly states it has ASP ability, the Open Source "Open Web Server" only mentions "SSL, CGI, FastCGI and its own NSAPI interface." Though the original article I linked in this edit states that Sun Java System Web Server is "free", it doesn't say how free. (free for who, and for what purpose)

I find a note on Oracle website that says:-

Quote:

---

Oracle iPlanet Web Server securely and reliably deploys web applications built with leading-edge technologies, such as JavaServer Pages, Java servlets, Active Server Pages (ASP), ColdFusion, Personal Home Page construction kit (PHP), and Common Gateway Interface (CGI). A PHP add-on is available for Web Server 7.0

---

and also indicates that that product is part of "Oracle Web Tier". That product is available to download for "free" from Oracle under a very strict license.

Here are some of the terms I picked up which you must agree to comply with:-

• The programs may be installed on one computer only, and used by one person in the operating environment identified by us.
• You may not use the programs for your own internal data processing or for any commercial or production purposes, or use the programs for any purpose except the development of your application
• You may not make the programs available in any manner to any third party
• You agree that U.S. export control laws and other applicable export and import laws govern your use of the programs
• You are not a citizen, national, or resident of, and are not under control of, the government of Cuba, Iran, Sudan, Libya, North Korea, Syria, nor any country to which the United States has prohibited export.
• You will not download or otherwise export or re-export the Programs, directly or indirectly, to the above mentioned countries nor to citizens, nationals or residents of those countries.
• We may audit your use of the programs.

(Just a few that I lolled at) Anyone else here saying "F№§₦ʥing Nazis"?:lol:

On MONO "COM is not supported" and I can't pass my variables. I think I will test ArrowHead one more time.

Too bad I can't use (even find) sun ASP. I still would like to know if it would work anyway.

"You agree that U.S. export control laws and other applicable export and import laws govern your use of the programs"

LOL, keep dreaming XD

How to get ASP support on Linux | Computer Tips And Tricks, Gadgets, How-To, Life - 2.0 Style

Sounds arse-about-face, but should do the trick. (Apache Tomcat... ewww)

I prefer tutorial in ArrowHead readme :)

Clans still not working. I will have to configure windows clans to get packets data.
IIS NOOOOOO!!!
http://data.whicdn.com/images/4811949/vader_large.jpg

Natiz from Oracle not allowing me to use their product,

Spoiler:

http://www.videogamesblogger.com/wp-...-3d-hiltar.jpg

MONO is good for nothing, ArrowHead giving me error at connection string and mod_aspdotnet working only under windows. Any other alternatives for ASP under Linux?

But is still strange, client have some PHP strings used by official PT. I wonder what version of PHP they have.

We might be doing something wrong at those:
strSplit = Chr(13)
strSplit2 = "|"

They are standard vb4 split-strings. (dumb-ass way of creating a string array without declaring an array)

You know when you make a "file browse filter" in Winblows dialogues, how you say "*.bat|*.cmd|*.txt|*.ini|*.cfg" or such? Well it's like that. The string-split routine looks for the first "|" in the string, and makes everything before it the first filter, then it chops that, and the "|" off, and looks for the next one... and so on.

The "Char(13)" is not good. It doesn't take into account MS "Char(10)"... Remember, Basic doesn't escape "\r\n" It stores 0D0A directly in a Basic string without difficulty... just as it can store "\0" without difficulty. But Windows, Mac and Linux use different conventions for "Carriage Return, New Line". So it's not great, no matter what.

I would say go PHP all the way... or if you really want to stick with ASP, convert to Perl. (can it really be that hard? IDK, I've never tried)

OK, I'm more positive about PHP now. My test script worked on Linux version and I was able to pop clan chief sod page.

On windows data is separated with hex "OD" but on linux it can work without any split. This might give me some error in other scripts.

So far I can tell that this have nothing to do with "packet "corruption"" or win api. It should work on any HTTP server. I'm eliminating MONO, its sending me pages code not results in packets.

PS. Your awesome hotuk.ini (the one with comments) have bug, clans not sending IP/not working. Maybe it have something to do with number of lines/comments or some command that block clans :/
Too bad I like your commentary.

clans have nearly NOTHING to do with packets. They are mostly managed by the ASP pages. The only clan packets sent/received,the server basically just broadcast them.

Quote:

---

Originally Posted by SheenBR

clans have nearly NOTHING to do with packets. They are mostly managed by the ASP pages. The only clan packets sent/received,the server basically just broadcast them.

---

You should study network before being adamant about something you don't know ;]

Hmm... What Sheen means is almost certainly correct. What he just said (when he reconsiders, I'm sure he will agree) is completely wrong.

No information passes between two computers over the internet which is not packetised. Therefore... without packets... each client must make up clans entirely independently of the server and all other clients. This is, quite clearly, not the case.

The PT server has almost nothing to do with clans, or clan packets. The client communicates directly with the Web Server (not necessarily IIS) via packets. IIS communicates with your browser via packets... it cannot communicate anything without packets.

The client could communicate with Windows HTTP Client without packets... but it does not. Windows HTTP Client could communicate with the Clan server via packets and provide "pages" to the client, and the client would get the same information, and be less tied to a particular web servers packet encoding. (specifically, the encoding used by IIS) But it does not.

The PT client treats the IIS server like a generic internet communication service... like it treats the PT server. It doesn't treat it like a "web" server, much. Or, to put it another way, it implements it's own, built in and inflexible web client, rather than using built in system routines for dealing with the higher HTTP protocol. (that's redundant, but done to be explicit)

The communication is:-
Client <- TCP/IP <- HTTP <- IIS

It is not:-
Client <- HTTP <- TCP/IP <- HTTP <- IIS

If it where the later, then any HTTP compliant web server would do. Because it is not, there is no "decoding" of the general and open Web standard HTTP encoding. This leads to it being tied to the specific encoding produced by IIS. (in some circumstances)

There is more communicated between a web server and a web browser than URLs requested and pages returned. There are negotiation and identification "packets", and those are (or can be) as different for each web server as the "User Agent" packets sent out by every web browser. :wink:

(there are programs which can tell you what type of web server software is serving various pages on the internet, just as the above link will tell you what browser you are using... I can tell my browser that it is a Sony Playstation and that site will believe it... a web server can transmit via a web proxy and it's identity will also be masked)

http://i.imgur.com/ursnE.jpg
Just for LOLs

It's a shame we can't tell Apace (or something else more widely available to non-Windows OS) to pretend it is IIS. :/: As I say... I believe you can set IIS up as a forwarding proxy for Apache, and IIS will encode the Apache packets like IIS packets and resolve the problem... except that that doesn't resolve anything, because if you have to serve the Clan data from IIS for the client to understand it, then it may as well be IIS which runs the scripts in the first place. :(: (the point, I believe, which Gregoo has been making for years :wink:)

Last page left... most annoying one. .aspx...................and I should get working clan system. other pages working in .php now.

I need help:

Code:

---

          objQuery = "SELECT SNo FROM CT WHERE ChName='" & chname & "' AND UserID='" & userid & "'"
            objCommand = New SqlCommand(objQuery, objConn)
            objReader = objCommand.ExecuteReader()
           
            Dim tticket
           
            If objReader.Read()
                                tticket = objReader.Item(0)
                                If ticket <> tticket Then
                                        objReader.Close()
                                        objConn.Close()
                                        Response.Write("Code=100" & strSplit)
                                        Response.End
                                Else

---

What this If objReader.Read() do?
Is it if row exist? if query exist? if some result of execution? bool value, true?

tticket = objReader.Item(0) is SNo value?

Quote:

---

Originally Posted by Gregoo

You should study network before being adamant about something you don't know ;]

---

you should stop being an arse hole ;]

I meant PT packets -.- and for almost every clan action, the server is not notified. clan is basically only client side. at least, I was able to implement clans in my emu just by rewriting the clan scripts and managing one or two clan packets. (if I remember, when you try to invite someone, you need to send a packet to the desired player, dont remember very well.)

@vormav
Yes. it is " if row exists then, if results > 0 then... " and yes aswell.

I guess it is

Code:

---

If New SqlCommand("SELECT SNo FROM CT WHERE ChName='" & chname & "' AND UserID='" & userid & "'", objConn).ExecuteReader.Read As Boolean

---

I can make "bugged" clans. They don't load when you relog.

1st problem is in request for logo (.bmp), it gives me randomHex.bmp.
It can be forced but it will generate bugged data in client.

2nd is in clan load, client is not sending player name but here forcing it is crashing game.exe :/
Most likely because of bugged clan data file on client sided.

__EDIT__

ERROR 65 supposed to be some lack of read permission, I think I have all I need except execution.

Don't get why I can get correct .bmp name :/

Do the results look the same (correct) in a browser?

Browser will not show you everything, ClanContent/<clanIconNumber>.bmp is not part of php scripts. It takes info partly from SQL, Clan.dll and client.exe

I remember that I had problem like that (<randomHex>.bmp) on windows, but I cant remember how I fixed it.

Yes, I recognise that. Part of it is what I was saying earlier, but part is also URLs, which Apache logs, I believe?

PT caches the clan mark BMPs, but gets them from the server if they are not cached when it first encounters someone from that clan?

The clan mark (by number) for the user and any players from other clans they see is still HTTP GET? (I thought it was, but I could be wrong)

--- EDIT ---
I've spent all week downloading all the parts, and re-downloaded 3 which where clearly smaller than the others. I still can't get the correct checksum or decompress.

Can you post a 10% - 20% redundancy par2 RAID set for the collection Vormav? I'm sure I can't be much more out than that now. :(:

If you don't have a parchiver XD (yes, people do call them that) then I would recommend QuickPAR for a first-timer. The redundancy slider makes all the other settings super easy. :D:

There is no problem with sending clan logo. Problem is right before it, correct logo <name>. It must be some stupid bug I made in .php or Clan/SQL .dll

Do you have clan systems from this site:
http://forum.ragezone.com/f562/guide...ooting-166920/

(X files (Happy Edition) - Original clan files but are buggy)

(QuantumFusion modded X Files – No reported bugs, automation of image creation! Known flaw is possible SQL Injection.) Recommended

Links are dead.


BTW. What is "Original clan files"? Official leak?



PARTS 1-19 should have 209.72 M, last part is 110.20 M. Tell me what parts giving you wrong size and I will upload them on some other server.

Quote:

---

Originally Posted by Vormav

BTW. What is "Original clan files"? Official leak?

---

They were leaked? I thought sandurr wrote them from scratch :ehh:

I thought so too, that's why I'm asking. If there are official files than I would prefer to work with them.

I think it means the "original" rework. It wasn't all Sandurr, though I think he was the first to have any kind of reliable SoD score system.

There are old threads still present where people where decoding URLs and packets to get this, that or the other clan feature working, and I would imagine that the Chinese devs where working at least as hard in private, and leaking various successes to us through "the usual channels". :wink:

All my sections are 209,715,200 except the last which is 110,202,758. Extraction or parts creates a single password protected 7z file and notes that the checksum is invalid and it will be corrupt. :(: (someone else mentioned a password ... maybe this is what they, also meant?)

I don't want to download the entire set again, so par2 files seem the logical solution. An SFV of the set may tell me which section(s) corrupted though.

P.S. Those links where dead when I joined RZ. I'm not the longest standing, Telatoro or DarkAvaThar would remember those times, DK may remember them being up, but I know he's had massive data loss since then.

Unpack them with 7-Zip 9.20?
Inside there should be another 7-Zip file.

___EDIT


I forgot to tell you but this release have non free driver and key most likely expired by now.
But no worries I'm testing free open source driver, it works but I need to fix datetime fields in MySQL, they cant be 0000-00-00. MSSQL -> MySQL giving different date format so fields getting 0's. I can fix it but for now you can use non free driver, it have free trial.

My copy shows:-

Code:

---

7-Zip [64] 9.22 beta

---

But it looks like I've got it fixed by randomly replacing downloads I was concerned about.

To relieve such stress from others...
SFV:-

Code:

---

PTServer_Debian__7-Zip_9.20_.7z.001 0B729F6D
PTServer_Debian__7-Zip_9.20_.7z.002 6BB58F9A
PTServer_Debian__7-Zip_9.20_.7z.003 29CDC2F6
PTServer_Debian__7-Zip_9.20_.7z.004 2BAD2F6E
PTServer_Debian__7-Zip_9.20_.7z.005 381666AD
PTServer_Debian__7-Zip_9.20_.7z.006 871358B4
PTServer_Debian__7-Zip_9.20_.7z.007 11BE0E90
PTServer_Debian__7-Zip_9.20_.7z.008 CAC21755
PTServer_Debian__7-Zip_9.20_.7z.009 835A9A3E
PTServer_Debian__7-Zip_9.20_.7z.010 CF61EA06
PTServer_Debian__7-Zip_9.20_.7z.011 42311541
PTServer_Debian__7-Zip_9.20_.7z.012 00390085
PTServer_Debian__7-Zip_9.20_.7z.013 B344E649
PTServer_Debian__7-Zip_9.20_.7z.014 26D9C92E
PTServer_Debian__7-Zip_9.20_.7z.015 948D9DB7
PTServer_Debian__7-Zip_9.20_.7z.016 790065AE
PTServer_Debian__7-Zip_9.20_.7z.017 9B8DF0B1
PTServer_Debian__7-Zip_9.20_.7z.018 FAC1C732
PTServer_Debian__7-Zip_9.20_.7z.019 1F6F1292
PTServer_Debian__7-Zip_9.20_.7z.020 E97712E6

---

MD5:-

Code:

---

ae1f0fa0041a363db3e3ddc1fd5e2d8a *PTServer_Debian__7-Zip_9.20_.7z.001
6e6f074e4362fe9aa7d835f4803be39e *PTServer_Debian__7-Zip_9.20_.7z.002
cb4e0336ee63d636e357de7d1fec1b38 *PTServer_Debian__7-Zip_9.20_.7z.003
820f274d4760c81314f13bb0e31982c0 *PTServer_Debian__7-Zip_9.20_.7z.004
59d305190ac571c80875b00f44e1f6f5 *PTServer_Debian__7-Zip_9.20_.7z.005
b1bba1f915d1a310a7e9c4eab011f743 *PTServer_Debian__7-Zip_9.20_.7z.006
7af5649dc1c65323a8ffb269eb1933b9 *PTServer_Debian__7-Zip_9.20_.7z.007
f7573bdcd5d68e72558b79d308f504dc *PTServer_Debian__7-Zip_9.20_.7z.008
33989aca202536bf3ac5de82bc5db245 *PTServer_Debian__7-Zip_9.20_.7z.009
e0686714dc3f95930c86bcbb00054d50 *PTServer_Debian__7-Zip_9.20_.7z.010
8f564bf5b43f69d54d7d1b3d0a8cb97d *PTServer_Debian__7-Zip_9.20_.7z.011
886bc48dda350f9410b602e5a71832b7 *PTServer_Debian__7-Zip_9.20_.7z.012
205096cac39dee7016e0940029e4a6e1 *PTServer_Debian__7-Zip_9.20_.7z.013
963fd70e3dc2e7476b2869bdbcdd581e *PTServer_Debian__7-Zip_9.20_.7z.014
f0116e5f27bedd43cc3f67a8bff98b3d *PTServer_Debian__7-Zip_9.20_.7z.015
03b2fd270bbf76a2b3e85d0a4431d3a1 *PTServer_Debian__7-Zip_9.20_.7z.016
1cc4c3520a64c0269c33087c200e1705 *PTServer_Debian__7-Zip_9.20_.7z.017
a3b64b29daeeb383797bb024be5113f6 *PTServer_Debian__7-Zip_9.20_.7z.018
b7b71adbf43d4dc33f61479ba0534381 *PTServer_Debian__7-Zip_9.20_.7z.019
9050e3ca497178d44541da7a10bdde70 *PTServer_Debian__7-Zip_9.20_.7z.020

---

PAR2:- Attachment 99159 (Zipped, so it can be attached)
Other parts:-

PTServer_Debian__7-Zip_9.20_.7z.vol000_001.PAR2 1 block
PTServer_Debian__7-Zip_9.20_.7z.vol001_002.PAR2 2 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol003_004.PAR2 4 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol007_008.PAR2 8 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol015_016.PAR2 16 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol031_032.PAR2 32 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol063_064.PAR2 64 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol127_128.PAR2 128 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol255_137.PAR2 137 blocks
PTServer_Debian__7-Zip_9.20_.7z.vol392_137.PAR2 137 blocks

Illustration:-

http://i.imgur.com/eTZ1D.png

The idea:-

The .par2 will tell you which parts are corrupt and by how much. QuickPAR can then tell you how many blocks you need to repair the corruption. The PAR2 part files are in ever increasing sizes so you can get just as many or as few as you need to to meet the block count you require to repair.

So... say QuickPAR said I needed 120 blocks more to repair 3 files, I could get PTServer_Debian__7-Zip_9.20_.7z.vol007+008.PAR2, PTServer_Debian__7-Zip_9.20_.7z.vol015+016.PAR2, PTServer_Debian__7-Zip_9.20_.7z.vol031+032.PAR2 & PTServer_Debian__7-Zip_9.20_.7z.vol063+064.PAR2, or I could just get PTServer_Debian__7-Zip_9.20_.7z.vol127+128.PAR2 or any larger part file.

QuickPAR can reconstruct the broken files (and the missing PAR2 Parts) from the information I then have. It's a RAID, only it's a file RAID rather than a disk RAID. See?

All the data in all the files (original and PAR2 combined) is interconnected, so that being confident of the correct state of one part doesn't just tell you that, but also that another part is correct, or incorrect. Which part, and where. Also (with growing certainty, the more data you are confident about) what must be done (how it should be changed) to make it correct.

The par2 set totals 777Meg, and provides 20% redundancy. Each of your split parts is about 5% of the total data, so you could be completely missing about 4 7z.* files (assuming you had all the others in immaculate condition) and the complete par2 set could reconstruct those entire files. :wink:

I don't pretend to understand the math behind it any more than I understand how to engineer a Formula 1 Racing Car (I get the principals behind many concepts, but couldn't do anything like it my self) but I've been using them for years, and they totally own. :D: (still not sure why you didn't archive and split in one operation)

P.S. LOL, that VM has more memory allocated to it than my host. XD I hope it will run with considerably less.

Remember to download this driver http://cherrycitysoftware.com/ccs/Do...SQLPV(x86).zip
install it on windows, generate your free code and hex it into SQL.dll and Clan.dll on debian.

I will play with clans a bit more and post version with free open source driver later or just post tutorial how to use free oledb driver.

ty helped me a lot

Finally, I'm able to create and load clan!
I still need to do some fixes here and there.

Next release might be final if I implement free oledb driver.

So far I'm running server on
debian sid, apache + php, wine 1.5

I need to find a way to slim my release, I was thinking about DSLinux or just debian with light gui ( without games :( ).

Yea... I wondered why I had downloaded 2 complete office suites, a photo editing suite, Vector graphics suite, 3 PDF viewers, 2 Mail servers! 2 DNS servers, 5 complete multi-lingual dictionaries, web-cam & scanner software, 2 complete 3D hardware acceleration engines and 3 or 4 audio engines, 2 full multimedia playback suites and several streaming media clients and servers... etc. all on a VM which I can't (easily) attach such devices. (3D acceleration is kinda beta at best, scanners and cameras don't work and this appliance doesn't support audio hardware XD [it could, but that would just be annoying)

The packagemanager wouldn't allow me to "uninstall" so that was a bit of an arse. Guess I need to know a root password too. (but I think Deb can disable the default root account) Using root and init level 2 or 3 Synaptic / apt-get will allow pretty fine grain control over such things in Deb, but the Debian build policies kinda assume everything will be available, which makes for unnecessary application dependencies IMHO.

My 2-cents would be to check out Frugalware. If DSL will do, then I'm sure Frugal will too. Stick with LXDE and minimal package installation and you should have a pretty small, and very functional "no frills" Linux VM Appliance. My Frugal dev VM is under 3Gig (live IMS, PC down :(:) for an x64 desktop system with several IDEs for C++ and C#, complete SDKs and frameworks for just about everything (GTK, Gnome, WX, QT and such) and multiple user accounts. It runs smooth on half a gig RAM and has basic internet access to look stuff up, check out coding examples and get new frameworks an assemblies.

Oh, it has all the common SQL databases too, MySQL, Postgre, Berkly, SQLite... Can't remember what web server (if any) I put on, I'm very fond of Cherokee right now, but Lighty rox for test purposes too. Of course, PHP & Perl are there as per normal. Don't remember if I put Python and Ruby on or not. :/:

Cherokee look interesting and I might give it a try. It depends, if I can get deb repository with Cherokee packages. Too bad it can't run on windows.

I think I will stay with debian. Min install + some light gui.

I will have to stay with MySQL too, I can't find any free driver for SQLite. There might be one for PostgreSQL but syntax is different, SQLite have similar syntax but no free driver.

So far nearly everything is done, clans are running flawlessly.

TODO:
- convert MSSQL dates generated by PT server
- remake Auto SoD2 Score script

__EDIT__

- sod2 is working :D

how did you open the server.exe executable? isnt it designed for windows? lol

There is "app" called cheap red wine that let you run windows applications.

http://wine-bohemia.info/wp-content/...wines-7681.jpg

is it reliable?

@Sheen: Some variant of Wine is common place on most Unix systems. Even Macs have Bordaux. It's more effective than Microsoft Services for Unix. A closer analogy (doing the same thing in reverse) would be Cygwin. The big point is that it is useless for almost anything that uses the latest DirectX. Closed source technologies like that take time to reverse, and old DirectX (like PT) nobody can be bothered to put the effort in. XD

With the server, it may load DirectX but never uses it. So the fact that Wine can't support MS-SQL is the big problem.

Quote:

---

Originally Posted by Vormav

Cherokee look interesting and I might give it a try. It depends, if I can get deb repository with Cherokee packages. Too bad it can't run on windows.

---

There are Windows builds of Cherokee but they are quite old, and no "current" build is working, as there is no Windows maintainer.

Quote:

---

Originally Posted by Vormav

I will have to stay with MySQL too, I can't find any free driver for SQLite. There might be one for PostgreSQL but syntax is different, SQLite have similar syntax but no free driver.

---

Google served me this SQLite ODBC Driver for Windows x86 / x64, Linux and Mac as the first hit. :o It is free? (BSD-Style license, so may not be as free as we would like)

Quote:

---

The authors hereby grant permission to use, copy, modify, distribute, and license this software and its documentation for any purpose, provided that existing copyright notices are retained in all copies and that this notice is included verbatim in any distributions.

---

Seems fairly "free" to me.

Also... Yes, Deb (and derivatives like Ubuntu and Knoppix) is very popular, and with good reason, it's a solid platform which is easy enough to adapt to your desired purpose. It's still a little too "Windows" like in terms of "bloat" for my taste. :\

@SheenBR
Its quite stable. I'm using unstable version on unstable debian lol, PT server can work 24/7 without crashing. It can even run your old games that have problems running on new windows.

Quote:

---

Originally Posted by bobsobol

There are Windows builds of Cherokee but they are quite old, and no "current" build is working, as there is no Windows maintainer.

---

This is only argument against. I would prefer to keep it cross-platform. Apache + PHP + MySQL + PT Server.
The reason for that would be debugging and development. IDA works OK under wine (there is even native version) but ollydbg don't.

Quote:

---

Originally Posted by bobsobol

Google served me this SQLite ODBC Driver for Windows x86 / x64, Linux and Mac as the first hit. :o It is free? (BSD-Style license, so may not be as free as we would like)Seems fairly "free" to me.

---

Yes but this is ODBC, and I need OLEDB, it is a different type of provider. It does not require that you set up a DSN. I think oledb support was added around wine 1.3? Something like that. My first try was on 1.2? I tested DSN like connections on dlls and they don't work or work partly for login.

I'm happy with new free driver I'm using. Compared to not free one its actually showing me errors and not letting PT use bugged query. More fixes are needed but at same time I'm sure what was executed correctly in SQL/Clan.dll and what not.

Quote:

---

Originally Posted by bobsobol

Also... Yes, Deb (and derivatives like Ubuntu and Knoppix) is very popular, and with good reason, it's a solid platform which is easy enough to adapt to your desired purpose. It's still a little too "Windows" like in terms of "bloat" for my taste. :\

---

In PT server case I'm looking more at already compiled soft. Compiling wine will require from your to install lot of useless soft and dev packages.

Debian SID have wine up to 1.5 and any soft I need I get with apt-get.

@OLEDB: Ahh, I see the problem now. The best advise I've seen is to use the OLEDB provider for ODBC. :\ I think that's just going to cause more problems, and SQLite isn't ideal for larger servers anyway.

@apt-get: Frugalware pacman has wine 1.6 pre-compiled. link I can't imagine what you may need that you can't find on pacman TBH. But Windows is about the only system I know of which doesn't have a decent single recommended repository manager for adding and removing software packages. Whether it's pacman, apt-get, portage, RPMs, AppStore, Tracker or Servant... there is usually a tool. There's even one for ReactOS. (the open source Windows clone) :lol:

1.6 is frugalware version (distribution version) not wine version XD


2. wine 1.2.3-3
Version: 1.6; Architecture: i686

3. wine-devel 1.3.37-1
Version: 1.6; Architecture: i686


There is no wine 1.6 yet. 1.5.2 is newest :)