Conversion Please

[Money88]

Below is php code defining the varibles for the next part of code

//configure the tables in the database
$playerstable = "webl_players"; //the name of the table that contains information about the players
$gamestable = "webl_games"; //the name of the table that stores the played games
$newstable = "webl_news"; // the name of the table that stores the news
$varstable = "webl_vars"; //the name of the table that stores various information
$admintable = "webl_admin"; //name of the table that stores the admin login information
$pagestable = "webl_pages"; //name of the table that stores additional pages

Below Is an install script that seems to not work so I was wondering if anyone could convert that script below into a .sql file so i can import it or run with the code through phpmyadmin

<?php
if ($submit) {
?>
Creating tables...<br><br>
<?php
include "variables.php";
$db = mysql_connect($databaseserver, $databaseuser, $databasepass);
mysql_select_db($databasename,$db);
if ($db==false) die("Failed to connect to MySQL server<br>\n");

$sql = "CREATE TABLE $playerstable (player_id int(10) DEFAULT '0' NOT NULL auto_increment, name varchar(20) DEFAULT '' NOT NULL, passworddb varchar(10), approved varchar(10) DEFAULT 'no', mail varchar(50), icq varchar(15), aim varchar(40), msn varchar (100), country varchar(40), rating int(10) DEFAULT '1500', games int(10) DEFAULT '0', wins int(10) DEFAULT '0', losses int(10) DEFAULT '0', points int(10) DEFAULT '0', totalwins int(10) DEFAULT '0', totallosses int(10) DEFAULT '0', totalpoints int(10) DEFAULT '0', totalgames int(10) DEFAULT '0', rank int(10) DEFAULT '0', streakwins int(10) DEFAULT '0', streaklosses int(10) DEFAULT '0', ip varchar(100), PRIMARY KEY (player_id))";
mysql_query($sql,$db);
$sql = "ALTER TABLE $playerstable ADD UNIQUE(name) ";
mysql_query($sql,$db);
echo"Players table<br>";

$sql = "CREATE TABLE $gamestable (game_id int(10) DEFAULT '0' NOT NULL auto_increment, winner varchar(40), loser varchar(40), date varchar(40), recorded varchar(10), PRIMARY KEY (game_id))";
mysql_query($sql,$db);
echo"Games table<br>";

$sql = "CREATE TABLE $admintable (id int(10) DEFAULT '0' NOT NULL auto_increment, name varchar(40), password varchar(40), PRIMARY KEY (id))";
mysql_query($sql,$db);
echo"Admin table<br>";

$sql = "CREATE TABLE $newstable (news_id int(10) DEFAULT '0' NOT NULL auto_increment, title varchar (100), date varchar (100), news text, PRIMARY KEY (news_id))";
mysql_query($sql,$db);
echo"News table<br>";

$sql = "CREATE TABLE $pagestable (page_id int(10) DEFAULT '0' NOT NULL auto_increment, title varchar (100), page text, PRIMARY KEY (page_id))";
mysql_query($sql,$db);
echo"Pages table<br>";

$sql = "CREATE TABLE $varstable (vars_id int(10) DEFAULT '0' NOT NULL auto_increment, color1 varchar(20), color2 varchar (20), color3 varchar (20), color4 varchar (20), color5 varchar (20), color6 varchar(20), color7 varchar(20), font varchar(80), fontweight varchar(40), fontsize varchar(20), numgamespage int(10), numplayerspage int(10), statsnum int(10), standingsnogames varchar(10), hotcoldnum varchar(10), gamesmaxdayplayer int(10), gamesmaxday int(10), approve varchar(10), approvegames varchar(10), system varchar (20), pointswin int(10), pointsloss int(10), report varchar (20), leaguename varchar (100), titlebar varchar (100), newsitems int(10), copyright varchar(200), PRIMARY KEY (vars_id))";
mysql_query($sql,$db);
echo"Vars table<br><br>";

$date = date("M d, Y.");
echo"Inserting default values<br>";
$sql = "INSERT INTO $newstable (news, title, date) VALUES ('Congratulations, you have successfully installed WebLeague.<br><br>[Be happy here.]<br><br>Enjoy. :)', 'Glory!', '$date')";
mysql_query($sql,$db);
echo"Inserting news<br>";

$sql = "INSERT INTO $varstable (color1, color2, color3, color4, color5, color6, color7, font, fontweight, fontsize, numgamespage, numplayerspage, statsnum, hotcoldnum, gamesmaxdayplayer, gamesmaxday, approve, approvegames, system, pointswin, pointsloss, report, leaguename, titlebar, newsitems, copyright) VALUES ('#000000', '#FFFFFF', '#66CC66', '#339933', '#EEEEEE', '#000000', '#FFFFFF', 'Tahoma', 'normal', '12', '20', '30', '10', '5', '2', '10', 'no', 'no', 'elorating', '2', '-1', 'winner', 'Web<i>League</i>', 'WebLeague', '3', 'powered by: <a href=\"http://www.worms-league.com/WebLeague\">WebLeague</a>')";
mysql_query($sql,$db);
echo"Inserting vars<br><br>";

$sql = "INSERT INTO $admintable (name, password) VALUES ('$name','$password')";
$result = mysql_query($sql);
echo"Creating admin account.<br><br>";
echo"Done.";
} else{
?>
<form method="post" action="<?php echo $PHP_SELF?>">
<p align="center"><b>WebLeague installation.</b><br><br>
Create an admin account:
<div align="center">
<center>
<table border="0" cellpadding="0">
<tr>
<td>Nickname:</td>
<td><input type="Text" name="name"></td>
</tr>
<tr>
<td>Password:</td>
<td><input type="password" name="password"></td>
</tr>
</table>
</center>
</div>
<p align="center">
<input type="Submit" name="submit" value="Submit.">
</form>
<?php
}
?>

