- support - lists.drupal.org

RE: [support] node_access table
by Metzler, David 30 Dec '05

30 Dec '05

The short answer here is that it depends on which access control modules you're using. If you're using the "og module" it's different then if you're using "node privacy by role". If I understand it correctly, without additional modules installed this table doesn't do anything. You should be extremely careful about modifying this table without using the API's for the appropriate access module. More info is in the hook_access on the Drupal Api documentation. If you still want to do th is programatically then here's and example: If you're using node_privacy_by_role, then an example insert would be: Insert into node_access (nid,gid,realm,grant_view,grant_update,grant_delete) values (<node>,<role_id>,'node_access_byrole_role',<grant_view>,<grant_update>, <grant_delete>) With the followign replacements: <node> The node id that you're protecting - find from node edit screen <role_id> the role ID for the role your granting access to. <grant_view> 1 if the role can view, otherwise 0 <grant_update> 1 if the role can update, otherwise 0 <grant_delete> 1 if the role can delete, otherwise 0 -----Original Message----- From: support-bounces(a)drupal.org [mailto:support-bounces@drupal.org] On Behalf Of VJ Sent: Thursday, December 29, 2005 9:20 AM To: support(a)drupal.org Cc: development(a)drupal.org Subject: [support] node_access table How does this table work? If I want to remove comment and update rights to a specific user (or role), whats the exact SQL query? Thanks, V -- [ Drupal support list | http://lists.drupal.org/ ]

2 1

Need To Know How To Move Drupal To Another Hosting Company
by Rob 30 Dec '05

30 Dec '05

I am moving several sites to another hosting company. I wanted to ask if someone could explain how I should go about moving my existing Drupal site files so I will not lose archives etc.The simplest way possible is what I need to do since I only know how to use Drupal but am not familiar with some of the technical things about servers. Rob

4 5

node_access table
by VJ 29 Dec '05

29 Dec '05

How does this table work? If I want to remove comment and update rights to a specific user (or role), whats the exact SQL query? Thanks, V

1 0

translation (i18n) question: categories
by VJ 29 Dec '05

29 Dec '05

Hi, If I create a sub category in 2 languages , the translation module lets me map the two sub categories (under 'new translation'). What exactly does this achieve? If someone posts under english, does it automatically get tagged under the spanish sub category too? Also, I want to add 'block title' to the list of translatable variables..what exactly is the variable? is there an easy way to find out? Thanks, V

1 1

too many connections
by Mohammed al-shar' 29 Dec '05

29 Dec '05

hi list, this is not understandable. Warning: mysql_connect(): Too many connections in /home/mystop/public_html/includes/database.mysql.inc on line 31 Too many connections what does this mean? thank you.

3 7

IRC Hacking Files
by Rob 27 Dec '05

27 Dec '05

My hosting company has twice recently claimed there are IRC hacking files in one of my accounts which uses Drupal. Has anyone had this experience or have any idea how they could be uploaded into my account like that? Is there a security hole in Drupal that could cause this? Rob

3 4

weblinks or directory
by Mohammed al-shar' 24 Dec '05

24 Dec '05

hello everybody. I looked alot in the module pages at drupal.org for a web links directory module but found none. some forum threats do mention such a module, anybody have a better idea? what i want to achieve is to publish pages of links in various catigories and to give users the ability to suggest their favorite websites too. thanks in advance. regards, mohammed al-shar' www.mystop.net

3 2

Expert Drupal Developer Needed - starting Jan 2006 - long term contract
by Jason Diceman 23 Dec '05

23 Dec '05

