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. 

21 minutes ago, DreamOn said:

It's a shame IPS doesn't provide a light app just for blog posting.

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. 

57 minutes ago, bfarber said:

You join the same table more than once with different aliases.

LEFT JOIN core_sys_lang_words as titleJoin ON ...
LEFT JOIN core_sys_lang_words as descJoin ON ...

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?  

59 minutes ago, AlfaSpaceNET said:

Thank you for helpful reply.

I found it in block.css and change to 

.ipsWidget .ipsDataItem_title {
	font-size: {fontsize="large"};

and all working charm 😇

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;
	}
}

On 10/5/2020 at 8:28 AM, Adlago said:

Add in your Custom CSS

@media screen and (max-width: 767px)
.ipsType_normal, .ipsType_medium, body {
    font-size: 17px;
}

That's not quite correct; you're missing { }:

@media screen and (max-width: 767px) {
	.ipsType_normal, .ipsType_medium, body {
    	font-size: 17px;
	}
}

30 minutes ago, Charles said:

We remove all quoted post references but then elsewhere someone was talking about John Doe in their own post. That's not PII as it's not attributed to the user but would get replaced and break a conversation.

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?

1 hour ago, PoC2 said:

Do we need to create a new custom editor button with a copy of the code, or something else?

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.

1 minute ago, breatheheavy said:

This post is... not the vibe.

There's a way to offer suggestions and offer constructive criticism versus call something "absolutely terrible" that people spent a lot of time and energy on. 

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.

55 minutes ago, Paul E. said:

You can change the root app portion of the URL by editing the furl.json file in applications/<the app you're interested in>/data/furl.json.

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.

1 hour ago, ahc said:

You can usually do it via language strings and editing the friendly url associated with the app.

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

The Forums app will open at /forums.

On 12/29/2019 at 3:37 AM, Mark said:

Yes. To put Stripe into test mode you need to use the test mode API keys from your Stripe account.

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.

31 minutes ago, Poseidon2 said:

last question : do you know any random function ? or do we have to use the rand(x,y) function from HTML ?

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.