Textpattern CMS

#31 2014-10-12 22:51:51

lazlo

Member

Registered: 2004-02-24

Posts: 110

Re: Help cleaning up bulky/slow sql calls

etc wrote #284694:

Ah, you want to output the books having the current Author_1 (say, custom_1) or Editor_1 (custom_11) as contributors? This should work:

And that did work on my test site but my live site is on TXP 4.2 and it threw up a fatal error when try to go to the prefs file. I will be using this in my new revision though on TXP4.5:

 Fatal error: Call to undefined function bouncer() in /home/talonboo/public_html/textpattern/lib/txplib_misc.php(594) : eval()'d code on line 52

I did manage to get something working off of Michael’s code, thank you Michael. It doesn’t exclude the feature book in the list but for now it is usable.

Unfortunately I have used Jeff Soo’s filter in one other spots and I hoping for some alternatives:

In english code grabs a list of names that are all in the Title Field by First Name/Initial(sometimes)/Last Name, takes into account Initial and sorts them by Last Name. There must be easier ways of doing this in the long past I used chh_article_custom to do this.

Cancel all that, the new rewrite will do it properly by storing a discrete last name.

Thanks again to everyone who pitched in.

Last edited by lazlo (2014-10-13 00:19:37)

#32 2014-10-13 07:48:15

etc

Developer

Registered: 2010-11-11

Posts: 5,689

Website GitHub

Re: Help cleaning up bulky/slow sql calls

lazlo wrote #284742:

And that did work on my test site but my live site is on TXP 4.2 and it threw up a fatal error when try to go to the prefs file. I will be using this in my new revision though on TXP4.5:

Fatal error: Call to undefined function bouncer() in /home/talonboo/public_html/textpattern/lib/txplib_misc.php(594) : eval()'d code on line 52...

That’s it or csrf vulnerability, you’d better upgrade.

---

bloatware

#33 2014-10-13 07:52:01

gaekwad

Server grease monkey

From: People's Republic of Cornwall

Registered: 2005-11-19

Posts: 4,802

GitHub

Re: Help cleaning up bulky/slow sql calls

lazlo wrote #284742:

And that did work on my test site but my live site is on TXP 4.2 […]

This won’t help your immediate problem, but you need to upgrade soon. Background info here: www.cvedetails.com/vulnerability-list/vendor_id-5344/product_id-9097/Textpattern-Textpattern.html

Edit: etc beat me to it, and said it better.

Last edited by gaekwad (2014-10-13 07:52:29)

---

Textpattern CMS demo – tech updates

Code is Poetry; Text is Pattern.