 
 INSERT INTO `postsViews` (`id`, `postsId`, `ipaddress`) VALUES
 (1, 1, '125.234.96.138'),
+(112, 1, '180.76.15.140'),
 (20, 1, '180.76.15.15'),
+(123, 1, '66.249.64.195'),
 (41, 1, '66.249.65.48'),
 (43, 1, '66.249.65.51'),
 (23, 1, '66.249.65.54'),

(47, 45, 'questions', 'jj', NULL, 'jj', 'jjjj', 2, 0, 'N', 1433144850, 1433648255, 1433145068, 'A', 'N', 1433648255, 'N'),
(48, 45, 'questions', 'Creating a new Post', NULL, 'creating-a-new-post', 'Social Questions is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Social Questions or suggest a new feature, please post it on Github issues. \r\n\r\n\r\nSocial Questions is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Social Questions or suggest a new feature, please post it on Github issues. ', 5, 1, 'N', 1433216547, 1438235737, 1433537845, 'A', 'N', 1433648820, 'Y'),
(49, 56, 'questions', ' Phalcon Conference 2015', NULL, 'phalcon-conference-2015', '**Hello hello,**\r\n\r\nA couple of us are looking into the options of having a Phalcon Conference in 2015. We''d like to get some input from you guys as well, see how you feel about it and what we can expect in rough numbers.\r\n\r\nTake a look at this survey and let us know!\r\n\r\nIf there''s something not mentioned in the survey, respond to this thread with whatever you want to share. As long as it''s relevant to the survey and or conference.\r\n\r\nThanks!\r\n\r\nupdated per 2014-11-25, The survey is Amsterdam specific now.', 10, 6, 'N', 1433663963, 1438318137, NULL, 'A', 'N', 0, 'N'),
(50, 56, 'questions', ' Community contributed Extensions/Plugins/Adapters/VM', NULL, 'community-contributed-extensionspluginsadaptersvm', 'I had to built some oAuth with Phalcon. Then I share a simplified version of what i have done (i just put all the code in protected method of the controller, feel free to update the structure). You will have to modify a few things. Just look for "specific to your application" comments in the code. https://gist.github.com/SneakyBobito/6909234\r\n\r\nIt is based on PHPoAuthLib : https://github.com/Lusitanian/PHPoAuthLib then you have to add it to you autoloader Then you may add any service available in the lib (but i only tested with google and github). When you want to add a service : you have to generate an api key/secret key on the specific service and then put them into your config as with the examples of google and GitHub. Finaly add the action that has the same name of the oAuth service (github : GitHubAction google : GoogleAction)\r\n\r\nAll the examples of how to exploit the oAuth api are here : https://github.com/Lusitanian/PHPoAuthLib\r\n\r\n\r\n    $di[''mail''] = function () use ($cf) {\r\n    $mail = new PHPMailer;\r\n\r\n    $mail->isSMTP();\r\n    $mail->isHTML(true);\r\n\r\n    $mail->CharSet      = $cf->mail->charset;                                \r\n    $mail->Host         = $cf->mail->host;\r\n    $mail->SMTPAuth     = true;                               \r\n    $mail->Username     = $cf->mail->username;               \r\n    $mail->Password     = $cf->mail->password;                           \r\n    $mail->SMTPSecure   = $cf->mail->security;    \r\n    $mail->Port         = $cf->mail->port;\r\n\r\n    $mail->addAddress($cf->mail->email, $cf->mail->name);\r\n\r\n    return $mail;\r\n    };', 20, 2, 'N', 1433664088, 1438235737, 1433822699, 'A', 'N', 0, 'N'),
(51, 45, 'blog', ' Setting up PHPMailer', NULL, 'setting-up-phpmailer', 'Hi, welcome to the Phalcon official tips. We plan to share articles, tutorials and tips from the community and the Phalcon developers. All this interesting content will be available soon. We think you’re going to love it. Also we have features implemented:\r\nWeekly Digest\r\n\r\nA weekly digest is now sent to all users registered in the forum. This email summarizes the most important posts in the last week. A great resource if you want to learn more about the framework. If you don''t want to receive this weekly e-mail you can update your e-mail preferences.\r\nBadges\r\n\r\nBadges are awards that reward users for their contributions, collaboration and participation in the forum. Badges enable the community to collectively identify the best contributors. Check the available badges here.\r\nNotifications\r\n\r\nAll activity that occurs in the posts where you have been participated is now centralized in the notifications. You can see them anytime here. Improved search system\r\nSubscription to Posts\r\n\r\nNow you can subscribe to a post, by doing this you''ll receive e-mail notifications on topics you''re waiting answers without having to participate/comment.', 21, 1, 'N', 1433773306, 1443196208, 1433773506, 'A', 'N', 0, 'Y'),
(52, 47, 'questions', 'A tool for parsing', NULL, 'a-tool-for-parsing', 'The first thing you''ll need to do is obtain the network traffic for the MS-CHAPv2 handshake you''d like to crack.\r\n\r\nFor PPTP VPN connections, simply use a tool such as tcpdump or wireshark in order to obtain a network capture. For WPA2 Enterprise wireless handshakes, simply use a tool like FreeRADIUS-WPE in order to obtain ''challenge'' and ''response'' parameters.\r\n\r\nNext you''ll use chapcrack in order to parse and extract the MS-CHAPv2 handshake from your packet capture or FreeRADIUS interception.', 18, 2, 'Y', 1433775269, 1442829209, 1438332887, 'A', 'N', 0, 'Y'),
(53, 47, 'blog', 'Horizontal Scaling of PHP Apps', NULL, 'horizontalscalingofphpapps', 'In part 1, we discussed the horizontal scaling of the application layer – scaling out servers to handle the PHP code concurrently via load balancers and other means. We covered sharing of local data, touched on potential optimization, and explained the basics of load balancers.\r\n\r\nThe application layer, however, isn’t the only thing that needs scaling. With a bigger demand for our app, the demand for higher read/write operations on the database also surfaces. In this part, we’ll look at scaling the database, explain replication, and cover some common pitfalls you might want to avoid.\r\n\r\n#Optimization\r\n\r\nAs in Part 1, we need to mention optimization first. Indexing your database properly, making sure the tables consist of the least amount of important data and keeping the secondary information in others (users_basic + users_additional + users_alt_contacts, etc – known as database sharding – a complex topic warranting its own article for sure), doing small, atomic queries as opposed to large on-the-fly calculations – all those methods can help you speed up your databases and avoid bottlenecks. There’s one aspect that can help even more, though – query cache.\r\n\r\nDatabase servers typically cache results and compiled SELECT queries that were last executed. This allows a client (our app) to receive the data from cache instead of having to wait for execution again. Such an approach saves CPU cycles, produces results faster, and frees the servers from doing unnecessary calculations. But the query cache is limited in size, and some data sets change more often than others. Using the cache on all of our data would be ludicrous, especially if some information changes faster than some other information. While the cache can be fine tuned, depending on the database vendor, there’s an approach that lends itself quite nicely to the query cache solution – contextual grouping of servers.', 3, 1, 'N', 1434962514, 1443282047, NULL, 'A', 'N', 0, 'N'),
(54, 47, 'blog', 'Laracast Best video', 'https://laracasts.com', 'laracastbestvideo', 'The best PHP screencasts on the web. Buy me lunch once a month, and I''ll teach you everything about modern PHP workflow. ', 5, 0, 'N', 1434982459, 1443276540, NULL, 'A', 'N', 0, 'N'),
(55, 47, 'blog', 'Best link startup', 'http://codeblog.jonskeet.uk/2010/08/29/writing-the-perfect-question/', 'bestlinkstartup', 'oughly, the number of upvotes on their stories and comments, minus the number of downvotes. The numbers won''t exactly match up, because some votes aren''t counted to prevent various types of abuse. ', 9, 0, 'N', 1434982746, 1443281147, NULL, 'A', 'N', 0, 'N'),
(56, 47, 'blog', 'The best question and answers', NULL, 'thebestquestionandanswers', 'Have you thoroughly searched for an answer before asking your question? Sharing your research helps everyone. Tell us what you found (on this site or elsewhere) and why it didn’t meet your needs. This demonstrates that you’ve taken the time to try to help yourself, it saves us from reiterating obvious answers, and above all, it helps you get a more specific and relevant answer!', 11, 0, 'N', 1434982831, 1443116796, NULL, 'A', 'N', 0, 'N'),
(57, 59, 'blog', 'Best website community questions and answer', 'http://ama.phanbook.com', 'bestwebsitecommunityquestionsandanswer', 'A local mail server, such as Postfix, is the most robust way to send email through SendGrid when configured to queue all email from your application and then relay the messages through SendGrid as a smart host. This has the least latency from your application’s perspective with the added benefit of handing your email off to a fault tolerant server. If internet connectivity between your servers and ours drops, a local mail server gracefully handles queuing and resending the email, as opposed to building that intelligence into your sending application.', 10, 6, 'N', 1435215496, 1443319003, NULL, 'A', 'N', 0, 'N'),
(58, 59, 'questions', ' Optimal mullps/addps instructions order for 3 SSE units for Intel Core 2 Duo and How to install Phalcon on android', NULL, 'optimalmullpsaddpsinstructionsorderfor3sseunitsforintelcore2duo', 'It''s known that Intel Core 2 Duo has 3 SSE units. These 3 units allows 3 SSE instructions to be run paralelly (1), for example:\r\n\r\nIt''s known also, that each SSE unit consists of 2 modules: one for addition (substraction), and one for multiplication (division). The latter allows to run mullps-addps instruction sequences parallelly (2), for example:\r\n\r\nWhich way of instruction ordering should I prefer, A or B?\r\n\r\nMore specifically:\r\n\r\n- Is it possible to distribute 3 mulps to 3 SSE multiplication units (1), and at the same time (2) to distribute addps to their respective SSE addition units, resulting in total 6 instructions per schedule cycle?\r\n\r\n- If I run N mullps first, and N addps then - which N is optimal?\r\n\r\nRemarks\r\n\r\n    by ''scheduled'' I mean throughput rate.\r\n', 15, 9, 'N', 1435216990, 1438235737, 1436666390, 'A', 'N', 0, 'Y'),
(59, 59, 'questions', 'SSE instructions in a buffer', NULL, 'sseinstructionsinabuffer', 'If I have an instruction buffer for x86 is there an easy way to check if an instruction is an SSE instruction without having to check if the opcode is within the ranges for the SSE instructions? By this I mean is there a common instruction prefix or processor state (such as a register) that can be checked?', 11, 1, 'N', 1435219372, 1443047194, NULL, 'A', 'N', 0, 'N'),
(60, 47, 'blog', 'Github', 'https://github.com/eva-thien', 'github', ' Remember the human. When you communicate online, all you see is a computer screen. When talking to someone you might want to ask yourself "Would I say it to the person''s face?" or "Would I get jumped if I said this to a buddy?". ', 8, 0, 'N', 1435476872, 1443283847, NULL, 'A', 'N', 0, 'N'),
(61, 77, 'questions', 'Functions in View', NULL, 'functionsinview', 'So in my project i need to count how many comments each articles has , is there any way that i can run a function on my view ? Or a diffrent method ?\r\n\r\n```\r\n    <?php foreach( $articles as $id => $article ): ?>\r\n    <div class="day"><?=(new DateTime($article->date))->format("d")?></div>\r\n    <a class="comments pull-right" href="#"> 0 Comments </a>\r\n    <?php endforeach; ?>\r\n```', 6, 1, 'N', 1435889323, 1438235737, 1437929152, 'A', 'N', 0, 'Y'),
(62, 59, 'questions', 'how to tell if an attribute exists', NULL, 'howtotellifanattributeexists', 'Hi,\r\n\r\nI''m using $attribValue = $this->readAttribute(AppModel::FIELD); to get the value of this model/attribute.\r\n\r\nIf the field not exists, I have value is $attribValue = null, but the field, if exists, can contain null values too.\r\n\r\nso ... how do I know if the field/attribute exists and what its value?\r\n\r\nsorry for my english', 11, 2, 'N', 1435890003, 1442997260, NULL, 'A', 'N', 0, 'Y'),
(63, 77, 'questions', 'Count total records with limit', NULL, 'counttotalrecordswithlimit', 'Hi, I''m trying to implement a rest server and some of my request have a lot of data.\r\n\r\nAs I''m using ionic to consume this api, I''m avoiding returning all the dataset on the first fetch, so I implemented a "infinite scroll" that request new data evertyime the page reachs the bottom, basically a pagination.\r\n\r\nI need to inform in the app how many records I have in total and array.length in javascript will not help me (since I get the data by pieces).\r\n\r\nAlso, on Phalcon, when I call count on a ResultSet it return the count of the results on the ResultSet, so, if I apply a limit 0, 50 and count it will return 50.\r\n\r\nThere''s any way to get the total number of records as if I haven''t used limit instead of creating 2 queries (1 with the limit the fetch right and another without the limit to do the count)?\r\n\r\nThanks and sorry about the bad english', 9, 1, 'N', 1435891064, 1437494554, NULL, 'A', 'N', 0, 'Y'),
(64, 77, 'questions', 'Introducing Built with Phalcon', NULL, 'introducingbuiltwithphalcon', 'Today we are launching a new site that would help us spread the word about Phalcon and show where Phalcon is used, whether this is production applications, hobby projects or tutorials.\r\n\r\nIntroducing builtwith.phalconphp.com\r\n\r\nTaking the example from our friends at AngularJS we have cloned their repository and we have Phalcon-ized it. Special thanks to the AngularJS team as well as Ole Aass who is leading the project.\r\n\r\nThe new site has a very easy interface that users can navigate to and even search for projects with tags. You can add your own project by simply cloning our repository and adding your project as well as a logo and screenshots and then issue a pull request for it to appear in the live site.\r\n\r\nLooking forward to seeing your projects listed up there!\r\n\r\n<3 The Phalcon Team', 16, 1, 'N', 1435892143, 1443075413, NULL, 'A', 'N', 0, 'N'),
(65, 77, 'blog', 'Phalcon Conference 2015', NULL, 'phalconconference2015', 'Hello hello,\r\n\r\nA couple of us are looking into the options of having a Phalcon Conference in 2015. We''d like to get some input from you guys as well, see how you feel about it and what we can expect in rough numbers.\r\n\r\nTake a look at this survey and let us know!\r\n\r\nIf there''s something not mentioned in the survey, respond to this thread with whatever you want to share. As long as it''s relevant to the survey and or conference.\r\n\r\n***Thanks!***\r\n\r\nupdated per 2014-11-25, The survey is Amsterdam specific now.', 16, 2, 'N', 1435892590, 1437749892, 1435992124, 'A', 'N', 0, 'N'),
(66, 78, 'questions', 'Phalcon/Zephir Funding Campaign', NULL, 'phalcon-zephir-funding-campaign', 'Hey Community,\r\n# Header {.sth}\r\n\r\n# Header {.sth}\r\n\r\n\r\nSince 3 years we have been working on Phalcon trying to improve it and move forward with the resources we have. Most of the work has been done in our spare time and with the great help of the community.\r\n\r\nIn the last year, due to our jobs and other responsibilities, progress in Phalcon has been a little bit slower, we would like this to change next year.\r\n\r\nWe are launching a campaign in Pledgie to promote the development of the framework and its sub-projects in order to bring Phalcon where we all want.\r\n\r\nFollowing is the summary of the campaign:\r\n\r\nWe are asking for 30,000 USD (~2,500 USD/month) that will be employed during the following year, at this ti some donations were already made, thanks to the donors for their assistance and support!. If you want to help, please support this project by donating to it. Donations of any size are gratefully accepted. We hope to soon reach 35% (10,500.00 USD) of the goal to create a non-profit organization and hire developers.\r\n\r\nHow will we use this money?\r\n\r\n\r\nPhalcon/Zephir goals\r\n\r\nAllow us to pay 1-2 fully-dedicated core developers for a year\r\nDevelop the most popular requests from the community on Github in a short and realistic time frame\r\nProvide high-quality answers and support in forums and StackOverflow\r\nRelease new versions constantly\r\nProvide a LTS (Long Term Support) version focused on the enterprise\r\nPhalcon specific goals\r\n\r\nImprove documentation covering a larger number of subjects in depth\r\nCreate more tutorials and examples focused on a novice, intermediate and advanced audience\r\nExtend test-suite achieving greater coverage and increasing framework quality\r\nZephir specific goals\r\n\r\nFinish the implementation of a JIT compiler for Zephir to facilitate testing and debugging of software created in this language\r\nCreate a debugger that facilitates the development of extensions in this language\r\nIncrease the number of backends that currently Zephir supports\r\nSupport future versions of PHP and maintain backwards compatibility with already released PHP versions\r\nExtend and improve the test-suite to verify what has been built also works.\r\nYou can donate here: https://pledgie.com/campaigns/27405\r\n\r\nIf you have any questions, feel free to ask.\r\n\r\nThanks!\r\n\r\n```\r\nvagrant && vagrant up\r\n```\r\n\r\n    <?php\r\n      echo "Aaaa"\r\n    ?>', 20, 5, 'Y', 1436285728, 1442984720, 1438497497, 'A', 'N', 0, 'Y');
INSERT INTO `posts` (`id`, `usersId`, `type`, `title`, `link`, `slug`, `content`, `numberViews`, `numberReply`, `sticked`, `createdAt`, `modifiedAt`, `editedAt`, `status`, `locked`, `deleted`, `acceptedAnswer`) VALUES
(67, 59, 'blog', 'Versioning is in beta(!), what do you think?', NULL, 'versioningisinbetawhatdoyouthink', 'We just launched this Big New Internet Thing, so we''d love some Big New Internet Feedback. What''s cool? What''s uncool? (The video? yeah, I agree!) Comment below and we can interface about increasing stakeholder satisfaction in a meaningful and organic manner.\r\n\r\n\r\n\r\nPhanbook is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Phanbook or suggest a new feature, please post it on Github issues. \r\n\r\n## Installing\r\n\r\nTo install Phalcon PHP you need to install php development, to get that just adding command below\r\n\r\n```\r\nsudo apt-get install\r\n```\r\n\r\nThe CSS background-image property allows us to apply one or more background images to any HTML element. In this video I will explain how to use the property, including how to write URL values correctly, and how to write local and absolute paths to images.\r\n\r\nThis is one lesson from my Getting Started with CSS course on Learnable. If you enjoyed the video, check out the course. See you there!\r\n\r\n## Conculsion\r\n\r\nThe CSS background-image property allows us to apply one or more background images to any HTML element. In this video I will explain how to use the property, including how to write URL values correctly, and how to write local and absolute paths to images.\r\n\r\nThis is one lesson from my Getting Started with CSS course on Learnable. If you enjoyed the video, check out the course. See you there!', 8, 1, 'N', 1436695505, 1443210420, 1437016838, 'A', 'N', 0, 'N'),
(68, 59, 'questions', ' Introducing Built with Phalcon', NULL, 'introducingbuiltwithphalcon', 'Today we are launching a new site that would help us spread the word about Phalcon and show where Phalcon is used, whether this is production applications, hobby projects or tutorials.\r\n\r\nIntroducing builtwith.phalconphp.com\r\n\r\nTaking the example from our friends at AngularJS we have cloned their repository and we have Phalcon-ized it. Special thanks to the AngularJS team as well as Ole Aass who is leading the project.\r\n\r\nThe new site has a very easy interface that users can navigate to and even search for projects with tags. You can add your own project by simply cloning our repository and adding your project as well as a logo and screenshots and then issue a pull request for it to appear in the live site.\r\n\r\nLooking forward to seeing your projects listed up there!\r\n\r\n<3 The Phalcon Team', 6, 21, 'N', 1436774335, 1438223821, NULL, 'A', 'N', 0, 'N'),
(69, 59, 'blog', 'Provisioning Phalcon (and other tools) with Vagrant', NULL, 'provisioningphalconandothertoolswithvagrant', 'Matthew Setter''s last article on PuPHPet covered the easy GUI-backed creation of Vagrant VMs. PuPHPet is an absolutely awesome tool in getting up and running with a development environment really fast, and offers some very neat default options.\r\n\r\nBut what if we want to step outside the defaults? What if we''d, for example, like to install a PHP extension that isn''t part of the default distribution and doesn''t exist in package managers?\r\n\r\nIn this tutorial, we''ll make sure the Phalcon framework is installed by default when we run vagrant up. Pre-installing software on a Vagrant VM is called provisioning.\r\n\r\n\r\n## Getting ready\r\n\r\nPlease walk through Matthew''s article before moving along with this one. Simply make sure you download a ready PHP-enabled VM.\r\n\r\nIn this particular case I used PHP 5.4 with Ubuntu (5.5 won''t work with it just yet via PuPHPet), but if you''ve got your own configuration you''re used to, please feel free to use it – just make sure you can get to a good phpinfo screen before continuing. Make certain your PHP configuration works and you can access the VM through the browser and execute a PHP script like\r\n\r\n## The basics of Provisioning\r\n\r\nVagrant offers several ways to provision software into your Virtual Machines. There''s Puppet (what PuPHPet is based on), Chef, Docker, and more. What we''ll be using is pure good old shell commands – Vagrant can execute a shell file we write if we pass it to its provisioning settings.\r\n\r\nSo, let''s say you need to install the text editor joe and want to do it through shell. In your PuPHPet folder''s shell subfolder, you would create a joe.sh file with the following contents:\r\n\r\n\r\n    #!/bin/bash\r\n    sudo su\r\n    apt-get install joe\r\n\r\n\r\n```\r\n\r\nThis shell script first identifies itself as executable by bash (optional), requests superuser permissions, and then it installs joe through the regular channels. To actually have this executed, we modify the Vagrantfile in the PuPHPet folder by adding the line\r\n\r\n```\r\nconfig.vm.provision :shell, :path => "shell/joe.sh"```\r\n\r\n## Installing Phalcon\r\n\r\nAs per Phalcon''s online installation instructions, the compilation process is straightforward:\r\n\r\n    git clone git://github.com/phalcon/cphalcon.git\r\n    cd cphalcon/build\r\n    sudo ./install\r\n\r\nHowever, we also need to enter phalcon.so into the PHP configuration, restart the server, and make sure all the prerequisites are installed (they are, PuPHPet took care of that for us). Let''s do this step by step.\r\n\r\nIn the shell subfolder again, create the file install_phalcon.sh. Give it the following content:\r\n\r\nNow if you re-run vagrant up after running vagrant destroy, you can see the phalcon.so extension in the PHP extensions folder:\r\n\r\n\r\nFirst, we create a phalcon.ini file in the /etc/php5/mods-available directory. We could echo it directly into php.ini, but this is just cleaner. Then, we symlink that newly created file to all the locations from where PHP can be run: Apache, command line and FPM. That way, all our potential PHP runtimes have Phalcon available. Finally, we restart Apache.\r\n\r\nIf you try running vagrant up now (after running vagrant destroy), you''ll notice the phpinfo screen displaying Phalcon as loaded after you re-visit the VM''s IP in your browser.\r\n\r\nBut what if the server process is named differently? For example, if it''s "httpd", or just "apache", and not "apache2"? Furthermore, what if we''ve got a different distro? On CentOS phalcon.ini should go to /etc/php.d/, and on other distros into other locations. Finally, what if we only do a vagrant halt and then run vagrant up but force a re-provision with the --provision flag? Wouldn''t it be better to simply ignore the Phalcon installation if it''s already installed?\r\n\r\nLuckily, slogsdon took all this into account for us. He built an excellent Phalcon installation shell script, ripe with IF clauses and more, and even created a phalcon-tools installation script.\r\n\r\nTo install Phalcon with all the above taken into account, place install_phalcon.sh into the shell folder of your PuPHPet download, and add it to the provisioner like we did for joe before. If you''d like to install Phalcon tools, do the same with install_phalcon-devtools.sh. That''s all you need to do – the script accounts for different servers and setups so all you need to do is have it run.\r\n\r\nNow you too can have an out-of-the-box ready Phalcon installation ready for development at the snap of your fingers. Naturally, you''ll need to do some additional tweaks to get URL rewriting to work on Nginx (just follow the Phalcon docs), but once the extension is installed and loaded by PHP, the hard part is over. What''s best, you can use this approach to install Phalcon on any of the PuPHPet supported environments as well – Digital Ocean, Rackspace or AWS. Just plug slogsdon''s shell into the provision settings, and you''re ready to go!\r\n\r\n##Conclusion\r\n\r\nIn this tutorial, we covered the basics of provisioning via shell and installed Phalcon (and joe) with a booting VM. Coming soon is a followup article from Matthew Setter which will deal with further customizations of the downloaded provision settings from PuPHPet.\r\n\r\nTo get familiar with the full workflow of Vagrant and Puppet, please do keep following this series as it''s about to get a whole lot more interesting!\r\n\r\nIf you have any comments, uncertainties, problems or just general feedback, please leave it in the comments below and I''ll do my best to address it as soon as possible! If you''ve got your own setup you''d like to share with the rest of us, do get in touch with me via +BrunoSkvorc and we''ll talk', 4, 0, 'N', 1437029974, 1437831289, NULL, 'A', 'N', 0, 'N'),
(70, 59, 'blog', ' Have you ever got hired for working with Phalcon?', 'abc.com', 'haveyouevergothiredforworkingwithphalcon', 'Phalcon, throught the last years, has grown to a full grown up framework that clashes any other big player in the market. With many advantages, the biggest still being performance for me, Phalcon slowly put the distrust of "that C framework" in the past to become a tool that seduce more and more PHP devs.\r\n\r\nAnd by dragging more attention, the community grew. Grew to the point there are probably some places actively relying into Phalcon as their main framework. So, with a bigger community, and jobs related to Phalcon starting to appear, here goes my questions.\r\n\r\nHave you ever been contacted for some job related with Phalcon?\r\n\r\nHave you already experiencied freelance offers or consulting requests?\r\n\r\nDo you have some business/startup that is using Phalcon and are seeking for devs?\r\n\r\nIf so, please share your experiences here. :)', 7, 3, 'N', 1437280485, 1438223215, NULL, 'A', 'N', 0, 'N'),
(71, 59, 'blog', 'Developer devops', NULL, 'developerdevops', 'The following instructions will automatically download and provision a virtual machine for you to begin hacking\r\non Phanbook with:\r\n\r\n### Getting Started\r\n\r\n1. Install Git: http://git-scm.com/downloads (or [GitHub for Windows](http://windows.github.com/) if you want a GUI). Recommend use github for Windows\r\n2. Install VirtualBox: https://www.virtualbox.org/wiki/Downloads\r\n3. Install Vagrant: http://www.vagrantup.com/ (We require Vagrant 1.7.2 or later)\r\n4. Open a terminal\r\n5. Clone the project: `git clone https://github.com/Phanbook/phanbook.git`\r\n6. Enter the project directory: `cd Phanbook` (Recommendation Create your workspace directory and clone project there. C:/workspace/phanbook/)\r\n\r\n### Using Vagrant\r\n\r\nWhen you''re ready to start working, boot the VM:\r\n\r\n    chmod +x phanbook.sh && ./phanbook.sh up\r\n\r\nOr you can runninng via command below\r\n\r\n```\r\ncd opsfiles && vagrant up\r\n```\r\n\r\nVagrant will prompt you for your admin password. This is so it can mount your local files inside the VM for an easy workflow.\r\n\r\n(The first time you do this, it will take a while as it downloads the VM image and installs it. Go grab a coffee.)\r\n\r\n**Note to Linux users**: Your Phanbook directory cannot be on an ecryptfs mount or you will receive an error: `exportfs: /home/your/path/to/Phanbook does not support NFS export`\r\n\r\n**Note to OSX/Linux users**: Vagrant will mount your local files via an NFS share. Therefore, make sure that NFS is installed or else you''ll receive the error message:\r\n\r\n```\r\nMounting NFS shared folders failed. This is most often caused by the NFS\r\nclient software not being installed on the guest machine. Please verify\r\nthat the NFS client software is properly installed, and consult any resources\r\nspecific to the linux distro you''re using for more information on how to\r\ndo this.\r\n```\r\n\r\nFor example, on Ubuntu, you can install NFS support by installing nfs-kernel-server with `apt-get install`.\r\n\r\nOnce the machine has booted up, you can shell into it by typing:\r\n\r\n```\r\n./phanbook.sh ssh\r\n```\r\nOr\r\n\r\n```\r\ncd opsfiles && vagrant ssh\r\n```\r\n\r\nThe Phanbook code is found in the /usr/share/nginx/html/www directory in the image.\r\n\r\n**Note to Windows users**: You cannot run ```vagrant ssh``` from a cmd prompt; you''ll receive the error message:\r\n\r\n```\r\n`vagrant ssh` isn''t available on the Windows platform. You are still able\r\nto SSH into the virtual machine if you get a Windows SSH client (such as\r\nPuTTY). The authentication information is shown below:\r\n\r\nHost: 192.168.33.33\r\nPort: 2222\r\nUsername: vagrant\r\nPrivate key: C:/Users/Your Name/.vagrant.d/insecure_private_key\r\n```\r\n\r\nAt this point, you will want to get an SSH client, and use it to connect to your Vagrant VM instead. We recommend\r\nPuTTY:\r\n\r\n**[PuTTY Download Link](http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html)**\r\n\r\nYou may use this client to connect to the VM by using ```vagrant/vagrant``` as your username/password, or by [using\r\nPuTTYGen to import the insecure_private_key file](http://jason.sharonandjason.com/key_based_putty_logins_mini_how_to.htm)\r\n(mentioned above) into a PuTTY profile to quickly access your VM.\r\n\r\n### Let''s contribution for phanbook.\r\n1. checkout your new branch (feature/your-name-branch)\r\n\r\n```\r\n$ ## creating new branch\r\n$ git checkout -b feature/{your-new-branch-name}\r\n```\r\n2. commit your files and let''s push\r\n\r\n```\r\ngit push origin feature/{your-new-branch-name}\r\n```\r\n\r\n### Shutting down the VM\r\n\r\nWhen you''re done working on Phanbook, you can shut down Vagrant with:\r\n\r\n```\r\ncd opsfiles && vagrant halt\r\n```\r\n\r\nor you can running \r\n\r\n```\r\n./phanbook.sh halt\r\n```\r\n', 10, 15, 'N', 1438149466, 1443301116, 1438149551, 'A', 'N', 0, 'N'),
(72, 59, 'blog', ' Phalcon vs Laravel', NULL, 'phalconvslaravel', 'I''m currently in a debate with some co-workers about which framework to use for our next mid sized buisness application.\r\nI''m trying to evangelize Phalcon and he favors Laravel. One point of contention is the ORM.\r\n\r\nHe basically says that Larvel:Eleoquent is better than Phalcon:ORM because it can more easily save related records. Here is an excerpt from Laravel...\r\n\r\n> you will often need to insert new related models. For example, you may\r\n> wish to insert a new comment for a post. Instead of manually setting\r\n> the post_id foreign key on the model, you may insert the new comment\r\n> from its parent Post model directly:', 7, 0, 'N', 1438225705, 1443162350, NULL, 'A', 'N', 0, 'N'),
(73, 59, 'blog', ' Phalcon vs Laravel', NULL, 'phalconvslaravel', 'I''m currently in a debate with some co-workers about which framework to use for our next mid sized buisness application.\r\nI''m trying to evangelize Phalcon and he favors Laravel. One point of contention is the ORM.\r\n\r\nHe basically says that Larvel:Eleoquent is better than Phalcon:ORM because it can more easily save related records. Here is an excerpt from Laravel...\r\n\r\n> you will often need to insert new related models. For example, you may\r\n> wish to insert a new comment for a post. Instead of manually setting\r\n> the post_id foreign key on the model, you may insert the new comment\r\n> from its parent Post model directly:', 0, 0, 'N', 1438225781, 1438315497, NULL, 'A', 'N', 1438315497, 'N'),
(74, 59, 'blog', ' Phalcon vs Laravel', NULL, 'phalconvslaravel', 'I''m currently in a debate with some co-workers about which framework to use for our next mid sized buisness application.\r\nI''m trying to evangelize Phalcon and he favors Laravel. One point of contention is the ORM.\r\n\r\nHe basically says that Larvel:Eleoquent is better than Phalcon:ORM because it can more easily save related records. Here is an excerpt from Laravel...\r\n\r\n> you will often need to insert new related models. For example, you may\r\n> wish to insert a new comment for a post. Instead of manually setting\r\n> the post_id foreign key on the model, you may insert the new comment\r\n> from its parent Post model directly:', 8, 0, 'N', 1438225810, 1443297418, NULL, 'A', 'N', 0, 'N'),
(75, 59, 'blog', 'WordPress as a Framework', NULL, 'wordpressasaframework', 'WordPress is one of the most popular CMS (Content Management Systems) as far as the user base and ease of access is concerned. Many famous content rich websites use WordPress as their back-end – including SitePoint itself. Regular updates, a larger community, great support forum, rich documentation and many other factors have put WP way ahead of its competitors.\r\n\r\nThe first thing that comes to most people’s minds when thinking of WordPress is Blog or Content Management Platform, but there is another angle to it. Have you considered that it can act as a full framework for developing web applications as well?\r\n\r\nThere are various aspects which are taken into consideration before choosing a framework for web development. In this piece, we are going to look into features that WP provides if we treat it as a web development framework.', 7, 0, 'N', 1438226079, 1443202514, NULL, 'A', 'N', 0, 'N'),
(76, 59, 'blog', 'About us', NULL, 'about-us', 'Phalconjobs  provides cutting-edge content for web professionals — developers, designers, programmers, freelancers and site owners.\r\n\r\nFounded by Thien; our mission is to deliver new ideas, emerging concepts, and teach state-of-the-art technology to our readers. Whether it’s via our practical tutorials, books, articles, courses, if it’s got anything to do with building the web - we''ve got you covered.', 7, 0, 'N', 1438226275, 1443089100, 1438327058, 'A', 'N', 0, 'N'),
(77, 59, 'blog', 'Working with Models', NULL, 'working-with-models', 'A model represents the information (data) of the application and the rules to manipulate that data. Models are primarily used for managing the rules of interaction with a corresponding database table. In most cases, each table in your database will correspond to one model in your application. The bulk of your application’s business logic will be concentrated in the models.\r\n\r\nPhalcon\\Mvc\\Model is the base for all models in a Phalcon application. It provides database independence, basic CRUD functionality, advanced finding capabilities, and the ability to relate models to one another, among other services. Phalcon\\Mvc\\Model avoids the need of having to use SQL statements because it translates methods dynamically to se engine operations.', 5, 0, 'N', 1438226363, 1443080600, 1438327213, 'A', 'N', 0, 'N'),
(78, 78, 'questions', 'test nuumber tag', NULL, 'test-nuumber-tag', 'Phanbook is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Phanbook or suggest a new feature, please post it on Github issues.', 0, 0, 'N', 1438327237, 1438525097, NULL, 'A', 'N', 1438525097, 'N'),
(79, 78, 'questions', 'test nuumber tag', NULL, 'test-nuumber-tag', 'Phanbook is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Phanbook or suggest a new feature, please post it on Github issues.', 0, 0, 'N', 1438327342, 1438525090, NULL, 'A', 'N', 1438525090, 'N'),
(80, 78, 'questions', 'test nuumber tag', NULL, 'test-nuumber-tag', 'Phanbook is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Phanbook or suggest a new feature, please post it on Github issues.', 0, 1, 'N', 1438327369, 1438525085, 1438333194, 'A', 'N', 1438525085, 'N'),
(81, 78, 'questions', 'TEST tAG', NULL, 'test-tag', 'Phalcon\\Mvc\\ModelPhalcon\\Mvc\\ModelPhanbook is an open source project and a volunteer effort. Help us make this a great place for discussion and collaboration. Please spend some time browsing the topics here before replying or starting your own, and you''ll have a better chance of meeting others who share your interests or have had similar problems. If you want to report any bug related to Phanbook or suggest a new feature, please post it on Github issues.\r\n', 5, 0, 'N', 1438333233, 1443286088, NULL, 'A', 'N', 0, 'N'),
(82, 2, 'pages', 'About', NULL, 'about', 'Phanbook is the next-generation Q&A and forum software that makes online discussion, question and answer site for professional and enthusiast people. Also the name Phanbook is mean - Phan(Phalcon PHP)book(the your note book)', 0, 0, 'N', 1442994492, 1442994492, NULL, 'A', 'N', 0, 'N');

-- --------------------------------------------------------

  `token` varchar(32) NOT NULL,
  `userAgent` varchar(120) NOT NULL,
  `createdAt` int(10) unsigned NOT NULL
) ENGINE=InnoDB AUTO_INCREMENT=74 DEFAULT CHARSET=utf8;

--
-- Dumping data for table `rememberTokens`
