Badge SQL Query

[Nevada]

Hello,
I have a list of user ID's (about 500) which I need to send the same badge to. Would someone be able generate my a query which I can put the ID's into so the badge gets sent to all of them without me having to do it manually?
Thanks!

 

[Benden]

What database?

 

[brsy]

Lol... In phoenix I believe there is a command that gives everyone the badge...

:massbadge (ID)

 

[Markshall]

<?php
mysql_query( "UPDATE `Users` SET `Badge` = 'badge_string'" );
?>

That would set their badge to 'badge_string' to every user.

 

[Nevada]

I just want a selected 500 users to receive it, I have their ID's. The database is the standard phoenix db

 

[brsy]

Just give it to those that are online I guess.

 

[Nevada]

I mean, it was for people posting on my facebook page. 500 users posted and I got their ID's and I want to send them all a particular badge

 

[Markshall]

You have the ID's?
Well, put them in an array like this:

<?php
$user_ids = array( 1, 2, 3 ); //a list of the users you want to send the badge to
foreach ( $user_ids as $id )
{
    mysql_query( "UPDATE `Users` SET `Badge` = 'badgecode' WHERE `UserID` = '" . $id . "'" );
}
?>

I'll let you do the Phoenix db shit, I don't know how the database is structured so you'll have to replace '`Users`', '`Badge`' and '`UserID`' with whatever Phoenix uses.

 

[Nevada]

You have the ID's?
Well, put them in an array like this:

<?php
$user_ids = array( 1, 2, 3 ); //a list of the users you want to send the badge to
foreach ( $user_ids as $id )
{
    mysql_query( "UPDATE `Users` SET `Badge` = 'badgecode' WHERE `UserID` = '" . $id . "'" );
}
?>

I'll let you do the Phoenix db shit, I don't know how the database is structured so you'll have to replace '`Users`', '`Badge`' and '`UserID`' with whatever Phoenix uses.

There is a separate table for badges called 'user_badges' the table has 2 collumns one for User ID called 'user_id' and one for badge ID 'badge_id'

 

[Markshall]

Try something like

<?php
$user_ids = array( 1, 2, 3 ); //a list of the users you want to send the badge to
foreach ( $user_ids as $id )
{
    mysql_query( "UPDATE `user_badges` SET `badge_id` = 'badgecode' WHERE `user_id` = '" . $id . "'" );
}
?>

Or something, I'm not entirely sure.

 

[Nevada]

Try something like

<?php
$user_ids = array( 1, 2, 3 ); //a list of the users you want to send the badge to
foreach ( $user_ids as $id )
{
    mysql_query( "UPDATE `user_badges` SET `badge_id` = 'badgecode' WHERE `user_id` = '" . $id . "'" );
}
?>

Or something, I'm not entirely sure.

I'm getting:

[Err] 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '<?php
$user_ids = array( 1, 2, 3 )' at line 1


I'm using Navicat

 

[brsy]

That would work, but he would then have to type in all the numbers, way up to 500? Why couldn't he do something like this:

<?php
$badecode = ""; // Put the badge ID here

    mysql_query( "UPDATE `user_badges` SET `badge_id` = '" . $badgecode . "' WHERE `user_id` = '" . $id <= 500 . "'" );
?>

Put that in a file called setBadge.php, and put it onto your server. Once it's on your server, go to it, then you're good to go.

 

[Nevada]

The thing is, the ID's are 500 random ID's like:

85108, 89329, 48628, 99474, 2325, 87283, 25997, 76514, 95880, 88795, 43490, 93312, 96788, 42730, 6532, 37167, 644, 101400, 80333, 32841, 15009, 26240, 65647, 19145, 52557, 101100, 10194, 66330, 98767, 99041, 3315, 101515, 25630, 99474, 55312, 84066, 96669, 17610, 4907, 71694, 16443, 51782, 28931, 82211, 34125, 101510, 69990

etc.

 

[brsy]

Then use m0nsta's way, and enter the ID's manually.

 

[Markshall]

<?php
$users = "85108, 89329, 48628, 99474, 2325, 87283, 25997, 76514, 95880, 88795, 43490, 93312, 96788, 42730, 6532, 37167, 644, 101400, 80333, 32841, 15009, 26240, 65647, 19145, 52557, 101100, 10194, 66330, 98767, 99041, 3315, 101515, 25630, 99474, 55312, 84066, 96669, 17610, 4907, 71694, 16443, 51782, 28931, 82211, 34125, 101510, 69990";
$usersexp = explode( ", ", $users );
foreach ( $usersexp as $id )
{
    mysql_query( "UPDATE `user_badges` SET `badge_id` = 'badgecode' WHERE `user_id` = '" . $id . "'" );
}
?>

Try that.

 

[Nevada]

<?php
$users = "85108, 89329, 48628, 99474, 2325, 87283, 25997, 76514, 95880, 88795, 43490, 93312, 96788, 42730, 6532, 37167, 644, 101400, 80333, 32841, 15009, 26240, 65647, 19145, 52557, 101100, 10194, 66330, 98767, 99041, 3315, 101515, 25630, 99474, 55312, 84066, 96669, 17610, 4907, 71694, 16443, 51782, 28931, 82211, 34125, 101510, 69990";
$usersexp = explode( ", ", $users );
foreach ( $usersexp as $id )
{
    mysql_query( "UPDATE `user_badges` SET `badge_id` = 'badgecode' WHERE `user_id` = '" . $id . "'" );
}
?>

Try that.

Ok so what do I do with this, run it as a query or put it as a .php file and go to it?

 

[Markshall]

Put it in a PHP file, but make sure your database connection is established in there, or it will throw you a list of MySQL errors all saying more-or-less the same thing.

 

[Nevada]

I've done that but it doesn't seem to work, is there not a query I can put into navicat and run for it?

 

[brsy]

You can do it manually for each user. That's the only alternative.