Databases
StackOverflow2013
Postsdbo
POphp mysql gaming levelup script issues
 

Note that there are some explanatory texts on larger screens.

plurals
  1. POphp mysql gaming levelup script issues
    primarykey
    data
    text
    <p>Here is my problem. In my game I am trying to implement this leveling system where once you reached a certain amount of experience that you advance to a higher level. I am using php 5.0 and the Latest MYSQL. My problem is that i cannot get my scripts to execute properly.</p> <p>SO here are some dummy stats followed by my code Any information that would help me solve my problems would be greatly appreciated </p> <pre><code> $playerNAME = "Bozo"; $playerClASS = "Warrior"; $playerLEVEL = 13; $playerSTR = 5; $playerDEF = 2; $playerDEX = 3; $playerMAG = 2; $playerEXPERIENCE = 99999; </code></pre> <p>when I go to levelup from 13 to 14 none of the stats are updated with a new value and the level dosnt update... Yes all my connections from the connect.php to the DB server are working properly and yes i am using the correct table names in my code</p> <pre><code> function levelUPSTATS () { global $playerNAME; global $playerClASS; global $playerLEVEL; global $playerSTR; global $playerDEF; global $playerDEX; global $playerMAG; if ($playerCLASS === "Warrior") { $playerSTR = $playerSTR + 3; $playerDEF = $playerDEF + 2; $playerDEX = $playerDEX + 3; $playerMAG = $playerMAG + 2; $playerBASE_DAMAGE = ceil($playerSTR*$playerDEX); $playerSPELL_BASE_DAMAGE = ceil($playerMAG * $playerDEX); $playerMAX_HEALTH_POINTS = ceil($playerSTR * $playerDEF * $playerDEX); $playerMAX_MANA_POINTS = ceil($playerMAG * $playerDEF * $playerDEX / $playerSTR); $statusplayerSTR = "update players set strength=strength+'$playerSTR' where username='$playerNAME'"; mysql_query($statusplayerSTR) or die("Could not update player"); $statusplayerDEF = "update players set defence=defence+'$playerDEF' where username='$playerNAME'"; mysql_query($statusplayerDEF) or die("Could not update player"); $statusplayerDEX = "update players set dexterity=dexterity+'$playerDEX' where username='$playerNAME'"; mysql_query($statusplayerDEX) or die("Could not update player"); $statusplayerMAG = "update players set magic=magic+'$playerMAG' where username='$playerNAME'"; mysql_query($statusplayerMAG) or die("Could not update player"); $statusplayerBASE_DAMAGE = "update players set basedamage=basedamage+'$playerBASE_DAMAGE' where username='$playerNAME'"; mysql_query($statusplayerBASE_DAMAGE) or die("Could not update player"); $statusplayerSPELL_BASE_DAMAGE = "update players set spellbasedamage=spellbasedamage+'$playerSPELL_BASE_DAMAGE' where username='$playerNAME'"; mysql_query($statusplayerSPELL_BASE_DAMAGE) or die("Could not update player"); $statusplayerHealthPOINTS = "update players set healthpoints='$playerMAX_HEALTH_POINTS' where username='$playerNAME'"; mysql_query($statusplayerHealthPOINTS) or die("Could not update player"); $statusplayerMaxHealthPOINTS = "update players set maxhealthpoints='$playerMAX_HEALTH_POINTS' where username='$playerNAME'"; mysql_query($statusplayerMaxHealthPOINTS) or die("Could not update player"); $statusplayerManaPOINTS = "update players set manapoints='$playerMAX_MANA_POINTS' where username='$playerNAME'"; mysql_query($statusplayerManaPOINTS) or die("Could not update player"); $statusplayerMaxManaPOINTS = "update players set maxmanapoints='$playerMAX_MANA_POINTS' where username='$playerNAME'"; mysql_query($statusplayerMaxManaPOINTS) or die("Could not update player"); } elseif ($playerCLASS === "Mage") { $playerSTR = $playerSTR + 2; $playerDEF = $playerDEF + 2; $playerDEX = $playerDEX + 3; $playerMAG = $playerMAG + 3; $playerBASE_DAMAGE = ceil($playerSTR * $playerDEF); $playerSPELL_BASE_DAMAGE = ceil($playerMAG * $playerDEX); $playerMAX_HEALTH_POINTS = ceil($playerDEF * $playerDEX * $playerMAG); $playerMAX_MANA_POINTS = ceil($playerMAG * $playerDEF * $playerDEX / $playerSTR); } else { } } if ($playerEXPERIENCE &lt; 100) { if (!$playerLEVEL ==1) { $playerLEVEL = 1; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 100; } } elseif ($playerEXPERIENCE &gt;= 100 &amp;&amp; $playerEXPERIENCE &lt;= 200) { if (!$playerLEVEL ==2) { levelUPSTATS (); $playerLEVEL = 2; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 200; } } elseif ($playerEXPERIENCE &gt;= 200 &amp;&amp; $playerEXPERIENCE &lt;= 400) { if (!$playerLEVEL ==3) { levelUPSTATS (); $playerLEVEL = 3; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 400; } } elseif ($playerEXPERIENCE &gt;= 400 &amp;&amp; $playerEXPERIENCE &lt;= 800) { if (!$playerLEVEL ==4) { levelUPSTATS (); $playerLEVEL = 4; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 800; } } elseif ($playerEXPERIENCE &gt;= 800 &amp;&amp; $playerEXPERIENCE &lt;= 1600) { if (!$playerLEVEL ==5) { levelUPSTATS (); $playerLEVEL = 5; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 1600; } } elseif ($playerEXPERIENCE &gt;= 1600 &amp;&amp; $playerEXPERIENCE &lt;= 3200) { if (!$playerLEVEL ==6) { levelUPSTATS (); $playerLEVEL = 6; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 3200; } } elseif ($playerEXPERIENCE &gt;= 3200 &amp;&amp; $playerEXPERIENCE &lt;= 6400) { if (!$playerLEVEL ==7) { levelUPSTATS (); $playerLEVEL = 7; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 6400; } } elseif ($playerEXPERIENCE &gt;= 6400 &amp;&amp; $playerEXPERIENCE &lt;= 12800) { if (!$playerLEVEL ==8) { levelUPSTATS (); $playerLEVEL = 8; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 12800; } } elseif ($playerEXPERIENCE &gt;= 12800 &amp;&amp; $playerEXPERIENCE &lt;= 25000) { if (!$playerLEVEL ==9) { levelUPSTATS (); $playerLEVEL = 9; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 25000; } } elseif ($playerEXPERIENCE &gt;= 25000 &amp;&amp; $playerEXPERIENCE &lt;= 35000) { if (!$playerLEVEL ==10) { levelUPSTATS (); $playerLEVEL = 10; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 35000; } } elseif ($playerEXPERIENCE &gt;= 35000 &amp;&amp; $playerEXPERIENCE &lt;= 50000) { if (!$playerLEVEL ==11) { levelUPSTATS (); $playerLEVEL = 11; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 50000; } } elseif ($playerEXPERIENCE &gt;= 50000 &amp;&amp; $playerEXPERIENCE &lt;= 75000) { if (!$playerLEVEL ==12) { levelUPSTATS (); $playerLEVEL = 12; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 75000; } } elseif ($playerEXPERIENCE &gt;= 75000 &amp;&amp; $playerEXPERIENCE &lt;= 100000) { if (!$playerLEVEL ==13) { levelUPSTATS (); $playerLEVEL = 13; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 100000; } } elseif ($playerEXPERIENCE &gt;= 100000 &amp;&amp; $playerEXPERIENCE &lt;= 135000) { if (!$playerLEVEL == 14) { levelUPSTATS (); $playerLEVEL = 14; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 135000; } } elseif ($playerEXPERIENCE &gt;= 135000 &amp;&amp; $playerEXPERIENCE &lt;= 200000) { if (!$playerLEVEL ==15) { levelUPSTATS (); $playerLEVEL = 15; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 200000; } } elseif ($playerEXPERIENCE &gt;= 200000 &amp;&amp; $playerEXPERIENCE &lt;= 300000) { if (!$playerLEVEL ==16) { levelUPSTATS (); $playerLEVEL = 16; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 300000; } } elseif ($playerEXPERIENCE &gt;= 300000 &amp;&amp; $playerEXPERIENCE &lt;= 420000) { if (!$playerLEVEL ==17) { levelUPSTATS (); $playerLEVEL = 17; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 420000; } } elseif ($playerEXPERIENCE &gt;= 420000 &amp;&amp; $playerEXPERIENCE &lt;= 600000) { if (!$playerLEVEL ==18) { levelUPSTATS (); $playerLEVEL = 18; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 600000; } } elseif ($playerEXPERIENCE &gt;= 600000 &amp;&amp; $playerEXPERIENCE &lt;= 800000) { if (!$playerLEVEL ==19) { levelUPSTATS (); $playerLEVEL = 19; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 800000; } } elseif ($playerEXPERIENCE &gt;= 800000 &amp;&amp; $playerEXPERIENCE &lt;= 1000000) { if (!$playerLEVEL ==20) { levelUPSTATS (); $playerLEVEL = 20; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } else { $playerNEXT_LEVEL = 1000000; } } elseif ($playerEXPERIENCE &gt;= 1000000) { if (!$playerLEVEL ==21) { levelUPSTATS (); $playerLEVEL = 21; $statusplayerLEVELUPDATE = "update players set level='$playerLEVEL' where username='$playerNAME'"; mysql_query($statusplayerLEVELUPDATE ) or die("Could not update player"); } } else { print "N/A"; } </code></pre> <p>problem is that it isn't display any error message.</p> <p>It wont update the stats properly the level doesn't update.</p>
    singulars
    1. PO
      singulars
      1. PTAnswer
    1. This table or related slice is empty.
    1. PTQuestion
    1. USAlex
    1. USJesse
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. PO
      singulars
      1. PTAnswer
    2. PO
      singulars
      1. PTAnswer
    3. PO
      singulars
      1. PTAnswer
    1. VO
      singulars
      1. POphp mysql gaming levelup script issues
      1. This table or related slice is empty.
      1. VTApproveEditSuggestion
    1. COTL; DR: please edit to specify *how* it is not working, include any error messages produced (both to screen and to web logs), and tell us what you've already looked in to.
      singulars
      1. POphp mysql gaming levelup script issues
      1. USderobert
    2. COCan you also format your code a bit better, it's kinda hard to read.
      singulars
      1. POphp mysql gaming levelup script issues
      1. USDarryl Hein
    3. COHow do I go about formatting my code to your likings?
      singulars
      1. POphp mysql gaming levelup script issues
      1. USJesse
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload