[Release] MuCore Exchange Online Time Module

[0pTi]

<fieldset> <legend>ONLINE TO CREDITS EXCHANGER</legend><table align=center border=0 width=500><tr><td align=center>
<?


if(!isset($_SESSION['user_auth_id'])) { die("You need to be logged in."); }$name = $_SESSION['user_auth_id'];
$query = mssql_query("Select OnlineHours from MEMB_STAT where memb___id='$name'");
$hour = mssql_fetch_row($query);
$hours = $hour[0];
if(!isset($_POST['agree']))
{


?><form action="" method="post" name="module">


<table style="padding-left: 10px;" border="0" cellpadding="0" cellspacing="4" width="100%">
<tbody><tr>
<td align="left">Your Online Hours : <b><font color="#2e9e1b"><? if($hours == "") { $hours = "0"; } echo($hours); ?></font></b></td>
</tr>
<tr>
<td align="left">You Will Get : <b><em><? $k = $hours*10; echo($k); ?>
<font color="red">Credits</font></em></b></td>
</tr>
<tr>
<td align="left"><div align="right"><strong>
<input name="agree" type="submit" id="agree" value="Exchange">
</strong></div></td>
</tr>
</tbody></table>
</form>
<?
}
else
{
$name = $_SESSION['user_auth_id'];
$queryy = mssql_query("Select OnlineHours from MEMB_STAT where memb___id='$name'");
$hr = mssql_fetch_row($queryy);
$hh = $hr[0];


$mm = mssql_query("Select connectstat from MEMB_STAT where Memb___id='$name'");
$fmm = mssql_fetch_row($mm);
if($fmm[0] == "1")
{
die("<strong>You need to be <font color=red>OFFLINE</font> before you trade your hours.</strong>");
}
$credit = mssql_query("Select Credits from MEMB_CREDITS where memb___id='$name'");
$cr = mssql_fetch_row($credit);
$k = $hh * 10 + $cr[0];
mssql_query("Update MEMB_CREDITS set Credits='$k' where memb___id='$name'");
mssql_query("Delete from MEMB_STAT where memb___id='$name'");
$queryyy = mssql_query("Select OnlineHours from MEMB_STAT where memb___id='$name'");
$hrr = mssql_fetch_row($queryyy);
$hhh = $hrr[0];
echo("<strong>You have now <font color=red>".$k." Credits</font> and <font color=red>0</font> Online Hours</strong>");
}
?>
</td></tr></table></fieldset>

Anyone can check this script?

Cause it doesn't counts the online time of my players T.T

 

[ianvalls90]

Anyone can check this script?

Cause it doesn't counts the online time of my players T.T

That's not a script error, it's a database error....anyways I suggest you to use 4FUNer's version of this module....it works better .

 

[0pTi]

That's not a script error, it's a database error....anyways I suggest you to use 4FUNer's version of this module....it works better .

Can you send me the link ? Thanks

 

[ianvalls90]

Can you send me the link ? Thanks

search it.-
Go to 4FUNer's profile, and check started threads by him, you'll find it there & its faster than asking people to throw a link.

 

[titansmu]

can u make a guide how to make it work, i still got 0 credits and 0 online hours, i am using MUENGINE FREE VERSION REPACK BY SCRIPTKID

and in mucore it still shows 0 online hours

 

[franlley]

is this module not working anymore ?
I've done from A to Z

Still got 0 credits & 0 hours !

 

[Jack Whoo]

WZ_DISCONNECT_MEMB from page 1 (TotalTime) doesn't disconnect some players some times. They still show on the server at Online Players even if they are not. ConnectStats remain 1 sometimes when players disconnect. Why ? I use the same WZ_DISCONNECT_MEMB from the page 1 of this topic.

 

[PositiveMu]

Installed this module and added query sql. All done like in guide and comments but there is a problem:

It does not count online hours.
In sql MEMB table TotalTime is okay it counts.
Help me with that. What would be a problem?

 

[pretendor]

hope someone can assist me with this.
i want to create a wcoins info page like credits in mucore 1.0.8
but i really don't know how to define the wcoins to select from DB.

please help me with this



nevermind allready fixed this part now the ingamestore wont show my coins...but will fix that later

 

[dragiukas]

Thanks for good module.

 

[0pTi]

what is the totaltime for Season 8 Episode 2 Database?

 

[jlmandin]

please help im noob can anyone give me a tutorial step by step in adding new query im using sql 2000 please help me

 

[pablo234]

help him