LabTech Vitals Dashboard

On April 16, 2014, in Projects, by Cubert aka (Cube Dweller)

Today we release the next round for the Squidworks Labtech Vitals Dashboard.

The Labtech Vitals Dashboard is a set of web pages that query the local Labtech MySql database and provides visual widgets of important data on the main display of the Labtech Support Console. We currently have 17 different widgets with 10 of them having detail views.

To install the Dashboard you will need to download and install… Continue reading

Tagged with:
 

Vitals Dashboard for Labtech MSP Providers.

On October 7, 2013, in Projects, Scripting, by Cubert aka (Cube Dweller)

Squidworks Vitals Dashboard for Labtech Software

Vitals Dashboard for Labtech Software

Download SWVDB here  -> SWVDB-0.1

 

Install instructions are included in the “install.txt” file inside of zip. You will need to have PHP 5.3.27 installed on you Labtech server and can be downloaded at http://php.net

The purpose of the Vitals Dashboard is to get key… Continue reading

Tagged with:
 

PHP Pagination with timestamp / timeline display

On February 3, 2010, in How-to, Scripting, by Cubert aka (Cube Dweller)

Pagination with a timestamp as the center value

We provide a way to scroll page to page of data and show the time stamp of when the data was collected as part of the page navigations.

Here we setup the first query and findout how many pages we have.

$sql = “SELECT COUNT(*) FROM table where name = ‘” . $name . “‘ and type = ‘” Continue reading

Tagged with:
 

Howto: MySQL Full Text Search in PHP

On November 6, 2009, in How-to, Scripting, by Cubert aka (Cube Dweller)

This tutorial is intended for Text Searching using MySQL (http://www.MySQL.com/) and PHP (http://www.php.net) and will focus on the Full-text capabilities presented by MySQL.

Synopsis

We run a website that hosts web blogs, we have a database that contains blog posts. We might create a table in our database using a statement like this:

CREATE TABLE blogs (body TEXT, title VARCHAR(250), id INT NOT NULL auto_increment, PRIMARY KEY(id);
 
Tagged with: