import_raw_items.cpp compiling errors

[Magoth78]

Hi there,

I'm trying to get this file compiled but it keeps sending me error that I can't understand.


Here is the file:


#include <mysql.h>
#include <stdio.h>
#include <string.h>

#include "../common/eq_packet_structs.h"

int main(int argc, char** argv)
{
MYSQL mysql;
FILE* fp;
char db_pass[32];

if (argc != 5)
{
printf("Usage: ./import_raw_items db_address db_username db_name item_filename\n");
return 1;
}

printf("Password:");
scanf("%s", db_pass);

mysql_init(&mysql);
if (!mysql_real_connect(&mysql, argv[1], argv[2], db_pass, argv[3], 0, 0, 0))
{
printf("Could not connect to database: Error:%s\n", mysql_error(&mysql));
return 1;
}

fp = fopen(argv[4], "r");
if (!fp)
{
printf("Could not open item file '%s'\n", argv[4]);
mysql_close(&mysql);
return 1;
}

Item_Struct item;
Item_Struct item2;
char query[1024];
char* end;
int16 id;
memset(&item, 0, sizeof(item));
memset(&item2, 0, sizeof(item));
// while(fread(&item, sizeof(item), 1, fp))
while(fread(&item, 240, 1, fp))
{
id = item.item_nr;

memcpy((char*)&item2, (char*)&item, 144);
memcpy((char*)&item2.unknown0144[8], (char*)item.unknown0144, sizeof(item)-152);
// memcpy((char*)((char*)&item)[148], (char*)((char*)&item)[144], sizeof(item)-148);
/*
((char*)&item)[144]=0;
((char*)&item)[145]=0;
((char*)&item)[146]=0;
((char*)&item)[147]=0;
*/
end = query;
end += sprintf(end, "INSERT INTO items SET id=%i,raw_data=", id);
*end++ = '\'';
end += mysql_real_escape_string(&mysql, end, (char*)&item2, sizeof(Item_Struct));
*end++ = '\'';
if (mysql_real_query(&mysql, query, (unsigned int) (end-query)))
{
printf("Could not insert item %i MySQL said: %s\n", id, mysql_error(&mysql));
}
}
}


and here are the errors:


--------------------Configuration: Zone - Win32 GuildWars Debug--------------------
Compiling...
import_raw_items.cpp
g:\lib\mysql_com.h(116) : error C2146: syntax error : missing ';' before identifier 'fd'
g:\lib\mysql_com.h(116) : error C2501: 'SOCKET' : missing storage-class or type specifiers
g:\lib\mysql_com.h(116) : error C2501: 'fd' : missing storage-class or type specifiers
g:\lib\mysql_com.h(180) : error C2065: 'SOCKET' : undeclared identifier
g:\lib\mysql_com.h(180) : error C2146: syntax error : missing ')' before identifier 's'
g:\lib\mysql_com.h(181) : error C2059: syntax error : ')'
G:\JOB\NightDumps\NightDumps\Source\zone\import_ra w_items.cpp(50) : error C2039: 'unknown0144' : is not a member of 'Item_Struct'
G:\JOB\NightDumps\NightDumps\Source\zone\../common/eq_packet_structs.h(973) : see declaration of 'Item_Struct'
G:\JOB\NightDumps\NightDumps\Source\zone\import_ra w_items.cpp(50) : error C2039: 'unknown0144' : is not a member of 'Item_Struct'
G:\JOB\NightDumps\NightDumps\Source\zone\../common/eq_packet_structs.h(973) : see declaration of 'Item_Struct'
Error executing cl.exe.

import_raw_items.obj - 8 error(s), 0 warning(s)


Any idea please?

I googled for your error messages and found a reference to including <my_global.h> before <mysql.h>

http://www.mysql.com/doc/en/Windows_client_compiling.html

might be worth a try.

[Magoth78]

Hello and thx for the reply,

I tried to include the <my_global.h> before <mysql.h>.
But I still have the same error.

[Deawin]

Instead of doing this:

#include <mysql.h>
#include <stdio.h>
#include <string.h>


do this:


#include <windows.h>
#include <winsock.h>
#include <mysql.h>
#include <stdio.h>


Regards,
Markus

Either including <my_global.h> or Deawin's suggestion get rid of the mysql errors for me.

G:\JOB\NightDumps\NightDumps\Source\zone\import_ra w_items.cpp(50) : error C2039: 'unknown0144' : is not a member of 'Item_Struct'
G:\JOB\NightDumps\NightDumps\Source\zone\../common/eq_packet_structs.h(973) : see declaration of 'Item_Struct'
G:\JOB\NightDumps\NightDumps\Source\zone\import_ra w_items.cpp(50) : error C2039: 'unknown0144' : is not a member of 'Item_Struct'
G:\JOB\NightDumps\NightDumps\Source\zone\../common/eq_packet_structs.h(973) : see declaration of 'Item_Struct'

Browsing the CVS on sourceforge, this would seem to be due to some conditional compilation in eq_packets_struct.h. It is only compiled in if TEST_SERVER_AA is defined.

[Magoth78]

Hi there and thx for the replys,

yes, I got rid of the mysql errors while compiling and I thank you.

But, I still have the Item_Struct errors.
Derision> I have not exactly understood what you said. You mean I can compile if I #define TEST_SERVER_AA in the eq_packet_structs.h?

Forget what i said about TEST_SERVER_AA, i wasn't paying enough attention to the code. My guess is that the devs have updated the Item_Struct and removed the member unknown144 but not got around to updating the program you are trying to compile.