User Profile

[Lats]

Or a slightly shorter version...

UPDATE user
JOIN userfield
USING (userid)
SET usergroupid = 36
WHERE  
field23 
REGEXP BINARY '[A-Z]'

[Lats]

Check this thread...

http://www.vbulletin.com/forum/forum...00-posts-per-m...

[Lats]

If you're comfortable running a query, this will help...

SELECT
    title,
    replycount AS posts
FROM
    forum
WHERE
    parentid > 0
ORDER BY

...

[Lats]

Check this thread...

http://www.vbulletin.com/forum/forum...ctivated-users

[Lats]

Post a link to your site so we can check the css being used.

[Lats]

Ok, replace this snippet of code you posted...

...
<center><script type="text/javascript">
var bannersnack_embed = {"hash":"bcfgxle8x","width":728,"height":90,"t":1430918800,"userId":15990086,"bgcolor":"#3D3D3D","wmode":"opaque"};

...

[Lats]

No, the center tags look like this...

<center> and
</center>

At the bottom.

[Lats]

Try replacing those center tags with something like this...

<div style="margin: 0 auto;">
...
your banner code
...
</div>

[Lats]

Check this thread...

http://www.vbulletin.com/forum/forum...-to-be-working

It happens every now and a...

[Lats]

After disabling the product, the syntax for getting rid of the column is...

alter table
 post
drop column
 column_name

Change column_name to the actual name of the column you want...

[Lats]

This should be a good start for you...

SELECT
 forum.forumid AS forumid,
 forum.title AS forumtitle,
 thread.threadid AS threadid,
 thread.title AS threadtitle,
 post.postid

...

[Lats]

Check this old thread...

http://www.vbulletin.com/forum/forum...ing/302256-cha...

[Lats]

Try this, it's pretty close to one of the examples Jake posted...

<if condition="$post[postcount] == 1 AND !$bbuserinfo[userid] AND $foruminfo[forumid] != 44">

[Lats]

Check this thread...

http://www.vbulletin.com/forum/forum...how-to-show-a-...

[Lats]

Or, without modifying the code, check this thread...

http://www.vbulletin.com/forum/forum...i-questions-an...

[Lats]

If you running the query within the admincp, try removing the vertical spacing.

[Lats]

Try this query...

DELETE FROM
 blog
WHERE
 dateline > '1389509567'

To fine tune the dateline value, use an online converter such as http://www.epochconverter.com/

[Lats]

Check post #5 in this thread...

http://www.vbulletin.com/forum/forum...leshooting/152...

[Lats]

Try this query...

SELECT
 username,
 total_posts,
 first_post,
 day_count,
 (total_posts / day_count) AS posts_per_day
FROM
 (
 SELECT
  user.username

...

[Lats]

Try this...

UPDATE
user
SET
usergroupid = X
WHERE
  email
LIKE '%.cn'
AND
 joindate > UNIX_TIMESTAMP('2013-10-07 : 18:15:00')

...