Thread: Char slot

Results 1 to 4 of 4
  1. #1
    Shu.'s Avatar
    Join Date
    Sep 2012
    Gender
    male
    Location
    Rasta Land
    Posts
    535
    Reputation
    48
    Thanks
    150
    My Mood
    Psychedelic

    Char slot

    hello can anyone tell me where can i edit price of char slots? ty

  2. #2
    Lunati's Avatar
    Join Date
    Apr 2013
    Gender
    male
    Posts
    265
    Reputation
    66
    Thanks
    1,545
    My Mood
    Amused
    There's two parts you need to edit, the displayed price and the actual price.

    First go to db > Database.cs and search for every instance of "nextcharslotprice = 0"

    Change each of the 0's to your price, this will change the price display.

    After that go to server > account > purchaseCharSlot.cs

    First look for this piece of code:
    Code:
    var cmd = db.CreateQuery();
                        cmd.CommandText = "SELECT gold FROM stats WHERE accId=@accId;";
                        cmd.Parameters.AddWithValue("@accId", acc.AccountId);
                        if ((int)cmd.ExecuteScalar() < 0)
                            status = Encoding.UTF8.GetBytes("<Error>Not enough fame</Error>");
    Change the 0 to whatever price you want it.

    After that, look for this piece of code
    Code:
    cmd = db.CreateQuery();
                            cmd.CommandText = "UPDATE stats SET gold = gold - 0 WHERE accId=@accId";
                            cmd.Parameters.AddWithValue("@accId", acc.AccountId);
    Change the 0 here too, and it should be working.

    Also, it might not be exactly the same, because I already edited my purchaseCharSlot, so if something doesn't seem exactly the same, all you need to change is the numbers, make sure you don't change any other 0's than the ones I described.

  3. #3
    Shu.'s Avatar
    Join Date
    Sep 2012
    Gender
    male
    Location
    Rasta Land
    Posts
    535
    Reputation
    48
    Thanks
    150
    My Mood
    Psychedelic
    Quote Originally Posted by Lunati View Post
    There's two parts you need to edit, the displayed price and the actual price.

    First go to db > Database.cs and search for every instance of "nextcharslotprice = 0"

    Change each of the 0's to your price, this will change the price display.

    After that go to server > account > purchaseCharSlot.cs

    First look for this piece of code:
    Code:
    var cmd = db.CreateQuery();
                        cmd.CommandText = "SELECT gold FROM stats WHERE accId=@accId;";
                        cmd.Parameters.AddWithValue("@accId", acc.AccountId);
                        if ((int)cmd.ExecuteScalar() < 0)
                            status = Encoding.UTF8.GetBytes("<Error>Not enough fame</Error>");
    Change the 0 to whatever price you want it.

    After that, look for this piece of code
    Code:
    cmd = db.CreateQuery();
                            cmd.CommandText = "UPDATE stats SET gold = gold - 0 WHERE accId=@accId";
                            cmd.Parameters.AddWithValue("@accId", acc.AccountId);
    Change the 0 here too, and it should be working.

    Also, it might not be exactly the same, because I already edited my purchaseCharSlot, so if something doesn't seem exactly the same, all you need to change is the numbers, make sure you don't change any other 0's than the ones I described.
    ty its working but its picture of gold and i set it for fame but its working

  4. #4
    Shu.'s Avatar
    Join Date
    Sep 2012
    Gender
    male
    Location
    Rasta Land
    Posts
    535
    Reputation
    48
    Thanks
    150
    My Mood
    Psychedelic
    oh im wrong i had 11k gold and lots of fame and than it cost fame but when u dont have atleast 1k gold it wont work so idk ill try to fix it and if u can help me to sir lunati

Similar Threads

  1. [WTS] RotMG Account - 56 Stars, 12 8/8's, 15 char slots, all vaults, and more!
    By bbaazzyy in forum Selling Accounts/Keys/Items
    Replies: 8
    Last Post: 04-09-2013, 10:28 AM
  2. Want to sell an account (all vault, 8 char slots)
    By Ohayoo_Gozaimasu in forum Realm of the Mad God Selling / Trading / Buying
    Replies: 4
    Last Post: 01-02-2013, 09:46 AM
  3. [WTS] Account with 6 char slots, 3 maxed!
    By donran in forum Realm of the Mad God Selling / Trading / Buying
    Replies: 9
    Last Post: 12-31-2012, 08:26 AM
  4. WTS 62 star 13 char slots acc
    By wiickedz in forum Realm of the Mad God Selling / Trading / Buying
    Replies: 1
    Last Post: 12-26-2012, 03:47 PM
  5. selling realm acc 8 char slots almost 3 rows unlocked 5 pets
    By xbiglx in forum Realm of the Mad God Selling / Trading / Buying
    Replies: 1
    Last Post: 12-13-2012, 02:03 AM