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.