Code:
<?php
$getid=safe_query("SELECT * FROM ".PREFIX."cup_matches WHERE cupID");
$ds=mysql_fetch_array($getid); $cupID = $ds['cupID'];
$get1on1=safe_query("SELECT 1on1 FROM ".PREFIX."cups WHERE ID='$cupID'");
$dl=mysql_fetch_array($get1on1);
mysql_query("ALTER TABLE `".PREFIX."cup_matches`
ADD `1on1` INT( 11 ) NOT NULL default '".$dl['1on1']."' AFTER `einspruch`;")
OR die(PREFIX.'cup_matches <font color="red">failed!</font><br> You have already updated to V4.1.4b!<br />');
echo '<center><h2>Successfully updated to V4.1.4b!</h2><br><a href="index.php"><b>View Site</b></a></center>';
?>
Problem: Adding incorrect value for added column at cup_matches table. (Adds 1 for all rows)
Column "ID = 1" at _cups table -> 1on1 = 0 so it should add this column with 0 value if ID = 1 and cupID = 1.
ID = cupID
Take a look at attatchment.
http://img686.imageshack.us/img686/5947/helpw.gif
Thanks if you can help.