Show Posts

This section allows you to view all posts made by this member. Note that you can only see posts made in areas you currently have access to.


Messages - dazholmes

Pages: [1] 2
1
Technical Support / Re: Can't get 2nd Server with MYSQL working
« on: Aug 07, 2016, 12:28 PM »
Ok i fixed this i had to manually input data into the the 2nd database into the serverinstances and put the id to 2 then go into main_config.cfg and set server id as 2 there also, It would be nice to know what the actually server id is other than guessing but at least it's fixed now.

2
Technical Support / Can't get 2nd Server with MYSQL working
« on: Aug 07, 2016, 10:48 AM »
Hi, i have 1 wasteland server altis running with mysql it works great i copied the files over created different db name edited the name in the extDB script to connect to the database but it doesn't work i literally copied the files from my first server to the 2nd and doesn't work :( the 2nd server i want with mysql is tanoa and it's not working not sure why there isn't any obvious mistakes all passwords username are connect i imported the sql file into the new db and still nothing is being put into it
I think it's something to do with the awasteland_settings main_config.cfg it says in extDB section server id every server has different id that deosn't really help it doesn't tell you how to get the server id i think that's the issue


3
Technical Support / Re: ATM Not Save Cash On Restart
« on: Jun 29, 2016, 08:48 PM »
yes you need a mysql  :D
Hey do you know how to setup mysql on linux? i made a topic if you're willing to help
http://forums.a3wasteland.com/index.php?topic=2812.msg16425#msg16425

4
Technical Support / a3wasteland extdb
« on: Jun 29, 2016, 12:13 AM »
I tried setting up extdb i downloaded the A3W_extDB_pack changed all the settings imported the sql file into the database put all username and passwords in etc but it's not writing any info into the columns i did select Name FROM PlayerInfo;
but it says empty

Also i replaced the A3Wasteland_settings/main_config.sqf into the mission pbo server/default cfg but still no difference i can join but it's just not running the mysql it might be because i need to remove profiles from
command line...

-config=config.cfg -cfg=basic.cfg -profiles=@Profiles -name=server -port=2302 -nosplash -exThreads=8


extdb-conf

Code: [Select]
[Main]
Version = 5

;Threads = 0 
; Default Value is the number of CPU Cores Detected (max value is 6, min value is 2)

Randomize Config File = false
;This is a legacy option to randomize config file for Arma2 Servers. Only for Windows Builds


;################################################################################################################################
;##                                                                                                                            ##
;##    A3WASTELAND DATABASE                                                                                                    ##
;##                                                                                                                            ##

[A3W]
Type = MySQL
Name = a3wasteland

Username = arma3
Password = password

IP = 127.0.0.1
Port = 3306

;minSessions = 2
idleTime = 60

compress = false
; Really should only use this if MySQL server is external. Also only for MySQL

Secure Auth = true
; Recommend you turn this on  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth

;##                                                                                                                            ##
;##                                                                                                                            ##
;################################################################################################################################


[Rcon]
;; This is functional, should be working fine. Just needs abit of testing on a $
;; Allow for changing Address for those running server in a VM environment.
IP = 127.0.0.1
Port = 2302

;; Rcon Password i.e Battleye/beserver.cfg
Password = password

;; Bad Player Name Checks
;; This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Bad Playername Enable = false
Bad Playername Kick Message = Bad Player Name

;; By default : is a bad character (used as seperator for extDB2 Calls (this is hardcoded in)
;;Bad Playername Strings = (:):{:}
;;Bad Playername Regex_1 = [:alnum:]
;;Bad Playername Regex_2 = [:alnum:]
;;Bad Playername Regex_3 = [:alnum:]


;; Whitelisting / Reserve Slots
;; This will only work if your mission / mod has started extDB2 Rcon. i.e 9:START_RCON:RCON
Whitelist Enable = false
Whitelist Kick Message = Only Reserved Slots Left

Whitelist Public Slots = 999

;; Database settings to use (Optional)
Whitelist Database = MySQL_Example
Whitelist SQL Prepared Statement = SELECT CASE WHEN EXISTS(SELECT UID FROM PlayerInfo WHERE BattlEyeGUID=? AND Whitelisted=1) THEN 1 ELSE 0 END
Whitelist Kick on SQL Query Failed = false

;; Hardcoded BEGuids for whitelisted players
;Whitelist BEGuids = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx : yyyyyyyyyyyyyyyyyyyyyyyyyyyyyyyy


[RemoteAccess]
;; Remote TCP Access to extDB2
Enable = true

Port = 2300
MaxThreads = 4
MaxQueued = 4
IdleTime = 120

Password = password


[Steam]
;; This is for VAC Protocol for VAC Bans + Steam Friends.
;; https://steamcommunity.com/dev/apikey
API Key = xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx


[VAC]
;; This feature requires Steam + Rcon to be enabled.
;; Also this feature is called via SQF Code atm, i.e it doesn't auto detect players joining server yet....
Auto Ban = true

;; For Player to get banned ( their total VAC Bans => NumberOfVACBans)  AND ( Days Since their Last Ban was <= DaysSinceLastBan)
;; This is also used extDB Protocol VAC:VACBanned returned results

NumberOfVACBans = 1
DaysSinceLastBan = 999999999
BanDuration = 0
;; 0 = Forever, otherwise its x Minutes
BanMessage = Steam VAC Banned


[Log]
;; Flush Logs after each write, more work on Harddrive
Flush = true


[MySQL_Example]
Type = MySQL
Name = Database_Name

Username = arma3
Password = password

IP = 127.0.0.1
Port = 3306

;minSessions = 2
idleTime = 60

compress = false
; Really should only use this if MySQL server is external. Also only for MySQL

Secure Auth = true
; Recommend you turn this on  http://dev.mysql.com/doc/refman/5.6/en/mysql-command-options.html#option_mysql_secure-auth


[SQLite_Example]
Type = SQLite
Name = sqlite.db

minSessions = 1
; minSession Default Value = 1

;maxSessions = 4
; maxSession Default Value = number of Main->Threads
; You really should leave this value alone
idleTime = 60
; idleTime no Default Value yet, needs to be defined.
; idleTime is the time before a database session is stopped if not used.
; If Database Sessions are greater than minSessions

5
Technical Support / ATM Not Save Cash On Restart
« on: Jun 28, 2016, 10:32 PM »
If i restart my server the cash in peoples atm's gets reset anyway to fix this?

i'm using profile to save data.. should i move to mysql?

6
Gameplay Discussion / Re: Reserve Slot
« on: Jun 23, 2016, 11:43 AM »
nvm got it working

7
Editing & Coding / Re: Reserved Slot
« on: Jun 23, 2016, 11:43 AM »
nvm got it working

8
Editing & Coding / Reserved Slot
« on: Jun 23, 2016, 01:34 AM »
Do any of you know how to Reserve slots? on a3wasteland like a squad for example of 5 reserve them for admins etc by there uid i have this code but not sure how to get it working i know i put player uid in there and add it into initplayerlocal.sqf but i'm not sure where i link the code to a player ai ingame so make it reserved.

Code: [Select]
while {true} do
{
private ["_reserved_units", "_reserved_uids", "_uid"];
 
waitUntil {!isNull player};
waitUntil {(vehicle player) == player};
waitUntil {(getPlayerUID player) != ""};
 
// Variable Name of the Player Character to be restricted. //
_reserved_units = [Reserved01];
 
// The player UID is a 17 digit number found in the profile tab. //
_reserved_uids =
[
"UIDXXXXXXXXXXXXXX"/* Add Player Name Here */,
"UIDXXXXXXXXXXXXXX"/* Add Player Name Here */,
"UIDXXXXXXXXXXXXXX"/* Add Player Name Here */
];
 
// Stores the connecting player's UID //
_uid = getPlayerUID player;
 
 
if ((player in _reserved_units)&& !(_uid in _reserved_uids)) then
    {
   titleText ["", "BLACK OUT"];
   disableUserInput true;
   hint "You are in a reserved slot! You will be kicked to the lobby in 15 seconds!";
   sleep 5;
   hint "You are in a reserved slot! You will be kicked to the lobby in 10 seconds!";
   sleep 5;
   hint "You are in a reserved slot! You will be kicked to the lobby in 5 seconds!";
   sleep 5;
   titleText ["", "BLACK IN"];
   disableUserInput false;
   failMission "end1";
    }; 
 };

9
Gameplay Discussion / Reserve Slot
« on: Jun 23, 2016, 01:31 AM »
Do any of you know how to Reserve slots? on a3wasteland like a squad for example of 5 reserve them for admins etc by there uid i have this code but not sure how to get it working i know i put player uid in there and add it into initplayerlocal.sqf but i'm not sure where i link the code to a player ai ingame so make it reserved.

Code: [Select]
while {true} do
{
private ["_reserved_units", "_reserved_uids", "_uid"];
 
waitUntil {!isNull player};
waitUntil {(vehicle player) == player};
waitUntil {(getPlayerUID player) != ""};
 
// Variable Name of the Player Character to be restricted. //
_reserved_units = [Reserved01];
 
// The player UID is a 17 digit number found in the profile tab. //
_reserved_uids =
[
"UIDXXXXXXXXXXXXXX"/* Add Player Name Here */,
"UIDXXXXXXXXXXXXXX"/* Add Player Name Here */,
"UIDXXXXXXXXXXXXXX"/* Add Player Name Here */
];
 
// Stores the connecting player's UID //
_uid = getPlayerUID player;
 
 
if ((player in _reserved_units)&& !(_uid in _reserved_uids)) then
    {
   titleText ["", "BLACK OUT"];
   disableUserInput true;
   hint "You are in a reserved slot! You will be kicked to the lobby in 15 seconds!";
   sleep 5;
   hint "You are in a reserved slot! You will be kicked to the lobby in 10 seconds!";
   sleep 5;
   hint "You are in a reserved slot! You will be kicked to the lobby in 5 seconds!";
   sleep 5;
   titleText ["", "BLACK IN"];
   disableUserInput false;
   failMission "end1";
    }; 
 };

10
Questions & Suggestions / Re: Reserved Slots
« on: Jun 23, 2016, 01:28 AM »
does that tool work with linux

11
General Discussion / Cleanup script
« on: Jun 19, 2016, 09:20 PM »
anyone know a good cleanup for wasteland?

12
Technical Support / Re: Can't run custom script
« on: Dec 14, 2015, 12:57 AM »
i Added it in and now i cant join the server it says reading mission file blank.... ? any idea how to fix that

13
Technical Support / Re: Can't run custom script
« on: Dec 11, 2015, 04:23 PM »
Well i add it to the top of clientFlagHandler.sqf and flagHandler.sqf but make sure that _playerUID is defined at the point u add the line.

My top lines of flagHandler.sqf :

and my clientFlagHandler.sqf :
Thanks much appreciated

14
Technical Support / Re: Can't run custom script
« on: Dec 08, 2015, 10:20 PM »
Hey we also use some custom Scripts and i have simply take out the Antihack only for admins. For that i simply added in the scripts:

if (_playerUID in ["Ur","Admin","IDs"]) exitWith{};

So the anthihack still works and only the Admins are abel to us the new Scripts.
Where do i add this script dude?

15
Technical Support / Re: Can't run custom script
« on: Dec 07, 2015, 02:08 AM »
You would potentially find what you're looking to edit in the antihack folder.
Ok i deleted the flaghandler but now everyone can join with hacks ;(

Pages: [1] 2