WordPress.org

Forums

Referral? (23 posts)

  1. Tek
    Member
    Posted 11 years ago #

    I was looking around...
    Is there a plugin that will list which sites referred to yours? Maybe I am overlooking this.

  2. Mark (podz)
    Support Maven
    Posted 11 years ago #

    Or get DElyMyth's latest script for advanced tracking:
    http://www.delymyth.net/en/index.php?p=1007

  3. OperaManiac
    Member
    Posted 11 years ago #

    if u want an independent solution that works for everything including ur blog:
    http://stuff.techwhack.com/archives/2004/05/04/refer-from-textism/

  4. davidchait
    Member
    Posted 11 years ago #

    Yeah, I haven't made CG-Referer into a plugin yet -- probably shouldn't be too difficult to do, though I'd like admin interface options. If enough people want to see a plugin-version of CG-Referer, it should be nearly trivial. Lemme know! ;)
    -d
    http://www.chait.net

  5. davidchait
    Member
    Posted 11 years ago #

    Yes, I'm a idjit sometimes... I added some streamlined code for CG, but didn't think how it'd affect overall performance. Going to clean it up, make it an optional param, and will post back here when I have new version ready and up in a bit...
    -d

  6. davidchait
    Member
    Posted 11 years ago #

    Okay, new CG-Referer version is up. Should eliminate the performance issue, and now has count in parens after the name for topReferrers. ;)
    -d

  7. Beel
    Member
    Posted 11 years ago #

    Yep, much better. Also seems to have cleared up the "disappearing menu" problem. Probably something to do with wrapping.

  8. davidchait
    Member
    Posted 11 years ago #

    Good, glad to hear it! Yeah, I had [span] instead of [/span] closing elements, but in the inline-results use of the code (and not the direct-URL-to-refererLib use) that code shouldn't have gotten touched.
    Basically, I added a few major things in the past few weeks:
    1. the direct-URL globals (URL params) are now all wrappered, meaning there will be no further conflict with other plugins.
    2. the formatting for direct-URL referrer lists (top and last-X) now uses a table layout for easier reading.
    3. the direct-URL referrer lists use an optional param to the two functions, that specifies to look-up queries in EACH referral, and if there is a query, [span] around the domain name so that queries vs referrals can be CSS styled differently.
    4. there's now a URL param to show IP addresses in the last-X referrals listing, good for seeing spammers to block...
    That's off the top of my head, I'm sure there's more!
    -d

  9. davidchait
    Member
    Posted 11 years ago #

    For anyone tracking, I just put an updated release up on the CG-Referer download page. It resolves some serious performance issues with topReferer listings (now near-instantaneous, and single-DB-query). Anyone doing a top-referer sidebar wants to grab this update.
    -d

  10. davidchait
    Member
    Posted 11 years ago #

    To improve on storage use for the referral tracking, I've just added improved unique-IP tracking and also now check if the given referral is already in the database for today (and thus is a duplicate, so don't re-log the same person, same referral). This is good as it eliminates sometimes getting 3-5 hits in the DB from the same user coming from google to the same page multiple times, or someone else doing back and forth and thrashing referrals.
    Up in the usual place,
    -d
    CHAITGEAR

  11. Anonymous
    Unregistered
    Posted 11 years ago #

    Hi,
    English is not my real language so excuse me for the mistakes.
    I used WP 1.2 and its runs correctly.
    I tried to install this kack but my homepage (http://www.blogdunum.net) (work in progress) doesn't show me this message :
    Database error: [You have an error in your SQL syntax near '(NOW(), visitTime)==0 AND userIP='xxx.x.xx.xxx' ORDER BY visitTi' at line 4]
    SELECT * /*DISTINCT userIP */ FROM referer_visitlog WHERE DATEDIFF(NOW(), visitTime)==0 AND userIP='xxx.x.xx.xxx' ORDER BY visitTime DESC
    Database error: [You have an error in your SQL syntax near '(NOW(), visitTime)==0 AND userIP='xxx.x.xx.xxx' ORDER BY visitTi' at line 4]
    SELECT * /*DISTINCT userIP */ FROM referer_visitlog WHERE DATEDIFF(NOW(), visitTime)==0 AND userIP='xxx.x.xx.xxx' ORDER BY visitTime DESC
    Can you explain me what's wrong ?
    Thanx a lot.
    Luc

  12. symantix
    Member
    Posted 11 years ago #

    Yesterday I downloaded and installed several of the scripts that have been suggested on this thread and a couple others. Some of them were nice, some not so hot.
    But I can't believe that more emphasis hasn't been put on the script that podz has recommended above. That was the last one that I installed, and it is the best by far.
    WP DStats 2 is the only script that is a true plugin for wordpress. It gives very detailed results, and is very easy to use.
    Here's the link again:
    http://www.delymyth.net/en/index.php?p=1007

  13. davidchait
    Member
    Posted 11 years ago #

    Luc:
    It has to do with a change I made not working with pre-4.1 MySQL. I just uploaded a new version of CG-Referer -- download and try that. I hate all the possible versions of web hosting apps!
    symantix:
    Just to be clear, a "true plugin for wordpress" is an extra single file in the plugins directory. That's the only difference. ;) I just haven't done it yet for Referer as I wanted to add some UI and there isn't yet a 'recommended' method.
    CG-Referer has been used by me for six months, others for the last three, quite successfully. It is meant for referrer and usage tracking, but not as much (at least, not yet) for 'stats' pages. It does last-n, top-n, and recent-search listings (extensive query-string identification coe)also does full search-query lists, unique ip tracking, daily/weekly/monthly counts, etc. Well suited for short sidebar/menu entries, or admin-level tracking pages.
    -d

  14. davidchait
    Member
    Posted 11 years ago #

    No offense taken -- I just want new people to understand that the difference between a 'hack' and a 'plugin' when it comes to an external data system is nearly irrelevant. ;)
    Most importantly, I DO appreciate that you appreciate my time and effort! To that end, if you have/had problems with my scripts, PLEASE contact me or post here and let me know specific details, as I strive to keep these scripts updated and functional, and I can't fix problems I don't know about. ;)
    The problem I introduced was trying to better scope daily-unique checks to a date and not a 24h period, and DATEDIFF is apparently only available in MySQL 4.1 or later. My bad was not realizing that my staging area for CHAITGEAR ignores me as a referrer in all cases, whereas if I had tested it against my WP1.2 test site the bug would have shown immediately.
    Ahh, such is the fun of rapid releases with little testing. ;)
    But again, do let me know if you had a particular problem with CG-Referer, so that I can look into it. Thanks!
    Regards,
    -d

  15. davidchait
    Member
    Posted 11 years ago #

    BTW, just put a new version of CG-Referer up on the site. Beel pointed out that all the fun new html-clean string generation I recently added for CG-Feedread wasn't being done at all in CG-Referer -- so I moved the CGFR functions into the helper_fns.php file (for all my libraries that use it), and updated CG-Referer code to try and cover all the places I thought needed strings to be cleaned for output.
    Should cover things like ampersands, etc., in search string histories.
    -d

  16. Anonymous
    Unregistered
    Posted 11 years ago #

    Hi,
    Thanx a lot David for the script and your answer.
    Luc.

  17. davidchait
    Member
    Posted 11 years ago #

    No problem, glad to help.
    BTW, I just put up another even newer CG-Referer version. I tweaked some of the query handler functions to deal with a new form of google query string, and to deal with null query terms better. No rush (not critical), but will look better if you use getRecentSearches and have people coming from google a lot...
    -d

  18. davidchait
    Member
    Posted 11 years ago #

    Sheesh, when I start coding... I can't stop!
    Yet NEWER version up, same old location. Added new bot detection strings (should catch lots of blog bots too, and anything following 'protocol' for identification), bot access tracking, and bot history listings. Updated docs with examples of flushing via the blacklist (which also makes sure bot entries are tagged), as well as direct-load examples for admin listings of top referers, recent referers, and recent bots.
    -d
    CHAITGEAR

  19. Beel
    Member
    Posted 11 years ago #

    I am getting used to my daily morning cup of coffee and my daily evening update of chaitgear hacks.

  20. davidchait
    Member
    Posted 11 years ago #

    I gotta feed the CHAITGEAR addicts out there! ;)
    -d

  21. Anonymous
    Unregistered
    Posted 11 years ago #

    Ups... Trying to dl your script I've got:
    Forbidden
    You do not have permission to access this document.
    --------------------------------------------------------------------------------
    Web Server at chait.net

  22. davidchait
    Member
    Posted 11 years ago #

    I'll look into it. CHAITGEAR is in the midst of relocating to a new server as the old server was down over 24h total in about two weeks... ;)
    -d

  23. aleeya
    Member
    Posted 9 years ago #

    I really love CG-referer. I had planned on using a service online to decipher my logs, but this is exactly what I needed. (I had tried hits link, but the code used by them was not xhtml valid and I am new to XHTML as well, so I was not able to "fix" it.

    I am using it at http://beta.aleeya.net and http://www.girlgeekette.net

    The one thing I wanted to do (and was able to figure out how - I am still new to php and mysql) was to change the number of referals shown.

    I would love it if I was able to click on the Columns in the cg-referrer.php page (id, time, ip, req, domain, query, engine, etc) so I could "order by".

    That way for example, If I wanted to group ALL of an IPs hits, or group all of the search for's in abc order, all of the info would be in that order. I am still trying to figure out how to make the top ID of each column linkable so when I click, it groups in ascending or decending rows in order by that column.

    As I said, I am pretty new to php and mysql.. and I am not sure I have used the correct wording to convey what I am trying to do. I just thought maybe I would ask to see if there is a way to do it, or if it might be a feature you would consider adding in the future.

    I really like your plug in and apprecate your time in making it. It has saved me a lot of time and trouble!

Topic Closed

This topic has been closed to new replies.

About this Topic

Tags

No tags yet.