columbo bonetechnologies
bonetechnologies
/ gist:31ab592ed08096043b93ca358bafeb4d
Created
June 22, 2016 20:18
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| CREATE TABLE user_properties( | |
| id BIGINT NOT NULL AUTO_INCREMENT, | |
| legacy_user_id BIGINT NOT NULL, | |
| vevo_user_id VARCHAR(22) CHARACTER SET latin1 COLLATE latin1_bin NOT NULL, | |
| property_type VARCHAR(255) NOT NULL, | |
| created DATETIME DEFAULT CURRENT_TIMESTAMP, | |
| modified DATETIME DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP, | |
| UNIQUE KEY property_type_unique (vevo_user_id, property_type), | |
| PRIMARY KEY(id), | |
| FOREIGN KEY(vevo_user_id) REFERENCES id_generation(vevo_user_id), |
bonetechnologies
/ gist:7e17716df2ab2cea06163f467d0ed9ae
Created
June 22, 2016 20:13
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ------------------------ | |
| LATEST DETECTED DEADLOCK | |
| ------------------------ | |
| 2016-06-22 19:26:01 2af7ba087700 | |
| *** (1) TRANSACTION: | |
| TRANSACTION 264153653, ACTIVE 0 sec inserting | |
| mysql tables in use 1, locked 1 | |
| LOCK WAIT 12 lock struct(s), heap size 376, 13 row lock(s), undo log entries 3 | |
| MySQL thread id 1697, OS thread handle 0x2af7a5706700, query id 988361715 10.11.55.253 ripple update | |
| INSERT INTO user_properties (id, legacy_user_id, vevo_user_id, property_type) VALUES (NULL, 26713336, 'yv5yaEZL31q2TtGqa05XSg', 'BIRTHDAY') |
bonetechnologies
/ gist:07ae461998565a13bdf8dde62af05985
Created
June 22, 2016 19:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| ### Error updating database. Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction | |
| ### The error may involve com.vevo.ripple.storage.mapper.UserPropertyMapper.createPropertyKey-Inline | |
| ### The error occurred while setting parameters | |
| ### SQL: INSERT INTO user_properties (id, legacy_user_id, vevo_user_id, property_type) VALUES (NULL, ?, ?, ?) | |
| ### Cause: com.mysql.jdbc.exceptions.jdbc4.MySQLTransactionRollbackException: Deadlock found when trying to get lock; try restarting transaction | |
| at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:30) ~[ripple-1.0-SNAPSHOT-all.jar:na] | |
| at org.apache.ibatis.session.defaults.DefaultSqlSession.update(DefaultSqlSession.java:172) ~[ripple-1.0-SNAPSHOT-all.jar:na] | |
| at org.apache.ibatis.session.defaults.DefaultSqlSession.insert(DefaultSqlSession.java:157) ~[ripple-1.0-SNAPSHOT-all.jar:na] | |
| at org.apache.ibatis.binding.MapperMethod.execute(MapperMethod.java:52) |
bonetechnologies
/ gist:1dc60804fa5a7ecc470aec823e32ed5b
Created
May 13, 2016 16:17
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| String[] dateOfBirthList = dateOfBirth.split("T00:00:00Z"); | |
| dateOfBirth = dateOfBirthList[0]; | |
| if (dateOfBirth.length() == 10) { | |
| dateOfBirthList = dateOfBirth.split("-"); | |
| String year = dateOfBirthList[0]; | |
| String month = dateOfBirthList[1]; | |
| String day = dateOfBirthList[2]; |
bonetechnologies
/ gist:eb3d16dfc8472c9560a7
Created
May 19, 2015 02:04
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public void getForageForRoom(Room room, Player player) { | |
| int countOfForagesFound = 0; | |
| int totalForageXp = 0; | |
| try { | |
| for (Forage forage : room.getForages().values()) { | |
| int foragingLevel = getLevel(gameManager.getPlayerManager().getPlayerMetadata(player.getPlayerId()).getStats().getForaging()); | |
| if (forage.getMinLevel() > foragingLevel) { | |
| // System.out.println("Foraging level not high enough."); | |
| return; |
bonetechnologies
/ gist:9954ad8a158b225fffcf
Created
May 14, 2015 21:06
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "name": "street hustler", | |
| "colorName": "street hustler", | |
| "dieMessage": "street hustler dies in a pool of blood", | |
| "loot": { | |
| "lootGoldMin": 34, | |
| "lootGoldMax": 55, | |
| "lootItems": [ | |
| 2 | |
| ] |
bonetechnologies
/ gist:8f2c84441d4b0de60212
Created
May 14, 2015 18:16
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| { | |
| "colorName": "COLORNAME", | |
| "dieMessage": "DIEMESSAGE", | |
| "name": "NAME", | |
| "loot": { | |
| "lootGoldMin": 5, | |
| "lootGoldMax": 10, | |
| "lootItems": [] | |
| }, | |
| "roamAreas": [ |
bonetechnologies
/ gist:07dd307d88b93feb413a
Created
May 9, 2015 18:54
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| level: 1 is 40000exp. | |
| level: 2 is 160000exp. | |
| level: 3 is 360000exp. | |
| level: 4 is 640000exp. | |
| level: 5 is 1000000exp. | |
| level: 6 is 1440000exp. | |
| level: 7 is 1960000exp. | |
| level: 8 is 2560000exp. | |
| level: 9 is 3240000exp. | |
| level: 10 is 4000000exp. |
bonetechnologies
/ gist:4b767b81b25640ab10bf
Created
May 9, 2015 16:26
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| public static int getLevel(int experience) { | |
| double constant = 0.032; | |
| double v = constant * sqrt(experience); | |
| return (int) Math.floor(v); | |
| } |
bonetechnologies
/ gist:c55393e55b4a1f8afa32
Created
April 28, 2015 02:05
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| startUpMessage("Adding Phantom Knights"); | |
| PhantomKnight phantomKnight = new PhantomKnight(gameManager, new Loot(18, 26, Sets.<Item>newHashSet())); | |
| entityManager.addEntity(new NpcSpawner(phantomKnight, Sets.newHashSet(Area.BLOODRIDGE5_ZONE), gameManager, new SpawnRule(10, 6, 2, 100))); | |
| entityManager.addEntity(new NpcSpawner(phantomKnight, Sets.newHashSet(Area.BLOODRIDGE6_ZONE), gameManager, new SpawnRule(10, 14, 2, 100))); | |
| entityManager.addEntity(new NpcSpawner(phantomKnight, Sets.newHashSet(Area.BLOODRIDGE7_ZONE), gameManager, new SpawnRule(10, 14, 2, 100))); | |
| PhantomOrc phantomOrc = new PhantomOrc(gameManager, new Loot(16, 24, Sets.<Item>newHashSet())); | |
| startUpMessage("Adding Phantom Orcs"); |