public spawnStatics(){ samp_mysql_select_db(mysqldb); samp_mysql_query("select vehicleid,x,y,z,angle from staticVehicles"); samp_mysql_store_result(); if(samp_mysql_num_rows() > 0){ new result[1024]; new vehicleid,Float:x,Float:y,Float:z,Float:angle; if(samp_mysql_num_rows() > 0){ print("Spawning static vehicles."); while(samp_mysql_fetch_row(result)){ new index; vehicleid = strval(strtok(result,index,'|')); x = floatstr(strtok(result,index,'|')); y = floatstr(strtok(result,index,'|')); z = floatstr(strtok(result,index,'|')); angle = floatstr(strtok(result,index,'|')); AddStaticVehicle(vehicleid,x,y,z,angle,-1,-1); } }else{ print("No vehicles found that need to be spawned."); } samp_mysql_query("select id,type,x,y,z,rx,ry,rz from staticObjects order by gameid"); samp_mysql_store_result(); new result2[256]; new counter; new objtype; new dbid; new crossref[250][2]; new Float:rx,Float:ry,Float:rz; counter = 0; printf("found %d objects to spawn.",samp_mysql_num_rows()); if(samp_mysql_num_rows() > 0){ print("Spawning static objects."); while(samp_mysql_fetch_row(result2)){ new index2; dbid = strval(strtok(result2,index2,'|')); objtype = strval(strtok(result2,index2,'|')); x = floatstr(strtok(result2,index2,'|')); y = floatstr(strtok(result2,index2,'|')); z = floatstr(strtok(result2,index2,'|')); rx = floatstr(strtok(result2,index2,'|')); ry = floatstr(strtok(result2,index2,'|')); rz = floatstr(strtok(result2,index2,'|')); new newobjid = CreateObject(objtype,x,y,z,rx,ry,rz); crossref[counter][0] = dbid; crossref[counter][1] = newobjid; printf("%d - created object: %d",counter,newobjid); counter++; } printf("%d",sizeof(crossref)); for(new i = 0; i <= sizeof(crossref)+1 ;i++){ new query[256]; format(query,256,"update staticObjects set gameid = %d where id = %d",crossref[i][1],crossref[i][0]); print(query); samp_mysql_query(query); } }else{ print("No objects found that need to be spawned."); } } return 1; }