/**
* @see Command
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$db = $this->getContainer()->get('doctrine')->getManager();
$username = $input->getArgument('username');
$email = $input->getArgument('email');
$password = $input->getArgument('password');
$locale = $input->getArgument('locale');
$inactive = $input->getOption('inactive');
$superadmin = $input->getOption('super-admin');
$manipulator = $this->getContainer()->get('syw.util.user_manipulator');
$manipulator->create($username, $password, $email, $locale, !$inactive, $superadmin);
$licotestdb = $this->getContainer()->get('doctrine.dbal.default_connection');
$licotestdb->query("UPDATE fos_user SET id='" . $username . "' WHERE username='******'");
$db->flush();
$user = $db->getRepository('SywFrontMainBundle:User')->findOneBy(array("username" => $username, "email" => $email));
$userProfile = new \Syw\Front\MainBundle\Entity\UserProfile();
$userProfile->setUser($user);
$userProfile->setCreatedAt(new \DateTime());
$db->persist($userProfile);
$db->flush();
$mailpref = new \Syw\Front\MainBundle\Entity\Mail();
$mailpref->setUser($user);
$mailpref->setNewsletterAllowed(1);
$mailpref->setAdminAllowed(1);
$mailpref->setOtherUsersAllowed(1);
$mailpref->setModifiedAt(new \DateTime());
$db->persist($mailpref);
$db->flush();
$user->setProfile($userProfile);
$user->setMailPref($mailpref);
$db->flush();
$obj = new \Syw\Front\MainBundle\Entity\Privacy();
$obj->setUser($user);
$obj->setSecretProfile(0);
$obj->setSecretCounterData(0);
$obj->setSecretMachines(0);
$obj->setSecretContactInfo(0);
$obj->setSecretSocialInfo(0);
$obj->setShowRealName(0);
$obj->setShowEmail(0);
$obj->setShowLocation(1);
$obj->setShowHostnames(1);
$obj->setShowKernel(1);
$obj->setShowDistribution(1);
$obj->setShowVersions(1);
$db->persist($obj);
$db->flush();
$output->writeln(sprintf('Created user <comment>%s</comment>', $username));
}
public function registerAction(Request $request)
{
/** @var $formFactory \FOS\UserBundle\Form\Factory\FactoryInterface */
$formFactory = $this->get('fos_user.registration.form.factory');
/** @var $userManager \FOS\UserBundle\Model\UserManagerInterface */
$userManager = $this->get('fos_user.user_manager');
/** @var $dispatcher \Symfony\Component\EventDispatcher\EventDispatcherInterface */
$dispatcher = $this->get('event_dispatcher');
$languages = $this->get('doctrine')->getRepository('SywFrontMainBundle:Languages')->findBy(array('active' => 1), array('language' => 'ASC'));
$user = $userManager->createUser();
$user->setEnabled(true);
$event = new GetResponseUserEvent($user, $request);
$dispatcher->dispatch(FOSUserEvents::REGISTRATION_INITIALIZE, $event);
if (null !== $event->getResponse()) {
return $event->getResponse();
}
$form = $formFactory->createForm();
$form->setData($user);
$form->handleRequest($request);
if ($form->isValid()) {
$event = new FormEvent($form, $request);
$dispatcher->dispatch(FOSUserEvents::REGISTRATION_SUCCESS, $event);
$em = $this->getDoctrine()->getManager();
$userManager->updateUser($user);
$userProfile = new UserProfile();
$userProfile->setUser($user);
$userProfile->setCreatedAt(new \DateTime());
$em->persist($userProfile);
$em->flush();
$mailpref = new \Syw\Front\MainBundle\Entity\Mail();
$mailpref->setUser($user);
$mailpref->setNewsletterAllowed(1);
$mailpref->setAdminAllowed(1);
$mailpref->setOtherUsersAllowed(1);
$mailpref->setModifiedAt(new \DateTime());
$em->persist($mailpref);
$em->flush();
$user->setProfile($userProfile);
$user->setMailPref($mailpref);
$userManager->updateUser($user);
$obj = new \Syw\Front\MainBundle\Entity\Privacy();
$obj->setUser($user);
$obj->setSecretProfile(0);
$obj->setSecretCounterData(0);
$obj->setSecretMachines(0);
$obj->setSecretContactInfo(0);
$obj->setSecretSocialInfo(0);
$obj->setShowRealName(0);
$obj->setShowEmail(0);
$obj->setShowLocation(0);
$obj->setShowHostnames(0);
$obj->setShowKernel(1);
$obj->setShowDistribution(1);
$obj->setShowVersions(0);
$em->persist($obj);
$em->flush();
if (true === isset($_POST['fos_user_registration_form']['newsletter']) && intval($_POST['fos_user_registration_form']['newsletter']) == 1) {
$email = $user->getEmail();
unset($user);
$user = $this->get('doctrine')->getRepository('SywFrontMainBundle:User')->findOneBy(array('email' => $email));
if (false === file_exists('/srv/www.linuxcounter.net/newsletter.email.import.csv')) {
$fp = fopen('/srv/www.linuxcounter.net/newsletter.email.import.csv', "a+");
fwrite($fp, "CounterID\tEmail\n");
fclose($fp);
}
$fp = fopen('/srv/www.linuxcounter.net/newsletter.email.import.csv', "a+");
fwrite($fp, $user->getId() . "\t" . $user->getEmail() . "\n");
fclose($fp);
}
if (null === ($response = $event->getResponse())) {
$url = $this->generateUrl('fos_user_registration_confirmed');
$response = new RedirectResponse($url);
}
$dispatcher->dispatch(FOSUserEvents::REGISTRATION_COMPLETED, new FilterUserResponseEvent($user, $request, $response));
return $response;
}
$metatitle = $this->get('translator')->trans('User Account Registration', array(), 'fos_user_registration_register');
$title = $metatitle;
$online = $this->getOnlineUsers();
$return2 = $this->getTransForm($user);
$return1 = array('online' => $online, 'metatitle' => $metatitle, 'metadescription' => $this->get('translator')->trans('If you want to get counted as a linux user, you must register here for an account in the Linux Counter.', array(), 'syw_front_main_main_index'), 'title' => $title, 'form' => $form->createView(), 'languages' => $languages, 'user' => $user);
return $this->render('FOSUserBundle:Registration:register.html.twig', array_merge($return1, $return2));
}
/**
* @see Command
*/
protected function execute(InputInterface $input, OutputInterface $output)
{
$item = $input->getArgument('item');
$lico = $this->getContainer()->get('doctrine.dbal.lico_connection');
$licotest = $this->getContainer()->get('doctrine')->getManager();
$licotestdb = $this->getContainer()->get('doctrine.dbal.default_connection');
if ($item == "processors" || $item == "all") {
$rows = $lico->fetchAll('SELECT p.name, p.herz FROM processors p ORDER BY p.name ASC');
foreach ($rows as $row) {
$name = $row['name'];
$hertz = $row['herz'];
$obj = new \Syw\Front\MainBundle\Entity\Cpus();
$obj->setName($name);
$obj->setHertz($hertz);
$licotest->persist($obj);
$licotest->flush();
}
}
if ($item == "countries" || $item == "all") {
$rows = $lico->fetchAll('SELECT p.name, p.code, p.population FROM places p ORDER BY p.name ASC');
foreach ($rows as $row) {
$name = $row['name'];
$code = $row['code'];
$population = $row['population'];
$obj = new \Syw\Front\MainBundle\Entity\Countries();
$obj->setName($name);
$obj->setCode(strtolower($code));
$obj->setPopulation($population);
$licotest->persist($obj);
$licotest->flush();
}
}
if ($item == "distributions" || $item == "all") {
$rows = $lico->fetchAll('SELECT DISTINCT m.distribution AS name FROM machines m ORDER BY m.distribution');
foreach ($rows as $row) {
$name = $row['name'];
$obj = new \Syw\Front\MainBundle\Entity\Distributions();
$obj->setName($name);
$licotest->persist($obj);
$licotest->flush();
}
}
if ($item == "architectures" || $item == "all") {
$rows = $lico->fetchAll('SELECT DISTINCT m.arch AS name FROM machines m ORDER BY m.arch');
foreach ($rows as $row) {
$name = $row['name'];
$obj = new \Syw\Front\MainBundle\Entity\Architectures();
$obj->setName($name);
$licotest->persist($obj);
$licotest->flush();
}
}
if ($item == "kernels" || $item == "all") {
$rows = $lico->fetchAll('SELECT DISTINCT m.kernel AS name FROM machines m ORDER BY m.kernel');
foreach ($rows as $row) {
$name = $row['name'];
$obj = new \Syw\Front\MainBundle\Entity\Kernels();
$obj->setName($name);
$licotest->persist($obj);
$licotest->flush();
}
}
if ($item == "classes" || $item == "all") {
$rows = $lico->fetchAll('SELECT DISTINCT m.sysclass AS name FROM machines m ORDER BY m.sysclass');
foreach ($rows as $row) {
$name = $row['name'];
$obj = new \Syw\Front\MainBundle\Entity\Classes();
$obj->setName($name);
$licotest->persist($obj);
$licotest->flush();
}
}
if ($item == "purposes" || $item == "all") {
$rows = $lico->fetchAll('SELECT DISTINCT m.purpose AS name FROM machines m ORDER BY m.purpose');
foreach ($rows as $row) {
$line = $row['name'];
if (strpos($line, ",") !== false) {
$names = explode(",", trim($line));
foreach ($names as $name) {
$exists = false;
$exists = $licotest->getRepository('SywFrontMainBundle:Purposes')->findOneBy(array("name" => $name));
if (!$exists) {
$obj = new \Syw\Front\MainBundle\Entity\Purposes();
$obj->setName($name);
$licotest->persist($obj);
$licotest->flush();
}
}
} else {
$exists = false;
$exists = $licotest->getRepository('SywFrontMainBundle:Purposes')->findOneBy(array("name" => $line));
if (!$exists) {
$obj = new \Syw\Front\MainBundle\Entity\Purposes();
$obj->setName($line);
$licotest->persist($obj);
$licotest->flush();
}
}
}
}
if ($item == "users") {
@exec("php app/console syw:import:lico usersbg >>import.log 2>&1 3>&1 4>&1 &");
exit(0);
}
if ($item == "usersbg") {
gc_collect_cycles();
if (true === file_exists('import.db')) {
$fp = fopen('import.db', "r");
$data = fread($fp, 1024);
fclose($fp);
$fp = null;
unset($fp);
$dataar = explode(" ", trim($data));
$start = intval(trim($dataar[0]));
$counter = intval(trim($dataar[1]));
} else {
$nums = $lico->fetchAll('SELECT COUNT(f_key) AS num FROM users');
$numusers = $nums[0]['num'];
$start = 0;
// $numusers;
$counter = 0;
}
$itemsperloop = 200;
$z = 0;
$a = $start;
unset($rows);
$rows = $lico->fetchAll('SELECT * FROM users ORDER BY f_key LIMIT ' . $a . ',' . $itemsperloop . '');
foreach ($rows as $row) {
$counter++;
gc_collect_cycles();
$sendmail = false;
$id = $row['f_key'];
$email = $row['email'];
$userex = null;
unset($userex);
$userex = $licotest->getRepository('SywFrontMainBundle:User')->findOneBy(array("id" => $id));
if (true === isset($userex) && true === is_object($userex)) {
continue;
}
$userex = null;
unset($userex);
$userex = $licotest->getRepository('SywFrontMainBundle:User')->findOneBy(array("email" => $email));
if (true === isset($userex) && true === is_object($userex)) {
continue;
}
if (preg_match("`^([a-z]{5,}[0-9]{2,}[\\+]+[a-z0-9]{3,}@gmail\\.com)\$`i", strtolower($email))) {
continue;
}
if (preg_match("`^(.*[a-z]+\\.[a-z]+\\.[a-z0-9]+\\.[a-z0-9]+.*@gmail\\.com)\$`i", strtolower($email))) {
continue;
}
$lastLogin = $row['logintime'];
$username = $id;
$password = mt_rand(1000000000, 9999999999.0);
$sendmail = true;
$licotest = $this->getContainer()->get('doctrine')->getManager();
$licotestdb = $this->getContainer()->get('doctrine.dbal.default_connection');
$licotestdb->prepare('SET autocommit=0;')->execute();
if ($sendmail === true) {
$userManager = $this->getContainer()->get('fos_user.user_manager');
$user = $userManager->createUser();
$user->setId($row['f_key']);
$user->setEnabled(true);
$user->setUsername($username);
$user->setEmail($email);
$user->setPlainPassword($password);
$user->setLastLogin(new \DateTime($lastLogin));
$user->setSuperAdmin(false);
$user->setLocale('en');
$userManager->updateUser($user);
$userid = $user->getId();
$id = $userid;
// $licotestdb->query('UPDATE fos_user SET id=' . $id . ' WHERE id=\'' . $userid . '\'');
// unset($user);
// $user = $licotest->getRepository('SywFrontMainBundle:User')->findOneBy(array("id" => $id));
$userProfile = new UserProfile();
$userProfile->setUser($user);
$userProfile->setCreatedAt(new \DateTime($row['f_ctime']));
$userProfile->setModifiedAt(new \DateTime($row['f_mtime']));
$licotest->persist($userProfile);
$licotest->flush();
$mailpref = new \Syw\Front\MainBundle\Entity\Mail();
$mailpref->setUser($user);
$mailpref->setNewsletterAllowed(1);
$mailpref->setAdminAllowed(1);
$mailpref->setOtherUsersAllowed(1);
$mailpref->setModifiedAt(new \DateTime());
$licotest->persist($mailpref);
$licotest->flush();
$user->setProfile($userProfile);
$user->setMailPref($mailpref);
$userManager->updateUser($user);
$licotest->flush();
$userManager = null;
unset($userManager);
$userProfile = null;
unset($userProfile);
$privacy = new \Syw\Front\MainBundle\Entity\Privacy();
$privacy->setUser($user);
$privacy->setSecretProfile(0);
$privacy->setSecretCounterData(0);
$privacy->setSecretMachines(0);
$privacy->setSecretContactInfo(0);
$privacy->setSecretSocialInfo(0);
$privacy->setShowRealName(0);
$privacy->setShowEmail(0);
$privacy->setShowLocation(1);
$privacy->setShowHostnames(1);
$privacy->setShowKernel(1);
$privacy->setShowDistribution(1);
$privacy->setShowVersions(1);
$licotest->persist($privacy);
$licotest->flush();
$mrows = $lico->fetchAll('SELECT * FROM machines WHERE owner = \'' . $userid . '\' ORDER BY f_key');
foreach ($mrows as $mrow) {
gc_collect_cycles();
$userid = $mrow['owner'];
$machineid = $mrow['f_key'];
$machine = new \Syw\Front\MainBundle\Entity\Machines();
$machine->setUser($user);
$machine->setId($machineid);
if (true === isset($mrow['update_key']) && trim($mrow['update_key']) != "") {
$machine->setUpdateKey(trim($mrow['update_key']));
}
if (true === isset($mrow['name']) && trim($mrow['name']) != "") {
$machine->setHostname(trim($mrow['name']));
}
if (true === isset($mrow['cpunum']) && trim($mrow['cpunum']) != "") {
$machine->setCores(trim($mrow['cpunum']));
}
if (true === isset($mrow['cpuflags']) && trim($mrow['cpuflags']) != "") {
$machine->setFlags(trim($mrow['cpuflags']));
}
if (true === isset($mrow['accounts']) && trim($mrow['accounts']) != "") {
$machine->setAccounts(trim($mrow['accounts']));
}
if (true === isset($mrow['disk']) && trim($mrow['disk']) != "") {
$machine->setDiskspace(trim($mrow['disk']));
}
if (true === isset($mrow['diskfree']) && trim($mrow['diskfree']) != "") {
$machine->setDiskspaceFree(trim($mrow['diskfree']));
}
if (true === isset($mrow['memory']) && trim($mrow['memory']) != "") {
$machine->setMemory(trim($mrow['memory']));
}
if (true === isset($mrow['memfree']) && trim($mrow['memfree']) != "") {
$machine->setMemoryFree(trim($mrow['memfree']));
}
if (true === isset($mrow['swap']) && trim($mrow['swap']) != "") {
$machine->setSwap(trim($mrow['swap']));
}
if (true === isset($mrow['swapfree']) && trim($mrow['swapfree']) != "") {
$machine->setSwapFree(trim($mrow['swapfree']));
}
if (true === isset($mrow['distversion']) && trim($mrow['distversion']) != "") {
$machine->setDistversion(trim($mrow['distversion']));
}
if (true === isset($mrow['mailer']) && trim($mrow['mailer']) != "") {
$machine->setMailer(trim($mrow['mailer']));
}
if (true === isset($mrow['network']) && trim($mrow['network']) != "") {
$machine->setNetwork(trim($mrow['network']));
}
if (true === isset($mrow['online']) && trim($mrow['online']) != "") {
if (trim($mrow['online']) == "online") {
$machine->setOnline(1);
} else {
$machine->setOnline(0);
}
}
if (true === isset($mrow['uptime']) && trim($mrow['uptime']) != "") {
$machine->setUptime(trim($mrow['uptime']));
}
if (true === isset($mrow['load']) && trim($mrow['load']) != "") {
$machine->setLoadAvg(trim($mrow['load']));
}
if (true === isset($mrow['f_ctime']) && trim($mrow['f_ctime']) != "") {
$machine->setCreatedAt(new \DateTime(trim($mrow['f_ctime'])));
}
if (true === isset($mrow['f_mtime']) && trim($mrow['f_mtime']) != "") {
$machine->setModifiedAt(new \DateTime(trim($mrow['f_mtime'])));
}
unset($obj);
if (true === isset($mrow['distribution']) && trim($mrow['distribution']) != "") {
$obj = $licotest->getRepository('SywFrontMainBundle:Distributions')->findOneBy(array("name" => trim($mrow['distribution'])));
if (true === isset($obj) && true === is_object($obj)) {
$obj->setMachinesNum($obj->getMachinesNum() + 1);
$licotest->persist($obj);
$machine->setDistribution($obj);
}
}
unset($obj);
if (true === isset($mrow['kernel']) && trim($mrow['kernel']) != "") {
$obj = $licotest->getRepository('SywFrontMainBundle:Kernels')->findOneBy(array("name" => trim($mrow['kernel'])));
if (true === isset($obj) && true === is_object($obj)) {
$obj->setMachinesNum($obj->getMachinesNum() + 1);
$licotest->persist($obj);
$machine->setKernel($obj);
}
}
unset($obj);
if (true === isset($mrow['cpu']) && trim($mrow['cpu']) != "" && intval($mrow['cpu']) >= 1) {
unset($line);
$line = $lico->fetchAll('SELECT name, herz FROM processors WHERE f_key=\'' . trim($mrow['cpu']) . '\'');
if (true === isset($line) && true === is_array($line) && true === isset($line[0]) && true === is_array($line[0]) && true === isset($line[0]['name']) && true === isset($line[0]['herz'])) {
unset($obj);
$obj = $licotest->getRepository('SywFrontMainBundle:Cpus')->findOneBy(array("name" => trim($line[0]['name']), "hertz" => trim($line[0]['herz'])));
if (true === isset($obj) && true === is_object($obj)) {
$obj->setMachinesNum($obj->getMachinesNum() + 1);
$licotest->persist($obj);
$machine->setCpu($obj);
}
}
}
unset($obj);
if (true === isset($mrow['country']) && trim($mrow['country']) != "") {
$obj = $licotest->getRepository('SywFrontMainBundle:Countries')->findOneBy(array("code" => strtolower(trim($mrow['country']))));
if (true === isset($obj) && true === is_object($obj)) {
$obj->setMachinesNum($obj->getMachinesNum() + 1);
$licotest->persist($obj);
$machine->setCountry($obj);
}
}
unset($obj);
if (true === isset($mrow['arch']) && trim($mrow['arch']) != "") {
$obj = $licotest->getRepository('SywFrontMainBundle:Architectures')->findOneBy(array("name" => trim($mrow['arch'])));
if (true === isset($obj) && true === is_object($obj)) {
$obj->setMachinesNum($obj->getMachinesNum() + 1);
$licotest->persist($obj);
$machine->setArchitecture($obj);
}
}
unset($obj);
if (true === isset($mrow['sysclass']) && trim($mrow['sysclass']) != "") {
$obj = $licotest->getRepository('SywFrontMainBundle:Classes')->findOneBy(array("name" => trim($mrow['sysclass'])));
if (true === isset($obj) && true === is_object($obj)) {
$obj->setMachinesNum($obj->getMachinesNum() + 1);
$licotest->persist($obj);
$machine->setClass($obj);
}
}
unset($obj);
$licotest->persist($machine);
$licotest->flush();
$mid = $machine->getId();
}
$user = null;
unset($user);
$privacy = null;
unset($privacy);
}
$licotestdb->prepare('COMMIT;')->execute();
$licotest->clear();
gc_collect_cycles();
$user = null;
unset($user);
$userProfile = null;
unset($userProfile);
$privacy = null;
unset($privacy);
$userid = null;
unset($userid);
$userManager = null;
unset($userManager);
$z++;
// $mypid = getmypid();
// $files = @exec('lsof -p '.$mypid.' | wc -l');
// file_put_contents("import.log", ">>> ".$counter." | ".$z." | ".$id." | open files: ".$files." | Memory info: ".number_format(round((memory_get_usage()/1000), 2))." Mb (".number_format(round((memory_get_peak_usage()/1000), 2))." Mb) \n", FILE_APPEND);
file_put_contents("import.log", ">>> " . $counter . " | " . $z . " | " . $id . " | " . $row['f_key'] . " \n", FILE_APPEND);
gc_collect_cycles();
}
file_put_contents('import.db', $a + $itemsperloop . " " . $counter);
$licotest->clear();
$licotest->close();
$licotestdb->close();
$lico->close();
$licotest = null;
unset($licotest);
$licotestdb = null;
unset($licotestdb);
$lico = null;
unset($lico);
gc_collect_cycles();
@exec("php app/console syw:import:lico users >>import.log 2>&1 3>&1 4>&1 &");
exit(0);
}
}
