Not logged in [
Login
-
Register
]
You Are Not Registered Or Not Logged In
Corsa Sport
»
Message Board
»
Off Day
»
Virgin media
» Post Reply
Post Reply
Who Can Post?
All users can post new topics and all users can reply.
Icon:
Formatting Mode:
Normal
Advanced
Help
Andale Mono
Arial
Arial Black
Book Antiqua
Century Gothic
Comic Sans MS
Courier New
Georgia
Impact
Tahoma
Times New Roman
Trebuchet MS
Script MT Bold
Stencil
Verdana
Lucida Console
-2
-1
1
2
3
4
5
6
White
Black
Red
Yellow
Pink
Green
Orange
Purple
Blue
Beige
Brown
Teal
Navy
Maroon
LimeGreen
Message:
HTML is Off
Smilies are On
BB Code is On
[img] Code is On
[quote][i]Originally posted by Ian[/i] [quote][i]Originally posted by xa0s[/i] ive had the same IP for 3 years[/quote] mysql> select concat(substring_index(useip,'.',3),'.x') as useip, count(*) as count, from_unixtime(min(dateline),'%d %M %Y') as mini, from_unixtime(max(dateline),'%d %M %Y') as maxi, (max(dateline) - min(dateline))/(60*60*24) as diff from posts where author='xa0s' group by useip order by dateline asc; +---------------+-------+-------------------+-------------------+----------+ | useip | count | mini | maxi | diff | +---------------+-------+-------------------+-------------------+----------+ | 86.7.137.x | 78 | 04 March 2008 | 20 March 2008 | 15.7542 | | 212.69.44.x | 2 | 03 June 2008 | 03 June 2008 | 0.0274 | | 92.12.38.x | 33 | 31 May 2008 | 09 June 2008 | 9.3264 | | 86.7.140.x | 922 | 02 April 2008 | 02 January 2009 | 275.4456 | | 92.11.110.x | 3 | 15 June 2008 | 17 June 2008 | 1.9879 | | 92.10.19.x | 1 | 22 June 2008 | 22 June 2008 | 0.0000 | | 167.206.189.x | 116 | 09 July 2008 | 04 August 2008 | 26.0286 | | 192.165.213.x | 43 | 05 August 2008 | 12 September 2008 | 38.0176 | | 149.254.192.x | 5 | 10 October 2008 | 19 October 2008 | 8.8339 | | 149.254.192.x | 1 | 12 October 2008 | 12 October 2008 | 0.0000 | | 92.12.27.x | 5 | 01 November 2008 | 02 November 2008 | 0.9377 | | 92.12.76.x | 18 | 04 November 2008 | 10 November 2008 | 5.6938 | | 92.11.113.x | 1 | 11 November 2008 | 11 November 2008 | 0.0000 | | 92.12.139.x | 26 | 13 November 2008 | 14 November 2008 | 1.9693 | | 92.12.128.x | 5 | 17 November 2008 | 21 November 2008 | 3.3636 | | 92.11.255.x | 9 | 26 November 2008 | 01 December 2008 | 5.8290 | | 92.10.14.x | 7 | 04 December 2008 | 05 December 2008 | 1.1693 | | 92.12.193.x | 1 | 17 December 2008 | 17 December 2008 | 0.0000 | | 90.221.251.x | 27 | 21 January 2009 | 24 January 2009 | 3.0024 | | 92.12.92.x | 1 | 23 February 2009 | 23 February 2009 | 0.0000 | | 92.9.184.x | 19 | 28 February 2009 | 28 February 2009 | 0.4083 | | 92.12.120.x | 2 | 16 March 2009 | 16 March 2009 | 0.0350 | | 86.7.138.x | 1091 | 09 January 2009 | 14 September 2010 | 612.3959 | | 92.13.219.x | 2 | 06 July 2009 | 06 July 2009 | 0.0547 | | 92.9.78.x | 1 | 25 September 2009 | 25 September 2009 | 0.0000 | | 92.13.149.x | 2 | 06 December 2009 | 06 December 2009 | 0.0012 | | 92.13.73.x | 2 | 07 December 2009 | 07 December 2009 | 0.0496 | | 213.105.74.x | 289 | 18 October 2010 | 23 February 2011 | 128.6569 | | 86.7.138.x | 80 | 24 February 2011 | 08 April 2011 | 42.7861 | | 86.31.107.x | 612 | 09 April 2011 | 23 December 2011 | 257.5334 | | 86.25.58.x | 12 | 24 December 2011 | 29 December 2011 | 5.1531 | | 86.7.141.x | 65 | 10 January 2012 | 23 January 2012 | 13.4442 | +---------------+-------+-------------------+-------------------+----------+ 32 rows in set, 1 warning (0.04 sec) [Edited on 23-01-2012 by Ian] [/quote]
Post Options:
Disable smileys?
Turn BBCode off?
Receive email notification of new replies?
This is a long topic, click
here
to review it.