Advertisement
Guest User

csgonitro_csgonitro.gz

a guest
Sep 5th, 2015
227
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 40.58 KB | None | 0 0
  1. -- MySQL dump 10.15 Distrib 10.0.21-MariaDB, for Linux (x86_64)
  2. --
  3. -- Host: localhost Database: maorb2_csgonitro
  4. -- ------------------------------------------------------
  5. -- Server version 10.0.21-MariaDB
  6.  
  7. /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  8. /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  9. /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  10. /*!40101 SET NAMES utf8 */;
  11. /*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
  12. /*!40103 SET TIME_ZONE='+00:00' */;
  13. /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  14. /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  15. /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  16. /*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;
  17.  
  18. --
  19. -- Table structure for table `z_new_chat`
  20. --
  21.  
  22. DROP TABLE IF EXISTS `z_new_chat`;
  23. /*!40101 SET @saved_cs_client = @@character_set_client */;
  24. /*!40101 SET character_set_client = utf8 */;
  25. CREATE TABLE `z_new_chat` (
  26. `id` int(11) NOT NULL AUTO_INCREMENT,
  27. `steamID` varchar(256) NOT NULL,
  28. `message` varchar(256) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL,
  29. PRIMARY KEY (`id`)
  30. ) ENGINE=InnoDB AUTO_INCREMENT=30 DEFAULT CHARSET=latin1;
  31. /*!40101 SET character_set_client = @saved_cs_client */;
  32.  
  33. --
  34. -- Dumping data for table `z_new_chat`
  35. --
  36.  
  37. LOCK TABLES `z_new_chat` WRITE;
  38. /*!40000 ALTER TABLE `z_new_chat` DISABLE KEYS */;
  39. INSERT INTO `z_new_chat` VALUES (18,'76561198150446418','test'),(19,'76561198119137364','hey man'),(20,'76561198024392221','Test.'),(21,'76561197964159167','WHo is this?'),(22,'76561198024392221','nigger'),(23,'76561198193130069','is site up?'),(24,'76561198042174832','test'),(25,'76561198121537861','test'),(26,'76561198200052534','kkk'),(27,'76561198200052534','hiiiiiiiiiiiiiiiiiii'),(28,'76561198200052534',':))))))))))))))))))))))))'),(29,'76561198200052534',':)))))))))))))');
  40. /*!40000 ALTER TABLE `z_new_chat` ENABLE KEYS */;
  41. UNLOCK TABLES;
  42.  
  43. --
  44. -- Table structure for table `z_new_games`
  45. --
  46.  
  47. DROP TABLE IF EXISTS `z_new_games`;
  48. /*!40101 SET @saved_cs_client = @@character_set_client */;
  49. /*!40101 SET character_set_client = utf8 */;
  50. CREATE TABLE `z_new_games` (
  51. `id` int(11) NOT NULL AUTO_INCREMENT,
  52. `roundhash` varchar(255) DEFAULT NULL,
  53. `state` tinyint(4) NOT NULL DEFAULT '0' COMMENT 'סטטוס המשחק',
  54. `start_time` datetime DEFAULT NULL,
  55. `sent` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'האם האייטמים נשלחו לזוכה',
  56. `isenter` int(11) NOT NULL COMMENT 'האם נכנס כבר לקובץ שליחה',
  57. `winner_steamID` bigint(20) DEFAULT NULL,
  58. PRIMARY KEY (`id`)
  59. ) ENGINE=InnoDB AUTO_INCREMENT=10 DEFAULT CHARSET=utf8;
  60. /*!40101 SET character_set_client = @saved_cs_client */;
  61.  
  62. --
  63. -- Dumping data for table `z_new_games`
  64. --
  65.  
  66. LOCK TABLES `z_new_games` WRITE;
  67. /*!40000 ALTER TABLE `z_new_games` DISABLE KEYS */;
  68. /*!40000 ALTER TABLE `z_new_games` ENABLE KEYS */;
  69. UNLOCK TABLES;
  70.  
  71. --
  72. -- Table structure for table `z_new_games_items`
  73. --
  74.  
  75. DROP TABLE IF EXISTS `z_new_games_items`;
  76. /*!40101 SET @saved_cs_client = @@character_set_client */;
  77. /*!40101 SET character_set_client = utf8 */;
  78. CREATE TABLE `z_new_games_items` (
  79. `id` int(11) NOT NULL AUTO_INCREMENT,
  80. `gameID` int(11) NOT NULL,
  81. `steamID` bigint(20) NOT NULL COMMENT 'אידי של השחקן שהימר',
  82. `classid` int(11) NOT NULL,
  83. `assetid` bigint(255) NOT NULL,
  84. `weapon_name` varchar(255) NOT NULL,
  85. `price` decimal(10,2) NOT NULL,
  86. `float` varchar(255) DEFAULT NULL,
  87. `add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'מועד ההימור',
  88. `sent` tinyint(1) NOT NULL DEFAULT '0' COMMENT 'האם הפריט נשלח לזוכה?',
  89. PRIMARY KEY (`id`)
  90. ) ENGINE=InnoDB AUTO_INCREMENT=359 DEFAULT CHARSET=utf8;
  91. /*!40101 SET character_set_client = @saved_cs_client */;
  92.  
  93. --
  94. -- Dumping data for table `z_new_games_items`
  95. --
  96.  
  97. LOCK TABLES `z_new_games_items` WRITE;
  98. /*!40000 ALTER TABLE `z_new_games_items` DISABLE KEYS */;
  99. /*!40000 ALTER TABLE `z_new_games_items` ENABLE KEYS */;
  100. UNLOCK TABLES;
  101.  
  102. --
  103. -- Table structure for table `z_new_settings`
  104. --
  105.  
  106. DROP TABLE IF EXISTS `z_new_settings`;
  107. /*!40101 SET @saved_cs_client = @@character_set_client */;
  108. /*!40101 SET character_set_client = utf8 */;
  109. CREATE TABLE `z_new_settings` (
  110. `id` int(11) NOT NULL AUTO_INCREMENT,
  111. `previous` varchar(255) NOT NULL,
  112. PRIMARY KEY (`id`)
  113. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  114. /*!40101 SET character_set_client = @saved_cs_client */;
  115.  
  116. --
  117. -- Dumping data for table `z_new_settings`
  118. --
  119.  
  120. LOCK TABLES `z_new_settings` WRITE;
  121. /*!40000 ALTER TABLE `z_new_settings` DISABLE KEYS */;
  122. /*!40000 ALTER TABLE `z_new_settings` ENABLE KEYS */;
  123. UNLOCK TABLES;
  124.  
  125. --
  126. -- Table structure for table `z_new_users`
  127. --
  128.  
  129. DROP TABLE IF EXISTS `z_new_users`;
  130. /*!40101 SET @saved_cs_client = @@character_set_client */;
  131. /*!40101 SET character_set_client = utf8 */;
  132. CREATE TABLE `z_new_users` (
  133. `id` int(11) NOT NULL AUTO_INCREMENT,
  134. `steamID` bigint(20) NOT NULL,
  135. `username` varchar(255) DEFAULT NULL,
  136. `real_name` varchar(255) DEFAULT NULL,
  137. `trade_link` varchar(255) DEFAULT NULL,
  138. `private_alert` tinyint(1) NOT NULL DEFAULT '0',
  139. `profile_url` varchar(255) DEFAULT NULL,
  140. `visibility_state` tinyint(4) DEFAULT NULL,
  141. `avatar_medium` varchar(255) DEFAULT NULL,
  142. `json_data` text,
  143. `register_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT 'מועד התחברות ראשונה',
  144. PRIMARY KEY (`id`),
  145. UNIQUE KEY `steamID` (`steamID`)
  146. ) ENGINE=InnoDB AUTO_INCREMENT=136 DEFAULT CHARSET=utf8;
  147. /*!40101 SET character_set_client = @saved_cs_client */;
  148.  
  149. --
  150. -- Dumping data for table `z_new_users`
  151. --
  152.  
  153. LOCK TABLES `z_new_users` WRITE;
  154. /*!40000 ALTER TABLE `z_new_users` DISABLE KEYS */;
  155. INSERT INTO `z_new_users` VALUES (65,76561198105494759,'React ツ #Kinguin','Shai','https://steamcommunity.com/tradeoffer/new/?partner=145229031&token=w-YqlZeP',0,'http://steamcommunity.com/id/_ShaiM_/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/79/799204bbea4a6c0ae7bb6308a81c07afec2bfc4b_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198105494759\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"React ツ #Kinguin\",\n \"lastlogoff\": 1439560405,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/_ShaiM_/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/79/799204bbea4a6c0ae7bb6308a81c07afec2bfc4b.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/79/799204bbea4a6c0ae7bb6308a81c07afec2bfc4b_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/79/799204bbea4a6c0ae7bb6308a81c07afec2bfc4b_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Shai\",\n \"primaryclanid\": \"103582791438816262\",\n \"timecreated\": 1378039279,\n \"personastateflags\": 0,\n \"gameserverip\": \"94.142.142.28:27015\",\n \"gameserversteamid\": \"90096788212310016\",\n \"gameextrainfo\": \"Garry\'s Mod\",\n \"gameid\": \"4000\",\n \"loccountrycode\": \"US\",\n \"locstatecode\": \"FL\",\n \"loccityid\": 896\n }\n ]\n \n }\n}','2015-08-14 17:12:47'),(67,76561197997768189,'ASFDAFAFAFAF',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=37502461&token=eMctxBR7',0,'http://steamcommunity.com/id/AndreaJackson/',1,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4f/4fc3c7352bec0f8a27b243738092f31c8248713c_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561197997768189\",\n \"communityvisibilitystate\": 1,\n \"profilestate\": 1,\n \"personaname\": \"ASFDAFAFAFAF\",\n \"lastlogoff\": 1439892847,\n \"commentpermission\": 2,\n \"profileurl\": \"http://steamcommunity.com/id/AndreaJackson/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4f/4fc3c7352bec0f8a27b243738092f31c8248713c.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4f/4fc3c7352bec0f8a27b243738092f31c8248713c_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4f/4fc3c7352bec0f8a27b243738092f31c8248713c_full.jpg\",\n \"personastate\": 0\n }\n ]\n \n }\n}','2015-08-14 17:29:46'),(69,76561198081880746,'✪ WinterHoly -Saiyan','Chen','https://steamcommunity.com/tradeoffer/new/?partner=121615018&token=5dISZlT-',0,'http://steamcommunity.com/id/winterholy/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/09/099074641690591dedb21bc8e6695c0ab3c346e2_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198081880746\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"✪ WinterHoly -Saiyan\",\n \"lastlogoff\": 1440144643,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/winterholy/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/09/099074641690591dedb21bc8e6695c0ab3c346e2.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/09/099074641690591dedb21bc8e6695c0ab3c346e2_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/09/099074641690591dedb21bc8e6695c0ab3c346e2_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Chen\",\n \"primaryclanid\": \"103582791438816262\",\n \"timecreated\": 1358619322,\n \"personastateflags\": 0,\n \"gameextrainfo\": \"Counter-Strike: Global Offensive\",\n \"gameid\": \"730\",\n \"loccountrycode\": \"IL\"\n }\n ]\n \n }\n}','2015-08-15 14:37:37'),(71,76561198119137364,'CSRunBets.com Bot [#1]','csrunbets','https://steamcommunity.com/tradeoffer/new/?partner=158871636&token=VNsTmkKM',0,'http://steamcommunity.com/id/CsRunBets/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/0a/0ad92801f26f85a1a47c0263c07960369595f9ab_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198119137364\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"CSRunBets.com Bot [#1]\",\n \"lastlogoff\": 1440094206,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/CsRunBets/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/0a/0ad92801f26f85a1a47c0263c07960369595f9ab.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/0a/0ad92801f26f85a1a47c0263c07960369595f9ab_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/0a/0ad92801f26f85a1a47c0263c07960369595f9ab_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"csrunbets\",\n \"primaryclanid\": \"103582791436911629\",\n \"timecreated\": 1387725886,\n \"personastateflags\": 0,\n \"loccountrycode\": \"DE\"\n }\n ]\n \n }\n}','2015-08-15 16:34:41'),(72,76561198201361262,'EreLos','Erel','https://steamcommunity.com/tradeoffer/new/?partner=241095534&token=HFTOw7uQ',0,'http://steamcommunity.com/id/erelos/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/68/68fa2df03b6cc6576753ca0e9488b24bdc27f27b_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198201361262\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"EreLos\",\n \"lastlogoff\": 1439650510,\n \"profileurl\": \"http://steamcommunity.com/id/erelos/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/68/68fa2df03b6cc6576753ca0e9488b24bdc27f27b.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/68/68fa2df03b6cc6576753ca0e9488b24bdc27f27b_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/68/68fa2df03b6cc6576753ca0e9488b24bdc27f27b_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Erel\",\n \"primaryclanid\": \"103582791438928529\",\n \"timecreated\": 1434193753,\n \"personastateflags\": 0,\n \"gameextrainfo\": \"Counter-Strike: Global Offensive\",\n \"gameid\": \"730\",\n \"loccountrycode\": \"IL\",\n \"locstatecode\": \"01\"\n }\n ]\n \n }\n}','2015-08-15 16:34:55'),(76,76561198206291560,'Acc3pt','Golan','https://steamcommunity.com/tradeoffer/new/?partner=246025832&token=rDJY-L2h',0,'http://steamcommunity.com/id/Acc3ept/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/02/02a59ba2d3f16d225a49a6638815dea8f4ca2890_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198206291560\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Acc3pt\",\n \"lastlogoff\": 1439650067,\n \"profileurl\": \"http://steamcommunity.com/id/Acc3ept/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/02/02a59ba2d3f16d225a49a6638815dea8f4ca2890.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/02/02a59ba2d3f16d225a49a6638815dea8f4ca2890_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/02/02a59ba2d3f16d225a49a6638815dea8f4ca2890_full.jpg\",\n \"personastate\": 0,\n \"realname\": \"Golan\",\n \"primaryclanid\": \"103582791439301782\",\n \"timecreated\": 1421443961,\n \"personastateflags\": 0,\n \"loccountrycode\": \"IL\",\n \"locstatecode\": \"01\"\n }\n ]\n \n }\n}','2015-08-15 20:39:39'),(79,76561198150446418,'Dale','Ran','https://steamcommunity.com/tradeoffer/new/?partner=190180690&token=x-n80T4I',0,'http://steamcommunity.com/id/Windwaving/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/32/3297aa520526f5d0308be8e831b893cd681843bf_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198150446418\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Dale\",\n \"lastlogoff\": 1439696973,\n \"profileurl\": \"http://steamcommunity.com/id/Windwaving/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/32/3297aa520526f5d0308be8e831b893cd681843bf.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/32/3297aa520526f5d0308be8e831b893cd681843bf_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/32/3297aa520526f5d0308be8e831b893cd681843bf_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Ran\",\n \"primaryclanid\": \"103582791436939422\",\n \"timecreated\": 1408352298,\n \"personastateflags\": 0,\n \"loccountrycode\": \"SE\"\n }\n ]\n \n }\n}','2015-08-16 13:35:12'),(81,76561198109300995,'imJKL CSRunBets','imNOTjkl',NULL,0,'http://steamcommunity.com/id/imJKL/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/42/42f2e2f99ea5895e1c8f5dbf41fe34a46fe460a4_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198109300995\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"imJKL CSRunBets\",\n \"lastlogoff\": 1439693547,\n \"profileurl\": \"http://steamcommunity.com/id/imJKL/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/42/42f2e2f99ea5895e1c8f5dbf41fe34a46fe460a4.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/42/42f2e2f99ea5895e1c8f5dbf41fe34a46fe460a4_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/42/42f2e2f99ea5895e1c8f5dbf41fe34a46fe460a4_full.jpg\",\n \"personastate\": 0,\n \"realname\": \"imNOTjkl\",\n \"primaryclanid\": \"103582791436923730\",\n \"timecreated\": 1380646141,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-16 13:47:05'),(85,76561198143300446,'Shade F%^ck russians','Ran',NULL,0,'http://steamcommunity.com/id/Ran_Cohen69/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ad/ad3b9e0bfdbca7a66497bfaad8a206356d477771_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198143300446\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Shade F%^ck russians\",\n \"lastlogoff\": 1439794188,\n \"profileurl\": \"http://steamcommunity.com/id/Ran_Cohen69/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ad/ad3b9e0bfdbca7a66497bfaad8a206356d477771.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ad/ad3b9e0bfdbca7a66497bfaad8a206356d477771_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ad/ad3b9e0bfdbca7a66497bfaad8a206356d477771_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Ran\",\n \"primaryclanid\": \"103582791438816257\",\n \"timecreated\": 1404413491,\n \"personastateflags\": 0,\n \"loccountrycode\": \"UM\"\n }\n ]\n \n }\n}','2015-08-17 15:50:19'),(86,76561198091109288,'Kuramshin','40',NULL,0,'http://steamcommunity.com/id/Kuramshin/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/85/855da8c6d02b97231692145c0b4dd80cdac1140c_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198091109288\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Kuramshin\",\n \"lastlogoff\": 1439756441,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/Kuramshin/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/85/855da8c6d02b97231692145c0b4dd80cdac1140c.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/85/855da8c6d02b97231692145c0b4dd80cdac1140c_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/85/855da8c6d02b97231692145c0b4dd80cdac1140c_full.jpg\",\n \"personastate\": 2,\n \"realname\": \"40\",\n \"primaryclanid\": \"103582791429521592\",\n \"timecreated\": 1368179967,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-17 17:03:27'),(87,76561198083912485,'l0bster | CSGO1.COM','Cray Cray Bets Owner','https://steamcommunity.com/tradeoffer/new/?partner=123646757&token=w3FIYg38',0,'http://steamcommunity.com/id/xplatapussyx/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bdb5105f364036253dda7ad0f6ebb45bd59aabb5_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198083912485\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"l0bster | CSGO1.COM\",\n \"lastlogoff\": 1439851868,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/xplatapussyx/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bdb5105f364036253dda7ad0f6ebb45bd59aabb5.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bdb5105f364036253dda7ad0f6ebb45bd59aabb5_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bdb5105f364036253dda7ad0f6ebb45bd59aabb5_full.jpg\",\n \"personastate\": 0,\n \"realname\": \"Cray Cray Bets Owner\",\n \"primaryclanid\": \"103582791438918478\",\n \"timecreated\": 1360922161,\n \"personastateflags\": 0,\n \"loccountrycode\": \"AU\"\n }\n ]\n \n }\n}','2015-08-18 02:29:07'),(90,76561198063913412,'Deduction','Asif','https://steamcommunity.com/tradeoffer/new/?partner=103647684&token=g9f7nRXa',0,'http://steamcommunity.com/id/DeductionPowerFul69/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/21/2162cca360668ac844cc1d82b175b301397c4b4c_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198063913412\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Deduction\",\n \"lastlogoff\": 1439794070,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/DeductionPowerFul69/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/21/2162cca360668ac844cc1d82b175b301397c4b4c.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/21/2162cca360668ac844cc1d82b175b301397c4b4c_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/21/2162cca360668ac844cc1d82b175b301397c4b4c_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Asif\",\n \"primaryclanid\": \"103582791437910247\",\n \"timecreated\": 1337426284,\n \"personastateflags\": 0,\n \"loccountrycode\": \"IL\"\n }\n ]\n \n }\n}','2015-08-18 16:30:02'),(92,76561198057018767,'+XplAiN',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=96753039&token=ijwu-Qd4',0,'http://steamcommunity.com/profiles/76561198057018767/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198057018767\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"+XplAiN\",\n \"lastlogoff\": 1439864777,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/profiles/76561198057018767/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_full.jpg\",\n \"personastate\": 0,\n \"primaryclanid\": \"103582791434672401\",\n \"timecreated\": 1326489597,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-19 00:00:38'),(94,76561198141129015,'Invisibility','Noam','https://steamcommunity.com/tradeoffer/new/?partner=180863287&token=6ZaAriD3',0,'http://steamcommunity.com/id/InvCSGO/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/77c799991e6c390a7c30c36d65081b9ede41f8c7_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198141129015\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Invisibility\",\n \"lastlogoff\": 1439997859,\n \"profileurl\": \"http://steamcommunity.com/id/InvCSGO/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/77c799991e6c390a7c30c36d65081b9ede41f8c7.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/77c799991e6c390a7c30c36d65081b9ede41f8c7_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/77c799991e6c390a7c30c36d65081b9ede41f8c7_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Noam\",\n \"primaryclanid\": \"103582791431103657\",\n \"timecreated\": 1403189623,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-19 20:29:54'),(96,76561197964159167,'CrimsoN_nl','Maikel','https://steamcommunity.com/tradeoffer/new/?partner=3893439&token=opp-kE4Y',0,'http://steamcommunity.com/id/OfficialCrimsoN/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e9/e93e0e47108a356d8e6b341dbc900931214e45b7_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561197964159167\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"CrimsoN_nl\",\n \"lastlogoff\": 1440894268,\n \"profileurl\": \"http://steamcommunity.com/id/OfficialCrimsoN/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e9/e93e0e47108a356d8e6b341dbc900931214e45b7.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e9/e93e0e47108a356d8e6b341dbc900931214e45b7_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e9/e93e0e47108a356d8e6b341dbc900931214e45b7_full.jpg\",\n \"personastate\": 0,\n \"realname\": \"Maikel\",\n \"primaryclanid\": \"103582791430583845\",\n \"timecreated\": 1075305749,\n \"personastateflags\": 0,\n \"loccountrycode\": \"NL\"\n }\n ]\n \n }\n}','2015-08-20 05:02:18'),(97,76561198003235287,'Rotimas * CSGO-Jackpot.eu','Jakub','https://steamcommunity.com/tradeoffer/new/?partner=215700211&token=zgpvSUe_',0,'http://steamcommunity.com/id/Rotimas/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/34/3498e6421126729d5d159f079e6b1889942027e7_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198003235287\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Rotimas * CSGO-Jackpot.eu\",\n \"lastlogoff\": 1440060153,\n \"profileurl\": \"http://steamcommunity.com/id/Rotimas/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/34/3498e6421126729d5d159f079e6b1889942027e7.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/34/3498e6421126729d5d159f079e6b1889942027e7_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/34/3498e6421126729d5d159f079e6b1889942027e7_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Jakub\",\n \"primaryclanid\": \"103582791439261762\",\n \"timecreated\": 1227614864,\n \"personastateflags\": 0,\n \"loccountrycode\": \"PL\"\n }\n ]\n \n }\n}','2015-08-20 14:53:36'),(100,76561198001179557,'Infinity','Raso','https://steamcommunity.com/tradeoffer/new/?partner=40913829&token=e4MIQscY',0,'http://steamcommunity.com/id/raso989/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/dc/dcfb152f7a834c8cabb3a4d28a1663d883429a1e_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198001179557\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Infinity\",\n \"lastlogoff\": 1440026676,\n \"profileurl\": \"http://steamcommunity.com/id/raso989/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/dc/dcfb152f7a834c8cabb3a4d28a1663d883429a1e.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/dc/dcfb152f7a834c8cabb3a4d28a1663d883429a1e_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/dc/dcfb152f7a834c8cabb3a4d28a1663d883429a1e_full.jpg\",\n \"personastate\": 1,\n \"realname\": \"Raso\",\n \"primaryclanid\": \"103582791435738687\",\n \"timecreated\": 1221360769,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-20 15:07:23'),(107,76561198024392221,'HYproXa',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=64126493&token=GimQL7-p',0,'http://steamcommunity.com/id/hyproxa/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ab/aba8eb50962e006d5c205eab813d0427db7fbec7_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198024392221\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"HYproXa\",\n \"lastlogoff\": 1440080324,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/hyproxa/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ab/aba8eb50962e006d5c205eab813d0427db7fbec7.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ab/aba8eb50962e006d5c205eab813d0427db7fbec7_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/ab/aba8eb50962e006d5c205eab813d0427db7fbec7_full.jpg\",\n \"personastate\": 2,\n \"primaryclanid\": \"103582791433230303\",\n \"timecreated\": 1272462516,\n \"personastateflags\": 0,\n \"loccountrycode\": \"US\"\n }\n ]\n \n }\n}','2015-08-20 15:36:18'),(111,76561198193130069,'Rexo TOXICJACKPOT.COM',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=232864341&token=Zy9ANTwT',0,'http://steamcommunity.com/id/OGRexo/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bd9d98d5c11c681c206ab951045510e4c91d16dd_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198193130069\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Rexo TOXICJACKPOT.COM\",\n \"lastlogoff\": 1440091572,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/OGRexo/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bd9d98d5c11c681c206ab951045510e4c91d16dd.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bd9d98d5c11c681c206ab951045510e4c91d16dd_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/bd/bd9d98d5c11c681c206ab951045510e4c91d16dd_full.jpg\",\n \"personastate\": 2,\n \"primaryclanid\": \"103582791438305607\",\n \"timecreated\": 1429733049,\n \"personastateflags\": 0,\n \"loccountrycode\": \"SE\"\n }\n ]\n \n }\n}','2015-08-20 21:02:41'),(114,76561198168780508,'fietseN',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=208514780&token=P2Zg6Bp6',0,'http://steamcommunity.com/id/w0wflat/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/98/982ecd7678b6f10f57a91d105d868ae73c350d6f_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198168780508\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"fietseN\",\n \"lastlogoff\": 1440133958,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/w0wflat/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/98/982ecd7678b6f10f57a91d105d868ae73c350d6f.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/98/982ecd7678b6f10f57a91d105d868ae73c350d6f_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/98/982ecd7678b6f10f57a91d105d868ae73c350d6f_full.jpg\",\n \"personastate\": 1,\n \"primaryclanid\": \"103582791429705688\",\n \"timecreated\": 1419033281,\n \"personastateflags\": 0,\n \"gameextrainfo\": \"Counter-Strike: Global Offensive\",\n \"gameid\": \"730\",\n \"loccountrycode\": \"IL\",\n \"locstatecode\": \"04\",\n \"loccityid\": 21071\n }\n ]\n \n }\n}','2015-08-21 11:23:42'),(118,76561198091894298,'Jered_ | CSGOShuffle.com',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=131628570&token=E5rKF9ki',0,'http://steamcommunity.com/id/AdminID3585992/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4b/4bbd38f0af454be33ba4b5e233a15cbfd4a43531_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198091894298\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Jered_ | CSGOShuffle.com\",\n \"lastlogoff\": 1440369883,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/AdminID3585992/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4b/4bbd38f0af454be33ba4b5e233a15cbfd4a43531.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4b/4bbd38f0af454be33ba4b5e233a15cbfd4a43531_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/4b/4bbd38f0af454be33ba4b5e233a15cbfd4a43531_full.jpg\",\n \"personastate\": 1,\n \"primaryclanid\": \"103582791438142852\",\n \"timecreated\": 1368961090,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-24 04:40:32'),(122,76561198213873447,'pzaze500',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=253607719&token=sATSjvsC',0,'http://steamcommunity.com/profiles/76561198213873447/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198213873447\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"pzaze500\",\n \"lastlogoff\": 1440381741,\n \"profileurl\": \"http://steamcommunity.com/profiles/76561198213873447/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/fe/fef49e7fa7e1997310d705b2a6158ff8dc1cdfeb_full.jpg\",\n \"personastate\": 0,\n \"primaryclanid\": \"103582791429521408\",\n \"timecreated\": 1440211281,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-27 18:35:39'),(124,76561198218001928,'CSGOSICK.COM @ BOT #1',NULL,NULL,0,'http://steamcommunity.com/id/WHOOPS1E/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/a3/a32c5b156627e61831cabee03bf27f5b8adc2677_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198218001928\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"CSGOSICK.COM @ BOT #1\",\n \"lastlogoff\": 1440760358,\n \"profileurl\": \"http://steamcommunity.com/id/WHOOPS1E/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/a3/a32c5b156627e61831cabee03bf27f5b8adc2677.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/a3/a32c5b156627e61831cabee03bf27f5b8adc2677_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/a3/a32c5b156627e61831cabee03bf27f5b8adc2677_full.jpg\",\n \"personastate\": 1,\n \"primaryclanid\": \"103582791439411648\",\n \"timecreated\": 1426611808,\n \"personastateflags\": 0,\n \"loccountrycode\": \"LT\"\n }\n ]\n \n }\n}','2015-08-28 18:29:47'),(125,76561198020151999,'Jon - CSGO-Stake.com','Jon','https://steamcommunity.com/tradeoffer/new/?partner=59886271&token=KfIM-ABX',0,'http://steamcommunity.com/id/focalpointservers/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/8d/8d504875e0ad55d6cfbbfe31a445bd440df9a70e_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198020151999\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Jon - CSGO-Stake.com\",\n \"lastlogoff\": 1440847723,\n \"profileurl\": \"http://steamcommunity.com/id/focalpointservers/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/8d/8d504875e0ad55d6cfbbfe31a445bd440df9a70e.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/8d/8d504875e0ad55d6cfbbfe31a445bd440df9a70e_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/8d/8d504875e0ad55d6cfbbfe31a445bd440df9a70e_full.jpg\",\n \"personastate\": 3,\n \"realname\": \"Jon\",\n \"primaryclanid\": \"103582791431220691\",\n \"timecreated\": 1264173921,\n \"personastateflags\": 0,\n \"loccountrycode\": \"US\"\n }\n ]\n \n }\n}','2015-08-29 01:16:24'),(127,76561198042174832,'',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=242517937&token=GlEtg1OB',0,NULL,0,NULL,'','2015-08-29 04:44:07'),(129,76561198121537861,'Andy! GOO CSGODARK.COM !!',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=161272133&token=d98des01',0,'http://steamcommunity.com/id/Andy1G/',3,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/7744ea3f066ee89f4029f4430625e7705ff9d029_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198121537861\",\n \"communityvisibilitystate\": 3,\n \"profilestate\": 1,\n \"personaname\": \"Andy! GOO CSGODARK.COM !!\",\n \"lastlogoff\": 1440812749,\n \"commentpermission\": 1,\n \"profileurl\": \"http://steamcommunity.com/id/Andy1G/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/7744ea3f066ee89f4029f4430625e7705ff9d029.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/7744ea3f066ee89f4029f4430625e7705ff9d029_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/77/7744ea3f066ee89f4029f4430625e7705ff9d029_full.jpg\",\n \"personastate\": 1,\n \"primaryclanid\": \"103582791435138820\",\n \"timecreated\": 1388745372,\n \"personastateflags\": 0\n }\n ]\n \n }\n}','2015-08-29 16:03:22'),(131,76561198200052534,'NeoN | CSGODARK.COM | Owner',NULL,'https://steamcommunity.com/tradeoffer/new/?partner=239786806&token=n0svDSl0',0,'http://steamcommunity.com/id/NeoNM9/',1,'https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e7/e798f8ff7faee2d99352d7474484bc5c2417f98d_medium.jpg','{\n \"response\": {\n \"players\": [\n {\n \"steamid\": \"76561198200052534\",\n \"communityvisibilitystate\": 1,\n \"profilestate\": 1,\n \"personaname\": \"NeoN | CSGODARK.COM | Owner\",\n \"lastlogoff\": 1440820825,\n \"commentpermission\": 2,\n \"profileurl\": \"http://steamcommunity.com/id/NeoNM9/\",\n \"avatar\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e7/e798f8ff7faee2d99352d7474484bc5c2417f98d.jpg\",\n \"avatarmedium\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e7/e798f8ff7faee2d99352d7474484bc5c2417f98d_medium.jpg\",\n \"avatarfull\": \"https://steamcdn-a.akamaihd.net/steamcommunity/public/images/avatars/e7/e798f8ff7faee2d99352d7474484bc5c2417f98d_full.jpg\",\n \"personastate\": 0\n }\n ]\n \n }\n}','2015-08-29 16:06:28');
  156. /*!40000 ALTER TABLE `z_new_users` ENABLE KEYS */;
  157. UNLOCK TABLES;
  158.  
  159. --
  160. -- Table structure for table `z_new_users_items`
  161. --
  162.  
  163. DROP TABLE IF EXISTS `z_new_users_items`;
  164. /*!40101 SET @saved_cs_client = @@character_set_client */;
  165. /*!40101 SET character_set_client = utf8 */;
  166. CREATE TABLE `z_new_users_items` (
  167. `id` int(11) NOT NULL AUTO_INCREMENT,
  168. `steamID` bigint(20) NOT NULL,
  169. `classid` int(11) NOT NULL,
  170. `assetid` bigint(255) NOT NULL,
  171. `weapon_name` varchar(255) NOT NULL,
  172. `price` float NOT NULL,
  173. `float` varchar(255) DEFAULT NULL,
  174. `add_time` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP,
  175. PRIMARY KEY (`id`)
  176. ) ENGINE=InnoDB AUTO_INCREMENT=129 DEFAULT CHARSET=utf8 COMMENT='רשימת הפריטים שיש לכל משתמש במלאי';
  177. /*!40101 SET character_set_client = @saved_cs_client */;
  178.  
  179. --
  180. -- Dumping data for table `z_new_users_items`
  181. --
  182.  
  183. LOCK TABLES `z_new_users_items` WRITE;
  184. /*!40000 ALTER TABLE `z_new_users_items` DISABLE KEYS */;
  185. /*!40000 ALTER TABLE `z_new_users_items` ENABLE KEYS */;
  186. UNLOCK TABLES;
  187.  
  188. --
  189. -- Table structure for table `z_new_withdraw_items`
  190. --
  191.  
  192. DROP TABLE IF EXISTS `z_new_withdraw_items`;
  193. /*!40101 SET @saved_cs_client = @@character_set_client */;
  194. /*!40101 SET character_set_client = utf8 */;
  195. CREATE TABLE `z_new_withdraw_items` (
  196. `id` int(11) NOT NULL AUTO_INCREMENT,
  197. `steamID` bigint(20) NOT NULL,
  198. `assetid` bigint(255) NOT NULL,
  199. `secret` varchar(255) NOT NULL,
  200. `weapon_name` varchar(255) NOT NULL,
  201. PRIMARY KEY (`id`)
  202. ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
  203. /*!40101 SET character_set_client = @saved_cs_client */;
  204.  
  205. --
  206. -- Dumping data for table `z_new_withdraw_items`
  207. --
  208.  
  209. LOCK TABLES `z_new_withdraw_items` WRITE;
  210. /*!40000 ALTER TABLE `z_new_withdraw_items` DISABLE KEYS */;
  211. /*!40000 ALTER TABLE `z_new_withdraw_items` ENABLE KEYS */;
  212. UNLOCK TABLES;
  213. /*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;
  214.  
  215. /*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
  216. /*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
  217. /*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
  218. /*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
  219. /*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
  220. /*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
  221. /*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;
  222.  
  223. -- Dump completed on 2015-08-30 23:13:46
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement