Re: ACL users permission settings

2010-05-29 Thread John Andersen
Have a look at the sample application in the CakePHP manual at:
http://book.cakephp.org/view/1543/Simple-Acl-controlled-Application

Maybe that you can use as a beginning and then expand on it?
Enjoy,
   John

On May 28, 8:28 am, ET3  wrote:
> I am developing a system where I need to set permission for users to
> access different groups. I need to build an interface in admin panel
> so that admin can set this access permission for users. Can any one
> give me some idea and some source code for this?

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: user manager system(help me)

2010-05-29 Thread John Andersen
Have a look at the CakePHP manual at:
http://book.cakephp.org/view/1543/Simple-Acl-controlled-Application

Is that not what you want? Or at least something with which you can
expand on!
Enjoy,
   John

On May 30, 7:38 am, hoss7  wrote:
> hi i am new in cakephp
> i want some user manager system(with Permission) for cakephp 1.3
>
> link 
> this:http://www.studiocanaria.com/articles/cakephp_auth_component_users_gr...
>
> i cant run this code in cakephp 1.3

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Recursive some only some associations?

2010-05-29 Thread Jeremy Burns
Here is your silver bullet: http://book.cakephp.org/view/1323/Containable

Jeremy Burns
jeremybu...@me.com


On 29 May 2010, at 13:07, Antony wrote:

> Hi all,
> 
> I have my models setup so:   Person     Item   Images
> 
> I want to be able to display a list of People and their images. I can
> do this through using recursive = 2 but it slows down the page a lot
> as there are many other associations which are not required.
> 
> I've tried playing around with bindModel/unbindModel but without any
> luck. I've also tried:
> $this->Person->recursive = 1;
> $this->Person->Item->recursive = 1;
> Which I thought might work, but doesn't.
> 
> I would really appreciate any help or advice on this!
> 
> Cheers,
> Antony
> 
> Check out the new CakePHP Questions site http://cakeqs.org and help others 
> with their CakePHP related questions.
> 
> You received this message because you are subscribed to the Google Groups 
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
> http://groups.google.com/group/cake-php?hl=en

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: helper naming convention

2010-05-29 Thread John Andersen
In your first example, the TimeLineHelper should be named TimeLine in
your helpers array in the controller!
Enjoy,
   John

On May 30, 5:58 am, Bryan Lim  wrote:
> Hi all,
>
> Can someone please tell me what did I do wrong with the naming
> convention?
>
> I named my helper time_line.php. It is called class TimeLineHelper
> extends AppHelper.
>
> At the controller, var $helpers = array("time_line");
>
> But it gives me error that TimeLineHelper is not found.
>
> So I change time_line.php to tl.php. TimeLineHelper to TlHelper.
> $helpers = array("tl");
>
> it works.
>
> I am using cakephp 1.3.
>
> Thanks!
> Bryan

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Recursive some only some associations?

2010-05-29 Thread John Andersen
Take a look at the Containable behaviour in the CakePHP manual at:
http://book.cakephp.org/view/1323/Containable

The Containable behaviour allows you to specify which related models
are to be included in the find you are making, thus speeding up the
find.
Enjoy,
   John

On May 29, 3:07 pm, Antony  wrote:
> Hi all,
>
> I have my models setup so:   Person     Item   Images
>
> I want to be able to display a list of People and their images. I can
> do this through using recursive = 2 but it slows down the page a lot
> as there are many other associations which are not required.
>
> I've tried playing around with bindModel/unbindModel but without any
> luck. I've also tried:
>  $this->Person->recursive = 1;
>  $this->Person->Item->recursive = 1;
> Which I thought might work, but doesn't.
>
> I would really appreciate any help or advice on this!
>
> Cheers,
> Antony

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Deep associations

2010-05-29 Thread Ed Propsner
By the looks of it you named your model correctly as "Items" but in your
conditions your are referencing "Item".

To find "count" ...

$this->Section->find('count' , array(
  'conditions'  => array(

'Items.user_id' => 1

)
   )
 );

- Ed

On Sun, May 30, 2010 at 12:44 AM, azv  wrote:

>
>
> I'm playing with a simple model where
>
> Section hasMany Catalogitem hasMany Item belongsTo User
>
> and naturaly the other way-
>
> User hasMany Item belongsTo Catalogitem belongsTo Section.
>
> I'm trying to get count how many items I have per section for
> user.id=1 - which is a very simple sql query (with 2 joins)-
>
> SELECT sections.id, count(*)
> FROM sections
> JOIN catalogitems ON sections.id=catalogitems.section_id
> JOIN items ON catalogitems.id=items.catalogitem_id
> WHERE user.id=1
> GROUP BY sections.id
>
> But I'm not sure how to use cake for that:
>
> $this->Section->find('all' , array( 'conditions' =>
> array('Item.user_id' => 1)) )
>
> I'm getting an error that 'Item.user_id' is an Unknown column.
>
> Can anyone shed light regarding what's the problem, and how do I get
> the find() to return a count of items per section for user.id?
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.comFor
>  more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Deep associations

2010-05-29 Thread azv


I'm playing with a simple model where

Section hasMany Catalogitem hasMany Item belongsTo User

and naturaly the other way-

User hasMany Item belongsTo Catalogitem belongsTo Section.

I'm trying to get count how many items I have per section for
user.id=1 - which is a very simple sql query (with 2 joins)-

SELECT sections.id, count(*)
FROM sections
JOIN catalogitems ON sections.id=catalogitems.section_id
JOIN items ON catalogitems.id=items.catalogitem_id
WHERE user.id=1
GROUP BY sections.id

But I'm not sure how to use cake for that:

$this->Section->find('all' , array( 'conditions' =>
array('Item.user_id' => 1)) )

I'm getting an error that 'Item.user_id' is an Unknown column.

Can anyone shed light regarding what's the problem, and how do I get
the find() to return a count of items per section for user.id?

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


user manager system(help me)

2010-05-29 Thread hoss7
hi i am new in cakephp
i want some user manager system(with Permission) for cakephp 1.3


link this:
http://www.studiocanaria.com/articles/cakephp_auth_component_users_groups_permissions

i cant run this code in cakephp 1.3

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Custom Session handler with DB issue

2010-05-29 Thread jerikschaeffer
Alright, I've racked my brain on this far too long now and want to see
if I can get another set of eyes on my code to see if I'm missing
something.

I need a custom handler for my sessions for a couple reasons:

1) My app is going between different domains, not subdomains, and
requires the referrer check to be set differently.

2) The high security setting in Cake has always given me issues with
session regeneration, so I need to set it to medium, but I want to
keep the cookie lifetime setting of 0 so cookies die after closing the
browser. Medium doesn't allow for this.

3) I need database sessions so that when my app does go back and forth
between domains, session data can be read from the DB and copied from
one session to the other on each of the domains.

Having said that, this is what I have so far (I put it in the bin to
make it easier to read):

http://bin.cakephp.org/view/263734852

I copied what I thought was everything from the cake_session.php file
in regards to database session handling to be implemented in my own
handler. Unfortunately, everytime the session starts, meaning on every
page, I'm seeing the following debug messages:

Warning (2): mysqli_real_escape_string() [function.mysqli-real-escape-
string]: Couldn't fetch mysqli [CORE/cake/libs/model/datasources/dbo/
dbo_mysqli.php, line 201]
Code | Context

$data   =   "4uenk81stnmcmuec2kk3v7lmm3"
$column =   "string"
$safe   =   false
$parent =   null

mysqli_real_escape_string - [internal], line ??
DboMysqli::value() - CORE/cake/libs/model/datasources/dbo/
dbo_mysqli.php, line 201
DboSource::__parseKey() - CORE/cake/libs/model/datasources/
dbo_source.php, line 2265
DboSource::conditionKeysToString() - CORE/cake/libs/model/datasources/
dbo_source.php, line 2207
DboSource::conditions() - CORE/cake/libs/model/datasources/
dbo_source.php, line 2087
DboSource::buildStatement() - CORE/cake/libs/model/datasources/
dbo_source.php, line 1447
DboSource::generateAssociationQuery() - CORE/cake/libs/model/
datasources/dbo_source.php, line 1240
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php,
line 810
Model::find() - CORE/cake/libs/model/model.php, line 2087
Model::exists() - CORE/cake/libs/model/model.php, line 1979
Model::save() - CORE/cake/libs/model/model.php, line 1242
CakeSession::__write() - CORE/cake/libs/cake_session.php, line 756
[main] - [internal], line ??

Warning (2): mysqli_query() [function.mysqli-query]: Couldn't fetch
mysqli [CORE/cake/libs/model/datasources/dbo/dbo_mysqli.php, line 115]
Code | Context

$sql=   "SELECT COUNT(*) AS `count` FROM `cake_sessions` AS `Session`
WHERE `Session`.`id` = ''   "

mysqli_query - [internal], line ??
DboMysqli::_execute() - CORE/cake/libs/model/datasources/dbo/
dbo_mysqli.php, line 115
DboSource::execute() - CORE/cake/libs/model/datasources/
dbo_source.php, line 250
DboSource::fetchAll() - CORE/cake/libs/model/datasources/
dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php,
line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
Model::exists() - CORE/cake/libs/model/model.php, line 1979
Model::save() - CORE/cake/libs/model/model.php, line 1242
CakeSession::__write() - CORE/cake/libs/cake_session.php, line 756
[main] - [internal], line ??

Warning (2): mysqli_errno() [function.mysqli-errno]: Couldn't fetch
mysqli [CORE/cake/libs/model/datasources/dbo/dbo_mysqli.php, line 214]
Code

mysqli_errno - [internal], line ??
DboMysqli::lastError() - CORE/cake/libs/model/datasources/dbo/
dbo_mysqli.php, line 214
DboSource::execute() - CORE/cake/libs/model/datasources/
dbo_source.php, line 254
DboSource::fetchAll() - CORE/cake/libs/model/datasources/
dbo_source.php, line 407
DboSource::read() - CORE/cake/libs/model/datasources/dbo_source.php,
line 812
Model::find() - CORE/cake/libs/model/model.php, line 2087
Model::exists() - CORE/cake/libs/model/model.php, line 1979
Model::save() - CORE/cake/libs/model/model.php, line 1242
CakeSession::__write() - CORE/cake/libs/cake_session.php, line 756
[main] - [internal], line ??

I can see that the session cookie is started properly in the browser,
but when I check the database, the session hasn't been started.
Obviously, this is in debug mode and I've used bake to build out the
db schema for cake_sessions, so that should all be setup properly.
There's got to be some other reason in my code that's causing this
breakdown. This is all using version 1.3.1. There was a custom session
handling bug in 1.3.0 that was causing my code to give a PHP fatal
error. 1.3.1 fixed that, but now I'm getting the issues outlined above
instead.

Any help would be greatly appreciated.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
ca

Re: CakePHP Gigya Social Network Plugin

2010-05-29 Thread nurvzy
Hi WebbedIT,

  I'm a fan of what gigya aims to be, and I've had a fun time
developing this plugin.  The service is free to evaluate but there is
no set expiration.  They do not advertise their fee anywhere on their
website, so I imagine they prefer to custom build their plans based on
traffic. However I do not know that for a fact.

I was hired to build a gigya plugin and my client has been nice enough
to allow me share it with the rest of the CakePHP community.

My personal Impressions of gigya are positive ones. They offer a solid
feature list for any major social network you'd want. Their api Is
well laid out and the service Is responsive.

If you're lookong for a 100% free social network plugin, I've also
developed a full featured Facebook plugin for cakephp.  It will soon
Include the new graph system.  I am in the process of developing a
similar full featured Twitter plugin I will release when its ready.

Facebook plugin example app:
Http://facebook.webtechnick.com

HTH,
Nick
On May 29, 3:44 am, WebbedIT  wrote:
> I'd be really interested in knowing more info about your plugin and
> your experiences of gigya as I am about to launch a website for
> charities/not-for-profits which I want to be fully integrated with all
> of the big Social Networks and it's a lot of work to code for each API
> (I've only managed Twitter so far, well I have facebook and then they
> released their new Graph API).
>
> My project:http://localcause.org.uk
>
> Could we have a chat sometime when it's convenient for you?  I'm in
> the UK.
>
> Thanks,
>
> Paul.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


helper naming convention

2010-05-29 Thread Bryan Lim
Hi all,


Can someone please tell me what did I do wrong with the naming
convention?

I named my helper time_line.php. It is called class TimeLineHelper
extends AppHelper.

At the controller, var $helpers = array("time_line");

But it gives me error that TimeLineHelper is not found.

So I change time_line.php to tl.php. TimeLineHelper to TlHelper.
$helpers = array("tl");

it works.

I am using cakephp 1.3.

Thanks!
Bryan

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Release: CakePHP 1.3.1

2010-05-29 Thread Sergei
Hi,

just tried 1.3.1 with one of my project (Cake 1.3). It instantly gave
me an errors on almost *every* page (see below). Removing TMP\cache
\persistent\ files doesn't help.

=
Notice (8): unserialize() [function.unserialize]: Error at offset 0 of
1661 bytes [CORE\cake\libs\cache\file.php, line 176]
Code | Context
$key=   "cake_core_file_map"
$time   =   1275179913
$cachetime  =   1275179919
$data   =   ""
unserialize - [internal], line ??
FileEngine::read() - CORE\cake\libs\cache\file.php, line 176
Cache::read() - CORE\cake\libs\cache.php, line 347
App::getInstance() - CORE\cake\libs\configure.php, line 967
App::build() - CORE\cake\libs\configure.php, line 650
Configure::__loadBootstrap() - CORE\cake\libs\configure.php, line 431
Configure::getInstance() - CORE\cake\libs\configure.php, line 52
include - CORE\cake\bootstrap.php, line 38
[main] - APP\webroot\index.php, line 77

Notice (8): unserialize() [function.unserialize]: Error at offset 0 of
28 bytes [CORE\cake\libs\cache\file.php, line 176]
Notice (8): unserialize() [function.unserialize]: Error at offset 0 of
5 bytes [CORE\cake\libs\cache\file.php, line 176]
Notice (8): unserialize() [function.unserialize]: Error at offset 0 of
105 bytes [CORE\cake\libs\cache\file.php, line 176]
==

On May 30, 2:29 am, mark_story  wrote:
> The CakePHP development team is happy to announce the release of
> CakePHP 1.3.1[1].  1.3.1 is the first  maintenance release for 1.3 and
> contains bugfixes and optimizations for features found in 1.3.  No new
> features will be introduced in the maintenance releases for 1.3.
> Regular maintenance releases for 1.3 are planned on a monthly basis
> for the near future.
>
> Since the release of CakePHP 1.3.0 last month, there have been more
> than 70 commits and 45 tickets resolved. There have been a few changes
> that may affect your application.
>
>  - The conditional check around including custom session configuration
> files was removed.  This fixes issues where requestAction could cause
> loss of session settings, and improves the end developers ability to
> customize the session.  Custom session files should ensure that
> classes/functions are conditionally declared.
>
>  - How virtualFields are detected and parsed was modified to allow
> virtualFields on the same table.  A virtualFieldSeparator property was
> added to DboSource to allow customization of the virtualField
> separator.  If you have fields containing '__' you may have to modify
> this setting to avoid issues.
>
>  - EmailComponent had a number of changes made to better support ELHO
> and slow SMTP servers.
>
> Be sure to check the full changelog[2] for all changes that have
> occurred. We'd like to welcome Juan Basso[3] to the development team.
> Juan has been very active in the brazilian community and we're really
> happy to have him.  Work on the 2.0 branch continues to progress.
> Currently much of the effort is focused on getting our migration to
> PHPUnit complete. We'd like to thank the ongoing community efforts
> around the documentation.  There are now over 18,500 revisions in the
> cookbook and 4 languages now have more than 70% of the documentation
> translated.
>
> As always, thank you for helping us make a great framework and
> fantastic community.
>
> Download a packaged release [1]
> View the changelog [2]
>
> [1]http://github.com/cakephp/cakephp/downloads
> [2]http://cakephp.lighthouseapp.com/projects/42648/changelog-1-3-1
> [3]http://blog.cakephp-brasil.org/

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


custom formhelper

2010-05-29 Thread luca capra

Hi all,

Using 1.3 stable I'm trying to override some function in a custom helper 
overriding a core helper (form+html)

An example:

dojo_html.php

App::Import('Html');
class DojoHtmlHelper extends HtmlHelper {
 var $tags = array(
   'form' => '',
   'input' => '',
   ...
  );
}

dojo_form.php

App::Import('Form');
class DojoFormHelper extends FormHelper {

   var $helpers = array('Html'=>'DojoHtml','Js');

   ...some overridden functions...
}

but seems not to work.
I've found this
http://cakeqs.org/eng/questions/view/custom_functions_arguments_in_form_helper
and this (old) post
http://cakebaker.42dh.com/2008/10/18/dont-abuse-the-apphelper-to-extend-the-core-helpers/
but still can't get it...

my aim is to call $form->input with customized $tags from html helper 
and get the dojo-related code.

Can somebody help me?

Thanks in advance,
Luca

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Recursive some only some associations?

2010-05-29 Thread Antony
Hi all,

I have my models setup so:   Person     Item   Images

I want to be able to display a list of People and their images. I can
do this through using recursive = 2 but it slows down the page a lot
as there are many other associations which are not required.

I've tried playing around with bindModel/unbindModel but without any
luck. I've also tried:
 $this->Person->recursive = 1;
 $this->Person->Item->recursive = 1;
Which I thought might work, but doesn't.

I would really appreciate any help or advice on this!

Cheers,
Antony

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: HABTM Containable find('all') question

2010-05-29 Thread bradmaxs
Hi Paul,

Here in (maybe) lies the rub. There isn't an actual admirers table.
There is only a friends table. The reason I am using the admirers/
friends business is to say user A has B friends and C other users have
A as a friend.  This was based on AD7six's reply to a 2007 post:
http://groups.google.com/group/cake-php/browse_thread/thread/c8ebc2097f8aad11/fae9ec58501534e6?tvc=2&q=friend#fae9ec58501534e6.

Which is also why I set up this association.

var $hasAndBelongsToMany = array(
'friend' => array('className' => 'User',
'joinTable' => 'Friend',
'foreignKey' => 'user_id',
'associationForeignKey' => 'friend_id'
),
'admirer' => array('className' => 'User',
'joinTable' =>'Friend',
'foreignKey' => 'friend_id',
'associationForeignKey' => 'user_id')
);

I thought I had to do this because when I do a query to list MY
friends - it is possible that I made the connection (my User.id is
Friend.user_id and Friend.friend_id is the other users User.id)

AND

if they make the connection (their User.id is Friend.user_id and
Friend.friend_id is my User.id)

Then I can list both in my views and I make this a little easier for
myself by doing an array_merge of the admirer and friend output of the
original SQL statement.

This is all working amazingly except the final piece which would be
omitting anyone that has been denied by me or has denied me - because
that would just be rubbing salt in the wound:)

I guess the question is this. Can I get a condition from the joined
tables friends and admirers ('Friend.approved !=' => '-1') to happen
within the users conditions?  It seems right now that if I put that
condition within the joined tables conditions - the record (of the
denied/denier) is still showing up - however it is leaving out the
friend/admirer merged array.  If I take that condition out - then the
record still shows up now with this array:

Array
(
[0] => Array
(
[id] => 4
[created] => 2010-05-03 17:33:54
[Friend] => Array
(
[id] => 39
[user_id] => 4
[friend_id] => 29
[approved] => -1
[message] =>
[created] => 2010-05-22 12:44:05
[modified] => 2010-05-25 13:15:49
)

)

)

I hope this makes sense. I am sorry for all the text - I am just
trying to wrap my head around exactly what I AM trying to do here:)

Thanks again for all of your attention to this!

Brad



On May 29, 2:24 am, WebbedIT  wrote:
> Do you have access to PhpMyAdmin or something to run queries direct on
> your database?
>
> If so try running this SQL
>
> SELECT DISTINCT User.id, User.username FROM users AS User
> LEFT JOIN admirers AS Admirer ON (User.id = Admirer.user_id AND
> Admirer.approved IN(0,1))
> LEFT JOIN friends AS Friend ON (User.id = Friend.user_id AND
> Friend.approved IN(0,1))
>
> Can you play with the above to see if you get the expected results and
> report back to me?
>
> The idea here is to work out how we would do it without Cake then
> structure our Model::find to produce the same SQL.
>
> HTH
>
> Paul

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Release: CakePHP 1.3.1

2010-05-29 Thread mark_story
The CakePHP development team is happy to announce the release of
CakePHP 1.3.1[1].  1.3.1 is the first  maintenance release for 1.3 and
contains bugfixes and optimizations for features found in 1.3.  No new
features will be introduced in the maintenance releases for 1.3.
Regular maintenance releases for 1.3 are planned on a monthly basis
for the near future.

Since the release of CakePHP 1.3.0 last month, there have been more
than 70 commits and 45 tickets resolved. There have been a few changes
that may affect your application.

 - The conditional check around including custom session configuration
files was removed.  This fixes issues where requestAction could cause
loss of session settings, and improves the end developers ability to
customize the session.  Custom session files should ensure that
classes/functions are conditionally declared.

 - How virtualFields are detected and parsed was modified to allow
virtualFields on the same table.  A virtualFieldSeparator property was
added to DboSource to allow customization of the virtualField
separator.  If you have fields containing '__' you may have to modify
this setting to avoid issues.

 - EmailComponent had a number of changes made to better support ELHO
and slow SMTP servers.

Be sure to check the full changelog[2] for all changes that have
occurred. We'd like to welcome Juan Basso[3] to the development team.
Juan has been very active in the brazilian community and we're really
happy to have him.  Work on the 2.0 branch continues to progress.
Currently much of the effort is focused on getting our migration to
PHPUnit complete. We'd like to thank the ongoing community efforts
around the documentation.  There are now over 18,500 revisions in the
cookbook and 4 languages now have more than 70% of the documentation
translated.

As always, thank you for helping us make a great framework and
fantastic community.

Download a packaged release [1]
View the changelog [2]


[1] http://github.com/cakephp/cakephp/downloads
[2] http://cakephp.lighthouseapp.com/projects/42648/changelog-1-3-1
[3] http://blog.cakephp-brasil.org/

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Problem with database cascade relationships.

2010-05-29 Thread 朝の木
Nobody knows how to solve this problem?

I think that it is very essential.
Any help will be appreciated. I can't continue my work without it :/

Kine regards,
T.

On 28 Maj, 01:01, 朝の木  wrote:
> Here is full statement *generated by cake*. It raises sql-error:
>
> SELECT `TestProduct`.`title`, `TestType`.`description`,
> `TestProductItem`.`size`, COUNT(*) FROM `test_product_items` AS
> `TestProductItem` LEFT JOIN `test_products` AS `TestProduct` ON
> (`TestProductItem`.`test_product_id` = `TestProduct`.`id`) WHERE 1 = 1
> GROUP BY `TestProduct`.`id`, `TestProductItem`.`size` ORDER BY
> `TestProductItem`.`id` asc LIMIT 25
>
> Error:
> SQL Error: 1054: Unknown column 'TestType.description' in 'field
> list' [CORE/cake/libs/model/datasources/dbo_source.php, line 666]
>
> This is *expected* to be generated by cake, but is not:
>
> SELECT `TestProduct`.`title`, `TestType`.`description`,
> `TestProductItem`.`size`, COUNT(*) FROM `test_product_items` AS
> `TestProductItem` LEFT JOIN `test_products` AS `TestProduct` ON
> (`TestProductItem`.`test_product_id` = `TestProduct`.`id`) LEFT JOIN
> `test_types` AS `TestType` ON (`TestProduct`.`test_type_id` =
> `TestType`.`id`) WHERE 1 = 1 GROUP BY `TestProduct`.`id`,
> `TestProductItem`.`size` ORDER BY `TestProductItem`.`id` asc LIMIT 25
>
> As you can see in first sql query, only join statement for
> test_products table is generated, but no for test_types.
>
> A. Below are source files:
>
> === controllers/test_product_items_controller.php ===
>
> class TestProductItemsController extends AppController {
>         var $paginate = array(
>                 'limit' => 25,
>                 'fields' => 'TestProduct.title, TestType.description,
> TestProductItem.size, COUNT(*)',
>                 'order' => array(
>                         'TestProductItem.id' => 'asc'
>                 ),
>                 'group' => array(
>                         'TestProduct.id, TestProductItem.size'
>                 )
>         );
>
>         function index() {
>                 $this->set('testProductItems', 
> $this->paginate('TestProductItem'));
>         }
>
> }
>
> === models/test_product.php ===
>
> class TestProduct extends AppModel {
>         var $belongsTo = array('TestType');
>         var $hasMany = array('TestProductItem');
>
> }
>
> === models/test_type.php ===
>
> class TestType extends AppModel {
>         var $hasMany = array('TestProduct');
>
> }
>
> === models/test_product_item.php ===
>
> class TestProductItem extends AppModel {
>         var $belongsTo = array('TestProduct');
>
> }
>
> B. Database schema & data:
>
> CREATE TABLE `test_products` (
>   `id` int(11) NOT NULL auto_increment,
>   `title` varchar(128) NOT NULL,
>   `test_type_id` int(11) NOT NULL,
>   PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=2 ;
>
> CREATE TABLE `test_product_items` (
>   `id` int(11) NOT NULL auto_increment,
>   `test_product_id` int(11) NOT NULL,
>   `size` varchar(16) NOT NULL,
>   `sold_time` datetime default NULL,
>   PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=13 ;
>
> CREATE TABLE `test_types` (
>   `id` int(11) NOT NULL auto_increment,
>   `description` varchar(32) NOT NULL,
>   PRIMARY KEY  (`id`)
> ) ENGINE=MyISAM  DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;
>
> INSERT INTO `test_products` VALUES (1, 'Star Jeans 502', 4);
> INSERT INTO `test_product_items` VALUES (7, 1, 'S', NULL);
> INSERT INTO `test_product_items` VALUES (8, 1, 'S', NULL);
> INSERT INTO `test_product_items` VALUES (9, 1, 'S', NULL);
> INSERT INTO `test_product_items` VALUES (10, 1, 'M', NULL);
> INSERT INTO `test_product_items` VALUES (11, 1, 'M', NULL);
> INSERT INTO `test_product_items` VALUES (12, 1, 'L', NULL);
> INSERT INTO `test_types` VALUES (4, 'Trousers');
>
> Thanks in advance,
> T.
>
> On 27 Maj, 05:38, Jeremy Burns  wrote:
>
> > All of your table and field names should be lower case.
>
> > What is your full find statement? Can you post it all, not just a small 
> > piece.
>
> > Jeremy Burns
> > jeremybu...@me.com
>
> > On 27 May 2010, at 00:22, 朝の木 wrote:
>
> > > I have three models (with controllers):
> > > - Product: Id, Title, Type_id
> > > - Type: Id, Description
> > > - ProductItem: Id, Product_id, Size, Sold_time
>
> > > Relationships:
> > > - Product: belongsTo(Type), hasMany(ProductItem)
> > > - Type: hasMany(Product)
> > > - ProductItem: belongsTo(Product)
>
> > > Example:
> > > - Product:
> > >  1; 'Star Jeans 502', 4
> > >  (...)
>
> > > - Type:
> > >  4; 'Trousers'
> > >  (...)
>
> > > - ProductItem:
> > >  7; 1; 'S', NULL
> > >  8; 1; 'S', NULL
> > >  9; 1; 'S', NULL
> > >  10; 1; 'M', NULL
> > >  11; 1; 'M', NULL
> > >  12; 1; 'L', NULL
> > >  (...)
>
> > > Now, I'd like to fetch the in such way:
> > > Description, Type, Size, Count
> > > Star Jeans 502, 'Trousers', 'S', 3
> > > Star Jeans 502, 'Trousers', 'M', 2
> > > Star Jeans 502, 'Trousers', 'L', 1
>
> > > The sql query should look like this:
> > > select Product.Title

Re: The page isn't redirecting properly

2010-05-29 Thread John Andersen
Please provide more information - like which controller and which
action you are trying to access through your browser (the url). Then
show your controllers code for the corresponding action. Maybe then we
will better be able to point you somewhere :)
Enjoy,
   John

On May 29, 9:46 am, karuppu  wrote:
> Dear all,
>
> I have installed my site created in cakePHP in local environment (my
> pc) unfortunately when i run that on browser that browser is showing a
> following error message "The page isn't redirecting properly". I
> couldn't find what is the cause of this. Kindly show the way to me.
>
> Thank you

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


[LONG] 1.2.7, Application and plugin intercommunication, looking for ideas, comments, etc.

2010-05-29 Thread John Andersen
Hi all,

I have started to look into how to integrate a cart plugin and a
paypal payment plugin without having either of the plugins knowing
anything about each other as well as the application.

First I would like to hear comments and ideas on the use of the cart
plugin.

In the application, the user can reserve a featured position on the
site for one or more weeks (monday to sunday). The reservation is
shown in a calender like widget for the current year plus the upcoming
year. Each calender shows the free weeks, the taken weeks, the
reserved weeks (by the user) and the past weeks.

Each reserved week should also be added to the cart and here is where
I have some issues and certainly would be happy for any ideas and
comments on how to realize it.

As the cart is a plugin, it can't assume anything about the
application, except that the current user may be found using the Auth
component. (comments?)

So my idea was to realize the cart interface using a CartComponent,
defined in the cart plugin, but usable by the application. The
CartComponent provides the application with the methods to:
- open: Get the current cart or open a new one.
- add: Add an item to the cart.
- remove: Remove an item from the cart.
and others to come later, but first I wish to crystalize my idea :)

The CartComponent then communicates with the cart plugin using
requestAction. Thus it is not necessary for the application to know
more about the cart plugin than the interface that the CartComponent
offers. (comments?)

In order to view the cart content, the cart plugin provides a cart
element showing the content of the cart (presented below the
calenders) and providing the user with actions to remove a cart item.
These actions invokes the plugins CartController which then removes
the item from the cart.

My issue here is how do I inform the application of the need to cancel
the reservation?
1) Do I configure the cart plugin, so that it knows how to cancel the
reservation?
2) Do I configure the CartComponent, so that it knows how and the
plugins CartController can use the same CartComponent to cancel the
reservation?
3) Do you have any better/other ideas?

Cart plugin models:
CartModel
- id, user_id, state, currency_code, description, created;

CartItemModel
- id, cart_id, model_name, model_id, item_line_0, item_line_1, price,
quantity;
where model_name and model_id points back to the originating model, in
this case the application model for featured positions.

Looking forward to hear your comments,
   John

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Cakephp Sample application

2010-05-29 Thread Zaky Katalan-Ezra
http://www.ibm.com/developerworks/views/opensource/libraryview.jsp?search_by=cook+web+sites+CakePHP


