Hi who to echo if datatime is not present ?

$programareTodayQ = $db->query("SELECT * FROM programare WHERE pro_data = ?",array($maine));
$usersHour = $programareTodayQ->results();
$maineCount = $programareTodayQ->count();

here if = ????

Hello!

I ask for a lot of help and do my best to help out, so here is my projects built off of US:

I designed a templates page for the company I work for as we handle Customer Service inquiries via phone, chat and email. The chats and email templates were in word documents before, so I dumped them into a DB and made it into the original templates page, way back when, which had a lot of security vulnerabilities and used mySQLi integration instead of PDO. I finally converted it here about 3 weeks ago to this:
http://screencloud.net/v/qJQlf

That is the landing page which has public "headers" and private ones which are assigned by permission level.

You can get to this page by having an existing session which lasts for 7 days or you hit the landing page:
http://screencloud.net/v/bOkZC

Guest access redirects you to the index page with a ?marker=YOURNAMEHERE value, or you can register which I try to prompt users to do. The landing page uses modals for the guest, login and register forms to avoid redirects.

As always I structure my permissions by extra pages or permissions, no 2 levels have access to the same pages. Everyone has the CSR level and the remainder have permissions as required:
http://screencloud.net/v/Euuqn

I added a stats section to my admin page to keep track of common variables I store in my logs table:
http://screencloud.net/v/23wyq

And my "New Settings" section from admin_panels.php in the includes to accommodate for changes I made to the system:
http://screencloud.net/v/CPDFy

My Manager pages are done with Tiles:
http://screencloud.net/v/AGB8v

I use these sections to manage templates, requests, crons logs and user templates.

In my templates manager I integrated an inline editor include auto-open next field which is used for sort editing only:
http://screencloud.net/v/zEPJ6

My Request Manager handles templates addition, edit and removal requests:
http://screencloud.net/v/p18Pk

When you use the function button on this screen you can see the details on the request:
http://screencloud.net/v/CLgdt

We have my system logs page which can be filtered by User Modal or by Data Type Modal:
http://screencloud.net/v/pcVCE
http://screencloud.net/v/58BHC
http://screencloud.net/v/aSL0g

The Data Type only includes data that is excluded from the logs as they are in large quantities (copies, tabs, etc - these are used for reporting purposes).

We then have my recently created cron manager:
http://screencloud.net/v/bdDEz

I setup cron files and the cron.php file runs daily at 4am local time which pulls from the db to include the appropriate files. This page allows me to disable crons for manual run only, remove them, edit the information, etc. This is great so I don't have to manually edit the cron file everytime.

And last but not least, I have my user_templates manager which users can add, edit, and remove their OWN templates in their own header that only they have access to and other users cannot see. They can enable or disable this header on their templates page. This is great for the users who do extra tasks that others do not, and for those who want to modify part of the templates but is not an edit every user wants.

Then we have my reports tiles which are designed off of tables and chart.js charts:
http://screencloud.net/v/fhNEc

This gives me crazy insights on my system including hourly, daily, weekly and monthly reports, user reports and many other awesome insights that I expand daily.

I will post my other US project tomorrow when I get back to my desk since my shift is over lol!

Thanks again @mudmin / @Dan for this awesome system to work with!

Hi Dan,
I would like to know if is possible do pagination in a grip using UserSpice resources.
Thanks

In my toolbar I have a "Scripts" tab and an "Admin scripts" tab and I wanted to know how I can have the "Admin scripts" tab not show up if I'm logged in as a normal user.

Thanks

Here's a quick walkthrough of one of my userspice projects. US runs the ATM and does all the audio processing and game monitoring.

https://www.youtube.com/watch?v=ZraPSROP3E4

Behind the scenes
https://www.youtube.com/watch?v=8acOH6GUI6k

Function

Hello.

As I'm new, I'm still learning what I can about userspice. I haven't found anything that addresses this subject.

Issue: I've noticed in my log a constant logging of certain IPs and did some research and noticed they are the search engine web crawlers. I'd like the log to omit entries of known bots (google, amazon, etc.)

Thoughts: I was thinking of exploring the tomfool php file and support files to see if I could put an exception in but before hand, was interested in seeing if any others have done this already. Another thought is to explore code in the htaccess files in select directories to block bots from scanning those directories.

Your thoughts? Thank you for any insight you can provide on this. I just dont want my log bloated with bot hits.

JDM

I have manged to achieve the spacing (padding) I want at the top of my page, via my own CSS file. I am loading the bootstrap.min.css first and then my own CSS. I have added a padding-top of 60{3bc1fe685386cc4c3ab89a3f76566d8931e181ad17f08aed9ad73b30bf28114d} to the body to adjust the content below the navigation in my CSS. However, when the screen size is reduced where the menu collapses, the content moves back up under the navbar.

What am I missing here? Where can I adjust this?

I have a table that contains, id and pcnumber.

I can add new entries to the DB fine however want to replicate the array delete similar to removing users / permission groups etc by selecting check boxes. I thought this would be as easy as copying what in the admin_users.php and amending the deleteUsers function however can't seem to make it work.

I can see there is a deletebyId class however I'm not sure how to make this work / if this would be a better approach.

In the source code when the page is loaded, the correct ID is shown in each checkbox field, corresponding to the correct it / pcnumber; however this breaks when I try to put the [count] part in although i wasn't sure if this was needed given the correct IDs are already being returned.

Kind of minimal information but but hopefully outlines what I'm trying to achieve.

Any help appreciated,

Thanks

Hi folks, what do I need to make a form like master / detail (2 tables) in Us 4.2 ? Which required packages I need to load in a new form ?
Thanks everybody