Meddysong

As others have said, you need to purchase 'Branding Removal' is a separate product which you have to purchase in the client area. Removing it in some other way would violate the terms of service you agreed to when making the initial purchase. That would still leave you with the theme information; you would need to purchase copyright removal for that from the designer: https://www.ipsfocus.com/themes/copyright/

That's standard behaviour and isn't controlled by a setting. The logo template is set up so that if there isn't a logo uploaded, the name of the community shows instead. To make your name disappear, you could: 1) Add a logo. 2) Add the following to your custom CSS: #elSiteTitle { display: none; } 3) Edit the template logo in your theme. Since editing templates isn't a good idea if you can avoid it, I wouldn't do that. Either of 1 or 2 will solve the problem.

No, it's outside of Invision Community. A locale is a file stored on your server and accessed by the software.

Invision Community has a specific app for blogging: https://invisioncommunity.com/features/content/#blogs

Unfortunately not with Databases, no, because each one can have custom fields, so things would break if a record from A were moved to B. If you're comfortable with SQL, then you could insert a record's details (everything except for the fields) into the relevant database table, and then remove it from the original. But there isn't a built-in solution, I'm afraid.

Lovely: that's sorted out how to set out the joins. Thank you for that. For anybody who is looking to do the same, you preprend the JOIN aliases to the field word_custom in the SELECT part to disambiguate: SELECT p_id AS ID, titleEn.word_custom AS Title, descEn.word_custom AS Description, p_group AS Category, categories.pg_id, categories.pg_parent, catName.word_custom AS Category, parentCat.word_custom AS 'Category Parent', p_stock AS Stock, p_store AS 'On Sale', GBP AS Price, p_discounts AS Discounts, titleEo.word_custom AS Titolo, descEo.word_custom AS Priskribo, from_unixtime(p_date_added, '%Y-%d-%m') AS Added, from_unixtime(p_date_updated, '%Y-%d-%m') AS Updated FROM nexus_packages as np LEFT JOIN core_sys_lang_words AS titleEn ON titleEn.lang_id=1 AND titleEn.word_key=CONCAT('nexus_package_', np.p_id) LEFT JOIN core_sys_lang_words AS descEn ON descEn.lang_id=1 AND descEn.word_key=CONCAT('nexus_package_', np.p_id, '_desc') LEFT JOIN core_sys_lang_words AS titleEo ON titleEo.lang_id=2 AND titleEo.word_key=CONCAT('nexus_package_', np.p_id) LEFT JOIN core_sys_lang_words AS descEo ON descEo.lang_id=2 AND descEo.word_key=CONCAT('nexus_package_', np.p_id, '_desc') LEFT JOIN nexus_package_base_prices AS prices ON prices.id = np.p_id LEFT JOIN nexus_package_groups AS categories ON categories.pg_id = np.p_group LEFT JOIN core_sys_lang_words AS catName ON catName.lang_id=1 AND catName.word_key=CONCAT('nexus_pgroup_', categories.pg_id) LEFT JOIN core_sys_lang_words AS parentCat ON parentCat.lang_id=1 AND parentCat.word_key=CONCAT('nexus_pgroup_', categories.pg_parent) ORDER BY p_store DESC In other words, if your alias is 'title', then your SELECT line will feature 'title.word_custom'.

I don't know whether there's a way to build conditional logic into the string. It's possible with numbers but the relevant template files know that a logic check is coming and are written differently accordingly. You do have the option here of changing the order of elements, so you could have: %2$s antwortete auf %1$s von/des %3$s in if that sounds fairly natural. That just passes a problem on, though, I think because you'd need to choose between articles depending on the gender of topic/blog post/file etc of whatever %1$s is going to be in a situation. You're probably best served to keep the ordering and accept that sometimes it's not grammatically perfect. There are plenty of people who (wrongly) believe that apostrophe-s doesn't follow 's' in English but who have to get used to seeing James's etc online. This sort of conundrum is why.

