Jump to content
SubSpace Forum Network

Recommended Posts

Posted

SOS, I am working on getting a high-speed internet connection at home, and it should be good to go this weekend (the download speed is 800kbs but the upload is like 20kbs = crap)

 

= 100 K/sec download and like 2K/sec upload

 

Once I get this going, if you want me to, I can work with the website design updates.

 

I am pretty !@#$%^&* familiar with the php/html, and once I get it up its not hard to maintain, and I have time for something like that.

 

Just hook me up with FTP/webite address info and I can get things like the scores working and such (and !@#$%^&* I can even get you past records from back in the day to look up).

 

I'm not familiar with the database stuff, but the website will probably be done in PHP (since I think that is how it is set up now already), otherwise HTML.

 

I'm taking a database course in school this term, so i'll be able to help you out with that stuff maybe too soon!

Posted

Ok, website is slowly forming. I've got Trained doing graphical design and am working on the code myself. Trained has some nice gfx skillz, which is good :D

 

Currently, a few things are up already. Nothing much to look at - !@#$%^&*, it is not even well-formed HTML blum.gif But still... something of interest, maybe. A race records table, for example. Woot, I have both ?go race records!

 

http://deva.sszones.com

 

Man, that records table took a few hours of my time to get correctly working. Quite a nasty database query, heh (for a newbie like me). I've never used LEFT JOINs before...

 

SELECT t.Name AS TrackName, e.Time, e.Timestamp, e.GameId, e.Ship, p.Name AS PlayerName FROM race_tracks AS t
JOIN race_games AS g ON g.TrackId = t.Id
JOIN race_entries AS e ON e.GameId = g.Id
JOIN players AS p ON p.Id = e.PlayerId
LEFT JOIN (race_entries as e2, race_games as g2) ON (g2.TrackId = g.TrackId AND e2.GameId = g2.Id AND e.Time > e2.Time)
WHERE e2.GameId IS NULL ORDER BY e.Timestamp DESC;

Posted
Ok, I am running out of neat interactive stuff. Tell me more ideas :D

 

A new population graph (the one at stats.trenchwars.com i dont like) ... one that shows a monthly trend would be good.

 

Oh, and just incase you did not recieve my email SOS ... I can't find my old website layouts.

 

P.S. if you want to show the subspace.edome.net statistics on the webpage .. just view the source of the HTML and copy out what you need.

Posted

SOS what is up with that action map? How does it work.

 

You may want to consider adding colours to it ... like a radar screen or infra-red satelite photo such that the more active the area, the brighter the colour.

Posted

It shows where the action is :mellow: (ie where people shoot)

 

And active areas do show up brighter. It just does not have enough data yet - most areas have seen more or less the same amount of fighting.

Posted
Action map algorithm improved. It now looks much cooler smile.gif

 

Yes, it does look cooler

 

Question: Does the yellow colour change or just get brighter?

 

It might be a cool idea based on frequency to use colors where it starts off blue in areas that are barely used, which gets darker when it is used more, then green, which gets darker, then yellow, then orange, then red, then deep purple for the most frequent areas.

 

That is basically how a colour-radar works.

 

P.S. somebody should fire bombs in a way to put their initials in an unused area of the map, lol.

Posted

Hmm... color-shifting might be annoyingly difficult.

 

Oh wait, I've done it before. No, it's simple.

 

Right now, the brightness changes. Hmm... ah, I think it'll do for now blum.gif

Posted
Hmm... color-shifting might be annoyingly difficult.

 

Oh wait, I've done it before. No, it's simple.

 

Right now, the brightness changes. Hmm... ah, I think it'll do for now blum.gif

 

 

I hope it doesn't become blinding bright though blum.gif lol

  • 2 weeks later...
Posted

Last time I checked, Trained was suppose to do graphics or something for the website, but don't know if he ever got to it.

 

And the high scores brings me to a popup that brings me to another popup with the scores :/ 1 is enough imo

Posted

If trained is making a website, that is excellent.

 

I've had no discussions with trained yet, so I am not sure.

 

ANybody is welcome to make a design attempt ... or create content FOR the website.

 

If it turns out that nobody can design a website, I can do it ... thats something i'm good at.

 

Well, I would still like graphics ... i'm not great at that part.

 

-xdoom

Posted

As you all know, I am SOS's !@#$%^&*, and hes not affiliated with Dev anymore, so I wont be doing the website. Here is a preview of 2 of them I had:

 

The first one is one you can have. I got the PSD's for both, but the second one is for a layout I made, and can be purchased for $35.

deva1.gif

deva2.gif

Posted

Thanks but no thanks, i'm not paying for a website I could easily do myself.

 

 

 

The first one isn't great, I can see weapon fire in the background that did not come from this zone.

 

The second one .. .Devastation is spelt wrong.

 

Its DevAstation not DevIstation ...

Guest
This topic is now closed to further replies.
×
×
  • Create New...