UPDATE user JOIN userfield USING (userid) SET usergroupid = 36 WHERE field23 REGEXP BINARY '[A-Z]'
Announcement
Collapse
No announcement yet.
User Profile
Collapse
-
Or a slightly shorter version...Code:
- 13 posts
-
If you're comfortable running a query, this will help...Code:SELECTtitle,replycount AS postsFROMforumWHEREparentid > 0ORDER BY
- 2 posts
Leave a comment:
-
- 3 posts
Leave a comment:
-
Post a link to your site so we can check the css being used.
- 8 posts
Leave a comment:
-
Ok, replace this snippet of code you posted...Code:... <center><script type="text/javascript"> var bannersnack_embed = {"hash":"bcfgxle8x","width":728,"height":90,"t":1430918800,"userId":15990086,"bgcolor":"#3D3D3D","wmode":"opaque"};
- 8 posts
Leave a comment:
-
No, the center tags look like this...
<center> and
</center>
At the bottom.
- 8 posts
Leave a comment:
-
Try replacing those center tags with something like this...Code:<div style="margin: 0 auto;"> ... your banner code ... </div>
- 8 posts
Leave a comment:
-
Check this thread...
http://www.vbulletin.com/forum/forum...-to-be-working
It happens every now and a...
- 6 posts
Leave a comment:
-
- 3 posts
Leave a comment:
-
Try this, it's pretty close to one of the examples Jake posted...Code:<if condition="$post[postcount] == 1 AND !$bbuserinfo[userid] AND $foruminfo[forumid] != 44">
- 6 posts
Leave a comment:
-
- 6 posts
Leave a comment:
-
Or, without modifying the code, check this thread...
http://www.vbulletin.com/forum/forum...i-questions-an...
- 3 posts
Leave a comment:
-
If you running the query within the admincp, try removing the vertical spacing.
- 8 posts
Leave a comment:
-
Try this query...Code:DELETE FROM blog WHERE dateline > '1389509567'
- 8 posts
Leave a comment:
-
Try this query...Code:SELECT username, total_posts, first_post, day_count, (total_posts / day_count) AS posts_per_day FROM ( SELECT user.username
- 8 posts
Leave a comment:
-
Try this...Code:UPDATE user SET usergroupid = X WHERE email LIKE '%.cn' AND joindate > UNIX_TIMESTAMP('2013-10-07 : 18:15:00')
- 13 posts
- 1 like
Leave a comment:
No activity results to display
Show More
Leave a comment: