Help Please :)

Scex · December 3, 2008

Hi, im currently learning and progressing in php by making a basic mmorpg for learning purposes only..

but im having trouble with a little section of it, i want "users" to be able to buy villages and for it then to update the km_villages db table aswell as the km_users table.

I would do it all in km_users but i want them to be able to buy multiple villages each with different levels of buildings and troop counts etc. Much like Tribal Wars if anyones played it.

Anyway hers what i have so far.

_<html>

_<table>

_<body>

_<tr>

_{<td colspan=2>}

_{<h2 align="center">TEST</h2>}

_</td>

_</tr>

_<tr>

_{<td >}

_{<h4 align="center">Ram image</h4>}

_</td>

_<td>

_{<form action="buyvil.php" method="post">}

_{<br>Buy villages: <INPUT TYPE="text" name="vil"></p>}

_{<input type="submit" value="Buy">}

_</form>

_</td>

_</tr>

_</table>

_</body>

_</html>

Basic page so i could go through with it, heres buyvil.php

_<?php

_{include 'connect.php';}

_{session_start();}

_?>

_<br><br>

_{<link rel="stylesheet" href="style.css" type="text/css">}

_<?php

_{if (isset($_SESSION['player']))}

_{

_{$player=$_SESSION['player'];}

_{$userstats="SELECT * from km_users where playername='$player'";}

_{$userstats2=mysql_query($userstats) or die("Could not get user stats");}

_{$userstats3=mysql_fetch_array($userstats2);}

_{$vils="SELECT * from km_villages where playername='$player'";}

_{$vils2=mysql_query($vils) or die("Could not get user stats");}

_{$vils3=mysql_fetch_array($vils2);}

_{if(isset($_POST['submit']))}

_{

_{$vil=$_POST['vil'];}

_{$vil=strip_tags($vil);}

_{$vilcost=2000;}

_{$totalcost=$vil*$vilcost;}

_$max=10;

_{$threshold=date("U")-60*1;}

_{$thetime=date("U");}

_{print "<center>";}

_{print "<table class='maintable'>";}

_{print "<tr class='headline'><td><center>Tarenza Warrior Grounds</center></td></tr>";}

_{print "<tr class='mainrow'><td>";}

_if($vil<0)

_{

_{die("You cannot buy negative villages");}

_}

_{else if($totalcost>$userstats3[gold])}

_{

_{die("You do not have that much gold, go back to <A href='index.php'>Main page</a>");}

_}

_{else if($vils3[iD]>$max)}

_{

_{die("You cannot have more than $max villages, go back to <A href='index.php'>Main</a>");}

_}

_{else if($userstats3[lastaction]>$threshold)}

_{

_{die("You have to wait 1 minute after an attack to buy troops, go back to <A href='index.php'>Main</a>.");}

_}

_{else if($vil<=10)}

_{

_{$getarmy="update km_villages set user='$player', type='village', pts=pts+'10', timber=timber+'30', iron=iron+'30', coal=coal+'30' where ID='$vils3[iD]'";}

_{mysql_query($getarmy) or die("Can't get Warriors");}

_{$getarmys="update km_users set gold=gold-'$totalcost' where ID='$userstats3[iD]'";}

_{mysql_query($getarmys) or die("Can't get Warriors");}

_{print "$warr Warriors purchased. Go back to <A href='buyarmy.php'>Recruitment</a>.";}

_}

_{print "</td></tr></table>";}

_}

_else

_{

_{print "Sorry, not logged in please <A href='login.php'>Login</a><br>";}

_}

_?>

and heres the table dump

_{$installusers="CREATE TABLE km_villages (}

_{ID bigint(21) NOT NULL auto_increment,}

_{user varchar(15) NOT NULL default '',}

_{type varchar(15) NOT NULL default 'camp',}

_{pts bigint(21) NOT NULL default '0',}

_{timber int(10) NOT NULL default '70',}

_{iron int(10) NOT NULL default '70',}

_{coal int(10) NOT NULL default '70',}

_{academy int(10) NOT NULL default '0',}

_{intel int(10) NOT NULL default '0',}

_{fort int(10) NOT NULL default '0',}

_{bg int(10) NOT NULL default '0',}

_{hq int(10) NOT NULL default '0',}

_{arena int(10) NOT NULL default '0',}

_{thall int(10) NOT NULL default '0',}

_{tmill int(10) NOT NULL default '0',}

_{imill int(10) NOT NULL default '0',}

_{cmill int(10) NOT NULL default '0',}

_{warrior bigint(20) NOT NULL default '0',}

_{ram bigint(20) NOT NULL default '0',}

_{beserker bigint(20) NOT NULL default '0',}

_{champion bigint(20) NOT NULL default '0',}

_{scout bigint(20) NOT NULL default '0',}

_{trojan bigint(20) NOT NULL default '0',}

_{virus bigint(20) NOT NULL default '0',}

_{archer bigint(20) NOT NULL default '0',}

_{warlock bigint(20) NOT NULL default '0',}

_{paladin bigint(20) NOT NULL default '0',}

_{science bigint(20) NOT NULL default '0',}

_{PRIMARY KEY (ID)}

_)";

_{mysql_query($installusers) or die("Could not install users");}

Anyone got ideas?

Scex · December 3, 2008

I changed

$vils="SELECT * from km_villages where playername='$player'";

$vils2=mysql_query($vils) or die("Could not get user stats");

$vils3=mysql_fetch_array($vils2);

to

$vils="SELECT * from km_villages where user='$player'";

$vils2=mysql_query($vils) or die("Could not get user stats");

$vils3=mysql_fetch_array($vils2);

daveoffy · December 3, 2008

Does it work now with that changed code?

Scex · December 3, 2008

Nope!

peranha · December 3, 2008

what exactly is it doing/not doing and is supposed to??

Scex · December 3, 2008

I am trying to get the user (me) to buy a village and it update my users info to store a village, but i want to be able to buy multiple villages each with different statistics/ amount of troops etc.

So i figured id need a new table for this so Km_villages came along.

When i click buy, it goes to buyvil and shows a blank page.

peranha · December 3, 2008

At the very top of the page put

error_reporting(E_ALL);

and after all the queries add mysql_error() I fixed the one query below for you.

$vils="SELECT * from km_villages where user='$player'";
$vils2=mysql_query($vils) or die("Could not get user stats".mysql_error());
$vils3=mysql_fetch_array($vils2);

Scex · December 3, 2008

Notice: Undefined variable: QUERY_STRING in /home/a6382197/public_html/connect.php on line 2

_<?php

_{parse_str("$QUERY_STRING");}

_{$db = mysql_connect("00000", "00000", "00000") or die("Could not connect.");}

_if(!$db)

_{die("no db");}

_{if(!mysql_select_db("0000",$db))}

_{die("No database selected.");}

_{if(!get_magic_quotes_gpc())}

_{

_{$_GET = array_map('mysql_real_escape_string', $_GET);}

_{$_POST = array_map('mysql_real_escape_string', $_POST);}

_{$_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);}

_}