On Fri, May 28, 2010 at 3:08 PM, Gopinath T.M  wrote:

> Dear friends,
>
>   Can anyone give me guide for Creating sample application and
> Explaination of View,Model and controller
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.comFor
>  more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>



-- 
Regards,
Zaky Katalan-Ezra
QA Administrator
www.IGeneriX.com
Sites.IGeneriX.com
054-7762312

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


ACL for multiple groups

2010-05-29 Thread ET5
Can any one give me some idea how I can implement ACL for Auth user
having multiple groups. Is this possible? Please give me some source
code

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: generate po files

2010-05-29 Thread Zaky Katalan-Ezra
If you use poedit you don't have to edit the po files after every code
change even if you created the initial po file by yourself.
You just need to configure poedit to reference your code folders.

On Sat, May 29, 2010 at 12:04 PM, Igurpi  wrote:

> Any idea with this issue?? :-(
>
> On May 28, 1:31 am, Igurpi  wrote:
> > I have generated my .po file using the "cake i18n extract" command in
> > the shell. But in my cakephp app, I have some translations with the
> > "__d" function: For example: "__d('admin', 'value')" where 'admin' is
> > the domain name. I expected to get an admin.po file automatically with
> > the shell function (as well as default.po), but it mixes all the
> > translations into a one file (default.po).
> > I've also tried to look into my app files using poedit, but if I
> > config to extract the key of __d function, it takes the first
> > parameter, and it should take the second one, so doesn't work. I know
> > I could generate myself a admin.po file via text editor but it's not
> > very usable, because each time a change is made, I have to edit
> > manually the file.
> > Any ideas for getting this work
> > Thanks!!!
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.comFor
>  more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>



-- 
Regards,
Zaky Katalan-Ezra
QA Administrator
www.IGeneriX.com
Sites.IGeneriX.com
054-7762312

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


using cakephp for social webapp

2010-05-29 Thread Rahul R
helo everyone ,
I am newbie to cakephp .  i am trying to implement an interaction platform
between alumnis and students of my college . i coded significantly in php
and javascript , but couldnt come up with a channel concept. where is i
have  channels for every alumni not student , so that they can be asked
various questions in that particular channels . (similar to forum but not
exactly like that) . i would be glad i f you could help me getting started
with this using cakephp.


Thanking You

Rahul

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


The page isn't redirecting properly

2010-05-29 Thread karuppu
Dear all,

I have installed my site created in cakePHP in local environment (my
pc) unfortunately when i run that on browser that browser is showing a
following error message "The page isn't redirecting properly". I
couldn't find what is the cause of this. Kindly show the way to me.

Thank you

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: CakePHP Gigya Social Network Plugin

2010-05-29 Thread Gonzalo Servat
On Sat, May 29, 2010 at 7:44 PM, WebbedIT  wrote:

> I'd be really interested in knowing more info about your plugin and
> your experiences of gigya as I am about to launch a website for
> charities/not-for-profits which I want to be fully integrated with all
> of the big Social Networks and it's a lot of work to code for each API
> (I've only managed Twitter so far, well I have facebook and then they
> released their new Graph API).
>
> My project: http://localcause.org.uk
>
> Could we have a chat sometime when it's convenient for you?  I'm in
> the UK.
>

Paul,

Looking good. Found a bug when you deny Twitter access to an account. It
shows some text saying that I've denied access, and I clicked on the
hyperlinked "LocalCause" text which had a URL similar to
http://localcause.org.uk/users/twitterConfirm?denied=, and
a nasty fatal error page came up:

*Notice* (8): Undefined variable: twitter
[*APP/controllers/users_controller.php*, line *374*]

Code

UsersController::twitterConfirm() -
APP/controllers/users_controller.php, line 374
Object::dispatchMethod() - CORE/cake/libs/object.php, line 116
Dispatcher::_invoke() - CORE/cake/dispatcher.php, line 227
Dispatcher::dispatch() - CORE/cake/dispatcher.php, line 194
[main] - APP/webroot/index.php, line 88


*Fatal error*: Call to a member function get_accountVerify_credentials() on
a non-object in */home/localcause/domains/
localcause.org.uk/public_html/app/controllers/users_controller.php* on line
*374*

- Gonzalo

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: cakephp and db2

2010-05-29 Thread leon
I can't run blog example, can anybody help me?

On May 27, 11:54 pm, leon  wrote:
> Thanks a lot for your help,
> I try this code
> $this->Post->id = $id;
> $this->set('post', $this->Post->read());
> and
> $this->set('posts', $this->Post->findById(1));
>
> but they both generate this SQL string
> SELECT Post.id, Post.title, Post.body, Post.created, Post.modified
> FROM posts AS Post   WHERE Post.id = '1'   FETCH FIRST 1 ROWS ONLY
>
> In CookBook chapter3.7.3.7 said: URL:http://book.cakephp.org/view/74/
> Complex-Find-Conditions
> Note:CakePHPwill quote the numeric values depending on the field
> type in your DB.
>
> So, I have not solved my problem yet,  Anybody know the answer ,please
> help me. I really appreciate that.
>
> On 5月27日, 下午6时36分, "Dr. Loboto"  wrote:
>
>
>
> > I think it's because you pass string '1', not integer 1 to find. Add
> > ticket athttp://cakephp.lighthouseapp.com/projects/42648-cakephp
>
> > On May 26, 3:22 pm, leon  wrote:
>
> > >CakePHPwill add two single quotes for integer in SQL string, but
> > > execute this kind of sql will cause error indb2.
>
> > > Wrong Sql string SELECT * FROM posts WHERE id = '1';
> > > Right Sql string SELECT * FROM posts WHERE id = 1;
>
> > > note:id INT UNSIGNED AUTO_INCREMENT PRIMARY KEY
>
> > > anybody know this problem, pls help me ,Thanks in advance.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: CakePHP Gigya Social Network Plugin

2010-05-29 Thread WebbedIT
I'd be really interested in knowing more info about your plugin and
your experiences of gigya as I am about to launch a website for
charities/not-for-profits which I want to be fully integrated with all
of the big Social Networks and it's a lot of work to code for each API
(I've only managed Twitter so far, well I have facebook and then they
released their new Graph API).

My project: http://localcause.org.uk

Could we have a chat sometime when it's convenient for you?  I'm in
the UK.

Thanks,

Paul.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Using one model from another

2010-05-29 Thread WebbedIT
I tend to use the following but can;t remember why I started using it
or of what benefits/disadvantages it has over Jeremy's method:

ClassRegistry::init('ModelName')->method();

I believe it is clever enough to check for existing instances of the
model if you use the call more than once in a HTTP request.

HTH

Paul.

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: HABTM Containable find('all') question

2010-05-29 Thread WebbedIT
Do you have access to PhpMyAdmin or something to run queries direct on
your database?

If so try running this SQL

SELECT DISTINCT User.id, User.username FROM users AS User
LEFT JOIN admirers AS Admirer ON (User.id = Admirer.user_id AND
Admirer.approved IN(0,1))
LEFT JOIN friends AS Friend ON (User.id = Friend.user_id AND
Friend.approved IN(0,1))

Can you play with the above to see if you get the expected results and
report back to me?

The idea here is to work out how we would do it without Cake then
structure our Model::find to produce the same SQL.

HTH

Paul

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: generate po files

2010-05-29 Thread Dilip Godhani
Po file mean what???
can u give us in details??


On Sat, May 29, 2010 at 2:34 PM, Igurpi  wrote:

> Any idea with this issue?? :-(
>
> On May 28, 1:31 am, Igurpi  wrote:
> > I have generated my .po file using the "cake i18n extract" command in
> > the shell. But in my cakephp app, I have some translations with the
> > "__d" function: For example: "__d('admin', 'value')" where 'admin' is
> > the domain name. I expected to get an admin.po file automatically with
> > the shell function (as well as default.po), but it mixes all the
> > translations into a one file (default.po).
> > I've also tried to look into my app files using poedit, but if I
> > config to extract the key of __d function, it takes the first
> > parameter, and it should take the second one, so doesn't work. I know
> > I could generate myself a admin.po file via text editor but it's not
> > very usable, because each time a change is made, I have to edit
> > manually the file.
> > Any ideas for getting this work
> > Thanks!!!
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.comFor
>  more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>



-- 
Dilip Godhani
Jr Software Developer, Entourage Solutions
e-mail: di...@entouragesolutions.com
  dilip.godh...@gmail.com
Web.: www.entouragesolutions.com
m. 9913822582

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: generate po files

2010-05-29 Thread Igurpi
Any idea with this issue?? :-(

On May 28, 1:31 am, Igurpi  wrote:
> I have generated my .po file using the "cake i18n extract" command in
> the shell. But in my cakephp app, I have some translations with the
> "__d" function: For example: "__d('admin', 'value')" where 'admin' is
> the domain name. I expected to get an admin.po file automatically with
> the shell function (as well as default.po), but it mixes all the
> translations into a one file (default.po).
> I've also tried to look into my app files using poedit, but if I
> config to extract the key of __d function, it takes the first
> parameter, and it should take the second one, so doesn't work. I know
> I could generate myself a admin.po file via text editor but it's not
> very usable, because each time a change is made, I have to edit
> manually the file.
> Any ideas for getting this work
> Thanks!!!

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Cakephp Sample application

2010-05-29 Thread AD7six


On May 29, 8:53 am, "Gopinath T.M"  wrote:
> can anyone come with me on chat.

If you would like to talk to someone in 'person' - use the irc
channel:
http://book.cakephp.org/view/9/Where-to-Get-Help

There are always lots of people around to help in there. You'll find
one way or anther your answer is always in the book.

Your sample application doesn't look like the blog tutorial's code



Where in the book did you take that from?

And finally please do not spam the group with chat invites... I just
kicked you out of the group assuming you were a spammer before
happening upon this thread. Feel free to rejoin (and not spam the
group).

AD

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Cakephp Sample application

2010-05-29 Thread Ed Propsner
8-)

On Sat, May 29, 2010 at 3:33 AM, John Andersen wrote:

> What version of CakePHP are you using? Version 1.1??
> I have no idea whether the .thtml files are valid for CakePHP version
> 1.2.x or 1.3!
> Enjoy,
>   John
>
> On May 29, 10:23 am, "Gopinath T.M"  wrote:
> > Actually i did a sample application like notes
> >
> > This Contain fields called title,description,created_date and
> > modified_date
> >
> > 1. app/views/edit.thtml
> >
> > Edit Note
> > 
> > hidden('Note/id'); ?>
> > 
> > Title:
> > input('Note/title', array('size' => '40'))?>
> > 
> > 
> > Body:
> > textarea('Note/body') ?>
> > 
> > 
> > submit('Save') ?>
> > 
> > 
> >
> > 2. app/views/index.thtml
> >
> > My Notes
> > 
> > link('Add Note', '/notes/add') ?>
> > 
> > 
> > 
> > Id
> > Title
> > Created
> > Modified
> > 
> > 
> > 
> > 
> > 
> > link($note['Note']['title'],
> > "/notes/view/{$note['Note']['id']}")?>
> > [link('Edit',
> > "/notes/edit/{$note['Note']['id']}")?>,
> > link('Delete',
> "/notes/delete/{$note['Note']['id']}",
> > null, 'Are you sure?')?>]
> > 
> >
> > 
> > 
> > 
> > 
> > 
> >
> > 3. app/views/views.thtml
> >
> > 
> > 
> > Created: 
> > 
> > 
> >
> > My problem is it doesn't getting any error.but the data doesn't
> > getting save to Database.
> [snip]
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.comFor
>  more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Cakephp Sample application

2010-05-29 Thread John Andersen
What version of CakePHP are you using? Version 1.1??
I have no idea whether the .thtml files are valid for CakePHP version
1.2.x or 1.3!
Enjoy,
   John

On May 29, 10:23 am, "Gopinath T.M"  wrote:
>     Actually i did a sample application like notes
>
>     This Contain fields called title,description,created_date and
> modified_date
>
>     1. app/views/edit.thtml
>
>     Edit Note
>     
>     hidden('Note/id'); ?>
>     
>     Title:
>     input('Note/title', array('size' => '40'))?>
>     
>     
>     Body:
>     textarea('Note/body') ?>
>     
>     
>     submit('Save') ?>
>     
>     
>
>     2. app/views/index.thtml
>
>     My Notes
>     
>     link('Add Note', '/notes/add') ?>
>     
>     
>     
>     Id
>     Title
>     Created
>     Modified
>     
>     
>     
>     
>     
>     link($note['Note']['title'],
> "/notes/view/{$note['Note']['id']}")?>
>     [link('Edit',
> "/notes/edit/{$note['Note']['id']}")?>,
>     link('Delete', "/notes/delete/{$note['Note']['id']}",
> null, 'Are you sure?')?>]
>     
>
>     
>     
>     
>     
>     
>
>     3. app/views/views.thtml
>
>     
>     
>     Created: 
>     
>     
>
> My problem is it doesn't getting any error.but the data doesn't
> getting save to Database.
[snip]

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Cakephp Sample application

2010-05-29 Thread Gopinath T.M
Actually i did a sample application like notes

This Contain fields called title,description,created_date and
modified_date

1. app/views/edit.thtml

Edit Note

hidden('Note/id'); ?>

Title:
input('Note/title', array('size' => '40'))?>


Body:
textarea('Note/body') ?>


submit('Save') ?>



2. app/views/index.thtml

My Notes

link('Add Note', '/notes/add') ?>



Id
Title
Created
Modified





link($note['Note']['title'],
"/notes/view/{$note['Note']['id']}")?>
[link('Edit',
"/notes/edit/{$note['Note']['id']}")?>,
link('Delete', "/notes/delete/{$note['Note']['id']}",
null, 'Are you sure?')?>]








3. app/views/views.thtml



Created: 



My problem is it doesn't getting any error.but the data doesn't
getting save to Database.

On Sat, May 29, 2010 at 12:29 PM, John Andersen wrote:

> Sorry, I am not available for chat.
> Please use this group, as there are others who are more "fluent" in
> CakePHP than I am.
> The more who can look at your issue, the more will be able to help.
> So give it a try, write down your issue here in the group :)
> Enjoy,
>   John
>
> On May 29, 9:54 am, "Gopinath T.M"  wrote:
> > john please send your mailid for chat. so that i can explain my
> problem
> > more closy..
> >
> > On Sat, May 29, 2010 at 12:23 PM, Gopinath T.M  >wrote:
> >
> >
> >
> > > can anyone come with me on chat.
> >
> > > On Sat, May 29, 2010 at 12:08 PM, John Andersen <
> j.andersen...@gmail.com>wrote:
> >
> > >> Please clarify what your issue is!
> > >> 1) Have you installed CakePHP?
> > >> 2) Is it in a working condition?
> > >> 3) Have you made the Blog sample application?
> > >> 4) What went wrong?
> >
> > >> We need to know what you have done and what went wrong (errors, code
> > >> snippets, other) in order to be able to help you :)
> > >> Enjoy,
> > >>   John
> >
> > >> On May 29, 9:31 am, "Gopinath T.M"  wrote:
> > >> > Actually i gone through already.But, i couldn't able to create one
> > >> sample
> > >> > application
> > >> > canyou please help in any other way.
> >
> > >> [snip]
> >
> > >> Check out the new CakePHP Questions sitehttp://cakeqs.organd help
> > >> others with their CakePHP related questions.
> >
> > >> You received this message because you are subscribed to the Google
> Groups
> > >> "CakePHP" group.
> > >> To post to this group, send email to cake-php@googlegroups.com
> > >> To unsubscribe from this group, send email to
> > >> cake-php+unsubscr...@googlegroups.com
> >For
> more options, visit this group at
> > >>http://groups.google.com/group/cake-php?hl=en
> >
> > > --
> > > Regards
> > > Gopinath T.M
> > > 9944944659
> >
> > --
> > Regards
> > Gopinath T.M
> > 9944944659
>
> Check out the new CakePHP Questions site http://cakeqs.org and help others
> with their CakePHP related questions.
>
> You received this message because you are subscribed to the Google Groups
> "CakePHP" group.
> To post to this group, send email to cake-php@googlegroups.com
> To unsubscribe from this group, send email to
> cake-php+unsubscr...@googlegroups.comFor
>  more options, visit this group at
> http://groups.google.com/group/cake-php?hl=en
>



-- 
Regards
Gopinath T.M
9944944659

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en


Re: Cakephp Sample application

2010-05-29 Thread John Andersen
Sorry, I am not available for chat.
Please use this group, as there are others who are more "fluent" in
CakePHP than I am.
The more who can look at your issue, the more will be able to help.
So give it a try, write down your issue here in the group :)
Enjoy,
   John

On May 29, 9:54 am, "Gopinath T.M"  wrote:
> john please send your mailid for chat. so that i can explain my problem
> more closy..
>
> On Sat, May 29, 2010 at 12:23 PM, Gopinath T.M wrote:
>
>
>
> > can anyone come with me on chat.
>
> > On Sat, May 29, 2010 at 12:08 PM, John Andersen 
> > wrote:
>
> >> Please clarify what your issue is!
> >> 1) Have you installed CakePHP?
> >> 2) Is it in a working condition?
> >> 3) Have you made the Blog sample application?
> >> 4) What went wrong?
>
> >> We need to know what you have done and what went wrong (errors, code
> >> snippets, other) in order to be able to help you :)
> >> Enjoy,
> >>   John
>
> >> On May 29, 9:31 am, "Gopinath T.M"  wrote:
> >> > Actually i gone through already.But, i couldn't able to create one
> >> sample
> >> > application
> >> > canyou please help in any other way.
>
> >> [snip]
>
> >> Check out the new CakePHP Questions sitehttp://cakeqs.organd help
> >> others with their CakePHP related questions.
>
> >> You received this message because you are subscribed to the Google Groups
> >> "CakePHP" group.
> >> To post to this group, send email to cake-php@googlegroups.com
> >> To unsubscribe from this group, send email to
> >> cake-php+unsubscr...@googlegroups.comFor
> >>  more options, visit this group at
> >>http://groups.google.com/group/cake-php?hl=en
>
> > --
> > Regards
> > Gopinath T.M
> > 9944944659
>
> --
> Regards
> Gopinath T.M
> 9944944659

Check out the new CakePHP Questions site http://cakeqs.org and help others with 
their CakePHP related questions.

You received this message because you are subscribed to the Google Groups 
"CakePHP" group.
To post to this group, send email to cake-php@googlegroups.com
To unsubscribe from this group, send email to
cake-php+unsubscr...@googlegroups.com For more options, visit this group at 
http://groups.google.com/group/cake-php?hl=en