[Apologies for any duplication of this message in your Inbox] Co-op Tools (www.cooptools.ca) is hiring a PHP/MySQL programmer to do extensive support and upgrades to a Drupal (www.drupal.org) code base to be shared across multiple large scale web sites. Approximately 15 hours a week. 10 week contract with potential to continue long-term. Wage: $40-60/hr USD Starting January 2006 Please submit your C.V. and list of recent Drupal projects to: jd(at)cooptools.ca Deadline is December 29th. International applications are welcome. == Skills Required == * Linux Apache system administration. * PHP, MySQL, XML and JavaScript programming. * Expert knowledge of evolving Drupal APIs. * Awareness of accessibility standards. * Subversion code management. * Collaboration within the Drupal community. * Reasonable (technical) English == Expectations == * Extremely dependable. * Quick and friendly communication on a daily basis. * Addressing bugs right away. * Reusing other peoples good code when ever appropriate. * Contributing code back to Drupal community. * Proactive in improving functionality. * Co-operate well with project manager to refine specifications, set reasonable milestones and to follow through with professionalism. * Co-operate well with other developers. == Responsibilities == * Development, testing, release and maintenance of secure, efficient and stable Drupal code. * Managing contributions of code by other developers. * Maintaining TRAC system (www.edgewall.com/trac/) * Research into development options and recommending approaches. * Maintaining functionality of multiple Drupal sites. * Working with web hosts to help with server administration. == Context == Interface Design and functional requirements will be provided by Co-op Tools in the form of documentation and mock-ups clarified through frequent discussion via e-mail and/or chat. You will not be expected to do direct support or training for clients. You can work from home. Project management style will be tailored to your preferences. We use a TRAC wiki to document development plans and tickets to track issues and minor upgrades. Average three hours a day, five days a week. == About Co-op Tools == Jason Diceman started Co-op Tools in January 2004 as a small business to provide easy to use collaboration tools to progressive organizations. Our clients have included: * Ashoka www.ashoka.org (key Drupal client) * Centre for Global eHealth Innovation * Green Peace Canada * Sierra Club of Canada * The City of Toronto * Green Party of Canada * Canadian co-operative associations * Centre for Social Innovation * The Canadian Partnership for Children's Health and Environment The Drupal projects we are doing this year will be global in scope with a focus on mass participatory decision-making and collaboration between social entrepreneurs (aka change makers). We are fun and professional folks who aim to make a lasting positive impact on our society. -- Please submit your C.V. and list of recent Drupal projects to: jd(at)cooptools.ca Deadline is December 29th. International applications are welcome. -- I sincerely hope you will apply for this job. - jd - ------------------------------ Jason Diceman Co-op Tools www.CoopTools.ca Phone: 416-538-co-op (2667) Toll-free: 1-866-519-co-op (2667) jd(a)cooptools.ca ------------------------------

1 0

multiple menu bugs? Or a classic case of PEBKAC?
by Kobus Myburgh 23 Dec '05

23 Dec '05

Hi, Possible bug 1: If you use the menu to customize the items, and set a menu so that users may control whether they can see it or not, and then saving your user account after that, doesn't seem to work. Here is the recipe: 1. Create a new menu (let's call it "advanced"). 2. Create a menu item under this menu (let's call it "home" and link it to index.php). 3. Enable the block in block administration. 4. Configure the block to be NOT shown by default but allow individual users to display it. 5. Edit your own account and check the box next to the advanced menu. Possible bug 2: I am not sure where to file this one. Is it a BlueMarine issue or is it a PHPTemplate issue, or what is this? When you go to the menu, and you DELETE the Primary Links menu, it still displays in the header section of my site. Typically not everyone would delete this menu, so it is possible that I am the first one to notice this, but I only deleted it becauuse I could not find a way to disable it. I am not sure whether these are bugs or not. I have searched the bug list, and couldn't find anything (although I only had a few minutes to do so - our power is going out in 25 minutes or so). If these are indeed bugs, could someone please file then, as our power will be out for the whole day, and I am not going to be back here until 3rd of January. Regards, Kobus

2 1

<!break--> tag?
by Kobus Myburgh 23 Dec '05

23 Dec '05

Hi! In previous version of Drupal I could split a node to have a "read more" section by using the  tag. It seems that I can't do that with Drupal CVS of 19 December (or thereabouts). Is this a bug, or did I miss something? My nodes were set up in various configurations to test this: either as "unlimited" or 2000 words length, so I doubt that is where the problem lies. Regards, Kobus

3 2