Responding to myself in case someone can needs this info.
I figured this out. It was a problem with pre- 4.1 MySQL databases. You have to use
Code:
result = dbi_query(dbc,"SELECT * FROM maprank where map_name ='%s'",mapname)
if (dbi_num_rows(result) < 1) {
result = dbi_query(dbc,"INSERT INTO maprank (map_name, good, okay, bad, total) values ('%s',%i,%i,%i,%i)",mapname,state[0],state[1],state[2],totalint)
}else{
result = dbi_query(dbc,"UPDATE maprank SET good=good+%i, okay=okay+%i, bad=bad+%i, total=total+%i WHERE map_name='%s'",state[0],state[1],state[2],totalint,mapname)
}
Instead of
Code:
result = dbi_query(dbc,"INSERT INTO maprank (map_name, good, okay, bad, total) values ('%s',%i,%i,%i,%i) ON DUPLICATE KEY UPDATE map_name=map_name, good=good+%i, okay=okay+%i, bad=bad+%i, total=total+%i",mapname,state[0],state[1],state[2],totalint,state[0],state[1],state[2],totalint)
________
Suzuki TS125 DUSTER