Advertisement
Guest User

Untitled

a guest
Aug 19th, 2016
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.53 KB | None | 0 0
  1. // TODO: Start loading pkmn party from db
  2. var mysql = require("mysql");
  3.  
  4. var connection = mysql.createConnection({
  5. host: "127.0.0.1",
  6. user: "root",
  7. password: "",
  8. database: "pogosql"
  9. });
  10. let level = "";
  11. connection.connect();
  12. connection.query('SELECT * from users', function(err, rows, fields) {
  13. if(err) throw err;
  14. console.log(rows);
  15. for (var i = 0; i < rows.length; i++) {
  16. let level = rows[i].level; //parse level from rows
  17. console.log("level: " + level);
  18. };
  19. });
  20. connection.end();
  21.  
  22. return (
  23. new proto.Networking.Responses.GetInventoryResponse({
  24. success: true,
  25. inventory_delta: new proto.Inventory.InventoryDelta({
  26. inventory_items: [
  27. new proto.Inventory.InventoryItem({
  28. "modified_timestamp_ms": new Date().getTime() * 1e3,
  29. "inventory_item_data": new proto.Inventory.InventoryItemData({
  30. "candy": new proto.Inventory.Candy({
  31. "family_id": 48,
  32. "candy": 3
  33. })
  34. })
  35. }),
  36. new proto.Inventory.InventoryItem({
  37. "modified_timestamp_ms": new Date().getTime() * 1e3,
  38. "inventory_item_data": new proto.Inventory.InventoryItemData({
  39. "candy": new proto.Inventory.Candy({
  40. "family_id": 16,
  41. "candy": 3
  42. })
  43. })
  44. }),
  45. new proto.Inventory.InventoryItem({
  46. "modified_timestamp_ms": new Date().getTime() * 1e3,
  47. "inventory_item_data": new proto.Inventory.InventoryItemData({
  48. "player_stats": new proto.Data.Player.PlayerStats({
  49. level: level, //trying to set level here
  50. experience: 4870,
  51. prev_level_xp: 1000,
  52. next_level_xp: 6000,
  53. km_walked: 1.0598372220993042,
  54. pokemons_encountered: 11,
  55. unique_pokedex_entries: 5,
  56. pokemons_captured: 5,
  57. evolutions: 0,
  58. poke_stop_visits: 37,
  59. pokeballs_thrown: 22,
  60. eggs_hatched: 0,
  61. big_magikarp_caught: 0,
  62. battle_attack_won: 0,
  63. battle_attack_total: 0,
  64. battle_defended_won: 0,
  65. battle_training_won: 0,
  66. battle_training_total: 0,
  67. prestige_raised_total: 0,
  68. prestige_dropped_total: 0,
  69. pokemon_deployed: 0
  70. })
  71. })
  72. }),
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement