Fairy pieces in PHP

‘;

$menu .= ‘ – ‘;
$menu .= ‘ALL pieces‘;
while ($result = mysql_fetch_array($queried)) {
$menu .= ‘‘ . $result[‘FairyPieceName’] . ‘‘;
}
$menu .= ‘ ‘;
return $menu;
}

function print_dropdown_conditions($query, $link){
$queried = mysql_query($query, $link);
$menu = ‘‘;

$menu .= ‘

– ‘;
$menu .= ‘ALL conditions‘;
while ($result = mysql_fetch_array($queried)) {
$menu .= ‘‘ . $result[‘FairyConditionName’] . ‘‘;
}
$menu .= ‘ ‘;
return $menu;
}

function selected_list_pieces($query, $link, $lang, $ext) {

$queried = mysql_query($query, $link);

while($row = mysql_fetch_array($queried))
{

echo “

“;
echo “

“;
echo $row[‘FairyPieceName’];
echo “ “;
if ($lang==1) {
echo $row[‘FairyPieceDef_RU’];
} else {
echo $row[‘FairyPieceDef_EN’];
}
if ($ext==1) {
echo “

“;
echo $row[‘Popeye’];
}

echo “

“;
}

}

function selected_list_conditions($query, $link, $lang) {

$queried = mysql_query($query, $link);

while($row = mysql_fetch_array($queried))
{

echo “

“;
echo “

“;
echo $row[‘FairyConditionName’];
echo “ “;

if ($lang==1) {
echo $row[‘FairyConditionDef_RU’];
} else {
echo $row[‘FairyConditionDef_EN’];
}

echo “

“;
}

}

[:en]

$db = “juliasfairies_fairy_terms”;

echo “

Fairy Terms

“;
echo “

Here you’ll find the information about Fairy pieces and Fairy conditions presented in the Original Problems section of the site and some more! (new fairy elements are to be added…)

“;

echo “

Thanks a lot to those authors who’ve sent with their original problems also the definitions of fairy terms (this is mostly about seldom fairy elements)! Also I’m grateful to Mike Tuzlak, the editor of StrateGems, who’s kindly sent me a big list of fairy pieces, conditions, stipulations he’s accumulated himself (I’ve started to insert those I didn’t have yet into this database) and to Georgy Evseev, who helps with some definitions and also with a correct translation into Russian.

“;

echo “

“;
echo “

“;
echo “

“;
echo “

“; echo ‘ ‘; echo “ Select fairy piece: “; echo print_dropdown_pieces(“SELECT FairyPieceName FROM FairyPieces ORDER BY FairyPieceName”, database_connect($db)); echo “Or enter pattern: “; echo ‘‘; echo “

“; echo ‘ ‘; echo “ Select fairy condition: “; echo print_dropdown_conditions(“SELECT FairyConditionName FROM FairyConditions ORDER BY FairyConditionName”, database_connect($db)); echo “Or enter pattern: “; echo ‘‘; echo “

“; echo ‘ ‘; echo “

“;

if (isset($_GET[“for_fairy_piece”])) {
$show_fairy_piece=$_GET[“for_fairy_piece”];

echo “

Search criterias:
Fairy Piece: “;
echo $show_fairy_piece;
echo ““;

}

if (isset($_POST[‘submit’]))

{

$show_fairy_piece=$_POST[“for_fairy_piece”];
$show_fp_by_pattern=$_POST[“fp_pattern”];

echo “

Search criterias:
Fairy Piece: “;
echo $show_fairy_piece;
echo ““;

if ($show_fairy_piece==”ALL”) {
$select_fairy_piece = “SELECT FairyPieceName, FairyPieceDef_EN FROM FairyPieces WHERE 1”;
} else if ($show_fairy_piece<>“none”) {

$select_fairy_piece = “SELECT FairyPieceName, FairyPieceDef_EN FROM FairyPieces WHERE FairyPieceName LIKE ‘$show_fairy_piece'”;
}

if ($show_fp_by_pattern<>“”) {
echo “
A Pattern for Fairy Piece: “;
echo $show_fp_by_pattern;
echo ““;

if ($show_fairy_piece<>“none”) {
$select_fairy_piece .= ” OR FairyPieceName LIKE ‘%$show_fp_by_pattern%'”;
} else {
$select_fairy_piece = “SELECT FairyPieceName, FairyPieceDef_EN FROM FairyPieces WHERE FairyPieceName LIKE ‘%$show_fp_by_pattern%'”;

}
}
echo “

“;

if ($show_fp_by_pattern<>“” OR $show_fairy_piece<>“none”) {

$select_fairy_piece .= ” ORDER BY FairyPieceName”;
echo “

“;
echo “

“;

selected_list_pieces($select_fairy_piece, database_connect($db), 0, 0);

echo “

Fairy Piece Name

Fairy Piece Definition

“;

echo ““;
}

$show_fairy_condition=$_POST[“for_fairy_condition”];

$show_fc_by_pattern=$_POST[“fc_pattern”];

echo “

Search criterias:
Fairy Condition: “;
echo $show_fairy_condition;
echo ““;

if ($show_fairy_condition==”ALL”) {
$select_fairy_condition = “SELECT FairyConditionName, FairyConditionDef_EN FROM FairyConditions WHERE 1”;
} else if ($show_fairy_condition<>“none”) {

$select_fairy_condition = “SELECT FairyConditionName, FairyConditionDef_EN FROM FairyConditions WHERE FairyConditionName LIKE ‘$show_fairy_condition'”;
}

if ($show_fc_by_pattern<>“”) {
echo “
A Pattern for Fairy Condition: “;
echo $show_fc_by_pattern;
echo ““;

if ($show_fairy_condition<>“none”) {
$select_fairy_condition .= ” OR FairyConditionName LIKE ‘%$show_fc_by_pattern%'”;
} else {
$select_fairy_condition = “SELECT FairyConditionName, FairyConditionDef_EN FROM FairyConditions WHERE FairyConditionName LIKE ‘%$show_fc_by_pattern%'”;

}
}
echo “

“;

if ($show_fc_by_pattern<>“” OR $show_fairy_condition<>“none”) {
$select_fairy_condition .= ” ORDER BY FairyConditionName”;
echo “

“;
echo “

“;

selected_list_conditions($select_fairy_condition, database_connect($db), 0);

echo “

Fairy Condition Name

Fairy Condition Definition

“;

echo ““;
}

} else {

echo “

Fairy Pieces: Basic (frequently used) pieces

“;

echo “

“;
echo “

“;

selected_list_pieces(“SELECT FairyPieceName, FairyPieceDef_EN, Popeye FROM FairyPieces WHERE Basic=’1′ ORDER BY FairyPieceName”, database_connect($db), 0, 1);

echo “

Fairy Piece Name

Fairy Piece Definition

Popeye

“;

echo ““;

echo “

Fairy Conditions: Basic (frequently used) conditions

“;

echo “

“;
echo “

“;

selected_list_conditions(“SELECT FairyConditionName, FairyConditionDef_EN FROM FairyConditions WHERE Basic=’1′ ORDER BY FairyConditionName”, database_connect($db), 0);

echo “

Fairy Condition Name

Fairy Condition Definition

“;

echo ““;

}

[:ru]

$db = “juliasfairies_fairy_terms”;

echo “

Сказочные термины

“;
echo “

Здесь Вы найдете информацию о Сказочных фигурых и Сказочных условиях, представленных в разделе Оригинальных задач сайта! (новые сказочные элементы и также русские переводы будут добавляться…)

“;

echo “

Спасибо большое тем авторам, кто присылает определения используемых сказочных элементов вместе со своими оригинальными задачами (это особенно относится к редко встречающимся)! Также я благодарна Майку Тузлаку (Mike Tuzlak), редактору журнала StrateGems, который любезно прислал мне список сказочных фигур, условий, заданий, собранных им за годы работы (постепенно вношу в базу те из них, которых у меня еще не было) и Георгию Евсееву за коррекцию некоторых определений и за помощь с переводом на русский язык.

“;

echo “

“;
echo “

“;
echo “

“;
echo “

“; echo ‘ ‘; echo “ Выберите сказочную фигуру: “; echo print_dropdown_pieces(“SELECT * FROM FairyPieces ORDER BY FairyPieceName”, database_connect($db)); echo “Или введите образец: “; echo ‘‘; echo “

“; echo ‘ ‘; echo “ Выберите сказочное условие: “; echo print_dropdown_conditions(“SELECT * FROM FairyConditions ORDER BY FairyConditionName”, database_connect($db)); echo “Или введите образец: “; echo ‘‘; echo “

“; echo ‘ ‘; echo “

“;

if (isset($_POST[‘submit’]))

{

$show_fairy_piece=$_POST[“for_fairy_piece”];
$show_fp_by_pattern=$_POST[“fp_pattern”];

echo “

Критерии поиска:
Сказочная фигура: “;
echo $show_fairy_piece;
echo ““;

if ($show_fairy_piece==”ALL”) {
$select_fairy_piece = “SELECT FairyPieceName, FairyPieceDef_RU FROM FairyPieces WHERE 1”;
} else if ($show_fairy_piece<>“none”) {

$select_fairy_piece = “SELECT FairyPieceName, FairyPieceDef_RU FROM FairyPieces WHERE FairyPieceName LIKE ‘$show_fairy_piece'”;
}

if ($show_fp_by_pattern<>“”) {
echo “
Образец для сказочной фигуры: “;
echo $show_fp_by_pattern;
echo ““;

if ($show_fairy_piece<>“none”) {
$select_fairy_piece .= “OR FairyPieceName LIKE ‘%$show_fp_by_pattern%'”;
} else {
$select_fairy_piece = “SELECT FairyPieceName, FairyPieceDef_RU FROM FairyPieces WHERE FairyPieceName LIKE ‘%$show_fp_by_pattern%'”;

}
}
echo “

“;

if ($show_fp_by_pattern<>“” OR $show_fairy_piece<>“none”) {
$select_fairy_piece .= ” ORDER BY FairyPieceName”;
echo “

“;
echo “

“;

selected_list_pieces($select_fairy_piece, database_connect($db), 1, 0);

echo “

Название сказочной фигуры

Определение сказочной фигуры

“;

echo ““;
}

$show_fairy_condition=$_POST[“for_fairy_condition”];

$show_fc_by_pattern=$_POST[“fc_pattern”];

echo “

Критерии поиска:
Сказочное условие: “;
echo $show_fairy_condition;
echo ““;

if ($show_fairy_condition==”ALL”) {
$select_fairy_condition = “SELECT FairyConditionName, FairyConditionDef_RU FROM FairyConditions WHERE 1”;
} else if ($show_fairy_condition<>“none”) {

$select_fairy_condition = “SELECT FairyConditionName, FairyConditionDef_RU FROM FairyConditions WHERE FairyConditionName LIKE ‘$show_fairy_condition'”;
}

if ($show_fc_by_pattern<>“”) {
echo “
Или образец для сказочного условия: “;
echo $show_fc_by_pattern;
echo ““;

if ($show_fairy_condition<>“none”) {
$select_fairy_condition .= “OR FairyConditionName LIKE ‘%$show_fc_by_pattern%'”;
} else {
$select_fairy_condition = “SELECT FairyConditionName, FairyConditionDef_RU FROM FairyConditions WHERE FairyConditionName LIKE ‘%$show_fc_by_pattern%'”;

}
}
echo “

“;

if ($show_fc_by_pattern<>“” OR $show_fairy_condition<>“none”) {
$select_fairy_condition .= ” ORDER BY FairyConditionName”;
echo “

“;
echo “

“;

selected_list_conditions($select_fairy_condition, database_connect($db), 1);

echo “

Название сказочного условия

Определение сказочного условия

“;

echo ““;
}

} else {

echo “

Сказочные фигуры: Основные (чаще применяемые)

“;

echo “

“;
echo “

“;

selected_list_pieces(“SELECT FairyPieceName, FairyPieceDef_RU, Popeye FROM FairyPieces WHERE Basic=’1′ ORDER BY FairyPieceName”, database_connect($db), 1, 1);

echo “

Название сказочной фигуры

Определение сказочной фигуры

Popeye

“;

echo ““;

echo “

Сказочные условия: Основные (чаще применяемые)

“;

echo “

“;
echo “

“;

selected_list_conditions(“SELECT FairyConditionName, FairyConditionDef_RU FROM FairyConditions WHERE Basic=’1′ ORDER BY FairyConditionName”, database_connect($db), 1);

echo “

Название сказочного условия

Определение сказочного условия

“;

echo ““;

}

[:]

?>[:]