add spels collumns and dont working in battles

winzombie commented 8 years ago

Couldn't insert new item

DEBUGGAGE

Ошибка SQL: 1054 Unknown column 'spell_auth' in 'field list'

Запрос SQL:
INSERT INTO phpbb_adr_shops_spells ( spell_id , spell_owner_id , item_type_use , spell_name , spell_desc , spell_icon , spell_power , spell_class , spell_alignment , spell_element_restrict , spell_level , spell_add_power , spell_mp_use , spell_max_skill , spell_element , spell_element_str_dmg , spell_element_same_dmg , spell_element_weak_dmg , spell_auth , spell_linked_item , spell_items_req , spell_battle , spell_xtreme , spell_xtreme_battle , spell_xtreme_pvp ) VALUES ( 1 , 1 , 11 , 'огнево', 'фигачет пламенем в тушку врага' , '' , 2 , '1,' , '0,' , '0,' , 1 , 1 , 1 , 0 , 4 , 100 , 50 , 10 , 0 , 0 , '513:1' , 0 , '' , '' , '' )

Линия: 716
Файл: D:\drou\EasyPHP\www\admin\admin_adr_forums_shop_spells.php

Ошибка в коде:
Линия-710:     $sql = "INSERT INTO " . ADR_SHOPS_SPELLS_TABLE . " 
Линия-711:     ( spell_id , spell_owner_id , item_type_use , spell_name , spell_desc , spell_icon , spell_power , spell_class , spell_alignment , spell_element_restrict , spell_level , spell_add_power , spell_mp_use , spell_max_skill , spell_element , spell_element_str_dmg , spell_element_same_dmg , spell_element_weak_dmg , spell_auth , spell_linked_item , spell_items_req , spell_battle , spell_xtreme , spell_xtreme_battle , spell_xtreme_pvp ) 
Линия-712:     VALUES ( $item_id , 1 , $item_type , '" . str_replace("\'", "''", $item_name) . "', '" . str_replace("\'", "''", $item_desc) . "' , '" . str_replace("\'", "''", $item_icon) . "' , $item_power , '$item_class_limit' , '$item_alignment_limit' , '$item_element_restrict_limit' , $item_level , $item_add_power , $item_mp_use , $item_max_skill , $item_element , $item_element_str , $item_element_same , $item_element_weak , $item_auth , $item_linked_item , '".$final_req_list."' , $item_battle , '$item_xtreme' , '$item_xtreme_battle' , '$item_xtreme_pvp' )"; 
Линия-713:     $result = $db->sql_query($sql); 
Линия-714:     if( !$result ) 
Линия-715:     { 
Линия-716!     message_die(GENERAL_ERROR, "Couldn't insert new item", "", __LINE__, __FILE__, $sql); 
Линия-717:     } 
Линия-718:   
Линия-719:     adr_previous( Adr_spells_spell_successful_added , admin_adr_forums_shop_spells , '' ); 
Линия-720:

winzombie commented 8 years ago

need add spell_auth int( 1 ) NOT NULL default '0', spell_linked_item int(8) NOT NULL default '0', spell_items_req text NOT NULL default '',

winzombie commented 8 years ago

i add spell but it dont do anithing in battle, only use mana

vendethiel commented 8 years ago

I'll test it at some point. It's definitely not ready yet.

vendethiel commented 8 years ago

@winzombie can you tell me which mod that's from?

winzombie commented 8 years ago

Advanced_Spell_Mod but idk your version

vendethiel commented 8 years ago

I'll try to take a look this weekend