Generates an error log entry when a slow query is detected.
Slow query detection is hardcoded to 1 second
Works on a single query at a time, not all queries for a request.
Only logs slow public queries.
I recommend using Add-on install & upgrade or [TH] Install and...
I try to develop a Plugin for my MC Server, that user can register by an simple command, that means:
So, is there a Register-Query that i can start or is it enough if I simply the entries the database?
For the passwortd i got the Password Reset Query...
Before I "properly' learned how to preregister variables and custom templates in a default vBulletin template, I had no clue how to use all the custom code I had developed for my site on the standard pages my members would use. I figured out a quick and handy workaround to registering a new...
Have you a lot of Smilies in your forum? Maybe you have some duplicated smilies just because you call same smilie with different keywords, for example can be called by :) :-) and :smile: or :( :-( :sad:
If you do that, like me, you'll have duplicate smilies in your smilies lists and...
Not very much has changed regarding how pagination works since vB 3.8, but quite enough to warrant an update of Revan's great tutorial, dating from 2006. Kudos to Revan.
As Revan I assume you know your way around php and can understand at least roughfly what each bit of the code...
What this add-on does...
The add-on displays a counter above the "What's New?" link on the navigation bar.
This counter displays the current number of unread posts (individual posts, not threads) that are visible to the user (it counts the number of unread posts in the forums that are...
About This File
Query Toolbox is a 3rd party developer plugin for the Invision Power Suite that adds a few extensions to the Database Schema and Versions section of the Developers Center.
Implements a "Query Toolbox" feature to the Database Schema page. This...
This will recalculate and update the post counts for all users at once. This is a large query that may take a while to finish.
UPDATE xf_user AS user
SET message_count = (
FROM xf_post AS post
LEFT JOIN xf_thread AS thread ON (thread.thread_id = post.thread_id)...