Et: Xreal

(Dushan) #441

Sorry about that. It was my debug and testing build what I was using at that time.
I fixed release build and compiled it again.

Latest release compiled

I also did some little work on MySQL feature in OpenWolf and enabled connecting to it.

mysql update.jpg1020×767 88.9 KB

EDIT #2: added one more photo

mysql update #2.jpg949×715 91.2 KB

EDIT #3: added one more photo

mysql update #3.jpg953×713 92.2 KB

Game should connect to “testdb” and there to create two tables “Players” and “player_stats”.

Soon I will rewrite all parts of game that is for me vital for MySQL and centralized database for IP, MAC, XP, GUID, awards, mod/game levels, skill levels, ban, mute … So that don’t have to be anymore in any mod. For me that is better, so mod can call GUID from global database and give player his XP and levels to server where he is playing …
One down part of that is that player need to register his account and GUID to database, and log in if he want to have all his scores. But that isn’t major down part of it. If player leave game and return after X months/years. He can still login with his details (password/username) and receive his full account).

I have looked for Quake 3 ver. 1.25 and how that did that, and saw that feature before in Q3 was big overkill for master server. For global statistics on Quake Live I really dont know how that is working.

That’s why I believe that this is best approach to this feature at this time. If am wrong please tell me and what is best approach to this feature.

EDIT #4. You can also host MySQL database on your localhost/clan server

I also checked OpenID … but what I found that was only for Content Management System (CMS) or a web-based framework or service for blogging, wikis or forums/bulletin boards. So basically stuff like that …

Only problem is that I started like 10 things. And to finish all that it need time. But all can be finished.

(dutchmeat) #442

A global database ? That’s quite a challange.
You might want to keep these things in mind;

  • Only Authoritative servers can send stats (servers need to be validated for obvious reasons)
  • Stats derrived from interacting with a bot don’t count
  • Encryption and data compression (I don’t know what kind of encryption and compression you’re using now, but a simple php script won’t cut it)

While I’m fairly unfamiliar with OpenID, I do know that it’s posible to use this in any client, just because of the fact this is reachable with HTTP(s).

Try to use an existing application that uses OpenID and record the packets that is being sent to and from the OpenID server.

Good luck with OpenWolf

(ailmanki) #443

Seems Steam uses also OpenID.
http://openid.net/developers/libraries/

Global statistics; I think the difficulty is the amount of data to handle. Splatterladder and those have that problem too, but they only scan each server for xp and playername.

Google Fusion Tables sounds like win in combination with charts, the maps - well ; if commandmaps would be in google map… LOL.
edit: fusion tables can SQL

(Dushan) #444

This is my initial MySQL table structure what game create on start … Not finished yet.
Basically here we have 4 tables. Mod_specifics is what I believe that every mod need to call from MySQL database. Player_stats may be still expanded and added more game specific statistics. Parts_stats table is created from info from VSP Stats.
Well server_log is something, I need to see how ET write etserver.log and try to move that to SQL.
User_info table what I believe that is need to be there.

If i miss something or wrong, please tell me what I did wrong.

–
– Table structure for table mod_specifics

CREATE TABLE IF NOT EXISTS mod_specifics (
GUID varchar(33) DEFAULT NULL,
IP4 varchar(15) DEFAULT NULL,
IP6 varchar(39) DEFAULT NULL,
MAC varchar(17) DEFAULT NULL,
XP varchar(255) DEFAULT NULL,
LEVEL varchar(255) DEFAULT NULL,
SKILLS varchar(255) DEFAULT NULL,
BANNED varchar(255) DEFAULT NULL,
MUTED varchar(255) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

–
– Table structure for table player_stats

CREATE TABLE IF NOT EXISTS player_stats (
MAP_ID varchar(100) DEFAULT NULL,
PLAYER_ID varchar(100) DEFAULT NULL,
KILLS varchar(100) DEFAULT NULL,
DEATHS varchar(100) DEFAULT NULL,
KILL_STREAK varchar(100) DEFAULT NULL,
KILLS_PER_DEATH varchar(100) DEFAULT NULL,
KILLS_PER_GAME varchar(100) DEFAULT NULL,
GAMES_PLAYED varchar(100) DEFAULT NULL
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

–
– Table structure for table server_log

CREATE TABLE IF NOT EXISTS server_log (
MOD_NAME varchar(255) DEFAULT NULL,
MOD_VERSION varchar(255) DEFAULT NULL,
MOD_URL varchar(255) DEFAULT NULL,
NAME varchar(255) DEFAULT NULL,
GUID varchar(33) DEFAULT NULL,
IP4 varchar(15) DEFAULT NULL,
IP6 varchar(39) DEFAULT NULL,
SAY varchar(255) DEFAULT NULL,
SAYPM varchar(255) DEFAULT NULL,
SAYFIRETEAM varchar(255) DEFAULT NULL,
Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

–
– Table structure for table user_info

CREATE TABLE IF NOT EXISTS user_info (
ID bigint(20) DEFAULT NULL,
UserName varchar(255) DEFAULT NULL,
Password varchar(64) DEFAULT NULL,
EMail varchar(64) DEFAULT NULL,
Clan varchar(64) DEFAULT NULL,
GUID varchar(33) DEFAULT NULL,
IP4 varchar(15) DEFAULT NULL,
IP6 varchar(39) DEFAULT NULL,
MAC varchar(17) DEFAULT NULL,
Picture varchar(255) DEFAULT NULL,
PrivateMessage varchar(255) DEFAULT NULL,
Timestamp timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

EDIT: And btw every version of ET is compiled without “Authorize Support”. I even asked here on forum is that working along with “Autoupdate Server”, but never got proper answer.

About Steam and OpenID. I saw that there is support for CSharp. But am not that much in C#.
Google Fusion Tables I dont know what is that and what it do.

(Indloon) #445

I´m interested of database of game .
With get database is imbossible to generate stats signature.
Alos with it is imbossible to do this: http://www.dayofdefeat.com/stats/
I´m currently working on ET online server browser,but this,I´m curious.

(etwolfmod) #446

With something like a database wouldnt it be doable to have ET-Live?

(Tr3B) #447

Everything is possible with open source projects. However most people underestimate the amount of work.
I read a lot of bull**** in this forum like creating ET2 and that it would be better based on Unity 3d or the UDK.
I have experience with both engines and I highly doubt that anybody here has any clue how much work it is to write a game code like ET has.
The only realistic way to improve ET is by doing smaller incremental changes.
BTW I will release ETXreaL 0.9.0 soon. There is only some work left to improve the interoperability with the latest DarkRadiant.

(Tr3B) #448

I improved ETXMap to make it easier porting old ET .map files to the new Doom 3 standard so they can be edited with DarkRadiant.

goldrush.map

converted using


./ETXMap.exe -fs_basepath .. -map2map -format quake3 ../etmain/maps/goldrush.map
(kamikazee) #449

[QUOTE=ailmanki;334879]Seems Steam uses also OpenID.
http://openid.net/developers/libraries/

Global statistics; I think the difficulty is the amount of data to handle. Splatterladder and those have that problem too, but they only scan each server for xp and playername.
[/QUOTE]Those libraries are used to make web applications. Having OpenID authentication in the game would thus require an embedded web browser, as you need to switch back and forth between the OpenID provider and your application.

Maybe you could make a website where you can register your account and ETkey, then only use the ETkey so you don’t need to log into servers in the game.

(daz2007) #450

[QUOTE=Tr3B;335408]I improved ETXMap to make it easier porting old ET .map files to the new Doom 3 standard so they can be edited with DarkRadiant.

goldrush.map

converted using


./ETXMap.exe -fs_basepath .. -map2map -format quake3 ../etmain/maps/goldrush.map

[/QUOTE]

awesome, cant wait for etXreal 0.9.0, would the Shaders need to be in Doom 3 Standards too when porting old maps

I also Suggest that EtXreal Maps should Use a Different Shader Path e.g. Shaders/sky.mtr to prevent Shader errors with Standard ET Maps.

This could be Done by Giving Etxreal Maps a Unique BSP Version

(dutchmeat) #451

[QUOTE=kamikazee;335454]Those libraries are used to make web applications. Having OpenID authentication in the game would thus require an embedded web browser, as you need to switch back and forth between the OpenID provider and your application.

Maybe you could make a website where you can register your account and ETkey, then only use the ETkey so you don’t need to log into servers in the game.[/QUOTE]

Still, I don’t see why you can’t do that using an ordinary httpclient.
I also don’t think we need complete libraries, as we’re only using the authentication part of OID

(Indloon) #452

[QUOTE=Tr3B;335403]Everything is possible with open source projects. However most people underestimate the amount of work.
I read a lot of bull**** in this forum like creating ET2 and that it would be better based on Unity 3d or the UDK.
I have experience with both engines and I highly doubt that anybody here has any clue how much work it is to write a game code like ET has.
The only realistic way to improve ET is by doing smaller incremental changes.
BTW I will release ETXreaL 0.9.0 soon. There is only some work left to improve the interoperability with the latest DarkRadiant.[/QUOTE]

Sound good.
But yes I must agree with you.
Just use Xreal and make psyhical movement changes…etc.
And name could be: Wolfenstein:Enemy Territory Modded Editon.
Also new XP system could be,this collect XP and lose your etkey:<

Btw I love your work Tr3B.
:smiley:

(acQu) #453

[QUOTE=dutchmeat;336022]Still, I don’t see why you can’t do that using an ordinary httpclient.
I also don’t think we need complete libraries, as we’re only using the authentication part of OID[/QUOTE]

Caus’ TEH library sounds better :wink:

(Dushan) #454

Little update :slight_smile:
Finally fixed problems with mod loading and map loading crash :slight_smile:

And now we can play Urban Terror, Tremulous, Quake 3 and RTCW maps

I tested that with Map_Citadel from Tremulous, Simpsons from Quake 3, Dangercity from Urban terror and sp_enigma_v2.0 from RTCW

citadel map.jpg856×642 96.2 KB

citadel map #2.jpg981×732 88.2 KB

citadel map #3.jpg871×651 95.5 KB

Dangercity.jpg779×584 98.3 KB

(Dushan) #455

simpsons_q3.jpg886×661 93.6 KB

simpsons_q3 #2.jpg961×720 87.4 KB

map enigma RTCW.jpg939×701 89.3 KB

(daz2007) #456

The Lightning is still horrible and not Right

here is what it should look like

The Problem i Have is that Some Map Models are Shown Completely Black

Also Quake3 Jump Pads Do not Work, would be Awesome if they worked too

(Shanks) #457

Game code issue not engine issue.

(Tr3B) #458

I created a Mod DB entry for ETXreaL so we have a community portal site besides the devsite at sourceforge.

(Mateos) #459

First member to follow, and already over 100 visits!

(dutchmeat) #460

Nice one Tr3b, you might want to ‘hire’ someone to maintain that page.