fragment kodu z zawartym wzorem na tworzenie księżyca:
function CreateOneMoonRecord($Galaxy, $System, $Planet, $Universe, $Owner, $MoonName, $Chance, $time = 0, $Size = 0) { $SQL = "SELECT id_luna,planet_type,id,name,temp_max,temp_min FROM ".PLANETS." "; $SQL .= "WHERE "; $SQL .= "universe = '".$Universe."' AND "; $SQL .= "galaxy = '".$Galaxy."' AND "; $SQL .= "system = '".$System."' AND "; $SQL .= "planet = '".$Planet."' AND "; $SQL .= "planet_type = '1';"; $MoonPlanet = $GLOBALS['DATABASE']->getFirstRow($SQL); if ($MoonPlanet['id_luna'] != 0) return false; if($Size == 0) { } else { $size = $Size; } $GLOBALS['DATABASE']->multi_query("INSERT INTO ".PLANETS." SET name = '".$MoonName."', id_owner = ".$Owner.", universe = ".$Universe.", galaxy = ".$Galaxy.", system = ".$System.", planet = ".$Planet.", last_update = ".TIMESTAMP.", planet_type = '3', image = 'mond', diameter = ".$size.", field_max = '1', temp_min = ".$mintemp.", temp_max = ".$maxtemp.", metal = 0, metal_perhour = 0, crystal = 0, crystal_perhour = 0, deuterium = 0, deuterium_perhour = 0; SET @moonID = LAST_INSERT_ID(); UPDATE ".PLANETS." SET id_luna = @moonID WHERE id = ".$MoonPlanet['id'].";"); return true; }
PS. W tym wypadku, fields nie ma nic do wielkości księżyca, to jest wartość, która określa ile można zbudować budynków na danym księżycu.