How to add items to all players?

Results 1 to 6 of 6
  1. #1
    Member Elyrb is offline
    MemberRank
    Mar 2016 Join Date
    Butuan City, PhLocation
    36Posts

    How to add items to all players?


    RaGEZONE Recommends

    RaGEZONE Recommends

    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 :)


  2. #2
    Tantra/Web Development jbeitz107 is offline
    True MemberRank
    Mar 2012 Join Date
    USALocation
    1,324Posts

    Re: How to add items to all players?

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

  3. #3
    Account Upgraded | Title Enabled! master_unknown is offline
    True MemberRank
    Oct 2004 Join Date
    HellLocation
    805Posts

    Re: How to add items to all players?

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

  4. #4
    Member Elyrb is offline
    MemberRank
    Mar 2016 Join Date
    Butuan City, PhLocation
    36Posts

    Re: How to add items to all players?

    Quote Originally Posted by master_unknown View Post
    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

  5. #5
    Account Upgraded | Title Enabled! master_unknown is offline
    True MemberRank
    Oct 2004 Join Date
    HellLocation
    805Posts

    Re: How to add items to all players?

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

  6. #6
    Web Developer John is offline
    True MemberRank
    Mar 2011 Join Date
    Tabasco, MXLocation
    380Posts

    Re: How to add items to all players?

    Test any.

    SQL

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

    PHP
    Code:
    $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";
    }
    add me in telegram: @amirtorrez




Advertisement