vBulletin Modifications

Whats the query

Welcome to vBHackers.com! - vBHackers Updates:

Go Back   vBulletin Modifications > General vBulletin Section > General vBulletin Support

Reply
 
LinkBack Thread Tools
Old 05-03-2006, 05:28 AM   #1
Junior Member
Join Date: Apr 2006
Xanthate is on a distinguished road

Default Whats the query

What query would I use to count for a user the number of times their post was the second one in a thread (eg the first reply to the thread)??? I didnt find a field in the post table for this.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Sponsored Links
Old 05-03-2006, 08:29 AM   #2
Coder
Senna's Avatar
Join Date: Mar 2005
Location: LalaLand
Senna is on a distinguished road

Default

don't know if it is possible at all, querying the number of replies he made in total is possible (total posts - total threads started)

maybe someone else knows how to do it?




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 05-03-2006, 09:37 AM   #3
vBulletin Guru
Arnoud's Avatar
Join Date: Nov 2004
Real Name: Arnoud Kuipers
Location: Europe, Flanders
Arnoud is on a distinguished road

Default

Well, I believe there's a certain code in a query which picks only the second (or third, fourth, etc.. its defined in the code itself) result in the query. I don't know how this works though.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 05-04-2006, 10:10 AM   #4
vBulletin Guru
Ken Iovino's Avatar
Join Date: Mar 2004
Real Name: Ken Iovino
Location: Miami, Florida
Ken Iovino is on a distinguished road

Default

Theres no one query for this, you would have to baslicly create a script with alot of queries and conditions to narrow it down to that. It's possiable, just would be very time consuming to create and figure out.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 05-04-2006, 01:33 PM   #5
vBulletin Guru
Arnoud's Avatar
Join Date: Nov 2004
Real Name: Arnoud Kuipers
Location: Europe, Flanders
Arnoud is on a distinguished road

Default

.. and very resource intensive.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 05-05-2006, 09:23 AM   #6
Coder
Senna's Avatar
Join Date: Mar 2005
Location: LalaLand
Senna is on a distinguished road

Default

Quote:
Originally Posted by LiveWire
Theres no one query for this, you would have to baslicly create a script with alot of queries and conditions to narrow it down to that. It's possiable, just would be very time consuming to create and figure out.
wouldn't it be possible with the query that gathers the info for creating that numbering of the posts in a thread? (upperright of a post: #6) (postcount)




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 05-06-2006, 01:32 AM   #7
Junior Member
Join Date: Apr 2006
Xanthate is on a distinguished road

Default

Quote:
Originally Posted by Ike013
wouldn't it be possible with the query that gathers the info for creating that numbering of the posts in a thread? (upperright of a post: #6) (postcount)
Thats what I was thinking, but I couldnt find any info on it. Tired looking at code in showtread.php, but couldnt find that query.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Old 05-06-2006, 04:47 AM   #8
Coder
Senna's Avatar
Join Date: Mar 2005
Location: LalaLand
Senna is on a distinguished road

Default

have a look at this:
showthread.php
You must first be a registered member to view any code.




Digg this Post!Add Post to del.icio.usBookmark Post in TechnoratiFurl this Post!
Reply With Quote
Reply



Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
[How To] Run a Query Ken Iovino vBulletin Modification Tutorials 9 07-30-2008 03:29 AM
Query Userinfo field (SX) General vBulletin Support 1 02-23-2006 01:08 PM
trigger query after user replys Hakkie General vBulletin Support 6 09-15-2005 01:44 PM
Mysql / php code help w/ query and totals Hyper General vBulletin Support 6 07-12-2004 12:48 AM


All times are GMT -3. The time now is 02:10 AM.

Powered by vBulletin® Version 3.7.4
Copyright ©2000 - 2009, Jelsoft Enterprises Ltd.
SEO by vBSEO 3.2.0 ©2008, Crawlability, Inc. (Patent Pending)