Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- //RDB TO SQL FOR db_characterMotion by Gr4ph0s
- //RELEASE ON EPVP
- #include <iostream>
- #include <fstream>
- using namespace std;
- struct db_charactermotion {
- int Motion_ID;
- int Race_ID;
- int Sex;
- char File_Name[256];
- int Frame_Length;
- int Play_Speed;
- int graphic_effect_file_ID;
- int Graphic_effect_speed_type;
- int Graphic_effect_position;
- char graphic_effect_follow;
- char graphic_effect_disappear;
- int sound_file_ID;
- int Sound_volumn;
- int Sound_play_probability;
- int Sound_timing;
- char sound_reverb_apply;
- char sound_filter_apply;
- char sound_stereo_apply;
- int fx_id;
- int fx_timing;
- int fx_position;
- int fx_play_speed;
- int Event01_id;
- int Event01_timing;
- int Event02_id;
- int Event02_timing;
- int Event03_id;
- int Event03_timing;
- int Event04_id;
- int Event04_timing;
- int Event05_id;
- int Event05_timing;
- int Event06_id;
- int Event06_timing;
- int Event07_id;
- int Event07_timing;
- int Event08_id;
- int Event08_timing;
- int Event09_id;
- int Event09_timing;
- int Event10_id;
- int Event10_timing;
- };
- int main()
- {
- int nbloop; //var for count number of loop
- ifstream RDB; //stream for read rdb
- ofstream SQL; //stream for write sql
- RDB.open("db_charactermotion.rdb", ios::in | ios::binary); //open RDB file
- if(!RDB)//if the file can't be open
- {
- cout << "Cannot open file.\n";
- return 1;
- }
- SQL.open("db_charactermotion.sql"); //open SQL file
- RDB.seekg(128, ios::beg); //We go over the header(128empty bit)
- RDB.read((char *) &nbloop,4);//we read 4bit(int) corresponding to the nb of line
- db_creaturefarm data[nbloop];//create array who will contening each information
- for(int i=0; i<nbloop; i++) //loop for read all data
- {
- RDB.read((char *) &data[i], sizeof(db_creaturefarm));//put each data from structure into
- }
- RDB.close(); //close RDB
- if(!RDB.good()) //If error durring reading(some time because you try to read more than you can)
- {
- cout << "A file error occurred.\n";
- return 1;
- }
- //Wrinting Drop & create for CreatureFarmResource
- SQL << "USE [Arcadia]\nGO\n\n/****** Object: Table [dbo].[CharacterMotion] Script Date: 03/21/2012 15:03:37 ******/\nDROP TABLE [dbo].[CharacterMotion]\nGO\n\nUSE [Arcadia]\nGO\n\n/****** Object: Table [dbo].[CharacterMotion] Script Date: 03/21/2012 15:07:49 ******/\nSET ANSI_NULLS ON\nGO\n\nSET QUOTED_IDENTIFIER ON\nGO\n\nSET ANSI_PADDING ON\nGO\n\nCREATE TABLE [dbo].[CharacterMotion](\n [motion_id] [int] NOT NULL,\n [race_id] [int] NOT NULL,\n [sex] [int] NOT NULL,\n [file_name] [varchar](256) NULL,\n [frame_length] [int] NOT NULL,\n [play_speed] [int] NOT NULL,\n [graphic_effect_file_ID] [int] NOT NULL,\n [graphic_effect_speed_type] [int] NOT NULL,\n [graphic_effect_position] [int] NOT NULL,\n [graphic_effect_follow] [tinyint] NOT NULL,\n [graphic_effect_disappear] [tinyint] NOT NULL,\n [sound_file_ID] [int] NOT NULL,\n [sound_volumn] [int] NOT NULL,\n [sound_play_probability] [int] NOT NULL,\n [sound_timing] [int] NOT NULL,\n [sound_reverb_apply] [tinyint] NOT NULL,\n [sound_filter_apply] [tinyint] NOT NULL,\n [sound_stereo_apply] [tinyint] NOT NULL,\n [fx_id] [int] NOT NULL,\n [fx_timing] [int] NOT NULL,\n [fx_position] [int] NOT NULL,\n [fx_play_speed] [int] NOT NULL,\n [event01_id] [int] NOT NULL,\n [event01_timing] [int] NOT NULL,\n [event02_id] [int] NOT NULL,\n [event02_timing] [int] NOT NULL,\n [event03_id] [int] NOT NULL,\n [event03_timing] [int] NOT NULL,\n [event04_id] [int] NOT NULL,\n [event04_timing] [int] NOT NULL,\n [event05_id] [int] NOT NULL,\n [event05_timing] [int] NOT NULL,\n [event06_id] [int] NOT NULL,\n [event06_timing] [int] NOT NULL,\n [event07_id] [int] NOT NULL,\n [event07_timing] [int] NOT NULL,\n [event08_id] [int] NOT NULL,\n [event08_timing] [int] NOT NULL,\n [event09_id] [int] NOT NULL,\n [event09_timing] [int] NOT NULL,\n [event10_id] [int] NOT NULL,\n [event10_timing] [int] NOT NULL\n) ON [PRIMARY]\n\nGO\n\nSET ANSI_PADDING OFF\nGO";
- for(int i=0; i < nbloop; i++)
- {
- SQL << "INSERT INTO [dbo].[CharacterMotion] ([motion_id] ,[race_id] ,[sex] ,[file_name] ,[frame_length] ,[play_speed] ,[graphic_effect_file_ID] ,[graphic_effect_speed_type] ,[graphic_effect_position] ,[graphic_effect_follow] ,[graphic_effect_disappear] ,[sound_file_ID] ,[sound_volumn] ,[sound_play_probability] ,[sound_timing] ,[sound_reverb_apply] ,[sound_filter_apply] ,[sound_stereo_apply] ,[fx_id] ,[fx_timing] ,[fx_position] ,[fx_play_speed] ,[event01_id] ,[event01_timing] ,[event02_id] ,[event02_timing] ,[event03_id] ,[event03_timing] ,[event04_id] ,[event04_timing] ,[event05_id] ,[event05_timing] ,[event06_id] ,[event06_timing] ,[event07_id] ,[event07_timing] ,[event08_id] ,[event08_timing] ,[event09_id] ,[event09_timing] ,[event10_id] ,[event10_timing])" <<
- "\nVALUES\n"<<
- "(" <<
- (int)data[i].Motion_ID << "," <<
- (int)data[i].Race_ID << "," <<
- (int)data[i].Sex << "," <<
- '"' << (string)data[i].File_Name << '"' << "," <<
- (int)data[i].Frame_Length << "," <<
- (int)data[i].Play_Speed << "," <<
- (int)data[i].graphic_effect_file_ID << "," <<
- (int)data[i].Graphic_effect_speed_type << "," <<
- (int)data[i].Graphic_effect_position<< "," <<
- (int)data[i].graphic_effect_follow << "," <<
- (int)data[i].graphic_effect_disappear << "," <<
- (int)data[i].sound_file_ID << "," <<
- (int)data[i].Sound_volumn << "," <<
- (int)data[i].Sound_play_probability << "," <<
- (int)data[i].Sound_timing << "," <<
- (int)data[i].sound_reverb_apply << "," <<
- (int)data[i].sound_filter_apply << "," <<
- (int)data[i].sound_stereo_apply << "," <<
- (int)data[i].fx_id << "," <<
- (int)data[i].fx_timing << "," <<
- (int)data[i].fx_position << "," <<
- (int)data[i].fx_play_speed << "," <<
- (int)data[i].Event01_id << "," <<
- (int)data[i].Event01_timing << "," <<
- (int)data[i].Event02_id << "," <<
- (int)data[i].Event02_timing << "," <<
- (int)data[i].Event03_id << "," <<
- (int)data[i].Event03_timing << "," <<
- (int)data[i].Event04_id << "," <<
- (int)data[i].Event04_timing << "," <<
- (int)data[i].Event05_id << "," <<
- (int)data[i].Event05_timing << "," <<
- (int)data[i].Event06_id << "," <<
- (int)data[i].Event06_timing << "," <<
- (int)data[i].Event07_id << "," <<
- (int)data[i].Event07_timing << "," <<
- (int)data[i].Event08_id << "," <<
- (int)data[i].Event08_timing << "," <<
- (int)data[i].Event09_id << "," <<
- (int)data[i].Event09_timing << "," <<
- (int)data[i].Event10_id << "," <<
- (int)data[i].Event10_timing << ")" <<
- "\nGo\n\n";
- }
- SQL.close(); //close SQL
- return 0; //exit
- }
Advertisement
Add Comment
Please, Sign In to add comment