Server Help

fatrolls

Patched Subbill.exe v0.23
Patched offset 0x00000B53 from 0x00 to 0x0A

Seems I reverted it back to Original Subbill before someone patched it before me to 0x00

Which just changes
Sleep(0);
to
Sleep(10);

Why would you want to Sleep for 0 anyways it doesn't do anything afaik.

Takes about 2,4 Megs of Memory not too bad.
Also did you know that the original Subbill is pretty good to use as permanent solution could support over millions of logins without storing them in one risky file User.dat,

All you have to enable is ODBC data source which connects to SQL Server. (I think it's Microsoft SQL Server).

Has SQL commands such as

Code: Show/Hide

INSERT INTO Usage (ServerID,PlayerCount,UsageStamp) VALUES (%d,%d,%s)
INSERT INTO Usage (ServerID,PlayerCount,UsageStamp) VALUES (0,%d,%s)
UPDATE Users SET Banner='%s' WHERE UserID=%d
INSERT INTO Security (UserID,ServerID,MessageText,MessageTime) VALUES (-1,%d,'%s',%s)
INSERT INTO Security (UserID,ServerID,MessageText,MessageTime) VALUES (%d,%d,'%s',%s)
INSERT INTO Messages (FromUserID,ToUserID,ServerID,MessageText,MessageTime) VALUES (%d,%d,%d,'%s',%s)
UPDATE Users SET Squad='%s' WHERE UserID=%d
INSERT INTO Squads (SquadName,SquadPassword,SquadCreatorID) VALUES ('%s','%s',%d)
UPDATE Users SET Squad='' WHERE UserID=%d
UPDATE Users SET Squad='' WHERE Squad='%s'
DELETE FROM Squads WHERE SquadName='%s'
UPDATE Users SET Squad='' WHERE Alias='%s' AND Squad='%s'
UPDATE Squads SET SquadPassword='%s' WHERE SquadName='%s'
UPDATE Users SET Password='%s' WHERE UserID=%d

There is 2 SQL Procdures (Which may be hard to recreate.)

Code: Show/Hide

EXECUTE StandardUserLogOut @pUserID=%d,@pDeltaSeconds=%d,@pLastMachineID=%d,@pLastTimeZoneBias=%d,@pLastIP='%s',@pServerID=%d,@pReason=%d,@pPacketLossS2C=%d,@pPacketLossC2S=%d,@pPing=%d,@pLatency=%d,@pZoneData=0x%sFF,@pScoreID=%d

EXECUTE StandardScoreUpdate @pZoneData=0x%sFF,@pScoreID=%d,@pUserID=%d

Seems the sql files were either lost or never got transfered from Virgin Entertainment.

It contains for squad commands the message *UNKNOWN* which is the same as in SSC makes me think SSC Biller is just a patched Subbill for SSC Billing server.

Cheese · Posted: Mon Apr 07, 2014 8:36 pm Post subject:

1) who are u
2) how long have u played this game
3) why do u seem to know what you are doing
4) why do u have a compulsive disorder of some kind
_________________
SSC Distension Owner
SSCU Trench Wars Developer

fatrolls · Posted: Mon Apr 07, 2014 9:52 pm Post subject:

I like perfecting things as far as I can. You know who I am I seen you on distension in tw. I usually played/hanged out in EG since 2001 I even got my name on some of the bases I made there ages ago in EG.

Other then that I'm just trying to help out

Cheese · Posted: Tue Apr 08, 2014 1:53 am Post subject:

well i hope u are legit because u seem to know what u are doing

Cheese · Posted: Tue Apr 08, 2014 5:33 pm Post subject:

if you ever start working on subgame:

an extremely huge problem with subgame is that there is a traffic limiter that crashes the zone if a sysop sends commands too quickly

talk to jabjabjab ingame for extra info, he thinks he found a hex offset or something awhile back

cycad · Novice Gender: Joined: Feb 12 2004 Posts: 29 Offline

cycad · Novice Gender: Joined: Feb 12 2004 Posts: 29 Offline

CypherJF · Posted: Thu Apr 10, 2014 8:16 am Post subject:

cycad · Novice Gender: Joined: Feb 12 2004 Posts: 29 Offline

fatrolls · Posted: Thu Apr 10, 2014 10:06 pm Post subject:

fatrolls · Posted: Sat Apr 26, 2014 12:18 pm Post subject:

I'd like to correct you on thread yield idea you had cycad.

subgame and subbill were both made for Windows 95 this is back when threads / threading didn't even exist they did have multi-tasking though.

The way subgame seems to be completely single threaded the Sleep(0); was probably required for Windows 95 multi-tasking so the application doesn't hog the whole system up. Kinda like DoEvents() in Visual Basic I think.

There is no CreateThread API's and yeah that api only existed since Windows XP.

It also spawns other programs in the background like tracert and has the ability to spawn itself for multiple zones and to just run remote tools.

Such as this example:
In a batch file type

Code: Show/Hide

subgame2 /SPAWN notepad

you could use that to open notepad using subgame2

/SPAWN command runs cmd.exe or command.com whichever your OS supports with a /c flag

I don't think the /SPAWN command was used for anything else then spawning other subgame servers.

you could use

Code: Show/Hide

subgame2 /SPAWN subgame2

this will spawn 2 subgame2 servers in one command prompt probably not to have too much command prompt windows on the screen, it will still run 2 processes.

I was thinking that subgame2 was like httpd (apache) where it spawns a bunch of processes of itself for multiple connections, but that will have a hard time synchronizing stuff only thing it spawns is the tracert program which is used for the command *trace

Also I wonder I'm checking out the Subspace CD server files and I can't seem to find the tracert.exe executable even though the command exists in the subgame.exe I guess they forgot to include it and everytime someone did the trace command the subgame.exe would crash haha.

Seems the official tracert.exe was never leaked and was remade by PriitK luckily it doesn't seem too important

Cheese · Posted: Sat Apr 26, 2014 6:46 pm Post subject:

is it possible whatever compiler he was using saw the 0 in sleep(0) and optimized away the entire thing because 0 < 1

cycad · Novice Gender: Joined: Feb 12 2004 Posts: 29 Offline

Sleep(0) being a yield is documented behavior of the API call, I'm not sure why you think it's an "idea" I had. CreateThread and threading both existed in Windows 95.

tracert.exe is a program for tracing network hops that comes standard with Windows.