[Snippet] AuthorTime stamp

• • 
  • 93 Posts
  jwtyler Reply #1, 18 years, 1 month ago

  This may be redundant. I could not find anything that would do this for me however.
  
  A simple snippet to tag a document with the Author and Date time of document creation. In this format
  
  By (author) on (Date time)
  
  Ala newslisting et al. My first snippet. My first PHP foray period. All borrowed code. Thanks to orignal snippet MetaTag generator.
  
  

  //Simple snippet to return Author and time a document was created.
  //Original code borrowed from MetaTag snippet by Miels, converted to MODX
  //by Shane Briggs. 
  //AuthorTime snippet by Jason Tyler
  
  $Author = "";
  
  
  $docInfo = $modx->getDocument($modx->documentIdentifier);
  
  // *** AUTHOR,Time***
  $authorid = $docInfo['createdby'];
  $createdon = date('d-M-y h:i:s A',$docInfo['createdon']);
  $tbl = $modx->getFullTableName('user_attributes');
  $query = "SELECT fullname FROM $tbl WHERE $tbl.id = $authorid"; 
  $rs = $modx->dbQuery($query);
  $limit = $modx->recordCount($rs); 
  if($limit=1) {
    $resourceauthor = $etomite->fetchRow($rs); 
    $authorname = $resourceauthor['fullname'];  
  }
  if (!$authorname == ""){
     $Author =  "By <strong>$authorname</strong> on $createdon " ;
   
  }
  
  
  
  // *** RETURN RESULTS ***
  
  $output = $Author;
  
  return $output;

  
  
  Feel free to chastize critisize etc.
  
  JW
  
  Edit: Replaced API function per Susan. Thanks guys. I didnt see the variable trouble... care to elucidate Susan?
• • 
  • 3,975 Posts
  Zaigham (aka zi) Reply #2, 18 years, 1 month ago

  Thanks for the little nice snippet!
  
  regards,
  
  zi
  Zaigham R - MODX Professional | Skype | Email | Twitter
  
  Digging the interwebs for #MODX gems and bringing it to you. modx.link
• • 
  • 1 Posts
  andrew_bernard Reply #3, 18 years ago

  Greetings from Australia!
  
  Just what I have been looking for! Thanks. I am an old IT dog but an absolute MODx newbie, so I am just getting into the coding/development side of MODx. Just two comments:
  

  
  
  • The statement [tt]if ($limit = 1)[/tt] should be [tt]if ($limit == 1)[/tt] I suspect.
  • You can replace the older [tt]$etomite[/tt] variable with the newer [tt]$modx[/tt] variable. They are defined to be the same thing.

  
  Cheerio!
  
  Andrew Bernard
• • 
  • 93 Posts
  jwtyler Reply #4, 18 years ago

  Thanks so much for the critique. I didnt think this would acctually be useful for anyone, or was already covered in some function I was unaware of.
  
  I will change that code. However, my php skills are nil. I understand syntax only as I stumble through pre written code. I could not code something from scratch to save my worthless hide.
  
  thanks again.
  
• • 
  • 54 Posts
  Zzzeke Reply #5, 18 years ago

  This looks like a handy little snippet to me (it’s a little odd it wasn’t created before since it’s a common snippet in most blogging software). But I’m afraid I can’t get it to work properly.
  
  Can anyone check the code and confirm the suggestion by andrew_bernard that you can simply exchange all occurences of "etomite" with "modx", and that ($limit = 1) should be if ($limit == 1)?
  
  Mats
  
• • ☆ A M B ☆
  • 24,524 Posts
  sottwell Reply #6, 18 years ago

  Yes, and yes. If you say "$variable = 1" you are assigning the value of 1 to $variable, which will always work so will always be "true". If you say "$variable == 1" you are comparing the value of $variable to 1, which may or may not be "true". And you can replace $etomite with $modx, at least so far.
  
  However, MODx offers another API function, getFullTableName:
  

  $tbl = $modx->dbConfig['dbase'].".".$etomite->dbConfig['table_prefix']."user_attributes";

  
  can be replaced with:
  

  $tbl = $modx->getFullTableName('user_attributes');
  Studying MODX in the desert - http://sottwell.com
  Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
  Join the Slack Community - http://modx.org
• • 
  • 141 Posts
  zenmaster Reply #7, 17 years, 11 months ago

  Why are these items not available as "values that are useful for display on the page" ? They sound pretty useful to me!
  
  
• • ☆ A M B ☆
  • 24,524 Posts
  sottwell Reply #8, 17 years, 11 months ago

  Because the standard [*...*] document variables are as-is from the database, and the "author" in the database is only the user ID, while the times stored in the database are raw Unix timestamps. These values need processing before they can be useful, so while you can access them with [*...*] syntax, they wouldn’t be very useful, except perhaps to use as the arguments to a snippet that will process them and return useful output.
  Studying MODX in the desert - http://sottwell.com
  Tips and Tricks from the MODX Forums and Slack Channels - http://modxcookbook.com
  Join the Slack Community - http://modx.org
• • 
  • 283 Posts
  OncleBen31 Reply #9, 17 years, 11 months ago

  I’ve made some modifications to the original snippet to make it easily configurable :
  

  
  
  • You can choose the date format with &dateFormat parameter (see PHP documentation for the syntax)
  • you can choose the Date field to use (like createon, editeon, pub_date etc...) with &usedDate parameter
  • you can use a template to change or translate the output by using placeholders in the string ([+Author+] and [+Date+])

  
  
  Example:
  

  [[AuthorTime? &dateFormat=`%d %B %Y - %H:%M` &usedDate=`pub_date` &tpl=`Posté par <strong>[+Author+]</strong> le [+Date+]`]]

  
  
  
  Follow my contributions to open source on Oncleben31.cc
• • 
  • 93 Posts
  jwtyler Reply #10, 17 years, 10 months ago

  OncleBen! YOU ROCK! Wow. Good stuff. Way to go.

This discussion is closed to further replies. Keep calm and carry on.