Jump to content

(RU4) URLs Transliteration


Ilya Hoilik
 Share

Recommended Posts

7 minutes ago, media said:

Thanks ABGenc,

I missed that but is there any complete list of this SQL queries???


UPDATE core_members SET members_seo_name='';
UPDATE forums_forums SET name_seo='', seo_last_title='', seo_last_name='';
UPDATE forums_topics SET title_seo='';

 

Since the table names require the prefix you have defined ( if any ) during setup, the complete list can not be given. But if you have it 3 queries were enough for my site.

Link to comment
Share on other sites

UPDATE blog_blogs SET blog_seo_name='';
UPDATE blog_entries SET entry_name_seo='';
UPDATE calendar_calendars SET cal_title_seo='';
UPDATE cms_database_categories SET category_last_seo_title='';
UPDATE core_announcements SET announce_seo_title='';
UPDATE core_members SET members_seo_name='';
UPDATE downloads_categories SET cname_furl='';
UPDATE forums_forums SET name_seo='', seo_last_title='', seo_last_name='';
UPDATE forums_topics SET title_seo='';
UPDATE gallery_albums SET album_name_seo='';
UPDATE gallery_categories SET category_name_seo='';
UPDATE gallery_images SET image_caption_seo='';

But that's not all. As far as I see, there is missed query for Downloads files at least.

Link to comment
Share on other sites

Ok I did run this:

UPDATE inv_core_members SET members_seo_name='';
UPDATE inv_forums_forums SET name_seo='', seo_last_title='', seo_last_name='';
UPDATE inv_forums_topics SET title_seo='';

and my last post link on the right side shows empty (GetNewComment)?

http://www.mysite.com/test/topic/417603-/?do=getNewComment

before ?do there suppose to be SEO Friendly link but not there

Everything else worked forum names / subforums / members and so on

Edited by media
Link to comment
Share on other sites

  • 2 months later...
On 4/18/2015 at 10:55 PM, revaboss said:

Nice try , is very useful :thumbsup:

in my opinion
in the Greek language is not enough to convert one letter but the agreement for vowels ,syllables and consonants to understand it when someone read it

sometimes latin characters give "bugs" for this language (for the stated reason) and the bugs , bad SEO :P

Hidden Content

I hope didn't insult you I just made a reference to the Greek grammar

This is very correct. Greeklish would be the best way. 

Link to comment
Share on other sites

  • 2 weeks later...

Greek to greeklish substitutions list  with the not helpful originals of the plugins, in parentheses

 

χ  =  ch   

γκ  =  g   (not gk)

φ = f  (not ph)

Υ=  y (not i) 

ω= w (not o)   (this is optional) 

β= v (not b)

 

edit i think i cannot have 2 characters have the same substitution. 

ideally both ξ and  χ   could end up in    the X latin character. but i think the plugin wont take  2   of the same substitutions. can it be ?

i used ch for x and it looks very well : 

xana chorismos       and   vrisko  instead of brisko

egyos instead of egkyos     . i didnt choose the w for ω,  maybe i will later on. 

 

 

Edited by MeMaBlue
Link to comment
Share on other sites

the (most) querys for the pre-existing links work, very nice ! 

but i have a problem, i am urgent seeking the query that will also involve  all links that end with        = get newcomment    because those are broken now! 

example is http://www.parentscafe.gr/forum/topic/6715-/?do=getNewComment        after the 6715-     the url is missing.

 if i edit the link ,  it will get the correct one, it will repair.  but i obviously cant edit all forum home page links - @Ilya Hoilik i have sent pm, but posting it if someone sees it earlier and knows what its about/how to solve .

 

Link to comment
Share on other sites

  • 3 months later...

Hello @Ilya Hoilik

I would like to confirm that its running effectively for on 4.1.19  ,

the fixfurl.zip  though ,     caused a php fatal error  (allowed memory size of bytes 536870912 exhausted (tried to allocate 4104 bytes)  in ........ init.php(448) : eval()'d code on line 33 

my associate will run it again and see, will report further. 

Ok , he just ran it again, and now its working splendidly! 

THANK YOU again 

Edited by MeMaBlue
Link to comment
Share on other sites

  • 3 months later...
On ‎8‎/‎10‎/‎2017 at 11:04 AM, Ilya Hoilik said:

@media do you mean you can't download zip file or script is not working properly? I downloaded it successfully and reviewed the code - it should works.

fixfurl.zip

@Ilya HoilikI ran fixfurl.zip  but problem is still there:

it turns this link (every where in the board)

http://www.domain.com/forum/topic/126428-apple-is-growing/?do=getNewComment

to this:


http://www.domain.com/forum/topic/126428-/?do=getNewComment

omitting the topic name from getNewComment function and system does not recreate the link.

Even if you visit that page it is not recreating that link

Only and only if someone post something (NEW) under that topic then system recreates that link

How can I recreate those links without posting under that topic?????

 

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...
 Share

  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...