MYSQL
#6

Thanks!!

Edit: Here is my problem:

PHP код:
stock SaveObjects(playeridid)
{
    new 
DB_Query[256];
    
mysql_format(Database2DB_Querysizeof DB_Query"SELECT * FROM `usersobjectsinfo` WHERE `USERNAME` = '%e'"P[playerid][Name]);
    
mysql_tquery(Database2DB_Query"OnPlayerSaveObjects""ii"playeridid);
    print(
"query sent. Calling OnPlayerSaveObjects");
    return 
1;
}
forward OnPlayerSaveObjects(playeridid);
public 
OnPlayerSaveObjects(playeridid){
    print(
"OnPlayerSaveObjects called");
    new 
Cacherand cache_save(), tempid0;
    
cache_set_active(rand);
    new 
DB_Query[256];
    while(
cache_num_rows())
    {
        print(
"cache num rows are != 0");
        
cache_get_value_int(0"OBJECTID"tempid0);
        
printf("id= %d tempid0= %d"idtempid0);
        
// CODE BELOW DOESN'T GET EXECUTED
    
if(id == tempid0){
        
mysql_format(Database2DB_Querysizeof DB_Query"UPDATE `usersobjectsinfo` SET `POSX`=%0.4f,`POSY`=%0.4f,`POSZ`=%0.4f,`ROTX`=%0.4f,`ROTY`=%0.4f,`ROTZ`=%0.4f,`OBJECTID`=%d WHERE `USERNAME`= '%e' LIMIT 1"
        
Obj[id][PosX], Obj[id][PosY], Obj[id][PosZ], Obj[id][RX], Obj[id][RY], Obj[id][RX], idObj[id][ObjOwner]);
        
printf("%s tempid0 = id"Obj[id][ObjOwner]);
        
mysql_tquery(Database2DB_Query);
        
cache_delete(rand);     
        return 
1;
    }
        
mysql_format(Database2DB_Querysizeof DB_Query"INSERT INTO `usersobjectsinfo` (`USERNAME`,`POSX`,`POSY`,`POSZ`,`ROTX`,`ROTY`,`ROTZ`,`OBJECTID`) VALUES ('%e','%0.3f','%0.3f','%0.3f','%0.3f','%0.3f','%0.3f','%d')"
        
P[playerid][Name],Obj[id][PosX], Obj[id][PosY], Obj[id][PosZ], Obj[id][RX], Obj[id][RY], Obj[id][RX], id);
        
printf("%s tempid0 != id"Obj[id][ObjOwner]);
        
mysql_tquery(Database2DB_Query);
        
cache_delete(rand);
        return 
1;
    }
    return print(
"Couldnt execute any object-saving queries");

Reply


Messages In This Thread
MYSQL (edited reply) - by v1k1nG - 08.10.2018, 09:38
Re: MYSQL - by Calisthenics - 08.10.2018, 10:14
Re: MYSQL - by v1k1nG - 08.10.2018, 11:10
Re: MYSQL - by v1k1nG - 08.10.2018, 12:43
Re: MYSQL - by v1k1nG - 08.10.2018, 13:48
Re: MYSQL - by v1k1nG - 08.10.2018, 14:01
Re: MYSQL - by Calisthenics - 08.10.2018, 18:32
Re: MYSQL - by v1k1nG - 08.10.2018, 18:58
Re: MYSQL - by Calisthenics - 08.10.2018, 20:40
Re: MYSQL - by v1k1nG - 10.10.2018, 12:10

Forum Jump:


Users browsing this thread: 1 Guest(s)