1,00,000 CEans Counter

@abrakadabra • Oct 18, 2024

Oct 18, 2024

1.2K

Soon we would be 95,000 CEans community.
I think we should create a counter for the last 1000 CEans and display it above the forum. It would be fun to watch it decreasing...till it hits the 6 digit number.

Plus, the new CEans will be aware that we are very near to the 1 lac mark and might join us on the 1,00,000 CEans Day (or Night) Celebration. 😒

What say everyone? Need your ideas and feedback.

@CS/IT Engineers: Could anyone make such a script that can be embedded on the forum page?

Like 0 Replies 33

Replies

Welcome, guest

Join CrazyEngineers to reply, ask questions, and participate in conversations.

CrazyEngineers powered by Jatra Community Platform

Neema Ambhurkar

@neema-SlYG3w • Apr 16, 2011

Yes, that would be great!
Awaiting for the CEans Day (or Night) Celebration! 😁
Mr.Don

@mrdon-92OwlG • Apr 16, 2011

Good Idea ABKD.
ISHAN TOPRE

@ishan-nohePN • Apr 16, 2011

By the time I am writing this post we are 94,996 member strong community. Just 4 more to go to reach 95K figure. That is really a nice idea. Let us make counter to measure up to 100001.
Ankita Katdare

@abrakadabra • Apr 16, 2011

I am looking for making it a cool looking counter. Something that will start with 99000 and end with 1,00,000. Each time a member registers, the digits will flip animatedly.
Anybody with experience on how to do it?
Ankita Katdare

@abrakadabra • May 5, 2011

Alright. We will need to fetch the internal data about registrations to do this.
Should we set up a different page altogether for this?
synergynext

@synergynext-FdHLd3 • May 8, 2011

whats the current count btw
Ankita Katdare

@abrakadabra • May 8, 2011

synergynext
whats the current count btw

It's 96,339 at this instant.
Saandeep Sreerambatla

@saandeep-sreerambatla-hWHU1M • May 9, 2011

I have seen counter in goyal site and indianguitarist site!

So it must not be very hard.
optimystix

@optimystix-4yMPKC • May 10, 2011

hey AKD,
check this out. These links should help
#-Link-Snipped-#
#-Link-Snipped-#
<a href="https://extensions.joomla.org/extensions/clients-a-communities/members-lists" target="_blank" rel="nofollow noopener noreferrer">Show all - Members lists</a>

use javascript, jsp etc to fetch data from the table which stores registration count. counters may be placed in different parts of the site as required.

I am not too good at coding and I guess there are other CEans who can do much better. Try and get this done by others. I guess you too could try this one. The code snippets are already given in the links above, just need to customize them as required.
Ankita Katdare

@abrakadabra • May 10, 2011

@opti: Thanks man! I will go through it as soon as my exam ends and ask Biggie for the right permissions.
Till then, all interested CS/IT engineers can try it too.
Ankita Katdare

@abrakadabra • May 18, 2011

@opti: Are you giving it a kick start? 😀
ShrinkDWorld

@shrinkdworld-WWdBBc • May 19, 2011

now 97,030 little away from our target!!!
ISHAN TOPRE

@ishan-nohePN • May 20, 2011

How about assigning numbers to all CEans? Like I am 67,987th member and something like this? It may be possible that such data may not be available with CE. In case it is we can assign it to members. I can be displayed below the number of posts on left side. 😀

What say?
Ankita Katdare

@abrakadabra • May 20, 2011

What will be the use of giving numbers to CEans?
ISHAN TOPRE

@ishan-nohePN • May 20, 2011

The same use as that of the counter. Won't it be good, if people say that I was the 100000th CEan? In this way, people will be regular on CE.

Of course we can implement this idea only if we have the required data/way to do available.
ISHAN TOPRE

@ishan-nohePN • Jun 17, 2011

OK we are very close to 99000. is the counter ready for last 1000 counts?
eternalthinker

@eternalthinker-Kvsi5Y • Jun 17, 2011

I think we can implement the counter easily with Ajax/JavaScript. On first thought, we can keep track of the number of users in a file or variable at the server, so as to avoid querying the database every time.

Normally, is there a way to see the member count in CE? I see that in above posts members are mentioning the exact count.
Is there any page in CE where we can actually see this count?
ISHAN TOPRE

@ishan-nohePN • Jun 18, 2011

Well people, I am not having a lot of programming knowledge. But do you know what I am thinking?

There is actually a counter counting the number of CEans which is currently showing the number as 98961. So I am thinking of applying the same algorithm for another counter but with just a little change. We will count reverse from 1000. What say?

To write a simple algo,
j=1000- i where i= 10000- number of CEans displayed by existing counter.

We can arrange for graphics too cannot we? 😀
eternalthinker

@eternalthinker-Kvsi5Y • Jun 18, 2011

@Ishutopre ~
If you want a count down from 1000, just 100000- number of CEans displayed by existing counter would be enough, right?
But where is this existing counter showing number of CEans? Pardon my ignorance 😐
ISHAN TOPRE

@ishan-nohePN • Jun 18, 2011

No problem ET, you have actually seen it. 😀 Go to forum. Press (ctrl+f) and typr "welcome to our newest member". -> you can easily find it by ctrl+f. Just above that welcome line, you will see members-> It is currently 98, 984.

P.S: Hurry ET, you have only a little time to implement it! Come on buddy you can do that.
ISHAN TOPRE

@ishan-nohePN • Jun 19, 2011

We have still one chance to have 500 CEans back word counter,

If this idea is to take up, we need to do something faster, else this thread is of no use. Just a time waste as usual.
Saandeep Sreerambatla

@saandeep-sreerambatla-hWHU1M • Jun 20, 2011

Just 920 more to go now! So guys speed up.
eternalthinker

@eternalthinker-Kvsi5Y • Jun 22, 2011

Oh there it was! Thanks @Ishu for pointing that out. I'll try to come up with some working example very soon.

On a rough estimation the 1,00,000 limit will be reached in the next 3 weeks.
So I hope we can put up a good counter atleast 2 weeks before the moment of glory, in worst case.
Kaustubh Katdare

@thebigk • Jun 22, 2011

How many are familiar with vBulletin code?
ISHAN TOPRE

@ishan-nohePN • Jun 22, 2011

Not me. But I do want something like a counter should be their. It would be great. If any help from my side, do tell me.
eternalthinker

@eternalthinker-Kvsi5Y • Jun 22, 2011

Hey, I have made a test counter. It works on a dummy data and not on the actual CE member count.
See it here: #-Link-Snipped-#

Open the Join page link in a new window. Click on Join button and see how the counter gets updated in real-time.

The idea is this:
> Member count is stored in a text file
> It is loaded every second by the counter
> Every time a member joins, the count is incremented in the file (to be done by the php code at actual join page)

It is implemented this way, so that the whole counter thing doesn't touch the CE database. So it avoids a lot of COUNT(*) queries every second!

Questions:
* My first doubt is whether there is some ready made count value stored in CE. Or is it just a COUNT(*) done every time the Forum link is clicked?
* The style of the counter, and what is to be done on The Count need to be finalized
* Any issues regarding the correctness of the counter need to be discussed
PraveenKumar Purushothaman

@praveenkumar-66Ze92 • Jun 23, 2011

This is nice one... This can be implemented, which is far better than MySQL Queries... 😀
eternalthinker

@eternalthinker-Kvsi5Y • Jun 23, 2011

Some notes:
There are a number of other methods all of which involve querying the database somehow. So after some thinking, this is one design I thought, would completely isolate the counter as a separate process.

The periodic querying for the text file is a necessity anyhow. Here some assumptions can be made:

* The text file should be altered by the same code which finally registers users to CE.
We can assume that too many users are not signing up at once, within a few seconds, ie. Correct me if this assumption is wrong.

* For the same reason as above, the counter might seem more or less static most of the time. So the main purpose of the counter's existence in this universe pretty much sums up to: Notifying all the online CEans of the glorious moment just when it happens!

* The life of the counter would be 3 weeks or slightly more, from now. So even if we're implementing this concept, or not, we better finalize our decision soon 😀
PraveenKumar Purushothaman

@praveenkumar-66Ze92 • Jun 23, 2011

Hey, what about the deadlock mechanism? I guess using MySQL will be better now! 😔
eternalthinker

@eternalthinker-Kvsi5Y • Jun 24, 2011

If CE server won't mind querying the database every second or so for every online user, MySQL way is surely the most straightforward; We can always assign a php file just for that, right?

In the previous method, there IS, the issue of exclusive access. But how probable is that situation in CE, practically? (multiple users signing up within a second)
There is always some way to introduce exclusive access to the file, but we can also consider whether all the extra code is worth it.

Also, 680 more to go. It'll already be a hundred thousand users by the time we decide upon how to implement the counter 😛
As the number of required members dwindle down, I think the exclusive access issue will get less significant (yet another strategy!) 😉
Kaustubh Katdare

@thebigk • Jun 24, 2011

Why don't we simply update the counter manually after every 100 until 100000 from 99500?
eternalthinker

@eternalthinker-Kvsi5Y • Jun 24, 2011

May be implement realtime counter for the last 10 or so?
Saandeep Sreerambatla

@saandeep-sreerambatla-hWHU1M • Jul 5, 2011

We have crossed the mark, I guess we will close this thread!!