Mod Pack: Watermark, better thumbs, avatar, buddy, PM, notification

[celeritycat]

you've added the sql as is... but you should have modified the prefix to the one you use. Means you should have changed all occurances of cpg142_ in the sql above to cpg_

A BIG THANKS
and by the way, love the new version!

[sigepjedi]

Is there a way to have the watermark feature run over all the older images that were there prior to applying the MOD?

Its working great for all new images.

[celeritycat]

Oops sorry I thought I was in the clear. Using theme classic I recieve this error when clicking on my friends(buddies) Every other link works great and thanks for the help.

While executing query "SELECT id, buddy_ok, buddy_block, buddy_id, since, u.avatar_url, u.user_name as buddy_name, o.user_ip FROM cpg_buddy as b LEFT JOIN  cpg_users as u on b.buddy_id=u.user_id LEFT JOIN  as o on u.user_id=o.user_id WHERE buddy_ok='YES' AND b.user_id = 1 ORDER BY buddy_name ASC LIMIT 0, 25;" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as o on u.user_id=o.user_id WHERE buddy_ok='YES' AND b.user_id = 1 ORDER BY budd' at line 1

USER:
------------------
Array
(
    [ID] => 8a5ca64617481b882ff7ca739aaca6fb
    [am] => 1
    [liv] => Array
        (
           

• => 5
              [1] => 4
              [2] => 2
              [3] => 36
              [4] => 25
          )
  
      [uid] => 1
      [sort] => ta
      [theme] => classic
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => celeritycat
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg_filetypes; (0.004s)
      [1] => select * from cpg_plugins order by priority asc; (0.002s)
      [2] => delete from `thevp_coppermine1`.cpg_sessions where time<1133384873 and remember=0; (0.001s)
      [3] => delete from `thevp_coppermine1`.cpg_sessions where time<1132178873; (0.001s)
      [4] => select user_id from `thevp_coppermine1`.cpg_sessions where session_id=md5("aeeeb6b2c9ffe935e598621def202391156e99a6a1cbf1e23d44c12712d17ef2"); (0s)
      [5] => select user_id as id, user_password as password from `thevp_coppermine1`.cpg_users where user_id=1 (0.001s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `thevp_coppermine1`.cpg_users AS u INNER JOIN `thevp_coppermine1`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.001s)
      [7] => SELECT user_group_list FROM `thevp_coppermine1`.cpg_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
      [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (1) (0.001s)
      [9] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0.001s)
      [10] => update `thevp_coppermine1`.cpg_sessions set time='1133388473' where session_id=md5('aeeeb6b2c9ffe935e598621def202391156e99a6a1cbf1e23d44c12712d17ef2'); (0.001s)
      [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0.001s)
      [12] => DELETE FROM cpg_banned WHERE expiry < '2005-11-30 22:07:53' (0.001s)
      [13] => SELECT * FROM cpg_banned WHERE (ip_addr='67.180.151.178' OR ip_addr='67.180.151.178' OR user_id=1) AND brute_force=0 (0.001s)
      [14] => SELECT count(*) FROM  cpg_buddy WHERE user_id=1 AND buddy_ok = 'YES' (0.002s)
      [15] => SELECT count(*) FROM  cpg_buddy WHERE user_id=1 AND buddy_block = 'YES' (0.001s)
      [16] => SELECT count(*) FROM  cpg_buddy_req WHERE buddy_to=1 (0.001s)
      [17] => SELECT count(*) FROM  cpg_buddy_req WHERE buddy_from=1 (0s)
      [18] => SELECT id, buddy_ok, buddy_block, buddy_id, since, u.avatar_url, u.user_name as buddy_name, o.user_ip FROM cpg_buddy as b LEFT JOIN  cpg_users as u on b.buddy_id=u.user_id LEFT JOIN  as o on u.user_id=o.user_id WHERE buddy_ok='YES' AND b.user_id = 1 ORDER BY buddy_name ASC LIMIT 0, 25; (0s)
      [19] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0.001s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.1 - OK
  ------------------
  mySQL version: 4.1.15-log
  ------------------
  Coppermine version: 1.4.2(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support: 1
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 4.1.11
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/usr/local/include/mysql
  MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/usr/local/php4 | .:/usr/local/php4
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.228 seconds - 20 queries in 0.022 seconds - Album set : ; Meta set: ;

[Stramm]

I can't verify this.. all's working smooth. Check if you use the english.php from the zip and the fallback.inc.php



Yea... Im using those, and the most recent zip file.

can you give me a link?

[Stramm]

Is there a way to have the watermark feature run over all the older images that were there prior to applying the MOD?

Its working great for all new images.

The admin tools will do this for you. If you want to undo the watermark... go there as well. For the undo turn off watermark and let the admin tools recreate fullsized and normal images. Creating mini thumbs and cropped thumbs for older images works the same.

[Stramm]

Oops sorry I thought I was in the clear. Using theme classic I recieve this error when clicking on my friends(buddies) Every other link works great and thanks for the help.

Looks to me like there's not all sql added with the correct prefix. Please recheck

[ganeshcp]

does this mod have any issues?

i used the mod pack for 1.3 and now i have upgraded to 1.4.2....will i have any problems with the tables?
g

[amirw2k]

This looks great !
I'm using a bridged gallery, so I have no use for the PM and user related mods. Is it possible to specify changes made only for the watermark  & thumbs ?

I can easily identify the database changes, but I'm not sure about the changes in the files.

Thanks,
Amir W.

[Stramm]

does this mod have any issues?

i used the mod pack for 1.3 and now i have upgraded to 1.4.2....will i have any problems with the tables?
g

there are some new sql entries... you have to identify them and hut apply these... despite that there shouldn't be a problem

[Stramm]

This looks great !
I'm using a bridged gallery, so I have no use for the PM and user related mods. Is it possible to specify changes made only for the watermark  & thumbs ?

I can easily identify the database changes, but I'm not sure about the changes in the files.

Thanks,
Amir W.

have a look at the watermark mod for 1.3.x... just use the picmgmnt.inc.php from this modpack and do siilar as described in the 1.3 thread

[ganeshcp]

there are some new sql entries... you have to identify them and hut apply these... despite that there shouldn't be a problem

i did that and it seems to work fine.
a suggestion wud be to improve the interface of the pms and buddy interface...it doesn't seem very user friendly

[ganeshcp]

there is a small problem. the star rating pics are all displaying a "no rating" image...
http://www.bollyville.com/thumbnails.php?album=toprated

[am not sure if this is coz of this mod even or something else]

[sigepjedi]

The admin tools will do this for you. If you want to undo the watermark... go there as well. For the undo turn off watermark and let the admin tools recreate fullsized and normal images. Creating mini thumbs and cropped thumbs for older images works the same.

It kind of looks like i have too many damn pictures..... YIKES!
5994 files in 995 albums and 5 categories with 56495 comments viewed 2750535 times

[Stramm]

there is a small problem. the star rating pics are all displaying a "no rating" image...
http://www.bollyville.com/thumbnails.php?album=toprated

[am not sure if this is coz of this mod even or something else]

I can't reproduce that behaviour on my test installs

[Stramm]

It kind of looks like i have too many damn pictures..... YIKES!
5994 files in 995 albums and 5 categories with 56495 comments viewed 2750535 times

hmmm, I have more... 11651 files in 34 albums and 1 categories with 42407 comments viewed 2813697 times

[sigepjedi]

I just limited it to 5 at a time... and it processed, but The normal_ images are still without the watermark.

I am running it as follows:

- Update thumbs and/or resized photos
> Everything... full sized, resized and thumbs

[celeritycat]

Looks to me like there's not all sql added with the correct prefix. Please recheck

Well I don't know much about SQL but I think this looks ok, Maybe I am missing something?

While executing query "SELECT id, buddy_ok, buddy_block, buddy_id, since, u.avatar_url, u.user_name as buddy_name, o.user_ip FROM cpg_buddy as b LEFT JOIN  cpg_users as u on b.buddy_id=u.user_id LEFT JOIN  as o on u.user_id=o.user_id WHERE buddy_ok='YES' AND b.user_id = 1 ORDER BY buddy_name ASC LIMIT 0, 25;" on 0

mySQL error: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'as o on u.user_id=o.user_id WHERE buddy_ok='YES' AND b.user_id = 1 ORDER BY budd' at line 1

And the debug info...

USER:
------------------
Array
(
    [ID] => 8a5ca64617481b882ff7ca739aaca6fb
    [am] => 1
    [liv] => Array
        (
           

• => 4
              [1] => 2
              [2] => 36
              [3] => 25
              [4] => 55
          )
  
      [uid] => 1
      [sort] => ta
      [theme] => classic
  )
  
  ==========================
  USER DATA:
  ------------------
  Array
  (
      [user_id] => 1
      [user_name] => celeritycat
      [groups] => Array
          (
             
• => 1
          )
  
      [disk_max] => 0
      [disk_min] => 0
      [can_rate_pictures] => 1
      [can_send_ecards] => 1
      [ufc_max] => 3
      [ufc_min] => 3
      [custom_user_upload] => 0
      [num_file_upload] => 5
      [num_URI_upload] => 3
      [can_post_comments] => 1
      [can_upload_pictures] => 1
      [can_create_albums] => 1
      [has_admin_access] => 1
      [pub_upl_need_approval] => 0
      [priv_upl_need_approval] => 0
      [group_name] => Administrators
      [upload_form_config] => 3
      [group_quota] => 0
      [can_see_all_albums] => 1
      [group_id] => 1
  )
  
  ==========================
  Queries:
  ------------------
  Array
  (
     
• => SELECT extension, mime, content, player FROM cpg_filetypes; (0.003s)
      [1] => select * from cpg_plugins order by priority asc; (0.001s)
      [2] => delete from `thevp_coppermine1`.cpg_sessions where time<1133460315 and remember=0; (0.003s)
      [3] => delete from `thevp_coppermine1`.cpg_sessions where time<1132254315; (0.001s)
      [4] => select user_id from `thevp_coppermine1`.cpg_sessions where session_id=md5("c9c760c6c7dd2aabd3345231f64f37d1156e99a6a1cbf1e23d44c12712d17ef2"); (0.001s)
      [5] => select user_id as id, user_password as password from `thevp_coppermine1`.cpg_users where user_id=1 (0.002s)
      [6] => SELECT u.user_id AS id, u.user_name AS username, u.user_password AS password, u.user_group+100 AS group_id FROM `thevp_coppermine1`.cpg_users AS u INNER JOIN `thevp_coppermine1`.cpg_usergroups AS g ON u.user_group=g.group_id WHERE u.user_id='1' (0.002s)
      [7] => SELECT user_group_list FROM `thevp_coppermine1`.cpg_users AS u WHERE user_id='1' and user_group_list <> ''; (0.001s)
      [8] => SELECT MAX(group_quota) as disk_max, MIN(group_quota) as disk_min, MAX(can_rate_pictures) as can_rate_pictures, MAX(can_send_ecards) as can_send_ecards, MAX(upload_form_config) as ufc_max, MIN(upload_form_config) as ufc_min, MAX(custom_user_upload) as custom_user_upload, MAX(num_file_upload) as num_file_upload, MAX(num_URI_upload) as num_URI_upload, MAX(can_post_comments) as can_post_comments, MAX(can_upload_pictures) as can_upload_pictures, MAX(can_create_albums) as can_create_albums, MAX(has_admin_access) as has_admin_access, MIN(pub_upl_need_approval) as pub_upl_need_approval, MIN( priv_upl_need_approval) as  priv_upl_need_approval FROM cpg_usergroups WHERE group_id in (1) (0.001s)
      [9] => SELECT group_name FROM  cpg_usergroups WHERE group_id= 1 (0.001s)
      [10] => update `thevp_coppermine1`.cpg_sessions set time='1133463915' where session_id=md5('c9c760c6c7dd2aabd3345231f64f37d1156e99a6a1cbf1e23d44c12712d17ef2'); (0.001s)
      [11] => SELECT user_favpics FROM cpg_favpics WHERE user_id = 1 (0.001s)
      [12] => DELETE FROM cpg_banned WHERE expiry < '2005-12-01 19:05:15' (0.001s)
      [13] => SELECT * FROM cpg_banned WHERE (ip_addr='67.180.151.178' OR ip_addr='67.180.151.178' OR user_id=1) AND brute_force=0 (0.001s)
      [14] => SELECT count(*) FROM  cpg_buddy WHERE user_id=1 AND buddy_ok = 'YES' (0.001s)
      [15] => SELECT count(*) FROM  cpg_buddy WHERE user_id=1 AND buddy_block = 'YES' (0s)
      [16] => SELECT count(*) FROM  cpg_buddy_req WHERE buddy_to=1 (0.001s)
      [17] => SELECT count(*) FROM  cpg_buddy_req WHERE buddy_from=1 (0.001s)
      [18] => SELECT id, buddy_ok, buddy_block, buddy_id, since, u.avatar_url, u.user_name as buddy_name, o.user_ip FROM cpg_buddy as b LEFT JOIN  cpg_users as u on b.buddy_id=u.user_id LEFT JOIN  as o on u.user_id=o.user_id WHERE buddy_ok='YES' AND b.user_id = 1 ORDER BY buddy_name ASC LIMIT 0, 25; (0.001s)
      [19] => SELECT COUNT(*) FROM cpg_pictures WHERE approved = 'NO' (0.001s)
  )
  
  ==========================
  GET :
  ------------------
  Array
  (
  )
  
  ==========================
  POST :
  ------------------
  Array
  (
  )
  
  ==========================
  VERSION INFO :
  ------------------
  PHP version: 4.4.1 - OK
  ------------------
  mySQL version: 4.1.15-log
  ------------------
  Coppermine version: 1.4.2(stable)
  ==========================
  Module: GD
  ------------------
  GD Version: bundled (2.0.28 compatible)
  FreeType Support: 1
  FreeType Linkage: with freetype
  T1Lib Support: 1
  GIF Read Support: 1
  GIF Create Support: 1
  JPG Support: 1
  PNG Support: 1
  WBMP Support: 1
  XBM Support: 1
  JIS-mapped Japanese Font Support:
  
  ==========================
  Module: mysql
  ------------------
  MySQL Supportenabled
  Active Persistent Links 0
  Active Links 1
  Client API version 4.1.11
  MYSQL_MODULE_TYPE external
  MYSQL_SOCKET /tmp/mysql.sock
  MYSQL_INCLUDE -I/usr/local/include/mysql
  MYSQL_LIBS -L/usr/local/lib/mysql -lmysqlclient 
  ==========================
  Module: zlib
  ------------------
  ZLib Support enabled
  Compiled Version 1.1.4
  Linked Version 1.1.4
  ==========================
  Server restrictions (safe mode)?
  ------------------
  Directive | Local Value | Master Value
  safe_mode | Off | Off
  safe_mode_exec_dir | no value | no value
  safe_mode_gid | Off | Off
  safe_mode_include_dir | no value | no value
  safe_mode_exec_dir | no value | no value
  sql.safe_mode | Off | Off
  disable_functions | no value | no value
  file_uploads | On | On
  include_path | .:/usr/local/php4 | .:/usr/local/php4
  open_basedir | no value | no value
  ==========================
  email
  ------------------
  Directive | Local Value | Master Value
  sendmail_from | me@localhost.com | me@localhost.com
  sendmail_path | /usr/sbin/sendmail -t -i  | /usr/sbin/sendmail -t -i
  SMTP | localhost | localhost
  smtp_port | 25 | 25
  ==========================
  Size and Time
  ------------------
  Directive | Local Value | Master Value
  max_execution_time | 30 | 30
  max_input_time | 60 | 60
  upload_max_filesize | 2M | 2M
  post_max_size | 8M | 8M
  ==========================
  Page generated in 0.312 seconds - 20 queries in 0.025 seconds - Album set : ; Meta set: ;
  

[sigepjedi]

also, is it possible for the watermarking to bypass .gif files?

This would allow for animated gif to still work

[Stramm]

Well I don't know much about SQL but I think this looks ok, Maybe I am missing something?

Well, how should I see from the debug if you added all the SQL with the correct prefix given in post one in this thread? Start up phpmyadmin and have a look

[Stramm]

I just limited it to 5 at a time... and it processed, but The normal_ images are still without the watermark.

I am running it as follows:

- Update thumbs and/or resized photos
> Everything... full sized, resized and thumbs

Checked all possible settings... all work as expected for me. Maybe you just need to reduce the number of images to process in a batch even more. Depends on your CPU usage and server settings. If it has a somehow smart setup it times out after ~5+- pics
You can wait a lil bit till I strat the 'better admin tools for 1.4x'. These will auto refresh the batch process.. you won't have to click 'continue' after every 5 pics that have been processed but go drinking a coffee or two