Posts tagged MySQL
WordPress – How to Delete Existing Post Revisions
0
This is the second part of managing WordPress feature of post revisions, for the users who had disabled or turned off post revisions tracking or versions history feature. As you already know, this feature exists in WordPress (starting with WordPress 2.6). After disable it (of course, if you really need to do that), it also make sense to also delete and remove all existing stored post revisions. By doing so, you’ll remove changes made on pages stored in the database such that you’ll slim down the wp_posts table size´. This is especially recommended when there is already lots of revisions or changes inside.
WordPress – managing Post Revisions Tracking
1 A very interesting feature added in WordPress blog publishing system since version 2.6 is the post revisions tracking, like in version control systems. It simply adds a Wiki-like style tracking of edits that had been made to the posts or pages. This allows bloggers and authors to view, control and moderate – knowing who and when made what changes to any post or page. It also includes the ability to compare for differences between each saved versions, or revert back to older version.
BNR exchange rate
0 
In this global crisis, nothing is more useful than a good chart to watch your money as investment. That’s why I created a special page which collects freely available exchange rates from BNR (National Romanian Bank) and presents them in a graphical form. This way, the viewers of my website will always be on the edge with exchange rates, as soon as BNR posts them (usually around 13:00 GMT+2).
The main challenges were:
- Building a php script to parse XML, inserting the exchange rates into database. The lack of experience and debugging tools made a huge difference in development time. But all is working now.
- Creating a php script that will daily update the exchange rates, so the users will have the fresh rates at their disposal as soon as possible.
- Design the page that hosts the chart and provide create the appropriate data structure which will feed the chart with data.
- learn to use a very interesting framework of representing data as charts – Google Visualisations
Next steps:
- Offer the posibility to choose among all 30 currencies for which the BNR provides exchange rates.
- implement AJAX for smooth behavior of refreshing the page while user chooses a different currency.
Enjoy!
Google Visualizations
0
While working on my idea of presenting on this website also the Romanian National Bank exchange rates (very useful in this crisis time), I end up in choosing a form of visualization.
One might argue that text is good enough, but for me frankly graphs and charts are the best. So I started looking on the internet for free and customizable charting tools.
From the plethora of choices on the web I will present just a few:
1. An interesting tutorial on how to build a chart of your own – it’s the easy way to get exactly what you need done as it should be. It is quite old, but still actual, as Macromedia MX programming is still supported in Adobe CS3
2. OpenFlashChart GWT Library – very interesting, free library and highly customizable. But it comes with a big drawback : it has approx 375 Kb .. quite big for my requirements.
3. Origamy Flash graph component – amazingly nice and costly . 99$ ..
4. Google visualization – free, fast, light and with a ton of settings. They have pies, tables, charts … with really lots of settings. The added traffic isn’t much … around 30 kb per graph ( and I measured biggest one – Annotated time line ).
Change Browser’s UserAgent
0The question of What’s that user agent string used for? should has been duly answered in the previous post. The next question is about How to change or spoof user agent string?
The structure of Internet Explorer user agent string.
The template of user agent string used by Microsoft Internet Explorer.
Why there is a need to change or spoof user agent string?
Well, this question should have been answered in the previous post too. In short, changing or spoofing user agent string is needed when online security is a concern or to bypass web services access restriction for certain type of web browser.
For example, Adobe Reader download site will display different download page according to the web browser that visiting the site, limit or auto pick up Adobe Reader version for the OS type in the user agent string, force Adobe Updater to manage Adobe Reader download progress. So, by changing the user agent string, one can directly download any Adobe Reader version of any platforms or languages with Internet Explorer or Mozilla Firefox, without using the Adobe Updater or Opera web browser!
How to change User Agent String of Internet Explorer?
For Internet Explorer 6 SP2 on Windows 2000 and IE7 For Windows XP, open up Windows Registry Editor to locate this Registry key:
HKLMSoftwareMicrosoftWindowsCurrentVersionInternet Settings5.0User Agent (more…)
Radu Poenaru » Master thesis – Related work
[...] me on twitter « Master Thesis – Introduction Master thesis – Concept [...]
3 weeks ago