Help Me Humpa

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Hey Humpa,

you don't seem to have many questions being asked at the moment Razz

I don't know if you remember my individual setup, but I have it so that someone can register on my site and they are then emailed a unique id. They then add that to the end of their MMS profile URL - http://www.mysite.com/mms/send.php?userid=12345678 and I then have a script that pulls that userid from the database and replaces it with their username under their MMS's - "Posted by: Humpa".

I'm wondering, is there any easy way of being able to pull up all the pics posted by an individual user? I'm trying to think of something like this:

For each MMS posted, there is a date&timestamp.txt file created with "Posted by: Username" - and with that file is the corresponding media. So somehow, if I wanted to show all pics from "Humpa", I'd need to examine all the .txt files on the server, find the ones that had "Humpa" in them and then have a page that showed all the media that related to those .txt files. (Of course, the .txt files have the same date&timestamp as the actual media files).

Firstly, does that make sense?
Secondly, is it easier to achieve than I'm thinking?
Thirdly, probably easier to tell me to sod off as you've already helped me more than enough Smile

Cheers!

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Hi Humpa,

not sure if you ever read the above post or not, but it's been something I've put on the back burner and every now and again, come back to. I'm looking at it again and trying to see if there's a way of achieving this easily. Apart from the thoughts I've had above, I'm wondering if I could somehow do this:

When a user sends media to the site, I add the filename and user to a separate table in my database...Then I somehow have the username as a hyperlink under their posted media (example: Posted by: Humpa) and that then takes them to another page that interrogates the database for all media posted by Humpa...Firstly, does that make sense? Secondly, could it work? Thirdly, I can add the data easily enough to the database, but not sure of the code I would need to then extract it again...I'm not too worried about having a "Humpa style" page when showing an individual users media, just a simple enough gallery showing all the pics (and possibly comments) etc...I'm sure you know what I mean Wink

Cheers - and I welcome any thoughts/ideas Cool

Humpa · Site Admin Joined: 06 Nov 2005 Posts: 10258

It really isn't designed for that.

Probably the easiest way is to log an entry in a new database table for every mms the user sends.
Just log his username and the $pic_time.
You could put the sql insert line right before the writeBackSendConf($dec); line to ensure you didn't log anything that wasn't actually an mms message that was sent.

But the problem would then be writing a page to pull those 14 digit pic_time's out of the database and turning them into a page(s) of that users pic/videos/whatever.

You'd have to copy the index.php, but totally rewrite it. It doesn't look very easy. Sad

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Hi,

thanks for the reply. I guess I'm just being dumb here, but would it not be possible to pull all the posted media by a user out of a database by using the userid? Let's say that my userid=001. So if a user was to click on my name, I'd have some kind of sql statement that would pull out all media where userid=001 ? By storing the actual filename of the media posted then it would pull out all the .jpg / .mp4 whatever. I wouldn't necessarily need to be able to hyperlink userid's, I could have a separate page that listed all my users and make those links...Or are you saying the problem would be how to display the media once pulled from the database?

I suppose another way, would be when a user joins my site, I could create a separate folder with their username and have the media copied to that folder...And then that page would simply be a 'display' page - they wouldn't be able to edit/delete or anything. Would that be easier you think? I can't remember from reading previous posts, but it's not that easy to copy media to two folders when media is sent to the site is it? If it is, then I could copy installs of Humpa-MMS (with the minimal amount of files needed) to users folders and they would then be in /mms/userid

Cheers Humpa - sorry for picking your brains over this, but it's a bit of a Star Wars scenario...Help me, Obi-Wan Kenobi; you're my only hope Laughing

Humpa · Site Admin Joined: 06 Nov 2005 Posts: 10258

The easiest thing would be to give them all separate folders. But then you wouldn't be able to show all pics together, only separted pages for each user.

Your best solution might be this:
You could put an sql insert line right before each $file = fopen($filename, 'wb'); line.
Just insert their userid in one column, the $filename in another, and the $pictime in another.

Then the problem would be simply writing some sort of page to display all that.

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Ok, I reckon that's the way to go. Let me know when you've finished coding it up?

Heh heh, only joking Smile

I think what I might do for now, is just have a page that shows only the images and worry about other media/comments some other time...I think that might be the easiest thing to do for now.

Cheers Humpa!

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Goooooooooood evening Very Happy

Well I've been toying around with this a fair bit today and I think I'm real close to an answer. Couple of things I wouldn't mind a bit of help with though please...

Firstly a quick question about phpthumb. When you use this, do you have to specify width and height? If I have an original image of say 640x480, if I was to set the width & height to 80x80 then the thumbnail will obviously look squint. Is there a way for phpthumb to dynamically alter the size of the original without losing the perspective?

Secondly, here's a line of my code:

Humpa · Site Admin Joined: 06 Nov 2005 Posts: 10258

I forget how exactly phpthumb needs it's attributes, but I think you can just use a height or a width, and it will resize it proportionally. And if the pic is already smaller then the size you tell it, it won't resize at all.
But all that is explained in the file itself. Look in the phpThumb or the phpThumb config file. Those files have not been modified by me at all.

For displaying horizontally, you need to use multiple table cells before ending the row .. you know?
I imagine you know that, but the trick comes in setting up a counter in your script so it ends the table row every 5 pics and then starts a new row. I imagine you can use the code I have in the index.php already for that.

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Hi,

sorry about editing my post as you were replying...I shouldn't have done that. Surprised

Thanks though - I'm glad you said about index.php because it means I am on the right track to working this out...

Will let you know how I get on!

Humpa · Site Admin Joined: 06 Nov 2005 Posts: 10258

something like this:

Humpa · Site Admin Joined: 06 Nov 2005 Posts: 10258

of course then you have the problem that it will show a zillion pics, if that user has a zillion pics Wink

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Thanks very much for the code...Although it seems to be looping? Here's the code (just omitting the database connection stuff):

Phree · Joined: 31 Dec 2005 Posts: 254 Location: South Coast, UK

Sorted!

I changed: