[trinitycore] registrace

chippy · July 9, 2010

ahoj lidi mam tu script na registrace a nefunguje kdo mi pomuze vyplnit dobre tk rep+ predem diky , aby ste si nemysleli hesla sem vymazal nez sem to sem dal xD

<?php include("include/config.php"); ?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN" "http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title><?php print("$title"); ?> - Create Account</title>
<meta http-equiv="imagetoolbar" content="false"/>
<meta http-equiv="content-type" content="text/html; charset=windows-1250" />
<link rel="stylesheet" type="text/css" media="screen, projection" href="images/master.css"/>
<!--[if IE 6]>
<link rel="stylesheet" type="text/css" href="/login/_themes/wam/css/master-ie6.css" />
<![endif]-->
<script type="text/javascript" src="js/common.js"></script>
<script type="text/javascript" src="js/jquery.js"></script>
<script type="text/javascript">
var $j = jQuery.noConflict();
var processingStr = "In Bearbeitung";
</script>

<style type="text/css">

body {
font-family:	Verdana, Helvetica, Arial, Sans-Serif;
font:			Message-Box;
}

code {
font-size:	1em;
}

/* extra rules for even and odd rows */
.even {
background:	#eee;
}

.odd {

}
</style>

</head>
<body class="mt">

<?php include("templates/$cataclysm/header.html"); ?>
<div class="page loginView">
<div class="">

<center>
Server is : <?php
$ip = "90.177.96.148"; 
$port = "3306"; 
if (! $sock = @fsockopen($ip, $port, $num, $error, 5)) 

echo '<font color="red">OFFLINE</font>'; 
else{ 
echo '<font color="green">ONLINE</font>'; 
fclose($sock); 
} 
?>

<?php


function OnlinePlayersCountHorde()
{
 global $90.177.96.148, $root, $mojeheslo, $world;
 $DbSession = mysql_connect($90.177.96.148, $root, $mojeheslo);
 mysql_select_db($world, $DbSession);
 $Query = "SELECT COUNT(*) FROM characters WHERE online = 1 AND race IN (2, 5, 6, 8, 10)";
 $DbResult = mysql_query($Query, $DbSession);
 $DbRow = mysql_fetch_row($DbResult);
 $Count = $DbRow[0];
 mysql_free_result($DbResult);
 mysql_close(); 
 return($Count);
}

function OnlinePlayersCountAliance()
{
 global $90.177.96.148, $root, $mojeheslo, $world;
 $DbSession = mysql_connect($90.177.96.148, $root, $mojeheslo);
 mysql_select_db($world, $DbSession);
 $Query = "SELECT COUNT(*) FROM characters WHERE online = 1 AND race IN (1, 3, 4, 7, 11)";
 $DbResult = mysql_query($Query, $DbSession);
 $DbRow = mysql_fetch_row($DbResult);
 $Count = $DbRow[0];
 mysql_free_result($DbResult);
 mysql_close(); 
 return($Count);
}

function OnlinePlayersCountAlianceAndHorde()
{
 return OnlinePlayersCountHorde() + OnlinePlayersCountAliance();
}



echo ('<table><tr><td align=\"center\">Aliance</td> <td align=\"center\">Horda</td> <td align=\"center\">Celkem</td></tr>');
echo ('<tr><th>'.OnlinePlayersCountAliance()); 
echo ('</th>');
echo ('<th>'.OnlinePlayersCountHorde()); 
echo ('</th>');
echo ('<th>'.OnlinePlayersCountAlianceAndHorde());
echo ('<th></tr></table>'); ?>


<form id="loginForm" class="submitForm" name="loginForm" autocomplete="off" method="post" action="register.php">
   <div class="formRow accountName">
   	<label class="formLabel" for="accountName" style="margin-bottom:1px">Nazev uctu</label>
   	<input value="" id="mysqluser" name="mysqluser" maxlength="320" type="text" tabindex="1" class="text" />
   </div>
   <div class="formRow email">
   	<label class="formLabel" for="email">E-Mail Adresa</label>
       <input id="email" name="email" maxlength="26" type="text" tabindex="2" autocomplete="off" class="text" />
</div>
   <div class="formRow password">
	<label class="formLabel" for="password">Heslo</label>
	<input id="pw" name="pw" maxlength="26" type="password" tabindex="2" autocomplete="off" class="text" />
</div>
   <div class="formRow password2">
	<label class="formLabel" for="password2">Heslo znovu</label>
	<input id="pw2" name="pw2" maxlength="26" type="password" tabindex="2" autocomplete="off" class="text" />
</div>
   <center>
   <label class="expansion">
   <input type="radio" name="expansion" value="0">Classic
   <input type="radio" name="expansion" value="1">TBC
   <input type="radio" name="expansion" value="2">WotLK<br>
   <input type="submit" class="hiddenSubmit" />
   </label>
   </center>
   <a class="submit" href="javascript:;" onclick="Form.submit(this)" tabindex="3">Register</a><b><h2>
<center>

<br><br>
<font color="white"><a href="/Forum/">Forum</a></font>      
<font color="white"><a href="/banlist/">Banlist</a></font>     
<font color="white"><a href="index.php">Homepage</a></font>      
<font color="white">Realmlist: wow server </font>
</b></h2>
<br><br>
<font color="white">
<?php



echo "<table class='sort-table' id='table-1' cellspacing='0'>
<thead>
<tr><th style='width:100px; height:40'> Jmeno </th><th> Class </th><th>Rasa</th><th> Level </th></tr></thead>";
$connect = mysql_connect($90.177.96.148 , $root, $mojeheslo)  or die ("Spojeni se serverem $90.177.96.148 nebylo uspesne");
mysql_select_db($world, $connect)  or die ("Nepodarilo se spojit databazi $world");
$sql = "SELECT `name`,`class`,`race`, `level` FROM `characters` WHERE `online` = 1";
$result = mysql_query($sql, $connect);

while ($vystup = mysql_fetch_array($result))
{
   echo "<tbody><tr><td class='odd' align=\"center\">".$vystup["name"]."</td>";
   echo "<td class='even' align=\"center\">";

   switch ($vystup["class"]):

       case 1:
         print "<img src=\"img/1.gif\">";
         break;
       case 2:
         print "<img src=\"img/2.gif\">";
         break;
       case 3:
         print "<img src=\"img/3.gif\">";
         break;
       case 4:
         print "<img src=\"img/4.gif\">";
         break;
       case 5:
         print "<img src=\"img/5.gif\">";
         break;
 case 6:
         print "<img src=\"img/6.gif\">";
         break;
       case 7:
         print "<img src=\"img/7.gif\">";
         break;
       case 8:
         print "<img src=\"img/8.gif\">";
         break;
       case 9:
         print "<img src=\"img/9.gif\">";
         break;
       case 11:
         print "<img src=\"img/11.gif\">";
         break;
   endswitch;

   echo "</td><td class='even' align=\"center\">";
   switch ($vystup["race"]):

       case 1:
         print "<img src=\"img/1-0.gif\">";
         break;
       case 2:
         print "<img src=\"img/2-0.gif\">";
         break;
       case 3:
         print "<img src=\"img/3-0.gif\">";
         break;
       case 4:
         print "<img src=\"img/4-0.gif\">";
         break;
       case 5:
         print "<img src=\"img/5-0.gif\">";
         break;
       case 6:
         print "<img src=\"img/6-0.gif\">";
         break;
       case 7:
         print "<img src=\"img/7-0.gif\">";
         break;
       case 8:
         print "<img src=\"img/8-0.gif\">";
         break;
       case 10:
         print "<img src=\"img/10-0.gif\">";
         break;
       case 11:
         print "<img src=\"img/11-0.gif\">";
         break;
   endswitch;

   echo "</td>";
   echo "<td>".$vystup["level"]."</td>";

echo "</tr>";

}
mysql_close();
   echo "</tbody></table>";
?>
<br><br>

</font>
</form>	
</div>
</body>
<small>
<center>
<br><br>
2010 Gameshoot.eu || Vsechna prava vyhrazena 
<br><br>
</small>
</html>

Edited July 9, 2010 by chippy

Filajer · July 9, 2010

error?

chippy · July 9, 2010

error?

kdyz to dam na net tk to pise ...

Parse error: syntax error, unexpected T_DNUMBER, expecting T_STRING or T_VARIABLE or '{' or '$' in /home/free/ic.cz/d/death-trinity/root/www/index.php on line 65

Nightavanger · July 9, 2010

Typl bych to na chybu na 65. řádků, v T_DNUMBER :rolleyes:

chippy · July 9, 2010

Typl bych to na chybu na 65. řádků, v T_DNUMBER

muzes poradit presneji zadny T_DNUMBER tam neni

inac je to toto...

global $90.177.96.148, $root, $mojeheslo, $world;

tk co bych mel zmenit

Edited July 9, 2010 by chippy

