SQL-querie that forces users to switch skin

[Eagle Creek]

Hi guys!

I want to run a MYSQL query that sets the default skin for ALL my users to ID 11 (for example).
After that they are still allowed to change later but I want to have all my current users, using a particular skin.

How can I do that?

[harmor19]

The only way is do a while loop.

PHP Code:

<?php
require_once('./global.php');

$getusers = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user ");
while($user = $db->fetch_array($getusers))
{
  $db->query_write("UPDATE " . TABLE_PREFIX . "user
               SET styleid =  '11' ");
}

?>

Test it on a test vbulletin first.

[Eagle Creek]

Originally Posted by harmor19

a while loop

I don't really understand what that means..

But I am going to test your code out, thankyou!

[Marco van Herwaarden]

No need for any coding, just run the following query:
[sql]UPDATE user set styleid = 11;[/sql]

@harmor19

Do you have any idea what your code is doing? It will loop through each user registered on your board, then for each user it will set the styleid for all users.

This not only don't make sense, it will for sure bring your server on it's knees for some time if you have a big userbase.

[harmor19]

Well he wanted to set all his user styleid to "11" and that was the only way I knew how.

[Eagle Creek]

Originally Posted by MarcoH64

No need for any coding, just run the following query:
[sql]UPDATE user set styleid = 11;[/sql]

@harmor19

Do you have any idea what your code is doing? It will loop through each user registered on your board, then for each user it will set the styleid for all users.

This not only don't make sense, it will for sure bring your server on it's knees for some time if you have a big userbase.

Thx!

[Marco van Herwaarden]

Originally Posted by harmor19

Well he wanted to set all his user styleid to "11" and that was the only way I knew how.

If you really wanted to loop through each user individually (don't make sense), then you should have at least have limited the update query to the current userid:

PHP Code:

<?php 
require_once('./global.php'); 

$getusers = $db->query_read("SELECT * FROM " . TABLE_PREFIX . "user "); 
while($user = $db->fetch_array($getusers)) 
{ 
  $db->query_write("UPDATE " . TABLE_PREFIX . "user 
               SET styleid = 11 WHERE userid = " . $user['userid']); 
} 

?>