need some help of Ranking system lua scripts

[CrazyFlyCat]

Hi, everybody, I am FlyCat from inSky Lock Club in China ( we have more than six thousands registered forum members and everyday there are more than 30 people hanging out in our TS flying and fighting ). These days we setup a dedicated host (E6600, 4G, 150M Fiber, welcome to join in via host.insky.cn ). Need some help of Lockon Ranking system lua scrip.

 

I found this post about lua script of Jetfire and I modified the script and did some customization, set up a web page( http://host.insky.cn and also you can check the host system load status with http://host.insky.cn:81/hoststatus/panel.htm) for realtime flight information. But I am wondering how to make a system like ranking system like vvs504 before(It's really a pity that their system is down) . Is there anybody knows the detail about that? please give me some hint how to setup a system like that. Really thanks! :pilotfly:

[CrazyFlyCat]

faint!~~

is my post invisible or nobody comes here anymore?

[CrazyFlyCat]

seems nobody here anymore.

anyway, no trouble to bother. I made the script myself and export the mp_log to mysql. All necessary key data imported.

[GGTharos]

Sorry FlyCat ... a number of servers have created these things, but I guess they either wanted to keep it to themselves or weren't visiting this forum. Who knows.

[TucksonSonny]

faint!~~

is my post invisible or nobody comes here anymore?

 

 

The best ever made ranking system was made for/by (?) the 504th squadron server

 

http://www.syn-ack.com/vvs504/stats/index.shtml

 

 

Spiteful these guys are out of business (?) for some months now…:cry:

[504Goon]

Made by Zorlac :)

 

And we are most certainly not out of business.. just haven't found a suitable public server yet :)

[RvEYoda]

They are coming back for sure. We have a planned match against them in 2,5 wks ;)

[X-man]

They are coming back for sure. We have a planned match against them in 2,5 wks ;)

Indeed we do! :thumbup:

[504Goon]

Coming back? :)

[GGTharos]

They never left. Some squadrons have simply kept quiet ;)

[Mugatu]

Hi Crazy,

 

Sorry missed your post. You can export directly form lomac to mysql using a module called luasql (http://www.keplerproject.org/). That's what we do over at 3sqn. It's a little bit tricky getting it to compile with the old lua dll used by lomac but it works well once done. PM me if you want some more details.

 

But it looks like you've got it working with your scripts.

 

 

 

 

seems nobody here anymore.

anyway, no trouble to bother. I made the script myself and export the mp_log to mysql. All necessary key data imported.

[X-man]

Coming back? :)

Both!

 

Since we lost our servers, we've been having our own trainings 2-3 times/week, we've been in all LOCERFs, we've had a good presence on HL...where did someone get the idea that we were gone?? :)

[CrazyFlyCat]

Hi Crazy,

 

Sorry missed your post. You can export directly form lomac to mysql using a module called luasql (http://www.keplerproject.org/). That's what we do over at 3sqn. It's a little bit tricky getting it to compile with the old lua dll used by lomac but it works well once done. PM me if you want some more details.

 

But it looks like you've got it working with your scripts.

 

 

thanks all your reply!

 

Mugatu, luasql is exactly what I use.

 

in export.lua it looks like this:

 g_startTime = os.date( "%c"); 
        lastRow = 0; 

function LuaExportStart() 
     dofile( "Config/Export/calcRows.lua" ); 
     calcRows(); 
end 

function LuaExportBeforeNextFrame() 
end 

function LuaExportAfterNextFrame() 
end 

function LuaExportStop() 
   dofile( "Config/Export/ExportData.lua" ); 
   ExportData(); 
end 

 

it works fine, and I get the data in mysql likes this:

 

okay, got the data, the other part is easy to take care.

 

But these days I met a situation. Somebody uses other's name login the host to make some trouble. I don't want this happen in the stats system, it will cause big mess. an idea comes up and I think maybe there should be a webbased user register page running in the host and share the same database with the LOFC stats to record the user's last login IP address which can compare with the player's IP address in LOFC. if people want their stats data(records or points ) remain in the stats system, the IP address he last login the web must be the same as the IP address in LOFC. and the valid stats data will belong to the ID registered in the web.

 

sorry for so many words and my English. I am not native english speaker. In simply words:

 

how to export the player's connected IP address in LOFC via script?

 

I checked the AsyncNet.log, from this log, IP address can be extracted but how to tell it belongs to which player's?

 

don't know who can help me out of this. :cry:

[CrazyFlyCat]

up!up!

[Mugatu]

Hi CrazyFlyCat, I use coroutines to process a chunk of the mplog, and when the mission exits process what's left in the mplog/asynlog files.

 

function LuaExportStop()

stats_engine.complete_processing()

stats_engine.destroy()

end

 

 

function update_stats(t)

while true do

stats_engine.process_buffer()

coroutine.yield()

end

end

 

function CoroutineResume(index, tCurrent)

 

coroutine.resume(Coroutines[index], tCurrent)

return coroutine.status(Coroutines[index]) ~= "dead"

 

end

 

CoroutineIndex = CoroutineIndex + 1

Coroutines[CoroutineIndex] = coroutine.create(update_stats)

 

 

LoCreateCoroutineActivity(CoroutineIndex, 1.0, 60.0)