hey sarge, take a look at this code here. The query is valid, I have checked with a good playerid and it works fine.
_dotheDamnThing = 1;
if (_dotheDamnThing == 1) then {
// define query
//_key = format ["CHILD:999: select id from building WHERE class_name= '%1' AND id >...
my best guess is that the hive.dll that origins is using is causing this issue.
All child calls I've seen in the origins calls pass only 1 or 2 params. That's it. No table names, no queries, just params.
Well for starters, your query assumes that there is a table called "player" here is what the query will look like with your _key string:
select playerid from player WHERE instance_id= '_playerid' AND id > 0
I think you want to format your _key statement like this:
_key = format...
This is related to the Operating system that your database is being run on. take a look at this:
http://dev.mysql.com/doc/refman/5.0/en/identifier-case-sensitivity.html
I don't know how much access you have to your database but you could try and start mysql with the lower_case_table_names...
Here's some food for thought. In PHP MySQL injection is a big problem, users pass their own query in as data and force your server to execute it. one way to work around this is by using parameters in your query instead of just replacing a string value in the query itself (? vs %1 in this...
Hey sarge,
Trying to figure out the code here as it is a bit confusing in the query structuring. It looks like you are only passing one variable (_classname) to the query as a parameter but I see two params(?) exoected in the query.
I see "class_name='%1'" and "id > ?:[0]"
Can you please...
OK, here is how it works:
You can only access the inventory when the house is UNLOCKED. If you use the inventory when the house is locked, you will not access the actual inventory of the house stored in the DB, if you put stuff in the inventory when it is locked, you risk losing your gear...
Still working on getting antihax going. So far I got it mostly working but can't stop it from closing the spawn select screen so everyone ends up in kameni
Sent from my Galaxy Nexus using Tapatalk 2
If you look at that github link I posted, it describes the different child functions and what they do. All except 999. 999 is in theory supposed to allow you to execute custom queries. I don't know if it is limited to read or write.
no, I think you need to call it like this:
_playerisadmin = format["CHILD:999:select adminID, from admins where instance_id = ?:[%1]:", dayZ_instance];
_data2 = "HiveEXT" callExtension _playerisadmin;
Then you have to get the data out of that... This is the problem I am having right now...
I think you need to call the hive with _playerisadmin to execute the query...
here is something interesting. I've been trying to find data on CHILD:999 but all I can find is info on the other child calls from the hive code...
thanks, this is helpful information.
holy crap, this arma2 coding is starting to come together. So you can pass code to every client on the server with a public variable.... I just assumed they held data only.
This should... work with epoch. I don't know about any custom scripts though, as it uses a different server format than bliss. I think you could modify them to work if you knew what you were doing though.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.