Register Members List Search Today's Posts Mark Forums Read

Showing results 1 to 25 of 28
Search took 0.01 seconds.
Search: Posts Made By: kgroneman
Forum: vB4 General Discussions 04 Dec 2018, 21:29
Replies: 0
Views: 69
Posted By kgroneman
SQL Query for ranks

I need to find out how many users have each rank. Is there a kind soul out there that could give me a query to find the number of users that have a single rank? I would be in your debt.
Forum: vB4 Programming Discussions 06 Feb 2018, 14:56
Replies: 3
Views: 522
Posted By kgroneman
Thanks! much appreciated. This looks like it...

Thanks! much appreciated. This looks like it may set ALL threads to that prefix instead of just threads without a prefix, but what do I know. :-) I'll test it out before using it in a critical...
Forum: vB4 Programming Discussions 29 Jan 2018, 15:29
Replies: 3
Views: 522
Posted By kgroneman
SQL query to assign threads a prefix

I'm needing to assign all threads in a specific forum that do not currently have a prefix to an existing prefix. Is there some kind soul out there that could show me an SQL query that would do such...
Forum: vB4 General Discussions 01 Sep 2017, 16:14
Replies: 6
Views: 425
Posted By kgroneman
Thumbs up Thanks Simon and Dave. You've just made managing...

Thanks Simon and Dave. You've just made managing sticky posts across a lot of forums a lot easier. I sincerely appreciate the time you've taken to assist me. :up: :up: :up:
Forum: vB4 General Discussions 30 Aug 2017, 20:29
Replies: 6
Views: 425
Posted By kgroneman
Question Yes! Thank you. It works as I had hoped. :up:...

Yes! Thank you. It works as I had hoped. :up:

--------------- Added 1504196589 at 1504196589 ---------------

One more question if I may. I added the option to sort by date:
SELECT...
Forum: vB4 General Discussions 30 Aug 2017, 19:18
Replies: 6
Views: 425
Posted By kgroneman
Thumbs up Simple for you anyway. Thanks! I tried that...

Simple for you anyway. Thanks!

I tried that and it gives me the thread.title and the thread.postusername, but not the forum.title. Can it easily be tweaked a bit to list the forum too?
Forum: vB4 General Discussions 30 Aug 2017, 17:42
Replies: 6
Views: 425
Posted By kgroneman
Question Finding all sticky posts

I've got a lot of forums and a lot of moderators. Sometimes they forget about a sticky post and it gets out of date and needs to be unstuck.

This sql query will show all sticky posts: SELECT *...
Forum: vB4 General Discussions 05 Jan 2017, 15:04
Replies: 4
Views: 270
Posted By kgroneman
Thumbs up Thanks! I appreciate the response.:up:

Thanks! I appreciate the response.:up:
Forum: vB4 General Discussions 04 Jan 2017, 21:06
Replies: 4
Views: 270
Posted By kgroneman
Query to close threads with a prefix?

I'd like to use an SQL query to close all threads in a specific forum that have a specific prefix (prefix=product version). I don't know how to create queries. The best I can come up with is this:...
Forum: vB4 General Discussions 12 May 2016, 15:48
Replies: 6
Views: 263
Posted By kgroneman
That did it! Thanks to you both! This now...

