How to add items to all players?

[Elyrb]

Hi RageZoners,

Is there anyway to add items to all players using tools or SQL Query?

I've tried adding Amanda/Tikoy Power Pack to all accounts using SQL Query, sadly it doesn't work, I left the ID value to blank hoping it might affect all the rows in my database, unfortunately it doesn't work, I can only use this query to add items on a single player, which means GM Tool would be a lot faster

exec Tantra..InsertTantraItem 0,'',7067,1;
exec Tantra..InsertTantraItem 0,'USERNAME',ItemID,Quantity;

Thanks

 

[jbeitz107]

Look into while statements in php by googling it. Very simple. This is the only hint I will give you.

 

[master_unknown]

Lmao at hint whilst he also asks for help. Typical. Yah, get butthurt and report this post. IDC.

 

[Elyrb]

Lmao at hint whilst he also asks for help. Typical. Yah, get butthurt and report this post. IDC.

What's your problem? I'm asking for help and all I get is this uneducated and uncivilized response of yours?

I asked for help because I don't know how to do it (Of course I already tried doing a lot of stuff by myself)
Since none of them worked, I asked for help in this forum

Something must be wrong with you mentally

 

[master_unknown]

You're retarded. Did I respond to your query directly? Learn to understand what you read. lmao

 

[John]

Test any.

SQL

INSERT INTO TantraItem VALUES (0, UserID, 7067, 1)
SELECT UserID FROM Account;

PHP

$selectQuery = mssql_query("SELECT UserID FROM UserLogin");
while($selectUser = mssql_fetch_array($selectQuery)){
    echo "<br>";
    $insertItem = mssql_query("INSERT INTO TantraItem VALUES (0, ".$selectUser['UserID'].", 7067, 1)");
    (!$inserItem) ? echo "Item to ".$selectUser['UserID']." be not inserted" : echo "Item to ".$selectUser['UserID']." be inserted";
}