In user.php :
<?php
class User extends CActiveRecord
{
/**
* @return array relational rules.
*/
public function relations()
{
$relations = array(
'profile'=>array(self::HAS_ONE, 'Profile', 'user_id'),
'subscription'=>array(self::HAS_MANY, 'Subscription', 'id_users'),
);
if (isset(Yii::app()->getModule('user')->relations)) $relations = array_merge($relations,Yii::app()->getModule('user')->relations);
return $relations;
}
}
in Subcription.php :
<?php
/**
* This is the model class for table "{{subscription}}".
*
* The followings are the available columns in table '{{subscription}}':
* @property integer $id
* @property integer $id_users
* @property integer $subscriptionstart
* @property integer $subscriptionend
* @property string $amount
*
* The followings are the available model relations:
* @property Users $idUsers0
*/
class Subscription extends CActiveRecord
{
/**
* @return array relational rules.
*/
public function relations()
{
// NOTE: you may need to adjust the relation name and the related
// class name for the relations automatically generated below.
return array(
'idUsers0' => array(self::BELONGS_TO, 'User', 'id_users'),
);
}
}
in AdminController.php (extension yii_user)
<?php
class AdminController extends Controller
{
/**
* Manages all models.
*/
public function actionAdmin()
{
$dataProvider=new CActiveDataProvider('User', array(
'criteria'=>array(
'with'=>array('subscription'),
'together'=>true,
),
'pagination'=>array(
'pageSize'=>Yii::app()->controller->module->user_page_size,
),
//'pagination'=>array( 'pageSize'=>30),
));
$this->render('index',array(
'dataProvider'=>$dataProvider,
));
}
}
Now in index.php :
<?php
$this->breadcrumbs=array(
UserModule::t('Users')=>array('admin'),
UserModule::t('Manage'),
);
?>
<h1><?php echo UserModule::t("Manage Users"); ?></h1>
<?php echo $this->renderPartial('_menu', array(
'list'=> array(
CHtml::link(UserModule::t('Create User'),array('create')),
),
));
?>
<?php $this->widget('zii.widgets.grid.CGridView', array(
'dataProvider'=>$dataProvider,
'columns'=>array(
array(
'name' => 'id',
'type'=>'raw',
'value' => 'CHtml::link(CHtml::encode($data->id),array("admin/update","id"=>$data->id))',
),
array(
'name' => 'username',
'type'=>'raw',
'value' => 'CHtml::link(CHtml::encode($data->username),array("admin/view","id"=>$data->id))',
),
array(
'name'=>'email',
'type'=>'raw',
'value'=>'CHtml::link(CHtml::encode($data->email), "mailto:".$data->email)',
),
array(
'name' => 'createtime',
'value' => 'date("d.m.Y H:i:s",$data->createtime)',
),
array(
'name' => 'lastvisit',
'value' => '(($data->lastvisit)?date("d.m.Y H:i:s",$data->lastvisit):UserModule::t("Not visited"))',
),
array(
'name'=>'status',
'value'=>'User::itemAlias("UserStatus",$data->status)',
),
array(
'name'=>'superuser',
'value'=>'User::itemAlias("AdminStatus",$data->superuser)',
),
array(
'name' => 'subscription.subscriptionstart',
'value' => '$data->subscription->subscriptionstart',
),
array(
'class'=>'CButtonColumn',
),
),
));
?>
And i always have a problem 
Really thanks a lot antonio to take time to help me.
