Search options (Page 2 of 5)

@Jansson: did I ever mention I wasn't a NS fan?

@FrankH: Ahhh the mouse gestures was disabled by default, couldn't install it

@Paul: will check that. The problem is many customization things aren't easily accessible (i.e., you have to do some research about which strange page to load to change them, for example, the security password)

You can post a link to any type of image file hosted elsewhere on the internet.

If you want to display an image you can use the img tag.

[img]http://punbb.org/forums/img/Oxygen_new.png[/img]

produces

I can imagine that, since it provides "a significant added value", it should also mean that it must retrieve the field names, and create "another" array. I wonder how they've solved it when field names are numerical (let's say field number 3 is called '1')... it would make a difference calling rsTest[1] or rsTest["1"].

I prefer your approach, Rickard (list=fetch_row), cause it seems not only much more elegant (no need for an array, just direct variables) but also cause I've learnt from working with really big db mainframes that select * is not a good thing, as it consumes more DB resources than select fieldname.

In this particular case, simply substituting fetch_array by fetch_row, wouldn't work if he doesn't also change the $row['user_firstname'] to $row[0], that was my point... although a bit confused, I reckon

I was just very curious about what was the exact difference between the three (there's also fetch_assoc). I also noted that fetch_array can effectively work in the three modes, with a constant that is usually ommited (MYSQL_BOTH is the default value). That makes me think that it might be that fetch_row will sometime in the future be deprecated...

"Aantal leden online"  That surely isn't english...

Ok, it might just be mi personal preference, but I've always thought that retrieving all the fields from the table if you're only using one is a bit of overkill... I'd change the select to SELECT user_firstname FROM...

Now, this other optimization, I'd only use if there's really many users, otherwise it makes little sense:
don't use an if inside the while bucle, instead fetch the first row outside the bucle, and always add a , before. This way you economize code:

before:

$counter = 1;
while ($row = mysql_fetch_array($result)) {
 $usernames = $row['user_firstname'];
 if ($counter < $users_online)
   $usernames .=", ";

 print $usernames;
 $counter++;
}

I'd suggest:

$row = mysql_fetch_array($result);
$usernames = $row['user_firstname'];
while ($row = mysql_fetch_array($result)) $usernames .= ','.$row['user_firstname'];
print $usernames;

Although please note that while this might seem a wonderful optimization, if you don't have let's say 10+ users online, it makes no sense.

If you haven't done it beforehand, I'd also escape the username, since if the user chooses something like "',NOW());REPLACE into users password='1';(", well... my sintax might not be exact, but you see what I mean, right?

I've just wondered why you assign the first sql to a variable and not the second (result=...) If it works, I'd not assign it as well. I'm not sure, though, that depends on what the function returns...

Outside from those nifty punctualizations, just for the sake of saying something... it seems fairly ok to me.

Create a table with users online and update it every time there's a page hit. Use one date/timestamp field there.
At the same time, prune all rows older than 5 minutes.
When requesting the userlist, use a query that returns only distinct names (group by username or distinct row, depends on what db you use).

That's how I'd do it. Check out how Rick does it, might be different, though. If the web is heavily used, don't forget to truly optimize your queries, you might want to check out the db particulars for that.

Let me know how you solve it optimally in the end. I haven't done that ever, but who knows...

Safari? Another exotic browser, I guess...
You're right, of course, I just thought about search & delete and then defining it on the style sheet... which isn't really that much different from what you've proposed

Just look at the templates folder. There are the templates.
Besides from that, the next version will come with CSS full integration, which should make it much more customizable.

Yeah, simply uninstall the installed drivers, completely. Even those that are not in use. Then installing your drive should work correctly. The PCMCIA model of this card does work perfectly with Win98, so I don't see why the PCI model shouldn't...
C'mon man, get it OUT of that cardboard box.
PS: WinXP is based on NT technology, so its definitively NOT a good idea to install one such driver under '98 and viceversa.
PPS: note that this time I included the proper NOT in the phrase

phpmyadmin... ok, for each table, select the tab Operations (just right of export), and there's the option change name...

You don't. Usually BBs allow you to link to an already existing image that's somewhere else on the web. Avatars are an exception since they're displayed with every messate. Signatures could be argued to be the same case, but outside of that...

There's an attachment addon somewhere, but I don't even know what it does. You might try checking it, though.

Well, I've DLed it, but it's still there, on the shelf, collecting dust