Facebook  Twitter 

SMFHacks.com

+- +-

SMFHacks.com

+- User Information

Welcome, Guest.
Please login or register.
 
 
 
Forgot your password?

+- Forum Stats

Members
Total Members: 12415
Latest: dlhsmfhacks
New This Month: 1
New This Week: 1
New Today: 0
Stats
Total Posts: 40899
Total Topics: 7165
Most Online Today: 63
Most Online Ever: 2482
(April 09, 2011, 07:02:45 pm)
Users Online
Members: 0
Guests: 32
Total: 32

Author Topic: From SMF Gallery Lite to SMF Gallery Pro  (Read 520 times)

0 Members and 1 Guest are viewing this topic.

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #15 on: April 21, 2021, 03:34:08 pm »
You would need to convert the gallery tables character set via phpmyadmin to utf8
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #16 on: April 22, 2021, 01:21:33 am »
The forum database has encoding utf8_general_ci but I noticed that some gallery tables have utf8 encoding and some have latin1_swedish_ci - why is that?

In smf_gallery_usercat > Operations > Collation > here I set utf8_general_ci and unfortunately the diacritics are still not displayed.

I have set all the gallery tables the same.
« Last Edit: April 22, 2021, 01:50:40 am by Monocero »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #17 on: April 22, 2021, 07:23:23 am »
The gallery currently does not set tables at uft8 if enabled in SMF will make that change in a future update.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #18 on: April 22, 2021, 09:35:10 am »
Added a fix to the user category edits for other characters sets download latest version at
https://www.smfhacks.com/index.php/topic,9539.msg41642.html#msg41642
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #19 on: April 22, 2021, 01:35:20 pm »
Unfortunately, diacritics in my language are still not correctly displayed in the user's gallery (in the gallery name and description). I uploaded this revised version and it is the same. :-\ Again in phpmyadmin in each gallery table should I set utf8_general_ci?
« Last Edit: April 22, 2021, 01:39:03 pm by Monocero »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #20 on: April 22, 2021, 01:42:01 pm »
You are using SMF 2.0.x right? Or 2.1.x?

Yes each table characters set should be UTF8 but in this case it is mainly gallery_user_cat table
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #21 on: April 22, 2021, 02:19:28 pm »
You are using SMF 2.0.x right? Or 2.1.x?

SMF 2.0.18

Yes each table characters set should be UTF8 but in this case it is mainly gallery_user_cat table

I set all gallery tables to utf8_general_ci and still get a question mark instead of the diacritical mark.

I noticed that some gallery tables have Storage Engine: InnoDB and some tables have MyISAM. Does it matter?

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #22 on: April 22, 2021, 02:34:30 pm »
You might have to change the column to utf8 as well since this table was converted to utf8
column's in gallery_user_cat would be title and description columns
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #23 on: April 22, 2021, 02:54:44 pm »
I will have to change the collation in this column to utf8. And in each column of the gallery table where is latin1 I have to change to utf8? I mean:

smf_gallery_catperm
smf_gallery_comment
smf_gallery_creport

I noticed that some gallery columns have latin1 instead of utf8.



« Last Edit: April 22, 2021, 02:59:19 pm by Monocero »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #24 on: April 22, 2021, 02:58:09 pm »
title,description matter in that case. Basically any places you want those characters accepted.
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #25 on: April 23, 2021, 05:19:47 am »
I changed all gallery columns from latin1 to utf8.

Some time ago I changed the user numbers in the smf_gallery_usercat table in user_id_cat - I just wanted to sort the users, starting with me as number 1 and unfortunately the photos in my gallery did not display, user galleries didn't have photos either. So I re-entered the correct numbers, I undone my change. Out of curiosity, I would like to know if it is safe to change the order of users in this table at all?

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #26 on: May 03, 2021, 10:11:48 am »
I translate this modification into my language and want to know which file I still need to translate? First I started translating the file Gallery.english-utf8.php

I noticed that there is content in these files to translate:

smfgallery2.0.x.xml
smfgallery.xml

There is this content in the Modifications.english.php file:

Code: [Select]
// Begin SMF Gallery Text Strings
$txt['smfgallery_menu'] = 'Gallery';
$txt['smfgallery_admin'] = 'Gallery Configuration';

$txt['gallery_ftp'] = 'Batch Add';
$txt['gallery_text_catpermlist2'] = 'Category Permissions';
$txt['gallery_filespace'] = 'Space Manager';
$txt['gallery_form_approveimages'] = 'Approve Images';
$txt['gallery_form_reportimages'] = 'Reported Images';
$txt['gallery_form_approvecomments'] = 'Approve Comments';
$txt['gallery_form_managecats'] = 'Manage Categories';
$txt['gallery_text_settings'] = 'Settings';
$txt['gallery_text_videosettings'] = 'Video/Audio Settings';
$txt['gallery_txt_moderationcenter'] = 'Moderation Center';
$txt['gallery_txt_imagemoderation'] = 'Image Moderation';
$txt['gallery_txt_commentmoderation'] = 'Comment Moderation';

$txt['gallery_menu_addpic'] = 'Add Picture';
$txt['gallery_menu_addvideo'] = 'Add Video/Audio';
$txt['gallery_menu_search'] = 'Search';
$txt['gallery_menu_stats'] = 'Stats';

//Permissions
$txt['permissiongroup_smfgallery'] = 'SMF Gallery';
$txt['permissiongroup_simple_smfgallery'] = 'Use SMF Gallery';

$txt['permissionname_smfgallery_view'] = 'View SMF Gallery';
$txt['permissionhelp_smfgallery_view'] = 'Allows the user to view the Gallery';
$txt['cannot_smfgallery_view'] = 'You are not allowed to view the Gallery';

$txt['permissionname_smfgallery_add'] = 'Add Picture';
$txt['permissionhelp_smfgallery_add'] = 'Allows the user to add a picture.';
$txt['cannot_smfgallery_add'] = 'You are not allowed to add a picture.';

$txt['permissionname_smfgallery_bulk'] = 'Bulk Uploads';
$txt['permissionhelp_smfgallery_bulk'] = 'Allows the user to use the bulk upload feature.';
$txt['cannot_smfgallery_bulk'] = 'You are not allowed to bulk upload.';

$txt['permissionname_smfgallery_edit'] = 'Edit own Picture';
$txt['permissionhelp_smfgallery_edit'] = 'Allows the user to edit their own picture.';
$txt['cannot_smfgallery_edit'] = 'You are not allowed to edit that picture.';

$txt['permissionname_smfgallery_delete'] = 'Delete own Picture';
$txt['permissionhelp_smfgallery_delete'] = 'Allows the user to delete their own picture.';
$txt['cannot_smfgallery_delete'] = 'You are not allowed to delete that picture.';

$txt['permissionname_smfgallery_ratepic'] = 'Rate Picture';
$txt['permissionhelp_smfgallery_ratepic'] = 'Allows the user to rate a picture.';
$txt['cannot_smfgallery_ratepic'] = 'You are not allowed to rate that picture.';

$txt['permissionname_smfgallery_editcomment'] = 'Edit own Comment';
$txt['permissionhelp_smfgallery_editcomment'] = 'Allows the user to edit their own comments.';
$txt['cannot_smfgallery_editcomment'] = 'You are not allowed to edit that comment.';

$txt['permissionname_smfgallery_comment'] = 'Leave Comments';
$txt['permissionhelp_smfgallery_comment'] = 'Allows the user to leave comments on a picture.';
$txt['cannot_smfgallery_comment'] = 'You are not allowed to leave comments.';

$txt['permissionname_smfgallery_report'] = 'Report Pictures/Comments';
$txt['permissionhelp_smfgallery_report'] = 'Allows the user to report pictures and comments.';
$txt['cannot_smfgallery_report'] = 'You are not allowed to report content.';

$txt['permissionname_smfgallery_autocomment'] = 'Auto Approve Comments';
$txt['permissionhelp_smfgallery_autocomment'] = 'Comments do not need to wait for approval.';

$txt['permissionname_smfgallery_autoapprove'] = 'Auto Approve Pictures';
$txt['permissionhelp_smfgallery_autoapprove'] = 'Pictures do not need to wait for approval.';

