Announcement

Collapse
No announcement yet.

Field Priming

Collapse
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • Field Priming

    I need to implement field priming. This is pretty simple - just need to add OperatorID to every record saved in a database.
    Another words every table (have about 80 tables) has a field called OperatorID. I plan to implement LOGIN App to read OperatorID, then it will be stored in a Global Variable.

    I have few questions regarding this:
    - where is the best place to prime every record with the operatorID (which event)
    - how to deal with Concurence Checking ? (2 userrs access the sdame record)
    - is the GlobalVariable the same as Session Variable ?
    - how/where to clear OperatorID on user Exit ?

    Arthur
    -----------------------------------------
    Arthur Klisiewicz
    dATA POINT SOFTWARE
    www.datapointsoftware.com

  • #2
    You already have a security application's native SC? If yes, so...

    - where is the best place to prime every record with the operatorID (which event)

    In the event the application MENU go onValidateSuccess, here you will put operatorID as "Global"

    - how to deal with Concurence Checking ? (2 userrs access the sdame record)

    The Self Scriptcase controls that natively ...

    - is the GlobalVariable the same as Session Variable ?

    Yes, for this you have to set it as a session variable

    - how/where to clear OperatorID on user Exit ?

    Application security Scriptcase already have this native control!

    Comment


    • #3
      thanks for nice reply Fred
      my App should work with Joomla so the question is how can I read sessionID ver from Joomla ?
      Art
      -----------------------------------------
      Arthur Klisiewicz
      dATA POINT SOFTWARE
      www.datapointsoftware.com

      Comment


      • #4
        I believe there is "plugins" SC for Joomla. And he already has this control session between them. I can not give you a sure because I have not worked with this integration SC x Jomla.

        Comment


        • #5
          Originally posted by FredKeyster View Post
          I believe there is "plugins" SC for Joomla. And he already has this control session between them. I can not give you a sure because I have not worked with this integration SC x Jomla.
          I integrate my SC apps with E107 CMS and I guess with Joomla you need to do something similar. You need the variable send by Joomla, which can be done by letting your application run in an IFrame within the Joomla environment. In the url you need to use the Joomla system variable. It might be that the Joomla plugin does this for you for E107 I just modified an existing plugin to do so. Hope this helps.
          Albert Drent
          aducom software netherlands
          scriptcase partner, reseller, support and (turn-key) development
          www.scriptcase.eu / www.scriptcase.nl

          Comment


          • #6
            Yes I could yse iFrame plugin, but this would limit me to have the project run within a single page, and also put a frames around the App so it could not be easily handled as far as resizing windows/grids/forms etc.
            Also existing iGrame plugin does not allow pass session variables.
            I bought jScriptcase extension. It works fine, but it cannot pass the user ID or any type of Joomla validation onfo into SC App.

            I wonder is somebody has ever developed a encrypting/decrypting MD5 algorithm in SC that would eventually work in Joomla. This would completely resolve the user validation, so SC App could then read/compare Joomla USERS tables.

            Arthur
            -----------------------------------------
            Arthur Klisiewicz
            dATA POINT SOFTWARE
            www.datapointsoftware.com

            Comment


            • #7
              I'm not a Joomla guru, I work with E107.But it's fairly simple to access the user tables in the database. Encrypting MD5 is a simple PHP statement, decrypting is not possible. (nor necessary). But if your SC application needs to use the security tables in Joomla or apply to the user tables in Joomla you can do that directly. I do so in E107, don't think it will be much different in Joomla. I had to modify the IFrame plugin in E107 to allow passing some data. Also I got rid of the frame around the iframe as this is just a property in the IFrame statement. But it was not out of the box.
              Last edited by aducom; 10-26-2013, 09:04 AM.
              Albert Drent
              aducom software netherlands
              scriptcase partner, reseller, support and (turn-key) development
              www.scriptcase.eu / www.scriptcase.nl

              Comment


              • #8
                Originally posted by aka View Post
                I wonder is somebody has ever developed a encrypting/decrypting MD5 algorithm in SC that would eventually work in Joomla.
                I am surprised that you sometimes ask things that you easy can answer with a little self initiative ...:

                PHP Code:
                $password 'test';
                $salt     'e77pswZc2REOvQQBkCgk5iPslV6oPF6N';
                $crypt    '66fa078f3dade8e4c88fe28854b08e6b';

                if ( 
                md5$password $salt) == $crypt)
                {    
                    echo 
                "Joomla: Password is ok.";
                }    
                else
                {    
                    echo 
                "Joomla: Password wrong!";


                HTH.
                Best regards: - Reinhard -

                I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                Comment


                • #9
                  the reason I have asked this is because I'm not a PHP coder, and know very little about PHP.
                  If I knew PHP I would not buy SC ;-)

                  I looked into Joomla users table and the pasword looks something like this:

                  c7656dca12af21ee941874864842df78:7WHJw595WTwdFnBcd 4yovjirUKGWZJLM

                  so how do I extract $salt and $crypt from that, to make a comparison ?
                  shall I go by number of characters or any other method ?

                  Arthur
                  -----------------------------------------
                  Arthur Klisiewicz
                  dATA POINT SOFTWARE
                  www.datapointsoftware.com

                  Comment


                  • #10
                    yes I see not problem updating USERS table in Joomla except the password field.
                    AFAIK Scriptcase has a function to work with MD5 so I need to know how can I use it

                    Arthur
                    -----------------------------------------
                    Arthur Klisiewicz
                    dATA POINT SOFTWARE
                    www.datapointsoftware.com

                    Comment


                    • #11
                      Originally posted by aka View Post
                      AFAIK Scriptcase has a function to work with MD5 so I need to know how can I use it
                      http://lmgtfy.com/?q=php+md5
                      Best regards: - Reinhard -

                      I use ScriptCase 8 Enterprise Edition, Version 8.(latest)

                      Comment

                      Working...
                      X