Would this be the same for update as well? What you're saying DOES make sense, and it would probably explain why the game is inserting the field, throwing it into crash_copyover.
+----------------------------------------------------+ + TJW: Head Tech, designer: Dreamless Realms Mud + + Mud : http://drealms.kyndig.com + + Telnet: drealms.kyndig.com port 9275 + + OLC Docs: http://olc.kyndig.com + +----------------------------------------------------+ -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Chad Simmons Sent: Monday, June 10, 2002 2:21 PM To: [EMAIL PROTECTED] Cc: [email protected] Subject: RE: Advanced (kinda): Mysql & connection problems --- Tom Whiting <[EMAIL PROTECTED]> wrote: > >Breakpoint 2, send_query (command=0xbfff81e0 "SELECT * from stats WHERE > >uname = 'Xantha' ") > ><<from here it's all downhill.. crash_copyover called as it should be, > >game rebooted>> > No, this is the beginning of the crash_copyover code, where it's saving > the sql player stats. It starts going downhill here: > > 87 if (!(db->result=mysql_store_result(&my_connection))) > 89 error_db(command, 2 ); What would you logically expect the result of an insert statement to be? For a select the result is the list of records returned, but an insert doesn't give anything like that. I would say that inserting to the database most likely would return NULL from a mysql_store_result call, which then causes your program to erroniously error out. You might want to make a different function which is used for inserts, and which does not look for a result from the statement. ~Kender ===== -----BEGIN GEEK CODE BLOCK----- Version 3.1 GCS/L/C/O d-(+) s++: a-- C+++$>++++ UBLS++++$ P+++(--)$ L+++>++++ E--- W+>++$ N !o K? w(--) !O M- !V PS+ PE(++) Y+ PGP->+ t+ 5 X+() R(+) tv+@ b++(+++) !DI+++ D G(-) e>+++$ h---() r+++ y+++ ------END GEEK CODE BLOCK------ __________________________________________________ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- ROM mailing list [email protected] http://www.rom.org/cgi-bin/mailman/listinfo/rom
