|
|
#include <windows.h>
#include <iostream.h>
#include <stdio.h>
#include <commctrl.h>
#include <time.h>
#include <process.h>
#include <oledb.h>
#include <mmsystem.h>
#include "dbmgr.h"
INT nAccountCount = 0;
char szQuery[1024];
char szID[20] = {0};
char szPASS[20] = {0};
bool bSuss = false;
DWORD dwTmp = 0;
CRecordset *pRec;
FILE *file;
VOID InsertLogMsg(LPTSTR lpszMsg)
{
cout<<lpszMsg<<endl;
}
void main()
{
GetDBManager()->Init( InsertLogMsg, "shake", "sa", "Lj_lh_MsC_zlYH_ckJw" );
cout<<"DATA AUTO ADD SYSTEM"<<endl;
cout<<"==================="<<endl;
file = fopen( "monref.txt", "rt" );
if( file == NULL ) return;
int nMap;
int nRefTime;
CHAR szMonster[256];
int nRefNum;
int nX;
int nY;
int nAreaX;
int nAreaY;
int nNum = 0;
while( feof(file) == 0 )
{
nNum++;
fscanf( file, "%d", &nMap );
fscanf( file, "%d", &nRefTime );
fscanf( file, "%s", szMonster );
fscanf( file, "%d", &nRefNum );
fscanf( file, "%d", &nX );
fscanf( file, "%d", &nY );
fscanf( file, "%d", &nAreaX );
fscanf( file, "%d", &nAreaY );
cout<<nNum<<" "<<nMap<<" "<<nRefTime<<" "<<szMonster<<" "<<nRefNum
<<" "<<nX<<" "<<nY<<" "<<nAreaX<<" "<<nAreaY<<endl;
pRec = GetDBManager()->CreateRecordset();
sprintf( szQuery, "INSERT SYS_MONREF ("
"FLD_IDX, FLD_MAP, FLD_REFTIME, FLD_MONSTER, FLD_COUNT, "
"FLD_X, FLD_Y, FLD_AREA_X, FLD_AREA_Y ) "
"VALUES ( "
"%d, %d, %d, '%s', %d, "
"%d, %d, %d, %d )",
nNum, nMap, nRefTime, szMonster, nRefNum,
nX, nY, nAreaX, nAreaY );
bSuss = pRec->Execute( szQuery );
GetDBManager()->DestroyRecordset( pRec );
}
/* file = fopen( "monitem.txt", "rt" );
if( file == NULL ) return;
CHAR szMonster[256];
CHAR szItem[256];
int nProb;
int nSum;
int nNum = 0;
while( feof(file) == 0 )
{
nNum++;
fscanf( file, "%s", szMonster );
fscanf( file, "%s", szItem );
fscanf( file, "%d", &nProb );
fscanf( file, "%d", &nSum );
cout<<nNum<<" "<<szMonster<<" "<<szItem<<" "<<nProb<<" "<<nSum<<endl;
pRec = GetDBManager()->CreateRecordset();
sprintf( szQuery, "INSERT SYS_MONITEM ("
"FLD_IDX, FLD_MONSTER, FLD_ITEM, FLD_PROBABLY, FLD_COUNT ) "
"VALUES ( "
"%d, '%s', '%s', %d, %d )",
nNum, szMonster, szItem, 10000/nProb, nSum
);
bSuss = pRec->Execute( szQuery );
GetDBManager()->DestroyRecordset( pRec );
}
*/
/* file = fopen( "item.txt", "rt" );
if( file == NULL ) return;
CHAR szName[256];
int nNum = 0;
int nType;
int nJob;
int nNaijiu;
int nDC, nDCMax;
int nAC, nACMax;
int nDis, nWide;
int nLvl;
while( feof(file) == 0 )
{
nNum++;
fscanf( file, "%s", szName );
fscanf( file, "%s", szName );
fscanf( file, "%d", &nType );
fscanf( file, "%d", &nJob );
fscanf( file, "%d", &nNaijiu );
fscanf( file, "%d", &nDis );
fscanf( file, "%d", &nWide );
fscanf( file, "%d", &nDC );
fscanf( file, "%d", &nDCMax );
fscanf( file, "%d", &nAC );
fscanf( file, "%d", &nACMax );
fscanf( file, "%d", &nLvl );
cout<<nNum<<" "<<szName<<" "<<nType<<" "<<nJob<<" "<<nNaijiu
<<" "<<nDis<<" "<<nWide<<" "<<nDC<<" "<<nDCMax<<" "<<nAC
<<" "<<nACMax<<" "<<nLvl<<endl;
pRec = GetDBManager()->CreateRecordset();
sprintf( szQuery, "INSERT SYS_ITEM ("
"FLD_INDEX, FLD_CHARNAME, FLD_TYPE, FLD_GSHAPE, FLD_WSHAPE, "
"FLD_GENDER, FLD_JOB, FLD_QUALITY, FLD_MAXQUALITY, FLD_ATTRIBUTE, "
"FLD_ATTACKSTEP, FLD_ATTACKWIDE, FLD_ADDMINDC, FLD_ADDMAXDC, FLD_ADDMINAC, "
"FLD_ADDMAXAC, FLD_ADDMINMC, FLD_ADDMAXMC, FLD_WEIGHT, FLD_NEEDLVL, "
"FLD_ADDHP, FLD_ADDMP, FLD_ADDHPUPPER, FLD_ADDMPUPPER, FLD_ADDPRECISION, "
"FLD_ADDDODGE, FLD_ADDATTACKSPD, FLD_ADDCOLD, FLD_ADDFIRE, FLD_ADDEARTH, "
"FLD_ADDWIND, FLD_ADDLIGHT, FLD_ADDDARK, FLD_ADDPOSION, FLD_ADDSUCKBLOOD ) "
"VALUES ( "
"%d, '%s', %d, %d, %d, "
"0, %d, %d, %d, 0, "
"%d, %d, %d, %d, %d, "
"%d, 0, 0, 0, %d, "
"0, 0, 0, 0, 0, "
"0, 0, 0, 0, 0, "
"0, 0, 0, 0, 0 )",
nNum, szName, nType, nNum, nNum,
nJob, nNaijiu, nNaijiu,
nDis, nWide, nDC, nDCMax, nAC,
nACMax, nLvl
);
bSuss = pRec->Execute( szQuery );
GetDBManager()->DestroyRecordset( pRec );
}
*/
}
|
|
发表于 2004-6-23 14:35:00
发表于 2004-6-23 15:37:00
楼主