Path: csiph.com!usenet.pasdenom.info!gegeweb.org!usenet-fr.net!nerim.net!novso.com!newsfeed.xs4all.nl!newsfeed3.news.xs4all.nl!xs4all!newsgate.cistron.nl!newsgate.news.xs4all.nl!post.news.xs4all.nl!not-for-mail
MIME-Version: 1.0
In-Reply-To: <l31fg6$d8b$1@dont-email.me>
References: <l30lbg$etp$1@dont-email.me> <l319sl$cl6$3@dont-email.me> <l31fg6$d8b$1@dont-email.me>
Date: Tue, 8 Oct 2013 13:47:14 -0400
Subject: Re: Cookie gets changed when hit comes from a referrer
From: Joel Goldstick <joel.goldstick@gmail.com>
To: =?UTF-8?B?zp3Or866zr/PgiDOkc67zrXOvs+Mz4DOv8+FzrvOv8+C?= <nikos.gr33k@gmail.com>
Content-Type: text/plain; charset=UTF-8
Content-Transfer-Encoding: quoted-printable
Cc: "python-list@python.org" <python-list@python.org>
Precedence: list
Newsgroups: comp.lang.python
Message-ID: <mailman.870.1381254441.18130.python-list@python.org>
Lines: 49
NNTP-Posting-Host: 2001:888:2000:d::a6
Xref: csiph.com comp.lang.python:56436

On Tue, Oct 8, 2013 at 1:30 PM, =CE=9D=CE=AF=CE=BA=CE=BF=CF=82 =CE=91=CE=BB=
=CE=B5=CE=BE=CF=8C=CF=80=CE=BF=CF=85=CE=BB=CE=BF=CF=82 <nikos.gr33k@gmail.c=
om> wrote:
> Is there any better way to identif a previous visitor? i tried cookies wh=
ich
> failed for me for the reason i opened this thread and host like follows:
>
>                 # try to locate the visitor
>                 cur.execute('''SELECT * FROM visitors WHERE counterID =3D=
 %s
> and host =3D %s''', (cID, host) )
>                 data =3D cur.fetchone()
>
>                 if not data:
>                         # if first time visitor on this page, create new
> record
>                         cur.execute('''INSERT INTO visitors (counterID,
> host, city, useros, browser, ref, lastvisit) VALUES (%s, %s, %s, %s, %s, =
%s,
> %s)''',
>                                                    (cID, host, city, user=
os,
> browser, ref, lastvisit) )
>                 else:
>                         # since visitor exists just update his record
>                         cur.execute('''UPDATE visitors SET city =3D %s, u=
seros
> =3D %s, browser =3D %s, ref =3D %s, hits =3D hits + 1, lastvisit =3D %s''=
', (city,
> useros, browser, ref, lastvisit) )
> =3D=3D=3D=3D=3D=3D=3D
>
> Please tell me if you can think fo something else.

Yes! there is a very simple and comprehensive way to learn about your
visitors.  Use Google Analytics.  Its free, you only need a google
account to open an analytics account.  They give you a small bit of
javascript that you copy and past to your pages.  If you are using a
template to create your pages, this is easy, since you just add google
code to the template.
>
> --
> https://mail.python.org/mailman/listinfo/python-list



--=20
Joel Goldstick
http://joelgoldstick.com