AppGini Community Forums

Code: Select all

<?php
	/* change these to configure the script */
	$table_to_monitor = "tablename";
	$primary_key_field = "id";
	$condition_for_changing_ownership = "fieldname=0";
	$new_owner_group_id = 3;
	$new_owner_username = "test_user";
	/* end of configuration */


	$currDir=dirname(__FILE__);
	require("$currDir/incCommon.php");
	
	$res = sql("select
			`$table_to_monitor`.`$primary_key_field`
		from
			`$table_to_monitor` left join
			membership_userrecords mu on (mu.tableName='$table_to_monitor' and mu.pkValue=`$table_to_monitor`.`$primary_key_field`)
		where ($condition_for_changing_ownership) and mu.memberID!='$new_owner_username' limit 100", $eo);
	
	$records = array();
	while($row = mysql_fetch_row($res)){
		$records[] = $row[0];
	}

	if(count($records)){
		$records_cs = implode(',', $records);
		sql("update membership_userrecords set memberID='$new_owner_username', groupID='$new_owner_group_id' where tableName='$table_to_monitor' and pkValue in ($records_cs)", $eo);
	}