<?php
-/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013 Arun Persaud <arun@nubati.net>
+/* Copyright 2006, 2007, 2008, 2009, 2010, 2011, 2012, 2013, 2014, 2016 Arun Persaud <arun@nubati.net>
*
* This file is part of e-DoKo.
*
if($party1 != $party2)
DB_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'$party1',$uid1,$uid2,'fox')");
+ " VALUES(NULL,CURRENT_TIMESTAMP,$gameid,'$party1',$uid1,$uid2,'fox')");
}
}
$party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1);
DB_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'$party1',$uid1,NULL,'karlchen')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'$party1',$uid1,NULL,'karlchen')");
};
};
}; /* end scoring Karlchen */
$party1 = DB_get_party_by_gameid_and_userid($gameid,$uid1);
DB_query("INSERT INTO Score".
- " VALUES( NULL,NULL,$gameid,'$party1',$uid1,NULL,'doko')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'$party1',$uid1,NULL,'doko')");
}
/*
for( $p=$call_contra;$p<=120; $p+=30 )
{
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'against$p')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'against$p')");
}
for( $p=$call_contra; $p<120; $p+=30)
{
if( $re >= $p )
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'made$p')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'made$p')");
}
}
if($winning_party!='re' and $call_re!= -1)
for( $p=$call_re;$p<=120; $p+=30 )
{
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'against$p')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'against$p')");
}
for( $p=$call_re; $p<120; $p+=30)
{
if( $contra>=$p )
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'made$p')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'made$p')");
}
}
if($winning_party=='contra')
{
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'againstqueens')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'againstqueens')");
}
/* one point each for winning and each 30 points + calls */
if($re>$p-$offset)
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'".(240-$p)."')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'".(240-$p)."')");
}
/* re called something and won */
foreach(array(0,30,60,90,120) as $p)
{
if($call_re!= -1 && $call_re<$p+1)
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'re',NULL,NULL,'call$p')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'re',NULL,NULL,'call$p')");
}
}
else if( $winning_party=='contra')
if($contra>$p-$offset)
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'".(240-$p)."')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'".(240-$p)."')");
}
/* re called something and won */
foreach(array(0,30,60,90,120) as $p)
{
if($call_contra != -1 && $call_contra<$p+1)
DB_query('INSERT INTO Score'.
- " VALUES( NULL,NULL,$gameid,'contra',NULL,NULL,'call$p')");
+ " VALUES( NULL,CURRENT_TIMESTAMP,$gameid,'contra',NULL,NULL,'call$p')");
}
};