$txt['permissionname_smfgallery_usergallery'] = 'Personal Gallery';
$txt['permissionhelp_smfgallery_usergallery'] = 'Allows the user to have a personal gallery.';
$txt['cannot_smfgallery_usergallery'] = 'You are not allowed to have a gallery.';

$txt['permissionname_smfgallery_manage'] = 'Admin Gallery';
$txt['permissionhelp_smfgallery_manage'] = 'Allows the user to add/delete/edit all catagories. Delete Comments, Delete Pictures, Approve Pictures.';
$txt['cannot_smfgallery_manage'] = 'You are not allowed to manage gallery.';

//Permissions
$txt['permissiongroup_smfgalleryvideo'] = 'SMF Gallery Pro Video/Audio';

$txt['permissionname_smfgalleryvideo_add'] = 'Add Video/Audio';
$txt['permissionhelp_smfgalleryvideo_add'] = 'Allows the user to add a video/audio file';
$txt['cannot_smfgalleryvideo_add'] = 'You are not allowed to add a video/audio file.';

// END SMF Gallery Text Strings

I know that I need to translate these lines, but this content is in these two files. So, which file should I open for translation? I use SMF 2.0.18

smfgallery2.0.x.xml
smfgallery.xml
« Last Edit: May 03, 2021, 10:22:19 am by Monocero »

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #27 on: May 03, 2021, 09:33:59 pm »
You would use smfgallery2.0.x.xml
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

Offline Monocero

  • Forum Toolbox
  • Newbie
  • *****
  • Posts: 47
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #28 on: May 04, 2021, 01:49:45 am »
Thank you for the information.

I know that I need to translate the lines between "Begin SMF Gallery Text Strings/END SMF Gallery Text Strings" and this line for Who.MyLanguage.php file. Yes?

Code: [Select]
$txt['whoall_gallery'] = 'In the <a href="' . $scripturl . '?action=gallery">Gallery</a>';
Code: [Select]
<file name="$languagedir/Who.english.php">
 <operation error="ignore">
 <search position="end"></search>
 <add><![CDATA[
// Begin SMF Gallery
$txt['whoall_gallery'] = 'In the <a href="' . $scripturl . '?action=gallery">Gallery</a>';
// END SMF Gallery Strings
]]></add>
 </operation>
</file>

https://www.smfhacks.com/smfgallery/help/

Offline SMFHacks

  • Administrator
  • Hero Member
  • *****
  • Posts: 15429
    • View Profile
Re: From SMF Gallery Lite to SMF Gallery Pro
« Reply #29 on: May 04, 2021, 07:17:44 am »
Yes for Who.language file
Get your Forum Ranked! at https://www.forumrankings.net - find out how your forum compares with others!

Like What I do? Support me at https://www.patreon.com/vbgamer45/

 

Related Topics

  Subject / Started by Replies Last post
5 Replies
5657 Views
Last post January 12, 2007, 06:28:22 am
by softtouch
10 Replies
6875 Views
Last post December 05, 2007, 10:49:46 pm
by djmac
3 Replies
4809 Views
Last post April 21, 2008, 10:17:18 pm
by SMFHacks
6 Replies
3929 Views
Last post November 24, 2013, 03:03:34 pm
by dan42101
3 Replies
1931 Views
Last post May 04, 2017, 03:30:12 pm
by SMFHacks

+- Recent Topics

Guest has high bid? by SMFHacks
May 05, 2021, 10:05:52 pm

Reorder/Sort Categories by SMFHacks
May 05, 2021, 07:05:21 pm

Moved forum to new host, new domain by Krash
May 04, 2021, 06:10:59 pm

From SMF Gallery Lite to SMF Gallery Pro by SMFHacks
May 04, 2021, 07:17:44 am

SEO Analyze question by SMFHacks
April 30, 2021, 07:35:12 pm

Many of these errors, but don't know how to replicate by scso1502
April 25, 2021, 01:21:54 pm

[Mod]Disable FLoC Tracking by SMFHacks
April 20, 2021, 09:12:36 pm

looking for SMF mods by cloudsurph
April 13, 2021, 11:59:07 am

siapamoyanganda.com/familyforum/ by SMFHacks
April 12, 2021, 07:55:58 am

Problem with SimpleAudioVideoEmbedder by Panoulis64
April 08, 2021, 09:08:58 am

Powered by EzPortal