Nwm ... i did it myself ...!
Here it is:
Add this to _inc/mfs.class
Code:
/* Marry */
function login() {
if(isset($_POST['login']))
{
$account = secure($_POST['account']);
$password = secure($_POST['password']);
$married = secure($_POST['married']);
check_inject();
$check_accq = mssql_query("Select * from MEMB_INFO where memb___id='$account' and memb__pwd='$password'");
$check_acc = mssql_num_rows($check_accq);
if($check_acc == 0) { echo"<meta http-equiv=\"refresh\" content=\"0\">"; }
else
{
$_SESSION['ip'] = $_SERVER['REMOTE_ADDR'];
$_SESSION['date'] = date("F j, Y, G:i A");
$_SESSION['user'] = $account;
$_SESSION['pass'] = $password;
echo "<meta http-equiv=\"refresh\" content=\"0\">";
}
}
if(isset($_POST['logout']))
{
unset($_SESSION['ip']);
unset($_SESSION['date']);
unset($_SESSION['user']);
unset($_SESSION['pass']);
echo "<meta http-equiv=\"refresh\" content=\"0;url=index.php\">";
}
}
function married_users()
{
$char = secure($_POST['ycharacter']);
$char2 = secure($_POST['acharacter']);
$message = secure($_POST['message']);
$type = secure($_POST['type']);
$user = secure($_SESSION['user']);
check_inject();
$date = date('d/m/Y H:i');
$time = time();
$time12 = $time - 172800;
$check_chr = mssql_num_rows(mssql_query("Select * from Character where AccountID='$user' and Name='$char'"));
$check_chr2 = mssql_num_rows(mssql_query("Select * from Character where AccountID='$user' and Name='$char2'"));
$row = mssql_fetch_array(mssql_query("Select * from Character where Name='$char'"));
$row2 = mssql_fetch_array(mssql_query("Select * from Character where Name='$char2'"));
$row3 = mssql_fetch_array(mssql_query("Select * from married where senderacc='$user'"));
$already = mssql_num_rows(mssql_query("Select * from married where senderacc='$user'"));
$already2 = mssql_num_rows(mssql_query("Select * from marriedusers where priel='$char2'"));
$already3 = mssql_num_rows(mssql_query("Select * from marriedusers where predlojil='$char2'"));
$already4 = mssql_num_rows(mssql_query("Select * from marriedusers where predlojil='$char'"));
$already5 = mssql_num_rows(mssql_query("Select * from marriedusers where priel='$char'"));
if(empty($char) or empty($char2) or empty($user) or empty($message)) { echo"<font color='red'>You cannot leave any fields blank!</font><br>"; $error=1; }
elseif($row['Class'] == 0 or $row['Class'] == 16 or $row['Class'] == 32 or $row['Class'] == 2 or $row['Class'] == 17 or $row['Class'] == 33 or $row['Class'] == 80 or $row['Class'] == 81) { echo"<font color='red'>Your character must to have a 3rd quest !</font>"; $error=1; }
elseif($row2['Class'] == 0 or $row2['Class'] == 16 or $row2['Class'] == 32 or $row2['Class'] == 2 or $row2['Class'] == 17 or $row2['Class'] == 33 or $row2['Class'] == 80 or $row2['Class'] == 81) { echo"<font color='red'>Your partner must to have a 3rd quest !</font>"; $error=1; }
elseif($already != 0) { echo"<font color='red'>This character already waiting for Married !</font><br>"; $error=1; }
elseif($already != 0 and $row3['time'] < $time12) { mssql_query("DELETE from married where senderacc='$user'"); echo"<font color='red'>Please try again... Thank you !</font><br>"; $error=1; }
elseif($already2 != 0) { echo"<font color='red'>This character is Married !</font><br>"; $error=1; }
elseif($already3 != 0) { echo"<font color='red'>This character is Married !</font><br>"; $error=1; }
elseif($already4 != 0) { echo"<font color='red'>This character is Married !</font><br>"; $error=1; }
elseif($already5 != 0) { echo"<font color='red'>This character is Married !</font><br>"; $error=1; }
elseif($row['Married'] > 0) { echo"<font color='red'>Your character is Married !</font><br>"; $error=1; }
elseif($row2['Married'] > 0) { echo"<font color='red'>Your partner is Married !</font><br>"; $error=1; }
elseif($check_chr2 >= 1) { echo"<font color='red'>Second selected character is your, you cant married with your characters!</font><br>"; $error=1; }
elseif($char == $char2) { echo"<font color='red'>First selected character is the same like the second. Please go back and try again!</font><br>"; $error=1; }
elseif($row['Resets'] < 10) { echo"<font color='red'>Your character must have at least 10 Resets to send this invitation!</font><br>"; $error=1;}
elseif($row2['Resets'] < 10) { echo"<font color='red'>Your partner must have at least 10 Resets to send this invitation!</font><br>"; $error=1;}
elseif($check_chr <= 0) { echo"<font color='red'>First selected character is not your. Please go back and try again!</font><br>"; $error=1; }
if($type == normal) {
if($row['Class'] == 35 and $row2['Class'] == 35 and $row['Class'] == 83 and $row2['Class'] == 83) { echo"<font color='red'>If you want to married for woman (woman + woman) you must select Lesbian type. Please go back and try again!</font><br>"; $error=1; }
elseif($row['Class']!= 35 and $row2['Class'] != 35 and $row['Class'] != 83 and $row2['Class'] != 83) { echo"<font color='red'>If you want to married for man (man + man) you must select Gay type. Please go back and try again!2</font><br>"; $error=1; }
}
if($type == gay) {
if($row['Class']!= 35 and $row2['Class'] != 35 and $row['Class'] != 83 and $row2['Class'] != 83) { echo"<font color='red'>You are selected Gay couple and you cant married with Womans (Elf). Please go back and try again!</font><br>"; $error=1; }
}
if($type == lesbian) {
if($row['Class'] == 35 and $row2['Class'] == 35 and $row['Class'] == 83 and $row2['Class'] == 83) { echo"<font color='red'>You are selected Lesbian couple and you cant married with Mans (BK,SM,MG). Please go back and try again!</font><br>"; $error=1; }
}
if($error != 1) {
$a = mssql_query("INSERT INTO married (senderacc,receiveracc,sender,receiver,message,status,type,time,date) VALUES ('$user','$row2[AccountID]','$char','$char2','$message','not','$type','$time','$date')");
echo"<font color='green'>You successful send this invitation to $char2! If she/he approved your invitation, you will be married ! But if she/he unapproved your invitation, you will not Married !</font><br>";
}
}
/* End Marry */
Married.php:
Code:
<?php if(isset($_POST['login']) or isset($_POST['logout'])) { login(); } ?>
<?php
if ($_SESSION['user'] == false) {
echo "
<br>You have to log in system to view this module !
<table border=0 cellspacing=5 cellpadding=0>
<td width='250'>
<form name=login method=post action=>
<table width=100% border=0 cellspacing=1 cellpadding=1>
<tr>
<td width=70><font color=#cccccc>Login ID :</td>
<td>
<input name=account type=text id=account maxlength=10>
</td>
</tr>
<tr>
<td width=70><font color=#cccccc>Password :</td>
<td>
<input name=password type=password id=password maxlength=10>
</td>
</tr>
<td width=70> </td>
</tr>
<tr>
<tr>
<td width=100 align=right><input type=submit class=button name=login value=Login></td>
<td><input type=reset class=button name=Submit2 value=Reset></td>
</tr>
</table>
</form>
</div>
</td>
</table>
";
}
else {
$accuser = secure($_SESSION['user']);
check_inject();
$check_accq = mssql_query("Select * from married where receiveracc='$accuser'");
$check = mssql_num_rows($check_accq);
if ($check > 0) {
echo "<meta http-equiv=\"refresh\" content=\"0;url=?page=marr_request\">";
}
else{
?>
<?php
if(isset($_POST['submit'])) { married_users(); }
?>
<br>With this module, you can married your characters with other characters... :)
<table border=0 cellspacing=5 cellpadding=0>
<td width='250'>
<table width="100%" border="0" cellspacing="1" cellpadding="1">
<tr>
<td align="center" colspan="5">
<select style="width: 220;" onchange="window.location='?page=married&sex='+this.value">
<option value="0" selected>- Choose your sexual orientation -</option>
<option value="normal">- I am Normal (Woman + Man)</option>
<option value="gay">- I am gay (Man + Man)</option>
<option value="lesbian">- I am lesbian (Woman + Woman)</option>
</select>
</td>
<form name="" method="post" action="">
<td><input type='submit' name='logout' class='button' value='Logout' title='Log out from the module'></td>
</form>
</tr>
<? if ($_GET['sex'] == normal)
{ ?>
<form name="" method="post" action="">
<tr><td colspan="5" align="center">Your sexual orientation is <?=$_GET['sex']?>, [<?=$_SESSION['user']?>]</td></tr>
<tr>
<td width="70"><font color=black>Your Character:</td>
<td>
<select name="ycharacter" style="width: 121;"><optgroup label="Hero for Married">
<?php
$charq = mssql_query("SELECT [Name] FROM [Character] where AccountID='$_SESSION[user]'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"<option value='$row[0]'><b>$row[0]</b></option>";
}
?>
</select>
</td>
</tr>
<tr>
<td width="70"><font color=black>Your partner:</td>
<td>
<select name="acharacter" style="width: 121;"><optgroup label="Choose your partner">
<?php
$charq = mssql_query("SELECT [Name] FROM [Character] where AccountID!='$_SESSION[user]'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"<option value='$row[0]'><b>$row[0]</b></option>";
}
?>
</select>
<input type="hidden" name="type" value="<?=$_GET['sex']?>">
</td>
</tr>
<tr>
<td align="center" colspan="5"><input type="text" name="message" style="width: 220; height: 15; text-align: center;" maxlength="100" value="You message to your next wife/husband..."></td>
</tr>
<tr>
<td width="70"> </td>
</tr>
<tr>
<tr>
<td width="100" align="right"><input type="submit" class=button name="submit" value="Submit"></td>
<td><input type="reset" class=button name="Submit2" value="Reset"></td>
</tr>
</form>
<?}
elseif($_GET['sex'] == gay)
{?>
<form name="" method="post" action="">
<tr><td colspan="5" align="center">Your sexual orientation is <?=$_GET['sex']?></td></tr>
<tr>
<td width="70"><font color=black>Your Character:</td>
<td>
<select name="ycharacter" style="width: 121;"><optgroup label="Hero for Married">
<?php
$charq = mssql_query("SELECT [Name] FROM [Character] where class!='32' and class!='33' and class!='35' and class!='80' and class!='81' and class!='83' and AccountID='$_SESSION[user]'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"<option value='$row[0]'><b>$row[0]</b></option>";
}
?>
</select>
</td>
</tr>
<tr>
<td width="70"><font color=black>Your partner:</td>
<td>
<select name="acharacter" style="width: 121;"><optgroup label="Choose your partner">
<?php
$charq = mssql_query("SELECT [Name] FROM [Character] where class!='32' and class!='33' and class!='35' and class!='80' and class!='81' and class!='83' and AccountID!='$_SESSION[user]'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"<option value='$row[0]'><b>$row[0]</b></option>";
}
?>
</select>
<input type="hidden" name="type" value="<?=$_GET['sex']?>">
</td>
</tr>
<tr>
<td align="center" colspan="5"><input type="text" name="message" style="width: 220; height: 15; text-align: center;" maxlength="100" value="You message to your next wife/husband..."></td>
</tr>
<tr>
<td width="70"> </td>
</tr>
<tr>
<tr>
<td width="100" align="right"><input type="submit" class=button name="submit" value="Submit"></td>
<td><input type="reset" class=button name="Submit2" value="Reset"></td>
</tr>
</form>
<?}
elseif($_GET['sex'] == lesbian) {?>
<form name="" method="post" action="">
<tr><td colspan="5" align="center">Your sexual orientation is <?=$_GET['sex']?></td></tr>
<tr>
<td width="70"><font color=black>Your Character:</td>
<td>
<select name="ycharacter" style="width: 121;"><optgroup label="Hero for Married">
<?php
$charq = mssql_query("SELECT [Name] FROM [Character] where class!='0' and class!='1' and class!='3' and class!='16' and class!='17' and class!='19' and class!='48' and class!='50' and class!='64' and class!='66' and class!='96' and class!='98' and AccountID='$_SESSION[user]'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"<option value='$row[0]'><b>$row[0]</b></option>";
}
?>
</select>
</td>
</tr>
<tr>
<td width="70"><font color=black>Your partner:</td>
<td>
<select name="acharacter" style="width: 121;"><optgroup label="Choose your partner">
<?php
$charq = mssql_query("SELECT [Name] FROM [Character] where class!='0' and class!='1' and class!='3' and class!='16' and class!='17' and class!='19' and class!='48' and class!='50' and class!='64' and class!='66' and class!='96' and class!='98' and AccountID!='$_SESSION[user]'");
for($i=0;$i < mssql_num_rows($charq);++$i)
{
$row = mssql_fetch_row($charq);
echo"<option value='$row[0]'><b>$row[0]</b></option>";
}
?>
</select>
<input type="hidden" name="type" value="<?=$_GET['sex']?>">
</td>
</tr>
<tr>
<td align="center" colspan="5"><input type="text" name="message" style="width: 220; height: 15; text-align: center;" maxlength="100" value="You message to your next wife/husband..."></td>
</tr>
<tr>
<td width="70"> </td>
</tr>
<tr>
<tr>
<td width="100" align="right"><input type="submit" class=button name="submit" value="Submit"></td>
<td><input type="reset" class=button name="Submit2" value="Reset"></td>
</tr>
</form>
<?}}}?>
</table>
</div>
</td>
</table>
marr_request.php
Code:
<?php if(isset($_POST['login'])) { login(); } ?>
<?php
if ($_SESSION['user'] == false) {
echo "<meta http-equiv=\"refresh\" content=\"0;url=?page=married\">";
}
else {
$accuser = secure($_SESSION['user']);
check_inject();
$check_accq = mssql_query("Select * from married where receiveracc='$accuser' and status='not'");
$check = mssql_num_rows($check_accq);
$row = mssql_fetch_array($check_accq);
$date = date("F j, Y, G:i A");
$time = time();
if($row['type'] == normal) { $type = "Normal"; }
elseif($row['type'] == gay) { $type = "Gays"; }
elseif($row['type'] == lesbian) { $type = "Lesbians"; }
if($_GET['id'] == agree and $check > 0)
{
mssql_query("INSERT INTO marriedusers (predlojil,priel,message,type,date,time) VALUES ('$row[sender]','$row[receiver]','$row[message]','$type','$date','$time')");
mssql_query("delete from married where receiveracc='$accuser'");
mssql_query("UPDATE Character set Married='1',MarryName='$row[sender]' where Name='$row[receiver]'");
mssql_query("UPDATE Character set Married='1',MarryName='$row[receiver]' where Name='$row[sender]'");
echo "<script language=\"JavaScript\">alert (\"You successful accept this married !\");</script>";
echo "<meta http-equiv=\"refresh\" content=\"0;url=?page=married\">";
}
elseif($_GET['id'] == idont and $check > 0)
{
mssql_query("delete from married where receiveracc='$accuser'");
}
if ($check > 0) {
?>
<br>Here you can check your requestions for Married
<table border="0" cellspacing="5" cellpadding="0">
<td width='400'>
<table width="100%" border="0" cellspacing="1" cellpadding="1" class='tmem'>
<tr>
<td align="center">Request By</td>
<td align="center">Request To</td>
<td align="center">Yes or No</td>
</tr>
<tr>
<td align="center"><?=$row['sender']?></td>
<td align="center"><?=$row['receiver']?></td>
<td align="center"><a href="?page=marr_request&id=agree" style="border-bottom: 1px dashed;">I agree</a> <a href="?page=marr_request&id=idont" style="border-bottom: 1px dashed;">I don't</a></td>
</tr>
<tr>
<td align="center" colspan="3"> </td>
</tr>
<tr>
<td align="center" colspan="3">Message sended from <?=$row['sender']?> to you:</td>
</tr>
<tr>
<td align="center" colspan="3"><?=$row['message']?></td>
</tr>
<?}
else{
echo "<meta http-equiv=\"refresh\" content=\"0;url=?page=married\">";
}}?>
</table>
</div>
</td>
</table>
SQL Query
Code:
USE [MuOnline]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[married]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[married]
GO
CREATE TABLE [dbo].[married] (
[senderacc] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[receiveracc] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[sender] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[receiver] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[message] [varchar] (1800) COLLATE Chinese_PRC_CI_AS NULL ,
[status] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[type] [varchar] (10) COLLATE Chinese_PRC_CI_AS NULL ,
[time] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL ,
[date] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL
) ON [PRIMARY]
GO
I made it a simple page based on diablo71's web - removed almost everything ... only Marry link and Hall of Fame left. So until i figure out how to make it as a module for MuCore i'll use it as a web in web :P
P.S.: Thanks anyway for your help! I don't believe none knows how to do it - this community gets worse by the day ... and i'm starting to get sick of it!
Marry module for MuCore 1.0.8
Originally Posted by diablo71
Here is new module for my web:
