<?php
if(defined('master_page')){
if(REG_ACTIVE == true){
?>
<style>
div#Registro{
text-align: center;
}
</style>
<div id="Registro">
<form autocomplete="off" action="" method="post" id="reg_form">
<input maxlength='16' class="text" type="text" name="R_USER" placeholder="Insira Seu Usuario"/></br>
<input maxlength='16' class="text" type="password" name="R_PASS" placeholder="Insira Sua Senha"/></br>
<input maxlength='16' class="text" type="password" name="R_PAS2" placeholder="Repita Sua Senha"/></br>
<input maxlength='16' class="text" type="text"  name="R_NICK" placeholder="Insira Seu Nick"/></br>
<p>Sexo
<select class="text" name="R_SEX">
<option value="False">Feminino</option>
<option value="True">Masculino</option>
</select></p>
<input class="submit" type="submit" name="submit" value="Registrar!"/></br>
</form>
</div>
<?php
if(isset($_POST['submit'])){
echo "<style>#roles { display:none; } </style>";
$R_USER = addslashes($_POST['R_USER']);
$R_PASS = addslashes($_POST['R_PASS']);
$R_RPAS = addslashes($_POST['R_PAS2']);
$R_NICK = addslashes($_POST['R_NICK']);
$R_SEX  = addslashes($_POST['R_SEX']);
$qry = odbc_exec($sqltank_conn,"SELECT Count(*) as UCNT FROM Sys_Users_Detail WHERE UserName = '$R_USER'");
$nqy = odbc_exec($sqltank_conn,"SELECT Count(*) as ECNT FROM Sys_Users_Detail WHERE NickName = '$R_NICK'");
$UASOC = odbc_fetch_array($qry);
$NASOC = odbc_fetch_array($nqy);
if($R_USER == null || $R_PASS == null || $R_NICK == null){
echo "<span id='message' class='error'>Você deixou algo em Branco!</span>";
}
else if($NASOC['ECNT'] != 0){
echo "<span id='message' class='error'>O NickName já está sendo usado!</span>";
}
else if($UASOC['UCNT'] != 0){
echo "<span id='message' class='error'>A Conta já está sendo usada!</span>";
}
else if ((isset($_POST['submit']) == true) and (strlen($R_USER) < 3) || (strlen($R_USER) > 15)) {
echo "<span id='message' class='error'>Seu nome de usuário deve ser entre 3 e 15 caracteres.</span>";
}
else if ((isset($_POST['submit']) == true) and (strlen($R_NICK) < 3) || (strlen($R_NICK) > 20)) {
echo "<span id='message' class='error'>Seu Nickname deve ser entre 3 e 20 caracteres.</span>";
}
else if ((isset($_POST['submit']) == true) and ((strlen($R_PASS) < 3) || (strlen($R_PASS) > 15) || (strlen($R_RPAS) < 3) || (strlen($R_RPAS) > 15))) {
echo "<span id='message' class='error'>A senha deve ter entre 3 e 15 caracteres.</span>";
}

else if ((isset($_POST['submit']) == true) and ($R_PASS != $R_RPAS)) {
echo "<span id='message' class='error'>As senhas devem ser iguais.</span>";
}

else if ((isset($_POST['submit']) == true) and (($R_USER == $R_PASS) || ($R_USER == $R_RPAS))) {
echo "<span id='message' class='error'>Para sua Segurança , o nome de usuário e a senha não podem ser iguais.</span>";
}
else if($UASOC['UCNT'] == 0 || $NASOC['ECNT'] == 0){
if(odbc_exec($sqltank_conn , "INSERT INTO Sys_Users_Detail (UserName, Password, NickName, Sex, IsFirst,State,Repute,Money,Gold,GiftToken,IsAdmin,PVEPermission,IsExist) VALUES('".$R_USER."','".strtoupper(md5($R_PASS))."','".$R_NICK."','".$R_SEX."',31,90,90,'".REGISTER_MONEY."','".REGISTER_GOLD."','".REGISTER_FREEMONEY."',0,'FFFFFFFFFFFFF','False')")){
$query2 = odbc_exec($sqltank_conn , "SELECT * FROM Sys_Users_Detail WHERE UserName = '$R_USER'");
$UserID = odbc_fetch_array($query2);
if(odbc_exec($sqltank_conn , "INSERT INTO Sys_Users_Fight ([UserID],[Attack],[Defence],[Luck],[Agility],[Delay],[Honor],[Map],[Directory],[IsExist]) VALUES('".$UserID['UserID']."',100,48,100,18,1,1,1,1,'True')")){
echo "<span id='message' class='success'>Cadastrado com Sucesso!</span>";
} else echo "<span id='message' class='error'>Erro ao Registrar! Tente Novamente Mais Tarde.</span>"; } else { echo "<span id='message' class='error'>Erro ao Registrar!Caso o Erro continue , contate o administrador com essa mensagem de erro : <textarea readonly>".odbc_errormsg($sqltank_conn)."</textarea>"; }
} else {
echo "<span id='message' class='error'>A Conta ou NickName ou Email já está sendo usada!</span>";
}
}
} else {
?>
<p style="color:red;">Registro Desativado para Manutenção</p>
<?php
}
} else {
header('HTTP/1.0 404 Not Found');
}
?>

