Ok,I am with kagurazakayukari,so I will describe some technical details about our host here.
Our host was running in a Windows Server 2003 system.I have already set up a web-service of php,ngnix and mysql.so I cant use your Bat script came with the windows' version because it seems that it will set up another web-service which might crashed the web-service I already set.
Runs for a week and it works pretty fine. However there are some little issue...
It seems that its not possible to delete data? I've drive a car with no restrictions for several laps and then change to restricted and the delta shows I'm much slower than its time.....very annoying.....
And for some layout, driving over the construct object(eg some bridges) are invaild in HLVC so 100% no clean lap...
New version v0.5.2
- Layouts support
- !axlist command
- Top laps - show layout name, filter by tyres
- Main loop optimizations
- More translatable strings
You can set in "User settings -> Timebar" when to reset stint / delta. I'll look if anything can be done with HLVC and object.
For usage, with the reverse method set correctly, should /start= typed with some parameters or just ignore it? Usually we do a 2-round-race, typed in /start=fixed after Round 1 start and manually order the start place by end race. How to deal with it with tracker now? need type anything different?
And an issue, autosretart still not working in some cases...
Now we are using it as a leaderboard/race combined server, except following issues it works pretty fine~
UPDATE: Somehow we've been enabled autoupdate but it just doesn't work...so update manually by overwriting it and it works fine~
I was trying to use KingTracker's database within my website so I wrote a simple php based script which it didn't get the things right and I don't understand why.
My script checks the LAPS table of KingTracker's database every 30 secs.If there is new lap-time record in it ,my script will read it and translate to my database's format and put it into my website's database.
The core-code was as followed:
$sql="select maxID from max_lap_id where host_id=$hostID"; $maxID=getsql($sql,0);//The max_lap_id table was set up by me in order to record the max lap ID that have been put into my database
$sql="select * from laps where track='$track' and id>$maxID order by id ";//make sure don't record the same lap-data again. $ok=mysql_query($sql); $idLog=''; if (mysql_num_rows($ok)>0){ while ($row=mysql_fetch_array($ok)) {
$player_id=$row["player_id"]; $sql2="select UName from players where id=$player_id"; $plyName=getsql($sql2,0); $car=$row["car"]; //$timestamp=time(); $maxID_new=$LapId=$row['id']; $idLog=$maxID_new."\r\n".$idLog; $LapTime=$row["time"]/1000; $sectors=$row["sectors"]; $timestamp=strtotime($row["added"])+8*3600; $var=json_decode($sectors,true); $st0=$var["1"]; $st1=$var["2"]; $SectorTime0=getSeconds($st0); $SectorTime1=getSeconds($st1); $LapCount=0; $data=$data."$LapId,1,$plyName,$car,4,5,6,7,8,$LapCount,$SectorTime0,$SectorTime1,$LapTime,$SectorTime0,$SectorTime1,$LapTime,$timestamp\n"; //I will post this $data to my website's receiver. $sql3="update max_lap_id set maxID=$maxID_new where host_id=$hostID";//update the max-lap-id mysql_query($sql3);
}
Well, if I set the max-lap-id to zero or something much more smaller than the LAPS table actually recorded,and the script will do it all right which will transfer all data into my website correctly in the very first time .but if the script keep running,all data transfer to my website were wrong.
So I wonder that will KingTracker update the certain LAPS record after insert it into LAPS table?If the answer is yes,could you tell me when KingTracker will update it ?
New version v0.5.2f
- Track rotation - added open layouts
- !status command
- chinese language updated (kagurazakayukari)
- FIX laps saving on some layouts
- FIX restart timers
- FIX layout unloading (splits count)
Update
If you are updating manualy there is sql file (update_v0.5.2f.sql) with changes made to database
Yes, lap records are updated if player made a better time on same conditions (car, track, layout, setup configs, tyres ...), I have added new field "updated" with datetime when it was updated. Also see example code in /external/getLaps.php how you can easily fetch lap time in your script.
Thanks a lot for your kindly reply.Since we are planning to record every single lap that every player did in our server and no matter what time they did,so we have to find some other way to do that.
New version v0.5.3
- ResultsService store last 20 races results and laps / splits (external sample added)
- Automatic race restart after qualify ends (delayed)
New version v0.5.4
Open tracks improvements:
- split and lap times are compared with fastest lap on current track/layout/car/restrictor
- HLVC disable object contact check with some objects (concrete, ramps) (!host -> race settings -> general)
- translated HLVC messages
Thanks for translation, yes language changes automatically based on user in game language, but it have to be set before user joins server - I can't detect user language change, only language when he connects. (manual language selection will be added in near future)
File you sent was saved in wrong encoding (ANSI), KingTracker needs UTF-8. I have attached correct file which worked for me.
