public void onPickupItem(NetworkMessage netMsg) { moveItem item = netMsg.ReadMessage <moveItem>(); MySqlConnection conn; int playerID = getCharacterIDFromDir(item.player); Debug.Log("wew from pickup: " + item.player + " : " + playerID); mysqlNonQuerySelector(out conn, "INSERT INTO inventory (playerID, itemID, WAtt, MAtt, Luk, position) VALUES ('" + playerID + "','" + item.item1[0] + "','" + item.item1[1] + "','" + item.item1[2] + "','" + item.item1[3] + "','" + item.item1[4] + "')"); conn.Close(); }
public void moveItem(int[] itemMoved, int[] itemReplaced, short packetType, Player player) { moveItem item = new moveItem(); item.item1 = itemMoved; item.item2 = itemReplaced; item.player = player.playerName; item.position = new float[] { player.transform.position.x, player.transform.position.y, player.transform.position.z }; con.Send(packetType, item); }
public void moveItem(Item itemMoved, Item itemReplaced, short packetType, Player player) { moveItem item = new moveItem(); item.item1 = Tools.objectToByteArray(itemMoved); item.item2 = Tools.objectToByteArray(itemReplaced); item.player = player.playerName; //item.position = new float[] { player.transform.position.x, player.transform.position.y, player.transform.position.z}; con.Send(packetType, item); }
public void onDropItem(NetworkMessage netMsg) { moveItem item = netMsg.ReadMessage <moveItem>(); MySqlConnection conn; MySqlDataReader reader; int characterID = getCharacterIDFromDir(item.player); //Debug.Log("wew from drop: " + item.name + " : " + sqlItemStatement(item.item1)); mysqlReader(out conn, out reader, "SELECT * FROM inventory WHERE characterID = " + characterID + " AND " + sqlItemStatement(item.item1) + ""); mysqlNonQuerySelector(out conn, "DELETE FROM inventory WHERE characterID = " + characterID + " AND " + sqlItemStatement(item.item1) + ""); conn.Close(); GameObject itemObject = spawnObject("Drop", new Vector3(item.position[0], item.position[1], item.position[2])); }
public void onChangeItem(NetworkMessage netMsg) { moveItem item = netMsg.ReadMessage <moveItem>(); MySqlConnection conn; //ServerDebug("hello from server"); int playerID = getCharacterIDFromDir(item.player); Debug.Log("item1: " + item.item1[8] + " item2: " + item.item2[8]); mysqlNonQuerySelector(out conn, "UPDATE inventory SET position = '" + item.item1[8] + "' WHERE characterID = '" + playerID + "' AND " + sqlItemStatement(item.item1) + ""); if (item.item2[0] != -1) { mysqlNonQuerySelector(out conn, "UPDATE inventory SET position = '" + item.item2[8] + "' WHERE characterID = '" + playerID + "' AND " + sqlItemStatement(item.item2) + ""); } conn.Close(); }
public void onChangeItem(NetworkMessage netMsg) { moveItem item = netMsg.ReadMessage <moveItem>(); MySqlConnection conn; //ServerDebug("hello from server"); int playerID = getCharacterIDFromDir(item.player); Debug.Log("item1: " + item.item2[Tools.ITEM_PROPERTY_SIZE - 1] + " item2: " + item.item1[Tools.ITEM_PROPERTY_SIZE - 2] + " item2: " + item.item1[0]); mysqlNonQuerySelector(out conn, "UPDATE inventory SET position = '" + item.item1[Tools.ITEM_PROPERTY_SIZE - 1] + "' WHERE id = '" + item.item1[Tools.ITEM_PROPERTY_SIZE - 3] + "'"); if (item.item2[0] != -1) { mysqlNonQuerySelector(out conn, "UPDATE inventory SET position = '" + item.item2[Tools.ITEM_PROPERTY_SIZE - 1] + "' WHERE id = '" + item.item2[Tools.ITEM_PROPERTY_SIZE - 3] + "'"); } conn.Close(); }