07-31-2011, 11:31 AM
Im a bit afraid of this tool.Every item in the inventory has a unique Serial.
If there are more inventory spots with the same serials then many strange things can happen ingame.
Maybe u should make it that they can only edit existing items but not adding new items to the inventory
I just change it for you. it will load the Ids to let you know what your adding or editing seals to but doesnt touch the id even if people change it in the editor. this item doesnt use the insert into i use the UPDATE. UPDATE t_inventory SET a_plus0=" & TextBox7.Text & ", a_plus1=" & TextBox8.Text & ", a_plus2=" & TextBox9.Text & ", a_plus3=" & TextBox10.Text & ", a_plus4=" & TextBox11.Text & ", a_option0_type=" & TextBox12.Text & ", a_option0_value=" & TextBox13.Text & ", a_option1_type=" & TextBox14.Text & ", a_option1_value=" & TextBox15.Text & ", a_option2_type=" & TextBox16.Text & ", a_option2_value=" & TextBox17.Text & ", a_option3_type=" & TextBox18.Text & ", a_option3_value=" & TextBox19.Text & ", a_option4_type=" & TextBox20.Text & ", a_option4_value=" & TextBox21.Text & " WHERE a_index=" & Label29.Text & "". does that look good for you. :p