Need Help - FireFly Help Please?

[bbaddons]

Hello, I know this may have been covered and some of it has not but I was wondering if someone could tell me how to do the following:

- Total Attachments (in all forums)
- Total Downloads Made (from all forums)
- Active Members
- Non-Active Members/Non-Posters

I know this can be done as I have seen it in the forums below but I was hoping tha FireFly or Sinecure could help me out with this. Help is much appreciated by anyone that helps out.

The forum I see this done in was:

http://forums.hololith.com/

Please help me out and tell me how this can be done and what code I need to place in my forums to accomplish this (the code is what is needed most, I know to stick it in the index.php file on the root forums directory).

Thanks in advance

[Admin]

Try this: :)
https://vborg.vbsupport.ru/showthread.php?s=&threadid=31653&highlight=stats

[bbaddons]

Yeah I have seen that but I wanted it to be on my site like on the Hololith forums (the same way they have it)

Total Post:..... | Active Members:..... | Non-Active:... |

ect.....


Do you think you could tell me how to do that? Please? :)

Thank you for your sugestion though, but I would rather have it that way if you are willing to help.

[bbaddons]

Can anyone help?

[bbaddons]

FireFly, can you please help me out, this one is on the board here so I hope that you can tell me how you did it.

I would like to have the following on my board if you would be kind enough to help me out:

- Top Submitter (like your top hacker - counting all forums)
- Total Submissions ( like total hacks - all forums)

If you would please help it would be appreciated.

Thanks in advance :)

[Admin]

So:
Top Submitter = top thread poster?
Total Submissions = total threads?

[bbaddons]

No, I mean as you have it here at vBhacks.com, I allow people to submit zip files, ect like this board does to my board and I need it to display the Top Submitter (the one who has submitted the most files)

The other needs to display the number of total files submitted (the total zip or .txt files submitted in all forum)

Can you help me with this?

[Admin]

What I have here is total threads, not attachments.

Anyway, try this code in index.php:
$gettotalattach=$DB_site->query_first("SELECT COUNT(*) AS count FROM attachment WHERE filename LIKE '%.zip' OR filename LIKE '%.txt'");
$totalattach=$gettotalattach[count];
$gettopattach=$DB_site->query_first("SELECT userid,COUNT(attachmentid) AS count FROM attachment WHERE filename LIKE '%.zip' OR filename LIKE '%.txt' GROUP BY userid ORDER BY count DESC LIMIT 1");
$topattacher=getuserinfo($gettopattach[userid]);
$topattacher[count]=$gettopattach[count];
Then use:
$totalattach for total submissions.
$topattacher[userid], [username], etc. for top submitter info.
$topattacher[count] for total submisions the top submitter has.

[bbaddons]

Thanks Chen, this is just what was needed. I appreciate you help with this.

Thanks again,