kigkonsult logo

Now 117 362 iCalcreator
users worldwide!!

Services

kigkonsult offer professional services for software support, design and new/re-development, customizations and adaptations of PHP/MySQL solutions with focus on software lifecycle management, including long term utility, reliability and maintainability.

If you need any custom modules, modification or amendment based on iCalcreator to suit your needs or professional support, don't hesitate to contact us.


Sponsored Links
Custom Search

iCalcreator used in.. .

  • albaven
  • All-in-One Event Calendar
  • Bugscope
  • Date iCal
  • Dokeos
  • event_connect
  • ESS Feed
  • Exponent CMS
  • EQDKP Plus
  • GCalendar
  • GLPI
  • Grapevine Birmingham
  • Gumbo Millennium
  • Hypecal
  • iCal
  • iCalendar-to-Facebook-Event
  • JCal Pro
  • kitEvent
  • MarkupiCalendar
  • One Big SYSTem
  • Open Atrium
  • Repository based CMS
  • sfiCalCreatorPlugin
  • Telaen
  • terncal
  • twical
  • Virtual Loup-De-Mer
  • "Weather Forecast"
  •  
  • And many more.. .
  •  

Tell us

what iCalcreator is missing,
use the contact page

Support us

Link to our site from yours!    kigkonsult.se - iCal PHP software 

We will create a link to your site in our list of featured users!

Credits & Licenses plus

iCalcreator and the related PHP software was conceived and written by Kjell-Inge Gustafsson.

Many people have contributed, through providing questions, issues, reporting bugs and sending patches.

iCalcreator (standard) and the related PHP software are released under the LGPL  /  GPL  /  CC licences.

This site uses:
cssmenumaker 
FotoramaMIT
jQueryMIT/GPL
jQuery UIMIT/GPL
jQuery TimepickerMIT/GPL
PHPMailerLGPL
prototypeCC BY-SA
reCAPTCHA 

sLog

sLog

A mysql (5.x) log database able to log events in a single or multi system/application environment. Written completely as mysql stored procedures with a secure simple log interface using direct access to database or via a web/SOAP service.

sLog logs application and system events, tracking user, client, application, application module, operation, date and time and event/log specifics.

Logging can be done with a simple direct mysql (function) call, no coding required apart from coding database connection and call. Logging can also be done by doing http or SOAP requests, PHP examples attached.

Database structure is completely hidden from user/calling application, using a mysql user only allowed to insert log events by executing a stored procedure.

Only sLog mysql administrator can access stored events and gather statistics of user activities (who did what?) and application use and payload.

Download sLog here.

SPM

sLog Payload Monitor is a HTML/Javascript/Ajax interface used for exploring sLog (req. v0.8) information.

LOG ITEMS

ORGANISATION (*)
organisation/unit alt. internet country name/code
ORGANISATION_SPEC
organisation/unit detail text
USER (*)
Some user id, member id alt. IP-number
USER_SPEC
ex. user name alt. Internet domain
CLIENT (*)
client name, alt. Web browser.
CLIENT_SPEC
client specification:version.. ., alt. Web browser spec.
APPLICATION (*)
application/system name

SERVICE
system module/(web-)service name ex. "createCustomer"
OPERATION
Basic operation, ex. CRUD; one of "create"/"read"/'update"/"delete"
APPLICATION2 / SERVICE2 / OPERATION2
opt. parent/child relation; service/subservice
DATE
event date
TIME
event time
OBJECT NUMBER
if running more than one object instance (=application/service),
SUBJECT
Detailed header event information like query, read/update/delete id.. .
BODY
Respons, query answer, update specific..

(*) mandatory

using examples

// COMPLETE mysql call:

SELECT <database>.fslog(
"<date>",
"<time>",
"<application>",
"<service>",
"<operation>",
"<objno>",
"<application2>",
"<service2>",
"<operation2>",
"<client>",
"<clientSpec>",
"<organisation>",
"<org/unit>",
"<user>",
"<user_spec>",
"<subject>",
"<body>" )

// SIMPLE mysql call:

SELECT <database>.fslog(
"",
"",
"<application>",
"",
"",
"1",
"",
"",
"",
"<client>",
"",
"<organisation>",
"",
"<user1>",
"",
"",
"" )



Read the lastest release news here.

Copyright © 2008-2014 kigkonsult
kigkonsult Contact
Terms and Conditions
Privacy & Cookies Policy
Linking Policy