Services

By: Isolution Technologies  09-12-2011

  • SELECT *
      FROM jos_session
      WHERE session_id = 'b1vr7lp1456mvo51pt5v2o1820'

  • DELETE
      FROM jos_session
      WHERE( time < '1321517004')

  • SELECT *
      FROM jos_session
      WHERE session_id = 'b1vr7lp1456mvo51pt5v2o1820'

  • UPDATE `jos_session`
      SET`time`='1321524204',`userid`='0',`usertype`='',`username`='',`gid`='0',`guest`='1',`client_id`='0',`data`='__default|a:8:{s:15:\"session.counter\";i:5;s:19:\"session.timer.start\";i:1321524191;s:18:\"session.timer.last\";i:1321524198;s:17:\"session.timer.now\";i:1321524202;s:22:\"session.client.browser\";s:38:\"CatchBot/1.0; +http://www.catchbot.com\";s:8:\"registry\";O:9:\"JRegistry\":3:{s:17:\"_defaultNameSpace\";s:7:\"session\";s:9:\"_registry\";a:1:{s:7:\"session\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:4:\"user\";O:5:\"JUser\":19:{s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:3:\"gid\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:3:\"aid\";i:0;s:5:\"guest\";i:1;s:7:\"_params\";O:10:\"JParameter\":7:{s:4:\"_raw\";s:0:\"\";s:4:\"_xml\";N;s:9:\"_elements\";a:0:{}s:12:\"_elementPath\";a:1:{i:0;s:71:\"/home/isolutiontech/public_html/libraries/joomla/html/parameter/element\";}s:17:\"_defaultNameSpace\";s:8:\"_default\";s:9:\"_registry\";a:1:{s:8:\"_default\";a:1:{s:4:\"data\";O:8:\"stdClass\":0:{}}}s:7:\"_errors\";a:0:{}}s:9:\"_errorMsg\";N;s:7:\"_errors\";a:0:{}}s:13:\"session.token\";s:32:\"1519c6d1793cdb93f71d805e56b07e3c\";}'
      WHERE session_id='b1vr7lp1456mvo51pt5v2o1820'

  • SELECT *
      FROM jos_components
      WHERE parent = 0

  • SELECT folder AS type, element AS name, params
      FROM jos_plugins
      WHERE published >= 1
      AND access <= 0
      ORDERBY ordering

  • SELECT m.*, c.`option`AS component
      FROM jos_menu AS m
      LEFTJOIN jos_components AS c
      ON m.componentid = c.id
      WHERE m.published = 1
      ORDERBY m.sublevel, m.parent, m.ordering

  • SELECT template
      FROM jos_templates_menu
      WHERE client_id = 0
      AND(menuid = 0OR menuid = 559)
      ORDERBY menuid DESC
      LIMIT0, 1

  • SELECT a.*, u.name AS author, u.usertype, cc.title AS category, s.title AS section, CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(":", a.id, a.alias) ELSE a.id END AS slug, CASE WHEN CHAR_LENGTH(cc.alias) THEN CONCAT_WS(":", cc.id, cc.alias) ELSE cc.id END AS catslug, g.name AS groups, s.published AS sec_pub, cc.published AS cat_pub, s.access AS sec_access, cc.access AS cat_access 
      FROM jos_content AS a
      LEFTJOIN jos_categories AS cc
      ON cc.id = a.catid
      LEFTJOIN jos_sections AS s
      ON s.id = cc.section
      AND s.scope = "content"
      LEFTJOIN jos_users AS u
      ON u.id = a.created_by
      LEFTJOIN jos_groups AS g
      ON a.access = g.id
      WHERE a.id = 414
      AND(  ( a.created_by = 0)    OR  ( a.state = 1
      AND( a.publish_up = '0000-00-00 00:00:00'OR a.publish_up <= '2011-11-17 10:03:24')
      AND( a.publish_down = '0000-00-00 00:00:00'OR a.publish_down >= '2011-11-17 10:03:24')   )    OR  ( a.state = -1)  )

  • UPDATE jos_content
      SET hits = ( hits + 1)
      WHERE id='414'

  • SELECT id, title, module, position, content, showtitle, control, params
      FROM jos_modules AS m
      LEFTJOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND m.access <= 0
      AND m.client_id = 0
      AND( mm.menuid = 559OR mm.menuid = 0)
      ORDERBY position, ordering

  • SELECT parent, menutype, ordering
      FROM jos_menu
      WHERE id = 559
      LIMIT1

  • SELECT

    count

    (

    *

    )
    FROM

    jos_menu

    AS

    m

      WHERE

    menutype=

    'mainmenu'
    AND

    published=

    '1'
    AND

    access <=

    '0'
    AND

    parent=

    0
    AND

    ordering <

    4

  • Contact Isolution Technologies

    Email

    Print this page

    Other products and services from Isolution Technologies

    09-12-2011

    eCommerce Consulting

    SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published>= 1 AND access <= 0 ORDERBY ordering. SELECT template FROM jos_templates_menu WHERE client_id = 0 ANDORDERBY menuid DESC LIMIT0. SELECT parent, menutype, ordering FROM jos_menu WHERE id = 567 LIMIT1. UPDATE jos_content SET hits = WHERE id='41.


    09-12-2011

    Website Hosting and Services

    In most cases our site hosting and maintenance services are delivered as part of a close and long term relationship with the client, i.e. our support is comprehensive and is designed to deliver bespoke solutions to the client's changing needs. ISolution Technologies offers you the choice of maintenance & support services on either an hourly rate basis, or on a per job basis, or through purchase of a package of maintenance plan.


    09-12-2011

    Web Development

    SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published>= 1 AND access <= 0 ORDERBY ordering. SELECT template FROM jos_templates_menu WHERE client_id = 0 ANDORDERBY menuid DESC LIMIT0. SELECT parent, menutype, ordering FROM jos_menu WHERE id = 569 LIMIT1. UPDATE jos_content SET hits = WHERE id='407.


    09-12-2011

    Online Marketing

    SELECT folder AS type, element AS name, params FROM jos_plugins WHERE published>= 1 AND access <= 0 ORDERBY ordering. SELECT template FROM jos_templates_menu WHERE client_id = 0 ANDORDERBY menuid DESC LIMIT0. SELECT parent, menutype, ordering FROM jos_menu WHERE id = 568 LIMIT1. UPDATE jos_content SET hits = WHERE id='403.