rick

That is exactly what @BitPoet said about the aggregate functions. I'm wondering if you can view the various PW queries via Tracy as further examples while studying. It would help to see actual data being used. Applying your instructions to actual content would help with understanding how PW works internally. For example, Seeing how PW creates queries from selectors.

The author may be using a previous mysql version that did not have this option enabled by default. I was just curious because I couldn't see a instructional site/book giving you wrong information. And it doesn't matter at all whether you know what group by does. The point is that you are wanting to learn everything you can. We all can learn something new regardless of experience.

From what I understand, you are attempting to group the resulting data by a column that is not unique; There are two entries of 222, which confuses mysql because it doesn't know which one to use for the group. Why are you wanting to group results of this particular query? I understand that you are learning sql, but this example isn't the best option to learn GROUP BY. [edit] @BitPoet replied. The only concern I have is disabling a warning rather than fixing an issue. I would rather use any_value(column_name) to tell mysql to pick one.

Tracy is pretty powerful, and with that power comes a learning curve. I'm learning as I go and still have a long way to go. But you can't beat the convenience and ease of use (when you learn a feature) in debugging and testing code. [/offtopic]

I like the site. The only thing is the contrast between the text and background, eg, the menu and related pages, is not high enough for my old eyes. Otherwise, do they deliver to Texas?

Hi @Gideon So, What you ask can be done. Is it possible? Yes. What is needed? This is the kicker. Obviously it depends on your application requirements, and what you want to incorporate as 'progressive'. Take a cell phone provider application as an example. I use a top level page for the process module. Under which is a page for each cell phone provider that contains specific cell phone provider information, such as url, plan rates, etc. Under those pages are the pages for each application subscribed user that contains specific information about that user regarding that specific provider, such as password, services used, etc. Also under the process module is a history page for each user which tracks their application usage history. Cellphone Process Module - ATT -- User A Provider page - Verizon -- User A Provider page -- User B Provider page - Sprint -- User B Provider page - History -- User A History page -- User B History page This allows me to have a template for each provider, and a template for each user of that provider. Making changes to each template is relatively simple to reflect those changes in your code. I don't use cookies to track usage simply because it won't be available if the user changes devices. You could however use cookies as a temporary storage and write the data to the history page on each user selection. You can get very complicated very quickly tracking user history so I would start off simple at first. What article/image/ad was displayed at what time. Did the user click any creative? If so, at what time? Did the user page through the complete article or stop mid-way? etc. There are many utilities available to provide a smooth UI experience, but I don't use many of them simply because it is not worth the data load to me. That is entirely up to you as to how fancy looking you want to make the UI. I tend to use javascript only to ensure the user doesn't submit a form more than once, provide initial validation, etc. This is a simplistic answer, but I hope it gives you food for thought.

Should that be and (&&) rather than or (||)?

@ryan Call your insurance agent to file a claim. Wind driven rain is covered under base policies. Make sure you photograph everything for the adjuster. Even if the initial claim doesn't cover your deductible, you can file a subsequent claim (same policy/claim number) to cover any future damage (highly likely) without incurring another deductible.

This feature sounds like it would be a prime candidate to add to the admin on steroids module.

That too

Just an old saying, like keep it simple.

Hi @Antonio Iorio, Regarding where to place your ads, is dependant on the ad itself. For example, a creative with wide dimensions doesn't fit in a sidebar. When I wrote the ad manager plugin fo wp many years ago, I referenced the IAB Standards for ad sizes. In your screenshot you will notice a Leaderboard 728x90 type ad. This ad is designed to display in one of three locations (I used the term zone in my plugin). This banner should be placed in the header and or footer of your page, or even between two separate sections of body content. The <script> section of your screenshot is apparently how altervista wants you to include the ads. You would simply edit your PW templates and include that script at the location you want the ad to appear. You repeat that process for all the ads you want to present. One note of caution. While ads can be a good means to generate a small income, you should use them sparingly. No user wants to weed through a bunch of ads in order to continue reading your content. So I would keep with the old axiom, less is more. I hope this helps. Let us know if you have any further questions.

Hi Antonio, and welcome to the forum. With regard to incorporating altervista advertising, I did not see any reference (I don't speak Italian) regarding any form of advertising options for their hosted members. I did notice they have a support forum link at the bottom of the page. I would ask your advertising question there. Once you have the necessary information you can ask here how best to include that information. Regarding your css and php file changes, you usually need to clear any cached data in your browser before you see any changes.

Thanks @flydev, I know this will be very helpful to others as well!

Don't worry about whether you are a coder or not. This community is full of people that are glad to help you with whatever issues you may have. We just need more information to do so. Post the code you have to work with and someone here will be along shortly to help you get it sorted.

Hi @Roych, I'm not quite sure I understand. When you say you have a field for redirecting if necessary, what does necessary mean? And a non-clickable link is just text. Can you expand your requirements further so I understand exactly what you are trying to accomplish please? Maybe a screen shot of a similar interface?

Here is a good read.

I have VSCode as well, but haven't used it since I purchased a license for storm. There are some UML plugins, such as this one available in the marketplace. I haven't used any of these, so I can't vouch for which is best.

Hi @SamC, One thing I find that helps me understand and better structure any classes I attempt to create is a UML tool. Personally, I learn best when I am shown how to do something and a UML diagram is the next best thing to having someone standing over my shoulder. If you are using PhpStorm, you can read about the UML feature here.

I wrote an ad sponsor plugin for wp many moons ago. I thought of porting it to PW as my first project, but quickly realized I didn't know squat about PW so it wound up on the shelf. If anyone is interested in taking on a project like this I'd be more than happy to send you the source to the original plugin and answer any questions about ad/sponsor management.

To me it's a preference. For example, in user registration I use this structure: if( $input->post('register') == '1' ) { // is our form submitted if($session->CSRF->hasValidToken()) { // is it our form if( $input->post->text('g-recaptcha-response') == '' ) { // are they beast or human $regError = "Invalid Captcha response."; } else { $regEmail = $input->post->email( 'regEmail' ); if( $users->get( "email=$regEmail" )->id ) { $regError = "You cannot register more than one account with the same email address."; } else { ... } } } else { header("Status: 401", true, 401); } } Since php does a short circuit test, it stops evaluating conditionals as soon as a value is known. So it doesn't really matter, unless you get into nesting elseif or use switch statements. Whatever code style reads best for you and your team is how you should do it. Just my $.02

Searching by, site:processwire.com/talk/ processwire ide yields a number of recent topics and various tips.

Depending on the theme, it can a lot more work trying to remove all the wp junk from a theme than it would be to create a similar theme from scratch using whatever front-end style you want, such as bootstrap, etc. Personally, I have not found a wp theme worth that time. There are many good theme (templates) where you could put your time to better use. See this thread for some great options.

Yes. Yes, it is. And the longer any organization is put off the mightier that task becomes.

I am calling d($result) from the console panel. I have a saved snippet that I refer to often. The result is appended to the admin page and doesn't display in any panel I have found. I would keep the ajax panel functioning as you have overridden. Maybe the manual clear option is best. The ajax panel does increase vertically. It doesn't appear to stop at the view port top, though. The same with the console panel. I have to clear the result on the console panel for it to resize back down where i can close it. But I am not concerned about that. One pilot error at a time. Edit: We can take this offline to PM if you wish. I hate clogging up this thread with my stuff.