bcoffin

Hi All.. have a backend where users may login and make changes and such. I'm wondering if there's a good way to only allow one login with that account. read: somehow perform a check to see if someone is currently logged in? I'm concerned that if my users don't "logout" then it will be stuck forever logged in, otherwise I could just record an "in" on login and "out" on logout. Isn't there a better way to do this? Furthermore, is there a way to see how many [unique] users are logged in at any one time? I've seen it on phpbb that shows who's currently online...

You = genius; Me = idiot; I thank you for pointing out the error of my ways.

Bummer.. I'm still getting the same error: Unknown column 't3.a' in 'field list'... What a tricky query~~!

I've never used an "inner join" before. I will give that a try right now, Shoz. Hopefully others who are experiencing this same problem will be enlightened (too) by your advice.

I've used MySQL 4 for years but don't understand how to translate this query for MySQL 5. I've done a cursory search through this forum, but don't see any queries that look similar: [code] SELECT t1.*, t2.*, CONCAT(t3.a,'|',t3.b,'|',t3.c) AS abc FROM t1,t2 LEFT JOIN t4 ON t1.id = t4.t1_id LEFT JOIN t3 ON t1.id = t3.t1_id AND t3.[some field] = [some value] WHERE t2.t1_id = t1.id AND t2.t1_id = [some id] GROUP BY t1.id ORDER BY t1.field1, t1.field2, t1.field3 [/code] I'm getting ERROR 1054: (42S22): Unknown column 't3.a' in 'field list' Can someone please help? benny

Looks like just the gem I'm looking for! Thanks again obsidian.

very cool.. that's just one .htaccess doc, then, rather than a ton of other bs. Thanks for the suggestion -- I'll google around for docs on that, do you have any handy? Benny

I'm building an intranet for my company and want to be able to give my coworkers (there are about 150) the ability to create their own news/photos pages. I took a look at MySpace and certainly don't want anything that complicated but was wondering how they do the dynamic URLs part.. ie: if my site lives at: http://intranet/ how do I configure my web server (or better yet, just the PHP code), so that if an employee does create his own page, then I can use: http://intranet/alan http://intranet/betty http://intranet/charlie and have that URL actually resolve instead of say "Page Not Found" I'd rather not create all these web directories one by one, or even have the php create them and copy the necessary scripts into the folders. Is there a way to use apache look-back, or php $_SERVER global to just place the script in the webroot and grab these values? Thanks all, benny

Does anybody know a good script to recursively process/assign smarty variables? This is what I'd like to do... foreach($vals as $k=>$v) {   if(is_array($v))   {     foreach($v as $ak=>$av)     {         $this->smarty->assign(array($k[$ak] => strtoupper($av)));     }   }   else   {       $this->smarty->assign(array($k => strtoupper($v)));   } } ..however, I would like it to process all levels of an array, no matter how deep... ideas?

Awesome.. dUnzip worked like a charm. Thanks so much! benny

What command will uncompress zip files?

Can anybody offer any advice on how to create JPG stills from a user-uploaded QT Mov or MPEG file? I've built a simple upload tool but would like to present my users with a series of stills from the files they've uploaded at various second intervals, or specify a timecode from which to select an auto-generated JPG still. I've looked into FFMPEG but it's a bit confusing and requires a rebuild of the web server. Is there any stand alone class that I can use? Any advice, please? Thanks Benny

Does anybody know what the external_link_list_url option does in TinyMCE? The description makes it sound like it gives you the option of a dropdown list of links, rather than a freetext field... If so, this is exactly what I'm interested in, but I can't find any documentation showing how to configure this feature.. Can somebody show me how? What steps?

