[wp-hackers] getting a pageview from the wp_links links

[Dion Hulse (dd32)]

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.
http://core.trac.wordpress.org/ticket/18781

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 )
>
> http://yoursite.com/your-custom-page/?link_id=WHATEVER_THE_LINK_ID_IS_FROM_THE_WP_LINKS_TABLE_FORTHAT_LINK
>
> 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
> query_string.
> 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?
>>
>> OG
>>
>> On Wed, Apr 11, 2012 at 2:49 PM, Haluk Karamete <halukkaramete at gmail.com>
>> wrote:
>> > I thought about that. It also has much larger field link_note. I don't
>> have
>> > 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>
>> wrote:
>> >
>> >> 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
>> I'm....
>> >> _______________________________________________
>> >> 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
>> 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