[wp-hackers] getting a pageview from the wp_links links
Dion Hulse (dd32)
wordpress at dd32.id.au
Thu Apr 12 04:48:12 UTC 2012
for future planning.. You'd be better off making a Custom Post Type
and storing the news articles in that instead, An extra 55k records is
not going to be a significant impact if stored as a CPT rather than a
post, the MySQL indexes will take care of separating it easily, you'll
also gain a lot more template functionality than you will with the
links table (As it's not designed to be queried, simply, displayed)
The future for the wp_links table is death IMO, It's not used by most
people, and is probably the one component in WordPress that I advocate
be removed and put into a plugin.
the Links table was introduced as a "Blogroll", back in the early days
of blogging as a "Here's a short list of my friends and my
relationship to them", not a "Here's thousands of links to external
sites that you can search through".
On 12 April 2012 09:23, Haluk Karamete <halukkaramete at gmail.com> wrote:
> Here is my solution to this
> Use the wp_links" table's "link_notes" field to store the excerpt of the
> linked article.
> Do NOT use the "link_url" for storing the "external link url".
> Instead store the following URL; ( or something like that )
> Store the "external link url" in the wp_links' link_description field.
> ( Hopefully the URL would be less than 255 or you are toast. )
> Let your-custom-page do a look up on the link_id passed thru the
> Do a db look up into wp_links to get to external url link and the excerpt
> and do the necessary.
> This approach solves my problem.
> Unless anybody throws his 5 cents into this and offer a dramatically better
> solution, I will go with this approach.
> On Wed, Apr 11, 2012 at 2:56 PM, Oscar Gonzalez <rakxzo at gmail.com> wrote:
>> Ah... well, maybe rewrite all links to a permalink structure like
>> .../out/... from where you link them out for good? And then you have
>> to display our content on that link... like
>> ../out/wwwmyawesomelinkcom/ and the linnk out would be contained within.
>> Maybe custom post types would help?
>> On Wed, Apr 11, 2012 at 2:49 PM, Haluk Karamete <halukkaramete at gmail.com>
>> > I thought about that. It also has much larger field link_note. I don't
>> > a problem much with where to store the description / excerpt. Currently,
>> > you click on the link, you are out, heading towards the other web site.
>> > Links do not have a local url - cause they do not have a slug to begin
>> > with.
>> > I'm trying to get an extra click/page impression. Any ideas for that?
>> > On Wed, Apr 11, 2012 at 1:38 PM, Oscar Gonzalez <rakxzo at gmail.com>
>> >> Doesn't the built in facilities for links have a description field you
>> >> can use as the link excerpt summary? why wouldn't you use this and
>> >> display them in a custom view?
>> >> On Wed, Apr 11, 2012 at 11:51 AM, Haluk Karamete
>> >> <halukkaramete at gmail.com> wrote:
>> >> > I got 55K links to various news sources ( I should say to various
>> >> external
>> >> > articles ) accumulated over the years in the home grown CMS that
>> >> _______________________________________________
>> >> wp-hackers mailing list
>> >> wp-hackers at lists.automattic.com
>> >> http://lists.automattic.com/mailman/listinfo/wp-hackers
>> > _______________________________________________
>> > wp-hackers mailing list
>> > wp-hackers at lists.automattic.com
>> > http://lists.automattic.com/mailman/listinfo/wp-hackers
>> wp-hackers mailing list
>> wp-hackers at lists.automattic.com
> wp-hackers mailing list
> wp-hackers at lists.automattic.com
More information about the wp-hackers