gmane.comp.php.drupal.support

Re: Videos Tutorials provider | please advise for a newbie

richard reyes — 2012-05-26T01:18:56

Try here..

http://dev.nodeone.se/en

On Sat, May 26, 2012 at 3:19 AM, Wuxi Ixuw <wuxi.ixuw< at >gmail.com> wrote:

Re: show view of items with their child node references

ALLAHBAKASH ALLAHBAKASH — 2012-05-25T23:16:45

Yes There Are Ways But with Limits

On 5/26/12, Hummel, Tracey S - (thummel) <thummel< at >email.arizona.edu> wrote:

show view of items with their child node references

Hummel, Tracey S - (thummel — 2012-05-25T22:23:03

Is their a way to show a list of items and their child items in one display?  Like:

Topic 1
      node reference
      node reference
      node reference
Topic 2
      node reference
      node reference
      node reference
Topic 3
      node reference
      node reference
      node reference


Thanks,
Tracey

--------------------
Tracey Hummel
Web Application Developer
SBS Technical Services
University Services Building
888 N. Euclid, Room 302
PO Box 210158, Tucson AZ  85721-0158
520-626-3223
tracey< at >arizona.edu
http://tshummel.com

Re: Seting up local site and getting fatal error

Anthony — 2012-05-25T22:20:39

So I overlooked that module and unzipped it to the modules folder and
voila!
Thanks Earnie.

On Fri, May 25, 2012 at 2:09 PM, Earnie Boyd
<earnie< at >users.sourceforge.net>wrote:

Re: db_select()->condition()

Earnie Boyd — 2012-05-25T21:16:04

Uh, no it does not return the same thing or I would be able to do
db_select()->execute()->fetch().

You must use foreach(db_select()->execute() as $row) to get the data
and the data type of the first parameter of foreach is an array.

Re: Seting up local site and getting fatal error

Earnie Boyd — 2012-05-25T21:09:56

That function is provided by the libraries module.
http://drupal.org/project/libraries

Earnie

On Fri, May 25, 2012 at 4:39 PM, Anthony <tony< at >tony-mac.com> wrote:

Re: db_select()->condition()

Michael Prasuhn — 2012-05-25T21:07:44

No, no, no. SelectQuery::execute() does not return an array. 

Execute (at least for select queries) returns the result of DatabaseConnection::query which ends up returning the DatabaseStatement. To get an array of all results you'd have to call fetchAllAssoc() on the the resulting DatabaseStatement.

If you'd actually read the docs and the code you'd see that SelectQuery::execute and db_query() actually return the *exact same thing*. 

The real answer is that since both SelectQuery::execute and db_query end up calling and returning the same thing, is that the method for getting the query to execute with SelectQuery is much more convoluted, while helpful, each call to a method of SelectQuery, such as condition(), fields(), orderBy(), join(), etc takes additional time to execute, and then must be compiled into a string by calling __toString() on the query, the args have to be gathered by calling getArguments(), and so on.

Please look at the API docs and code before posting misinformation to the list.

-Mike

Seting up local site and getting fatal error

Anthony — 2012-05-25T20:39:21

After setting up a local site I am trying to port my site from a host.
I am now getting a fatal error in the superfish module:


 ( ! ) Fatal error: Call to undefined function libraries_get_path() in
D:\WEB_DEVELOPMENT_FROM_TONY-MAC_AND_POLAM\wamp\www\Polam_Bluehost\sites\all\modules\superfish\superfish.module
on line *700* Call Stack #TimeMemoryFunctionLocation 10.0009674048{main}( )
..\index.php*:*0 20.00821446992drupal_bootstrap( )..\index.php*:*20 30.2206
7731000_drupal_bootstrap_full( )..\bootstrap.inc*:*2186
41.371435730736module_invoke_all(
)..\common.inc*:*5045
51.446436955768call_user_func_array<http://www.php.net/call_user_func_array>(
)
..\module.inc*:*823 61.446436956008superfish_init( )..\module.inc*:*823

?
Thanks

Re: db_select()->condition()

Earnie Boyd — 2012-05-25T20:16:57

For others who are later looking at this thread, one consideration is
that db_select()->execute() returns an array of rows of objects
matching the select.  You could quickly consume all memory pulling all
nodes so don't do something stupid like

$nodes = db_select('nodes', 'n')->fields('n')->execute();

To process one row at a time from the DB you must use db_query() which
has an appropriate fetch() method to retrieve the data from the DB one
row at a time.

Thanks for the responses David and Jamie, sounds like a heated debate
but I now understand when db_select should be used and when not to.

Re: Videos Tutorials provider | please advise for a newbie

Wuxi Ixuw — 2012-05-25T19:19:00

Hello
What about videos itself as books do not make me understand everything.

Re: Videos Tutorials provider | please advise for a newbie

Earnie Boyd — 2012-05-25T19:00:43

Check out the books suggested at http://drupal.org/documentation which
should give you a start on Drupal.  But if you are new to web
development you need to learn other things first such as HTML, CSS,
JAVASCRIPT and then PHP.

Videos Tutorials provider | please advise for a newbie

Wuxi Ixuw — 2012-05-25T15:44:52

Hello
I am newbie to drupal and web development as a whole and been trying to 
go in my own since a while and it seems that I keep asking silly 
question that members here or in the list or in drupal forum do not like.
So I am thinking about getting video tutorials to learn and understand 
how things going on.
So please advise if you know from your experience a good one as I've 
found so many providers like _*Drupalizeme*_ and *_Build A Module_* and 
some others and do not know which one to get.
Please advise and reply me as I am really very mch disappointed for do 
not know the way out of this.
Thanks for your time reading my email and sorry for bothering you.
Thanks a lot
WI

