forum.coppermine-gallery.net
No Support => Modifications/Add-Ons/Hacks => Mods: Uploading => Topic started by: mumtaz on January 12, 2006, 11:14:12 pm
-
How can I create an album in a registered user's gallery, and how can I upload pictures there?
Is there any way, that as an admin I edit the php, so any user's personal gallery I can create albums and upload files there, like as it would be my gallery.
-
that would defeat the point of a personal gallery,don't you think?
-
that would defeat the point of a personal gallery,don't you think?
Ok, ok. This is a private gallery site, where a small group of people show each other pictures, but the problem is, some of them don't know how to create album's on personal galery and how to upload them.
-
Ok if you wish to upload to user's personal gallery here is a small mod for it. This will allow you to create an album for user as well.
Edit albmgr.php
ADD
$query = "SELECT user_id, user_name FROM {$CONFIG['TABLE_USERS']} WHERE user_id > 1";
$result1 = cpg_db_query($query);
$rowset1 = cpg_db_fetch_rowset($result1);
foreach ($rowset1 as $row1) {
$CAT_LIST[] = array(FIRST_USER_CAT + $row1['user_id'], '*'.$row1['user_name'].'*');
}
just after (somewhere around line 365)
$CAT_LIST[] = array(0, $lang_albmgr_php['no_category']);
alb_get_subcat_data(0, '');
then edit upload.php
Replace(Around line 850)
if (USER_ID) {
$user_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='" . (FIRST_USER_CAT + USER_ID) . "' ORDER BY title");
with
if (USER_ID) {
if (GALLERY_ADMIN_MODE) {
$user_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category>'" . FIRST_USER_CAT . "' ORDER BY title");
} else {
$user_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='" . (FIRST_USER_CAT + USER_ID) . "' ORDER BY title");
}
HTH
Abbas
-
Ok if you wish to upload to user's personal gallery here is a small mod for it. This will allow you to create an album for user as well.
Edit albmgr.php
ADD
$query = "SELECT user_id, user_name FROM {$CONFIG['TABLE_USERS']} WHERE user_id > 1";
$result1 = cpg_db_query($query);
$rowset1 = cpg_db_fetch_rowset($result1);
foreach ($rowset1 as $row1) {
$CAT_LIST[] = array(FIRST_USER_CAT + $row1['user_id'], '*'.$row1['user_name'].'*');
}
just after (somewhere around line 365)
$CAT_LIST[] = array(0, $lang_albmgr_php['no_category']);
alb_get_subcat_data(0, '');
then edit upload.php
Replace(Around line 850)
if (USER_ID) {
$user_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='" . (FIRST_USER_CAT + USER_ID) . "' ORDER BY title");
with
if (USER_ID) {
if (GALLERY_ADMIN_MODE) {
$user_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category>'" . FIRST_USER_CAT . "' ORDER BY title");
} else {
$user_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category='" . (FIRST_USER_CAT + USER_ID) . "' ORDER BY title");
}
HTH
Abbas
Ohhh. Very thx. (https://forum.coppermine-gallery.net/proxy.php?request=http%3A%2F%2Fforum.hwsw.hu%2Fhtml%2Femoticons%2Fico_respect.gif&hash=01250004b4f9ebced3871e95ff098a7bca4f60fa)
-
You are welcome mumtaz (is someone making Taj Mahal for you... just kidding).
For those admins who just want to create albums for their users but don't want to upload photos then only edit albmgr.php and similarly if you only want to upload to user's personal gallery then only edit upload.php in the above mod.
-
works this with bridged cpg to smf
-
Are you asking a question whether this works with bridged cpg or not? Or are you telling us that this works with cpg?
-
Hi,
I did the required changes to those files, and it does work. But...
I'm using bridge to phpbb so I'm using phpbb's user table. Now I can only create albums to users from coppermine's user table. This is of course very logical..
Is there anyway to make a query that would check the user table from phpbb? :-[ ???
Or should I someway (using phpmyadmin) copy phpbb user tabe into copperminen user table (thou then user id number's should also be identical...)
help, please? :)
-
Change
$query = "SELECT user_id, user_name FROM {$CONFIG['TABLE_USERS']} WHERE user_id > 1";
to
$query = "SELECT {$cpg_udb->field['user_id']} AS user_id, {$cpg_udb->field['username']} AS user_name FROM {$cpg_udb->usertable} WHERE {$cpg_udb->field['user_id']} > 1";
-
"There was an error while processing a database query.
While executing query "SELECT user_id AS user_id, username AS user_name FROM `kyyhky_phpb1`.phpbb_users WHERE user_id > 1" on 0
mySQL error:
File: /home/kyyhky/public_html/galleria/include/functions.inc.php - Line: 249"
???
-
Also
$result1 = cpg_db_query($query);
to
$result1 = cpg_db_query($query, $cpg_udb->link_id);
-
Thaks Nibbler, album creation works now!
But I still can't select a user gallery from batch add or move files that are allready on the server to a user gallery?
I hate to be a pain in the ass but I'd really appreciate some help... :)
-
Are you asking a question whether this works with bridged cpg or not? Or are you telling us that this works with cpg?
yes, this is a question.
-
and the answer is given by Nibbler above...
-
Greetings,
I'd really like to use the "batch-add" functionality to add photos to my users' albums. For instance, if a user ships me a CD full of images, half of which should go into one album, and the other half of which should go into another album, the "batch-add" screen would be a great place to do that from.
My situation is that I'm selectively importing thousands of photos from hundreds of directories created by another gallery software (an ancient version of albinator). When I was implimenting Coppermine, I didn't have the time to run the ablinator -> coppermine converter script. I think that using the "batch-add" utility to convert these old albums to coppermine format will provide me the best results.
If you have alternate suggestions, I'd love to hear them.
-
This thread is basically for uploading to user's album using http upload method. Please start a new thread for batch add.
-
This thread is basically for uploading to user's album using http upload method. Please start a new thread for batch add.
JosephL did not decide to start a new thread, I believe. However it seems, that I managed to hack coppermine, so that admin can batch-upload users' files:
In a file ./bridge/udb_base.inc.php a change is required in a function get_batch_add_album_list, which seems to be used for batch upload only.
Instead of:
function get_admin_album_list()
{
global $CONFIG;
if ($this->can_join_tables) {
$sql = "SELECT aid, CONCAT('(', {$this->field['username']}, ') ', a.title) AS title
FROM {$CONFIG['TABLE_ALBUMS']} AS a
INNER JOIN {$this->usertable} AS u
ON category = (" . FIRST_USER_CAT . " + {$this->field['user_id']})
ORDER BY title";
} else {
$sql = "SELECT aid, IF(category > " . FIRST_USER_CAT . ", CONCAT('* ', title), CONCAT(' ', title)) AS title " . "FROM {$CONFIG['TABL
E_ALBUMS']} " . "ORDER BY title";
}
return $sql;
}
at about line 618, it now says:
function get_batch_add_album_list()
{
global $CONFIG;
if ($this->can_join_tables) {
$sql = "SELECT aid, CONCAT('(', u.user_name, ') ', a.title) AS title
FROM {$CONFIG['TABLE_ALBUMS']} AS a
INNER JOIN {$this->usertable} AS u
ON category = (" . FIRST_USER_CAT . " + u.user_id)";
} else {
$sql = "SELECT aid, IF(category > " . FIRST_USER_CAT . ", CONCAT('* ', title), CONCAT(' ', title)) AS title " . "FROM {$CONFIG['TABL
E_ALBUMS']} WHERE category = ".(FIRST_USER_CAT+USER_ID)." ORDER BY title";
}
return $sql;
}
Please note the change of a users' name displayed in parantheses (u.user_name) and a condition binding tables, which now allows inclusion of all users' albums. I did not change the else clause though, as haven't read the code deeply enought to find out, when is it actually used.
Have a good day,
(js).
-
Jans -
I tried this and that didn't work... any ideas...
-
this works great, thank you very much.
I was wondering though, would it be possible to edit so that i can move pictures to user's gallery with the "change file information"-function?
I guessing that it wouldnt be that much to change right? Any ideas? :)
-
Are you talking about mod by jans or me?
-
hmm, who is janz?
Im talking about the mod on the first page in this thread.
There is astandard feature in coppermine where you can move pics from one album to another. And i was thinking that the code couldnt be much different if i wanted to change that so i could move files to users personal galleries?
-
For moving file to user albums you will need to edit editpics.php and editoOnePic.php I think it is doable.
-
I want to be able to do the exact opposite... I want users to be able to upload to admin albums. The idea is that I choose the album names (disable album creation for users) and have users only be able to upload to my albums. I tried changing upload.php to:
if (USER_ID) {
$public_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category < " . FIRST_USER_CAT . " ORDER BY title");
} else {
$public_albums = cpg_db_query("SELECT aid, title FROM {$CONFIG['TABLE_ALBUMS']} WHERE category < " . FIRST_USER_CAT . " AND uploads='YES' AND (visibility = '0' OR visibility IN ".USER_GROUP_SET.") ORDER BY title");
}
if (mysql_num_rows($public_albums)) {
$public_albums_list = cpg_db_fetch_rowset($public_albums);
} else {
$public_albums_list = array();
}But it didn't work... almost though... but then I get an error saying "Selected pod does not exist or you don't have permission to upload in this pod " any help would be greatly appreciated... I know this is an old thread.
-
Forget it... I got it. ;D
-
Does this mod work with Coppermine 1.4.14?
I've tried making the changes listed, and I can view all the users in my database, but the users gallery is not created....
Can anyone help please?
Regards
Eddy
-
Anyone???
I'm transfering from phpBB and FAP, so I need to be able to recreate all the user galleries and move the photos across - ANY help would be appreciated!
Regards
Eddy
-
Is anyone alive here? :-\
Eddy
-
Does this mod work with Coppermine 1.4.14?
It should.
I've tried making the changes listed, and I can view all the users in my database, but the users gallery is not created....
Well, maybe you made an implementation mistake, maybe the mod doesn't work for cpg1.4.14 (which I doubt). Anyway, as you have failed to post a link to your gallery and a non-admin test user account, there's little we could do to help you. If you want help, you'll have to supply the needed information to enable supporters to look into your issues.
I'm transfering from phpBB and FAP, so I need to be able to recreate all the user galleries and move the photos across - ANY help would be appreciated!
I have no idea what "FAP" is, so what should I have replied? There is no point in posting "what the * are you talking about", so I haven't. Seems like all other supporters had the same thoughts, that's why nobody replied.
Is anyone alive here? :-\
Yes. As suggested above: supply details if you want help. Just posting that something doesn't work as expected without providing details will not help at all. You might want to zip your changed files and attach them to your posting.
-
My apologies Joachim, I've obviously got off to a bad start, so I'm sorry....
Attached are the two files I've modified - The changes allow me to view a listing of usernames when I attempt to create a user gallery, but when I select on no gallery is created. The changes to upload.php don;t seem to have any effect at all, and it works exactly as it did in the standard coppermine, but that's probably because I'm unable to create a user gallery to upload to?
Regards
Eddy
-
Anyway, as you have failed to post a link to your gallery and a non-admin test user account, there's little we could do to help you. If you want help, you'll have to supply the needed information to enable supporters to look into your issues.
Where's the link and test user account?
-
Ok. I still have problems since installing the mod (http://forum.coppermine-gallery.net/index.php/topic,26386.0.html).
The mod works well and enables me to upload to private users galleries if they either cannot or will not.
The problem I have now is as follows:
If I upload to a users album, the picture appears in that album. If later on either the album owner or admin edit any text in the properties of the picture (for instance the title name or description) when you go to apply changes the image is moved to a main gallery album. On closer inspection it seems that the private album isn't listed in the albums available for that picture any more, only the main gallery albums are available.
Now that means the picture is stuck in one of the main gallery albums and the only option I have is to move it around the main gallery or delete the image and upload it again.
Regards,
Steff
-
this works great, thank you very much.
I was wondering though, would it be possible to edit so that i can move pictures to user's gallery with the "change file information"-function?
I guessing that it wouldnt be that much to change right? Any ideas? :)
For moving file to user albums you will need to edit editpics.php and editoOnePic.php I think it is doable.
I too, want to be able to move existing pictures in an existing album to a user's album, and change the picture owner to the user so that the user can modify their own files. Please help! It's tedious having to do this through phpmyadmin all the time :'(