齋月 寫:
合成大師&限定合成 共存 且 分開資料庫
在mysql裡輸入
- 代碼: 選擇全部
CREATE TABLE `wog_syni` (
`syni_id` int(11) NOT NULL auto_increment,
`syni_result` mediumint(4) unsigned NOT NULL default '0',
`syni_ele1` mediumint(4) unsigned NOT NULL default '0',
`syni_ele2` mediumint(4) unsigned NOT NULL default '0',
`syni_ele3` mediumint(4) unsigned NOT NULL default '0',
`syni_ele4` mediumint(4) unsigned NOT NULL default '0',
`syni_ele5` mediumint(4) unsigned NOT NULL default '0',
PRIMARY KEY (`syni_id`)
) TYPE=MyISAM AUTO_INCREMENT=1 ;
./class/wog_syn.php中
尋找
- 代碼: 選擇全部
case "3":##########special synthetic##########
if(count($_POST["syn"])>5){alertWindowMsg($lang['wog_act_syn_error4']);}
for($ch=0;$ch<5;$ch++)
{if(!$_POST["syn"][$ch] || empty($_POST["syn"])){$_POST["syn"][$ch]=0;}}
$new_arm=$DB_site->query_first("select a.syn_result,b.d_name from wog_syn a,wog_df b where a.syn_ele1=".$_POST["syn"][0]." and a.syn_ele2=".$_POST["syn"][1]." and a.syn_ele3=".$_POST["syn"][2]." and a.syn_ele4=".$_POST["syn"][3]." and a.syn_ele5=".$_POST["syn"][4]." and b.d_id=a.syn_result");
break;
覆蓋成
- 代碼: 選擇全部
case "3":##########special synthetic##########
if(count($_POST["syn"])>5){alertWindowMsg($lang['wog_act_syn_error4']);}
for($ch=0;$ch<5;$ch++)
{if(!$_POST["syn"][$ch] || empty($_POST["syn"])){$_POST["syn"][$ch]=0;}}
$new_arm=$DB_site->query_first("select a.syni_result,b.d_name from wog_syni a,wog_df b where a.syni_ele1=".$_POST["syn"][0]." and a.syni_ele2=".$_POST["syn"][1]." and a.syni_ele3=".$_POST["syn"][2]." and a.syni_ele4=".$_POST["syn"][3]." and a.syni_ele5=".$_POST["syn"][4]." and b.d_id=a.syni_result");
break;
結束
齋月 寫:
加入 限定合成 於後台中
開啟 ./wog/acpleft.php
尋找
- 代碼: 選擇全部
<tr>
<td align="left">
<p><font size="1" face="新細明體">
<input class="text" type="submit" value="合成大師" name="actions"></font></td>
</tr>
後面加上
- 代碼: 選擇全部
<tr>
<td align="left">
<p><font size="1" face="新細明體">
<input class="text" type="submit" value="限定合成" name="actions"></font></td>
</tr>
開啟 ./wog/acpmain.php
尋找
- 代碼: 選擇全部
case "更新合成系統資料庫":
print_header();
admin_syn_sub();
print_footer();
break;
下面加上
- 代碼: 選擇全部
case "限定合成":
print_header();
syni_list();
print_footer();
break;
case "檢視限定合成詳細資訊":
print_header();
admin_syni();
print_footer();
break;
case "更新限定合成資料庫":
print_header();
admin_syni_sub();
print_footer();
break;
同一檔案
尋找
- 代碼: 選擇全部
function admin_syn_sub()
{
...
}
下面加上
- 代碼: 選擇全部
//限定合成
function syni_list()
{
global $DB_site;
?>
<form action="acpmain.php" method="POST" target="_self">
<table borderColor="#4b689e" cellSpacing="0" cellPadding="2" width="97%" align="center" border="1">
<tr>
<td colSpan="15">
</td>
</tr>
<tr>
<td colSpan="14">限定合成管理</td>
</tr>
<tr>
<td>ID</td>
<td>成品編號</td>
<td>材料1編號</td>
<td>材料2編號</td>
<td>材料3編號</td>
<td>材料4編號</td>
<td>材料5編號</td>
</tr><?
$templist=$DB_site->query("select * from wog_syni");
while($getitemlist=$DB_site->fetch_array($templist))
{
$temp_s = $temp_s."<tr><td>".$getitemlist[syni_id]."</td><td>".$getitemlist[syni_result]."</td><td>".$getitemlist[syni_ele1]."</td><td>".$getitemlist[syni_ele2]."</td><td>".$getitemlist[syni_ele3]."</td><td>".$getitemlist[syni_ele4]."</td><td>".$getitemlist[syni_ele5]."</td><td><input type='radio' value='".$getitemlist[syni_id]."' name='temp_syni_id'></td></tr>";
}
echo $temp_s;
?>
</tr>
<tr>
<td colSpan="15" width="748"><input class='text' type="submit" name="Submit" value="更新/新增/送出">刪除已選取合成方式:<input type="checkbox" name="del_syni" value="1"></td>
</tr>
</tbody>
</table>
<input type="hidden" value="<?=$_SESSION["SID"];?>" name="sid">
<input type='hidden' name='actions' value='檢視限定合成詳細資訊'>
</form>
</table>
<?
}
//限定合成管理
function admin_syni()
{
check_ulv();
global $DB_site;
$tempsyn_id = $_POST["temp_syni_id"];
if($_POST["del_syni"] != "1"){
$imodify =$DB_site->query_first("select * from wog_syni where syni_id='".$tempsyn_id."'");
if($imodify)
{
$syni_id = $imodify["syni_id"];
$syni_result = $imodify["syni_result"];
$syni_ele1 = $imodify["syni_ele1"];
$syni_ele2 = $imodify["syni_ele2"];
$syni_ele3 = $imodify["syni_ele3"];
$syni_ele4 = $imodify["syni_ele4"];
$syni_ele5 = $imodify["syni_ele5"];
$iadmin_submode = "更新";
}else{
$syni_id = "";
$syni_result = "";
$syni_ele1 = "";
$syni_ele2 = "";
$syni_ele3 = "";
$syni_ele4 = "";
$syni_ele5 = "";
$iadmin_submode = "新增";
}
?>
<form action="acpmain.php" method="POST" target="_self">
<table borderColor="#4b689e" cellSpacing="0" cellPadding="2" width="320" align="center" border="1">
<tbody>
<tr>
<td colSpan="5" width="320"><?=$iadmin_submode;?>合成方式</td>
</tr>
<tr>
<td colSpan="5" width="320">ID: ( <?=$syn_id;?> )</td>
</tr>
<tr>
<td>成品編號:</td>
<td><?=$syni_result;?></td><td><input class='text' type="text" value="<?=$syni_result;?>" name="syni_result" size="10"></td>
</tr>
<tr>
<td>材料1編號:</td>
<td><?=$syni_ele1;?></td><td><input class='text' type="text" value="<?=$syni_ele1;?>" name="syni_ele1" size="10"></td>
</tr>
<tr>
<td>材料2編號:</td>
<td><?=$syni_ele2;?></td><td><input class='text' type="text" value="<?=$syni_ele2;?>" name="syni_ele2" size="10"></td>
</tr>
<tr>
<td>材料3編號:</td>
<td><?=$syni_ele3;?></td><td><input class='text' type="text" value="<?=$syni_ele3;?>" name="syni_ele3" size="10"></td>
</tr>
<tr>
<td>材料4編號:</td>
<td><?=$syni_ele4;?></td><td><input class='text' type="text" value="<?=$syni_ele4;?>" name="syni_ele4" size="10"></td>
</tr>
<tr>
<td>材料5編號:</td>
<td><?=$syni_ele5;?></td><td><input class='text' type="text" value="<?=$syni_ele5;?>" name="syni_ele5" size="10"></td>
</tr>
<tr>
<td colSpan="3" width="320"><input class='text' type="submit" name="Submit" value="傳送"></td>
</tr>
<tr>
<td colSpan="3">注意事項:</td>
</tr>
<tr>
<td colSpan="3">若將某欄空白或不是輸入數字,則更新資料庫時將自動設為0,也就是"無",成品編號一定要輸入,材料編號也至少輸入兩個,且都不可為0,才可以成為正常的合成方式!</td>
</tr>
</tbody>
</table>
<input type="hidden" value="更新限定合成資料庫" name="actions">
<input type="hidden" value="<?=$syni_id;?>" name="syni_id">
<input type="hidden" value="<?=$iadmin_submode;?>" name="iadminsubmode">
<input type="hidden" value="<?=$_SESSION["SID"];?>" name="sid">
</form>
<?
}else{
$DB_site->query("delete from wog_syni where syni_id='".$tempsyn_id."'");
echo "從wog_syni刪除此合成方式成功!<BR>";
}
}
function admin_syni_sub()
{
check_ulv();
global $DB_site;
$syni_id = $_POST["syni_id"];
$syni_result = $_POST["syni_result"];
$syni_ele1 = $_POST["syni_ele1"];
$syni_ele2 = $_POST["syni_ele2"];
$syni_ele3 = $_POST["syni_ele3"];
$syni_ele4 = $_POST["syni_ele4"];
$syni_ele5 = $_POST["syni_ele5"];
$iadmin_submode = $_POST["iadminsubmode"];
if ($iadmin_submode == "更新"){
$DB_site->query("Update wog_syni set syni_result ='".$syni_result ."',syni_ele1='".$syni_ele1."',syni_ele2='".$syni_ele2."',syni_ele3='".$syni_ele3."',syni_ele4 ='".$syni_ele4."',syni_ele5='".$syni_ele5."' where syni_id='".$syni_id."'");
echo "限定合成更新成功!";
}else{
if($syni_result != ""){
$DB_site->query("INSERT INTO wog_syni (syni_id,syni_result,syni_ele1,syni_ele2,syni_ele3,syni_ele4,syni_ele5)
VALUES ('','".$syni_result ."','".$syni_ele1."','".$syni_ele2."','".$syni_ele3."','".$syni_ele4."','".$syni_ele5."')");
echo "限定合成增加成功!";
}else{
echo "成品編號不可空白!";
}
}
}
結束
終於是用好了 呵呵
感謝 reload0402 的幫助
如有問題再提出 ^^
大家一起討論！
--
