Jump to content

gav240z

Administrators
  • Posts

    26,804
  • Joined

  • Last visited

  • Days Won

    560

Everything posted by gav240z

  1. Thanks mate, I actually discovered that the User IDs have changed between the old software to the new software. I ran this command. Which seems to have updated the comments table to include the correct author IDs. Just got to work out how to do it for the owner IDs. Worst case scenario I'll do it in a manual fashion...there is only about 300 unique rows.
  2. unlocked.
  3. http://auctions.yahoo.co.jp/jp/auction/v413158495 http://yahoo.kurumaerabi.com/html/201505/083/dd6fbee2_image.html http://yahoo.kurumaerabi.com/html/201505/083/dd6fbee2_movie.html HLS30 99667
  4. http://auctions.yahoo.co.jp/jp/auction/r128137347 Looks like a HS30-H replica. (Based on an S31). Asking 2.4M yen. Weird radiator support configuration..
  5. Well if you decide to part with it I'm interested mate. Sadly the last head unit I tried to buy the deal fell through.. I've got reproduction faceplates being made at the moment. Just waiting on the chrome to be done for the knobs etc.. I decided I'd put the original head units in both my 240z's. The switch is really the last missing piece.
  6. Found 1. http://www.ebay.com/itm/datsun-240Z-antenna-switch-assembly-series-1-new-nos-/301638335940 Buy It Now: US $179.00 Part no. 27357-E4100
  7. By the way as a follow up to this car. http://www.ebay.com/itm/-/281544553219 Looks like it finally sold US $49,340.00 More photos here: http://firsttraderegistry.com/forsale/10_14/70datsun/ Video:
  8. Fairlady Z (S30-S) - S30 05854 - sold a while back in the US for 21K USD http://www.ebay.com/itm/1971-Datsun-Z-Series-Fairlady-Z-240Z-/291407099055
  9. Really just putting this here for my own sake, but just in case anyone else is interested. I noticed that after converting the photo albums across to the new software that the albums lost their owners, along with comments etc.. Turns out that when you 'bridge' software (in this case Coppermine gallery and SMF forum) Coppermine defers to the SMF users tables (they share the same user tables) rather than creating their own independent tables. So what's the problem? This means Coppermines own user tables are blank (no users in them) the script to convert Coppermine to Invision Power Suite's Gallery can't convert these users because they don't exist in the table. Compounding the problem is the fact that when you convert from the old forum software to the new software a members unique ID changes, so a member with ID 2 before becomes 2048 or similar. I've been doing a few join statements in SQL to figure out how I can look up a specific user by ID and name and see how their ID has changed in the old system to the new, I'm hoping to use this information to update the database with the correct owners of albums etc.. Once I figure that out, I think that's the last major hurdle. Then I can upload a test version for people to experiment with and see if any issues come up before uploading and transitioning over. This looks like something I might need. http://stackoverflow.com/questions/12248413/replacing-a-sql-column-value-based-on-a-column-another-table
  10. Early 1970 built HLS30 car in Japan. http://page16.auctions.yahoo.co.jp/jp/auction/u78513713 L24 015253 was in HS30 00150, this engine number is lower than that, which seems to indicate that this car could indeed be HLS30 00854 Video here:
  11. Hi Ben, Do you have any 15z8 in 0 offset? http://www.viczcar.com/forum/index.php/topic,4438.msg156739.html#msg156739 I'm looking for the same size and stance as what's on Mossy's car. Are the prices on the website already updated to take 30% off? Cheers, Gavin
  12. Craigslist special. http://goldcountry.craigslist.org/cto/5027996592.html HLS30-96217 Currently on eBay. http://www.ebay.com/itm/Datsun-Z-Series-240z-/261888251027 4 days to go at US $14,000.00 currently. What would concern me with this car is that the rust is starting to come back after 5 years (since repaint). Chassis rails also look like the rears have been cut off. Passenger side chassis rail is beat up. Battery tray repair is 'interesting'. Sounds nice and seems to go well however.
  13. Locked for now until advised otherwise.
  14. Don't give it away, you couldn't build a car like this under 20K. However I'd give away the wheels . Don't put the flares on though, I'd find a nice set of 'period' looking wheels that fit the car nicely with stock guards. I guess value is difficult to determine because at this stage I'm not sure if 'original' or 'restomod' is where the money is with these cars, in my opinion though it's the 'original' cars that will prevail in values. Still the advantage of this is it's user friendly. Good luck with whatever you decide to do.
  15. I'd keep the Fat Pizza sticker on the side since it's part of it's history but 'restore' the rest. Interesting how the 260z alloys were widened like that for the rear? Didn't think you could do that with non split rims. I wonder how many 2 seaters exist in Australia?
  16. Ahh really thought it was a 2+2 gold find Lurch. How did you find it? Looks like Kobe Seiko KS wheels haha j/k but similar to the rally car look.
  17. George where is it advertised? Link?
  18. Hi mate, I have a question for you re: SQL. I've just converted the Gallery over and it seems to be working fine, except for the fact that each album that was previously created had an owner assigned to it. Now however the owners are blank (as in not defined). The old Coppermine Gallery table (cpg132_albums) has a couple of columns: 1. title = Album name 2. owner = member id The new Invision Power Gallery table (ips_gallery_albums) has the following corresponding columns: 1. album_name = Album name 2. album_owner_id = member id Where the left hand value before the = sign is the database column name. What I need to do is some kind of lookup for the old table, where I extract the title and owner columns and then insert them into the album_name and album_owner_id columns. Although interestingly I tried do manually update the album_owner_id value via phpmyadmin UI and it didn't seem to work... I'll look into that.
  19. Thanks mate, does the site seem any quicker to you today? In terms of response and page load times?
  20. Thanks for letting me know, I'll keep looking.
  21. *Edit sadly the seller decided not to send me this head unit and refunded my money. I wasn't happy, think he sold it elsewhere for more money. Don't deal with seller http://www.ebay.com.au/usr/1983quattro So I'm still looking for an antenna switch been watching eBay with no joy. Will take a broken switch also!
  22. Here is to your comeback... Bad WOG! (Warning some may find the scene sexually explicit haha)*.
  23. Video featuring Big Sam. (Driver Martin Sharpe)
  24. 2 knob Rally Clock on Yahoo! Auctions. http://page11.auctions.yahoo.co.jp/jp/auction/n149760050 No oscillator box though, I think it might still get $400 AU....Even in that shape..
  25. 1 more piece of the puzzle solved, looks like Avatars now move across more consistently, there is a few that are broken but the majority say 98% will move across. Yay!
×
×
  • Create New...