Guest User

Untitled

a guest
Nov 21st, 2012
296
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
C++ 6.86 KB | None | 0 0
  1. //RDB TO SQL FOR db_characterMotion by Gr4ph0s
  2. //RELEASE ON EPVP
  3. #include <iostream>
  4. #include <fstream>
  5. using namespace std;
  6.  
  7. struct db_charactermotion {
  8.   int Motion_ID;
  9.   int Race_ID;
  10.   int Sex;
  11.   char File_Name[256];
  12.   int Frame_Length;
  13.   int Play_Speed;
  14.   int graphic_effect_file_ID;
  15.   int Graphic_effect_speed_type;
  16.   int Graphic_effect_position;
  17.   char graphic_effect_follow;
  18.   char graphic_effect_disappear;
  19.   int sound_file_ID;
  20.   int Sound_volumn;
  21.   int Sound_play_probability;
  22.   int Sound_timing;
  23.   char sound_reverb_apply;
  24.   char sound_filter_apply;
  25.   char sound_stereo_apply;
  26.   int fx_id;
  27.   int fx_timing;
  28.   int fx_position;
  29.   int fx_play_speed;
  30.   int Event01_id;
  31.   int Event01_timing;
  32.   int Event02_id;
  33.   int Event02_timing;
  34.   int Event03_id;
  35.   int Event03_timing;
  36.   int Event04_id;
  37.   int Event04_timing;
  38.   int Event05_id;
  39.   int Event05_timing;
  40.   int Event06_id;
  41.   int Event06_timing;
  42.   int Event07_id;
  43.   int Event07_timing;
  44.   int Event08_id;
  45.   int Event08_timing;
  46.   int Event09_id;
  47.   int Event09_timing;
  48.   int Event10_id;
  49.   int Event10_timing;
  50. };
  51.  
  52. int main()
  53. {
  54.     int nbloop; //var for count number of loop
  55.     ifstream RDB; //stream for read rdb
  56.     ofstream SQL; //stream for write sql
  57.     RDB.open("db_charactermotion.rdb", ios::in | ios::binary); //open RDB file
  58.  
  59.     if(!RDB)//if the file can't be open
  60.     {
  61.         cout << "Cannot open file.\n";
  62.         return 1;
  63.     }
  64.     SQL.open("db_charactermotion.sql"); //open SQL file
  65.     RDB.seekg(128, ios::beg); //We go over the header(128empty bit)
  66.     RDB.read((char *) &nbloop,4);//we read 4bit(int) corresponding to the nb of line
  67.  
  68.     db_creaturefarm data[nbloop];//create array who will contening each information
  69.     for(int i=0; i<nbloop; i++) //loop for read all data
  70.     {
  71.         RDB.read((char *) &data[i], sizeof(db_creaturefarm));//put each data from structure into
  72.     }
  73.  
  74.     RDB.close(); //close RDB
  75.  
  76.     if(!RDB.good()) //If error durring reading(some time because you try to read more than you can)
  77.     {
  78.         cout << "A file error occurred.\n";
  79.         return 1;
  80.     }
  81.     //Wrinting Drop & create for CreatureFarmResource
  82.      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";
  83.  
  84.  
  85.      for(int i=0; i < nbloop; i++)
  86.     {
  87.         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])" <<
  88.         "\nVALUES\n"<<
  89.         "(" <<
  90.         (int)data[i].Motion_ID << "," <<
  91.         (int)data[i].Race_ID << "," <<
  92.         (int)data[i].Sex << "," <<
  93.         '"' << (string)data[i].File_Name << '"' << "," <<
  94.         (int)data[i].Frame_Length << "," <<
  95.         (int)data[i].Play_Speed << "," <<
  96.         (int)data[i].graphic_effect_file_ID << "," <<
  97.         (int)data[i].Graphic_effect_speed_type << "," <<
  98.         (int)data[i].Graphic_effect_position<< "," <<
  99.         (int)data[i].graphic_effect_follow << "," <<
  100.         (int)data[i].graphic_effect_disappear << "," <<
  101.         (int)data[i].sound_file_ID << "," <<
  102.         (int)data[i].Sound_volumn << "," <<
  103.         (int)data[i].Sound_play_probability << "," <<
  104.         (int)data[i].Sound_timing << "," <<
  105.         (int)data[i].sound_reverb_apply << "," <<
  106.         (int)data[i].sound_filter_apply << "," <<
  107.         (int)data[i].sound_stereo_apply << "," <<
  108.         (int)data[i].fx_id << "," <<
  109.         (int)data[i].fx_timing << "," <<
  110.         (int)data[i].fx_position << "," <<
  111.         (int)data[i].fx_play_speed << "," <<
  112.         (int)data[i].Event01_id << "," <<
  113.         (int)data[i].Event01_timing << "," <<
  114.         (int)data[i].Event02_id << "," <<
  115.         (int)data[i].Event02_timing << "," <<
  116.         (int)data[i].Event03_id << "," <<
  117.         (int)data[i].Event03_timing << "," <<
  118.         (int)data[i].Event04_id << "," <<
  119.         (int)data[i].Event04_timing << "," <<
  120.         (int)data[i].Event05_id << "," <<
  121.         (int)data[i].Event05_timing << "," <<
  122.         (int)data[i].Event06_id << "," <<
  123.         (int)data[i].Event06_timing << "," <<
  124.         (int)data[i].Event07_id << "," <<
  125.         (int)data[i].Event07_timing << "," <<
  126.         (int)data[i].Event08_id << "," <<
  127.         (int)data[i].Event08_timing << "," <<
  128.         (int)data[i].Event09_id << "," <<
  129.         (int)data[i].Event09_timing << "," <<
  130.         (int)data[i].Event10_id << "," <<
  131.         (int)data[i].Event10_timing << ")" <<
  132.         "\nGo\n\n";
  133.     }
  134.  
  135.     SQL.close(); //close SQL
  136.     return 0; //exit
  137. }
Advertisement
Add Comment
Please, Sign In to add comment