no way to compare when less than two revisions

Differences

This shows you the differences between two versions of the page.


Previous revision
Next revision
—shell_access [2009-12-16 15:45] – external edit 127.0.0.1
Line 1: Line 1:
 +Here's a little hack to allow command-line interaction with our favorite Web Office Suite. It works by executing PHP in the Unix Shell.
  
 +Ideal for narrowband on-the-road-interaction from anything that can run SSH. Like, my mobile Phone!
 +
 +first little attempt only shows a somewhat formatted list of tasks, sorted by tag. To come: Creating new Tasks, marking tasks complete. If Easter then still isn't over, perhaps I'll do something for Contacts & Notes next.
 +
 +e.g.
 +
 +PHP OGOO.PHP -u wolf -t tel -w 6
 +
 +will dump all tasks for me tagged as "tel"  from my private workspace...
 +
 +the output looks like this:
 +
 +''user>id   tag    description text of the task (workspace name-id)''
 +
 +
 +parameters:
 +-u username
 +-t tag (currently supports filtering for one tag only)
 +-w workspace (must supply the workspace number. The number can be found in the dump at the end of each line.
 +
 +
 +oh,
 +please be aware that this might pose a severe security risk. Use only if you know what you are doing. I'm absolutely not responsible.
 +
 +uses a command-line parser function by Tyler Hall found [[http://code.google.com/p/tylerhall/source/browse/trunk/class.args.php|here]]. 
 +
 +copy the following code as ogoo.php into your opengoo's root dir, or wherever.
 +
 +
 +<code php>
 +''#!/usr/local/bin/php -q
 +
 +<?php
 +$dbhost = '127.0.0.1:3306';
 +$dbuser = 'root';
 +$dbpass = '********'; // insert your password here
 +
 +$conn = mysql_connect($dbhost, $dbuser, $dbpass) or die                      ('Error connecting to mysql');
 +
 +$dbname = 'opengoo'; // insert your DB name here
 +mysql_select_db($dbname);
 +
 +$argv[0]=="ogoo" ? $nl="\n" : $nl="<br>";
 +
 +$a= new Args();
 +
 +$a->flag('u') ? $user = "User:".$a->flag('u') : $user="Any User" ;
 +$a->flag('u') ? $userfilter = "AND `og_users`.`username` = '".$a->flag('u')."'" : $userfilter="" ;
 +
 +$a->flag('t') ? $tag = "Tag:". $a->flag('t') : $tag="No Tag";
 +$a->flag('t') ? $tagfilter = "AND `og_tags`.`tag` = '". $a->flag('t')."'" : $tagfilter="";
 +
 +$a->flag('w') ? $tag = "Workspace:". $a->flag('w') : $tag="All Workspaces";
 +$a->flag('w') ? $wsfilter ="AND `og_projects`.`id` = ".$a->flag('w')  : $wsfilter="" ;
 +
 +// parameters for Tasks
 +// tag=xxxx due=yyyymmdd  ws="workspace Name"
 +
 +print ("connect...success".$nl);
 +
 +$result=mysql_query("SELECT `og_project_tasks`.`id` AS `taskID`, `og_tags`.`tag`, `og_project_tasks`.`title`, `og_project_tasks`.`assigned_to_user_id`, `og_users`.`username`, `og_projects`.`name`, `og_projects`.`id` FROM `opengoo`.`og_tags` AS `og_tags`, `opengoo`.`og_project_tasks` AS `og_project_tasks`, `opengoo`.`og_users` AS `og_users`, `opengoo`.`og_projects` AS `og_projects` WHERE `og_tags`.`rel_object_id` = `og_project_tasks`.`id` AND `og_users`.`id` = `og_project_tasks`.`assigned_to_user_id` AND `og_project_tasks`.`project_id` = `og_projects`.`id` ".$userfilter.$tagfilter." AND `og_tags`.`rel_object_manager` = 'ProjectTasks' AND `og_project_tasks`.`trashed_by_id` = 0 AND `og_project_tasks`.`completed_by_id` = 0 ".$wsfilter." ORDER BY `og_tags`.`tag` ASC");
 +
 +
 +// store the record of the "example" table into $row
 +$i=0;
 +while($row = mysql_fetch_array( $result )){
 + $i++;
 + print ($row['username'].">".$row['taskID']."\t".$row['tag']."\t".$row['title']." (".$row['name']."-".$row['id'].")".$nl);
 +};
 +print ($nl.$user."/".$tag."/".$i." tasks in this list.");
 +
 +//--------------------------------------------------------------------------------------------------------
 +
 +    // A quick and dirty command line argument parser. Written in about
 +    // an hour, so you might want to take this with a grain of salt or two.
 +    //
 +    // Single letter options should be prefixed with a single
 +    // dash and can be grouped together. Examples:
 +    //
 +    // cmd -a
 +    // cmd -ab
 +    //
 +    // Values can be assigned to single letter options like so:
 +    //
 +    // cmd -a foo (a will be set to foo.)
 +    //
 +    // cmd -a foo -b (a will be set to foo.)
 +    //
 +    // cmd -ab foo (a and b will simply be set to true. foo is only listed as an argument.)
 +    //
 +    // You can also use the double-dash syntax. Examples:
 +    //
 +    // cmd --value
 +    //
 +    // cmd --value foo (value is set to foo)
 +    //
 +    // cmd --value=foo (value is set to foo)
 +    //
 +    // Single dash and double dash syntax may be mixed.
 +    //
 +    // Trailing arguments are treated as such. Examples:
 +    //
 +    // cmd -abc foo bar (foo and bar are listed as arguments)
 +    //
 +    // cmd -a foo -b bar charlie (only bar and charlie are arguments)
 +
 +
 +    class Args
 +    {
 +        private $flags;
 +        public $args;
 +
 +        public function __construct()
 +        {
 +            $this->flags = array();
 +            $this->args  = array();
 +
 +            $argv = $GLOBALS['argv'];
 +            array_shift($argv);
 +
 +            for($i = 0; $i < count($argv); $i++)
 +            {
 +                $str = $argv[$i];
 +
 +                // --foo
 +                if(strlen($str) > 2 && substr($str, 0, 2) == '--')
 +                {
 + $str = substr($str, 2);
 +                    $parts = explode('=', $str);
 +                    $this->flags[$parts[0]] = true;
 +
 +                    // Does not have an =, so choose the next arg as its value
 +                    if(count($parts) == 1 && isset($argv[$i + 1]) && preg_match('/^--?.+/', $argv[$i + 1]) == 0)
 +                    {
 +                        $this->flags[$parts[0]] = $argv[$i + 1];
 +                    }
 +                    elseif(count($parts) == 2) // Has a =, so pick the second piece
 +                    {
 +                        $this->flags[$parts[0]] = $parts[1];
 +                    }
 +                }
 +                elseif(strlen($str) == 2 && $str[0] == '-') // -a
 +                {
 +                    $this->flags[$str[1]] = true;
 +                    if(isset($argv[$i + 1]) && preg_match('/^--?.+/', $argv[$i + 1]) == 0)
 +                        $this->flags[$str[1]] = $argv[$i + 1];
 +                }
 +                elseif(strlen($str) > 1 && $str[0] == '-') // -abcdef
 +                {
 +                    for($j = 1; $j < strlen($str); $j++)
 +                        $this->flags[$str[$j]] = true;
 +                }
 +            }
 +
 +            for($i = count($argv) - 1; $i >= 0; $i--)
 +            {
 +                if(preg_match('/^--?.+/', $argv[$i]) == 0)
 +                    $this->args[] = $argv[$i];
 +                else
 +                    break;
 +            }
 +
 +            $this->args = array_reverse($this->args);
 +        }
 +
 +        public function flag($name)
 +        {
 +            return isset($this->flags[$name]) ? $this->flags[$name] : false;
 +        }
 +    }
 +
 +
 +
 +
 +?>
 +
 +
 +</code>
 +
 +
 +by  --- //[[User Page: Max|max wolf]] 2009-04-17 15:49//