That did it! Thanks to you both! This now works.
SELECT count(vb_post.postid) AS vb_postcount, vb_user.username
FROM vb_post AS vb_post
LEFT JOIN vb_user AS vb_user ON (vb_user.userid =...
Forum: vB4 General Discussions 12 May 2016, 15:40
Replies: 6
Views: 263
Posted By kgroneman
First of all THANK YOU so much for your time and...

First of all THANK YOU so much for your time and effort helping me. I don't know much of anything about SQL queries. I tried your suggestion and got a timestamp error, so I changed the syntax of...
Forum: vB4 General Discussions 12 May 2016, 15:11
Replies: 6
Views: 263
Posted By kgroneman
Thanks Dave, that's what I thought too, but when...

Thanks Dave, that's what I thought too, but when I use just forumid I get the same error:

Message
An error occurred while attempting to execute your query. The following information was returned....
Forum: vB4 General Discussions 12 May 2016, 14:35
Replies: 6
Views: 263
Posted By kgroneman
Question Excluding forums in SQL query

I need some help with an SQL query. I'm trying to run a query to list the top posters but exclude some specific forums using vb_forumid, but it's not recognized. Here's the query BEFORE trying to...
Forum: vB4 General Discussions 19 Oct 2015, 21:15
Replies: 5
Views: 522
Posted By kgroneman
I found it! Thanks to your help and guidance: ...

I found it! Thanks to your help and guidance:


SELECT COUNT(postid) AS count, user.username
FROM post
LEFT JOIN user ON (user.userid = post.userid)
WHERE (dateline >...
Forum: vB4 General Discussions 19 Oct 2015, 20:48
Replies: 5
Views: 522
Posted By kgroneman
Thanks Dave. The options you list won't give me...

Thanks Dave. The options you list won't give me statistics for the users in that group for JUST that time period which is what I'm looking for. Thanks for the response and thanks for the shortcut...
Forum: vB4 General Discussions 19 Oct 2015, 16:20
Replies: 5
Views: 522
Posted By kgroneman
Question SQL Query for number of posts per user group

Hi,

I'm trying to get the number of posts for users in a specific user group in a specific timeframe and am using this query:


SELECT posts, username, email from vb_user
WHERE (usergroupid=10...
Forum: vB4 Programming Discussions 23 May 2014, 16:43
Replies: 2
Views: 272
Posted By kgroneman
Duh. I should have seen that. Thanks for the...

Duh. I should have seen that. Thanks for the slap across the face. It works. :-)
Forum: vB4 Programming Discussions 23 May 2014, 15:21
Replies: 2
Views: 272
Posted By kgroneman
Question SQL query for specific text in homepage field

Can someone help me create a query that lists all users with a specific string of characters in the homepage field? I have a spammer that has the word barbara in a URL of the home page.

I've...
Forum: Community Lounge 09 Apr 2014, 13:05
Replies: 7
Views: 700
Posted By kgroneman
Same thing, but with different address...

Same thing, but with different address originating in China:
The person trying to log into your account had the following IP address: 223.87.186.245
Forum: vB4 General Discussions 08 Mar 2013, 17:59
Replies: 0
Views: 293
Posted By kgroneman
Question How to limit attachments to a single forum

On vB 4.2 Suite. I've been looking for a good way to limit the posting of attachments to a single forum, is it possible?

It looks like the only choice I have for a forum is to moderate...
Forum: vBulletin 3.5 Add-ons 26 Jan 2012, 16:01
Replies: 734
Views: 184,350
Posted By kgroneman
We've got it working very nicely, but have had to...

We've got it working very nicely, but have had to modify the code a bit to get it working right. If anyone wants it, I'll send you the files I have. Currently running on 4.1.9 PL1 without problems...
Forum: vB4 Programming Discussions 25 May 2011, 19:57
Replies: 2
Views: 924
Posted By kgroneman
As far as I can tell, that deals with the number...

As far as I can tell, that deals with the number of articles displayed, not the numerical number being displayed in the widget the OP seems to be asking for? Is there a way to display the number of...
Forum: vB4 General Discussions 09 Dec 2010, 16:11
Replies: 2
Views: 346
Posted By kgroneman
Thanks for the suggestion. That looks like it...

Thanks for the suggestion. That looks like it just displays on the forum page, I guess I'm more interested in just creating myself a report.
Forum: vB4 General Discussions 09 Dec 2010, 14:26
Replies: 2
Views: 346
Posted By kgroneman
Question User statistics

Is there a mod that would give a report of user statistics for a defined period of time? For example I want to see the top 100 posters in my forums for the month of November. (It would be perfect...
Forum: vBulletin 3.5 Add-ons 30 Nov 2010, 14:51
Replies: 734
Views: 184,350
Posted By kgroneman
Question I'm running it on 4.0.7 currently and it works...

I'm running it on 4.0.7 currently and it works great except for attachments. Any time it comes across an attachment it hangs. Is anyone else seeing this?
Showing results 1 to 25 of 28

 

New To Site? Need Help?

All times are GMT. The time now is 15:56.

Layout Options | Width: Wide Color: