Smarty
[ class tree: Smarty ] [ index: Smarty ] [ all elements ]
Packages:
Zikula 1.0.1
axmls
PHPLayersMenu
PHPMailer
phpSniff
pnForm
PostNuke_Core
RC4Crypt
SafeHTML
Services_JSON
SimplePie
Smarty
Xanthia_Templating_Environment
XML_HTMLSax3
ZikulaTemplate_Plugins
Zikula_Core
Zikula_Docs
Zikula_System_Modules
Zikula_Template_Plugins
Zikula_Themes
Zikula_Value_Addons

Source for file resource.userdb.php

Documentation is available at resource.userdb.php

  1. <?php 
  2. /**
  3.  * Smarty plugin
  4.  * @package Smarty
  5.  * @subpackage plugins
  6.  */
  7.  
  8. /** 
  9. * Smarty plugin
  10. * -------------------------------------------------------------
  11. * Type:     resource
  12. * Name:     userdb
  13. * Purpose:  read user maintained source as a template
  14. *           $tpl_name is parsed as a uri type of string where
  15. *          the path to the template field is encoded as:
  16. * 
  17. * table/source_field?field=condtional&field=conditional...
  18. * 
  19. * results in:
  20. *    SELECT source_field FROM table WHERE conditions...
  21. * -------------------------------------------------------------
  22. */ 
  23. function smarty_resource_userdb_fetch($tpl_name, &$tpl_source, &$smarty, $default=false) 
  24. { 
  25.     $_url = parse_url($tpl_name); 
  26.     
  27.     // (required) expected syntax: table/source_field 
  28.     $_path_items = explode('/', $_url['path']); 
  29.     $table = $_path_items[0]; 
  30.     $source = $_path_items[1]; 
  31.  
  32.     // Theme Configuration
  33.     $skinid = pnModAPIFunc('Xanthia','user','getSkinID',
  34.                                 array('skin' => $table));
  35.  
  36.     $dbconn =& pnDBGetConn(true);
  37.     $pntable =& pnDBGetTables();
  38.  
  39.     $table = $pntable['theme_tplsource'];
  40.     $column = &$pntable['theme_tplsource_column'];
  41.     $query = "SELECT $column[tpl_source]
  42.                     FROM $table
  43.                     WHERE $column[tpl_file_name]='$source'
  44.                     AND $column[tpl_skin_id]= '$skinid' LIMIT 1";
  45.     $result =& $dbconn->Execute($query);        
  46.  
  47.     if ($result->EOF) {
  48.     } else {
  49.         list($tpl_source) = $result->fields;
  50.     }
  51.     $result->MoveNext();
  52.     $result->Close();
  53.     if ($tpl_source) { 
  54.         return true; 
  55.     } else { 
  56.         return $default; 
  57.     } 
  58. } 
  59.  
  60. function smarty_resource_userdb_source($tpl_name, &$tpl_source, &$smarty) 
  61. { 
  62.     if (smarty_resource_userdb_fetch($tpl_name, $tpl_source, $smarty)) { 
  63.         $tpl_source = stripslashes($tpl_source); 
  64.         return true; 
  65.     }  
  66.     return false; 
  67. }  
  68.  
  69. /** 
  70. * 
  71. * -------------------------------------------------------------
  72. * pass current time back to smarty.
  73. * no need to make sql query since template will be updated in the database
  74. * and local compiled template will be deleted automatically
  75. * forcing smarty to reload template again form database
  76. * -------------------------------------------------------------
  77. */ 
  78. function smarty_resource_userdb_timestamp($tpl_name, &$tpl_timestamp, &$smarty) 
  79. { 
  80. /*
  81.     $_url = parse_url($tpl_name); 
  82.     
  83.     // (required) expected syntax: table/source_field 
  84.     $_path_items = explode('/', $_url['path']); 
  85.     $table = $_path_items[0]; 
  86.     $source = $_path_items[1]; 
  87.  
  88.     // Theme Configuration
  89.     $skinid = pnModAPIFunc('Xanthia','user','getSkinID',
  90.                                 array('skin' => $table));
  91.  
  92.     $dbconn =& pnDBGetConn(true);
  93.     $pntable =& pnDBGetTables();
  94.     $table = $pntable['theme_tplsource'];
  95.     $column = &$pntable['theme_tplsource_column'];
  96.  
  97.     $query = "SELECT $column[tpl_timestamp]
  98.                     FROM $table
  99.                     WHERE $column[tpl_file_name]='$source'
  100.                     AND $column[tpl_skin_id]= '$skinid' LIMIT 1";
  101.     $result =& $dbconn->Execute($query);        
  102.     if ($result->EOF) {
  103.     } else {
  104.         list($tpl_timestamp) = $result->fields;
  105.     }
  106.     $result->MoveNext();
  107.     $result->Close();
  108.  
  109.     if ($tpl_timestamp) {
  110.         return true; 
  111.     } else {
  112.         return false;
  113.     } 
  114. }
  115. */
  116.  
  117.     $default=microtime(); 
  118.     return $default;
  119. }
  120.  
  121. function smarty_resource_userdb_secure($tpl_name, &$smarty) 
  122. { 
  123.     return true; 
  124. }  
  125. function smarty_resource_userdb_trusted($tpl_name, &$smarty) 
  126. { 
  127.     return true; 
  128. }  
  129.  
  130. ?>
Documentation generated on Fri, 18 Jul 2008 21:56:37 +0200 by phpDocumentor 1.4.1