121
Items / Re: Item request: Lotery
« on: June 25, 2007, 01:38:47 am »
An option? Wouldn't that be the only way it could work...?
cuz really... That's how it works right now...
cuz really... That's how it works right now...
This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.
// Registration options are always default options...
if($referrer > 0)
{
$query = db_query("SELECT value FROM {$db_prefix}settings WHERE variable = 'shopRegAmount'", __FILE__, __LINE__);
$refural= mysql_fetch_assoc($query);
$ammountGiven = $refural['value']/'2';
$query2 = db_query ("SELECT moneyBank FROM {$db_prefix}members WHERE ID_MEMBER = '$referrer'", __FILE__, __LINE__);
$result = mysql_fetch_assoc($query2);
$bank = $result['moneyBank'];
if ($ammountGiven == 0) $ammountGiven = 500;
$newBank= $bank+$ammountGiven;
$query = db_query ("UPDATE {$db_prefix}members
SET moneyBank = '$newBank'
WHERE ID_MEMBER = '$referrer'", __FILE__, __LINE__);
}
if($referrer > 0)
{
$query = db_query("SELECT value FROM {$db_prefix}settings WHERE variable = 'shopRegAmount'", __FILE__, __LINE__);
$refural= mysql_fetch_assoc($query);
$ammountGiven = $refural['value']/'2';
$query2 = db_query ("SELECT money FROM {$db_prefix}members WHERE ID_MEMBER = '$referrer'", __FILE__, __LINE__);
$result = mysql_fetch_assoc($query2);
$pocket = $result['money'];
if ($ammountGiven == 0) $ammountGiven = 500;
$newPocket= $pocket+$ammountGiven;
$query = db_query ("UPDATE {$db_prefix}members
SET money= '$newPocket'
WHERE ID_MEMBER = '$referrer'", __FILE__, __LINE__);
}
if($referrer > 0)
{
$query = db_query("SELECT * FROM {$db_prefix}settings", __FILE__, __LINE__);
$refural= mysql_fetch_assoc($query);
$ammountGiven = $refural['shopRegAmount']/2;
$query2 = db_query ("SELECT * FROM {$db_prefix}members WHERE ID_MEMBER = '$referrer'", __FILE__, __LINE__);
$result = mysql_fetch_assoc($query2);
$bank = $result['moneyBank'];
if ($ammountGiven == 0) $ammountGiven = 500;
$newBank= $bank+$ammountGiven;
$query = db_query ("UPDATE {$db_prefix}members
SET moneyBank = '$newBank'
WHERE ID_MEMBER = '$referrer'", __FILE__, __LINE__);
}
global $boardurl, $db_prefix, $scripturl;
$result = db_query("
SELECT name, level, age, ownerid, breed
FROM {$db_prefix}shop_pets
ORDER BY level
DESC LIMIT 0,1", __FILE__, __LINE__);
$StrongestPet= mysql_fetch_assoc($result);
$ForumMember = mysql_query("
SELECT realName
FROM {$db_prefix}members
WHERE ID_MEMBER = $StrongestPet[ownerid]");
$MemberName = mysql_fetch_assoc($ForumMember);
echo '
<table width="100%" height="100%">
<tr>
<td align="center">'.$StrongestPet['name'].' the '.$StrongestPet[breed].'
</td>
</tr>
<td align="center">
<img src="'.$boardurl.'/Sources/shop/pet_images/'.$StrongestPet[breed].'.gif">
</td>
</tr>
<tr>
<td align="center">
Level:'.$StrongestPet['level'].'
</td>
</tr>
<tr>
<tr>
<td>
Owner: <a href="'.$scripturl.'?action=profile;u='.$StrongestPet['ownerid'].'">'.$MemberName['realName'].'</a>
</td>
</tr>
</table>';