Jump to content


Photo
- - - - -

First 5 members of OCC according to db


  • Please log in to reply
12 replies to this topic

#1 d6bmg

d6bmg

    BMG FTW!!

  • Members
  • PipPipPipPipPip
  • 3699 posts
  • Gender:Male

Posted 29 November 2012 - 04:21 AM

Today I got bored while browsing through different threads. I went to members tab and searched for all the members according to joining date.
What I got as teh first 5 members of OCC :
1. Overclock
2. Admin
3. Overclocking
4. Overclocker
5. Overclockers

:teehee:

Nomenclature problem? :evilgrin:
P.S. on the second last page, there are some accounts which have same nick (i.e. 'MICHAELharden' 3 times). So I guees something messed OCC up sometime. :woot:

boozei.gif


#2 Fragsman

Fragsman

    loco_frags

  • Members
  • PipPipPip
  • 646 posts
  • Gender:Male
  • Location:Argentina

Posted 29 November 2012 - 11:13 AM

Jajajajajaj admins where creaiting User_Test_Accounts I believe... all those Over.... seems to be for testing when this site was released.

Desktop: Intel i7 950 3.0Ghz / ASUS P6X58D-E / 6Gb DDR3 Patriot 1600Mhz / WD Black Sata3 1Tb 7200RPM / Samsung B2030 20" / EVGA 460gtx 1Gb / Sound Blaster X-Fi XtremeGamer / Edifier R133 / Thermaltake v9 Black / Cooler Master 700w / DVD RW+ LG Black 22x Sata / Corsair Vengeance 1500 Headset
Laptop: AMD Athlon 64x2 TK57 1.9Ghz // 4GBRAM // HD 120 Gb 5400RPM // ATI x1250 128Mb // 15.4" Screen

My Creation below

membergk7.gif


#3 Bosco

Bosco

    OCC Boss

  • Senior Admin
  • PipPipPipPipPipPipPipPipPip
  • 31469 posts
  • Gender:Male
  • Location:Canada

Posted 30 November 2012 - 10:00 PM

I am going to be doing a cleaning of users here soon, so some of that stuff will be removed.
Main Gaming Rig
Intel 2600K @ 4.8
Asus P8P67 WS Revolution
16GB of Corsair Vengeance
NVIDIA GTX 690
Corsair Force 3 GT 240GB SSD
Corsair 600T
H100 Cooling
Corsair AX1200 PSU
3 X 24" LCD's in Surround
Support OCC :::: Donating to OCC :::: DIGG OCC! :::: OCC Site Rules :::: OCC Reviews
RIP Verran gone but never will be forgotten.

#4 Andrewr05

Andrewr05

    "So big, so angry, so dead..."

  • Donated T5
  • PipPipPipPipPipPipPip
  • 10941 posts
  • Gender:Male
  • Location:Perkinsville, VT

Posted 30 November 2012 - 11:45 PM

I am going to be doing a cleaning of users here soon, so some of that stuff will be removed.

Will this change our user number if other users are deleted?

I have memorized mine, I can always link to my OCC User Profile, /index.php?showuser=18065 .


 
Rig specs: 

Spoiler


#5 EuroFight

EuroFight

    I'm not lazy, I'm just energy efficient.

  • News Editor
  • PipPipPipPip
  • 1279 posts
  • Gender:Male
  • Location:London, UK

Posted 30 November 2012 - 11:48 PM

Will this change our user number if other users are deleted?

I have memorized mine, I can always link to my OCC User Profile, /index.php?showuser=18065 .

You have a good memory - just checked Posted Image

Processor AMD FX-6100 Hex-core, 3.3GHz > Intel Pentium M 2.0GHz Single-core, 2.0GHz

Memory 8GB Corsair Vengeance DDR3 1600MHz > Hyinx 1.5GB DDR2 667MHz
Graphics Radeon HD7770 + Radeon HD5570 > ATi Mobility Radeon X600 400MHz Core
Motherboard Gigabyte GA-970A-DS3 Socket AM3+ > OEM Latitude D810 Motherboard Socket 479
Storage Seagate Barracuda 2TB SATA 7200.14 > Western Digital 80GB IDE 5400RPM
Power Supply Cooler Master Elite ATX 500W > OEM Dell Power Supply 90W

 

"Sudo make me a sandwich" - BluePanda


#6 Coors

Coors

    ????? ????

  • Members
  • PipPipPipPipPip
  • 3548 posts
  • Gender:Male
  • Location:Missouri

Posted 01 December 2012 - 12:50 AM

You have a good memory - just checked Posted Image


All you have to do is hover over the name and i twill show it, 87,281.

