Скрипт за записване на турнир

Factor · 22 Август 2010

Здравейте,загавието говори до 50% за какво става въпрос...
Само да допълня ,искам сцрипта да представлява нещо като регистрация.
Примерно

Име на отбора:
Играч#1:
Играч#2:
Играч#3:
Играч#4:
Играч#5:
SteamID Player #1:

SteamID Player #2:

SteamID Player #3:

SteamID Player #4:

SteamID Player #5:

Прочети правилата на турнира

и отодоло един бутон Запиши отбора
Ако има желаещи да ми помогнат нека го направят,а тези който смятат че чакам на готово бъркат .. вече сигорно 3 седмици търся такъф скрипт ,направих и няколко жалки опита да напиша следният скрипт :?:

sadd · 22 Август 2010

Дай да видим какво си направил и да ти помогнем да го оправиш

Factor · 22 Август 2010

sadd каза:
Дай да видим какво си направил и да ти помогнем да го оправиш

Не го пазя но си спомням че ползвах урок за регисрация от тука и се опитах да я модна ... но не се получи

nom3r1 · 22 Август 2010

sql.sql

Код:

CREATE TABLE `cs_teams` (
  `id` int(11) NOT NULL auto_increment,
  `team_name` varchar(255) NOT NULL default '',
  `player1` varchar(255) NOT NULL default '',
  `player2` varchar(255) NOT NULL default '',
  `player3` varchar(255) NOT NULL default '',
  `player4` varchar(255) NOT NULL default '',
  `player5` varchar(255) NOT NULL default '',
  `steam_player1` varchar(255) NOT NULL default '',
  `steam_player2` varchar(255) NOT NULL default '',
  `steam_player3` varchar(255) NOT NULL default '',
  `steam_player4` varchar(255) NOT NULL default '',
  `steam_player5` varchar(255) NOT NULL default '',
  `odobren` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM ;

Код:

<?php
$dbhost = "localhost";
$dbusername= "";
$dbpassword = "";
$dbname = "";
$connect = mysql_connect($dbhost, $dbusername, $dbpassword);
$db = mysql_select_db($dbname,$connect) or die ("Could not select database");
$chars="SET CHARACTER SET cp1251";
mysql_query($chars);
?>

add_otbor.php

Код:

<?php
include ("config.php");
?>
<form method="post" action=""><br />
<table align="center" width="90%" cellpadding="1" cellspacing="1" id="textove">
	<tr> 
		<td align="left"><p class="margin">Име на отбора: </p></td>
		<td align="left"><input name="team_name" type="text" id="team_name" size="15" /></td> 
	</tr>
	<tr> 
		<td align="left"><p class="margin">Играч #1: </p></td>
		<td align="left"><input name="player1" type="text" id="player1" size="15" /></td> 
	</tr>
	<tr> 
		<td align="left"><p class="margin">Играч #2: </p></td>
		<td align="left"><input name="player2" type="text" id="player2" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">Играч #3: </p></td>
		<td align="left"><input name="player3" type="text" id="player3" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">Играч #4: </p></td>
		<td align="left"><input name="player4" type="text" id="player4" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">Играч #5: </p></td>
		<td align="left"><input name="player5" type="text" id="player5" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">SteamID Player #1: </p></td>
		<td align="left"><input name="steam_player1" type="text" id="steam_player1" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">SteamID Player #2: </p></td>
		<td align="left"><input name="steam_player2" type="text" id="steam_player2" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">SteamID Player #3: </p></td>
		<td align="left"><input name="steam_player3" type="text" id="steam_player3" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">SteamID Player #4: </p></td>
		<td align="left"><input name="steam_player4" type="text" id="steam_player4" size="15" /></td> 
	</tr>
		<tr> 
		<td align="left"><p class="margin">SteamID Player #5: </p></td>
		<td align="left"><input name="steam_player5" type="text" id="steam_player5" size="15" /></td> 
	</tr>
		<tr>
		<td align="center"><a href="rules.php">Прочети правилата на турнира</a></td>
	</tr>
<tr> 
	<td colspan="3" align="center">
	<input name="submit" type="submit" id="button" value="Добави!"/> 
	<input name="reset" type="reset" id="button" value="Изчисти"></td> 
</tr> 
</table>
</form>
<?php
if(isset($_POST['submit'])){
		$team_name = htmlspecialchars($_POST['team_name']); //име на отбора
		$player1 = htmlspecialchars($_POST['player1']); //играч 1
		$player2 = htmlspecialchars($_POST['player2']); //играч 2
		$player3 = htmlspecialchars($_POST['player3']); //играч 3
		$player4 = htmlspecialchars($_POST['player4']); //играч 4
		$player5 = htmlspecialchars($_POST['player5']); //играч 5
		$steam_player1 = htmlspecialchars($_POST['steam_player1']); //steam играч 1
		$steam_player2 = htmlspecialchars($_POST['steam_player2']); //steam играч 2
		$steam_player3 = htmlspecialchars($_POST['steam_player3']); //steam играч 3
		$steam_player4 = htmlspecialchars($_POST['steam_player4']); //steam играч 4
		$steam_player5 = htmlspecialchars($_POST['steam_player5']); //steam играч 5
		$odoboren = "0";
		$sql = mysql_query("INSERT INTO `cs_teams` (`id`,`team_name`, `player1`, `player2`, `player3`, `player4`, `player5`, `steam_player1`, `steam_player2`, `steam_player3`, `steam_player4`, `steam_player5`, `odobren`) VALUES (NULL, '$team_name', '$player1', '$player2', '$player3', '$player4', '$player5', '$steam_player1', '$steam_player2', '$steam_player3', '$steam_player4', '$steam_player5', '$odobren');") or die(mysql_error(); 
	if($sql == true){ 
		echo '<meta http-equiv="refresh" content="1;url=index.php">';
		echo "Отбора е успешно регистриран!<br />Трябва да изчакате администратора на сайта да одобри вашият отбор!"; 
	}
	else {
		echo "Отбора не е добавен!";
	}}}
?>

Factor · 22 Август 2010

Така като гледам ще получиш точка :wink:

embaka · 22 Август 2010

nom3r1 каза:

sql.sql

Код:

CREATE TABLE `cs_teams` (
  `id` int(11) NOT NULL auto_increment,
  `team_name` varchar(255) NOT NULL default '',
  `player1` varchar(255) NOT NULL default '',
  `player2` varchar(255) NOT NULL default '',
  `player3` varchar(255) NOT NULL default '',
  `player4` varchar(255) NOT NULL default '',
  `player5` varchar(255) NOT NULL default '',
  `steam_player1` varchar(255) NOT NULL default '',
  `steam_player2` varchar(255) NOT NULL default '',
  `steam_player3` varchar(255) NOT NULL default '',
  `steam_player4` varchar(255) NOT NULL default '',
  `steam_player5` varchar(255) NOT NULL default '',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM ;

защо ползваш????

Код:

  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)

в случая имаш auto_increment и ползваш уникален ключ, който е излишен

nom3r1 · 22 Август 2010

@embaka, от както се помня така го правя и не ми прави никакви проблеми?

@Factor, промених малко кода, за да правиш одобрение на отборите! След, малко ще добавя и кодовете за одобрение в админ панел.

Factor · 22 Август 2010

Мерси обаче защо ми дава тази грешка ?

Parse error: parse error in add_otbor.php on line 74

nom3r1 · 23 Август 2010

Така?

sql.sql

Код:

CREATE TABLE `cs_teams` (
  `id` int(11) NOT NULL auto_increment,
  `team_name` varchar(255) NOT NULL,
  `player1` varchar(255) NOT NULL,
  `player2` varchar(255) NOT NULL,
  `player3` varchar(255) NOT NULL,
  `player4` varchar(255) NOT NULL,
  `player5` varchar(255) NOT NULL,
  `steam_player1` varchar(255) NOT NULL,
  `steam_player2` varchar(255) NOT NULL,
  `steam_player3` varchar(255) NOT NULL,
  `steam_player4` varchar(255) NOT NULL,
  `steam_player5` varchar(255) NOT NULL,
  `odobren` varchar(255) NOT NULL default '0',
  PRIMARY KEY  (`id`),
  UNIQUE KEY `id` (`id`)
) ENGINE=MyISAM ;

config.php

Код:

<?php
$dbhost = "localhost";
$dbusername= "";
$dbpassword = "";
$dbname = "";
$connect = mysql_connect($dbhost, $dbusername, $dbpassword);
$db = mysql_select_db($dbname,$connect) or die ("Could not select database");
$chars="SET CHARACTER SET cp1251";
mysql_query($chars);
?>

index.php

Код:

<?php
include ("config.php");
$query = mysql_query("SELECT * FROM `cs_teams` WHERE odobren='1' ORDER BY id DESC")or die(mysql_error()."<br />Грешка: ".__LINE__);
while($row = mysql_fetch_array($query)){
$team_name = $row['team_name'];
$player1 = $row['player1'];
$player2 = $row['player2'];
$player3 = $row['player3'];
$player4 = $row['player4'];
$player5 = $row['player5'];
$steam_player1 = $row['steam_player1'];
$steam_player2 = $row['steam_player2'];
$steam_player3 = $row['steam_player3'];
$steam_player4 = $row['steam_player4'];
$steam_player5 = $row['steam_player5'];
echo "<table align='center'>
	<tr>
		<td align="center"><b>$team_name</b></td>
	</tr>
	<tr>
		<td>$player1</td>
		<td>$steam_player1</td>
	</tr>
	<tr>
		<td>$player2</td>
		<td>$steam_player2</td>
	</tr>
	<tr>
		<td>$player3</td>
		<td>$steam_player3</td>
	</tr>
	<tr>
		<td>$player4</td>
		<td>$steam_player4</td>
	</tr>
	<tr>
		<td>$player5</td>
		<td>$steam_player5</td>
	</tr>
	</table>";
}
?>

add_otbor.php

Код:

<?php
include ("config.php");
?>
<form method="post" action=""><br />
<table align="center" width="90%" cellpadding="1" cellspacing="1" id="textove">
   <tr>
      <td align=\"left\"><p class=\"margin\">Име на отбора: </p></td>
      <td align=\"left\"><input name="team_name" type="text" id="team_name" size=\"15\" /></td>
   </tr>
   <tr>
      <td align=\"left\"><p class=\"margin\">Играч #1: </p></td>
      <td align=\"left\"><input name="player1" type="text" id="player1" size=\"15\" /></td>
   </tr>
   <tr>
      <td align=\"left\"><p class=\"margin\">Играч #2: </p></td>
      <td align=\"left\"><input name="player2" type="text" id="player2" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">Играч #3: </p></td>
      <td align=\"left\"><input name="player3" type="text" id="player3" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">Играч #4: </p></td>
      <td align=\"left\"><input name="player4" type="text" id="player4" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">Играч #5: </p></td>
      <td align=\"left\"><input name="player5" type="text" id="player5" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #1: </p></td>
      <td align=\"left\"><input name="steam_player1" type="text" id="steam_player1" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #2: </p></td>
      <td align=\"left\"><input name="steam_player2" type="text" id="steam_player2" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #3: </p></td>
      <td align=\"left\"><input name="steam_player3" type="text" id="steam_player3" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #4: </p></td>
      <td align=\"left\"><input name="steam_player4" type="text" id="steam_player4" size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #5: </p></td>
      <td align=\"left\"><input name="steam_player5" type="text" id="steam_player5" size=\"15\" /></td>
   </tr>
      <tr>
      <td align="center"><a href="rules.php">Прочети правилата на турнира</a></td>
   </tr>
<tr>
   <td colspan="3" align="center">
   <input name="submit" type="submit" id="button" value="Добави!"/> 
   <input name="reset" type="reset" id="button" value="Изчисти"></td>
</tr>
</table>
</form>
<?php
if(isset($_POST['submit'])){
      $team_name = htmlspecialchars($_POST['team_name']); //име на отбора
      $player1 = htmlspecialchars($_POST['player1']); //играч 1
      $player2 = htmlspecialchars($_POST['player2']); //играч 2
      $player3 = htmlspecialchars($_POST['player3']); //играч 3
      $player4 = htmlspecialchars($_POST['player4']); //играч 4
      $player5 = htmlspecialchars($_POST['player5']); //играч 5
      $steam_player1 = htmlspecialchars($_POST['steam_player1']); //steam играч 1
      $steam_player2 = htmlspecialchars($_POST['steam_player2']); //steam играч 2
      $steam_player3 = htmlspecialchars($_POST['steam_player3']); //steam играч 3
      $steam_player4 = htmlspecialchars($_POST['steam_player4']); //steam играч 4
      $steam_player5 = htmlspecialchars($_POST['steam_player5']); //steam играч 5
      $odoboren = "0";//одобрен не
      $sql = mysql_query("INSERT INTO `cs_teams` (`id`,`team_name`, `player1`, `player2`, `player3`, `player4`, `player5`, `steam_player1`, `steam_player2`, `steam_player3`, `steam_player4`, `steam_player5`, `odobren`) VALUES (NULL, '$team_name', '$player1', '$player2', '$player3', '$player4', '$player5', '$steam_player1', '$steam_player2', '$steam_player3', '$steam_player4', '$steam_player5', '$odobren')") or die(mysql_error());
   if($sql == true){
      echo '<meta http-equiv="refresh" content="1;url=index.php">';
      echo "Отбора е успешно регистриран!<br />Моля почакайте!";
   }
   else {
      echo "Отбора не е добавен!";
   }}
?>

admin/index.php

Код:

 <?php
include ("../config.php");
$query = mysql_query("SELECT * FROM `cs_teams` WHERE odobren='0' ORDER BY id DESC")or die(mysql_error()."<br />Грешка: ".__LINE__);
while($row = mysql_fetch_array($query)){
$id = $row['id'];
$team_name = $row['team_name'];
$player1 = $row['player1'];
$player2 = $row['player2'];
$player3 = $row['player3'];
$player4 = $row['player4'];
$player5 = $row['player5'];
$steam_player1 = $row['steam_player1'];
$steam_player2 = $row['steam_player2'];
$steam_player3 = $row['steam_player3'];
$steam_player4 = $row['steam_player4'];
$steam_player5 = $row['steam_player5'];
echo "<table align='center'>
	<tr>
		<td align="center"><b>$team_name</b></td>
	</tr>
	<tr>
		<td>$player1</td>
		<td>$steam_player1</td>
	</tr>
	<tr>
		<td>$player2</td>
		<td>$steam_player2</td>
	</tr>
	<tr>
		<td>$player3</td>
		<td>$steam_player3</td>
	</tr>
	<tr>
		<td>$player4</td>
		<td>$steam_player4</td>
	</tr>
	<tr>
		<td>$player5</td>
		<td>$steam_player5</td>
	</tr>
	<tr>
		<td><a href='edit.php?id=$id'>Промени</a></td>
	</tr>
	</table>";
}
?>

admin/edit.php

Код:

<?php
include ("../config.php");
function secure($var) {
return addslashes(htmlspecialchars($var));
}
$id = secure($_GET['id']);
if (isset($id) and !empty($id)){
$query = mysql_query("SELECT * from `cs_teams` WHERE id = '$id'")or die(mysql_error()."<br />Грешка: ".__LINE__);
$row = mysql_fetch_array($query);
$team_name = $row['team_name'];
$player1 = $row['player1'];
$player2 = $row['player2'];
$player3 = $row['player3'];
$player4 = $row['player4'];
$player5 = $row['player5'];
$steam_player1 = $row['steam_player1'];
$steam_player2 = $row['steam_player2'];
$steam_player3 = $row['steam_player3'];
$steam_player4 = $row['steam_player4'];
$steam_player5 = $row['steam_player5'];
$odobren = $row['odobren'];
echo "<form method=\"POST\"><center>
<table align=\"center\" width=\"90%\" cellpadding=\"1\" cellspacing=\"1\" id=\"textove\">
   <tr>
      <td align=\"left\"><p class=\"margin\">Име на отбора: </p></td>
      <td align=\"left\"><input name=\"team_name\" type=\"text\" id=\"team_name\" value='$team_name' size=\"15\" /></td>
   </tr>
   <tr>
      <td align=\"left\"><p class=\"margin\">Играч #1: </p></td>
      <td align=\"left\"><input name=\"player1\" type=\"text\" id=\"player1\" value='$player1' size=\"15\" /></td>
   </tr>
   <tr>
      <td align=\"left\"><p class=\"margin\">Играч #2: </p></td>
      <td align=\"left\"><input name=\"player2\" type=\"text\" id=\"player2\" value='$player2' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">Играч #3: </p></td>
      <td align=\"left\"><input name=\"player3\" type=\"text\" id=\"player3" value='$player3' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">Играч #4: </p></td>
      <td align=\"left\"><input name=\"player4\" type=\"text\" id=\"player4\" value='$player4' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">Играч #5: </p></td>
      <td align=\"left\"><input name=\"player5\" type=\"text\" id=\"player5\" value='$player5' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #1: </p></td>
      <td align=\"left\"><input name=\"steam_player1\" type=\"text\" id=\"steam_player1\" value='$steam_player1' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #2: </p></td>
      <td align=\"left\"><input name=\"steam_player2" type=\"text\" id=\"steam_player2\" value='$steam_player2' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #3: </p></td>
      <td align=\"left\"><input name=\"steam_player3" type=\"text\" id=\"steam_player3\" value='$steam_player3' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #4: </p></td>
      <td align=\"left\"><input name=\"steam_player4\" type=\"text\" id=\"steam_player4\" value='$steam_player4' size=\"15\" /></td>
   </tr>
      <tr>
      <td align=\"left\"><p class=\"margin\">SteamID Player #5: </p></td>
      <td align=\"left\"><input name=\"steam_player5\" type=\"text\" id=\"steam_player5\" value='$steam_player5' size=\"15\" /></td>
   </tr>
      <tr>
         <td>Одобри:</td>
         <td><select name='odobren' style='width: 175px'>
            <option value='1'>да</option>
            <option value='0'>не</option>
         </select></td>
   </tr>
</table>
<br />
<input type='submit' name='submit' value='Готово!'>
</center>
</form>";
$ok = secure($_POST['submit']);
$odobren = secure($_POST['odobren']);
if (isset($ok)){
      $team_name = htmlspecialchars($_POST['team_name']); //име на отбора
      $player1 = htmlspecialchars($_POST['player1']); //играч 1
      $player2 = htmlspecialchars($_POST['player2']); //играч 2
      $player3 = htmlspecialchars($_POST['player3']); //играч 3
      $player4 = htmlspecialchars($_POST['player4']); //играч 4
      $player5 = htmlspecialchars($_POST['player5']); //играч 5
      $steam_player1 = htmlspecialchars($_POST['steam_player1']); //steam играч 1
      $steam_player2 = htmlspecialchars($_POST['steam_player2']); //steam играч 2
      $steam_player3 = htmlspecialchars($_POST['steam_player3']); //steam играч 3
      $steam_player4 = htmlspecialchars($_POST['steam_player4']); //steam играч 4
      $steam_player5 = htmlspecialchars($_POST['steam_player5']); //steam играч 5
      $odobren = trim(strip_tags(addslashes($_POST['odobren']))); //одобрен да/не
$update = mysql_query("UPDATE `cs_teams` SET team_name='$team_name', player1='$player1', player2='$player2', player3='$player3', player4='$player4', player5='$player5', steam_player1='$steam_player1', steam_player2='$steam_player2', steam_player3='$steam_player3', steam_player4='$steam_player4', steam_player5='$steam_player5', odobren='$odobren'  WHERE id = '$id'")or die(mysql_error()."<br />Грешка: ".__LINE__);
echo "Успешно одобри отбора!";
}}
else {
   echo 'грешка в кода..';
}
?>

nepoznatia · 23 Август 2010

@nom3r1 В add_otbor.php ред 81 трябва да се махне едната } . Иначе скрипта върши работа :?: .

Factor · 5 Септември 2010

Съзалявам за късния си отговор , просто нямаш време да пиша

Мерси!

Скрипт за записване на турнир

Factor

Registered

sadd

Registered

Factor

Registered

nom3r1

Registered

Factor

Registered

embaka

Registered

nom3r1

Registered

Factor

Registered

nom3r1

Registered

nepoznatia

Registered

Factor

Registered