Go Back   vb.org Archive > Search Forums
Reload this Page Search Results
FAQ Community Calendar Today's Posts Search

Page 1 of 2 1 2
Showing results 1 to 25 of 28
Search took 0.00 seconds. Search: Posts Made By: kgroneman
Forum: vB4 General Discussions 12-04-2018, 08:29 PM
Replies: 0
Views: 127
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 02-06-2018, 01:56 PM
Replies: 3
Views: 616
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 01-29-2018, 02:29 PM
Replies: 3
Views: 616
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 09-01-2017, 02:14 PM
Replies: 6
Views: 574
Posted By kgroneman
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 08-30-2017, 06:29 PM
Replies: 6
Views: 574
Posted By kgroneman
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 08-30-2017, 05:18 PM
Replies: 6
Views: 574
Posted By kgroneman
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 08-30-2017, 03:42 PM
Replies: 6
Views: 574
Posted By kgroneman
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 01-05-2017, 02:04 PM
Replies: 4
Views: 339
Posted By kgroneman
Thanks! I appreciate the response.:up:

Thanks! I appreciate the response.:up:
Forum: vB4 General Discussions 01-04-2017, 08:06 PM
Replies: 4
Views: 339
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 05-12-2016, 01:48 PM
Replies: 6
Views: 445
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 05-12-2016, 01:40 PM
Replies: 6
Views: 445
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 05-12-2016, 01:11 PM
Replies: 6
Views: 445
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 05-12-2016, 12:35 PM
Replies: 6
Views: 445
Posted By kgroneman
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 10-19-2015, 07:15 PM
Replies: 5
Views: 763
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 10-19-2015, 06:48 PM
Replies: 5
Views: 763
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 10-19-2015, 02:20 PM
Replies: 5
Views: 763
Posted By kgroneman
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 05-23-2014, 03:43 PM
Replies: 2
Views: 337
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 05-23-2014, 02:21 PM
Replies: 2
Views: 337
Posted By kgroneman
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 04-09-2014, 12:05 PM
Replies: 7
Views: 843
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 03-08-2013, 05:59 PM
Replies: 0
Views: 373
Posted By kgroneman
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 01-26-2012, 04:01 PM
Replies: 734
Views: 192,519
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 05-25-2011, 06:57 PM
Replies: 2
Views: 967
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 12-09-2010, 03:11 PM
Replies: 2
Views: 410
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 12-09-2010, 01:26 PM
Replies: 2
Views: 410
Posted By kgroneman
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 11-30-2010, 01:51 PM
Replies: 734
Views: 192,519
Posted By kgroneman
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
Page 1 of 2 1 2

 
Forum Jump

All times are GMT. The time now is 02:23 PM.

Contact Us - Archive - Top

Powered by vBulletin® Version 3.8.12 by vBS
Copyright ©2000 - 2025, vBulletin Solutions Inc.
X vBulletin 3.8.12 by vBS Debug Information
  • Page Generation 0.02974 seconds
  • Memory Usage 2,038KB
  • Queries Executed 10 (?)
More Information
Template Usage:
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_header_end
  • (1)ad_header_logo
  • (1)ad_navbar_below
  • (1)footer
  • (1)forumjump
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)navbar
  • (2)navbar_link
  • (120)option
  • (1)pagenav
  • (1)pagenav_curpage
  • (1)pagenav_pagelink
  • (1)post_thanks_navbar_search
  • (1)search_results
  • (25)search_results_postbit
  • (1)spacer_close
  • (1)spacer_open
  • (6)threadbit_pagelink 
Phrase Groups Available:
  • global
  • inlinemod
  • prefix
  • search
Included Files:
  • ./search.php
  • ./global.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/config.php
  • ./includes/functions.php
  • ./includes/class_hook.php
  • ./includes/modsystem_functions.php
  • ./includes/functions_search.php
  • ./includes/functions_databuild.php
  • ./includes/functions_forumlist.php
  • ./includes/functions_misc.php
  • ./includes/functions_forumdisplay.php
  • ./includes/functions_bigthree.php 
Hooks Called:
  • init_startup
  • init_startup_session_setup_start
  • init_startup_session_setup_complete
  • cache_permissions
  • style_fetch
  • cache_templates
  • global_start
  • parse_templates
  • global_setup_complete
  • search_before_process
  • search_start
  • search_results_start
  • search_results_query_posts
  • search_results_prebits
  • threadbit_process
  • search_results_postbit
  • pagenav_page
  • pagenav_complete
  • forumjump
  • search_complete
  • navbits
  • navbits_complete