solinent

It is an in-progress work, there will be a javascript signature editor. Right now I just wanted to know if the navigation was ok.

Is that your MSN name or google talk?

Sure, I guess. I don't really need that much help, but if you could contribute signature images. Do you have an MSN or something that we can talk better on? We really shouldn't be doing this here Hmm, bungie seems to use a uid rather than a username, making it harder than it really should be. I doubt you would be able to do this if you didn't develop a mechanism where you could cache the results of bungie.net for a day, but this way you wouldn't have stats. Or you could cache uid's... that would work better actually.

Overflow basically makes a fixed height div have a scrollbar. So basically imagine an iframe, except the html contents are within the page. It's very versatile if you're using php.

Lol yeah I noticed Maybe I'll make another website xbox360.runeap.com and then make stats sigs for xbox360? I'd make the design the same except green It's not that hard to make these things, but whatever. If you direct me to a website where you can view stats, then I can get them (via file_get_contents).

Oh, I see. Hmm, my menu works on the PS3 browser. I was about to put up a message saying don't use the ps3 browser! DOH Yeah, I made the script myself, btw. Did you look at the forum post? The site's going to be more about that. If you're interested and have a ps3 and are good with photoshop (or two of the above) then I need someone to help me... (edit: you own a halo site, so I doubt it eh? well, if you ever want me to write a script like that for halo 3, then I probably will, even though I don't plan on buying an xbox until the price drops, I'm broke from the PS3 lol)

How big is the javascript library. Anyways thats besides the point. Did you try it out in firefox? please give impressions I dunno if they do anything like that for xbox 360, I know I'm the first (I was suprized) to do it for PS3. EDIT: sticky tabs are done They now stick if you have javascript enabled. Javascript doesn't have to be enabled in firefox, though. EDIT: I see jQuery is 61kB. That's a bit too big, it's more than what would be nessessary for html + css... unless I go through all the code and take out the unneeded parts...

Can't modify posts ??? Anyways, here's a page that has content, none of the menu links work currently (except one, but you won't get to this page). http://ps3.runeap.com/gthd/?u=solinent In firefox I have rounded coreners with -moz css. I don't want to use a image corner because it would take up quite a bit of html for every single one, and that's too much.

I would change: The top navigation should be fluid. So you should have all of them equal widths Make sure to test in firefox, specifically the login boxes are too large (overflow the container) Not a design choice, but I reccomend you use less ads. It may seem better, but my personal experience with google is that people only click the ads that are in the content or front and center. Put your name/friend's email box into one of those nice boxes that the others are within If you keep the bottom left ad, center it within it's box. Note that the width of everything is really wide for me, mostly because I'm using a 1440x900 resolution! Also, the front center content looks very good when you click-through.

Hi there, just wondering what you guys think of my design at http://ps3.runeap.com It's a minimal design, the navigation is really cool though. It's only been tested in firefox because I want to make all the PHP and stuff before I get into compatibility with browsers (because the design can change). However, I'd love if you gave me tips for making that nav-menu work in IE. I will probably just make it javascript. Which leads me to another thing. Do you think the navigation is too hard? Should I make it "stick" with javascript, so that it doesn't "go away" when you go slightly too far? This wouldn't be hard to make, but I won't do it if it means more code. I don't like javascript in general, so... Looking for comments on everything else also. One more thing, is, should I make the login (top right) be always there, or should it appear (with javascript) when you click the link. Thanks!

Yeah, I am doing that, but it doesn't seem to work. The SELECT doesn't return good results, or some error is happening. First I crawl some webpages, insert values into a table. Then, I SELECT the table in order, and then UPDATE it with the order number (because doing it with mysql every time would take too much time). This needs to run every day with cron, so I need to fit it in one script. It works if I separate the scripts.

You have to use the SELECT statement, and the value will be calculated on the fly. Columns can't "read" other columns. Could you explain yourself a bit better? If you wanted one column to equal another, you'd follow the same syntax as the other post here. Nevermind, whatever you're asking for should be done with PHP: $result = mysql_query("SELECT grade, name FROM table") or die("Error:".mysql_error()); while ($row = mysql_fetch_assoc($result)) { if ($row['grade'] >= 75) { $lgrade="A1"; } elseif ($row['grade'] >= 50 { $lgrade="B1"; } }

Can I do the following in the SAME PHP script? INSERT some columns SELECT inserted columns along with others UPDATE all the columns.

Let me try, one second. I have gotten the load times under .7 seconds by doing "OPTIMIZE". ... it is taking quite a long time to load, I hope I didn't break anything... This happend last time when I thought I had a good query. IS somehow the query circular that causes nothing to load? Here's what I modified SELECT a.* FROM gthd AS a JOIN (SELECT username,MIN(wrank) AS minwrank FROM gthd WHERE car=43 AND reg!= 'w' GROUP BY username) AS b ON a.username=b.username AND a.wrank=b.minwrank; Testing in phpMyAdmin

No no no, all the fields are wrong. So the most important field, their time, is wrong. It corresponds to a totally different wrank (the first one) rather than the one I displayed.

I got it to work with PHP in a couple minutes just now, very simple, but it does take 1.5 secs to execute... if mysql will be faster please tell me, if not, then I'll just use PHP. My code for checking (if $skip=0 then it skips the recordset) foreach ($users as $user) { if ($db->recordSet[10]==$user) { $skip=1; break; } else { $skip=0; } } if ($u==100) { break; } And then later on: if (!$skip) { $users[$u] = $db->recordSet[10]; $u++; Also, here is the page to see what output I want (if you still don't get it): http://www.runeap.com/gthd/?m=4&cr=1&l=1

Help! select g.* from gthd g, (select g2.car, g2.username, min(g2.wrank) as wrank from gthd g2 group by g2.username ) as gg where g.username = gg.username and g.wrank = gg.wrank AND gg.car=43 LIMIT 100 Goes on forever... Ok, now it finished, but with the wrong results...

Sort of. I get columns, and the right username, but I need the row that corresponds with that wrank. This way, I get two 'wrank': car week id username time country transmission wrank rank ASM TCS tire_front tire_back updated reg wrank 43 104924 192973 ommy 9415 j MT 705 21 OFF 0 N1 N1 17:52 01/01 j 1 43 104924 192953 D-1 11629 j MT 189 1 OFF 0 N1 N1 01:02 30/12 j 2 43 104924 193009 S_factry 7589 j MT 1815 57 OFF 0 S1 S1 03:02 04/01 j 10 43 104925 198954 Redsupra 10223 j MT 441 6 OFF 0 N2 N1 02:10 11/01 j 19 Notice how wrank is right...and username, but there's two wrank's, and the first wrank corresonds the the column... so it's sort of a mixed result... EDIT; I have to add stuff to make it work: SELECT *,min(wrank)as wrank FROM gthd WHERE car=43 AND reg != 'w' GROUP BY username ORDER BY wrank ASC LIMIT 100; car=43 is the most important, reg!='w' is just my mistake, and LIMIT 100 is so that I get 100 results. The first 4 are above. Thanks for your help! EDIT: found this: somehow need to modify it to fit me? http://www.thescripts.com/forum/thread76634.html

Simply a time. See GT:HD on the internet if you're really interested. My website which is now running fine is at http://runeap.com/gthd/ and it should show you what I mean. Enter "solinent' or just click "leaderboards".

Uh, I can't modify my orig post anymore, so sorry Anyways, here's some progress I made, I'm able to get the rank numbers of the unique and wanted posters. How can I cross reference this with a simple select statement? SELECT MIN(wrank) AS worldrank FROM gthd WHERE car=43 AND reg != 'w' GROUP BY username ORDER BY worldrank ASC LIMIT 100; (it makes it much easier when you type out messages like this, I find! I just need to organise my thoughts. I think theres an easy way to do this...)

A couple days late, searching for my own problem, but if someone comes by this ever: Simply do this: SELECT * FROM U_G_T WHERE gender='male' ORDER BY timestamp DESC UNION SELECT * FROM U_G_T WHERE gender='female' ORDER BY timestamp DESC Or something simillar!

I've got a table that looks like this: +-----+--------+--------+----------+-------+---------+--------------+-------+------+-----+-----+------------+-----------+---------------------+ | car | week | id | username | time | country | transmission | wrank | rank | ASM | TCS | tire_front | tire_back | updated | +-----+--------+--------+----------+-------+---------+--------------+-------+------+-----+-----+------------+-----------+---------------------+ | 43 | 104945 | 163164 | ommy | 13704 | Japan | MT | 1 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104935 | 143194 | D-1 | 13599 | Japan | MT | 2 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104945 | 163165 | D-1 | 13589 | Japan | MT | 3 | 2 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104935 | 143195 | ommy | 13561 | Japan | MT | 4 | 2 | OFF | 0 | N2 | N2 | 0000-00-00 00:00:00 | | 43 | 104942 | 157164 | ommy | 13536 | Japan | MT | 5 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104933 | 139212 | D-1 | 13521 | Japan | MT | 6 | 1 | OFF | 0 | N2 | N2 | 0000-00-00 00:00:00 | | 43 | 104939 | 151164 | D-1 | 13508 | Japan | MT | 7 | 1 | OFF | 0 | N2 | N2 | 0000-00-00 00:00:00 | | 43 | 104942 | 157165 | D-1 | 13478 | Japan | MT | 8 | 2 | OFF | 0 | N2 | N2 | 0000-00-00 00:00:00 | | 43 | 104943 | 159164 | D-1 | 13477 | Japan | MT | 9 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104943 | 159165 | S_factry | 13440 | Japan | MT | 10 | 2 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104945 | 163166 | S_factry | 13436 | Japan | MT | 11 | 3 | OFF | 0 | N2 | N2 | 0000-00-00 00:00:00 | | 43 | 104938 | 149164 | D-1 | 13427 | Japan | MT | 12 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104936 | 145164 | D-1 | 13426 | Japan | MT | 13 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104940 | 153164 | S_factry | 13370 | Japan | MT | 14 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104942 | 157166 | S_factry | 13358 | Japan | MT | 15 | 3 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104934 | 141211 | D-1 | 13355 | Japan | MT | 16 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104937 | 147164 | S_factry | 13326 | Japan | MT | 17 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104941 | 155164 | D-1 | 13323 | Japan | MT | 18 | 1 | OFF | 0 | N2 | N2 | 0000-00-00 00:00:00 | | 43 | 104944 | 161164 | Redsupra | 13318 | Japan | MT | 19 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104933 | 139213 | Redsupra | 13299 | Japan | MT | 20 | 2 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | +-----+--------+--------+----------+-------+---------+--------------+-------+------+-----+-----+------------+-----------+---------------------+ (mysql output) Basically, I need a function to pull out this result (with mySQL alone, I'm going to be pulling alot more from the db): +-----+--------+--------+----------+-------+---------+--------------+-------+------+-----+-----+------------+-----------+---------------------+ | car | week | id | username | time | country | transmission | wrank | rank | ASM | TCS | tire_front | tire_back | updated | +-----+--------+--------+----------+-------+---------+--------------+-------+------+-----+-----+------------+-----------+---------------------+ | 43 | 104945 | 163164 | ommy | 13704 | Japan | MT | 1 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104935 | 143194 | D-1 | 13599 | Japan | MT | 2 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104943 | 159165 | S_factry | 13440 | Japan | MT | 10 | 2 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | | 43 | 104944 | 161164 | Redsupra | 13318 | Japan | MT | 19 | 1 | OFF | 0 | N1 | N1 | 0000-00-00 00:00:00 | +-----+--------+--------+----------+-------+---------+--------------+-------+------+-----+-----+------------+-----------+---------------------+ This is to eliminate doubles (in username column, and the one listed should be the one with the smallest wrank) when displaying these stats (I don't want to display twice). Now, how do I do this? The first command was brought to you by: SELECT * FROM gthd WHERE car=43 ORDER BY wrank LIMIT 20 And the second command should go something like this? SELECT (list of columns...) MIN(wrank) FROM gthd WHERE car=43 GROUP BY username ORDER BY wrank LIMIT 20 But that doesn't work, it produces a totally unrelated list of columns. Please help (just incase it makes anything clearer, wrank stands for "world rank"

I think I have an idea, but it doesn't work perfectly. Well all I do is loop through every single category and assign a static rank. When I update all the records once a week, I'll simply re-run the ranking script. This way it improved a 30 sec load time to a .5 sec

I store it in the database. It probably depends on how long the main body of the news is going to be. If it's normally quite big, then use files. If it's average (I dunno, maybe under 8k characters?) then keep it in the database. Obviously, it's easier to use and maintain it if it is in a database. I see no disadvantage to it, either, but I'm not extremely experienced, so don't go by my opinion alone!

I can't though, if I hardcode a LIMIT, then people who are beyond that limit will be gone Any other ideas? EDIT: username is not a unique field. I do have a unique ID field if there's anything I can do with that?