_else

_{

_{$_GET = array_map('stripslashes', $_GET);}

_{$_POST = array_map('stripslashes', $_POST);}

_{$_COOKIE = array_map('stripslashes', $_COOKIE);}

_{$_GET = array_map('mysql_real_escape_string', $_GET);}

_{$_POST = array_map('mysql_real_escape_string', $_POST);}

_{$_COOKIE = array_map('mysql_real_escape_string', $_COOKIE);}

_}

_?>

That has not ever caused problems with my other forms etc.. so i doubt its that.

premiso · December 3, 2008

Replace

parse_str("$QUERY_STRING");

with

if (isset($QUERY_STRING)) {
   parse_str($QUERY_STRING);
}

But I think $QUERY_STRING assumes register_globals is on, it is better to code it this way:

if (isset($_SERVER['QUERY_STRING'])) {
   parse_str($_SERVER['QUERY_STRING']);
}

Scex · December 3, 2008

OK but this wouldnt be causing me problems in the coding above would it

Sign In

Help Please :)

Recommended Posts

Scex

Link to comment

Share on other sites

Scex

Link to comment

Share on other sites

daveoffy

Link to comment

Share on other sites

Scex

Link to comment

Share on other sites

peranha

Link to comment

Share on other sites

Scex

Link to comment

Share on other sites

peranha

Link to comment

Share on other sites

Scex

Link to comment

Share on other sites

premiso

Link to comment

Share on other sites

Scex

Link to comment

Share on other sites

Join the conversation

Browse

Activity

Important Information