Ir para conteúdo
Fórum Script Brasil

MGProjects

Membros
 Perfil  Explorar Conteúdo

  • Total de itens

    3

  • Registro em

  • Última visita

Sobre MGProjects

MGProjects's Achievements

0

Reputação

  1. MGProjects
    Galera precisava de uma ajuda no php.. bem eu to fazendo um sistema.. e eu precisava que ele somasse a quantia existente.. exemplo $silkAdd = $rowPin['qtd_silk']; $JIDsilks = mssql_query("SELECT silk_own FROM SK_Silk WHERE JID = '$userJID'") ; $soma = ($JIDsilks + $silkAdd); { mssql_query("update SK_Silk set silk_own = '$soma' where JID = '$userJID'"); echo "Silks have been updated to $soma"; } ele tinha que pegar na tabela a quantia existente, e somar com a nova quantia só que tem um problema.. ele não soma.. sempre add o numero da quantia que esta no codigo que eu coloco ou seja se no silk_own tem 100 e o codigo é pra add 200 ele simplismente muda pra 200 , o correto seria ele colocar 300.. quantia atual + nova quantia.. quem puder me ajudar eu agradeço EDITTT consegui.. eu estava errando na query
  2. MGProjects
    como faço para abrir um php em uma pagina com java scrypt e ele não exibir meu codigo? codigo do index em HTML. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8" /> <title>templates</title> <link rel="stylesheet" type="text/css" media="screen" href="style.css" /> &lt;script src="js/AC_RunActiveContent.js" type="text/javascript"></script> &lt;script src="js/jquery142.js" type="text/javascript"></script> &lt;script src="js/sound.js" type="text/javascript"></script> &lt;script src="js/main.js" type="text/javascript"></script> <!--BEGIN OF TERMS OF USE. DO NOT EDIT OR DELETE THESE LINES. IF YOU EDIT OR DELETE THESE LINES AN ALERT MESSAGE MAY APPEAR WHEN TEMPLATE WILL BE ONLINE--> <style>#free-flash-header a,#free-flash-header a:hover {color:#FFFFFF;}#free-flash-header a:hover {text-decoration:none}</style> <!--END OF TERMS OF USE--> <!--[if lt IE 8]> <style type=text/css"> <!-- #free-flash-header {bottom: 115px;} --> </style> <![endif]--> </head> <body> <div id="body"> <div id="holder"> <!--BEGIN OF TERMS OF USE. DO NOT EDIT OR DELETE THESE LINES. IF YOU EDIT OR DELETE THESE LINES AN ALERT MESSAGE MAY APPEAR WHEN TEMPLATE WILL BE ONLINE--> <div id="copy" style="height: 75px; position: absolute; bottom: 0px; left:0px; border: none; width: 100%;"> <div id="free-flash-header" style="width:820px;margin:0 auto;text-align:right;position:relative;bottom:0px;margin-top:63px;color:#FFFFFF;font-size:10px;font-family:Verdana"></div> </div> <!--END OF TERMS OF USE--> <div id="frame"> <!-- MENU --> <div id="big_menu"> <table> <tr> <td><a href="java script:showPage('_home.htm', '');"> Home </a> </td> <td><a href="java script:showPage('reg.php', '');"> Registration </a> </td> <td><a href="java script:showPage('_forum.htm', '');"> SERVER RATES</a></td> <td><a href="java script:showPage('_serveur.htm', '');"> PLAYERS INFO</a> </td> <td><a href="java script:showPage('_serveur.htm', '');"> FORUM </a> </td> </tr> </table> </div> <!-- MENU END --> <!-- HEADER --> <div id="header"> <div id="header_id"></div> &lt;script type="text/javascript"> var hasRightVersion = DetectFlashVer(requiredMajorVersion, requiredMinorVersion, requiredRevision); if(hasRightVersion) { myFlashHeader('flash/header',900,500,'#000000','header_id','custom.xml'); } else { alert("Your version of Flash player is rather old. We suggest you to upgrade your Flash player to version "+requiredMinorVersion+" (at least).The latest version can be downloaded here : http://www.adobe.com/shockwave/download/do...eFlash."); } </script> </div> <!-- HEADER END --> <div class="clear"> </div> <div id="border"> <div id="content"> <!-- MENU LEFT --> <div id="left_menu"> <div class="little_menu"> <div> <h1>Movie</h1> <ul> <li></li> <li></li> <li></li> </ul> </div> <div> <h1>MGP Silkroad Online</h1> <ul> <li></li> <li></li> <li></li> <li></li> </ul> </div> </div> </div> <!-- MENU LEFT END --> <!-- CONTENT BLOCK --> <div class="dynamicContent"></div> <!-- BLOCK CONTENT END --> <!-- MENU RIGHT --> <div id="right_menu"> <div class="little_menu"> <div> <h1>Activity</h1> <p>&nbsp;</p> </div> </div> </div> <!-- MENU RIGHT END --> </div> <div class=" clear"> </div> </div> <!-- FOOTER --> <div id="footer"> <span class="copyright">MGProjects&reg; Copyright &copy; 2011..</span></div><br/> <!-- FOOTER END --> </div> <!-- FRAME END --> </div> <!-- HOLDER END --> </div> </body> </html> codigo do php &lt;script type="text/javascript"> alert("<?php echo "olá"; ?>"); </script> <head> <link rel="shourtcut icon" href="favicon.ico"> <STYLE TYPE="text/css">@import url(style.css);</STYLE> <title>MGPSro - Registration</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="description" content="EGSRO Private Server"> <head> <link rel="shourtcut icon" href="favicon.ico"> <STYLE TYPE="text/css">@import url(style.css);</STYLE> <title>MGPSro</title> <meta http-equiv="Content-Type" content="text/html; charset=utf-8"> <meta name="description" content="EGSRO Private Server"> </head> <body> <div align="center"> <tr> <td style="width: 10px">&nbsp;</td> <?php /* Simple registration page for silkroad server, by Chernobyl * Settings are at _inc/config.php * If you get an mssql connection error, while defining totally correct data * Just use older ntwdblib.dll for your webserver */ require_once('_inc/security.class.php'); require_once('_inc/config.php'); if(!isset($_POST['submit])) { echo "<form method='post'> <table border='0' align='center'> <br><br><br><br><br><br><br><br><br><br><br><br><br> <td><td align='center'><h1>Username:</td><td><input type='text' name='username' maxlength='16'></td><tr/> <td><td align='center'><h1>Password:</td><td><input type='password' name='pw1' maxlength='32'></td><tr/> <td><td align='center'><h1>Password again:</td><td><input type='password' name='pw2' maxlength='32'></td><tr/> <td><td align='center'><h1></td><td><input type='submit' name='submit' value='Register'></td> </form> </table>"; } else { if(strlen($_POST['username']) < 3) $msg[] = "Username too short"; if(strlen($_POST['username']) > 16)$msg[] = "Username too long"; if(strlen($_POST['pw1']) < 6) $msg[] = "<h1>Password too short"; if(strlen($_POST['pw1']) > 32)$msg[] = "<h1>Password too long"; if(strlen($_POST['pw2']) < 6) $msg[] = "<h1>Password too short"; if(strlen($_POST['pw2']) > 32) $msg[] = "<h1>Password too long"; if($_POST['pw1'] != $_POST['pw2']) $msg[] = "<h1>Passwords do not match"; $sec = new security(); if($sec->is_secure($_POST['username']) == false) $msg[] = "Username contains forbidden symbols"; if($sec->is_secure($_POST['pw1']) == false) $msg[] = "<h1>Passwords contains forbidden symbols"; if($sec->is_secure($_POST['pw2']) == false) $msg[] = "<h1>Passwords do not match"; if(count($msg) > 0) { for($i = 0; $i < count($msg); $i++) { echo $msg[$i]."<br/>"; } return; } else { //checking damn mssql stuff $accountExists = mssql_num_rows(mssql_query("select StrUserID from TB_User where StrUserID=$_POST[username]'")); if($accountExists > 0) echo "<h1>User name already used<br/>"; else { $pwd = md5($_POST['pw1]); mssql_query("insert into TB_User(StrUserID,password,sec_primary,sec_content) values('$_POST[username]','$pwd','3','3')"); echo "<h1>Account successfully created<br/>"; } } } ?>
  3. MGProjects
    bem estava tentando fazer uma conexão com o sql 2005 com o php do apache.. estou com esse erro quando abro a pagina Notice: Use of undefined constant sql_host - assumed 'sql_host' in C:\wamp\www\_inc\config.php on line 9 Notice: Use of undefined constant sql_user - assumed 'sql_user' in C:\wamp\www\_inc\config.php on line 9 Notice: Use of undefined constant sql_pass - assumed 'sql_pass' in C:\wamp\www\_inc\config.php on line 9 Notice: Use of undefined constant sql_db - assumed 'sql_db' in C:\wamp\www\_inc\config.php on line 13 codigo da conexão <?php $cfg['sql_host'] = "ZULU631\SQLEXPRESS"; $cfg['sql_user'] = "sa"; $cfg['sql_pass'] = "A0168t21"; $cfg['sql_db'] = "SRO_VT_ACCOUNT"; $sqlLink = mssql_connect($cfg[sql_host],$cfg[sql_user],$cfg[sql_pass]); if(!$sqlLink) die("MSSQL server is not accessable, why should we try to select database ?"); else { mssql_select_db($cfg[sql_db],$sqlLink); } ?> codigo do index. <?php /* Simple registration page for silkroad server, by Chernobyl * Settings are at _inc/config.php * If you get an mssql connection error, while defining totally correct data * Just use older ntwdblib.dll for your webserver */ require_once('_inc/security.class.php'); require_once('_inc/config.php'); if(!isset($_POST['submit'])) { echo "<table border=1'> <form method='post'> <td>Username</td><td><input type='text' name='username' maxlength='16'></td><tr/> <td>Password[1]</td><td><input type='password' name='pw1' maxlength='32'></td><tr/> <td>Password[2]</td><td><input type='password' name='pw2' maxlength='32'></td><tr/> <td></td><td><input type='submit' name='submit' value='Register'></td> </form> </table>"; } else { if(strlen($_POST['username]) < 3) $msg[] = "Username too short"; if(strlen($_POST['username']) > 16)$msg[] = "Username too long"; if(strlen($_POST['pw1']) < 6) $msg[] = "Password [1] too short"; if(strlen($_POST['pw1']) > 32)$msg[] = "Password [1] too long"; if(strlen($_POST['pw2']) < 6) $msg[] = "Password [2] too short"; if(strlen($_POST['pw2']) > 32) $msg[] = "Password [2] too long"; if($_POST['pw1'] != $_POST['pw2']) $msg[] = "Passwords are not the same"; $sec = new security(); if($sec->is_secure($_POST['username']) == false) $msg[] = "Username contains forbidden symbols"; if($sec->is_secure($_POST['pw1']) == false) $msg[] = "Password [1] contains forbidden symbols"; if($sec->is_secure($_POST['pw2']) == false) $msg[] = "Password [2] contains forbidden symbols"; if(count($msg) > 0) { for($i = 0; $i < count($msg); $i++) { echo $msg[$i]."<br/>"; } return; } else { //checking damn mssql stuff $accountExists = mssql_num_rows(mssql_query("select StrUserID from TB_User where StrUserID=$_POST[username]'")); if($accountExists > 0) echo "Account with such username already exists<br/>"; else { $pwd = md5($_POST['pw1]); mssql_query("insert into TB_User(StrUserID,password,sec_primary,sec_content) values('$_POST[username]','$pwd','3','3')"); echo "Account successfully created<br/>"; } } } ?> ai quando eu do ok para add na tabela ele aparece Password [1] too short Password [2] too short mais não add nada na dbo
×
×
  • Criar Novo...