Counting submissions

[lumpen5]

We are holding a contest and want to be able to find out which registered user submitted the X link (as in you submitted the 1,000th link. Congrats!), etc.

I've checked in mysql, etc. but I just can't find a way to do it. Is there something I am missing?

Also, we want to be able to show the amount of published links on the front page. Try to modify the "logged in user" code but that didnot turn out so well.

Any help?

Thanks!

[lumpen5]

Originally Posted by lumpen5

We are holding a contest and want to be able to find out which registered user submitted the X link (as in you submitted the 1,000th link. Congrats!), etc.

I've checked in mysql, etc. but I just can't find a way to do it. Is there something I am missing?

Also, we want to be able to show the amount of published links on the front page. Try to modify the "logged in user" code but that didnot turn out so well.

Any help?

Thanks!

Ok figured it out...Duhhh.

Go into mysql admin
click on yourtable_links
then browse
scroll down to the 1,000 entry (insert duh here!)
look in the "link_author" field for the author number
go to yourtable_users and find the "author number" in "user_id
Presto you have found your 1,000 submitor.

Still need help with getting the amount of published stories on the front page though

[chuckroast]

Have you looked at admin_main_center.tpl?
There are already smarty variables created such as:

{$members} = total number of members
{$total} = total number of stories submitted
{$published} = number of stories published
{$queued} = number of stories in the queue
{$votes} = total combined votes of all stories
{$comments} = total number of comments made on the site

So for example lets say you want to show the total number of published stories on the home page.

Open index.php and add

$published = $db->get_var('SELECT count(*) from ' . table_links . ' where link_status = "published";');
$main_smarty->assign('published', $published);

Then open index_center.tpl and add something like

{$published} total published stories

[lumpen5]

Excellent. Thanks!