News2005-11-27 -
- Continue to test some different designs. Need to do some serious graphics work soon....
- The internal redesign is pretty much complete with the new one page design and parameters controlling what will be shown. 2005-11-26 -
These are the first steps to the new design of the site
- Removed the frameset and moved the menu into the pages.
- All pages are now displayed via index.php. The different sub pages and functions are included into that page. 2005-11-24 -
New items for VU7.8 added.
Trying to speed up the database responses which will lead to faster results when displaying pages. During this procedure many debug and sql messages will be shown. The results will not always work etc.
The changes lead to extreme improvements in loading time.
- View item and designs is fixed
- View types is fixed
- Missing BPs/designs and TT values fixed
- Crafting Wizard fixed
- Synched the type names with the names used in PE Auction
- Added Timber as a new type
- Crafting Wizard will now show all components
- Crafting Wizard has new delimiters between the different types
- Rearranged the dropdowns in the Crafting Wizard due to the need of more space
- Changed the design of the menu (a larger and more extensive update of the user interface will come. No ETA)
- Removed almot all stats and item images since most of them have changed. Will start over with new images. 2005-11-19 -
Upgraded MySQL from v.3.23 to v.5.0 which caused a few problems with some automatically created tables. It is fixed now and everything should work as before the upgrade.
In v.3.23 views couldn't be used which I used for all data in the old MS SQL database. My work-around was to create tables which simultated views. A huge script extracted data from the main tables, created new tables and inserted the transformed data. That script caused the problems now. NULL values were handled differently. I will change back to using views now since it is supported in the new version of MySQL.
I made an emergency fix and changed to views right away. When I test it feels like it is going slower than before...
Current BUGS after the upgrade:
- The crafting wizard has some problems with php commands atm. FIXED
- Missing BPs/Designs not working. FIXED
- "Designs which require this item" not working. FIXED
- Slow FIXED
- PHP 4 not working good with MySQL 5 atm... FIXED 2005-11-17 -
All prices on minerals, enmatter, materials and alien parts are now automatically updated with values from MyTwoPecs.com
Thank you for some very useful XML files.
I created a php script that parse the XML files, a shell script will send the php script to lynx (a text browser for web pages). The shell script is set as a cron job that will run every day at 06:15 AM CET. 2005-11-08 -
Added new VU7.7 BPs and the new category Furniture
Added furniture components to the natural resource category. Maybe they will end up in another category later on when we see the whole picture. 2005-11-07 -
I just received a reply from kb.se for my abuse report...
It was one of the robots for the project: "Kulturarw3- Long time preservation of electronic documents" http://www.kb.se/kw3/ENG/
Pretty embarrassing to report a robot for abuse ... lol 2005-10-27 -
Added a new category called "Limited attempts". Moved Nano Katana (L) to the new category. 2005-10-27 -
I just discovered something very strange with the database. Many many items and designs are missing. I got a recent backup and it should be no problem to restore the database to the state it was 2 days ago, but I need to check this up...
Maybe someone found out the login. The security for the admin interface is terrible and after this I will add something better...just in case...
Ok, database restored. Increased the security for the admin interface :) 2005-10-27 -
I checked my logs and found the entries when items in the database were deleted.
IP: 193.10.249.67
Start: 27/Oct/2005:01:53:05
End: 27/Oct/2005:04:43:36
inetnum: 193.10.249.0 - 193.10.249.255
netname: SE-KB
descr: Kungliga Biblioteket
country: SE
Abuse report sent to abuse@sunet.se 2005-10-12 -
Maybe it is time to add all component BPs to the Crafting Wizard since Nano Katana (L) is using Basic Rings in the design....
Added all new BPs (not the designs)
Also removed the "Uncolored" text from all Tailoring BPs with a nice little SQL-statement (just a little proud of it :-):
update item
set name = RIGHT(name,LENGTH(name)-10)
where
name like '%uncolored%' and
type = 22; 2005-07-30 -
Fixed a bug in the crafting wizard that would result in an error if an item with no designs was selected.
I also added a small update of the combo boxes in the wizard that will make it easier to find the correct material. 2005-05-27 -
Bob the Builder is now moved to my new Linux server.
The ASP code has been converted to PHP and the data in M$ SQL is moved to MySQL.
Both the site and database is on the same server which should increase performance and uptime compared to the old solution with the site on my commercial Windows Server and database on one of my home servers.
It took me about a month to get everything up and running... :D
If you see any strange, it would be really good if you report it right away to me: bob@candyman.se 2005-01-27 -
Today I created a nice little function that I think is very useful.
I was in urgent need of some money so I started to craft with everything I had in my storage, but realized that it was way too hard to find the designs that used the specific materials I had stored....
Hmmm....why not create a function where you can enter the type of material you would like to use and then get the designs that uses that material?
Four hours later....Bob the Builder's Crafting Wizard saw the light!
You find the link "Crafting Wizard" in the menu.
I've coded non stop for several hours and the new function hasn't been tested so much so a few bugs might be there.
Please, report them to me and try to explain what you did if you find any.
Bug that might be some kind of feature: Some unexpected effects in the left table that shows "Designs which uses only the
selected materials". The idea was to show only the designs that uses all the materials selected, but it seems to combine the materials to get all possible designs from the materials selected....not sure yet....I think it is good if it works in that unexpected way :) |