Special Rights for Different Users

You can use BeforeProcessRowList event for this purpose.
Set $row["1editable"] variable to true for those records you want to be editable:
The following code snippet makes editable all records on the list page starting with number 5.

You can use this function to apply your logic.

You can use BeforeProcessRowList event for this purpose.

<img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=21440&image=1&table=forumreplies' class='bbc_emoticon' alt=':(' /> Sorry I forget to mention that I uses PHPRunner V. 3.1

Dieter,
in this case you need to modify generated code manually.
I think upgrading to PHPRunner 4.1 is not a bad idea after all.

Dieter,

Is there nothing I can do with this code ?
function AfterSuccessfulLogin()

{

global $conn $strSQL $a;
$str="select berechtigungen from _User where Name='".$_SESSION["UserID"]."'";

$rs=db_query($str,$conn);

$data=db_fetch_array($rs);
$_SESSION["Berechtigungen"]=$data["berechtigungen"];

$a = explode (",",$_SESSION["Berechtigungen"]);
//now in Array $a there are the ID´s which I also use for OwnerID. Perhaps I can now do something with this eg.
if (in_array($_SESSION["OwnerID"],$a))
{
do something...
}
}
... but I don't know what to do ?
Perhaps anyone has an Idea for a workaround?
Thanks Dieter.

modify generated code manually

how ?
I've no Idea.
Dieter

Dieter.
not really sure what is your question here.

What are you trying to do ?

Please clarify.

Dieter.

I try to explain it more clearly.
1st Table: (_Location) with Street, Town, phonenumber, locationID

This Table is Mastertable with locationID

2nd Table: (_members) with Name, Forename, Age, profession, membersID, locationID (from location)

This ist Detailstable

3rd Table: (-users) for the rights with Name, password, ID, GroupID, locationID, rights (in this field I can write locationID´s)

4th Table: (_group) with groupname (admin, normal user), ID
From 1st and second Table I´ve built a tableview for the different Groups to edit or view.
A user can edit his own members, can see the others (comes with OwnerID = locationID)

I want to have some users they can add and edit his own members and some other members from specified locations sored in the field rights.
I hope I explained it understandable. <img src='https://asprunner.com/forums/file.php?topicimage=1&fieldname=reply&id=21516&image=1&table=forumreplies' class='bbc_emoticon' alt=':unsure:' />
Dieter.

Sorry I forgot,
In the Moment the normal user can add,edit,delete his own members (from his location)

Admin can add edit delete all members from all locations.
Dieter

Dieter,
I see what you saying.

Here is what you can do.
Save your users.rights field contents in some session variable in After successfulLogin event.

I.e.

$_SESSION["rights"]=$data["rights"];

Build the pages and modify CheckSecurity function in generated include/commonfunctions.phpfile.

Here is the snippet you need to modify there:

if($strTableName=="members")

add checking of $strValue against $_SESSION["rights"] there.
Also you'll need to add some code to Before record updated/added events to avoid writting of user's LocationID to members.LocationID field.