#
#-----[ Zapytania SQL ]------------------------------------------
#

UPDATE phpbb_config SET config_value='2.7' WHERE config_name='version_diam';

#
#-----[ Znajdź ]------------------------------------------
#

if($wyroznij_post_id)
{
$sql = "SELECT post_wyroznij FROM phpbb_posts WHERE post_id = '". $wyroznij_post_id ."'";
if ( !($result = $db->sql_query($sql)) ){ message_die(GENERAL_ERROR, "Error while querying database", '', __LINE__, __FILE__, $sql); }
$row = mysql_fetch_assoc($result);
if($row["post_wyroznij"] == "no") {
$ile_koszt = 1;
$ile = $userdata['user_diamenty'] - $ile_koszt;
$sql = "UPDATE phpbb_users SET user_diamenty='" . $ile . "' WHERE user_id='" . $userdata['user_id'] . "'";
if ( !($result = $db->sql_query($sql)) ){ message_die(GENERAL_ERROR, "Error while querying database", '', __LINE__, __FILE__, $sql); }
}
}
if($wyroznij_post_id)
{
$sql = "UPDATE phpbb_posts SET post_wyroznij='yes' WHERE post_id = $wyroznij_post_id";
if ( !$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error while querying database', '', __LINE__, __FILE__, $sql);
}
}


#
#-----[ Zamień na ]------------------------------------------
#

if($userdata['wyroznieniepostu'] == "1")
{
if($wyroznij_post_id)
{
$result = mysql_query("SELECT post_wyroznij FROM phpbb_posts WHERE post_id = '". $wyroznij_post_id ."'");
$row = mysql_fetch_assoc($result);
if($row["post_wyroznij"] == "no")
{
$ile_koszt = 1;
$ile = $userdata['user_diamenty'] - $ile_koszt;
mysql_query("UPDATE phpbb_users SET user_diamenty='" . $ile . "' WHERE user_id='" . $userdata['user_id'] . "'");
}
}
if($wyroznij_post_id)
{
$sql = "UPDATE phpbb_posts SET post_wyroznij='yes' WHERE post_id = $wyroznij_post_id";
if ( !$db->sql_query($sql))
{
message_die(GENERAL_ERROR, 'Error', '', __LINE__, __FILE__, $sql);
}
}
}

#
#-----[ KONIEC ]------------------------------------------
#