Support

Support Options

Report a problem

Dorothy Grabowski

Mobile Development for mBanking

Mobile Development for mBanking

Smartphones have heralded an era of high mobility. As a result, the computing devices have become tiny and the human life is running at a fast pace. Earlier, the internet witnessed the same boom and changed the scenario by offering a variety of services. For instance, people had to go to banks for operating their accounts or making any kind of transaction. The internet helped in reducing this traffic. Further, with the introduction of mobiles, it brought a wave with an increased number of ATMs, reducing the cubic feet of banks. The newer method modernized the bank system to be complied with mBanking.
Today, the mobile development companies have a queue lined up for several bank projects. Previously, many of these companies were web designing companies and therefore, inherited all the concepts of web designing and applied them to the mobile development. Let’s look into some instances for a better clarity.

Picker or Spinner:

In many mobile interfaces, you will find drop-down menus especially when you transfer money from checking (current) account to the saving account. It also displays Fill Amount and Verification fields. If you click on the drop-down menu on the web, you can view a list of accounts with the code and amount. However, the same translates awfully in mobiles as iPhone shows only 3 full and 2 partial choices with its standard picker control. On the other hand, Android shows 8 options using the spinner overlay. For a 20 accounts holder, the bank seems helpless.

As a mobile development company what will you offer the mobile developers? To create a better experience and increase google play store keywords, we can adopt another design pattern. Let’s find out in detail.

Table View (Dedicated Selection Page):

iOS developer guidelines consider using a table view instead of a picker for displaying a large number of values. An extended table view offers easy scrolling. Like this, you can consider other advantages too. For instance, use of any font for branding, utilize full width of the page, wrap the text as you wish, etc. For mBanking, the form page is little altered. Usually, you can go straight from account to Fill Amount and then to Verification. However, with each step, you will have to visit a dedicated page to make selection and then move ahead. Thus, the process becomes quite long. It may be bearable for filling small forms but is not a good option for larger forms.

Wizard Flow with Form:

To cut down many steps, you can use a wizard flow. You can start with a dedicated page, make selections and then come to the main form to enter the amount and verification code. Just four steps! This pattern can be called the best due to optional fields, multiple input fields, etc. Easy editing is the major benefit out of all. In case of a mistake, you just need to repeat the whole process, correct the input field and move ahead. This gives you a smooth flow and a better user experience.

This reveals that the mobile development is quite different from that of desktop. You should just not copy the web experiences at all and apply them in the mobile development.

  1. applications
  2. commerce
  3. development
  4. ios

Comments on this entry

  1. Walker James

    Mobile development companies doing their best to get high rank in the market. The 7 dollar essay did research on it and they find some common factors for it.

    Reply Report abuse

    Replying to Walker James

Add a comment

Please keep comments relevant to this entry.

