Database Update Script (for MODs)

[Noobarmy]

I was just looking for suggestions on how this should really be done. For one of my mods (xData) i wish to provide a database update script from teh phpBB2 xData Mod's info into the phpBB3 Custom profile field info. Now i know how i can actually do this, with the SQL stuff ect, what i was more curious about however was how the script should work.

should it need to have the user enter the database information for both boards (phpbb2 & phpbb3) then it just takes the data changes it ect. or should it include the phpbb3 config and then request teh phpbb2 database information.

should i use the phpbb3 or the phpbb2 files (the database ones to be more specefic), or make the script work with both.

also shoudl i setup language vars in the language files? also should i setup templates. i figured because it was jsut an upgrade fiile it would be ok to put everything together in one file so it can simply be uploaded then deleted afterward.

i think this would be useful for anyone who's going to provide a database update script for their mods to port from phpbb2 to phpbb3, or if you've already written a script to update how did you do it?

thanks,
anthony

[igorw]

Go here and download a snapshot: http://area51.phpbb.com/cvs/

You have an upgrade script from phpBB2 to phpBB3. Edit that script to include your tables

[poyntesm]

Hmmm..been wondering this myself recently. If you edit the conversion script you can only help those as they convert not after they convert.

So I think you are best to have a upgrade script that is not part of the convertor...just my €0.02

I will be working on my upgrade script very soon as I am nearly finished converting my MOD and adding the features I plan for inital phpBB3 release.

[drathbun]

[igorw]

That's a good point

[Thoul]

Sorry to bump an old topic, but I wanted to ask: did anyone make an independent phpBB 2 -> phpBB 3 upgrade script for mods, as was discussed here? I've been thinking about providing such a script for one of my old mods (a friend/foe list). I can always make one myself, but I don't see any reason to reinvent it if someone already created one.

[igorw]

No problem,

i don't think anybody made a totally independent one, but i've included one in the [url=http://phpbbmodders.net/viewtopic.php?t=1692]Genders[/url] MOD, that is easy to change

[Thoul]

Thanks, I'll take a look at that.

[poyntesm]

I have customised the phpBB convertor and built my own convetor so I can handle all garage systems to phpBB

However in doing that I think you could use the existin UCF to convert a MOD, I needed to do some pretty complex stuff so wanted 100% control but I believe the UCF could have handled a simple MOD conversion.

The convertor is actually a nightmare to understand though ... its still stands as the bit I understand the least.