676 replies to this topic

[equilla]

Hi,

the NONSSL bit is peculiar to the tep_href_link function of osCommerce. To understand how it works you would have to examine the code for that function (its in /catalog/includes/functions/html_output.php if I recall correctly).

This parameter controls whether the output URL uses the secure, or non-secure form of URL for the link (i.e http://blahblah or https://blahblah). I seem to remember that if you omit the parameter the output defaults to non-secure anyway, so it doesn't matter if you miss it out.

Regards,

[elv1s]

Hi Equilla,

ok it worked..!

nex problem!

When i want to delete the oldest data and enter the nr. of rows i want to delete i get this error...

1064 - You have an error in your SQL syntax near 'ORDER by tracking_id ASC LIMIT 1' at line 1

DELETE from supertracker ORDER by tracking_id ASC LIMIT 1

[TEP STOP]


any ideas?

thanks
gr.
kasper

[busonero]

Hi Equilla,

it works.  thank you for this contribution.

it helps me a lot keeping track of visitors

sincerely

Roberto

[julianpuje]

julianpuje, on Aug 25 2005, 08:30 AM, said:

Hi

I've done the complete upload again and got a fresh binary GeoIP.dat file from the site. I ftp'd this folder in binary mode and still no luck. Exactly the same error.
Any ideas, thanks.

Julian

Fatal error: error traversing database - perhaps it is corrupt? in /home/julianp/public_html/includes/geoip.inc on line 416

<{POST_SNAPBACK}>

Hi again

Been through the install many times now with the same error. No idea why it isn't working, has anyone else?

Cheers
Julian

[equilla]

elv1s, on Aug 25 2005, 04:05 PM, said:

Hi Equilla,

ok it worked..!

nex problem!

When i want to delete the oldest data and enter the nr. of rows i want to delete i get this error...

1064 - You have an error in your SQL syntax near 'ORDER by tracking_id ASC LIMIT 1' at line 1

DELETE from supertracker ORDER by tracking_id ASC LIMIT 1

[TEP STOP]
any ideas?

thanks
gr.
kasper

<{POST_SNAPBACK}>

Hmm, this is an interesting one - I may have a clue on this, but can I just check how many rows were in the table when you did this and what number you entered (I'm guessing 1, but I want to be sure).

BTW - further posts will only be made in a couple of days as I will be away this weekend.

Regards,

[jugarte]

Great contrib Mark... congrats!!

First, sorry for my bad english...

Im having a little problem, but I know that this problem is becouse I have a different file stucture, I mean, my url is www.huntingadultflix.com, but I pointed this url to a html page with a warning message becouse I sell adult videos, so www.huintingadultflix.com is ranked #1 referring page becouse most of the customers are landing at my catalog/index.php through that html page.

The thing is that I want to know if its possible to make a modification to the supertracker contrib or to my html file in order to see the referring pages that customers are using to land at www.huntingadultflix.com.

Thank You!
Juan Ugarte

[equilla]

jugarte, on Aug 29 2005, 12:05 PM, said:

The thing is that I want to know if its possible to make a modification to the supertracker contrib or to my html file in order to see the referring pages that customers are using to land at www.huntingadultflix.com.

Thank You!
Juan Ugarte

<{POST_SNAPBACK}>

Hi Juan,

yes, I get the opposite problem - hits on custom pages I use just for myself that I don't want recorded - because I do what I'm about to suggest to you.

Unfortunately, you are using a html file, but if you could change that to a php file (still mostly just plain html in it though), so that you can include a single line of php to include application_top.php, then you should find that the session starts at your doorway page and all the data is then recorded correctly:

include (DIR_WS_INCLUDES . 'application_top.php');

The only other way I can think of doing it is more complicated and involves capturing all the details on the front  page and then POSTing them into the subsequent page (index.php), but this involves using php on the front page too, so I guess the first solution would still be the best one.



Regards,



Mark

[equilla]

Quick add-on to the above. If you can't change your front page name (e.g. index.html), why not change it to include an IFRAME which shows a new page called blank.php (for example)?  

This blank.php could then simply include application_top.php. Not sure if this won't generate error messages for one reason or another as I haven't tried it, and also I don't know if the referrer details, etc, would still be recorded properly, but there must be a solution similar to this that would work.

Regards,

[radders]

I think you could set up your htaccess to interpret an html page as being a php page so you don't have to change the name of it.

[elv1s]

equilla, on Aug 26 2005, 05:00 PM, said:

Hmm, this is an interesting one - I may have a clue on this, but can I just check how many rows were in the table when you did this and what number you entered (I'm guessing 1, but I want to be sure).

BTW - further posts will only be made in a couple of days as I will be away this weekend.

Regards,

<{POST_SNAPBACK}>

Hi there,

well there were about 380 rows in the table and i tried it with 200, 100 and 1. None of them worked..

Thanks again!
gr.
kasper

[kev@num]

does anyone know what's in the .dat file?

i've downloaded everything and it seems to work, i'm just a little concerned as i can't read the data inside the .dat file, and hope it's not connecting to anywhere and passing on some information from my site to someone...

i'm probably being silly, but i did find a "free" hack somewhere on here before and people posted that it was sending information out to the providers of the code..

hopefully it's just a DB and i'm being paranoid..

Edited by kev@num, 30 August 2005 - 12:37 PM.

[equilla]

kev@num, on Aug 30 2005, 08:36 AM, said:

does anyone know what's in the .dat file?

i've downloaded everything and it seems to work, i'm just a little concerned as i can't read the data inside the .dat file, and hope it's not connecting to anywhere and passing on some information from my site to someone...

i'm probably being silly, but i did find a "free" hack somewhere on here before and people posted that it was sending information out to the providers of the code..

hopefully it's just a DB and i'm being paranoid..

<{POST_SNAPBACK}>

Hi Kev,

Paranoia is good  
It's basically just a database which is loaded when the class declared in geoip.inc is called. If there was any "calling home" going on it would be in geoip.inc, rather that the .dat file. If you have a look at that file, you should be able to see how all this works and put your mind at rest.

Regards,



Mark

[equilla]

elv1s, on Aug 30 2005, 03:51 AM, said:

Hi there,

well there were about 380 rows in the table and i tried it with 200, 100 and 1. None of them worked..

Thanks again!
gr.
kasper

<{POST_SNAPBACK}>

Kasper,

Do you know what version of MySQL you have?

It could be that it doesn't like the lack of a WHERE condition in the statement. Perhaps you could try giving it one.

...On Line 63 of admin/supertracker.php, change the line to read as follows:-

$del_query  = "DELETE from supertracker WHERE tracking_id>0 ORDER by tracking_id ASC LIMIT " . $rows_to_delete;

If that doesn't work I will need to think again once I know what MySQL version you are running, as the supported syntax may be different to later ones.

Regards,

Edited by equilla, 30 August 2005 - 07:12 PM.

[soeren71]

Hi,

I`ve installed your contribution.

I`m not quite sure where I went wrong during installation. When I visit
admin/supertracker I see a totally blank page.

Any ideas how to fix this?

Thanks in advance.

Best Regards
Soeren

[equilla]

soeren71, on Aug 31 2005, 04:03 AM, said:

Hi,

I`ve installed your contribution.

I`m not quite sure where I went wrong during installation. When I visit
admin/supertracker I see a totally blank page.

Any ideas how to fix this?

Thanks in advance.

Best Regards
Soeren

<{POST_SNAPBACK}>

Hi Soeren,

are you using and administration modifications, such admin with access levels, etc. If so, I'm just wondering if the page is being blocked in some way because it hasn't been added to your list of allowed pages.

Another possibility is that you are using a browser in which this page doesn't render properly - it was checked in both IE and firefox, but I didn't go beyond that.

If the above draws a blank, perhaps you could PM me with some details so that I can see the problem for myself as I'm shooting slightly in the dark on this one.

Regards,

[elv1s]

equilla, on Aug 30 2005, 08:11 PM, said:

Kasper,

Do you know what version of MySQL you have?

It could be that it doesn't like the lack of a WHERE condition in the statement. Perhaps you could try giving it one.

...On Line 63 of admin/supertracker.php, change the line to read as follows:-

$del_query  = "DELETE from supertracker WHERE tracking_id>0 ORDER by tracking_id ASC LIMIT " . $rows_to_delete;

If that doesn't work I will need to think again once I know what MySQL version you are running, as the supported syntax may be different to later ones.

Regards,

<{POST_SNAPBACK}>

Hi again!

well i´m using MySQL 3.23.57

*****

i will try the code....

and...

i´m sorry doesn´t work...

Error:

1064 - You have an error in your SQL syntax near 'ORDER by tracking_id ASC LIMIT 95' at line 1

DELETE from supertracker WHERE tracking_id>0 ORDER by tracking_id ASC LIMIT 95

[TEP STOP]

any ideas?

thanks
gr.
kasper

[equilla]

elv1s, on Aug 31 2005, 04:13 AM, said:

well i´m using MySQL 3.23.57

<{POST_SNAPBACK}>

Hi Kasper

Well, I think that it is your MySQL version that is causing the problem (it was released over 2 years ago). I have read the relevant documentation for the DELETE function, and the above should have worked.....

So, basically there are 2 options - update your MySQL version, or experiment in something like phpmyadmin until you find something that works for your version. Unfortunately I don't have anything that old around to experiment for myself.

Regards,

[elv1s]

equilla, on Aug 31 2005, 07:34 PM, said:

Hi Kasper

Well, I think that it is your MySQL version that is causing the problem (it was released over 2 years ago). I have read the relevant documentation for the DELETE function, and the above should have worked.....

So, basically there are 2 options - update your MySQL version, or experiment in something like phpmyadmin until you find something that works for your version. Unfortunately I don't have anything that old around to experiment for myself.

Regards,

<{POST_SNAPBACK}>

Hi again,

well thanks anyway! I know it´s an old version.. but my provider didn´t make the update to a newer version..

So i guess i´ve to try and play with the code!

Thanks again man!

gr.
kasper

[homewetbar]

I'm getting it up and going, but it looks to be an excellent and useful contrib!

One suggestion, in the next release I would move the geo_flags directory to just images/flags to be consistent with visitors and other contribs that already use the flags.

I do have a question, from what I understand every visitor is logged. So in a site say getting 500+ or 1000+ visitors a day the lines can really add up, How often do you suggest deleting the tables to maintain optimal site performance?

Great work!

[equilla]

Hi,

many thanks for your feedback. I'm getting a few suggestions now and will certainly take them into account in the next release.

In answer to the question you posed, the simple answer is, I don't know. I think perhaps we have to draw on the experience from users of busier stores to gather that information...!

Regards,



Mark