:
Most visitors online was 12487 , on 27 Apr 2024
I need Gold club
- Thread starter harcu
- Start date
- Status
Junior Spellweaver
- Joined
- Jan 7, 2012
- Messages
- 147
- Reaction score
- 100
Gold club isn't added in t3 yet (assuming you mean raid list & trade routes) but there is a crop finder (not searchable by oasis bonus though)
Although if you mean to add a gold club feature (people can buy it and access features) it is simple:
1) Add 'goldclub' column to [PREFIX]users table (tinyint, default being 0 (no gold club)
2) Create file 'goldclub.tpl' in "Templates/Plus":
3) Add this code to "Templates/Plus/3.tpl"
I have quickly wrote this, I have not checked for bugs, but can help if there is any.
You can restrict viewing pages by:
Although if you mean to add a gold club feature (people can buy it and access features) it is simple:
1) Add 'goldclub' column to [PREFIX]users table (tinyint, default being 0 (no gold club)
2) Create file 'goldclub.tpl' in "Templates/Plus":
PHP:
<?php
## Buy Gold Club - aggenkeech
$MyGold = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE `id`='".$session->uid."'") or die(mysql_error());
$golds = mysql_fetch_assoc($MyGold);
$MyId = mysql_query("SELECT * FROM ".TB_PREFIX."users WHERE `id`='".$session->uid."'") or die(mysql_error());
$uuid = mysql_fetch_assoc($MyId);
$MyVilId = mysql_query("SELECT * FROM ".TB_PREFIX."bdata WHERE `wid`='".$village->wid."'") or die(mysql_error());
$uuVilid = mysql_fetch_assoc($MyVilId);
$goldlog = mysql_query("SELECT * FROM ".TB_PREFIX."gold_fin_log") or die(mysql_error());
$today = date("mdHi");
if(mysql_num_rows($MyGold))
{ ## Player exists
if($golds['access'] > 2)
{ ## Player is not banned
if($golds['gold'] > 99)
{
mysql_query("UPDATE ".TB_PREFIX."users set goldclub = 1 where `id`='".$session->uid."'") or die(mysql_error());
mysql_query("UPDATE ".TB_PREFIX."users set gold = ".($session->gold-100)." where `username`='".$session->username."'") or die(mysql_error());
mysql_query("INSERT INTO ".TB_PREFIX."gold_fin_log VALUES ('".(mysql_num_rows($goldlog)+1)."', '".$village->wid."', 'Gold Club')") or die(mysql_error());
$done1 = " Gold Club";
}
else
{
mysql_query("UPDATE ".TB_PREFIX."users set goldclub = 0 where `id`='".$session->uid."'") or die(mysql_error());
$done1 = " You need more gold";
mysql_query("INSERT INTO ".TB_PREFIX."gold_fin_log VALUES ('".(mysql_num_rows($goldlog)+1)."', '".$village->wid."', 'Failed Gold Club')") or die(mysql_error());
}
}
else
{
$done1 = "Nothing has been done";
}
}
else
{
$done1 = "Nothing has been done";
}
print "<BR><BR><BR><BR>";
echo $done1;
print "<BR>";
include("Templates/Plus/3.tpl");
?>3) Add this code to "Templates/Plus/3.tpl"
PHP:
<table class="plusFunctions" cellpadding="1" cellspacing="1">
<thead>
<tr>
<th colspan="5">Gold club</th>
</tr>
<tr>
<td></td>
<td>Description</td>
<td>Duration</td>
<td>Gold</td>
<td>Action</td>
</tr>
</thead>
<tbody>
<tr>
<td class="man">
<a href="#" onClick="return Popup(9,6);"><img class="help" src="img/x.gif" alt="" title="" /></a>
</td>
<td class="desc">
<b><a href="goldclub.php">Gold club</a></b>
<span class="run"> </span>
</td>
<td class="dur">All Round</td>
<td class="cost"><img src="img/x.gif" class="gold" alt="Gold" title="Gold" />100</td>
<td class="act">
<span class="none">
<?php
$sql = mysql_query("SELECT goldclub FROM ".TB_PREFIX."users WHERE id = '".$session->uid."'")or die(mysql_error());
$goldclub = mysql_result($sql, 0);
if (mysql_num_rows($MyGold))
{
if($golds['gold'] > 99)
{
if($goldclub == 0)
{
echo '<a href="plus.php?id=goldclub"><span>Activate';
}
if($goldclub == 1)
{
echo '<span>Already Activated';
}
}
else
{
echo '<a href="plus.php"><span>Not enough Gold';
}
}
?>
</span></a></td>
</tr>
<td colspan="5">Gold Club Activated:
<?php
if($goldclub == 1){ echo Yes; }
if($goldclub == 0){ echo No; }
?>
</td>
</tr>
</tbody>
</table>I have quickly wrote this, I have not checked for bugs, but can help if there is any.
You can restrict viewing pages by:
PHP:
<?php
$sql = "SELECT goldclub FROM ".TB_PREFIX."users WHERE id=".$session->uid."";
$q = mysql_query($sql) or die(mysql_error());
$goldclub = mysql_result($q, 0);
if($goldclub == 0)
{
## no gold club
header("Location: plus.php");
}
else
{ ?>
## Rest of page
<?php
}
?>
Last edited:
is added to TravianZ by me with farmlist and masterbuilder yet.
- Status
RaGEZONE Sponsor
