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; }