function tribe_createTribe($tag, $name, $leaderID, $db)
{
$query = "INSERT INTO Tribe " . "(tag, name, leaderID, created, governmentID, validatetime, valid) " . "values ('{$tag}', '{$name}', 0, NOW() + 0, 1,((NOW() + INTERVAL " . TRIBE_MINIMUM_LIVESPAN . " SECOND ) + 0),0)";
if (!$db->query($query)) {
return 0;
}
if (!tribe_createRanking($tag, $db)) {
return 0;
}
if ($leaderID && !tribe_joinTribe($leaderID, $tag, $db)) {
return 0;
}
if ($leaderID && !tribe_makeLeader($leaderID, $tag, $db)) {
tribe_leaveTribe($leaderID, $tag, $db);
return 0;
}
return 1;
}
function tribe_createTribe($tag, $name, $password, $leaderID)
{
global $db;
$sql = $db->prepare("INSERT INTO " . TRIBE_TABLE . "\n (tag, name, leaderID, created, password, governmentID, validatetime, valid)\n values \n (:tag, :name, 0, NOW() + 0, :password, 1, ((NOW() + INTERVAL " . TRIBE_MINIMUM_LIVESPAN . " SECOND ) + 0),0)");
$sql->bindValue('tag', $tag, PDO::PARAM_STR);
$sql->bindValue('name', $name, PDO::PARAM_STR);
$sql->bindValue('password', $password, PDO::PARAM_STR);
if (!$sql->execute()) {
return false;
}
if (!tribe_createRanking($tag)) {
return false;
}
if (!tribe_joinTribe($leaderID, $tag)) {
return false;
}
if (!tribe_makeLeader($leaderID, $tag)) {
tribe_leaveTribe($leaderID, $tag);
return false;
}
return 1;
}