Foxconn Blood Rage X58 - i7 920 D0 4Ghz - 2x Powercolor 6970 PCS+ - 3x2GB Corsair Dominator GT 1600 - Intel X-25M 160GB - Hitachi Deskstar E7K1000 1TB - Enermax 1020w - CM 690II Advanced - HP ZR30w

Sager NP9170 - i7 3720QM - GTX680m - 16GB 1600Mhz - 4x Crucial M4 256GB - 17" matte display

Shuttle SP35P2V2 - E8600 4Ghz - eVGA 8800GTX ACS KO - 2x2GB g.skill PK - Samsung 500GB - 2x Dell E228wfp


#7 d6bmg

d6bmg

    BMG FTW!!

  • Members
  • PipPipPipPipPip
  • 3699 posts
  • Gender:Male

Posted 01 December 2012 - 01:52 AM

Will this change our user number if other users are deleted?

I have memorized mine, I can always link to my OCC User Profile, /index.php?showuser=18065 .


Actually it shouldn't.
Those id numbers are generally used as primary key for most of the tables in database, and that's why I guess it would not be possible.

boozei.gif


#8 Bosco

Bosco

    OCC Boss

  • Senior Admin
  • PipPipPipPipPipPipPipPipPip
  • 31469 posts
  • Gender:Male
  • Location:Canada

Posted 01 December 2012 - 12:54 PM

If I recall it stayed the same. But with new updates it might change when I tell the system to do a recount.
Main Gaming Rig
Intel 2600K @ 4.8
Asus P8P67 WS Revolution
16GB of Corsair Vengeance
NVIDIA GTX 690
Corsair Force 3 GT 240GB SSD
Corsair 600T
H100 Cooling
Corsair AX1200 PSU
3 X 24" LCD's in Surround
Support OCC :::: Donating to OCC :::: DIGG OCC! :::: OCC Site Rules :::: OCC Reviews
RIP Verran gone but never will be forgotten.

#9 bishop245

bishop245

    10 years @ OCC 02 to 12

  • Moderator
  • PipPipPipPipPipPip
  • 9533 posts
  • Gender:Male
  • Location:Oklahoma

Posted 01 December 2012 - 11:52 PM

Oh god not the DELETE button again. :ph34r:

#10 Black64

Black64

    Black It Out

  • Members
  • PipPipPipPipPip
  • 2793 posts
  • Gender:Male
  • Location:The internet

Posted 02 December 2012 - 12:25 PM

Will this change our user number if other users are deleted?

I have memorized mine, I can always link to my OCC User Profile, /index.php?showuser=18065 .



did not even know we had a use number.

Current System

[CPU]Intel Xeon W3670 (i7-970) @3.20Ghz---[CPU Cooling]Thermalright Silver Arrow---[MOBO]ASUS Rampage Gene III---[RAM]G-Skill Rip Jaws (24GB)(6x4GB)---[GPU]Gigabyte Radeon HD 6950 OC---[PSU]KingWin Lazar LZ-1000---[CASE]Bitfenix Colossus Venom Edition---[HDDs]WD Dives(6.5TB total storage) and Crucial 128GB SSD(boot)---[Monitors] 3X NEC 24" LCD2490WUXi ISP Panels 


PC 2.0 Audio System (Speakers) Triad InRoom Mini Pair - (Receiver) Marantz SR-4400 (Power Conditioning) - UltraPower PGX-500
My 5.2 Room Theater System (Speakers) B&W CDM 1NT Pair --- (Center) B&W CNT --- (Sub) 2X Polk Audio PSW Series PSW10 --- (Receiver) Rotel RSX-1057 --- (Power Conditioning) UltraPower PGX-500


 


#11 Overclocker16

Overclocker16

    Space for rent...

  • Members
  • PipPipPipPipPip
  • 2889 posts
  • Gender:Male

Posted 02 December 2012 - 12:44 PM

The dreaded delete button haha
"Why build one when you can build two at twice the cost?"
Infantryman are not an "Autonomous Mobile Biological Mine Clearing Device, Single Use"

If you can read this, thank a teacher. If you can read this in English thank a vet - Anonymous

#12 Andrewr05

Andrewr05

    "So big, so angry, so dead..."

  • Donated T5
  • PipPipPipPipPipPipPip
  • 10941 posts
  • Gender:Male
  • Location:Perkinsville, VT

Posted 02 December 2012 - 12:51 PM

I am going to be doing a cleaning of users here soon, so some of that stuff will be removed.



Oh god the the DELETE button again. :ph34r:

The dreaded delete button haha

:rofl:

Might I suggest deleting users in small clumps, then checking the database, then deleting in clumps.... etc


:teehee:


 
Rig specs: 

Spoiler