蛋治 寫:那個改成每一件裝備都抓應該怎麼改...
請問可以示範一小部分嗎?
或者你需要什麼code才能做示範?
我可以提供一下0,0
不知道你用哪一個版本,下面是V4.5的範例
V3做法也是一樣,裝備欄位沒這麼多,code也會更少
JS端可以不用改
只要改PHP端
1
在wog_player_arm ,這張table裡面查出玩身上所有裝備的ID
像這樣
select a_id,d_body_id,d_head_id,d_hand_id,d_foot_id,d_item_id,d_item_id2,s_a_id,s_body_id,s_head_id,s_hand_id,s_foot_id,s_item_id,p_a_id,p_body_id,p_head_id,p_hand_id,p_foot_id,p_item_id,d_item_num,d_item_num2 from wog_player_arm where p_id=$user_id
2.
定義所有屬性
$d_at=0
$d_mat=0
$d_df=0
$d_mdf=0
$d_str=0
$d_agi=0
$d_smart=0
$d_life=0
$d_vit=0
$d_au=0
$d_b=0
$d_hp=0
$d_sp=0
3.
接著查出所有裝備品的屬性,
SELECT d_at,d_mat,d_g_hp,d_g_sp,d_g_str,d_g_smart,d_g_agi,d_g_life,d_g_vit,d_g_au,d_g_be FROM wog_df WHERE d_id=a_id
SELECT d_at,d_mat,d_g_hp,d_g_sp,d_g_str,d_g_smart,d_g_agi,d_g_life,d_g_vit,d_g_au,d_g_be FROM wog_df WHERE d_id=d_body_id
SELECT d_at,d_mat,d_g_hp,d_g_sp,d_g_str,d_g_smart,d_g_agi,d_g_life,d_g_vit,d_g_au,d_g_be FROM wog_df WHERE d_id=d_head_id
魔石的話
wog_stone_setup
wog_stone_temp
要從這兩張table去查屬性
魔石屬性抓取有點複雜,要自己去查一下了
精鍊的話
wog_plus_setup
從這張table去查屬性
SELECT d_at,d_mat,d_df,d_mdf,d_str,d_agi,d_smart,d_life,d_vit,d_au,d_be from wog_plus_setup where p_id=$user_id and d_id=p_a_id
SELECT d_at,d_mat,d_df,d_mdf,d_str,d_agi,d_smart,d_life,d_vit,d_au,d_be from wog_plus_setup where p_id=$user_id and d_id=p_body_id
4.
然後把相關屬性加總
$d_at =d_at(裝備基礎屬性)+d_at(魔石屬性)+d_at(精鍊屬性)
$d_mat =d_mat(裝備基礎屬性)+d_mat(魔石屬性)+d_mat(精鍊屬性)
5.
執行
UPDATE wog_player SET at=at-$d_at,mat=mat-$d_mat,df=df-$d_df,mdf=mdf-$d_mdf,agi=agi-$d_agi,str=str-$d_str,life=life-$d_life,vit=vit-$d_vit,smart=smart-$d_smart,hp=hp-$d_hp,sp=sp-$d_sp,au=au-$d_au,be=be-$d_be, WHERE p_id=$user_id
update wog_player_arm set
a_id='',d_body_id='',d_head_id='',d_hand_id='',d_foot_id='',d_item_id='',d_item_id2='',s_a_id='',s_body_id='',s_head_id='',s_hand_id='',s_foot_id='',s_item_id='',p_a_id='',p_body_id='',p_head_id='',p_hand_id='',p_foot_id='',p_item_id='',d_item_num='',d_item_num2='' where p_id=$user_id
6.
組合卸下後的物品ID
規則如下
裝備ID:魔石ID&精鍊ID:符號是魔石的分割符號
&符號是精鍊的分割符號
update wog_item set a_id=a_id+組合後的物品ID,d_body_id+組合後的物品ID....... where p_id=$user_id