vBProductMaker 1.5.1 – Free vBulletin Product development tool for Windows

February 25, 2009

programiconbighelp

April 02: x64 version is available for download!

Version 1.6.0 is released

click here for details!

vBProductMaker intended to help vBulletin product developers and make it little easy to manage their products and corresponding components. The skill level of users using this tool can vary from novice to advanced web programmers. It is combining code editor with syntax coloring, vBulletin-aware management console and XML builder, in order to produce final XML file which can be imported into vBulletin.

vBProductMaker is using internal file type in order to store and retrieve all information related to your vBulletin product. The file type is defined as .vbu . You can save your product as .vbu file and then later load it, modify and finally export to vBulletin XML product.

As the help contains most of information one can need, I will show several screenshots below.

general

plugins

templates

phrase

settings

programoptions

export

This is public beta version, feel free to test and report issues.

Requirements: .NET framework 2.0 or later

Download vBProductMaker 1.5.1

Advertisements

Backup your DB and files using batch file

January 29, 2009

I’ve been given a small task to backup our issue database on daily basis, for which I created a tiny backup file and would like to share with you.

The script below will do the following

  1. Create MySQL dump of your database using configuration set
  2. Compress files and MySQL dump into single archive file and copy to destination folder
  3. It will always create old backup so you always have previous version
  4. Copy both old and new backups to network shared resourse

@ECHO OFF
 REM ----------- START OF CONFIGURATION HERE
 SET DESTINATION_FOLDER=c:\dest\
 SET BACKUP_FILENAME=yourBackup.rar
 SET BACKUP_FILENAME_OLD=yourBackup.old.rar
 SET BACKUP_DB_FILENAME=backup.sql
 SET MYSQL_FOLDER=C:\wamp\bin\mysql\mysql5.1.30\bin\
 SET MYSQL_DB_NAME=yourdbname
 SET MYSQL_DB_USER=yourdbuser
 SET MYSQL_DB_PASS=yourdbpass
 SET NETWORK_PATH=\\your_backup_pc_ip\path
 SET NETWORK_USERNAME=your_backup_pc_user
 SET NETWORK_PASSWORD=your_backup_pc_pass
 REM ----------- END OF CONFIGURATION HERE

CD %~dp0

%MYSQL_FOLDER%mysqldump.exe -u %MYSQL_DB_USER% -p%MYSQL_DB_PASS% %MYSQL_DB_NAME% >%BACKUP_DB_FILENAME%
 ECHO DB Done

rar a %BACKUP_FILENAME% @files.lst > NUL
 @del %DESTINATION_FOLDER%%BACKUP_FILENAME_OLD% 2>NUL
 @rename %DESTINATION_FOLDER%%BACKUP_FILENAME% %BACKUP_FILENAME_OLD% 2>NUL
 copy %BACKUP_FILENAME% %DESTINATION_FOLDER% > NUL
 ECHO Files Done

@del %BACKUP_FILENAME% 2>NUL
 @del %BACKUP_DB_FILENAME% 2>NUL
 ECHO Removing Temporary Files Done

ECHO Accessing Network...
 net use %NETWORK_PATH% %NETWORK_PASSWORD% /user:%NETWORK_USERNAME%
 copy %DESTINATION_FOLDER%%BACKUP_FILENAME% %NETWORK_PATH% > NUL
 copy %DESTINATION_FOLDER%%BACKUP_FILENAME_OLD% %NETWORK_PATH% > NUL
 ECHO Network Copy Done

ECHO All Done

To make backup regular I’ve used Cron NT service for Windows because I honestly don’t like Windows Scheduler and always disable it 😉
Here is the crontab line that suits my needs.

10 23 * * * cmd /c C:\wamp\backup\backup.bat

This will backup my stuff every day at 23:10.

That’s pretty much it.
Cheers!


JM20337 read data corruption – solution

December 8, 2008

Some time ago I bought hard drive enclosure. To my surprise recently I’ve found out that read operation is giving random corrupted data, in other words if you copy data from IDE HD connected to that enclosure, your fill will be corrupted on target media. Without any hope that I will get some answer, I wrote an e-mail to enclosure chipset vendor – JMicron. To my second surprise I got immediate response from very kind person Alex Lee working in that company. He was very prompt and professional and eventually helped to fix the problem, which was enclosure vendor design issue rather than chipset. I will share with this information just in case if some one else need it.

The enclosure box I bought is below. The model NTY-M35HD. I bought it from South Korean local market online, through gmarket.co.kr.

boxThe chipset used is JM20337.
Some PCB pictures of my enclosure.

enc13

enc2

And here goes recommended patch, click on the picture to see full size. Basically you have to remove resistor R15 4.72k.

image0011Click on the picture to zoom and see that resistor.

Right after patch I have created a batch file for continuous reading / comparing over 2 days and not a single error.

So I want to thank Alex Lee for his great work and JMicron company for amazing products which I believe are leading in the market.

Update March 16, 2009
Here is very tiny batch file to help you test your adapter and/or hard drive. It will continuously copy/compare large file [provided by you] and terminate either when data mismatch found or you press Ctrl+C. You can leave it run overnight.
Copy the following into datacheck.bat (use view plain link at the top of script) and save it anywhere in your hard drive.

@echo off
echo checking data
echo [press ctrl+c to terminate script]
:Loop

copy %1 %2 >nul
fc /b %1 %2 > nul
if ERRORLEVEL 1 GOTO Fail

GOTO Loop

:Fail
echo sorry, data corrupted...

Then goto Start -> Run -> cmd
type

cd path_where_you_copied_datacheck.bat 
datacheck.bat c:\bigfile.dat e:\bigfile.dat
c:\bigfile.dat - some really big file over 500MB
e:\bigfile.dat - your USB drive connected through adapter with name of the target file

Now the script will continuously check data. Grab some tea, sit back, cross your fingers and relax 😉

Cheers!