kaniagostyn *UKS Kania Gostyń

Auto Gordian Knot 1.72 - kopiarka DVD [info]. najnowsza stabilna wersja; AutoGK

(Auto Gordian Knot) 2.20 stable
[ http://www.free-code...load/AutoGK.htm ]

na stronie znajdziesz również;
VIDEO CODECS
FFDShow MPEG-4
DivX 6.0.2
Koepi's XviD Codec
DivX Free
Stinky's MPEG-2
OggDS / OGM Codec
Nic's XviD Codec
Ligos Indeo Codec

AUDIO CODECS
MPEG Layer-3 Codec
AC3 Filter
AC-3 Decompressor
CoreVorbis Decoder
Vorbis Ogg ACM Codec
LAME MP3 Encoder
Monkey's Audio
LAME ACM MP3 Codec

CODEC PACKS
XP Codec Pack
Codec Pack All in 1
K-Lite Codec Pack
Matroska Pack
Lazy Man's MKV Pack
The Codecs
K-Lite Mega Codec
G. Knot Codec Pack

TOOLS
Real Alternative
QuickTime Alternative
WinAVI Converter
GSpot
Media Player Classic
VLC (VideoLAN Client)
Winamp
XVid;-) Player

Yii 1.0.5 is released. Dear Yii Folks,

We are proud to announce the release of Yii Framework v1.0.5!

In this release, we included nearly thirty feature enhancements and a dozen of bug fixes. Some of the major feature enhancements are summarized as follows.

We made several significant improvements to the ActiveRecord (AR) feature in Yii. We implemented named scopes (thanks to Ruby on Rails for its inspiration) in AR, which allows us to write snappy and chainable queries like Post::model()->published()->recently()->findAll(). We further improved the lazy loading feature of AR by supporting on-the-fly query options. We also added support for using Oracle with AR, thanks to our community member Ricardo for his generous contribution.

We enhanced the URL management functionality. In particular, sub-patterns can now be used in URL routes. This makes the two-way URL management (URL routing and creation) in Yii even more powerful.

While we are adding many new features, performance remains to be a central piece in Yii. In this release, we optimized the database queries used in role-based access control (RBAC). We also added support for caching the result of RBAC.

A list of all issues resolved in this release can be found at:

http://www.yiiframew...GELOG-1.0.5.txt


Cheers!


The Yii Developer Team
http://www.yiiframework.com


Extend model with new attributes and populate by join query. Hi Tommy,

the one with the relation I already had. Problem is that if you do it like that, it seems to me that you have to implement sorting on the column by yourself. And using eager or lazy loading - it will be a mess.


In your view
echo $userRecord->group->your-attribute;


What I want to do is this
echo $userRecord->group-table-attribute;

I can add the attribute to the User model, but how can I tell the model to populate it with a specific field from the data if the specific field shows up in the data?

I.e., make the attribute available through the model, if the attribute is contained in the dataset.

Perhaps there is a way to access the underlying raw query result and implement an onload event that copies it to the attribute if present.

In standard sql thinking, for this kind of problem I would create a virtual table by using a view and issue a query on this one. So the data would be put together right away. In Yii, it seems to me that I require a model for each view, and may lead to a model flood :)

Cheers,
Hein

Help with AR relationships.
Doesn't this return all Paragraphs with their related ChangeRequests? I want just the ChangeRequests that are related to an Article (via Paragraphs).

I haven't tried exactly this, but you should be able to declare a condition like this
... ->with(some-relationship=>array('condition'=>'some-condition'), ...)-> ...

BTW this is eager loading. Alternatively, for lazy loading you should be able to specify a condition and 'with' in a relationship declaration.

Edit:
See also with() in class reference.

/Tommy

Sharding.
How to deal with relational queries?

This database scaling screencast (apart from rails-specific tips) contains introductory information about sharding map techniques.

AR models should know which related data is in the same database, and in those cases one can use eager loading. Otherwise the newly introduced anti-together lazy loading option should be used.

Edit:

When multiple connections are used, how do we merge the data together when calling findAll()?

If sharding takes effect, it is developers' task to ensure that unaccessible tables are not involved (i.e. determining foreign keys before findAll).
This post has been edited by pestaa: 24 August 2009 - 11:14 AM
[Closed] Display / Log detailed SQL queries. I think my syntax is working since there is a weblog, but it does not show the complete SQL statement for all excecuted queries...

19:23:48.661820 trace system.db.CDbConnection Opening DB connection 19:23:48.690167 trace system.db.CDbCommand Querying SQL: SHOW COLUMNS FROM `User` 19:23:48.711076 trace system.db.CDbCommand Querying SQL: SHOW CREATE TABLE `User` 19:23:48.732249 trace system.db.CDbCommand Querying SQL: SHOW COLUMNS FROM `ContactsProfile` 19:23:48.744143 trace system.db.CDbCommand Querying SQL: SHOW CREATE TABLE `ContactsProfile`

May my problem is that I define the queries in the function relations():
- if I use "BELONGS_TO" I get the SQL statement
- if I use "HAS_MANY" it shows only
19:40:49.445883 trace system.db.ar.CActiveRecord lazy loading User.contactprofile

Marcus

Using "OR" in Relational Active Record. For the record, I solved this using CDbCriteria:

$dbCriteria = new CDbCriteria(); $dbCriteria->addSearchCondition('name', $model->term); $dbCriteria->addSearchCondition('field_values.value', $model->term, true, 'OR'); $results = User::model()->with('field_values')->findAll($dbCriteria);

Eagerly loading the field_values table in this case is essential because otherwise there will be problems searching in its table columns (default is lazy loading, so it won't be joined at all)