Файл: msmenu/msjeweler.php
Строк: 96
<?php
if(isset($_GET['mscraftlink']) && num($_GET['mscraftlink'])!=NULL && $user['level']>=9 && mysql_result(mysql_query("SELECT COUNT(*) FROM `ms_gems` WHERE `id` = '".num($_GET['mscraftlink'])."' AND `user` = '".$user['id']."' AND `quantity` >= '".num(3)."' LIMIT 1"),0)!=0){
$mscraftlink = mysql_fetch_array(mysql_query("SELECT * FROM `ms_gems` WHERE `id` = '".num($_GET['mscraftlink'])."' AND `user` = '".$user['id']."' AND `quantity` >= '".num(3)."' LIMIT 1"));
$msgemsup = $mscraftlink['level']+1;
$mscraftup = mysql_fetch_array(mysql_query("SELECT * FROM `ms_gems` WHERE `level` = '".num($msgemsup)."' AND `user` = '".$user['id']."' LIMIT 1"));
if($mscraftlink['quantity'] > 3){
mysql_query("UPDATE `ms_gems` SET `quantity` = '".num(($mscraftlink['quantity']-3))."' WHERE `id` = '".$mscraftlink['id']."' AND `user` = '".$user['id']."' LIMIT 1");
}elseif($mscraftlink['quantity'] == 3){
mysql_query("DELETE FROM `ms_gems` WHERE `id` = '".$mscraftlink['id']."' AND `user` = '".$user['id']."' LIMIT 1");
}
if($mscraftup['level'] == $msgemsup){
mysql_query("UPDATE `ms_gems` SET `quantity` = '".($mscraftup['quantity']+1)."' WHERE `user` = '".$user['id']."' AND `id` = '".$mscraftup['id']."' LIMIT 1");
$mslevelgems = 'Получен <img src="/img/gems.png" width="24" height="24" /> самоцвет '.$mscraftup['level'].' уровня.';
}else{
mysql_query("INSERT INTO `ms_gems` SET `quantity` = '".num(1)."', `user` = '".$user['id']."', `level` = '".$msgemsup."'");
$mslevelgems = 'Создан <img src="/img/gems.png" width="24" height="24" /> самоцвет '.$msgemsup.' уровня.';
}
/////////////////////////////////////////////////////////////////////////////
//////////// Задания ////////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
$mstoaccept_user_one = mysql_fetch_array(mysql_query("SELECT * FROM `ms_tasks_user` WHERE `user` = '".num($user['id'])."' LIMIT 1"));
$ms_to_accept = 1;
if($mstoaccept_user_one['type_'.$ms_to_accept.''] == $ms_to_accept){
if($mstoaccept_user_one['set_col_'.$ms_to_accept.''] < $mstoaccept_user_one['col_'.$ms_to_accept.'']){
mysql_query("UPDATE `ms_tasks_user` SET `set_col_".$ms_to_accept."` = '".($mstoaccept_user_one['set_col_'.$ms_to_accept.'']+1)."' WHERE `user` = '".$user['id']."' LIMIT 1");
echo $mstoaccept_user_one['set_col_'.$ms_to_accept.''].'/'.$ms_to_accept['col_'.$ms_to_accept.''];
}
}
/////////////////////////////////////////////////////////////////////////////
////////// Конец заданий ////////////////////////////////////////////////////
/////////////////////////////////////////////////////////////////////////////
$text = $mslevelgems;
$_SESSION['msg'] = $text;
header("Location: ../msjeweler");
exit;
}else{
echo '<div class="content">
<img src="/img/pattern-left.png" width="48" height="18" alt="" />
<span>Ювелир</span>
<img src="/img/pattern-right.png" width="48" height="18" alt="" />
</div>
<img src="/img/rshkeq.png" style="width: 100%"/>
<div>
<span class="btni fl center" style="width: 50%; padding: 4px 0;">Объединить</span>
<a class="btni fr center" style="width: 50%; padding: 4px 0;" href="../Link:ILinkListener-MsJaveler;MsAll;">Объединить все</a>
<div class="cb"></div>
</div>';
$user['set'] = 5;
$k_post = mysql_result(mysql_query("SELECT COUNT(*) FROM `ms_gems` WHERE `user` = '".$user['id']."' AND `quantity` >= '".num(3)."'"),0);
if ($k_post==0){
echo '<div class="content" style="padding-top: 0;">
<div style="padding-top: 4px;">
<div class="cltf">
<div class="crtf">
<div class="crbf">
<div class="clbf">
<div class="iborder" style="padding:4px;">
<div>
У Вас нет самоцветов для объединения, <a href="../msthings">разбирайте вещи</a>, чтобы получить самоцветы.
</div>
</div>
</div>
</div>
</div>
</div>
</div>
';
}
$k_page=k_page($k_post,$user['set']);
$page=page($k_page);
$start=$user['set']*$page-$user['set'];
$mslog = mysql_query("SELECT * FROM `ms_gems` WHERE `user` = '".$user['id']."' AND `quantity` >= '".num(3)."' ORDER BY `level` ASC LIMIT $start, $user[set]");
while($msid = mysql_fetch_array($mslog))
{
echo '<div class="content" style="padding-top: 0;">
<div style="padding-top: 4px;">
<div class="cltf">
<div class="crtf">
<div class="crbf">
<div class="clbf">
<div class="iborder" style="padding:4px;">
<div style="text-align:left; padding-top:4px;">
<a class="btni" style="margin-right: 4px;" href="../?msjeweler&mscraftlink='.num($msid['id']).'">
<img src="/img/accept48.png" width="24" height="24" alt="" title=""/> <span>Объединить</span> </a>
<span class="fr">
<span>'.$msid['level'].'</span> ур
<img src="/img/gems.png" width="24" height="24" />
<img src="/img/gems.png" width="24" height="24"/>
<img src="/img/gems.png" width="24" height="24"/>
</span>
<div class="cb"></div>
</div>
</div>
</div>
</div>
</div></div></div></div>';
}
if ($k_page>1)str("../?msjeweler&",$k_page,$page);
echo '<div class="small minor" style="padding-top: 4px;">Ювелир объединяет 3 самоцвета одинакового уровня, в результате получается новый самоцвет на один уровень выше.</div>
</div>
<a class="btnl" href="../mscraft"><img src="/img/smith.png" width="24" height="24" alt="" /> Квартал ремесленников</a>
<a class="btnl" href="./msgems"><img src="/img/gems.png" width="24" height="24" alt=""/> Самоцветы</a>';
}
?>