I'm trying to create a query which will display the items we have for sale, the descriptions, the stock count, and so on. One of the challenges I have is that the site has two languages, so if I want the name of a product, I have to look in core_sys_lang_words: SELECT p_id AS ID, word_custom AS Title, word_custom AS Description, p_group AS Category, p_stock AS Stock, p_store AS 'In Store', GBP AS Price, p_discounts AS Discounts, from_unixtime(p_date_added, '%Y-%d-%m') AS Added, from_unixtime(p_date_updated, '%Y-%d-%m') AS Updated FROM nexus_packages as np LEFT JOIN core_sys_lang_words as lang ON lang.lang_id=1 AND lang.word_key=CONCAT('nexus_package_', np.p_id) LEFT JOIN nexus_package_base_prices as prices ON prices.id = np.p_id ORDER BY p_store DESC The crucial part there is: LEFT JOIN core_sys_lang_words as lang ON lang.lang_id=1 AND lang.word_key=CONCAT('nexus_package_', np.p_id) For the product with the p_id 1, that looks up the row with the value nexus_package_1 in the field word_key, returning the value for word_custom: Here's where I am stuck: 1) I'd also like to select the description, which is in the field word_custom where the word_key is nexus_package_X_desc. 2) I'd ideally like to select the title and description where lang_id = 2 too. 3) I'd also like to select the category name, which will involve looking up word_custom for 'nexus_pgroup_X'. The problem I'm experiencing is in the SELECT line, since in each case it involves the field word_custom, which will naturally repeat the same value every time I mention it. How can I do the equivalent of word_custom AS Description, word_custom AS 'Title (language 2)', word_custom AS 'Category (language 1), word_custom AS 'Category (language 2), etc?

Don't change it in block.css because it may be overwritten in future updates; make the change in your custom.css file instead.

It means that only your account will see the strings presented like that. But that's the wrong function anyway: you need the Visual Language Editor, which will allow you to change the string by clicking and holding over it.

Your way's not necessarily wrong if it works for you but it seems a lot more complex than it needs to be, and amending the templates themselves is usually a last-ditch solution. It seems to me that you can solve the problem easily with one entry in custom.css: @media (min-width:992px){ .ipsUserPhoto_large { height: yourheight; width: yourwidth; } } This will apply throughout the suite so if it's important to hit only Forums but leave other instances of the large photo unchanged, you could try a more specific way of targeting, such as: body[data-pageapp="forums"] @media (min-width:992px){ .ipsUserPhoto_large { height: yourheight; width: yourwidth; } }

That's not quite correct; you're missing { }: @media screen and (max-width: 767px) { .ipsType_normal, .ipsType_medium, body { font-size: 17px; } }

Yes, that's understandable, Charles, and I don't think anybody could expect you to do a full replacement of every single mention for precisely that reason. It would be possible to target names in quotes and mentions, wouldn't it? I'm not a particularly versed coder but your team could probably find a way to say "any instance of the username which is located within <ipsCitation> tags or within a container which has the data attribute 'data-mentionid'", I would think.

No. That's a variable name for the system to process.

No, I'm sorry, but I don't know the answer to that question. My suspicion is that the you will see this: I'm going to introduce a [b]spoiler[/b] below, folks! [spoiler]Isn't it a nice surprise?[/spoiler] in your past content. A spoiler now takes the following form: <div class="ipsSpoiler" data-ipsspoiler=""> <div class="ipsSpoiler_header"> <span>Spoiler</span> </div> <div class="ipsSpoiler_contents ipsClearfix"> <p> The text you're hiding. </p> </div> </div> , so I assume you would have to run a script to change all instances of [spoiler] to the first bit, and [/spoiler] to the second. I'm in no way qualified to give that assessment, though, so I'd either wait for somebody to advise you with more certainty, or test it in a backup environment. Perhaps IPS would consider some sort of task to pull this off automatically with old content?

You don't have to create a custom button, since one already comes as an option. Go to "Edit Toolbars" in the ACP, and drag the eye icon onto the toolbars to have it present for your users.

You probably want to stay away from his later posts in this topic. He doesn't get any better.

Ah, sorry, that was inadvertently brusque of me. I'd linked to the exact point of the article which was relevant but the embed stripped the # part of the address, leaving you with lots of reading to do before reaching the part relevant to you.

Yes, that's the solution which some of us (with self-hosted sites) have had to adopt but it should be added that IPS has strongly advised against doing this, expressing that this is tampering with core files, could cause problems, and is not something that their support team would assist with. In other words, if your site runs into problems and they notice you've done this, you're on your own.

Not the name of the app itself, unfortunately. Forums is /forums, even if you change /topic etc.

The Forums app will open at /forums.

Is it enough to simply remove Stripe as a payment method, Mark? I'm asking because our Stripe account is tied to another colleague's phone for 2FA (she's administration and finance, so this is her area, whereas development etc falls to me), so now that I'm trying to log in at 23:10, having just become aware that people are being charged referrals from our test installation, I can't access Stripe to get the alternative keys.

I can't help with your other questions but I know that {{shuffle($rows);}} works with database categories when ordering records randomly. You might be able to adapt that for $records rather than $rows.

Both the Apache server (2.4.43) and WampServer are using PHP 7.3. That said, I can see that the server has 5.6 as its default PHP setting and I've adjusted it manually for my sites, so I'd better change it. I think I'm going to experiment with using alternatives to WampServer too.