Nightavanger · July 9, 2010

nemáš v heslu nestandartní znaky? další věc je že ic.cz nepodporuje připojování k jiným serverům x)

chippy · July 9, 2010

nemáš v heslu nestandartní znaky? další věc je že ic.cz nepodporuje připojování k jiným serverům x)

ok v heslu jsou jen cisla a pismena ztm rep+ moc diky

chippy · July 9, 2010

cau hele jine registrace vypadaji jednouzseji jen nvm kde mam chybu ..

<?php

include("db.conf.php");

$page = '<?xml version="1.0" encoding="utf-8" ?>
<!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" xml:lang="en" lang="en">
<head>
<title>' . $title . '</title>
</head>
<body style="background-color:black;color:yellow;font-family:verdana;">
<form method="post" action="' . $_SERVER["SCRIPT_NAME"] . '">
<p style="text-align:center;">
<strong>' . $title2 . ' - ' . $title . '</strong>
<br /><br /><br />
Username:
<br /><input name="username" type="text" maxlength="14" /><br />
Password:
<br /><input name="password" type="password" maxlength="12" /><br />
Email:
<br /><input name="email" type="text" maxlength="255" />
<br />
<INPUT TYPE=RADIO NAME="expansion" VALUE="0"         >Original -
<INPUT TYPE=RADIO NAME="expansion" VALUE="1"         >TBC -
<INPUT TYPE=RADIO NAME="expansion" VALUE="2" CHECKED >WOTLK<br />
<br /><br /><br />
<button type="submit">Submit</button>
</p>
</form>
</body>
</html>';

function error_s ($text) {
   echo("<p style=\"background-color:black;color:yellow;font-family:verdana;\">" . $text);
   echo("<br /><br /><a style=\"color:orange;\" href=\"" . $_SERVER["SCRIPT_NAME"] . "\">Go back...</a></p>");
};

$user_chars = "#[^a-zA-Z0-9_\-]#";
$email_chars = "/^[^0-9][A-z0-9_]+([.][A-z0-9_]+)*[@][A-z0-9_]+([.][A-z0-9_]+)*[.][A-z]{2,4}$/";

$con = @mysql_connect($ip, $user, $pass);
if (!$con) {
   error_s("Unable to connect to database: " . mysql_error());
};

if (!empty($_POST)) {
       if ((empty($_POST["username"]))||(empty($_POST["password"]))||(empty($_POST["email"]))||(empty($_POST["expansion"])) ) {
               error_s("You did not enter all the required information.");
               exit();
       } else {
               $username = strtoupper($_POST["username"]);
               $password = strtoupper($_POST["password"]);
               $email = strtoupper($_POST["email"]);
               $expansion = $_POST["expansion"];
               if (strlen($username) < 5) {
                       error_s("Username too short.");
                       exit();
               };
               if (strlen($username) > 14) {
                       error_s("Username too long.");
                       exit();
               };
               if (strlen($password) < 8) {
                       error_s("Password too short.");
                       exit();
               };
               if (strlen($password) > 12) {
                       error_s("Password too long.");
                       exit();
               };
               if (strlen($email) < 4) {
                       error_s("Email was too short.");
                       exit();
               };
               if (strlen($email) > 255) {
                       error_s("Email was too long.");
                       exit();
               };
               if (preg_match($user_chars,$username)) {
                       error_s("Username contained illegal characters.");
                       exit();
               };
               if (preg_match($user_chars,$password)) {
                       error_s("Password contained illegal characters.");
                       exit();
               };
               if (!preg_match($email_chars,$email)) {
                       error_s("Email was in an incorrect format.");
                       exit();
               };
               $user = mysql_real_escape_string($user);
               $password = mysql_real_escape_string($password);
               $email = mysql_real_escape_string($email);
               $qry = @mysql_query("select username from " . mysql_real_escape_string($r_db) . ".account where username = '" . $username . "'", $con);
               if (!$qry) {
                   error_s("Error querying database: " . mysql_error());
               };
               if ($existing_username = mysql_fetch_assoc($qry)) {
                       foreach ($existing_username as $key => $value) {
                               $existing_username = $value;
                       };
               };
               $existing_username = strtoupper($existing_username);
               if ($existing_username == strtoupper($_POST['username'])) {
                       error_s("That username is already taken.");
                       exit();
               };
               unset($qry);
               $qry = @mysql_query("select email from " . mysql_real_escape_string($r_db) . ".account where email = '" . $email . "'", $con);
               if (!$qry) {
                   error_s("Error querying database: " . mysql_error());
               };
               if ($existing_email = mysql_fetch_assoc($qry)) {
                       foreach ($existing_email as $key => $value) {
                               $existing_email = $value;
                       };
               };
               if ($existing_email == $_POST['email']) {
                       error_s("That email is already in use.");
                       exit();
               };
               unset($qry);
               $sha_pass_hash = sha1(strtoupper($username) . ":" . strtoupper($password));
               $register_sql = "insert into " . mysql_real_escape_string($r_realmd) . ".account (username, sha_pass_hash, email, expansion) values (upper('" . $username . "'),'" . $sha_pass_hash . "','" . $email . "','" . $expansion . "')";
               $qry = @mysql_query($register_sql, $con);
               if (!$qry) {
                   error_s("Error creating account: " . mysql_error());
               };
               echo("Account successfully created.");
               exit();
       };
} else {
       echo($page);
};

?>

error to dela

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /home/free/ic.cz/t/test-archangel/root/www/index.php on line 91

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/free/ic.cz/t/test-archangel/root/www/index.php on line 91

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /home/free/ic.cz/t/test-archangel/root/www/index.php on line 92

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/free/ic.cz/t/test-archangel/root/www/index.php on line 92

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: Access denied for user 'www-data'@'localhost' (using password: NO) in /home/free/ic.cz/t/test-archangel/root/www/index.php on line 93

Warning: mysql_real_escape_string() [function.mysql-real-escape-string]: A link to the server could not be established in /home/free/ic.cz/t/test-archangel/root/www/index.php on line 93

pritom na tom radku nechapu chybu ptz ikdyz je tam $user nebo $password tk to napise chybu a ikdyz tam dam $root a $mojeheslo tk to napise chybu

Nightavanger · July 9, 2010

Už jsem ti to řikal, ic nedovoluje připojovat se na jiný servery. Nepůjdou ti tam žádné registrace. Zkus endora.cz

chippy · July 9, 2010

Už jsem ti to řikal, ic nedovoluje připojovat se na jiný servery. Nepůjdou ti tam žádné registrace. Zkus endora.cz

ale kdyz sem delal na mangos regi jednou a mel sem to na ic,cz tk to slo

J0dA · July 9, 2010

to jeste byla ta funkce povolena :rolleyes:

Nightavanger · July 9, 2010

Buď si to s něčím pleteš nebo to byl nějaký interní error ic.

chippy · July 9, 2010

to jeste byla ta funkce povolena

lol tk nechapu co zas vymejsli to ic.cz dik mno budu muset cekat do pondeli xD

Hkarta · July 9, 2010

Nechci vypadat jako blbec, ale tohle mi příjde jako totální píčovina:

global $90.177.96.148, $root, $mojeheslo, $world;

Už jen proto, že pokud vím, v php jsou proměnné globální tak nějak samy od sebe.

O použití čísla v názvu proměnné si taky dovolím pochybovat.

Řekl bych, že jsi měl při psaní scriptu na mysli spíš toto:

$ip = "90.177.96.148";
$user = "root";
$password = "tvojeheslo";
$database = "characters";

A s tím dále pracovat.

Možná mluvím z cesty, nejsem žádný php pro a třeba je to prostě jen moje neznalost. Script jsem nečetl, nechtělo sem i to pročítat.

Sign In

Announcements

Pravidlo pro postování v TTT

Seznam návodů a důležitých témat v této sekci

Příspěvky tam, kde nemají co dělat

Používání spoilerů

[trinitycore] registrace

Recommended Posts

chippy 7

Share this post

Link to post

Share on other sites

Filajer 19

Share this post

Link to post

Share on other sites

chippy 7

Share this post

Link to post

Share on other sites

Nightavanger 51

Share this post

Link to post

Share on other sites

chippy 7

Share this post

Link to post

Share on other sites

Nightavanger 51

Share this post

Link to post

Share on other sites

chippy 7

Share this post

Link to post

Share on other sites

chippy 7

Share this post

Link to post

Share on other sites

Nightavanger 51

Share this post

Link to post

Share on other sites

chippy 7

Share this post

Link to post

Share on other sites

J0dA 135

Share this post

Link to post

Share on other sites

Nightavanger 51

Share this post

Link to post

Share on other sites

chippy 7

Share this post

Link to post

Share on other sites

Hkarta 584

Share this post

Link to post

Share on other sites

Create an account or sign in to comment

Create an account

Sign in

Browse

More