Add amount of gold to player

Question

I have a server of [ Mu Online ] Ex 802 , and it has a { SHOP CASH } system so players can buy their items. Well my Server has a control panel in which I can add the amount of currency that the Player will have , plus this system is in C#.

The Shop Cash game uses 1 table to connect with sql:

     - Tabela " GameShop_Data"
     - Colunas " MemberGuid , WCoinC , WCoinP , WCoinG" 

He does this check: When he enters the game, and opens the Shop Cash, there is a field called : { Amount of Golds: VALUE } - Basically the check to know qts Golds has it does the following: IT SEARCH IN SQL a TABLE "Gameshop_data" ( how the user connected to his account he already has member_guid ) so he searches in the table the Memberguid field of the connected user and it has the column " Wcoinc " ( being the main currency ) and see the amount of Golds in this column and show in the GAME the amount you checked in SQL.

• The columns starting with W are the currency types you have in the GAME.

• The Memberguid column is like a kind of organization " id " .

However the Server has a site where there are 3 types of control panel:

• User Control Panel
• Game Master Control Panel

• Administrator Control Panel

• In the control panel of { administrator } you have the option to add the amount of currency , in it there are two types of coins.

• To add you need basically three fields { login , currency name ( SELECT being two ) , quantity }.

More if I put only the login as identification , will not work.

For the simple reason:

INSERT INTO "Gameshop_data" ("username","Wcoinc", ...) VALUES ("user typed in input", "VALUE typed in input",);

If you run this code, a random " id " will appear in the database.

An example: If the user I want to put gold , has a number id 25 , more in the table there are 3 users placed , ie let’s assume that these three I put the ' Golds ' through the panel that I quoted there above first made in C#.

[ Memberguid ] | [ Wcoinc ] | [Wcoinp] | [Wcoinp]

 "1"                  "500"            "NULL"           "NULL"
 "2"                  "500"            "NULL"           "NULL"
 "3"                  "500"            "NULL"           "NULL"

" SCRIPT EXECUTED BY THE C# PANEL IS WORKING CORRECTLY "

More if I run the above script with specific data on the basis that that user I typed in the WEB SITE Control Panel input field the id is"6 "

INSERT INTO "Gameshop_data" ("username","Wcoinc",) VALUES ("mauricio1", "1000",);

THE TABLE WOULD LOOK LIKE THIS:

[ Memberguid ] | [ Wcoinc ] | [Wcoinp] | [Wcoinp] | [username]

  "1"              "500"           "NULL"         "NULL"       "NULL"
  "2"              "500"           "NULL"         "NULL"       "NULL"
  "3"              "500"           "NULL"         "NULL"       "NULL"
  "4"              "1000"          "NULL"         "NULL"       "mauricio1"

That is: he created a random Memberguid by itself dealing with an " int " with Primary key ( and did not put the " id 6" that in the game would identify the 'Golds' of the logged in account ).

Well I would like to know which script should I use to do this check correctly and so be able to add the Golds to the players through the WEBSITE Control Panel.

• Remember that the login id of each account is in the table " MEMB_INFO " as in the second image of the publication.