Two textpattern instances with one image folder

Kjeld · 2021-12-09 11:45:46

Bloke wrote #332148:

That’s a bind. Not sure if there’s any equivalent to CREATE VIEW. There’s CREATE TEMPORARY TABLE which can be used in a similar sort of way to make a ‘copy’ of another database on-the-fly but that’s more invasive as it needs to be done every session. Wouldn’t advocate that.

I wonder if there’s any way you could host a dedicated ‘image only’ Textpattern and use rah_swap to fetch stuff from it in your templates. So you could set up a shortcode maybe as a wrapper for <txp:images> which first connected to the images database. I’m not convinced that would work very well and it would require some additional plugin support for the Images panel (and Write panel if you use com_article_image or an equivalent plugin to help with adding pics to articles).

Can’t think of anything else off the top of my head, sorry.

Thanks, Bloke.

I was hoping there was another way to access the txp_image table in the master installation

Incidentally, I have made a shortcode that pulls in the image from the image folder on the master site. But it would be nice if there were access to the txp_image table

Kjeld · 2021-12-11 08:53:34

Bloke wrote #332148:

That’s a bind. Not sure if there’s any equivalent to CREATE VIEW. There’s CREATE TEMPORARY TABLE which can be used in a similar sort of way to make a ‘copy’ of another database on-the-fly but that’s more invasive as it needs to be done every session. Wouldn’t advocate that.

I wonder if there’s any way you could host a dedicated ‘image only’ Textpattern and use rah_swap to fetch stuff from it in your templates. So you could set up a shortcode maybe as a wrapper for <txp:images> which first connected to the images database. I’m not convinced that would work very well and it would require some additional plugin support for the Images panel (and Write panel if you use com_article_image or an equivalent plugin to help with adding pics to articles).

Can’t think of anything else off the top of my head, sorry.

Just tried to install rah_swap on a Textpattern v4.8.7 installation, but I get this error:

Warning “mysqli_real_escape_string() expects parameter 2 to be string, array given”.

jakob · 2021-12-11 11:16:29

Kjeld wrote #332165:

Just tried to install rah_swap on a Textpattern v4.8.7 installation, but I get this error:

Warning “mysqli_real_escape_string() expects parameter 2 to be string, array given”.

Hmm, I don’t see that function used at all in the current version’s code in his rah_swap GitHub repo.

You might want to try that version. You can either install it using composer as he suggest or compile it to a txt-installer as described here.

I’ve done that for you here – although it says v0.1.0 in the file and the plugin’s manifest.json, it is the code of what gocom calls the “forthcoming 0.2.0 version”, though nothing further has happened since then.

# Name: rah_swap v0.1.0
# Swap database on fly
# Author: Jukka Svahn
# URL: https://github.com/gocom/rah_swap
# Recommended load order: 5
# .....................................................................
# This is a plugin for Textpattern - https://textpattern.com/
# To install: textpattern > admin > plugins
# Paste the following text into the "Install plugin" box:
# .....................................................................