Line breaks and paragraphs are automatically converted. URLs (starting with http://) or email addresses will automatically be linked.

Debug Console

Close31 MBRequestSessionTimelineDatabase87Events52
$_GET
Array( ) Array(

)
$_POST
Array( ) Array(

)
$_COOKIE
Array( ) Array(

)
$_SERVER
Array( USER => apache, HOME => /var/www, FCGI_ROLE => RESPONDER, REDIRECT_SCRIPT_URL => /... Array(
USER => apache,
HOME => /var/www,
FCGI_ROLE => RESPONDER,
REDIRECT_SCRIPT_URL => /members/1198/blog/2019/02/mobile-development-for-mbanking,
REDIRECT_SCRIPT_URI => https://ecologyplus.esa.org/members/1198/blog/2019/02/mobile-development-for-mbanking,
REDIRECT_HTTPS => on,
REDIRECT_SSL_TLS_SNI => ecologyplus.esa.org,
REDIRECT_STATUS => 200,
SCRIPT_URL => /members/1198/blog/2019/02/mobile-development-for-mbanking,
SCRIPT_URI => https://ecologyplus.esa.org/members/1198/blog/2019/02/mobile-development-for-mbanking,
HTTPS => on,
SSL_TLS_SNI => ecologyplus.esa.org,
HTTP_USER_AGENT => CCBot/2.0 (https://commoncrawl.org/faq/),
HTTP_ACCEPT => text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8,
HTTP_ACCEPT_LANGUAGE => en-US,en;q=0.5,
HTTP_HOST => ecologyplus.esa.org,
HTTP_CONNECTION => Keep-Alive,
HTTP_ACCEPT_ENCODING => gzip,
PATH => /sbin:/usr/sbin:/bin:/usr/bin,
SERVER_SIGNATURE => ,
SERVER_SOFTWARE => Apache/2.2.15 (Red Hat),
SERVER_NAME => ecologyplus.esa.org,
SERVER_ADDR => 10.111.213.60,
SERVER_PORT => 443,
REMOTE_ADDR => 54.196.116.3,
DOCUMENT_ROOT => /var/www/ecologyplus,
SERVER_ADMIN => root@localhost,
SCRIPT_FILENAME => /var/www/ecologyplus/index.php,
REMOTE_PORT => 37038,
REDIRECT_URL => /members/1198/blog/2019/02/mobile-development-for-mbanking,
GATEWAY_INTERFACE => CGI/1.1,
SERVER_PROTOCOL => HTTP/1.1,
REQUEST_METHOD => GET,
QUERY_STRING => ,
REQUEST_URI => /members/1198/blog/2019/02/mobile-development-for-mbanking,
SCRIPT_NAME => /index.php,
PHP_SELF => /index.php,
REQUEST_TIME_FLOAT => 1563315882.8444,
REQUEST_TIME => 1563315882
)
separator .
orderBy id
orderDir asc
1 registerIP
2 access
always
renew
tracker.sid 9444482c83a0f2d8decdb3e0263e3547
tracker.ssid 9444482c83a0f2d8decdb3e0263e3547
tracker.rsid 9444482c83a0f2d8decdb3e0263e3547
session.token a113afed44e0037569062a0a337d347d
  • site 0.105 seconds (+0.105); 9.25 MB (+9.250) - afterInitialise
  • site 0.168 seconds (+0.063); 11.00 MB (+1.750) - afterRoute
  • site 0.960 seconds (+0.792); 28.25 MB (+17.250) - afterDispatch
  • site 0.979 seconds (+0.019); 28.50 MB (+0.250) - beforeRenderModule mod_custom (Hub Footer)
  • site 0.984 seconds (+0.004); 28.50 MB (0.000) - afterRenderModule mod_custom (Hub Footer)
  • site 0.984 seconds (+0.001); 28.50 MB (0.000) - beforeRenderModule mod_collect (Collect)
  • site 0.988 seconds (+0.003); 28.75 MB (+0.250) - afterRenderModule mod_collect (Collect)
  • site 0.988 seconds (+0.000); 28.75 MB (0.000) - beforeRenderModule mod_featured (Aggregated Content)
  • site 1.011 seconds (+0.024); 29.50 MB (+0.750) - afterRenderModule mod_featured (Aggregated Content)
  • site 1.012 seconds (+0.000); 29.50 MB (0.000) - beforeRenderModule mod_custom (Career Planning Tools)
  • site 1.013 seconds (+0.001); 29.50 MB (0.000) - afterRenderModule mod_custom (Career Planning Tools)
  • site 1.013 seconds (+0.000); 29.50 MB (0.000) - beforeRenderModule mod_menu (Main Menu)
  • site 1.026 seconds (+0.013); 29.75 MB (+0.250) - afterRenderModule mod_menu (Main Menu)
  • site 1.026 seconds (+0.000); 29.75 MB (0.000) - beforeRenderModule mod_custom (Application Form)
  • site 1.027 seconds (+0.001); 29.75 MB (0.000) - afterRenderModule mod_custom (Application Form)
  • site 1.027 seconds (+0.000); 29.75 MB (0.000) - beforeRenderModule mod_search (Search)
  • site 1.031 seconds (+0.004); 30.00 MB (+0.250) - afterRenderModule mod_search (Search)
  • site 1.031 seconds (+0.000); 30.00 MB (0.000) - beforeRenderModule mod_reportproblems (Trouble Report)
  • site 1.068 seconds (+0.037); 30.75 MB (+0.750) - afterRenderModule mod_reportproblems (Trouble Report)
  • site 1.077 seconds (+0.009); 31.00 MB (+0.250) - onAfterRender
  • site 1.081 seconds (+0.004); 31.00 MB (0.000) - sessionStore
31 MB

87 Queries Logged: 0.095325708389282 seconds

  1. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '018322e29fa6bcf035be43ef62be6afa'
  2. DELETE
      FROM`jos_session`
      WHERE `session_id` = '018322e29fa6bcf035be43ef62be6afa'
  3. SELECT data
      FROM `jos_session`
      WHERE `session_id` = '9444482c83a0f2d8decdb3e0263e3547'
  4. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  5. SELECT session_id
      FROM `jos_session`
      WHERE `session_id` = '9444482c83a0f2d8decdb3e0263e3547'
      LIMIT 1
  6. INSERT INTO `jos_session` (`session_id`,`client_id`,`time`,`ip`)
      VALUES ('9444482c83a0f2d8decdb3e0263e3547','0','1563315882','54.196.116.3')
  7. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_members'
  8. SELECT b.id
      FROM `jos_usergroups` AS `a`
      LEFT JOIN jos_usergroups AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`id` = '1'
  9. SELECT *
      FROM `jos_viewlevels`
  10. SELECT folder AS type,element AS name,protected,params
      FROM `jos_extensions`
      WHERE `enabled` >= '1'
      AND `type` = 'plugin'
      AND `state` >= '0'
      AND `access` IN ('1','1','4')
      ORDER BY `ordering` ASC
  11. SELECT m.id,m.menutype,m.title,m.alias,m.note,m.path AS route,m.link,m.type,m.level,m.language,m.browserNav,m.access,m.params,m.home,m.img,m.template_style_id,m.component_id,m.parent_id,e.element AS component
      FROM `jos_menu` AS `m`
      LEFT JOIN jos_extensions AS e
      ON e.extension_id = m.component_id
      WHERE `m`.`published` = '1'
      AND `m`.`parent_id` > '0'
      AND `m`.`client_id` = '0'
      ORDER BY `m`.`lft` ASC
  12. SELECT jos_template_styles.id,jos_template_styles.home,jos_template_styles.template,jos_template_styles.params,jos_extensions.protected
      FROM `jos_template_styles`
      INNER JOIN jos_extensions
      ON jos_extensions.element = jos_template_styles.template
      WHERE `jos_template_styles`.`client_id` = '0'
      AND `jos_extensions`.`enabled` = '1'
      AND `jos_extensions`.`type` = 'template'
      AND jos_extensions.`client_id` = `jos_template_styles`.`client_id`
      AND `jos_template_styles`.`id` = '15'
      ORDER BY `home` DESC
  13. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_tags'
  14. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1198'
  15. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_resources'
  16. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_projects'
  17. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_jobs'
  18. SHOW FULL COLUMNS
      FROM `jos_jobs_employers`
  19. SELECT a.rules
      FROM `jos_assets` AS `a`
      WHERE `a`.`id` = '1'
      GROUP BY a.id, a.rules, a.lft
  20. SELECT b.rules
      FROM `jos_assets` AS `a`
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE `a`.`name` = 'com_members.component'
      GROUP BY b.id, b.rules, b.lft
      ORDER BY `b`.`lft` ASC
  21. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`parent_id` = '0'
  22. SELECT *
      FROM `jos_assets`
      WHERE `jos_assets`.`id` = '1'
  23. SELECT e.id
      FROM jos_jobs_employers AS e JOIN jos_users_points_subscriptions AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2019-07-16 22:24:43'
  24. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_blog'
  25. SELECT *
      FROM `jos_plugin_params`
      WHERE `jos_plugin_params`.`object_id` = '1198'
      AND `jos_plugin_params`.`folder` = '0'
      AND `jos_plugin_params`.`element` = '0'
  26. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`alias` = 'mobile-development-for-mbanking'
      AND `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1198'
  27. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1198'
  28. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '32'
      AND `jos_blog_comments`.`state` IN ('1','3')
  29. SELECT jos_tags_object.label,jos_tags.*
      FROM `jos_tags`
      INNER JOIN jos_tags_object
      ON jos_tags_object.tagid = jos_tags.id
      WHERE `jos_tags_object`.`tbl` = 'blog'
      AND `jos_tags_object`.`objectid` = '32'
      AND `jos_tags`.`admin` = '0'
      GROUP BY jos_tags.id
  30. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1198'
      AND (`jos_blog_entries`.`publish_up` = '0000-00-00 00:00:00' OR `jos_blog_entries`.`publish_up` <= '2019-07-16 22:24:43' )
      AND (`jos_blog_entries`.`publish_down` = '0000-00-00 00:00:00' OR `jos_blog_entries`.`publish_down` >= '2019-07-16 22:24:43' )
      ORDER BY `hits` DESC
      LIMIT 5
  31. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('1198')
  32. SELECT id,entry_id
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`entry_id` IN ('32')
  33. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '1198'
  34. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '32'
      AND `jos_blog_comments`.`state` IN ('1','3')
      AND `jos_blog_comments`.`parent` = '0'
      ORDER BY `created` ASC
  35. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` IN ('1244')
  36. SELECT *
      FROM `jos_xprofiles`
      WHERE uidNumber = '1244';
  37. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_support'
  38. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`parent` = '79'
      AND `jos_blog_comments`.`entry_id` = '32'
      AND `jos_blog_comments`.`state` IN ('1','3')
      ORDER BY `created` ASC
  39. SELECT *
      FROM `jos_users`
      WHERE `jos_users`.`id` = '0'
  40. SELECT *
      FROM `jos_user_profiles`
      WHERE `jos_user_profiles`.`user_id` = NULL
  41. SELECT *
      FROM `jos_blog_comments`
      WHERE `jos_blog_comments`.`entry_id` = '32'
      AND `jos_blog_comments`.`id` = '0'
      AND `jos_blog_comments`.`state` IN ('1','3')
  42. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  43. SELECT *
      FROM `jos_blog_entries`
      WHERE `jos_blog_entries`.`scope` = 'member'
      AND `jos_blog_entries`.`scope_id` = '1198'
      AND `jos_blog_entries`.`state` = '1'
      AND `jos_blog_entries`.`access` IN ('1','1','4')
      AND (`jos_blog_entries`.`publish_up` = '0000-00-00 00:00:00' OR `jos_blog_entries`.`publish_up` <= '2019-07-16 22:24:43' )
      AND (`jos_blog_entries`.`publish_down` = '0000-00-00 00:00:00' OR `jos_blog_entries`.`publish_down` >= '2019-07-16 22:24:43' )
  44. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_collections'
  45. SHOW FULL COLUMNS
      FROM `jos_collections`
  46. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.object_id='1198'
      AND b.object_type='member'
  47. SELECT COUNT(DISTINCT b.id)
      FROM jos_collections AS b
      INNER JOIN `jos_collections_items` AS im
      ON im.type='collection'
      AND im.object_id=b.id
      LEFT JOIN `jos_collections_following` AS f
      ON f.following_type='collection'
      AND f.following_id=b.id
      WHERE b.state='1'
      AND b.access='0'
      AND b.object_id='1198'
      AND b.object_type='member'
  48. SELECT *
      FROM `jos_resource_types`
      WHERE `jos_resource_types`.`category` = '27'
      ORDER BY `type` ASC
  49. SELECT COUNT(jos_resources.id) AS count
      FROM `jos_resources`
      LEFT JOIN jos_author_assoc
      ON jos_author_assoc.subid = jos_resources.id
      WHERE `jos_resources`.`standalone` = '1'
      AND `jos_resources`.`published` IN ('1')
      AND `jos_author_assoc`.`subtable` = 'resources'
      AND `jos_author_assoc`.`authorid` = '1198'
      AND `jos_author_assoc`.`role` != 'submitter'
      AND `jos_resources`.`access` IN ('0','3')
  50. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wiki'
  51. SELECT *
      FROM `jos_wiki_versions`
      WHERE `jos_wiki_versions`.`created_by` = '1198'
      AND `jos_wiki_versions`.`approved` = '1'
      GROUP BY page_id
  52. SELECT COUNT(jos_wiki_pages.id) AS count
      FROM `jos_wiki_pages`
      WHERE `jos_wiki_pages`.`state` = '1'
      AND `jos_wiki_pages`.`scope` = 'site'
      AND `jos_wiki_pages`.`id` IN ('')
  53. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_courses'
  54. SHOW FULL COLUMNS
      FROM `jos_courses`
  55. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE m.user_id=1198
      AND m.student=0
      AND r.alias='instructor'
      AND c.state=1
  56. SHOW FULL COLUMNS
      FROM `jos_courses_offerings`
  57. SHOW FULL COLUMNS
      FROM `jos_courses_roles`
  58. SELECT r.*, (SELECT COUNT(m.user_id)
      FROM jos_courses_members AS m
      WHERE m.role_id=r.id
      AND m.`offering_id` IN (0,0)) AS total
      FROM jos_courses_roles AS r
      WHERE r.`offering_id` IN (0,0)
  59. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=1198
      AND m.student=0
      AND r.alias='instructor'
  60. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state IN (1, 3)
      AND m.user_id=1198
      AND m.student=0
      AND r.alias='manager'
  61. SELECT COUNT(*)
      FROM `jos_courses` AS c JOIN `jos_courses_members` AS m
      ON m.course_id=c.id
      LEFT JOIN `jos_courses_offerings` AS o
      ON o.id=m.offering_id
      LEFT JOIN `jos_courses_offering_sections` AS s
      on s.id=m.section_id
      LEFT JOIN `jos_courses_roles` AS r
      ON r.id=m.role_id
      WHERE c.state=1
      AND m.user_id=1198
      AND m.student=1
      AND (s.publish_down='0000-00-00 00:00:00' OR s.publish_down < '2019-07-16 22:24:43')
      AND s.state=1
      AND o.state=1
  62. SELECT *
      FROM `jos_xgroups_inviteemails`
      WHERE `jos_xgroups_inviteemails`.`email` = 'Catelp1@protonmail.com'
  63. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_applicants` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_members` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_managers` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.logo, g.created, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM `jos_xgroups` AS g, `jos_xgroups_invitees` AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 )
  64. SELECT COUNT(jos_xmessage_recipient.id) AS count
      FROM `jos_xmessage_recipient`
      INNER JOIN jos_xmessage
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      LEFT JOIN jos_xmessage_seen
      ON jos_xmessage_seen.mid=jos_xmessage.id
      AND jos_xmessage_seen.uid=1198
      WHERE `jos_xmessage_recipient`.`uid` = '1198'
      AND `jos_xmessage_recipient`.`state` = '0'
  65. SELECT COUNT(jos_xmessage.id) AS count
      FROM `jos_xmessage`
      INNER JOIN jos_xmessage_recipient
      ON jos_xmessage.id = jos_xmessage_recipient.mid
      WHERE `jos_xmessage_recipient`.`uid` = '1198'
      AND `jos_xmessage_recipient`.`state` != '2'
      AND jos_xmessage.id NOT IN (SELECT s.mid
      FROM `jos_xmessage_seen` AS s
      WHERE s.uid=1198)
  66. SHOW FULL COLUMNS
      FROM `jos_projects`
  67. SELECT count(DISTINCT p.id)
      FROM jos_projects AS p
      LEFT JOIN jos_project_owners AS o
      ON o.projectid=p.id
      AND o.userid='1198'
      AND o.userid != 0
      AND p.state!= 2 JOIN jos_users as x
      ON x.id=p.owned_by_user
      LEFT JOIN jos_xgroups as g
      ON g.gidNumber=p.owned_by_group
      WHERE (o.userid='1198'
      AND o.status!=2
      AND p.state NOT IN (2, 3)
      AND ((p.setup_stage >= '2') OR (o.role = 1
      AND p.owned_by_user='1198')))
      AND p.provisioned = 0
  68. SHOW FULL COLUMNS
      FROM `jos_project_owners`
  69. SELECT p.alias, p.title, o.*
      FROM jos_project_owners AS o
      INNER JOIN `jos_projects` AS p
      ON p.id=o.projectid
      WHERE o.userid=0
      AND o.status=0
      AND o.invited_email='Catelp1@protonmail.com'
  70. SELECT e.id
      FROM jos_jobs_employers AS e JOIN jos_users_points_subscriptions AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2019-07-16 22:24:43'
  71. SELECT e.id
      FROM jos_jobs_employers AS e JOIN jos_users_points_subscriptions AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2019-07-16 22:24:43'
  72. SELECT e.id
      FROM jos_jobs_employers AS e JOIN jos_users_points_subscriptions AS s
      ON s.id=e.subscriptionid
      AND s.uid=e.uid
      WHERE e.uid = '0'
      AND s.status=1
      AND s.expires > '2019-07-16 22:24:43'
  73. SELECT COUNT(jos_activity_recipients.id) AS count
      FROM `jos_activity_recipients`
      WHERE `jos_activity_recipients`.`scope` = 'user'
      AND `jos_activity_recipients`.`scope_id` = '1198'
      AND `jos_activity_recipients`.`state` = '1'
      AND `jos_activity_recipients`.`viewed` = '0000-00-00 00:00:00'
  74. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=0 )
  75. ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '0' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_applicants AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_members AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '1' AS registered, '1' AS regconfirmed, '1' AS manager
      FROM jos_xgroups AS g, jos_xgroups_managers AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 ) UNION ( SELECT g.gidNumber, g.published, g.approved, g.cn, g.description, g.join_policy, '0' AS registered, '1' AS regconfirmed, '0' AS manager
      FROM jos_xgroups AS g, jos_xgroups_invitees AS m
      WHERE (g.type='1' OR g.type='3')
      AND m.gidNumber=g.gidNumber
      AND m.uidNumber=1198 )
  76. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_search'
  77. SELECT m.id,m.title,m.module,m.position,m.content,m.showtitle,m.params,mm.menuid,e.protected
      FROM `jos_modules` AS `m`
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      LEFT JOIN jos_extensions AS e
      ON e.element = m.module
      AND e.client_id = m.client_id
      WHERE `m`.`published` = '1'
      AND `e`.`enabled` = '1'
      AND (`m`.`publish_up` = '0000-00-00 00:00:00' OR `m`.`publish_up` <= '2019-07-16 22:24:43' )
      AND (`m`.`publish_down` = '0000-00-00 00:00:00' OR `m`.`publish_down` >= '2019-07-16 22:24:43' )
      AND `m`.`access` IN ('1','1','4')
      AND `m`.`client_id` = '0'
      AND (`mm`.`menuid` = '83' OR `mm`.`menuid` <= '0' )
      ORDER BY `m`.`position` ASC,`m`.`ordering` ASC
  78. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_aggregator'
  79. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_applications'
  80. SELECT *
      FROM `jos_applications_fields`
      WHERE `jos_applications_fields`.`name` IN ('interests')
  81. SELECT *
      FROM `jos_applications`
      WHERE `jos_applications`.`created_by` = '0'
      AND `jos_applications`.`state` != '2'
      LIMIT 1
  82. SELECT DISTINCT jos_aggregator_posts.*
      FROM `jos_aggregator_posts`
      WHERE `jos_aggregator_posts`.`state` = '1'
      AND `jos_aggregator_posts`.`access` IN ('1','1','4')
      ORDER BY `jos_aggregator_posts`.`created` DESC
      LIMIT 5
  83. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  84. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_kb'
  85. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_answers'
  86. SELECT extension_id AS id,element AS "option",params,enabled
      FROM `jos_extensions`
      WHERE `type` = 'component'
      AND `element` = 'com_wishlist'
  87. UPDATE `jos_session`
      SET `data` = '__default|a:10:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1563315882;s:18:\"session.timer.last\";i:1563315882;s:17:\"session.timer.now\";i:1563315882;s:8:\"registry\";O:23:\"Hubzero\\Config\\Registry\":2:{s:7:\"\0*\0data\";O:8:\"stdClass\":2:{s:1:\"0\";s:7:\"session\";s:10:\"Components\";O:8:\"stdClass\":2:{s:4:\"Blog\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:7:\"Comment\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:7:\"created\";s:8:\"orderdir\";s:3:\"asc\";}}}s:9:\"Resources\";O:8:\"stdClass\":1:{s:6:\"Models\";O:8:\"stdClass\":1:{s:4:\"Type\";O:8:\"stdClass\":2:{s:7:\"orderby\";s:4:\"type\";s:8:\"orderdir\";s:3:\"asc\";}}}}}s:9:\"separator\";s:1:\".\";}s:4:\"user\";C:17:\"Hubzero\\User\\User\":22:{a:1:{s:5:\"guest\";b:1;}}s:11:\"tracker.sid\";s:32:\"9444482c83a0f2d8decdb3e0263e3547\";s:12:\"tracker.ssid\";s:32:\"9444482c83a0f2d8decdb3e0263e3547\";s:12:\"tracker.rsid\";s:32:\"9444482c83a0f2d8decdb3e0263e3547\";s:13:\"session.token\";s:32:\"a113afed44e0037569062a0a337d347d\";}',`time` = '1563315884',`ip` = '54.196.116.3'
      WHERE `session_id` = '9444482c83a0f2d8decdb3e0263e3547'
  • onAfterInitialise Method plgSystemP3p::onAfterInitialise /core/plugins/system/p3p/p3p.php:45
  • onAfterInitialise Method plgSystemRemember::onAfterInitialise /core/plugins/system/remember/remember.php:44
  • onAfterInitialise Method plgSystemHubzero::onAfterInitialise /core/plugins/system/hubzero/hubzero.php:46
  • onAfterInitialise Method plgSystemXFeed::onAfterInitialise /core/plugins/system/xfeed/xfeed.php:46
  • onAfterInitialise Method plgSystemSupergroup::onAfterInitialise /core/plugins/system/supergroup/supergroup.php:138
  • onAfterRoute Method plgSystemJquery::onAfterRoute /core/plugins/system/jquery/jquery.php:46
  • onAfterRoute Method plgSystemSpamjail::onAfterRoute /core/plugins/system/spamjail/spamjail.php:46
  • onAfterRoute Method plgSystemIncomplete::onAfterRoute /core/plugins/system/incomplete/incomplete.php:46
  • onAfterRoute Method plgSystemUnconfirmed::onAfterRoute /core/plugins/system/unconfirmed/unconfirmed.php:46
  • onAfterRoute Method plgSystemUnapproved::onAfterRoute /core/plugins/system/unapproved/unapproved.php:46
  • onAfterRoute Method plgSystemPassword::onAfterRoute /core/plugins/system/password/password.php:46
  • onMembersAreas Method plgMembersDashboard::onMembersAreas /core/plugins/members/dashboard/dashboard.php:87
  • onMembersAreas Method plgMembersProfile::onMembersAreas /core/plugins/members/profile/profile.php:55
  • onMembersAreas Method plgMembersAccount::onMembersAreas /core/plugins/members/account/account.php:59
  • onMembersAreas Method plgMembersBlog::onMembersAreas /core/plugins/members/blog/blog.php:55
  • onMembersAreas Method plgMembersCollections::onMembersAreas /core/plugins/members/collections/collections.php:55
  • onMembersAreas Method plgMembersContributions::onMembersAreas /core/plugins/members/contributions/contributions.php:55
  • onMembersAreas Method plgMembersCourses::onMembersAreas /core/plugins/members/courses/courses.php:55
  • onMembersAreas Method plgMembersGroups::onMembersAreas /core/plugins/members/groups/groups.php:55
  • onMembersAreas Method plgMembersMessages::onMembersAreas /core/plugins/members/messages/messages.php:55
  • onMembersAreas Method plgMembersProjects::onMembersAreas /core/plugins/members/projects/projects.php:71
  • onMembersAreas Method plgMembersResume::onMembersAreas /core/plugins/members/resume/resume.php:85
  • onMembersAreas Method plgMembersActivity::onMembersAreas /core/plugins/members/activity/activity.php:54
  • onMembersAreas Method plgMembersCareeractivity::onMembersAreas /app/plugins/members/careeractivity/careeractivity.php:61
  • onContentPrepare Method plgContentEmailcloak::onContentPrepare /core/plugins/content/emailcloak/emailcloak.php:49
  • onContentPrepare Method plgContentPagebreak::onContentPrepare /core/plugins/content/pagebreak/pagebreak.php:59
  • onContentPrepare Method plgContentXhubtags::onContentPrepare /core/plugins/content/xhubtags/xhubtags.php:50
  • onContentPrepare Method plgContentFormatwiki::onContentPrepare /core/plugins/content/formatwiki/formatwiki.php:88
  • onContentPrepare Method plgContentFormathtml::onContentPrepare /core/plugins/content/formathtml/formathtml.php:130
  • onBlogView Method plgBlogOpengraph::onBlogView /core/plugins/blog/opengraph/opengraph.php:44
  • onBlogView Method plgBlogTwitter::onBlogView /core/plugins/blog/twitter/twitter.php:44
  • onMembersContributionsAreas Method plgMembersResources::onMembersContributionsAreas /core/plugins/members/resources/resources.php:88
  • onMembersContributionsAreas Method plgMembersWiki::onMembersContributionsAreas /core/plugins/members/wiki/wiki.php:53
  • onMembersContributionsAreas Method plgMembersCourses::onMembersContributionsAreas /core/plugins/members/courses/courses.php:379
  • onMembersContributions Method plgMembersResources::onMembersContributions /core/plugins/members/resources/resources.php:142
  • onMembersContributions Method plgMembersWiki::onMembersContributions /core/plugins/members/wiki/wiki.php:90
  • onMembersContributions Method plgMembersCourses::onMembersContributions /core/plugins/members/courses/courses.php:417
  • onMembers Method plgMembersDashboard::onMembers /core/plugins/members/dashboard/dashboard.php:113
  • onMembers Method plgMembersProfile::onMembers /core/plugins/members/profile/profile.php:75
  • onMembers Method plgMembersAccount::onMembers /core/plugins/members/account/account.php:85
  • onMembers Method plgMembersBlog::onMembers /core/plugins/members/blog/blog.php:75
  • onMembers Method plgMembersCollections::onMembers /core/plugins/members/collections/collections.php:75
  • onMembers Method plgMembersContributions::onMembers /core/plugins/members/contributions/contributions.php:75
  • onMembers Method plgMembersCourses::onMembers /core/plugins/members/courses/courses.php:78
  • onMembers Method plgMembersGroups::onMembers /core/plugins/members/groups/groups.php:81
  • onMembers Method plgMembersMessages::onMembers /core/plugins/members/messages/messages.php:81
  • onMembers Method plgMembersProjects::onMembers /core/plugins/members/projects/projects.php:96
  • onMembers Method plgMembersResume::onMembers /core/plugins/members/resume/resume.php:185
  • onMembers Method plgMembersActivity::onMembers /core/plugins/members/activity/activity.php:78
  • onMembers Method plgMembersCareeractivity::onMembers /app/plugins/members/careeractivity/careeractivity.php:125
  • onAfterDispatch Method plgSystemDebug::onAfterDispatch /core/plugins/system/debug/debug.php:87
  • onAfterRender Method plgSystemSef::onAfterRender /core/plugins/system/sef/sef.php:45