Advice, perhaps I can use MySQL to store varible not session
Posted: Sat Dec 09, 2006 1:09 am
Im wondering, instead of using ($_SESSION['name'])
could I directly store the variable into MySQL
because it needs to add up...
When im playing, like my EXP increases, it needs to store that
Because I have a uhm 450 line code, for 1 monster, and basically 3 stats & some good looking page stuff...
Anyway to do this better? lol
heres my code anyway for the heck of it...
Techniquely unless theres a better easier way, I cant progress, and if there's not I may just have to strip everything back and reorganize it -.-
Been trying to catorgorize a bit better, thinking instead of making a $_SESSION['var'] for each monster and its stats, perhaps just put all the details into my MySQL DB and then set the stats to that of the chosen Monster through MySQL...
Would that be better?
could I directly store the variable into MySQL
because it needs to add up...
When im playing, like my EXP increases, it needs to store that
Because I have a uhm 450 line code, for 1 monster, and basically 3 stats & some good looking page stuff...
Anyway to do this better? lol
heres my code anyway for the heck of it...
Code: Select all
<?php
session_start();
?>
<html>
<body>
<head>
<style type='text/css'>
body
{
background-image:
url('SilverBG.jpg')
}
</style>
</head>
<DIV STYLE='Position: absolute; top: 0; left: 0;'>
<img src="Mythic Aeons Banner.jpg" width="1024" height="1">
</div>
<DIV STYLE='Position: absolute; Top: 250; Left: 90;'>
</div>
<!--<td style="color: #FFFFFF;">lots of text here</td>
Color group of text -->
<?php
//use the $_POST thing for newfight & attk
if(isset($_POST['strBTN']))
{
if($_POST['strBTN'] == 'Str')
{
$_SESSION['tstr'] = true;
$_SESSION['tdex'] = false;
$_SESSION['tdef'] = false;
}
}
if(isset($_POST['dexBTN']))
{
if($_POST['dexBTN'] == 'Dex')
{
$_SESSION['tstr'] = false;
$_SESSION['tdex'] = true;
$_SESSION['tdef'] = false;
}
}
if(isset($_POST['defBTN']))
{
if($_POST['defBTN'] == 'Def')
{
$_SESSION['tstr'] = false;
$_SESSION['tdex'] = false;
$_SESSION['tdef'] = true;
}
}
?>
<DIV STYLE='Position: absolute; Top: 200; Left: 325;'>
<?php
if(isset($_POST['Revive']))
{
if($_POST['Revive'] == 'Revive')
{
if ($_SESSION['maxlife'] <= 0)
{
$_SESSION['clife']=$_SESSION['maxclife'];
echo '<table border=\'3\'> <tr> <td><b>You have been revived</b></td></tr></table>';
}
else
{echo '<table border=\'3\'> <tr> <td><b>You are already alive</b></td></tr></table>';}
}
}
?>
</div>
<DIV STYLE='Position: absolute; Top: 200; Left: 325;'>
<?php
if (isset($_POST['nf']))
{
if ($_POST['nf'] == 'nf2')
{
$_SESSION['currmonster']=isset($_POST['monsters']);
$_SESSION['clifeelf']=$_SESSION['maxlifeelf'];
$_SESSION['sa']=true;
echo '<table border=\'3\'> <tr> <td><b>You challenge a '.$_SESSION['currmonster'].'</b></td></tr></table>';
}
}
?>
</div>
<?php
//warrior stats
//STR set
//i'll have to set the values for the user to the values from the database
if (!isset($_SESSION['strlvl']))
{$_SESSION['strlvl']=4;}
if (!isset($_SESSION['strXP']))
{$_SESSION['strXP']=0;}
if (!isset($_SESSION['ML']))
{$_SESSION['ML']=1;}
if (!isset($_SESSION['strdmg']))
{$_SESSION['strdmg']=1;}
if (!isset($_SESSION['strdiv']))
{$_SESSION['strdiv']=1;}
if (!isset($_SESSION['tstr']))
{$_SESSION['tstr']=true;}
if (!isset($_SESSION['deflvl']))
{$_SESSION['deflvl']=4;}
if (!isset($_SESSION['defptm']))
{$_SESSION['defptm']=0;}
///////////////////////////////////////////////str is above
if (!isset($_SESSION['dexlvl']))
{$_SESSION['dexlvl']=4;}
if (!isset($_SESSION['dexXP']))
{$_SESSION['dexXP']=0;}
if (!isset($_SESSION['dexcth'])) //chance to hit
{$_SESSION['dexcth']=0;}
if (!isset($_SESSION['dexdiv'])) // divides the stat increase
{$_SESSION['dexdiv']=1;}
if (!isset($_SESSION['tdex']))
{$_SESSION['tdex']=false;}
///////////////////////////////////////////////dex is above
if (!isset($_SESSION['clife']))
{$_SESSION['clife']=17;}
if (!isset($_SESSION['maxlife']))
{$_SESSION['maxlife']=17;}
///////////////////////////////////////////////life is above
if (!isset($_SESSION['deflvl']))
{$_SESSION['deflvl']=4;}
if (!isset($_SESSION['defXP']))
{$_SESSION['defXP']=0;}
if (!isset($_SESSION['defptm']))
{$_SESSION['defptm']=0;}
if (!isset($_SESSION['defdiv']))
{$_SESSION['defdiv']=1;}
if (!isset($_SESSION['tdef']))
{$_SESSION['tdef']=false;}
if (!isset($_SESSION['defda']))
{$_SESSION['defda']=0;}
///////////////////////////////////////////////defense is above
if (!isset($_SESSION['dexlvlelf']))
{$_SESSION['dexlvlelf']=4;}
if (!isset($_SESSION['dexcthelf']))
{$_SESSION['dexcthelf']=0;}
if (!isset($_SESSION['mba=elf'])) //monster being attked
{$_SESSION['mba=elf']=true;}
if (!isset($_SESSION['deflvlelf']))
{$_SESSION['deflvlelf']=4;}
if (!isset($_SESSION['MLelf']))
{$_SESSION['MLelf']=1;}
if (!isset($_SESSION['defptmelf']))
{$_SESSION['defptmelf']=0;}
if (!isset($_SESSION['mt=elf'])) //monster type
{$_SESSION['mt=elf']='Elf';}
if (!isset($_SESSION['strlvlelf']))
{$_SESSION['strlvlelf']=13;}
if (!isset($_SESSION['clifeelf']))
{$_SESSION['clifeelf']=5;}
if (!isset($_SESSION['clifemaxelf']))
{$_SESSION['clifemaxelf']=5;}
if (!isset($_SESSION['defdaelf']))
{$_SESSION['defdaelf']=0;}
////////////////////////////////////combatMonster is above
if (!isset($_SESSION['weapon']))
{$_SESSION['weapon']='Fists';}
if (!isset($_SESSION['spell']))
{$_SESSION['spell']='Ignite';}
if (!isset($_SESSION['currmonster'])) //creatingmonster
{$_SESSION['currmonster']='null';}
if (!isset($_SESSION['sa']))
{$_SESSION['sa']=false;}
if (!isset($_SESSION['rnd']))
{$_SESSION['rnd']=0;}
if (!isset($_SESSION['gold']))
{$_SESSION['gold']=10;}
if (!isset($_SESSION['gld2bd']))
{$_SESSION['gld2bd']=0;}
///////////////////////////////////////////////other is above
///////////////////////////////////////////////life is above
if (!isset($_SESSION['deflvl']))
{$_SESSION['deflvl']=4;}
if (!isset($_SESSION['defXP']))
{$_SESSION['defXP']=0;}
if (!isset($_SESSION['defptm'])) //percent to miss
{$_SESSION['defptm']=0;}
///////////////////////////////////////////////int
/*
$_SESSION['strdmg']=1;
$_SESSION['strlvl']=4;
$_SESSION['strdiv']=1;
$_SESSION['strXP']=0;
$_SESSION['ML']=1;
$_SESSION['dexdmg']=1;
$_SESSION['dexlvl']=4;
$_SESSION['dexdiv']=1;
$_SESSION['dexXP']=0;
*/
//int
//$intXP=0;
//$intlvl=2;
//focus
//$focXP=0;
//$foclvl=2;
//lifemagic
//$life=12;
//$mag=3;
//other
//$sxp=0;
//$gold=10;
//multiplications
$br='<br />';
//damage goes here
$_SESSION['strdmg']=$_SESSION['strlvl'] / 4;
//damage goes above
//deal dmg below
$_SESSION['strdmg']=rand(0, $_SESSION['strdmg'] * 1.1);
$_SESSION['strdmg']=round($_SESSION['strdmg']);
$_SESSION['defdaelf']=$_SESSION['MLelf'] * $_SESSION['deflvlelf'];
$_SESSION['defdaelf']=$_SESSION['defdaelf']/100;
echo ' DMG REDUCTION to me '.$_SESSION['defdaelf'];
$_SESSION['strdmg']=$_SESSION['strdmg']-$_SESSION['defdaelf'];
$_SESSION['strdmg']=round($_SESSION['strdmg']);
//monster stuff below
$_SESSION['strdmgelf']=$_SESSION['strlvlelf'] / 4;
//damage goes above
//deal dmg below
$_SESSION['strdmgelf']=rand(0, $_SESSION['strdmgelf'] * 1.1);
$_SESSION['strdmgelf']=round($_SESSION['strdmgelf']);
$_SESSION['defda']=$_SESSION['ML'] * $_SESSION['deflvl'];
$_SESSION['defda']=$_SESSION['defda']/100;
echo ' DMG REDUCTION to he '.$_SESSION['defda'];
$_SESSION['strdmgelf']=$_SESSION['strdmgelf']-$_SESSION['defda'];
$_SESSION['strdmgelf']=round($_SESSION['strdmgelf']);
//monster stuff
if ($_SESSION['mba=elf']==true)
{$_SESSION['dexcth']=rand($_SESSION['ML'], $_SESSION['dexlvl'] * 10);
$_SESSION['dexcthelf']=rand($_SESSION['MLelf'], $_SESSION['dexlvlelf'] * 10);
//damage above
$_SESSION['defptmelf']=rand($_SESSION['MLelf'], $_SESSION['deflvlelf'] * 10);
$_SESSION['defptm']=rand($_SESSION['ML'], $_SESSION['deflvl'] * 10);}
$_SESSION['defptmelf']=$_SESSION['defptmelf']/100;
$_SESSION['dexcthelf']=$_SESSION['dexcthelf']/100;
$_SESSION['dexcth']=$_SESSION['dexcth']/100;
$_SESSION['defptm']=$_SESSION['defptm']/100;
//monster stuff above
$_SESSION['gld2bd']=$_SESSION['MLelf'];
$_SESSION['gld2bd']=rand($_SESSION['gld2bd'], $_SESSION['gld2bd'] * 2.3);
$_SESSION['gld2bd']=round($_SESSION['gld2bd']);
//dealdmg above
echo $br;
?>
<div style='Position: absolute; top: 310; left: 375;'>
<font color='darkblue' size='3'>
<?php
if (isset($_POST['attack']))
{
if ($_SESSION['clifeelf'] < 1)
{
?>
</div>
<div style='Position: absolute; top: 200; left: 325;'>
<?php
echo '<table border=\'3\'> <tr> <td><b>The monster is dead</b></td> </tr> </table>';
}
else
{
if ($_POST['attack'] == 'attk')
{
?>
</div>
<div style='Position: absolute; top: 200; left: 325;'>
<table border='3'>
<tr>
<td>
<?php
echo '<b>You attack a '.$_SESSION['currmonster']. ':</b><br />';
?>
<?php
$_SESSION['currmonster']=$_SESSION['mt=elf'];//later find a way to detect what monster is being attacked
if ($_SESSION['dexcth'] > $_SESSION['defptmelf'])
{
echo "You attack with your ".$_SESSION['weapon']." and hit for ".$_SESSION['strdmg']." damage";
$_SESSION['clifeelf']=$_SESSION['clifeelf']-$_SESSION['strdmg'];
if ($_SESSION['clifeelf'] < 1)
{ $_SESSION['gold']=$_SESSION['gold']+$_SESSION['gld2bd'];}
}
else
{
echo "You attack with your ".$_SESSION['weapon']." and you miss"; $_SESSION['strdmg']=0;
}
echo '<br /> Current Life is '.$_SESSION['clifeelf']. '<br />';
if ($_SESSION['dexcthelf'] > $_SESSION['defptm'])
{
echo '<b>'.$_SESSION['currmonster']. "</b> attacks you and hits you for ".$_SESSION['strdmgelf'];
}
else
{
echo '<b>'.$_SESSION['currmonster']. "</b> attacks you and misses"; $_SESSION['strdmgelf']=0;
}
}
echo $br;
?>
</td>
</tr>
</table>
</div>
</font>
</div>
<?php
//echo 'Elf Chance to Evade '.$defptmelf;
//echo $br;
//echo 'My chance to hit '.$dexcth;
//use if($_SESSION['strlvl' + 'dexlvl' etc..)
?>
</div>
<DIV STYLE='Position: absolute; Top: 200; Left: 13;'>
<font color='darkblue' size='3'>
<?php
// damage delt (to increase XP) below MUST stay at bottom
if ($_SESSION['tstr']==true)
{
$_SESSION['strXP']=$_SESSION['strXP']+$_SESSION['strdmg'];
}
if ($_SESSION['tdex']==true)
{
$_SESSION['dexXP']=$_SESSION['dexXP']+$_SESSION['strdmg'];
}
if ($_SESSION['tdef']==true)
{
$_SESSION['defXP']=$_SESSION['defXP']+$_SESSION['strdmg'];
}
// damage delt (to increase XP) above MUST STAY huh
//XP check below//
if ($_SESSION['strXP']>=$_SESSION['strlvl'] * $_SESSION['strdiv'] * $_SESSION['strlvl'])
{
$_SESSION['strlvl']=$_SESSION['strlvl']+1;
$_SESSION['strdiv']=$_SESSION['strdiv']+1;
}
if ($_SESSION['dexXP']>=$_SESSION['dexlvl'] * $_SESSION['dexdiv'] * $_SESSION['dexlvl'])
{
$_SESSION['dexlvl']=$_SESSION['dexlvl']+1;
$_SESSION['dexdiv']=$_SESSION['dexdiv']+1;
}
if ($_SESSION['defXP']>=$_SESSION['deflvl'] * $_SESSION['defdiv'] * $_SESSION['deflvl'])
{
$_SESSION['deflvl']=$_SESSION['deflvl']+1;
$_SESSION['defdiv']=$_SESSION['defdiv']+1;
}
}
}
// STAT INCREASING ABOVE, Must be huh
//XP check above//
?>
</div>
<DIV STYLE='Position: absolute; Top: 112; Left: 13;'>
<font color='darkblue' size='3'>
<?php
/////////////////////////////////////////Displays the stat bars///////////////////////////////
echo "<font color='darkblue' size='3'><b>Stats</b><br /></font>";
echo "<font color='darkblue' size='3'>Life: ".$_SESSION['clife']." / ".$_SESSION['maxlife'];
echo $br;
echo "<font color='darkblue' size='3'>Str lvl: ".$_SESSION['strlvl'].", Str XP: ".$_SESSION['strXP']. " / ".$_SESSION['strlvl'] * $_SESSION['strdiv'] * $_SESSION['strlvl']. '</font>'. $br;
echo "<font color='darkblue' size='3'>Dex lvl: ".$_SESSION['dexlvl'].", Dex XP: ".$_SESSION['dexXP']. " / ".$_SESSION['dexlvl'] * $_SESSION['dexdiv'] * $_SESSION['dexlvl']. '</font>'. $br;
echo "<font color='darkblue' size='3'>Def lvl: ".$_SESSION['deflvl'].", Def XP: ".$_SESSION['defXP']. " / ".$_SESSION['deflvl'] * $_SESSION['defdiv'] * $_SESSION['deflvl']. '</font>'. $br;
echo "Main Level: ".$_SESSION['ML'];
echo $br;
echo "Gold: ".$_SESSION['gold'];
///////////////////////////////////////Displays Stat Bars/////////////////////////////////////////
////////////////Increases main level//////////
if ($_SESSION['strlvl'] + $_SESSION['dexlvl']>=$_SESSION['ML'] * 7)
{
$_SESSION['ML']=$_SESSION['ML']+1;
$_SESSION['maxlife']=$_SESSION['maxlife']+$_SESSION['ML']*2;
$_SESSION['clife']=$_SESSION['maxlife'];
}
/////////////Increases main level////////////
?>
<div style='Position: absolute; top: 90; left: 700;'>
<form method="post" action="HomePIG.php">
<input type='hidden' name='nf' value='nf2'>
<input type="submit" value="New Fight">
</form>
<form>
<select name="monsters">
<option value="Elf" selected="selected">Elf</option>
<option value="Derani">Derani</option>
<option value="Fierce Rat">Fierce Rat</option>
<option value="Ent">Ent</option>
</select>
</form>
<?php
if ($_SESSION['sa']==true)
{
?>
<form method="post" action="HomePIG.php">
<input type='hidden' name='attack' value='attk'>
<input type="submit" value="Attack">
</form>
<?php
}
?>
<form method="post" action="HomePIG.php">
<input type='hidden' name='Revive' value='Revive'>
<input type="submit" value="Revive">
</form>
</div>
<form method="post" action="HomePIG.php">
<input type='hidden' name='strBTN' value='Str'>
<input type="submit" value="Str">
</form>
<form method="post" action="HomePIG.php">
<input type='hidden' name='dexBTN' value='Dex'>
<input type="submit" value="Dex">
</form>
<form method="post" action="HomePIG.php">
<input type='hidden' name='defBTN' value='Def'>
<input type="submit" value="Def">
</form>
<DIV STYLE='Position: absolute; Top: 220; Left: 13;'>
<font color='darkblue' size='3'>
</div>
<!-- NOTES, later on load the monsters to array, and load the dmg str ALL of it, into an array stat variable matching the monster array and use that for monsters-->
</body>
</html>
<!--
if ($_SESSION['clife'] <= 0)
{
echo 'Monster is dead';
$_SESSION['md']==true;
}-->Been trying to catorgorize a bit better, thinking instead of making a $_SESSION['var'] for each monster and its stats, perhaps just put all the details into my MySQL DB and then set the stats to that of the chosen Monster through MySQL...
Would that be better?