#message {
     font-size:13px;
  }
  
  #message.error {
     color:red;
  }
  
  #message.success {
     color:green;
  }

USE Db_Web
INSERT INTO WebSettings(ServerID,ServerName,TitleSeparator,RegisterGold,RegisterFreeMoney,RegisterMoney,PlayersInRanking,DonateText,GameLink,BackgroundID)
VALUES(
4,/* ID do Canal principal */
'Nome do Server', /* Nome do Servidor */
'.::.', /* Separador (ServerName Separador Pagina) */
1500, /* Quantidade de Moedas de Ouro no Registro */
1500, /* Quantidade de Moedas Grátis no Registro */
1500, /* Quantidade de Cupons no Registro  */
15, /* Quantidade de Players no Ranking */
'Texto para Donate', /* Seu texto em html para a página de Donate */
'http://localhost/game/Loading.swf', /* Link do Loading.swf ou Default.aspx (Precisa ter o ?user=&key= para acessar) */
'1' /* ID/Link da Imagem , utilize para trocar o fundo do site */
)
GO
SELECT ID FROM WebSettings /* O Ultimo ID é o Ultimo inserido e o que pode ser usado no CONFIG_ID */

USE Db_Web
INSERT INTO News(NewsAuthor,NewsTitle,NewsText)VALUES(
' ', /* Autor da Postagem */
' ', /* Titlo da Postagem */
' '  /* Texto da Postagem (HTML) */
)

USE Db_Tank
IF NOT EXISTS (SELECT * FROM INFORMATION_SCHEMA.Columns WHERE TABLE_NAME = 'Sys_Users_Detail' AND COLUMN_NAME = 'IsAdmin') ALTER TABLE Sys_Users_Detail ADD IsAdmin int
GO
IF NOT EXISTS (SELECT * FROM sys.databases WHERE name = 'Db_web') CREATE DATABASE Db_Web
GO
USE [Db_Web]
IF EXISTS (SELECT * FROM sys.objects where type = 'U' and name = 'Pages') DROP TABLE Pages
IF EXISTS (SELECT * FROM sys.objects where type = 'U' and name = 'WebSettings') DROP TABLE WebSettings
IF EXISTS (SELECT * FROM sys.objects where type = 'U' and name = 'News') DROP TABLE News
GO

/****** Object:  Table [dbo].[Pages]    Script Date: 08/25/2012 19:11:03 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[Pages](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [Name] [text] NOT NULL,
 [Page] [text] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
USE [Db_Web]
GO

/****** Object:  Table [dbo].[Settings]    Script Date: 08/25/2012 20:12:33 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[WebSettings](
 [ID] [int] NOT NULL IDENTITY(0,1),
 [ServerID] [int] NOT NULL,
 [ServerName] [text] NOT NULL,
 [TitleSeparator] [text] NOT NULL,
 [RegisterGold] [int] NOT NULL,
 [RegisterMoney] [int] NOT NULL,
 [RegisterFreeMoney] [int] NOT NULL,
 [PlayersInRanking] [int] NOT NULL,
 [DonateText] [text] NOT NULL,
 [GameLink] [text] NOT NULL,
 [BackgroundID] [text] NOT NULL,
 [ForumLink] [text] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
/****** Object:  Table [dbo].[News]    Script Date: 08/25/2012 21:07:51 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[News](
 [ID] [int] IDENTITY(1,1) NOT NULL,
 [NewsTitle] [text] NOT NULL,
 [NewsText] [text] NOT NULL,
 [NewsAuthor] [text] NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO
INSERT INTO Pages(Name,Page) VALUES ('Registro','!Registro'),('Donate','!Donate'),('Ranking','!Ranking')