GetCOUNT started when i was curios who
visited my website. When i can understand the HTML
codes and CSS codes i totally can't see who
pass by my website and felt the need to learn how
to make it. Thru searching the net after came home
from work. I found some one writing javascript for
user details. But this create problem on how to
add to the database.
So I spend time searching another version of detect
USER passing by and at the same site I found PHP OS
script which generates all user details. I try it
out at work or home both show the correct
information. Again this was not enough I again
wondering how to get country or cities where user
pass by and capture it.
Searching the net long time and found a free PHP
script which calculates base on user IP capture and
denotes it to Country，cities, longitude, latitude
and many other details but I am only interested in
country name and cities which are good enough.
A full set of details seems to be the country name,
cities, operating system, web agent used. So I went
on to create the table in PHP SQL and try inserting
it each time user pass by it add into the SQL table.
A lot of script being modified to store in so many
details.
I place it on my website and found very few people
pass by and thus table show few lines. I thought the
counter was good enough.Then I got a hunch what if a
lot of people pass by a site would my table SQL
script crash. I decided to put it to test my company
website.
After trying only a week I found a lot of visitors
wow. So many data coming in. I become wondering what
another date I can mine. So I explore the PHP site
providing me the IP calculation base detector
script. Mindlessly I try to add all info into my
table. Country Name, Code, Cities, Longitude,
latitude, Computer OS, Web agent use.
After some time I forgot to add date but found out
that the date system does not let me query out which
date or time in one string. I ended up studying all
script in the net and found that all are hiding the
answer but the top link got the answer which is PHP
manual. The is hard to understand but I spend lots
of time reading it and trying it until its good.
I finally can get which date to query out and which
time , months, and more. Again I had a thought what
about computer name of a user, that make me search
the google very long and still end up with nothing.
Totally restricted with PHP, javascript. Although
javascript can write an active x and user click yes
will show, i can't let user click yes or no
They will scare it is the virus and close the site.I
gave up on that finding user's name. I thought of
using facebook but it also asks user to click token
yes which also will make the user go away.
After long running to about 9000 visitors from my
company website something happen the script show CPU
limit reach. I was the jam that time tie to my work
and unable to solve. So I ended up see my site
manager think that I can go in, which end up can't
go in I have to reset the whole account and
re-upload all the files and remake tables data.
This makes me learn that I SQL table have to rebuild
each time when you insert into it. Each insert will
eat up the resource with my script. Furthermore each
query out will also increase the CPU usage. I
totally can't solve for few weeks, Urgently I see my
company's website server and notice that.
With Paid server it will have a link on CPU usage.
ended up no choice but to upload little of my script
to test the CPU and see. Each test I learn that CPU
easily spikes when the table hit thousand or
more.like that I can't insert any more data after
few thousand.
I search the web for CPU limit answer and many links
behind show an expert saying see advance SQL
script.I read and read don't understand much and
found one script the FREE memory script for my SQL
and try on it. WOW, the CPU is like stuck at lowest
not even seen that it spike and reduce.
Totally seamless when the user queries few thousand.
happily thought that my script is perfect and again
I proceed counting my company user pass by. A few
months later again the CPU limit show up I was
shocked and not knowing the answer to this.
leaving the site close I went searching and
searching for the answer. Time pass I found a site
with and USER facing the same problem and another
user hinting him that try reading bank transaction.
With the thought, Bank must be running some expert
script.
I ended up the site is my SQL manual. Great, i know
how to write some simple PHP script and can run SQL.
And I actually don't know how to use this my SQL
manual.luckily there is search. But don't know what
to search for.
Without any name to search I go back to google and
search BANK transaction SQL. finally got the term
and headed back to my Manual. The page shows answer
hard to understand. No choice but to cut some words
and try searching for examples.
I search long hours ended up with no examples.
Leaving me no choice but to go back and read that
full page. Not understanding for weeks, I pass my
time while working. Suddenly I decided to try the
script with a guessing on understanding.
Try it and without errors, i can now test if hitting
10 000 visitors, but still this kind of number has
to wait for visitors to pass by another 9 months
pass and the final show down 10K visitors pass the
mark and nothing went wrong.
This proves that the bank script was useful. I can
now understand that forum and another site can do
this kind of insertion without jamming their server.
In AD.2012
Near Sep 2012
I decided to make improving
like I saw GOOGLE MAP API and decided to try adding
it. I try out their script and found that it need
Longitude and latitude which luckily I add all
details from IP calculate script.The Map was shown
with the arrow. But a funny thing happens my dot is
at the sea.
Running a few try and error and found out
the longitude and latitude was on opposite site. Now
I know whenever the map show dots on a sea. It means
my value got to reverse. Some days later I search
the web and found that there is a chart js free for
use. And spending some time I added the 2D chart to
my counter.
With the visitor counter completed. Another
question went into my mind I can see the world but
which date the visitor pass by I can't see I have to
create a calendar to select the date to query. Which
in the old days I try to create a calendar with JS
script and it works refining the query I get which
month I like to query out.
In mid-2013
I saw GOOGLE CHROME GLOBE view I
would try to send data in to map the globe but it
say only in chrome which cant be used on all device.
hope in near future someone did a link for JS to
connect OPEN GL and can draw anything.
Using google map daily I saw that each click can pop
up a ballon for a user to see and click hotel web
page. So I decided to add this function to each city
and can click on that cities. At first, it was
little information to see. slowly I redo my PHP
script to open few more connection and query all
data in.
Finally, a cluster information was created. simple
world map which was selected and another map with
that selected cities zoom in and look into it. With
total visitors came across and which Operating
system lastly which Web agent they use. It was fun
using this data mined. But still, all data mostly
come from my company web site.
Slowly I learn that not many people visit a site
create. Rather it is the product or service they
need to search to find that site. Which I don't sell
items or service. And it came to me that only a
company running can data mine.
In AD.2013
As time goes by I felt that there is something
missing the number keep increase each time 1 person
enter or bots enter. I decided to add cookie to act
as a reminder so that same person or bot enter won't
increase the number
Simple cookie takes time to start and end up with an
array of cookie but this creates problem like this
page can't print out cookie. I found out that the
cookie needs to set path and domain so that it can
be store and call out.
With some modification I have altered it to the only
record once till 00:00 am it will let the same user
record again. this way the number is reduced greatly
to 24 hours till midnight next day.
In AD.2013 DEC
As I left my company after 7 years 9 months I got
bored at home playing forex and finding jobs so I
decided to try out the WEB GL which chrome introduce
and finally the WEB GL has moved up to OPERA,
MOZILLA and I think all WEB KIT can support .
Trouble fill my head
For IE10 it does not have WebKit luckily I found out
that IE11 is fully from Mozilla standard hope the IE
11 will be like chrome,firefox,opera able to support
WEB GL. SO I start the programming of it.
After studying the script found out that some
trouble with token must be the directory with
default \globe\ when I change I get token access
error and I change back the directory it will work
funny error I try searching to change the globe in
all js can't find any.
Then came the jason problem it has to be in a file
jason which I do not want it so i change the ajax to
just var [][][] and using my php script insert into
javascript it still work. There came my chrome Globe
GL
After downloaded the developer edition for WIN 8.1 I
tested out the IE11 on chrome globe and it works it
did show the globe and spinning but the IE 11 has a
bug it cannot scroll in and out when does that the
globe disappears.
Funny thing is that when I lend my old colleague's
phone to test safari is WebKit base yet it fails to
load. maybe future safari will add WEB GL support.
After some study WEB GL came from WEB open GL which
some one else wrote the engine there is 3 type I
think the three.js is by google the.
I decided to try to change the index rod which cant
see info. Need lots of time to change the index rod
into human.png and on click drag out the info window
In AD.2015 FEB
I mange to learn a bit of the THREE.js and map a
texture my human.png to the box but facing difficult
as it will map all side.
Unable to made changes to the rod its size i manage to just put like this and decide to make it short to see the human png photo
Since i can't change much i decided to add another
thing set timezone to the scripts which capture
exact time of client insert SQL and display SQL
I firstly tested with 000webhost it crash now with
by those see any difference. After testing it seems
only can be added to 1 place add SQL but when read
SQL it seems hang the other
2-May 2015
I was trying out 3D three.js but
end up causing the SQL to overload.
While troubleshooting to found out SQL
overload i end up changing my DNS records just to
find out whats wrong
When back to my own site the server lock me
up. Which I got no choice but to redirect back to my
PC
Then and idea come up recently I bought
cisco router and I have to reconfigure ip6 to 4 to
have the internet. That become reverse I put my DNS
record to my ip6 house become the ip6 website.
The site can't be reached by the world thus can
research how to decode ip6 and find country and
info.
I end up with only decoding ip6 to decimal and ip6
country compare and isp nothing else
Also, my ajax script new XMLhtpp fail to grab data
back.
this makes me have to write everything back to SQL
to compare data. instead of easy CSV to array
12 JULY 2015
After installing the latest
windows 10162 it comes with Microsoft Edge and I
test it out seems that it do no t support proxy
server
After playing around another funny thing the
web agent show chrome and detect as WebKit which is
no longer Mozilla
The site still works except calendar still
freeze until 5 min then regains normal.
06 SEP 2015
During my developing of WishJS, i
manage to get the push notification up thru simple
ways. Then I thought of my main getcount site.
I can implement the push notification 5 sec
script in here. Without the buying refresh page keep
spinning.
First, I will touch the Counter after ADDing
to the Table it only show once the latest counter
index. Which will stay not updated?
Changing to push every 5 sec will keep
getting the latest update. So does all my chart in
my SYSTEM I can change al.
16 Sep 2015
I found that my world map by
google has upgraded with the drag and drop human.
This is common but I saw that my map is more
colorful upon looking at it I see
google has scanned more deeper with coral
reefs. Wow i wonder in future the map will be more
colorful with GEO data around the sea and land
corners
Terrain might will have details with
satellite eyes view
In AD.2016
News shows that the satellite map is upgraded to 700
Trillion pixel and I zoom to see wow so detail even
my roof top can be seen
The edges of sea and land are even clearer.
One day I think I can even see my self on the road
if it goes, even more, pixel
After experience lawyer letter of 1 picture claim, I
decided to change a name that google cannot even
find like getcount.
28 Sept 2016
I was trying to get XML HTTP to
query free app for proxy isp provider and so on...
End up all fail lots of try and error no fun. No
choice but to look at the example of others and
found that.
There is curl script that i can call like
XML HTTP and it is super fast not even 1 sec loading
and not even have to wait for return which i find it
stupid to implement XML HTTP
still, it has value like passing javascript
screen x y to PHP. But there is still error when
getting value funny thing is that a blank space can
parse to PHP was ok yet after curl query it cannot
parse over
end up I replace all space and able to send
into PHP. So I carry on and try to find proxy
detection after searching found the answer and I add
into the table. To my surprise, there is even local
IP and local language.I end up adding all this to my
table.
I saw some computer hiding its local IP so I search
and found answer not bad to run squid proxy server
at home.
now I have created those count for the new findings.
I can have a glance just that no more visit to
increase my data mining.
In AD.2017
18 JAN 2017
I manage to test run webcam
script and audio input script. knowing only when
user press allow then the device name is capture
this script can only get device hash id or hex id.
still i wish to add in and capture hex id
althought it cannot be decrypted. But i find it hard
to make it cross browser unless using flash.
still need help from web to decode it and
capture as raw visit and update table. Atleast
making my detection script more feature...screen,
proxy, webcam, mic,
Hope i can think of more detection like usb.
which is fun
16 APR 2017
During holiday i improve my
getcount php. Since i can get interval drop with
latest data. I deploy it to my getCount
Slowly i will make all into Xmlhttp request
to existing php so that i can separate php from html
design. As php is for query data, HTML is for design
Also before this i manage to learn and add
security to my php and lock up only same domain can
query php not sure if done correctly.
so meaning it should be safe to query php
inside my own webserver without other people query
the php out. But still when type to URL i see all
data instead of hidden.
1 MAY 2017
Holiday again sick and bored so
decided to google ways to hide php echo output and
allow only xmlhttp
At first found many script to help hide echo
php on browser. And manage to print something else
on browser.
But end out my xml http request fail to
collect data and display nothing. With some
understanding the requirement is not ment or if
statement is not true
After some google found the answer to get
true when xmlhttp request and my data is display out
correctly.
In AD.2018 MAR
31 MAR
Some how the map ended need API key and api key need send biling info which i am scared of bomb.
