Anunnaki

... yes i understand, but when you use for that ODBC with DSN, you dont need to manage connection or authentication or anything else like some commands/coding/translating for mysql or etc. Every gameserver admin simple can set all necessary information for connect (server address,login,password and dbf name) to his preffered database (in GUI) which is in "ODBC Data Source Administrator" in "Administrave Tools". ODBC is supported by any DBFs systems. ODBC is multiplatformal (win/linux/unix), is multiplatformal (C++,C#,VB,VB.NET,PHP,ASP.NET and many many else). ODBC is something like "common language" driver for any type of databases. You need to know only ODBC DSN name ( something like pointer to local ODBC mapped database ). Simply you just make connect to ODBC name. Then you send string and read the answer. That can be done synchronous, or asynchronous, so schript can continue and answer appears later, so this dont slow down game. And there is no problem with more connection to ODBC resources/databases from more applications/computers at same time...all handle ODBC. You can use more connection to different servers or databases in one time also (administrators must set more ODBC DSN connection on servers). I dont know how that really works, but must be simpler than implementation whole SQlite. But when you can do that, everyone can be happy . You need some library for C++,C# or VB or VB.NET...i found for C# following commands: (for ODBC with DSN name "myDSN") <table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE"> Â { Â Â Â OdbcConnection cn; Â Â Â OdbcCommand cmd; Â Â Â string MyString; Â Â Â MyString="Select * from Customers"; Â Â Â cn= new OdbcConnection "dsn=myDSN;"); Â Â Â cmd=new OdbcCommand(MyString,cn); Â Â Â cn.Open(); Â Â Â MessageBox.Show("Connected"); Â Â Â cn.Close(); } For administrators is not so big problem to setup mysql or mssql dbf server. And when is, there are lots free MySQL/MSSQL web host servers, so admins dont need to know anything about MsSQL or MySQL, they just have server addres, login, password and dbf name. Than they set to ODBC thru GUI and they must put ODBC name which would use your armalib. Anyway, thank you for this tool, and the time function would be great too. So when missions end and start on server, there would be possible set the same time like in real world. And where you can search GAMEID i dont know, but DSTS was able to receive GAMEID from game till 1.05 ( maybe 1.08 too ) http://forums.livecar.net/index.php?showforum=2 , maybe Nutty (autor of dsts) can tell you what to find and where.

Well i am not so good in programing to writte own application for moving datas between armalib and mysql or mssql database. But thank you for respond. So you dont think on implement mysql support to your armalib in near future ? And other commands/functions from my previous post ?

Here and here OK ... i understand...whole database server is inside armalib application, and is running in memmory (as a part of armalib). Well...when i understand that good, there is no way, how can i store statistics, ranks, or any other informations away from ArmaLib program to another computer ? How can i access to armalib sqllite datas stored inside from PHP (web server) or from other arma servers around world with armalib, so they dont use own sqllite inside armalib but mine sqllite I am working on one mission with special ranking system and storing ability, like "captured flags/camps/cityes" and weapontemplates for any registered players on our forum and many other thinks. In mine case there can be more independent computers=dedicated servers around the world, but they must connect to mine MYSQL or MYSQL server. Can you help me with that ? There was ArmaDLL as attempt but not working anymore. There was arma DSTS but that project looks DEATH and works only with arma 1.08version. Please...help us, and give there normal DATABASE support thru ODBC. We need only that your application send text string (which can contain anything from MySQL or MsSQL to any other commands ) and can receive results from local ODBC driver. http://www.connectionstrings.com/ .. Kegetys, you are great person, your tools and work was everytime perfect. You have mine full respect. I am afraid, than when you dont do(or cant do) that...than NO one else. Â So you are maybe our last chance/hope ...:) So what we need: 1) resultstring = "string" setSql; ...returns string "ok" or <errormessage> resultstring = "string" getSql; ...returns string <resultstring> or <errormessage> 2) resultnum = <object> getGameid; ...returns gameId of given object in which is player connected or null 3) resultdate = getDateTime; ...returns string witch actual date and time stamp of server

hmm i am sick from SQLlite ... SQLite is for most users not usable... this type of SQL lack any GUI SERVER/CLIENT tools/applications for WINXP32 or WINXP64. Can you add there support for normal/standard/mostused MySQL or MSSQL DBF ? Ideal thru ODBC DNS, so you dont need to "writte support" for connecting to the externals servers and so ... that make ODBC self for you. Something like: $result=<stringCommand> getMyslq; (string witch result) $result=<stringCommand> setMysql; (false/true) - - - To others: Can someone explain me, where can i download SQLlite v3 server for WIN32 or 64bit with graphical GUI in standard installation file ? (setup.exe or setup.msi) ...i can't find that on theyr official sites.

a] Can you add there some function, which will return players id of selected player or object ? b] Or new function, which we can use in command on player connected/disconnected function, which will return CORRECT player's id = game id ? This was not working in current arma.

Right...that looks like arma server is very bad wrotted. As is mentioned in first post here. When is some player connecting, arma server start some subprocedure to do send files to the clients (even with very low bandwith) and almoust HANG whole main application (dedicated server) and almoust whole one CPU core ! I can't understand why they dont do that thru another separate thread for JIPing players with low CPU priority, so game can continue withouth problems or lags. And that was tested on dual CPU and 100Mbit FullDuplex Ethernet LAN, betwen 10 playeres on that network. Please, BIS, there is nothing so important than fixing this school bug, which is not fixed longer than one year now from releasing your/our ARMA game ! It is shame !

Sorry  it was too temping you had a lot more towns in the north instead of me manualy adding them copying them was much easyer. Wasnt all the towns though most of the towns come from the origional who ever made them in the 1.0 N&S Just added yours as additions.. But i didnt think it would hurt anyone? Yeah?  Can you port your mission to new SARA.LITE island ? The old SARA is too BIG for few players and lacks some new roads, which are present in new SARA.LITE. THX.

Sorry  it was too temping you had a lot more towns in the north instead of me manualy adding them copying them was much easyer. Wasnt all the towns though most of the towns come from the origional who ever made them in the 1.0 N&S Just added yours as additions.. But i didnt think it would hurt anyone? Yeah?  Can you port your mission to new SARA.LITE island ? The old SARA is too BIG for few players and lacks some new roads, which are present in new SARA.LITE. THX.

Thank you very very very much...i was working on my own RANKING system for our server with DTST tool ,but was working only with arma v.1.08. Thank you again.

Arma 1.12 dedicated server (WINXP): is running on private (not public) IP but selected as DMZ host on HW firewall, everything ok, no more problems with connecting to them like was beffore on 1.11 (1.11 was not able to connect thru ingame serverlist ). Server works good with persistant battlefield on, an at this time more than 24hours withouth crash or problems. Arma 1.12 on VISTA SP1 64bit: GraphicsCard 8800GTS 640MB Sound integrated Realtek HD CPU AMD X2 5000+ Works good ! And i think better (faster) like on WInXPSP2! But i have experienced time by time small 0,5s lags. Somethimes is that from every 3seconds to minutes. That all on near full details = very high, only ground details on NORMAL, visible on 1500m. Good work !

Connections problems maybe identified. That looks to my like wrong implementation of IP gamespy reporting or equal. There is problem with connection to servers, which are running on private ip adress (=no public ip adress). That can be, when you have server behind router (nat router included), and public IP is on your router and private IP is on your server. That problems occurs even you have your private IP adress as DMZ host on your router, or you have forwarded necessary TCP or UDP ports from your router (public IP) to the private IP on your server (=virtual server=port mapping=port forwardint ...). That all looks, like the server send local server IP adress to the gamespy server list, and when you have only private IP adress on your server, nobody can't connect to your server thru in-game server list from gamespy. Only one solution is there, you can connect direct to the IP (bypassing gamespy server list), you must start game with necessary parameters: arma.exe -mod=beta -connect=<ipadressofserver> -port=<port> To our server would be that: arma.exe -mod=beta -connect=88.212.6.233 -port=2302 I was not investigating that to the deep, this is only first shot, because i dont have enought time right now.

Connections problems maybe identified. That looks to my like wrong implementation of IP gamespy reporting or equal. There is problem with connection to servers, which are running on private ip adress (=no public ip adress). That can be, when you have server behind router (nat router included), and public IP is on your router and private IP is on your server. That problems occurs even you have your private IP adress as DMZ host on your router, or you have forwarded necessary TCP or UDP ports from your router (public IP) to the private IP on your server (=virtual server=port mapping=port forwardint ...). That all looks, like the server send local server IP adress to the gamespy server list, and when you have only private IP adress on your server, nobody can't connect to your server thru in-game server list from gamespy. Only one solution is there, you can connect direct to the IP (bypassing gamespy server list), you must start game with necessary parameters: arma.exe -mod=beta -connect=<ipadressofserver> -port=<port> To our server would be that: arma.exe -mod=beta -connect=88.212.6.233 -port=2302 I was not investigating that to the deep, this is only first shot, because i dont have enought time right now.

