Most visitors online was 12487 , on 27 Apr 2024
Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!
Join Today!<?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");
?>
<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>
<?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
}
?>
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":
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 rel="nofollow" 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 } ?>