H4sIAAAAAAAAE+1abXPbNhL+rl+BajzVy8iUZcdpKkceOc5LfZO4Pr9cJuNkNCAJSbhQhAqC
ltU0//12FwBF0ZKTXu/TTf0hIfGy2F08eHYXFO/3nvS/ZP0n/XrKZ6J+lPWf9euaT0fZgs/x
9ad+/U7oTKoU3w779b2gF+zh89N+nedmqjS+9Hr9+j/yz585u7rjUxrb2/MDRrmW2HJw0K9P
jZln/W53Is00D4NIzboThf+WF0VpscgiLefGrbwP0q6gm8Xc8JBngqmUjZMl9oH2U5HQTBjl
jMCWkeYLUrv3DFt6AfOr1Gr1Cx595hOZmXrfKzX3TYHSE/cmMlStUI/9wepnWZaLbDVtqy04
+KVKuRGrwdA3VjqfBaH8vRtTZ3elFZkYqTQVkRExq1+LezPnxgidstN3VysxZtWBC7N3y6t/
vl05J5HpZ/SQmQr0EsszmU4YZ0bM5gksyQyfBOwaeudJPpEpm/KMBs+VEamRPGFGMZ4kasHm
eZLgbD836zCujYwSkTGexkzBPI1K40w21qBNLMdjofHVa5QFtdp0P2BnaWZAbK12QxrVT9Vs
rjKhS94UJnKNuA39Wi2MArbDfCPT4rdcasHK22KFv+CZjDI74Tl09fu0C3E4qM+W52Lx0ilT
P64x+AuCALXmMgVXg1pgIKgMrbXn3WL2ca1WcpNMjVZxHqHpLBUL9GOHDVeLdY+H1q/QwSKe
slCA80F+CG5iHKf5NTV5j5rQF4nosEwk490oUeQb2qL3U5FaAZW5uFnFdjvEwFmxOy8zFk15
OoFpADb27zwzNGGh+XwOjZGKhVVTaQl2wXb7eVpkRmkY49BT0obNudRuH0+M0TLMAQ21WjsO
2zXv20bGkEpgp8dsGIdDlIlyVAow5H4WWGo6LMo1ggQ6VpAvbCrZYNHrRpeMhbUiUNUCNmNN
8JPugJZZtlA67rCpykwLdKWdcgamDYOTYLNhAKjCZgBU0GDNn7A2bia6Sgu7OtmQxKXVg9qr
ew5HQvTRUIRYga8heynGPE9Mn43yNBZjhNgIPIUatgH7cGzBSXZj4aA5ofhY1qO8As4c1HM3
c/sKaL1dAbzjXRGwUwvFRIwNg3NslkyOaS2UyGIlyDFTficAZcW00vrYNqj7nu3ro8/bdGQK
b8IKEEMs3obYP6ST4bAM62EbWtXBtZU2LM1nIagF0EVl4OAgGbFERQDUTEWfhQn8+hn2DamL
RJd1xoZB3UsPTBJDDNp7ul35OATIacDmGp6xjQM4NaI2YDdZDgyGiAGYlBA9VTngo50q0/an
3iLM9Xj3w0GWBiAGDimxOwzP2M31691nHeIFi7pUpbt5KvG8rqthPchhFstTcT+3hwcOL7pk
HZnOpEEdyFumve3WR4mEozQaJ3wCEHp1bzRn9EKAsEhdpx2aELBzpWfkkqXKnbWIJgCKhjMf
qtxUnFV2oviGD8vGlDUc1LdbAn7APTwB1lWJAE+tljBTDpohqxIF0chsK5uGkAOg2RLGFFRJ
oYIIzjiiB9s2cLSTbnAjYQQEe7A1N2oG+xCR9Vs4li0go7BeE8BdSMZ2rSEJHJYdSQHCh0EA
q8H94loUCq3FFBtoaFAHRxQSySO4fQueEg8hlICh4KmE0kbJCxvcVd4qJ3fLBiEZt2vnyIFg
2hxJnPpKUkvEDiuMJfgQAnTh9iGKKHmCPGyFdDyxxWtS0CmYy2BQxCSF47q7fmG3BteaL9kd
15KHGJGHO963QwjPNjICZ637xM7NNSfMjCVNtI3BfDpf4yRUe1D3udQoDreiGMPsaVlyrfZe
IheCcZjdelDAZoIOVX90NuJ5zas2JGTA+fHDfX5oE2vKAAA3LOee3ZKVLXBMZgT3aJ2BdMIc
kJMcS1hk4dVHoBeaYmr4Eq32YTYuUe9m1f1pCjHho5Mk7UnKEFEL2EEAftUeXTrisYAj6jDh
PB6wS5+2Wz7FszxJVAhY93ig1IZO1Rou3Im3KfYMdlLuxhJySSybYDZhqmOzaRxDIwANlJJQ
/ApF4W9UxKHFY3JBpJgo9RnO70wmXOOcsXLybIYMKbLX6LaBgnuNT2zAbinTbcRhgw2OWeNd
kaP0Gh3bhQmA7/SJSdGJxO87L1zsLzoxsNrOIvxC16ejWq2iyv7jquw/psr+Y6rsf1uVOVGk
doTRG1Jwpef9ofNsKCzROjbCZ0oW146ArXWKCSu6HxZA2HISoemOJzlkc9XCxHIB6VVn3ePa
xq596iI2cLiAlHt6ELArSSDJMyhSAbLUZYsVV4tlRb7vToerU0jb46ENFQuZJGhQmRmLY1LA
vd2eQ4cyBOiRkw/k1W4/tApz4c2jXd313NzP+66EHEVQm8CSEZDhROmlmzra3+v1RpCq2RnF
rFDFy66T0n0o5rhSuZ1Zu51zIIndqFYJB3xlu63alhA/YWS8lqtJW8QSLmxaW26pgASOKsKR
ldYuimWEVAS6cTlJsfSKZeZAQ/MKosikpUna9qllkVgt0kTxOPPRzClaVmXj3hQTy9uBBD/y
PRWnr/WNEJOrAVsGIXC6JTHdx+Rs6K1u5Emo7lwhkdlgVDG/3S4a2u3yJqKr1iNBneYj+FeX
DrGKsqByp9LFIV0cvItPzv0nVK9X6nQ4dv5yhELKRFEHEftYmGjqT1a7XdyilNTcxgzF2DqS
AzoJksJ5DgkwJNxY2c+guoGAK/QjA6I4HRXpRsghnurR/uHT+96Tw78wa6UqJXrd44J5fLy2
dwlQqfgcOqUqga3K6YfZrEt6qOxP1MR6/F/2/pHtBfvBHttl+Rw2B2RAGskuIXOKICsL4Ll8
Qo8HT4KnMBoP2MUvF/D+E7zhFRKci1Am0iyDqvQeSQfiOejuHXb3nqL8s1TSZZgWUEbARrnr
RqzH6PFnvFis1brtGmsXWThIeVnUvnSNoOkapnKZh1O+eYUIg3DcqZovIfGeGtY8baGOP7PS
dasbdI01FoFbYskGdTREMy8ocIMKJXGsFqChGpsFgPaI0n9MCss8hKUqOLGrNE6eqViOl9iG
iaq9hAJzZpmPm2/Ob9gbAWABn13kYSIj9lZGkAkJnA6BZI6N2dRSK854jTpcOR3YawWCibo6
zN07s/1NqpeZ0kW3qZq78g7082ENKHicJx2cjqX4+7PrX369uWYn5x/Y+5PLy5Pz6w9HRbkl
7oQVhZGVElZM3VIDhdoYJbx7dXn6C0w5eXH29uz6A95PvD67Pn91dcVe/3rJTtjFyeX12enN
25NLdnFzefHr1Svga0HpBc7f7h3Cx4xSVJuZeps/FBW1vZzRIhISE3asM+fL7/R7ouDIUfZd
wAHrKCiz8c5RsOeIQ4DhYrEIJmlO19+JnZ91j1GXLoKcNLqwN6FRAjmY7RlTPUgNlEPjJXbt
C1E7zcG/NrvC4sndBfoaci3DCtxIP2EIWbfNnV1Ll/6fa3mHN9g7sa2abIkEmV5lPWgHiOSW
HdYEWP+M89QS1QhTATu02aIRX4rAtYP3FrvHa0tBKuuaJ8I1NVtHNOXrAy3e+NuFx03VwuTA
CtutLbQtrdkvjV+p7EqWHeD1aDw5KtrdEmvtD/W9+lP6kh8e1zcr9LWl9Y4VDMpjEP1O3V0D
eJ6EjGZCT0Rz0+Z0igU2WA7Dt9kNNQJ9xiDTIX1CjqGCzZWtjmNWH1Aohbs32zyDF0+PO0Zm
J1Y+bmQx/EtV6zle3jUbFKahyj5mIpoqVge4QgRyqRO2N1psMBiwBnY0HkUjdzhD7qAK9K+h
8S2K+BYYPe082BSLilZ1xDbVbWEGoYMudKt6g6/4jDGMDMB3O1TQXbvK7r837sUS76maZalb
rN2xBX2ZH5x3HD3hnxyz5g8yg3PRtONvSeSnVqskCf/MVKsFfbr4eJZCBSnjEz3J8RPVq/tI
0JfRZsP1WL+QwRMID2mjBP+vtarT19bd5nCbhdkaZpWobkbK9/EAlPSxT4yq7nyEDF6+WNky
W2a/JXIEoyHLhNKtCb27x2hOx4n6c8f+UvhPL6u09H/FfE5y809bh4WFWFnWKvMg4WrFqQ8D
UXn0yxeARQRQeZHvcwvdim+4CLcfLxbwX5zTBkqbIcvf/6q7qBjY4qyylLL5t59au8eFn7db
g8mq/aRHX1W38IZlRec7yNMzVv7MWRls8ftHmicJ6QWuOH34MbnqBzvr0XREk7aYQ/mIiap0
/CKwobAkumklajvfdnzo7FikrbGQc2cpEFEIGfMkE1Uycvo3Ght5BaU5SkNl7a1fYwOl6WWl
ZeXrwSoWrLGno991wUdrQr7i9VE0Zc2tRMl2Hlhk9ZGTCVS2Qmulm5Pre9NsSCtiVFSlI7q9
a3TYbeMLUsxXumhc0+dTq6LRFpdZt21woMCPbYDhBACXNW/XJjToZNCitDWdovdTx6rRqsaX
CMootxd2T3vsxx/Z2g7F4Yb9WR2wNa4uTyntPxOgDYWzHVJxuzTPVqTQgxNb8YWHJoD9h4GD
e1WyvVkYMMx2jqpd5PaBy5yspAdqPxToZj2C8EetdPT1aNi1/3uaggF/Xxz8fXHw/39xcA0l
Sh/YvNn4WELyx2s++Xgp8Od2etlo4QnCZ6Gbt5iy+IuEZquDDOhjYuMTvvrP3a0jdyFnlnMo
h2R/z/5IUWm8E4X3Q/tOPxjw/c9gOKkRfa4fnePPDWEE1XqjqZklI/tbwpDGHvTrs/iQfry4
368fPuEHz8ZPD+Mo/OnZwc9PnvX2Dg54PA7D/SfRYRjWj77+B+vcv2tSKQAA

Does this version work any better?

Kjeld · 2021-12-11 13:19:28

jakob wrote #332166:

Hmm, I don’t see that function used at all in the current version’s code in his rah_swap GitHub repo.

You might want to try that version. You can either install it using composer as he suggest or compile it to a txt-installer as described here.

I’ve done that for you here – although it says v0.1.0 in the file and the plugin’s manifest.json, it is the code of what gocom calls the “forthcoming 0.2.0 version”, though nothing further has happened since then.

# Name: rah_swap v0.1.0...

Does this version work any better?

No error messages now! Thanks, Julian!

I downloaded the plugin from the Plugins section on this site…

Kjeld · 2021-12-11 13:54:37

I have been going through the help file of rah_swap.

Now, my English and Japanese installations share one database. The Japanese one uses the prefix ja_.

If I move the Japanese installation to a separate database, I should be able to pull the image information from the English installation, right? No need to create an ‘image only’ Textpattern?

Or, am I understanding this wrong?

Also, out of intellectual curiosity, if it is possible to have a plugin like rah_swap access a different database for a small piece of code, couldn’t the same be done for a table with a different prefix (or without one) in the same database?

EDITED

Just found this shortcode. Does it do what I asked about in the last question?

Last edited by Kjeld (2021-12-11 14:01:53)

