API tools faq
paste
Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
89
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 14.65 KB | None | 0 0
raw download clone embed print report
  1. <?
  2. session_start();
  3. ?>
  4. <style>
  5. * { margin: 0; padding: 0; }
  6. body {
  7. background: #CCCCCC;
  8. color: #333;
  9. text-align: center;
  10. }
  11. .quadros {
  12. margin: 5px 0;
  13. padding: 10px;
  14. text-align: left;
  15. display: block;
  16. overflow: auto;
  17. /* white-space: pre; */
  18. background: #FAFAFA;
  19. border: 3px solid #EFEFEF;
  20. }
  21. .qdestaques {
  22. margin: 5px 0;
  23. padding: 10px;
  24. text-align: left;
  25. display: block;
  26. overflow: auto;
  27. /* white-space: pre; */
  28. background: #FAFAFA;
  29. border: 3px solid #FF3737;
  30. }
  31. input {
  32. padding:2px;
  33. border:1px solid #CFCFCF;
  34. font: Verdana, sans-serif;
  35. color:#777;
  36. }
  37. </style><div align="center">
  38. <table bgcolor="#CCCCCC" width="600" border="1">
  39. <tr>
  40. <td align="center" height="111"><img src="img/banner.jpg" width="600" height="114" /></td>
  41. </tr>
  42. <tr>
  43. <td align="center" height="22"><?
  44. if(isset($_POST[ip])) {
  45. $_SESSION[conection] = true;
  46. $_SESSION[host] = stripslashes($_POST[ip]);
  47. $_SESSION[user] = stripslashes($_POST[usuario]);
  48. $_SESSION[pwd] = stripslashes($_POST[senha]);
  49. $_SESSION[database] = stripslashes($_POST[bancodedados]);
  50. $_SESSION[nitens] = stripslashes($_POST[itens]);
  51. }
  52. if($_SESSION[conection] == true) {
  53. if(mssql_select_db($_SESSION[database], mssql_connect($_SESSION[host],$_SESSION[user],$_SESSION[pwd])) == false) session_destroy();
  54. } else {
  55. echo "<form action='$_SERVER[PHP_SELF]' method='POST'>
  56. <table class='quadros' width='600'>
  57. <tr>
  58. <td colspan='2' align='center'>Conex&atilde;o com o Banco de dados</td>
  59. </tr>
  60. <tr>
  61. <td align=right>IP Host: </td>
  62. <td><input name='ip' value='127.0.0.1' size='40'/></td>
  63. </tr>
  64. <tr>
  65. <td align=right>Banco de Dados: </td>
  66. <td><input name='bancodedados' value='MuOnline' size='40'/></td>
  67. </tr>
  68. <tr>
  69. <td align=right>Usu&aacute;rio: </td>
  70. <td><input name='usuario' value='sa' size='40'/></td>
  71. </tr>
  72. <tr>
  73. <td align=right>Senha: </td>
  74. <td><input name='senha' type='password' size='40'/></td>
  75. </tr>
  76. <tr>
  77. <td align=right>Itens: </td>
  78. <td><input name='itens' type='radio' value='1200'/> 1200 (Para versões menores que Season 2)<br /><input name='itens' type='radio' checked value='1920'/> 1920 (Para versões maiores que Season 2 ou a propria Season 2)</td>
  79. </tr>
  80. <tr>
  81. <td align='center' colspan='2'><input type='submit' value='Conectar ao banco de dados'/></td>
  82. </tr>
  83. </table>
  84. </form>";
  85. }
  86. if($_SESSION[conection] == true) {
  87.  
  88. function executarquery($arquivo) {
  89. $open = fopen($arquivo, "r");
  90. $conteudo = fread($open, filesize($arquivo));
  91.  
  92. if(mssql_query($conteudo) == true) { return "Criado com Sucesso."; } else { return "Erro."; }
  93.  
  94. }
  95.  
  96. function droparchave() {
  97.  
  98. $dropachave = "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[PK_MEMB_INFO]') and OBJECTPROPERTY(id, N'IsPrimaryKey') = 1)
  99. ALTER TABLE [dbo].[MEMB_INFO] DROP CONSTRAINT [PK_MEMB_INFO]";
  100.  
  101. if(mssql_query($dropachave) == true) { return "Criado com Sucesso."; } else { return "Erro."; }
  102.  
  103. }
  104.  
  105. function criar_procedure_muda_bau() {
  106. $apagarmuda_bau = "if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[Mudar_Bau]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
  107. drop procedure [dbo].[Mudar_Bau]";
  108.  
  109. $apagou = mssql_query($apagarmuda_bau);
  110.  
  111. $criarprocedure_muda_bau = "CREATE PROCEDURE Mudar_Bau
  112. @login VARCHAR(20)
  113. AS
  114. BEGIN
  115. UPDATE warehouse
  116. SET Items = (SELECT Itens2 FROM warehouse WHERE AccountID = @login),
  117. Itens2 = (SELECT Items FROM warehouse WHERE AccountID = @login)
  118. WHERE AccountID = @login
  119. END";
  120.  
  121. if(mssql_query($criarprocedure_muda_bau) == true) { return "Criado com Sucesso."; } else { return "Erro."; }
  122. }
  123.  
  124. function verificartabela($nome) {
  125. if(@mssql_query("SELECT * FROM ".$nome."") == true) { return "J&aacute; Criada."; } else { return executarquery("etc/".$nome.".sql"); }
  126. }
  127. function verificarcoluna($table,$nome,$tipo,$null,$default) {
  128. if(@mssql_query("SELECT ".$nome." FROM ".$table."") == true) { return "J&aacute; Criada."; } else {
  129. if($null == 1) $null = "NULL";
  130. if(mssql_query("ALTER TABLE $table ADD $nome $tipo $null $default")) { return "Criada com sucesso!"; } else { return "Erro."; }
  131. }
  132.  
  133. }
  134.  
  135. if($_GET[etapa] == 1 || isset($_GET[etapa]) == false) {
  136.  
  137. echo "<table class='quadros' width='500'>
  138. <tr>
  139. <td align='center' colspan='2'>Criar Tabelas</td>
  140. </tr>
  141. <tr>
  142. <td align='right'>Tabela: Eventos: </td>
  143. <td>".verificartabela("eventos")."</td>
  144. </tr>
  145. <tr>
  146. <td align='right'>Tabela: Noticias: </td>
  147. <td>".verificartabela("noticias")."</td>
  148. </tr>
  149. <tr>
  150. <td align='right'>Tabela: Site_perguntas: </td>
  151. <td>".verificartabela("Site_perguntas")."</td>
  152. </tr>
  153. <tr>
  154. <td align='right'>Tabela: Site_respostas: </td>
  155. <td>".verificartabela("Site_respostas")."</td>
  156. </tr>
  157. <tr>
  158. <td align='right'>Tabela: Site_screenshots: </td>
  159. <td>".verificartabela("Site_screenshots")."</td>
  160. </tr>
  161. <tr>
  162. <td align='right'>Tabela: Site_screenshotscoments: </td>
  163. <td>".verificartabela("Site_screenshotscoments")."</td>
  164. </tr>
  165. <tr>
  166. <td align='right'>Tabela: Site_screenshotsnotas: </td>
  167. <td>".verificartabela("Site_screenshotsnotas")."</td>
  168. </tr>
  169. <tr>
  170. <td align='right'>Tabela: Site_votalogins: </td>
  171. <td>".verificartabela("Site_votalogins")."</td>
  172. </tr>
  173. <tr>
  174. <td align='right'>Tabela: Site_votaips: </td>
  175. <td>".verificartabela("Site_votaips")."</td>
  176. </tr>
  177. <tr>
  178. <td align='center' colspan=2><input type='button' value='Proxima Etapa' onclick=\"location='".$_SERVER[PHP_SELF]."?etapa=2'\"/></td>
  179. </tr>
  180. </table>";
  181. } elseif($_GET[etapa] == 2) {
  182. echo "<table class='quadros' width='500'>
  183. <tr>
  184. <td align='center' colspan='2'>Criar Colunas</td>
  185. </tr>
  186. <tr>
  187. <td align='right'>Character::Resets: </td>
  188. <td>".verificarcoluna('Character','Resets','int','NOT NULL','DEFAULT 0')."</td>
  189. </tr>
  190. <tr>
  191. <td align='right'>Character::Resetao: </td>
  192. <td>".verificarcoluna('Character','Resetao','int','NOT NULL','DEFAULT 0')."</td>
  193. </tr>
  194. <tr>
  195. <td align='right'>Character::rankmes: </td>
  196. <td>".verificarcoluna('Character','rankmes','int','NOT NULL','DEFAULT 0')."</td>
  197. </tr>
  198. <tr>
  199. <td align='right'>Character::semanaldif: </td>
  200. <td>".verificarcoluna('Character','semanaldif','int','NOT NULL','DEFAULT 0')."</td>
  201. </tr>
  202. </tr>
  203. <td align='right'>Character::databloc: </td>
  204. <td>".verificarcoluna('Character','databloc','smalldatetime','','')."</td>
  205. </tr>
  206. <tr>
  207. <td align='right'>Character::diasdesbloc: </td>
  208. <td>".verificarcoluna('Character','diasdesbloc','int','','DEFAULT 0')."</td>
  209. </tr>
  210. <tr>
  211. <td align='right'>Character::motivobloc: </td>
  212. <td>".verificarcoluna('Character','motivobloc','nvarchar(50)','','')."</td>
  213. </tr>
  214. <tr>
  215. <td align='right'>Character::blocpor: </td>
  216. <td>".verificarcoluna('Character','blocpor','nvarchar(50)','','')."</td>
  217. </tr>
  218. <tr>
  219. <td align='right'>Character::ourotop: </td>
  220. <td>".verificarcoluna('Character','ourotop','int','NOT NULL','DEFAULT 0')."</td>
  221. </tr>
  222. <tr>
  223. <td align='right'>Character::pratatop: </td>
  224. <td>".verificarcoluna('Character','pratatop','int','NOT NULL','DEFAULT 0')."</td>
  225. </tr>
  226. <tr>
  227. <td align='right'>Character::bronzetop: </td>
  228. <td>".verificarcoluna('Character','bronzetop','int','NOT NULL','DEFAULT 0')."</td>
  229. </tr>
  230. <tr>
  231. <td align='right'>Character::ouroduelo: </td>
  232. <td>".verificarcoluna('Character','ouroduelo','int','NOT NULL','DEFAULT 0')."</td>
  233. </tr>
  234. <tr>
  235. <td align='right'>Character::prataduelo: </td>
  236. <td>".verificarcoluna('Character','prataduelo','int','NOT NULL','DEFAULT 0')."</td>
  237. </tr>
  238. <tr>
  239. <td align='right'>Character::bronzeduelo: </td>
  240. <td>".verificarcoluna('Character','bronzeduelo','int','NOT NULL','DEFAULT 0')."</td>
  241. </tr>
  242. <tr>
  243. <td align='right'>Character::ouroevento: </td>
  244. <td>".verificarcoluna('Character','ouroevento','int','NOT NULL','DEFAULT 0')."</td>
  245. </tr>
  246. <tr>
  247. <td align='right'>Character::prataevento: </td>
  248. <td>".verificarcoluna('Character','prataevento','int','NOT NULL','DEFAULT 0')."</td>
  249. </tr>
  250. <tr>
  251. <td align='right'>Character::bronzeevento: </td>
  252. <td>".verificarcoluna('Character','bronzeevento','int','NOT NULL','DEFAULT 0')."</td>
  253. </tr>
  254. <tr>
  255. <td align='right'>Character::foto: </td>
  256. <td>".verificarcoluna('Character','foto','varchar(300)','','')."</td>
  257. </tr>
  258. <tr>
  259. <td align='right'>MEMB_INFO::vip: </td>
  260. <td>".verificarcoluna('MEMB_INFO','vip','int','NOT NULL','DEFAULT 0')."</td>
  261. </tr>
  262. <tr>
  263. <td align='right'>MEMB_INFO::datavip: </td>
  264. <td>".verificarcoluna('MEMB_INFO','datavip','smalldatetime','','')."</td>
  265. </tr>
  266. <tr>
  267. <td align='right'>MEMB_INFO::diasdevip: </td>
  268. <td>".verificarcoluna('MEMB_INFO','diasdevip','int','','DEFAULT 0')."</td>
  269. </tr>
  270. <tr>
  271. <td align='right'>MEMB_INFO::vencimento: </td>
  272. <td>".verificarcoluna('MEMB_INFO','vencimento','smalldatetime','','')."</td>
  273. </tr>
  274. <tr>
  275. <td align='right'>MEMB_INFO::databloc: </td>
  276. <td>".verificarcoluna('MEMB_INFO','databloc','smalldatetime','','')."</td>
  277. </tr>
  278. <tr>
  279. <td align='right'>MEMB_INFO::diasdesbloc: </td>
  280. <td>".verificarcoluna('MEMB_INFO','diasdesbloc','int','','DEFAULT 0')."</td>
  281. </tr>
  282. <tr>
  283. <td align='right'>MEMB_INFO::motivobloc: </td>
  284. <td>".verificarcoluna('MEMB_INFO','motivobloc','nvarchar(50)','','')."</td>
  285. </tr>
  286. <tr>
  287. <td align='right'>MEMB_INFO::blocpor: </td>
  288. <td>".verificarcoluna('MEMB_INFO','blocpor','nvarchar(50)','','')."</td>
  289. </tr>
  290. <tr>
  291. <td align='right'>MEMB_INFO::gold: </td>
  292. <td>".verificarcoluna('MEMB_INFO','gold','int','NOT NULL','DEFAULT 0')."</td>
  293. </tr>
  294. <tr>
  295. <td align='right'>MEMB_INFO::LocalJogo: </td>
  296. <td>".verificarcoluna('MEMB_INFO','LocalJogo','nvarchar(50)','','')."</td>
  297. </tr>
  298. <tr>
  299. <td align='right'>MEMB_INFO::Conexao: </td>
  300. <td>".verificarcoluna('MEMB_INFO','Conexao','nvarchar(50)','','')."</td>
  301. </tr>
  302. <tr>
  303. <td align='right'>MEMB_INFO::Sexo: </td>
  304. <td>".verificarcoluna('MEMB_INFO','Sexo','nvarchar(50)','','')."</td>
  305. </tr>
  306. <tr>
  307. <td align='right'>MEMB_INFO::Idade: </td>
  308. <td>".verificarcoluna('MEMB_INFO','Idade','int','NOT NULL','DEFAULT 0')."</td>
  309. </tr>
  310. <tr>
  311. <td align='right'>MEMB_INFO::Numero: </td>
  312. <td>".verificarcoluna('MEMB_INFO','Numero','nvarchar(50)','','')."</td>
  313. </tr>
  314. <tr>
  315. <td align='right'>MEMB_INFO::Creditos: </td>
  316. <td>".verificarcoluna('MEMB_INFO','Creditos','nvarchar(50)','','')."</td>
  317. </tr>
  318. <tr>
  319. <td align='right'>MEMB_INFO::Frase: </td>
  320. <td>".verificarcoluna('MEMB_INFO','Frase','nvarchar(50)','','')."</td>
  321. </tr>
  322. <tr>
  323. <td align='right'>MEMB_INFO::autoriza: </td>
  324. <td>".verificarcoluna('MEMB_INFO','autoriza','int','NOT NULL','DEFAULT 0')."</td>
  325. </tr>
  326. <tr>
  327. <td align='right'>MEMB_INFO::contagm: </td>
  328. <td>".verificarcoluna('MEMB_INFO','contagm','int','NOT NULL','DEFAULT 0')."</td>
  329. </tr>
  330. <tr>
  331. <td align='right'>warehouse::Itens2: </td>
  332. <td>"; if($_SESSION[nitens] == 1200) echo verificarcoluna('warehouse','Itens2','varbinary(1200)','',''); else echo verificarcoluna('warehouse','Itens2','varbinary(1920)','',''); echo "</td>
  333. </tr>
  334. <tr>
  335. <td align='right'>warehouse::pwd: </td>
  336. <td>".verificarcoluna('warehouse','pwd','smallint','NOT NULL','DEFAULT 1')."</td>
  337. </tr>
  338. <tr>
  339. <td align='center' colspan=2><input type='button' value='Proxima Etapa' onclick=\"location='".$_SERVER[PHP_SELF]."?etapa=3'\"/></td>
  340. </tr>
  341. </table>";
  342. } elseif($_GET[etapa] == 3) {
  343. echo "<table class='quadros' width='500'>
  344. <tr>
  345. <td align='center' colspan='2'>Criar Procedures</td>
  346. </tr>
  347. <tr>
  348. <td align='right'>ChecaSenha: </td>
  349. <td>".executarquery("etc/ChecaSenha.sql")."</td>
  350. </tr>
  351. <tr>
  352. <td align='right'>Encripta: </td>
  353. <td>".executarquery("etc/Encripta.sql")."</td>
  354. </tr>
  355. <tr>
  356. <td align='right'>Tickets: </td>
  357. <td>".executarquery("etc/Site_Tickets.sql")."</td>
  358. </tr>
  359. <tr>
  360. <td align='right'>Respostas Tickets: </td>
  361. <td>".executarquery("etc/Site_Tickets_Respostas.sql")."</td>
  362. </tr>
  363. <tr>
  364. <td align='right'>Chave_MEMB_INFO: </td>
  365. <td>".droparchave()."</td>
  366. </tr>
  367. <tr>
  368. <td align='right'>Muda_Bau: </td>
  369. <td>".criar_procedure_muda_bau()."</td>
  370. </tr>
  371. <tr>
  372. <td align='center' colspan=2><input type='button' value='Proxima Etapa' onclick=\"location='".$_SERVER[PHP_SELF]."?etapa=4'\"/></td>
  373. </tr>
  374. </table>";
  375. } elseif($_GET[etapa] == 4) {
  376. echo "<table class='quadros' width='500'>
  377. <tr>
  378. <td align='center' colspan='2'>Criar Jobs</td>
  379. </tr>
  380. <tr>
  381. <td align='right'>Site_CharsBloq: </td>
  382. <td>".executarquery("etc/Site_CharsBloq.sql")."</td>
  383. </tr>
  384. <tr>
  385. <td align='right'>Site_ContasBloc: </td>
  386. <td>".executarquery("etc/Site_ContasBloc.sql")."</td>
  387. </tr>
  388. <tr>
  389. <td align='right'>Site_Ranking_Mensal.sql: </td>
  390. <td>".executarquery("etc/Site_Ranking_Mensal.sql")."</td>
  391. </tr>
  392. <tr>
  393. <td align='right'>Site_Ranking_Semanal: </td>
  394. <td>".executarquery("etc/Site_Ranking_Semanal.sql")."</td>
  395. </tr>
  396. <tr>
  397. <td align='right'>Site_Vips: </td>
  398. <td>".executarquery("etc/Site_Vips.sql")."</td>
  399. </tr>
  400. <tr>
  401. <td align='right'>Site_SVips: </td>
  402. <td>".executarquery("etc/Site_SVips.sql")."</td>
  403. </tr>
  404. <tr>
  405. <td align='center' colspan=2><input type='button' value='Proxima Etapa' onclick=\"location='".$_SERVER[PHP_SELF]."?etapa=5'\"/></td>
  406. </tr>
  407. </table>";
  408. } elseif($_GET[etapa] == 5) {
  409. echo "<table class='quadros' width='500'>
  410. <tr>
  411. <td align='center' colspan='2'>Finalizando Instala&ccedil;&atilde;o: </td>
  412. </tr>
  413. <tr>
  414. <td align='right'>Apagando Sessions: </td>
  415. <td>"; if(session_destroy() == true) echo "OK"; else echo "Erro"; echo "</td>
  416. </tr>
  417. <tr>
  418. <td align='right'>Fechando Conex&atilde;o com o SQL: </td>
  419. <td>"; if(mssql_close() == true) echo "OK"; else echo "Erro"; echo "</td>
  420. </tr>
  421. <tr>
  422. <td align='center' colspan='2'><br/><b>A instala&ccedil;&atilde;o do site foi concluida com sucesso!<br/>Apague essa pasta para sua seguran&ccedil;a!<br>Obrigado!</b></td>
  423. </tr>
  424. </table>";
  425. }
  426.  
  427. }
  428. ?></td>
  429. </tr>
  430. </table>
  431. </div>
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!