function insert_card_to_deck($table, $card)
{
global $CARD_TABLE_NAME, $CARD_VALID_ID_CONSTRAINT;
foreach ($card as $name => $num) {
#$query = "SELECT id FROM $CARD_TABLE_NAME WHERE name = \"$name\" AND id RLIKE '[0-9_][0-9]$';";
$query = "SELECT id FROM {$CARD_TABLE_NAME} WHERE name = \"{$name}\" AND {$CARD_VALID_ID_CONSTRAINT};";
#echo $query;
#echo "<br>";
$result = mysql_query($query);
$count = @mysql_numrows($result);
check_single_tuple($count, $name);
#if ($count != 1) {
# error_msg("multiple($count) \"$name\"");
# #echo "ERROR: multiple $name";
# #echo "<br>"
#}
$id = mysql_result($result, 0, "id");
#echo "id: $id, num: $num";
#echo "<br>";
$tuple = array();
$tuple["id"] = $id;
$tuple["num"] = $num;
$query = mysql_insert_str($table, $tuple);
#echo $query;
#echo "<br>";
exec_mysql_query($query);
}
}
function insert_card_data($table, $arr)
{
foreach ($arr as $set_type => $card_obj) {
$card_array = (array) $card_obj;
foreach ($card_array as $set_seq => $card_info_obj) {
$data = array();
$data["setType"] = $set_type;
$data["setSeq"] = $set_seq;
$card_info_array = (array) $card_info_obj;
foreach ($card_info_array as $key => $value) {
$value_type = gettype($value);
$value_all = "";
if ($value_type == "array") {
$value_all = implode(', ', $value);
} else {
if ($value_type == "object") {
$value_all = implode(', ', (array) $value);
} else {
if ($value === false) {
$value_all = 0;
} else {
$value_all = $value;
}
}
}
#echo "setType=$set_type, setSeq=$set_seq";
#echo "<br>";
$data[$key] = mysql_real_escape_string($value_all);
}
$query = mysql_insert_str($table, $data);
#echo $query;
#echo "<br>";
exec_mysql_query($query);
#if ($data["id"] == "EX1_066") {
# exec_mysql_query($query);
#}
}
}
}