Thank you all.

[StupidRalph]

This is something that you can do yourself using Find and Replace with your favorite text editor (outside of Notepad). You just have to substitute in the static value for the variables. Since you're using PHPMyAdmin you don't have to worry about connecting to the database. You only need to deal with the $sql variables. Extract every line that begins with $sql = "the SQL statement here" and paste them in a new form. You only need the part inside the quotation marks.

So:

$sql = "CREATE TABLE $playerstable (player_id int(10) DEFAULT '0' NOT NULL auto_increment, name varchar(20) DEFAULT '' NOT NULL, passworddb varchar(10), approved varchar(10) DEFAULT 'no', mail varchar(50), icq varchar(15), aim varchar(40), msn varchar (100), country varchar(40), rating int(10) DEFAULT '1500', games int(10) DEFAULT '0', wins int(10) DEFAULT '0', losses int(10) DEFAULT '0', points int(10) DEFAULT '0', totalwins int(10) DEFAULT '0', totallosses int(10) DEFAULT '0', totalpoints int(10) DEFAULT '0', totalgames int(10) DEFAULT '0', rank int(10) DEFAULT '0', streakwins int(10) DEFAULT '0', streaklosses int(10) DEFAULT '0', ip varchar(100), PRIMARY KEY (player_id))";


Would become:
CREATE TABLE webl_players (player_id int(10) DEFAULT '0' NOT NULL auto_increment, name varchar(20) DEFAULT '' NOT NULL, passworddb varchar(10), approved varchar(10) DEFAULT 'no', mail varchar(50), icq varchar(15), aim varchar(40), msn varchar (100), country varchar(40), rating int(10) DEFAULT '1500', games int(10) DEFAULT '0', wins int(10) DEFAULT '0', losses int(10) DEFAULT '0', points int(10) DEFAULT '0', totalwins int(10) DEFAULT '0', totallosses int(10) DEFAULT '0', totalpoints int(10) DEFAULT '0', totalgames int(10) DEFAULT '0', rank int(10) DEFAULT '0', streakwins int(10) DEFAULT '0', streaklosses int(10) DEFAULT '0', ip varchar(100), PRIMARY KEY (player_id));

[Money88]

hmm well I tried that before posting and I got this error which I have no idea why its coming up because i am not familiar with sql scripts.

Error
SQL query:

CREATE TABLE webl_players(

player_id int( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
name varchar( 20 ) DEFAULT '' NOT NULL ,
passworddb varchar( 10 ) ,
approved varchar( 10 ) DEFAULT 'no',
mail varchar( 50 ) ,
icq varchar( 15 ) ,
aim varchar( 40 ) ,
msn varchar( 100 ) ,
country varchar( 40 ) ,
rating int( 10 ) DEFAULT '1500',
games int( 10 ) DEFAULT '0',
wins int( 10 ) DEFAULT '0',
losses int( 10 ) DEFAULT '0',
points int( 10 ) DEFAULT '0',
totalwins int( 10 ) DEFAULT '0',
totallosses int( 10 ) DEFAULT '0',
totalpoints int( 10 ) DEFAULT '0',
totalgames int( 10 ) DEFAULT '0',
rank int( 10 ) DEFAULT '0',
streakwins int( 10 ) DEFAULT '0',
streaklosses int( 10 ) DEFAULT '0',
ip varchar( 100 ) ,
PRIMARY KEY ( player_id )
)

MySQL said:

#1067 - Invalid default value for 'player_id'



after editing the above with taking out auto_increment it seemed to work. does auto increment do anything though?

[StupidRalph]

Yes, you'll need autoincrement. It is very important actually to be able to establish a unique identifier for the row (primary key). You can change this to autoincrement in PHPMyAdmin. You do not need a default value b/c the value is automatically generated by mysql.

[StupidRalph]

hmm well I tried that before posting and I got this error which I have no idea why its coming up because i am not familiar with sql scripts.

Error
SQL query:

CREATE TABLE webl_players(

player_id int( 10 ) DEFAULT '0' NOT NULL AUTO_INCREMENT ,
name varchar( 20 ) DEFAULT '' NOT NULL ,
passworddb varchar( 10 ) ,
approved varchar( 10 ) DEFAULT 'no',
mail varchar( 50 ) ,
icq varchar( 15 ) ,
aim varchar( 40 ) ,
msn varchar( 100 ) ,
country varchar( 40 ) ,
rating int( 10 ) DEFAULT '1500',
games int( 10 ) DEFAULT '0',
wins int( 10 ) DEFAULT '0',
losses int( 10 ) DEFAULT '0',
points int( 10 ) DEFAULT '0',
totalwins int( 10 ) DEFAULT '0',
totallosses int( 10 ) DEFAULT '0',
totalpoints int( 10 ) DEFAULT '0',
totalgames int( 10 ) DEFAULT '0',
rank int( 10 ) DEFAULT '0',
streakwins int( 10 ) DEFAULT '0',
streaklosses int( 10 ) DEFAULT '0',
ip varchar( 100 ) ,
PRIMARY KEY ( player_id )
)

MySQL said:

#1067 - Invalid default value for 'player_id'



after editing the above with taking out auto_increment it seemed to work. does auto increment do anything though?

I might want to add that you might actually want to drop (delete) that table and build it over if you haven't already added data to it. If you have to PHPMyAdmin and select the database.

Then under the action column there will be an icon you can click for "Structure". On my installation it is 2nd from the left.

Then under the Action column click the pencil.

Delete the "0" under default value.

Under the Extras Drop town menu select Auto-Increment.

Good luck.