David Linnard

Some SQL for pulling out usernames and last login dates from the db, most recent first… All users (from any user group) SELECT user_id, email, login, FROM_UNIXTIME(last_visit_timestamp) FROM ezuser JOIN ezuservisit ON (ezuser.contentobject_id=ezuservisit.user_id) ORDER BY last_visit_timestamp DESC From a specific user group You’ll need to update the path_identification_string in the inner query with the user [...]

The ezinfo module provides useful information about your eZ Publish build. Unfortunately though, by default, it provides a public view for any user to view information about your eZ Publish version, and about any extensions you have installed (visit yoursite/ezinfo/about). Although as a developer this is useful it really is less than ideal that this [...]

When writing admin based modules in your extensions, the menu.ini is essential for creating the tab you need to access your functionality. This functionality is easy to utilise. There are also a number of settings which make it appear straightforward to create your own .ini based left menu, unfortunately though this is not the case. The [...]

Adding your own tabs and content to the CMS is essential for some extensions you build. This enables you to isolate functionality for authorised users and embed this functionality into the back office they are familiar with. This tutorial will cover the basics for creating CMS based views and modules which you can use as [...]

For a previous article I covered the various ways you can export user data using eZ Publish. In the article, I suggested how you can export all users who have logged in over the previous month using an extended attribute filter. In this article I will cover creating several different Extended Attribute Filters so you [...]

For all commercial sites I have worked on in eZ Publish, no site has had a useful error page, despite the fact that using template overrides makes it so straightforward. In this post I will demonstrate how easy it is, showing how a custom 404 page for your site can be made. Our final page [...]

This is the second part of this tutorial to demonstrate how you can access and extract user information from your eZ Publish database using PHP. Part One of the tutorial provided ways to extract individual users and demonstrated how to display all of the user information. It also demonstrated some of the built in ways [...]

There are specific cases where you need to pull the eZ Publish information directly in your PHP scripts. There are options available for both users and nodes. There is already an excellent article about doing this here. This guide extends this by providing a detailed guide to extracting User Information through a script and going [...]

In a previous post, I discussed how to use standard PHP functions within eZ Publish Templates. This article demonstrates how to use custom functions instead using custom Template Operators. What is a Template Operator? Template operators are the standard tags you use in the templates of eZ Publish, for example, the following are all template operators (a [...]