I did this on friday afternoon
You can now do neater mysql insert querys now. It's unique, fast and easier to read.
Not alot of updates atm, Development will sprout again when my friend matty13 (mattysouthall) adds the pathfinder; I've never done one so I plan to learn from him
Before
Code:
/*dbClient.ExecuteQuery("INSERT INTO room_items (`mID`, `x_axis`, `y_axis`, `rotation`, `sprite_id`, `trigger`, `isWallItem`) VALUES "
+ "('" + Client.GetHabbo().RoomId + "', '" + mX + "','" + mY + "', '" + mRotation + "', '" + mItem.SpriteID + "', 1, 0);");*/
After
Code:
Dictionary<string, object> KeyWithValue = new Dictionary<string, object>();
KeyWithValue.Add("mID", Client.GetHabbo().RoomId);
KeyWithValue.Add("x_axis", mX);
KeyWithValue.Add("y_axis", mY);
KeyWithValue.Add("rotation", mRotation);
KeyWithValue.Add("sprite_id", mItem.SpriteID);
KeyWithValue.Add("trigger", 0);
KeyWithValue.Add("isWallItem", Convert.ToInt32(false));
doQuery().doInsertQuery("room_items", KeyWithValue);
As you can see; I'm making things neater. So that others can understand and contribute upon it.