title: Add amount of gold to player
body: <p>I'm new here , I hope I can learn and share knowledge .</p>
  
  <p>Good This is my first post , and it is one with doubts.</p>
  
  <p>I have a [ Mu Online] server Ex 802, and the same features of { } SHOP CASH system for players to buy your items. Well my server has a control panel on which I can add the amount of money that the player will have , the more this system is in C#.</p>
  
  <p>The Cash Shop game uses one table to connect with sql :</p>
  
  <pre><code>     - Table " GameShop_Data"
       - Columns " MemberGuid , WCoinC , WCoinP , WCoinG" 
  </code></pre>
  
  <p>It does this check : When you enter the game, and opens the Shop Cash , there is a field called : { Golds number: VALUE }</p>
  
  <p>Basically checking that golds qts has it does the following : IT SEARCH TABLE SQL to " GameShop_Data " (as the user connected with his account he already is based on member_guid ) so he table scan the connected user MemberGuid field and it has the " WCoinC " column ( being the main currency ) and see the amount of Golds in this column and shows it in GAME the amount found in SQL.</p>
  
  <ul>
  <li><p>The columns beginning with W are the types of currency that has the SET.</p></li>
  <li><p>The MemberGuid column is like a kind of " id" organization.</p></li>
  </ul>
  
  <p>However the server has a site in which there are 3 types of control panel:</p>
  
  <ul>
  <li>User Control Panel</li>
  <li>Game Master Control Panel</li>
  <li><p>Administrator Control Panel</p></li>
  <li><p>On the control panel { } administrator has the option to add the quantity of money , it exists two types of currencies.</p></li>
  <li><p>To add basically need three fields {login , name of the currency ( SELECT being two ) , number } .</p></li>
  </ul>
  
  <p>But if I only put the login as identification, will not work.</p>
  
  <p>The simple reason:</p>
  
  <pre><code>INSERT INTO "GameShop_Data" ("username","WCoinC", ...) 
  VALUES ("user typed in input", "VALUE entered in input",);
  </code></pre>
  
  <p>If you run this code , it will pop up a " id" random in the database .</p>
  
  <p>An example : If the user I want to put gold , has a number of id 25 , more in Table 3 users placed there , i.e. we assume that these three I put the ' Golds ' through the panel I mentioned up there first done in C # .</p>
  
  <pre><code>[ MemberGuid ]    |    [ WCoinC ]    |    [WCoinP]    |    [WCoinP]
  
   "1"                 "500"             "NULL"           "NULL"
   "2"                 "500"             "NULL"           "NULL"
   "3"                 "500"             "NULL"           "NULL"
  </code></pre>
  
  <p>" PANEL BY EXECUTED SCRIPT MADE IN C # IS WORKING PROPERLY"</p>
  
  <p>But if I run the above script with data in specific with a base that user I typed in the input of the WEBSITE Control Panel field the id is "6"</p>
  
  <pre><code>INSERT INTO "GameShop_Data" ("username","WCoinC", ...) 
  VALUES ("mauricio1", "1000",);  "
  </code></pre>
  
  <p>TABLE SO WOULD STAY :</p>
  
  <pre><code>[ 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"
  </code></pre>
  
  <p>In other words, he created a random MemberGuid by itself it is an "int" with primary key ( and not put the id " 6" in the game that would identify the ' Golds ' the logged account) .</p>
  
  <p>Well I would like to know which script I ultilizar to do this check properly and thus be able to add the Golds for players through the Control Panel WEBSITE .</p>
  
  <ul>
  <li>Remember that the id login each account is on the table " MEMB_INFO " as in the second image of the publication.</li>
  </ul>
  
  <p>I will look for answers.</p>
  
  <p>Images Tables</p>
  
  <p>[ ' GameShop_Data '  ]</p>
  
  <p><img src="https://i.stack.imgur.com/xfd5b.jpg" alt="GameShop_Data"></p>
  
  <p>[ ' MEMB_INFO '    </p>
  
  <p><img src="https://i.stack.imgur.com/hVipU.jpg" alt="http://i.stack.imgur.com/hVipU.jpg"> </p>