[Podunk]

What: records battles on a mysql database.
Why: Watch overhead views of battles on a webpage
Credits: Most of the SQL stuff is from XxAvalanchexX's gungame_sql plugin. Thanks XxAvalanchexX
I'll be working on the web part of it over the next few weeks. (im a semi newb at flash so it may take a bit )

fl_sql_host 	"127.0.0.1"
fl_sql_user		""
fl_sql_pass		""
fl_sql_db		""
fl_sql_table	"fraglock_data"
fl_sql_updaterate	10.0

changelog:
0.1
inital version
0.2
+now records aim coords for players (thanks anssik and Alka)
+now records the "battle id" in a seperate table, everything in the tables are linked by the battleid
+now records deaths - pos and aim of attacker and victim and game time
-changed default updaterate to 10 seconds

[Juba_PornBorn]

explain a litle bit better Im not sure I understand it. What is Fraglock?
Records batles in what sense?

[Podunk]

it takes each players info such as hp and location and pushes that into a database table

I'll have the web side of it ready in the future so that battles can be seen/watched/analyzed on a webpage

[vittu]

Juba, he means in future he will create something to be able to watch game play as it happens on the web. Similar to Olo's Jaba TV: http://www.olo.counter-strike.pl/index.php?page=jabatv

[Podunk]

lol seems everything i made someone has thought of it and done it already.

oh well, I guess the difference here is its an amxmodx plugin as opposed to a metamod plugin

edit: I think ill go the ajax route too

[vittu]

Yea I have no idea if that one still works or not "(last update 24.10.2004)", but maybe could give you some ideas or whatnot.

[Podunk]

the screenshots the author has up looks like what I want

[anssik]

Yeah it's good if you can make it for flash, it's much better than some laggy Java. Using AJAX , that sounds good. I'll be looking forward to this plugin.

EDIT: Maybe you could use get_user_origin(index,origin[3],1) to get coords where a player is aiming at. That way you can get the FOV in the web app.

Originally Posted by AMXX Function Wiki get_user_origin ( index, origin[3], [ mode = 0 ] ) If mode is passed, the origin changes: 0 - current position (Default) 1 - Position from eyes (weapon aiming) 2 - End position from player position 3 - End position from eyes (hit point for weapon) 4 - Position from last bullet hit (only CS)

[Alka]

new origin[3]
get_user_origin(id, origin, 3)

Origin where player aiming at!

You can get FOV this way ,with fakemeta :

new fov
fov = pev(id, pev_fov)

[Podunk]

so FOV is where the player is looking/aiming? maybe i can make the application draw a line from the dot (the player) to where he/she is aiming?