file 1
my.c
//--------------------------------------------------------
// MySQL Database Create 1/13/2001. Netkiller Chen
//--------------------------------------------------------
#include
#include
main()
{
char host[16]; //mysql host address.
char sid[15]; //root user name.
char pwd[15]; //root password.
/* char *table_file[]={
"gsxx",
"bcxx",
"fgxx",
"hmbxx",
"ltxx",
NULL
};*/
//char *mysql;
char mydatabase[256];
char mysqltable[256];
int i;
int max_table_num;
int db,status;
i=0;
max_table_num=4; //max_table_num
system("clear");
showme();printf("\n");
printf("MySQL host:");scanf("%s",host);
printf("Root user:");scanf("%s",sid);
printf("Password:");scanf("%s",pwd);
printf("Loading........\n\n");
while(table_file[i]){
sprintf(mydatabase,"echo \"create database %s\"|mysql -h%s -u%s -p%s",table_file[i],host,sid,pwd);
sprintf(mysqltable,"mysql -h%s -u%s -p%s %s<%s.sql",host,sid,pwd,table_file[i],table_file[i]);
db=system(mydatabase);
status=system(mysqltable);
// printf("%s\n%s",mydatabase,mysqltable);
printf(table_file[i]);
//printf("%d",status);
if(db==0 && status==0){
printf("\t\t\tInstall [ OK ]\n");
}else{
printf("\t\t\tInstall [ :( ]\n");
}
i++;
}
address();
}
//------------------- Function ------------------
showme()
{
printf("-------------------------------------------------------------------\n");
printf("\tI am Netkiller Chen.\n");
printf("\tI am a programmer and system&net manager.\n");
printf("\tI am glad to be friend with you!\n");
printf("-------------------------------------------------------------------\n");
}
address()
{
printf("\n----------------------------------\n");
printf("|\tnewtech@sina.com |\n");
printf("|\tOICQ:13721218 |\n");
printf("|\t 1/13/2001 |\n");
printf("----------------------------------\n");
}
file 2
table.h
char *table_file[]={