Post by GeishaChan on Feb 15, 2015 15:40:59 GMT -8
Hello~
Not sure if this is possible, but I was thinking of a way to make it slightly easier in the long run for iSpy rewards handouts.
My idea is to create an NPC that would read information from a table in a database (SQL or otherwise, I'm just more familiar with SQL) in order to hand out valid and correct prizes.
So, a way I was thinking it could work would be to make two tables. One that would have a column where anyone keeping track of who correctly got the locations for each week's iSpy could go in and point a number (1, 2, 3, or 4) which represents which week said player got right. 1 being week 1, 2 being week 2, so on so forth.
When the player uses the NPC to receive their prizes, the code would check the number in that table on SQL and then multiply it by two. Then, whatever the sum is of that algorithm would be the amount of items the player gets of each reward.
Example: Player: Bob ; Administrator: Ace
Ace is putting into SQL the number for each winner of week 3's iSpy. So, he puts in the number 3 in the column of the proper table.
Bob is one of the winners. Yay! Bob goes to the proper NPC and gets a message saying "You guessed correctly! Here are your prizes! Please make sure you have enough room in your inventory"
And the NPC proceeds to give Bob 6 leaves and 6 trophies. The reason the NPC gave Bob 6 of each is because it took the number that Ace previously put into SQL, and the NPC has an algorithm to read that number, and multiply it by two, since you get two items per picture.
After the player gets their prize, the code then updates that SQL table for Bob's row to Null, so that Bob does not continue to use this NPC and it keeps stating he has guessed correctly.
Now, there would be a second table as well that would have four columns, each representing a week for the iSpy. The administrator would put some type of information, maybe an x, in each week that a player gets correctly.
So, lets go back to Bob. Bob got all four week's iSpy's correct. So when Bob uses the NPC for the fourth week's reward, he will get an extra screen saying "Wait, I just saw you did remarkably well this month! Congrats on finding all of this month's iSpy locations! Because you did so well I feel you should get a little something extra" and would proceed to give the extras you get for doing all four weeks.
How the NPC would know whether to give it to player Bob is by the X's in the second SQL table. The NPC would be coded to see if all four columns on this table have an X, and if Bob's row has those four X's, the NPC will carry out the coding to reward Bob the extra rewards.
Please do not hesitate to ask me questions regarding this. I am fully aware that this was probably not a very clear depiction of what I'm trying to say, and it may be random. I will try my hardest to make it clearer!
--Brittany
Not sure if this is possible, but I was thinking of a way to make it slightly easier in the long run for iSpy rewards handouts.
My idea is to create an NPC that would read information from a table in a database (SQL or otherwise, I'm just more familiar with SQL) in order to hand out valid and correct prizes.
So, a way I was thinking it could work would be to make two tables. One that would have a column where anyone keeping track of who correctly got the locations for each week's iSpy could go in and point a number (1, 2, 3, or 4) which represents which week said player got right. 1 being week 1, 2 being week 2, so on so forth.
When the player uses the NPC to receive their prizes, the code would check the number in that table on SQL and then multiply it by two. Then, whatever the sum is of that algorithm would be the amount of items the player gets of each reward.
Example: Player: Bob ; Administrator: Ace
Ace is putting into SQL the number for each winner of week 3's iSpy. So, he puts in the number 3 in the column of the proper table.
Bob is one of the winners. Yay! Bob goes to the proper NPC and gets a message saying "You guessed correctly! Here are your prizes! Please make sure you have enough room in your inventory"
And the NPC proceeds to give Bob 6 leaves and 6 trophies. The reason the NPC gave Bob 6 of each is because it took the number that Ace previously put into SQL, and the NPC has an algorithm to read that number, and multiply it by two, since you get two items per picture.
After the player gets their prize, the code then updates that SQL table for Bob's row to Null, so that Bob does not continue to use this NPC and it keeps stating he has guessed correctly.
Now, there would be a second table as well that would have four columns, each representing a week for the iSpy. The administrator would put some type of information, maybe an x, in each week that a player gets correctly.
So, lets go back to Bob. Bob got all four week's iSpy's correct. So when Bob uses the NPC for the fourth week's reward, he will get an extra screen saying "Wait, I just saw you did remarkably well this month! Congrats on finding all of this month's iSpy locations! Because you did so well I feel you should get a little something extra" and would proceed to give the extras you get for doing all four weeks.
How the NPC would know whether to give it to player Bob is by the X's in the second SQL table. The NPC would be coded to see if all four columns on this table have an X, and if Bob's row has those four X's, the NPC will carry out the coding to reward Bob the extra rewards.
Please do not hesitate to ask me questions regarding this. I am fully aware that this was probably not a very clear depiction of what I'm trying to say, and it may be random. I will try my hardest to make it clearer!
--Brittany
