Buy House with level

[weewooz]

sorry to post ere ive in help but no answer how do i set so that you have to be a certain level to buy a house ive imported sql with i think is right but what would i put in estate page ive been serached and one topic but it dont work any help thanks alot again sorry to post here

[Lithium]

Re: Buy House with level

my 2 cents...

It is not in 20 minutes that someone will answer you. 3 posts about the exact same thing is just one step to no one helping you out.

As of your first post about this, IF you read the entire thread instead skipping posts, you'd make it working.

[Pieces]

Re: Buy House with level

I understood a small minority of your post...

[weewooz]

Re: Buy House with level

i mean that you cant buy a certain house to you are the required level the level is what admin will set in php

[Guest Sniko`]

Re: Buy House with level

Open up staff_houses.php

and find

 

print "<h3>Add House</h3><hr />
<form action='staff_houses.php?action=addhouse' method='post'>
Name: <input type='text' name='name' />

Price: <input type='text' name='price' />

Max Will: <input type='text' name='will' />

<input type='submit' value='Add House' /></form>";

 

Replace with

 

print "<h3>Add House</h3><hr />
<form action='staff_houses.php?action=addhouse' method='post'>
Name: <input type='text' name='name' />

Price: <input type='text' name='price' />

Max Will: <input type='text' name='will' />

Level: <input type='text' name='level' />

<input type='submit' value='Add House' /></form>";

 

Now find

 

global $db, $ir, $c, $h, $userid;
$price=abs((int) $_POST['price']);
$will=abs((int) $_POST['will']);
$name=$_POST['name'];
if($price and $will and $name)

 

Replace with

 

global $db, $ir, $c, $h, $userid;
$price=abs((int) $_POST['price']);
$will=abs((int) $_POST['will']);
$name=$_POST['name'];
$lvl=$_POST['level'];
if($price and $will and $name)

 

Now find

 

$db->query("INSERT INTO houses VALUES(NULL, '$name', '$price', '$will')");

 

Replace with

 

$db->query("INSERT INTO houses VALUES(NULL, '$name', '$price', '$will', '$lvl')");

 

Now go to estate.php

find

 

$hq=$db->query("SELECT * FROM houses WHERE hWILL>{$ir['maxwill']} ORDER BY hWILL ASC");

 

Replace with

 

$hq=$db->query("SELECT * FROM houses WHERE hWILL>{$ir['maxwill']} AND hLVL < {$ir['level']} ORDER BY hWILL ASC");

 

SQL

 

ALTER TABLE houses ADD hLVL INT(11) DEFAULT 1;

 

UNTESTED BUT SHOULD WORK

POST ANY BUGS

Thanks

Sniko

[weewooz]

Re: Buy House with level

ty sniko will try now mate