requinix

On the common parlance side of things, typically "index" emphases that it's related to searching while "key" refers to it being an identifier for a record. Like, if your table has a user ID key then it should also have a user ID index.

That's so Hufflepuff.

Apparently CPanel has something to help you out with that part.

According to the opcache.revalidate_freq setting, your server is only looking for changes to PHP scripts once every minute. I think that is a reasonable amount of time. Can you do your development and testing locally instead? That really is a good practice to learn, and you should be doing it regardless of this caching thing.

Making a simple Marker is pretty simple. Check out the documentation and get just one marker on the map. It doesn't need to be real data. You can even hardcode the location. Get the basic marker there, then perhaps also work with the settings to customize it to look the way you want. Then add the popup tooltip functionality to it. Again, hardcode the information. Work with it, customize it, etc. Separate from that is getting the GPS data onto the page in a useful way. Do you have the map set up on the page yet? Where you want, how you want it? I don't see it in that index.php page...

Take a look at the syntax highlighting of the code you posted. In the first few lines, some of the highlighting is wrong. Can you see why?

A new line being the thing that is created when you hit Enter on your keyboard. Like I just did right now.

Sounds good to me. Assuming you want multiple categories applied to each blog post, that is.

Have you written the Javascript code necessary to add one marker to the map?

Bad news: no, the configuration I was thinking of has since been removed so it can't do what I thought it might have been doing. Good news: I found what I'll do for the next April Fool's Day prank. I have seen issues with quote blocks on other IPB 4 sites. And I do what Barand says: add a newline and move the quote above it.

Can you post/link to your phpinfo()?

Back up. What issues with unique indexes?

$(document).ready(function(){ became function added(){ Right? You modified that line at the beginning of the code to turn it into a function. Did you also take a look at the end of the code to see if that needed anything modified too?

If you're asking how it's done, typically either position:sticky or position:fixed. CSS.

I see you changed the beginning of the code to be a named function. Did you change the end of the code to match?

Okay. How about you write it, then come back and say what it is? Because like I said, depending on what it is, you may not need the subquery.

You might not need a subquery. Depends what that "too complicated" query was. So just let us see it.

Eh, it's BBCode parsing. IPB doesn't want people doing that anymore. But I'll see if maybe something happened during one of our upgrades - some configuration getting screwed up, something like that. That aside, please don't use quotes for code. You don't need to emphasize what line something else. Just say it. The little bit you gain from pointing out a particular line isn't enough to lose out on the monospace and syntax highlighting.

Screenshot of the post submit textbox thing before you submit it?

But what if the article doesn't even exist? How can you tell the user it's a premium article when you haven't actually looked for the article? I didn't miss it, I just don't see what additional information it's contributing. You said you want to go through this entitlement process to determine if the article is free, and I said that's a dumb.

I know. Psycho knows. api.drupal.org knows.

Irrelevant for free articles. Irrelevant for free articles. Irrelevant for free articles (because they're viewable by everyone). You shouldn't have to run a query just to see if the article is free: didn't you already run a query to look it up in the first place? The solution about setting up some situation with entitlements and something about outer joins? Let me turn that around on you: what's wrong with my solution?

When in doubt, check the documentation.

Thoughts? My thoughts are why you're making this so complicated. If the article is free then the article is free. Entitlements has nothing to do with it. Completely and totally irrelevant.

Your question is how to handle an article being free. Your answer is to set up some sort of free membership plan, then add the articles to that plan, and either put everybody into that plan so they have some sort of dual membership thing or to add the free articles to every membership plan that exists. My answer is to mark the article as free.