Offshore

How to associate a Taxonomy Term to a bunch of nodes via SQL for Drupal 6

Submitted by enzo on Thu, 01/20/2011 - 10:31

Hello folks

If for some weird reason you need a bulk process to associate a Taxonomy Term to a bunch of nodes, you can use SQL Script listed below:
 

SET @term_id = 100;
INSERT INTO term_node
SELECT nid, @term_id,vid
FROM `node`
WHERE language = 'en'


This script assumes you want to assign the term id # 100 and only for nodes with English as language.

Enjoy IT

enzo

New Contribution module Taxonomy Feed for Drupal 6

Submitted by enzo on Mon, 01/17/2011 - 09:15

Hello folks

Today after checking all modules available for taxonomies with views, I decided to create a new module to support the creation of rss views based in vocabulary terms.

Short Story

This module allows you to create a RSS feed, based in terms from a vocabulary or vocabularies using Views module.

Language Vine

Content: 
Drupal
Jquery
css
html
Costa Rica
Offshore
PHP5
Freelance
ubercart
shopping cart
Language
eCommerse
Multi Language
Translate
Courses
Japan
Korean
French

Languagevine.com is a website dedicated to learning different languages with a twist. Anexusit had a mission, create a website to make users stay and decide to pay in order to access even more content.

Languagevine was a great project that presented challenges and features such as multi language, media content such as videos, sound and pictures as well as interactive games to lead the user to gain credit point while learning the language of their preference.

CodeMyConcept Drupal Training

Content: 
PHP
Drupal
Costa Rica
Offshore
PHP5
Freelance
Training
Course
Lessons
Drupal School
Seminar

With so much to learn about Drupal CMS, creating and leveraging effective training content and materials can save hours of repetitive research, that is why AnexusIT has created a proven way of teaching Drupal for Developers and Designers. In this case it was CodeMyConcept who requested our company to give a full Drupal Theming Training to 6 of their employees.

Patch to fix term edition in Taxonomy Manager module for Drupal 6

Submitted by enzo on Tue, 01/11/2011 - 13:19

Hello folks.

We have developed a patch in order to disable the use of ajax when you save a term on taxonomy manager module, it seems like there is a problem with the form action url when you use ajax.

AttachmentSize
taxonomy_manager-[issue-number].txt1.69 KB

Patch to enable print City and Country in Debug Mode for GeoIP API

Submitted by enzo on Thu, 12/23/2010 - 15:03

Hello folks.

I did a small patch to include the Country and City in Debug mode for module GeoIP API  with Drupal 6, the debug mode for this module is important in development process and useful if you don't access to computers in other countries.

You can follow the issue request to include in next release at: http://drupal.org/node/1006424

Merry Christmas

enzo

How to store all queries executed in MySQL in a Table

Submitted by enzo on Tue, 12/14/2010 - 15:51

Hello folks.

If you have the task of debugging a Function, Store Procedure or a Program, maybe you need to store all executed queries to run a certain debug. You can do this by configuring your MySQL to store all queries inside a mysql table.

1. Enable log.

execute "SET GLOBAL general_log = 'ON';"
    execute "SET GLOBAL log_output = 'TABLE';"

2. Find inside your queries.

All queries now are stored in database/schema `mysql` inside table `general_log`, if you need to find a specific query, just run a query as below:

How to debug a MySQL function

Submitted by enzo on Tue, 12/14/2010 - 12:15

Hello folks

If you are a MySQL Coder with some buggy functions and you need to debug this script inside you DB, but you don't know how do this, check the following approach.

1. Create a log Table

create table log ( id int AUTO_INCREMENT, 
                   timestamp int default 0 , 
                   name varchar(64), 
                   value varchar(255), key(id));

2. Update your function to include the debugging code

New Releases for Taxonomy Accordion Module

Submitted by enzo on Thu, 12/09/2010 - 19:53

Hello folks

I just released a new version (6.x.1.3) for Taxonomy Accordion module to fix the bug http://drupal.org/node/989724.

Also, I released a new version 6.x.2.1 to enable the active trail path to start with the proper container accordion open, in order to maintain a consistent user navigation experience.

Enjoy it

Regards,

enzo

Pages

Subscribe to Offshore