API tools faq
paste
Advertisement
Sky_Black

Connectionsmag.co.il - By Sky_BlaCk

Sky_Black
Jan 31st, 2013
221
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 18.50 KB | None | 0 0
raw download clone embed print report
  1. _ _ _________ __
  2. __| || |__\_ ____ \__________ _____| |__
  3. \ __ // \ \/_ __ \__ \/ ___/ | \
  4. | || | | \__| | \/ __ \__ \| Y \
  5. /_ ~~ _\\_____ /|__| (____ /___ >___| /
  6. |_||_| \/ \/ \/ \/
  7. ##############################################
  8. XXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXXX
  9.  
  10. Target : http://www.connectionsmag.co.il/
  11. IP : 72.249.89.201
  12. Web Server : Apache
  13. DB : MySQL
  14.  
  15. Databases :
  16.  
  17. [*] connectionsmag_co_il_-_data
  18. [*] information_schema
  19.  
  20.  
  21.  
  22.  
  23. Database: `connectionsmag_co_il_-_data`
  24.  
  25. +--------------------+
  26. | articles |
  27. | master |
  28. | passwords |
  29. | permad |
  30. | phpads_acls |
  31. | phpads_adclicks |
  32. | phpads_adstats |
  33. | phpads_adviews |
  34. | phpads_affiliates |
  35. | phpads_banners |
  36. | phpads_cache |
  37. | phpads_clients |
  38. | phpads_config |
  39. | phpads_images |
  40. | phpads_session |
  41. | phpads_targetstats |
  42. | phpads_userlog |
  43. | phpads_zones |
  44. +--------------------+
  45.  
  46.  
  47. Table: master
  48.  
  49. +----------+-------------+
  50. | Column | Type |
  51. +----------+-------------+
  52. | override | varchar(16) |
  53. +----------+-------------+
  54.  
  55.  
  56. Table: master
  57.  
  58. +------------------+
  59. | override |
  60. +------------------+
  61. | 47515c5d5503beb2 |
  62. +------------------+
  63.  
  64.  
  65.  
  66. Table: passwords
  67.  
  68. +---------------+-------------------+
  69. | Column | Type |
  70. +---------------+-------------------+
  71. | emailaddress | varchar(60) |
  72. | firstname | varchar(30) |
  73. | lastname | varchar(40) |
  74. | securitylevel | enum('1','2','3') |
  75. | upassword | varchar(16) |
  76. | username | varchar(10) |
  77. +---------------+-------------------+
  78.  
  79.  
  80.  
  81. Table: passwords
  82.  
  83. +----------+----------+-----------+------------------+--------------------+---------------+
  84. | username | lastname | firstname | upassword | emailaddress | securitylevel |
  85. +----------+----------+-----------+------------------+--------------------+---------------+
  86. | dstern | Stern | David | 215473c75f51967a | <blank> | 1 |
  87. | Rebecca | Stern | Rebecca | 3226c364425580e1 | drstern@013.net.il | 1 |
  88. | yclark | Clark | Yitzhak | 5668a61a05d9c04b | yitz13@gmail.com | 2 |
  89. | alevitas | Levitas | Ari | 221f244861e476d0 | <blank> | 1 |
  90. +----------+----------+-----------+------------------+--------------------+---------------+
  91.  
  92.  
  93.  
  94. Table: permad
  95.  
  96. +----------+--------------+
  97. | Column | Type |
  98. +----------+--------------+
  99. | id | int(11) |
  100. | link | varchar(120) |
  101. | ordernum | int(2) |
  102. | picfile | varchar(60) |
  103. +----------+--------------+
  104.  
  105.  
  106.  
  107. Table: permad
  108.  
  109. +----+-----------------------------------------------------+------------------------------+----------+
  110. | id | link | picfile | ordernum |
  111. +----+-----------------------------------------------------+------------------------------+----------+
  112. | 3 | http://www.connectionsmag.co.il/article.php?id=1016 | city-tarbut(1).jpg | 1 |
  113. | 4 | http://www.connectionsmag.co.il/article.php?id=1107 | p2k-chidon tanach banner.jpg | 2 |
  114. +----+-----------------------------------------------------+------------------------------+----------+
  115.  
  116.  
  117.  
  118. Table: phpads_session
  119.  
  120. +-------------+-------------+
  121. | Column | Type |
  122. +-------------+-------------+
  123. | lastused | timestamp |
  124. | sessiondata | blob |
  125. | sessionid | varchar(32) |
  126. +-------------+-------------+
  127.  
  128.  
  129.  
  130. Table: phpads_session
  131. [
  132. +-------------------------------+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  133. | sessionid | lastused | sessiondata |
  134. +-------------------------------+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  135. | phpads50aa557e2e8e46.65229985 | 2012-11-19 10:39:07 | a:4:{s:8:"usertype";i:1;s:8:"loggedin";s:1:"t";s:8:"username";s:4:"blid";s:5:"prefs";a:5:{s:16:"client-index.php";a:4:{s:12:"hideinactive";s:1:"0";s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}s:19:"affiliate-index.php";a:3:{s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}s:20:"client-campaigns.php";a:1:{i:115;a:4:{s:12:"hideinactive";b:1;s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}}s:23:"stats-global-client.php";a:6:{s:12:"hideinactive";s:1:"0";s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";s:6:"period";s:1:"r";s:12:"period_range";a:6:{s:9:"start_day";i:0;s:11:"start_month";i:0;s:10:"start_year";i:0;s:7:"end_day";i:0;s:9:"end_month";i:0;s:8:"end_year";i:0;}}s:27:"stats-global-affiliates.php";a:5:{s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";s:6:"period";s:1:"w";s:12:"period_range";a:6:{s:9:"start_day";i:0;s:11:"start_month";i:0;s:10:"start_year";i:0;s:7:"end_day";i:0;s:9:"end_month";i:0;s:8:"end_year";i:0;}}}} |
  136. | phpads50aa66c1578303.28970621 | 2012-11-19 11:09:23 | a:6:{s:8:"usertype";i:1;s:8:"loggedin";s:1:"t";s:8:"username";s:4:"blid";s:5:"prefs";a:2:{s:16:"client-index.php";a:4:{s:12:"hideinactive";s:1:"0";s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}s:19:"affiliate-index.php";a:3:{s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}}s:12:"update_check";b:0;s:12:"maint_update";a:2:{i:0;i:5;i:1;s:66:"Didn't receive 200 OK from remote server. (HTTP/1.1 404 Not Found)";}} |
  137. | phpads50aa7bb42b4bf9.20013815 | 2012-11-19 12:35:34 | a:6:{s:8:"usertype";i:1;s:8:"loggedin";s:1:"t";s:8:"username";s:8:"OPISRAEL";s:5:"prefs";a:2:{s:16:"client-index.php";a:4:{s:12:"hideinactive";b:1;s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}s:23:"stats-global-client.php";a:6:{s:12:"hideinactive";b:1;s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";s:6:"period";s:0:"";s:12:"period_range";a:6:{s:9:"start_day";i:0;s:11:"start_month";i:0;s:10:"start_year";i:0;s:7:"end_day";i:0;s:9:"end_month";i:0;s:8:"end_year";i:0;}}}s:12:"update_check";b:0;s:12:"maint_update";a:2:{i:0;i:5;i:1;s:66:"Didn't receive 200 OK from remote server. (HTTP/1.1 404 Not Found)";}} |
  138. | phpads50aa7b28d0ad27.82693128 | 2012-11-19 12:48:26 | a:5:{s:8:"usertype";i:1;s:8:"loggedin";s:1:"t";s:8:"username";s:8:"OPISRAEL";s:5:"prefs";a:1:{s:16:"client-index.php";a:4:{s:12:"hideinactive";b:1;s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}}s:12:"maint_update";a:2:{i:0;i:5;i:1;s:66:"Didn't receive 200 OK from remote server. (HTTP/1.1 404 Not Found)";}} |
  139. | phpads50aa7b735d7c69.31266922 | 2012-11-19 12:33:27 | a:4:{s:8:"usertype";i:1;s:8:"loggedin";s:1:"t";s:8:"username";s:8:"OPISRAEL";s:5:"prefs";a:1:{s:16:"client-index.php";a:4:{s:12:"hideinactive";b:1;s:9:"listorder";s:0:"";s:14:"orderdirection";s:0:"";s:5:"nodes";s:0:"";}}} |
  140. +-------------------------------+---------------------+----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+
  141.  
  142.  
  143.  
  144.  
  145. Table: phpads_clients
  146.  
  147. +------------------+---------------+
  148. | Column | Type |
  149. +------------------+---------------+
  150. | activate | date |
  151. | active | enum('t','f') |
  152. | clicks | int(11) |
  153. | clientid | mediumint(9) |
  154. | clientname | varchar(255) |
  155. | clientpassword | varchar(64) |
  156. | clientusername | varchar(64) |
  157. | contact | varchar(255) |
  158. | email | varchar(64) |
  159. | expire | date |
  160. | language | varchar(64) |
  161. | parent | mediumint(9) |
  162. | permissions | mediumint(9) |
  163. | report | enum('t','f') |
  164. | reportdeactivate | enum('t','f') |
  165. | reportinterval | mediumint(9) |
  166. | reportlastdate | date |
  167. | target | int(11) |
  168. | views | int(11) |
  169. | weight | tinyint(4) |
  170. +------------------+---------------+
  171.  
  172.  
  173.  
  174. Table: phpads_clients
  175.  
  176. +----------+-------+-----------------------+--------+--------+--------+------------+--------+--------+--------+---------+------------+----------+--------------------+-------------+----------------+----------------+----------------+----------------+------------------+
  177. | clientid | views | email | weight | parent | report | expire | target | active | clicks | contact | activate | language | clientname | permissions | clientpassword | reportlastdate | clientusername | reportinterval | reportdeactivate |
  178. +----------+-------+-----------------------+--------+--------+--------+------------+--------+--------+--------+---------+------------+----------+--------------------+-------------+----------------+----------------+----------------+----------------+------------------+
  179. | 115 | NULL | firaslabani@yahoo.com | 1 | 0 | t | 0000-00-00 | 0 | t | NULL | anas | 0000-00-00 | <blank> | Untitled | 0 | <blank> | 2012-09-26 | <blank> | 7 | t |
  180. | 116 | -1 | <blank> | 0 | 115 | t | 0000-00-00 | 0 | f | -1 | NULL | 0000-00-00 | NULL | Untitled - Default | NULL | <blank> | 0000-00-00 | <blank> | 7 | t |
  181. +----------+-------+-----------------------+--------+--------+--------+------------+--------+--------+--------+---------+------------+----------+--------------------+-------------+----------------+----------------+----------------+----------------+------------------+
  182.  
  183.  
  184.  
  185.  
  186. Table: phpads_userlog
  187.  
  188. +-----------+--------------+
  189. | Column | Type |
  190. +-----------+--------------+
  191. | action | mediumint(9) |
  192. | details | blob |
  193. | object | mediumint(9) |
  194. | timestamp | int(11) |
  195. | userid | mediumint(9) |
  196. | userlogid | mediumint(9) |
  197. | usertype | tinyint(4) |
  198. +-----------+--------------+
  199.  
  200.  
  201.  
  202. Table: phpads_zones
  203.  
  204. +-------------+--------------+
  205. | Column | Type |
  206. +-------------+--------------+
  207. | affiliateid | mediumint(9) |
  208. | append | blob |
  209. | appendtype | tinyint(4) |
  210. | chain | blob |
  211. | delivery | smallint(6) |
  212. | description | varchar(255) |
  213. | height | smallint(6) |
  214. | prepend | blob |
  215. | what | blob |
  216. | width | smallint(6) |
  217. | zoneid | mediumint(9) |
  218. | zonename | varchar(245) |
  219. | zonetype | smallint(6) |
  220. +-------------+--------------+
  221.  
  222.  
  223.  
  224. Table: phpads_zones
  225.  
  226. +-------+--------+-------------+-------------+---------+--------+---------+---------+----------+----------+----------+------------+-------------+
  227. | width | zoneid | affiliateid | what | chain | height | append | prepend | delivery | zonetype | zonename | appendtype | description |
  228. +-------+--------+-------------+-------------+---------+--------+---------+---------+----------+----------+----------+------------+-------------+
  229. | 125 | 7 | 1 | clientid:93 | <blank> | 125 | <blank> | <blank> | 0 | 3 | Test | 0 | <blank> |
  230. +-------+--------+-------------+-------------+---------+--------+---------+---------+----------+----------+----------+------------+-------------+
  231.  
  232.  
  233.  
  234. Table: phpads_affiliates
  235.  
  236. +-------------+---------------+
  237. | Column | Type |
  238. +-------------+---------------+
  239. | affiliateid | mediumint(9) |
  240. | contact | varchar(255) |
  241. | email | varchar(64) |
  242. | language | varchar(64) |
  243. | name | varchar(255) |
  244. | password | varchar(64) |
  245. | permissions | mediumint(9) |
  246. | publiczones | enum('t','f') |
  247. | username | varchar(64) |
  248. | website | varchar(255) |
  249. +-------------+---------------+
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!