Bloke · 2021-12-11 17:54:20

Yes, pulling images from one of the installations is perfect for what you need. I wasn’t clear when I said “images only”: I meant one has real images in it and the other doesn’t.

As for the short code: yep. Does the same as rah_swap, essentially. All you’re doing is supplying (overriding) the default credentials supplied from config.php with different credentials that point to another database.

Since the image dir and prefs of the 2nd DB hold the path to the images files, as far as your host installation is concerned, they’re “local” to it.

The only thing you might have to watch is if the prefs have already been loaded, you may find they’re set to the host DB. So you might have to do a force refresh on get_prefs() somehow, after supplying the new credentials, and just after reassigning the old DB creds back. YMMV.

Last edited by Bloke (2021-12-11 17:58:36)

colak · 2021-12-12 07:48:16

Kjeld wrote #332168:

Now, my English and Japanese installations share one database.

I was just wondering how you are dealing with the alt attribute on this. Do you just use English or do you use another field for the Japanese site?

I am also wondering how search engines would interpret the hotlinking of images and the possible different alts.

Kjeld · 2021-12-12 08:28:36

colak wrote #332172:

I was just wondering how you are dealing with the alt attribute on this. Do you just use English or do you use another field for the Japanese site?

I am also wondering how search engines would interpret the hotlinking of images and the possible different alts.

I haven’t quite solved this issue yet…

The shortcode I mentioned won’t connect me to the database. And I still have to try rah_swap with the Japanese installation on a separate database.

I also haven’t yet figured out how to change the Image directory in the Textpattern Admin Preferences to a folder on another domain. And I don’t know if that is actually needed if rah_swap works…

Julian advised me to install jcr_image_custom. It adds tables to txp_image in the DB, so you can access the foreign language data when you access txp_image

Kjeld · 2021-12-12 08:44:48

Incidentally, I did manage to make a shortcode a little while ago that pulls the image from another domain, and adds alt and caption in the body of the article.

But I would like to have everything go through the database if it is possible.

Here is the shortcode (named media_image):