I found this [a href=\"http://www.phpfreaks.com/forums/index.php?showtopic=89136&hl=\" target=\"_blank\"]thread[/a], but the regex_build_url function isn't recognized. (And it doesn't address the email part).

Could somebody please recommend a good way to input a textarea's contents and return the same contents, whereas all patterns matching a URL or EMAIL address are auto-linked? ie: Aliquam posuere iaculis [!--coloro:#CC6600--][span style=\"color:#CC6600\"][!--/coloro--]www.augue.com[!--colorc--][/span][!--/colorc--]. Mauris dictum pellentesque ipsum. Nam lacus. Sed mattis commodo lectus. Duis malesuada, lorem et gravida mattis, magna purus viverra orci, id tempus ante lorem et arcu. Nullam congue orci at metus. Ut tortor pede, placerat a, tristique eget, tempor id, augue. Mauris tincidunt risus sit amet diam. Mauris vehicula lectus eu dui. Aenean porttitor gravida purus. Vivamus nisl ipsum, aliquam sed, tincidunt vitae, dictum quis, purus. [!--coloro:#CC6600--][span style=\"color:#CC6600\"][!--/coloro--]Nam@bibendum.com [!--colorc--][/span][!--/colorc--]diam. becomes Aliquam posuere iaculis [!--coloro:#CC6600--][span style=\"color:#CC6600\"][!--/coloro--]<a href='www.augue.com' target='_new'>www.augue.com</a>[!--colorc--][/span][!--/colorc--]. Mauris dictum pellentesque ipsum. Nam lacus. Sed mattis commodo lectus. Duis malesuada, lorem et gravida mattis, magna purus viverra orci, id tempus ante lorem et arcu. Nullam congue orci at metus. Ut tortor pede, placerat a, tristique eget, tempor id, augue. Mauris tincidunt risus sit amet diam. Mauris vehicula lectus eu dui. Aenean porttitor gravida purus. Vivamus nisl ipsum, aliquam sed, tincidunt vitae, dictum quis, purus. [!--coloro:#CC6600--][span style=\"color:#CC6600\"][!--/coloro--]<a href='mailto:Nam@bibendum.com'>Nam@bibendum.com</a>[!--colorc--][/span][!--/colorc--] diam. THANKS for your help, you guys, Benny

[!--quoteo(post=356268:date=Mar 18 2006, 05:47 PM:name=maexus)--][div class=\'quotetop\']QUOTE(maexus @ Mar 18 2006, 05:47 PM) [snapback]356268[/snapback][/div][div class=\'quotemain\'][!--quotec--] You can't take away the open option, that is browser level stuff >_> Controlled by the user through the browser. [/quote] hmm.. okay. I figured that was the case. THank you for the help. benny

For some reason, I cannot post this inquiry with the header code -- does the forum not like that code?

Hi All.. I'm using the following script to give the option to either "SAVE" or "OPEN" a file, via headers() function. I'd like disable the "OPEN" option -- does anybody know if this is possible? So that the script only offers the option of saving the document... Thanks for all your help over the years! Benny

I noticed on safari, file fields are shown with forward slashes, whereas on a PC, file fields show backslashes. IE: on my pc, i browse to a file: path\to\my\file.jpg on my mac, i browse to the same file: path/to/my/file.jpg I'd like to alert the "file.jpg" to the user, but have to either split at the forward slash or the backslash.. can you suggest how to do both? thanks, benny

here's the one I ended up using. pretty dang brilliant, if you ask me: [a href=\"http://webfx.eae.net/dhtml/slider/slider.html\" target=\"_blank\"]http://webfx.eae.net/dhtml/slider/slider.html[/a] -benny

Hi Everybody, I googled it, but couldn't find any solutions. I'd like to create an iframe image gallery with a dhtml (customizable) sliderbar below it that slides the iframe left to right when you slide the sliderbar left to right. Eventually, the amount of images (and thus width) of the iframe source will be dynamic, so if you could please provide me with a sample of at least the dhtml/sliderbar code, I could probably start from there and figure out the add/remove images later...? Please help, Thanks -- benny.

WORKED LIKE A CHARM!! Again, you guys are irreplaceable! Thanks again, Benny

cool! will do. thanks again, all... benny

So ultimately, my query will look like this, right: "SELECT * FROM listings WHERE (director='director name') AND (terms like '%term1%' OR terms like '%term2%') AND (genre = 'genre1' OR genre='genre2' OR genre='genre3') ORDER BY title ASC"; Hopefully I've finally gotten this right? Benny

AWESOME YOU GUYS!! Your advice is priceless.. thank you! I promise I will take each and every one of your suggestions!!! Benny ps. I have no idea how to mark this SOLVED ... I can't find the solved button anywhere.