| New file |
|---|
| 0,0 → 1,144 |
|---|
| <?php |
| |
| /* |
| * phpMyEdit - instant MySQL table editor and code generator |
| * |
| * extensions/phpMyEdit-slide.class.php - slide show extension for phpMyEdit |
| * ____________________________________________________________ |
| * |
| * Developed by Ondrej Jombik <nepto@platon.sk> |
| * Copyright (c) 2002-2006 Platon Group, http://platon.sk/ |
| * All rights reserved. |
| * |
| * See README file for more information about this software. |
| * See COPYING file for license information. |
| * |
| * Download the latest version from |
| * http://platon.sk/projects/phpMyEdit/ |
| */ |
| |
| /* $Platon: phpMyEdit/extensions/phpMyEdit-slide.class.php,v 1.10 2006-01-22 21:44:24 nepto Exp $ */ |
| |
| /* |
| * Coding elapsed time: from 8:30 to 10:30 at 30th October 2002 |
| * with heavy patching phpMyEdit core class. |
| * |
| * Music used: E-Type (Campione, This is the Way and others) |
| */ |
| |
| require_once dirname(__FILE__).'/../phpMyEdit.class.php'; |
| |
| class phpMyEdit_slide extends phpMyEdit |
| { |
| // Extension options array |
| var $ext; |
| |
| function phpMyEdit_slide($opts) /* {{{ */ |
| { |
| $execute = 1; |
| isset($opts['execute']) && $execute = $opts['execute']; |
| $opts['execute'] = 0; |
| parent::phpMyEdit($opts); |
| |
| $this->ext = $opts['ext']; |
| |
| $execute && $this->execute($opts); |
| } /* }}} */ |
| |
| function display_record_buttons() /* {{{ */ |
| { |
| // TODO: classify this table and cells |
| echo '<table border=0 cellpadding=0 cellspacing=0 width="100%" style="border:0;padding:0;">'; |
| echo '<tr><td align=left style="text-align:left;border:0;padding:0;" nowrap>' . "\n"; |
| if ($this->change_operation()) { |
| echo '<input type="submit" name="savechange" value="'.$this->labels['Save'].'" />'."\n"; |
| echo '<input type="submit" name="morechange" value="'.$this->labels['Apply'].'" />'."\n"; |
| echo '<input type="button" name="cancel" value="'.$this->labels['Cancel'].'" onClick="form.submit();" />'."\n"; |
| echo '<input type="hidden" name="rec_change" value="1">'; |
| } elseif ($this->view_operation()) { |
| if ($this->change_enabled()) { |
| echo '<input type="submit" name="operation" value="'.$this->labels['Change'].'" />'."\n"; |
| } |
| echo '<input type="submit" name="cancel" value="'.$this->labels['Cancel'].'" />'."\n"; |
| } |
| |
| if (! $this->ext['prev_disable']) { |
| $disabled = $this->ext['prev'] ? '' : ' disabled'; |
| echo '<input'.$disabled.' type="submit" name="'.ltrim($disabled).'prev" value="' |
| .$this->labels['Prev'].'"> '; |
| echo '<input type="hidden" name="rec_prev" value="'.$this->ext['prev'].'">'; |
| } |
| if (! $this->ext['next_disable']) { |
| $disabled = $this->ext['next'] ? '' : ' disabled'; |
| echo '<input'.$disabled.' type="submit" name="'.ltrim($disabled).'next" value="' |
| .$this->labels['Next'].'">'; |
| echo '<input type="hidden" name="rec_next" value="'.$this->ext['next'].'">'; |
| } |
| echo '</td></tr></table>'."\n"; |
| } /* }}} */ |
| |
| function execute($opts) /* {{{ */ |
| { |
| if ($this->get_cgi_var('rec_change') |
| && ($this->next_operation() || $this->prev_operation())) { |
| $this->operation = $this->labels['Change']; |
| } |
| if (! $this->change_operation()) { |
| $this->operation = $this->labels['View']; |
| } |
| if ($this->prev_operation()) { |
| ! $this->ext['prev_disabled'] && $this->rec = $this->get_cgi_var('rec_prev'); |
| $this->prev = ''; |
| } |
| if ($this->next_operation()) { |
| ! $this->ext['next_disabled'] && $this->rec = $this->get_cgi_var('rec_next'); |
| $this->next = ''; |
| } |
| if (! $this->rec) { |
| $this->rec = $this->ext['rec']; |
| } |
| |
| if (! $this->rec |
| || (! $this->ext['prev_disable'] && ! $this->ext['prev']) |
| || (! $this->ext['next_disable'] && ! $this->ext['next'])) { |
| if ($this->connect() == false) { |
| return false; |
| } |
| $query_parts = array( |
| 'type' => 'select', |
| // XXX FIXME - simplify query |
| 'select' => 'PMEtable0.'.$this->key, |
| 'from' => $this->get_SQL_join_clause(), |
| 'where' => $this->get_SQL_where_from_query_opts()); |
| // TODO: order by clausule according to default sort order options |
| $res = $this->myquery($this->get_SQL_query($query_parts), __LINE__); |
| $ids = array(); |
| while (($row = @mysql_fetch_array($res, MYSQL_NUM)) !== false) { |
| $ids[] = $row[0]; |
| } |
| @mysql_free_result($res); |
| if ($this->rec) { |
| $idx = array_search($this->rec, $ids); |
| $idx === false && $idx = 0; |
| } else { |
| $idx = 0; |
| } |
| |
| $this->rec = $ids[$idx]; |
| ! $this->ext['prev'] && $this->ext['prev'] = $ids[$idx - 1]; |
| ! $this->ext['next'] && $this->ext['next'] = $ids[$idx + 1]; |
| } |
| |
| $this->recreate_fdd(); |
| $this->recreate_displayed(); |
| parent::execute(); |
| } /* }}} */ |
| |
| } |
| |
| /* Modeline for ViM {{{ |
| * vim:set ts=4: |
| * vim600:fdm=marker fdl=0 fdc=0: |
| * }}} */ |
| |
| ?> |