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

[Haluk Karamete]

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
>