Go to main content

Textpattern CMS support forum

You are not logged in. Register | Login | Help

#1 2013-01-12 19:28:44

rcpinheiro
Member
Registered: 2013-01-12
Posts: 11

Numeric author ID in posts

Hi!
Unfortunately, since TXP doesn’t have a way to include an avatar for a post author, I’ve decided to create to a quick solution. So I created a “avatar” folder to put all the admin avatars and then included this in form default:

<txp:php> global $thisarticle; echo ‘<img src=“avatar/”.$thisarticle[‘authorid’].’.jpg” />”;
</txp:php>

The problem is that some authorid are complex, include accented characters and non-latin characters. It would be a mess to name the avatar file name the same as the author name. So, instead I’m looking for a way to include the numeric author ID but didn’t found it.
Does anyone know how to do this? Or fiddling with SQL is the only way to get this information?
Thanks in advance!

PS: Sorry if this is a newbie question ;)

Offline

#2 2013-01-12 19:56:21

etc
Developer
Registered: 2010-11-11
Posts: 5,160
Website GitHub

Re: Numeric author ID in posts

<txp:author title="0" /> will output author’s login, which (normally) does not contain non-latin characters. If you need it inside a php block, call author(array('title'=>0)).

Edit: sorry, I was too self-confident, it’s the same as thisarticle['authorid'].

Last edited by etc (2013-01-12 20:02:49)

Offline

#3 2013-01-12 21:33:00

etc
Developer
Registered: 2010-11-11
Posts: 5,160
Website GitHub

Re: Numeric author ID in posts

Finally, I see nothing more than fetch('user_id', 'txp_users', 'name', doSlash($thisarticle['authorid'])) to retrieve the id. There is also smd_bio plugin that might suit your needs.

Offline

#4 2013-01-13 11:37:48

rcpinheiro
Member
Registered: 2013-01-12
Posts: 11

Re: Numeric author ID in posts

Many thanks for the answers.
etc, smd_bio does what I needed but I’m trying anyway to try to get the ID in the form. This doesn’t work (fetch is empty), any idea why?

<txp:php>
   global $thisarticle; 

   echo "The ID is ".fetch('user_id', 'txp_users', 'name', doSlash($thisarticle['authorid']))."<br>";
</txp:php>

PS: Using version 4.5.4

{Edited to add Textile’s bc.. for correctly displaying straight/curly apostrophes. – Uli}

Last edited by uli (2013-01-13 13:44:37)

Offline

#5 2013-01-13 14:17:28

etc
Developer
Registered: 2010-11-11
Posts: 5,160
Website GitHub

Re: Numeric author ID in posts

It works for me, both in article body and in article form. Actually, doSlash is not needed (and may cause problems), it’s done internally by fetch anyway. Try to call it in debug mode:

<txp:php>
   global $thisarticle; 
   echo "The ID is ".fetch('user_id', 'txp_users', 'name', $thisarticle['authorid'], true)."<br>";
</txp:php>

Offline

#6 2013-01-13 15:10:46

rcpinheiro
Member
Registered: 2013-01-12
Posts: 11

Re: Numeric author ID in posts

Thanks, etc.
Debug mode showed me the problem: it seems TXP has problems with accented characters!
This works (shown using debug mode):

select user_id from txt_txp_users where `name` = 'jose' limit 1

This doesn’t:

select user_id from txt_txp_users where `name` = 'josé' limit 1

The problem is worse than this because the link to the author posts also doesn’t work:

 http://domain.com/author/jos%C3%A9

It seems TXP doesn’t support AuthorIDs with non-ASCII characters or it has a serious bug.

Offline

#7 2013-01-13 17:33:39

etc
Developer
Registered: 2010-11-11
Posts: 5,160
Website GitHub

Re: Numeric author ID in posts

I was able to retrieve a non-ascii author’s user_id, and the corresponding link works ok, so the problem must be somewhere else. Make sure josé has some live articles in searchable (?) front-page sections. If you use the code above in article body, make sure that josé has sufficient privileges to run <txp:php>. Also check (with phpmyadmin?) what is in txp_users table.

Last edited by etc (2013-01-13 18:14:16)

Offline

#8 2013-01-13 18:05:06

rcpinheiro
Member
Registered: 2013-01-12
Posts: 11

Re: Numeric author ID in posts

Ops, found the bug. It was a silly typo from me, sorry about that :(
For the record: this works for all type of characters (I tested with chinese and other weird stuff)

fetch('user_id', 'txp_users', 'name', $thisarticle['authorid']).

Offline

#9 2013-01-14 12:32:51

uli
Moderator
From: Cologne
Registered: 2006-08-15
Posts: 4,306

Re: Numeric author ID in posts

rcpinheiro wrote:

It seems TXP doesn’t support AuthorIDs with non-ASCII characters or it has a serious bug.

Robert/wet himself opened an issue on January 6, that could have to do with what you’ve experienced. I’d like to ask you to read that short page and – if you think your problem might be related – add information to it. Thanks.


In bad weather I never leave home without wet_plugout, smd_where_used and adi_form_links

Offline

#10 2013-01-14 13:05:47

etc
Developer
Registered: 2010-11-11
Posts: 5,160
Website GitHub

Re: Numeric author ID in posts

This issue might be related to double doSlash (once in get_author_name/email, and once more in fetch functions; that’s what I meant above).

Offline

#11 2013-01-14 20:08:31

rcpinheiro
Member
Registered: 2013-01-12
Posts: 11

Re: Numeric author ID in posts

Hi, uli!
No relation, afaik. I haven’t tested with ‘ or “ characters, only with accented and non-latin characters used in oriental and latin person names.

Offline

Board footer

Powered by FluxBB