I dont know but evolution is writted very bad by someone, which is not good scripter and dont understand many how to writte effective program. Therefore is: a) unable to play this game on view distance higher than cca 1500m. I have very very strong computer. In other missions i have 5000+ and somethimes more view distance and all absolulty withouth laags. I run that on separate dedicated server on 1000Gbit lan withouth other players, but still , more then 1500m and you have laags b) when is new player connecting, laags and big desync appers inmediatly. I am now writting something like evolution but PvP with MYSQL ranking system. which dont have those problems like evo.

1) correct, i have the same problem, i am unable to test my MP mission because duplicate eventhandler in 1.09 doesn't work. 2) next problem is, that addPublicVariableEventHandler does not work on decicated server 1.09, that works only on clients.

I also call clearVehicleInit afterwards. Perhaps that fixes the JIP issues.<table border="0" align="center" width="95%" cellpadding="0" cellspacing="0"><tr><td>Code Sample </td></tr><tr><td id="CODE">// GLexec is a Game Logic GLexec setVehicleInit _code; processInitCommands; clearVehicleInit GLexec; Good advice with centralising the logic on the server. well, last time I discussed clearVehicleInit, they told me the example in the biki is wrong. You can not remove the vehicleInits after it was processed (processInitCommands).Well, yes you could run the clearVehicleInit command, but it would still be sent to JIP players There is a possibility that this clearVehicleInit does work as long as you execute it on the server, because he is the one who will send the list with vehicleInits to the JIPpers, not the other clients (Damn I hate this uncertainty, nothing beats testing and figuring out on my own ) I solved basicly all my issues with the v1.09beta function: addPublicVariableEventHandler, boy do I love it Wrote a new Network Engine that uses 1 variable per machine to send commands, with possibility to specify if all clients + server, only server, only clients, or specific clients (due to unique ID) must execute the command. Saves 100's, maybe 1000's, of vehicleInits that got synced at the start. And you only have to worry about the last command sent out being synced to JIP players (all publicVariables are synced to jippers at join) The coolness is now also that you can use arrays and publicvar them, basicly making it possible to send objects like groups and vehicles in one send. The problem with vehicleInit's are that they are strings. You can of course do something with the object you run the vehicleInit on (THIS), but you would have to run an Init per object or use extra publicVariables to work with more than 1 object at once. While using a publicVariable array that contains data used; destination, code to execute, and extra parameters like objects etc, gives you all the possibilities in the world I have maked simmilar way. I use two pulbic variables to send what i need from CLIENT to SERVER or back, from SERVER to ONE/ALL CLIENT. I use two public variales ServerToClient (STC) and ClientToServer (CTS). Clients are receiving STC variable, adn thransmiting thru CTS variable. Server oposit. Server have updated array of connected players (thru onPlayerConnect/Disconnect). Every receive/transmith have unique mID(mesasgeID), and pID(playerID). PID is need when server need to send something to one pc with this pID. mID is random number unique for every one message/connection. Every client first must "reserve" the "line" for him self, and then can send message or command. They send his mIDs to CTS and waiting, for permission received thru variable STC. When they receive thery mID back, they can transmith comand/string to the server. Server receive this string thru CTS variable and send back to the client acknowledge about that. Comunication is ended, server send 0 to the CTS var,, that means is ready to receive another reservation from another client or script which is waiting to send something. Every client and server is cycling on one variable so no "variable" broadcas storm would be there. You can be sure, that message will be transmithed to the server, but somethime that takes more time, because in one momment there can communicate only two PCs other commands wait for line reservation. I use that for starting some other scripts on client. Server and client when receive command, they execute them, or they can investigate what it is, so you can make condition, which command executed, and which is message to display or soo. Its not ready to publish, but i have working version. It is very good for multiplayer servers where are connected many many players and you don't wish to have laags by sending everything thru objectsinit or many public variables.