03.03.2015, 10:38
Very simple: without SQL you pretty much can't do anything that involves more than 1 item. Want to find the player with the most money? The least money? The highest score? The lowest score? The player that owns the most houses? etc, etc, etc.
Most of those RP servers also use some kind of "key" system where keys to a house can be distributed to other players. With flat files you're limited to a fixed number of users, with SQL there is no limit. You could create a table "house_access", for example, which contains two columns: houseid and userid. If a match is found in that table the user can enter the house, otherwise they can't.
Another example: bank transactions. Most servers currently store only one value "bankMoney", but how explanatory is that, really? With SQL you can insert a new row each time a transaction is made. You don't have to store "bankMoney" anymore either as you can just sum all the transactions together to get the right amount.
There's probably more examples, but I'm just quickly typing this up in my lunchbreak.
Most of those RP servers also use some kind of "key" system where keys to a house can be distributed to other players. With flat files you're limited to a fixed number of users, with SQL there is no limit. You could create a table "house_access", for example, which contains two columns: houseid and userid. If a match is found in that table the user can enter the house, otherwise they can't.
Another example: bank transactions. Most servers currently store only one value "bankMoney", but how explanatory is that, really? With SQL you can insert a new row each time a transaction is made. You don't have to store "bankMoney" anymore either as you can just sum all the transactions together to get the right amount.
There's probably more examples, but I'm just quickly typing this up in my lunchbreak.