Field Priming

Applications Forms
#1

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

#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!

#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

#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.

#5

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.

#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

#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.

#8

I am surprised that you sometimes ask things that you easy can answer with a little self initiative …:


$password = 'test';
$salt     = 'e77pswZc2REOvQQBkCgk5iPslV6oPF6N';
$crypt    = '66fa078f3dade8e4c88fe28854b08e6b';

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

HTH.

#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 :wink:

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

c7656dca12af21ee941874864842df78:7WHJw595WTwdFnBcd4yovjirUKGWZJLM

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

#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

#11

[QUOTE=aka;19014]AFAIK Scriptcase has a function to work with MD5 so I need to know how can I use it
[/QUOTE]

http://lmgtfy.com/?q=php+md5