<txp:images wraptag="figure" class='my-4 <txp:if_yield name="class"><txp:yield name="class" /></txp:if_yield>'>
<img src="https://www.OTHER_DOMAIN.com/images/ls-1024/<txp:yield name="id" />.jpg"
srcset="https://www.OTHER_DOMAIN.com/images/ls-640/<txp:yield name="id" />.jpg 640w,
https://www.OTHER_DOMAIN/images/ls-768/<txp:yield name="id" />.jpg 768w,
https://www.OTHER_DOMAIN.com/images/ls-1024/<txp:yield name="id" />.jpg 1024w"
class="d-block w-100" alt="<txp:yield name="alt" />"
/>
<figcaption class="figure-caption mx-3 mx-md-0"><txp:yield name="caption" /></figcaption>
</txp:images>

Responsive images in body of articles. Caption is only displayed if entered in photo. Class mx-3 mx-md-0 for figcaption adds margin on small screens. The caption left aligns with the images on medium screens and above.

Use this shortform:

<txp::media_image id="" class="" alt="" caption=""/>

ls-640, ls-768 and ls-1024 are different image sizes created with smd_thumbnail. This serves a smaller or larger image depending on the screen size.

class="" is to add an additional class. You can input multiple classes.

The other classes in this sample (like: figure-caption mx-3 mx-md-0) are actually bootstrap classes. Not really needed for the example, but I thought it would illustrate how to have classes in your shortcode.

Note that this only works for jpg files.

Last edited by Kjeld (2021-12-12 08:46:35)

Kjeld · 2021-12-12 10:20:40

I just tested the following setup and it mostly works.

English installation on DOMAIN_1, with DATABASE_1
Japanese installation on DOMAIN_2, with DATABASE_2
jcr_image_custom to input both English and Japanese Alternate text and Caption in the English installation. The data is stored in txp_image on DATABASE_1
rah_swap around txp:images tag in the Japanese installation, pulls the Japanese Alternate text and Caption from txp_image in DATABASE_1

The only thing that I have yet been unable to figure out is how to pull the images from the image folder on DOMAIN_1. Currently, the images are served from the image folder on DOMAIN_2.

The path to the Image directory of the Japanese installation should be changed to DOMAIN_1. How do I do that?

I have tried adding a path to the name of the images folder in the Image directory of the txp Admin Preferences in the Japanese installation, but this doesn’t work. I think you can only adjust the name of the folder here, not the path?

Any advice, suggestions?

Bloke, you wrote this:

The only thing you might have to watch is if the prefs have already been loaded, you may find they’re set to the host DB. So you might have to do a force refresh on get_prefs() somehow, after supplying the new credentials, and just after reassigning the old DB creds back. YMMV.

I fear that is far beyond my expertise. I have no idea how to do this and where.

Bloke · 2021-12-12 10:51:12

I expect the reason it’s using the old image path (ihu) is because the prefs aren’t being refreshed as I suggested above. Give me a little while to get near a laptop and I’ll see if I can test it out and see the best approach.

Kjeld · 2021-12-12 11:00:00

Bloke wrote #332179:

I expect the reason it’s using the old image path (ihu) is because the prefs aren’t being refreshed as I suggested above. Give me a little while to get near a laptop and I’ll see if I can test it out and see the best approach.

Oh, thank you, Bloke!

Textpattern CMS

Textpattern CMS support forum

#49 2021-12-09 11:45:46

Re: Two textpattern instances with one image folder

Bloke wrote #332148:

#50 2021-12-11 08:53:34

Re: Two textpattern instances with one image folder

Bloke wrote #332148:

#51 2021-12-11 11:16:29

Re: Two textpattern instances with one image folder

Kjeld wrote #332165:

#52 2021-12-11 13:19:28

Re: Two textpattern instances with one image folder

jakob wrote #332166:

#53 2021-12-11 13:54:37

Re: Two textpattern instances with one image folder

#54 2021-12-11 17:54:20

Re: Two textpattern instances with one image folder

#55 2021-12-12 07:48:16

Re: Two textpattern instances with one image folder

Kjeld wrote #332168:

#56 2021-12-12 08:28:36

Re: Two textpattern instances with one image folder

colak wrote #332172:

#57 2021-12-12 08:44:48

Re: Two textpattern instances with one image folder

#58 2021-12-12 10:20:40

Re: Two textpattern instances with one image folder

#59 2021-12-12 10:51:12

Re: Two textpattern instances with one image folder

#60 2021-12-12 11:00:00

Re: Two textpattern instances with one image folder

Bloke wrote #332179:

Board footer