Re: db_select()->condition()

Metzler, David — 2012-05-25T15:36:57

The question about check plain vs. non-check plain is really about the data and how it is used. Check plain is generally not used in the condition db-comparison layer because that's not the point where you're trying to prevent cross site scripting vulnerabilities.  Rather that happens at presentation. 

In general drupal's strategy has been to sanitize data prior to presentation, not prior to storage.   So until you're passing stuff to the presentation layer, you wouldn't normally run stuff through check_plain.  Check_plain does not provide SQL Injection protection, and since the data is stored in the raw, you don't want to run checkplain on something before the comparison of that value in the condition.  The SQL injection protection is all handled internally within DBTNG and db_query now, and check_plain never performed this protection anyway. 

The idea behind DBTNG is to get away from token substitution and into an object-relational mapping (ORM) style of coding.   So this really is the new drupal way.

Re: db_select()->condition()

Jamie Holly — 2012-05-25T13:32:31

As far as the overhead of dynamic queries, see this issue starting at 
comment #8:

http://drupal.org/node/835068#comment-3125136

You don't have to do a check_plain on your field. PDO knows what type of 
field is being populated and automatically prepares them as needed. This 
all happens up in the driver and invoked by PDO::Prepare(). In DBTING, 
the prepare is called when you do the ->execute(), so you don't have to 
worry about calling it.

Jamie Holly
http://www.intoxination.net
http://www.hollyit.net


On 5/25/2012 8:04 AM, Earnie Boyd wrote:

Re: db_select()->condition()

Earnie Boyd — 2012-05-25T12:04:46

I understand that db_select builds a string that is eventually passed
to MySQL but what overhead is added?  Can you point to threads of
discussion?


Ok, thanks.  It just doesn't seem Drupalish, I would have expected an
optional 4th argument to provide token substitution.  Shouldn't it be
check_plain($somevariable) then?  Probably depends on how
$somevariable gets a value.

Re: Entering data into taxonomy

Earnie Boyd — 2012-05-25T11:57:12

Maybe you want http://drupal.org/project/taxonomy_manager

Earnie

On Fri, May 25, 2012 at 12:50 AM, Roger <arelem< at >bigpond.com> wrote:

Re: Howto I removed og, workbench, etc

Earnie Boyd — 2012-05-25T11:53:25

This is expected.  If you want to remove the modules you must do it
yourself.  Perhaps Drush will do it for you since it is a command line
tool but IDK because I don't use Drush.

Howto I removed og, workbench, etc

Roger — 2012-05-25T09:42:03

Drupal 7.14.
I am happy to report that I believe I may have found a way to get rid of 
OG and workbench totally for learning purposes in prep for a fresh install.
Both leave database tables and data and if reinstalled simply find the 
old unwanted data.

Here's what I did...
- First did a backup of the site in cPanel compress and the database in 
ssh  mysqldump.
- Checked then cleared Reports ->Recent Log Messages.
- Switched off the modules and dependencies in Admin -> Modules.
- Then, and this is very important but not mentioned anywhere that I 
could find,  I ran UNINSTALL - the button, top right of the Modules view 
screen, select modules to remove, this advises that all data will be 
lost. I think it also cleans out the unwanted tables........But it does 
not uninstall/remove modules?

- Check Recent Log Messages just in case.
- Next I ran update.php,  then Clear All Caches.
- In cPanel I deleted the modules from sites/all/modules.
- I ran drush cc #1 to flush caches which don't normally flush with the

Entering data into taxonomy

Roger — 2012-05-25T04:50:24

I have need to let 6 users add or update data in taxonomy fields which 
provide drop down menus for Town. Locality and Venue.
I have an editor's page and menu for such purpose where those select 
users can view taxonomy data in views and select from the menu to add a 
new term to now of the above vocabularies.
In Permissions:
'Administer Vocabularies and Terms' permits this but they can alter 
taxonomy fields and display.
Switch off 'Administer Vocabularies and Terms' and the menu items 
disappear, they cannot add data.
Is there any way to allow the users to add taxo data but not have the 
degree of admin access?
I'm a bit stuck on how to do this, help would be appreciated.
thanks
Roger

D7: hook_field_extra_fields() + field_attach_form()

Georg Jaehnig — 2012-05-25T02:09:40

Hi,

I exposed a field in hook_field_extra_fields():

$form_elements['item_description'] = array(
    'label' => t('Item Description'),
    'description' => t('Item Description (an extra form field)'),
    'weight' => -5,
  );
  $extra_fields['entity_example_basic']['first_example_bundle']['form']
= $form_elements;
  return $extra_fields;

Now I thought, by calling

  field_attach_form('entity_example_basic', $entity, $form, $form_state);

in a form callback, it will be attached to $form automatically. But it doesn't.

Is there a way to change that? Or do I have to add the form field
manually in any case?

If I there's no way to attach it automatically - what is the sense in
exposing the field in
hook_field_extra_fields()?

Cheers,

Re: Glossary View - Attachment - How does it work?

richard reyes — 2012-05-25T01:53:00

Thanks

On Fri, May 25, 2012 at 1:16 AM, Jeff Greenberg <jeff< at >ayendesigns.com>wrote: