-
Posts
279 -
Joined
-
Last visited
-
Days Won
3
Content Type
Profiles
Forums
Articles
Posts posted by Bricktop
-
-
I have a problem with players using the "endmission" cheat to dupe - Is there a way to block this ?
__________
Help would be appreciated!
-
-
Sorry to bug you guys but I'm still having a problem where players are using the "endmission" cheat which is allowing them to disconnect / dupe
I think this is the solution but not sure where this line goes -
_nil = execVM "scripts\player_kick.sqf";
__________
Help would be appreciated!
-
Hi guys,
Great script seems to be working after first install attempt even though I left this part out because I didn't know where to put it:
If you use endMission "SOME", like in nosidechat.sqf, chenge to:
_nil = execVM "scripts\player_kick.sqf";
in player_kick.sqf:
kickme = true;
I guess just make the player_kick.sqf and drop it in the scripts folder
But where to put
_nil = execVM "scripts\player_kick.sqf";
__________
Thanks for any info
-
8 hours ago, seelenapparat said:
same for me.
of my 4 servers, only the takistan one has this strange error.
my startparams of the servers are fine, but somehow the dzlauncher shows epoch first and then overwatch.
which is obviously wrong.
I sent a mail to the dz launcher guys.
Ill report back, when I know more.
Man it's nice to know I'm not alone! This has killed my server because most players don't realize what's going on and just give up because of errors.
Lucky for me I do have a faithful few that figured out how to change the order and were able to join.
Hope they work this out soon - It sucks to pay for counter productive advertising :(
-
I'm sure this is not the place for this but I can't seem to get an answer from support and discord bot sucks my brain every time I try to ask a question so here goes ....
__________
I run an Overpoch server and I paid to sponsor my server on Dayz Launcher - now it sometimes shows up twice :
__________
ManUp|999k-START|BANK|TANK|JET|SLOW-Z|SNAP-V|GROUP
IP: 198.154.118.40:2802 | DayZ Overpoch |DayZ Epoch (( <<-- NOTE MOD ORDER ))
__________
AND
__________
ManUp|999k-START|BANK|TANK|JET|SLOW-Z|SNAP-V|GROUP
IP: 198.154.118.40:2802 | DayZ Epoch |DayZ Overpoch (( <<-- NOTE MOD ORDER ))
__________
When a player clicks on the second link it totally screws them causing errors / missing content / etc. and they can not join.
The first link works perfect and players join just fine.
__________
My player count went from 25 to 4 in one day!
Is there anything I can do myself to fix this or am I at the mercy of the dev and the non existent staff??
__________
Thanks and sorry to bother you guys with this but It's been days now and I don't know where else to turn ...
-
I have my events set up like this - They don't seem to spawn like they should. I set the spawn percentage for all events from 50% to 90% - some of them spawn but others never do.
I would guess it may have something to do with the way I have the timers set?
Is this correct or does it need changed? ( 2 hour restarts )
__________
EpochEvents =[["any","any","any","any",15,"supply_drop"],["any","any","any","any",25,"bombcrate"],["any","any","any","any",35,"rubble_town"],["any","any","any","any",45,"labyrinth"],["any","any","any","any",0,"abandonedvaults"],["any","any","any","any",20,"supply_building_drop"],["any","any","any","any",30,"ki_money_transport"],["any","any","any","any",40,"ki_immobile_transport"]];
__________
Thanks for any advice
-
last question - Do I need to do this if I run Overpoch?
5. If using ESS spawn selector: (IM USING EPOCH)
In dayz_server\compile\server_playerSetup.sqf find this block:
Epoch: http://pastebin.com/LiJ3HXvg
vanilla dayz: http://pastebin.com/aCMQ9tD1
Replace the whole block with this:Code:if (_randomSpot) then { if (!isDedicated) then {endLoadingScreen;}; _debug = getMarkerpos "respawn_west"; _worldspace = [0,[_debug select 0,_debug select 1,0.3]]; };
-
-
Like this?
_______________
while { _timeOut < 12000 } do {
if (dayz_clientPreload && dayz_authed) exitWith { diag_log "PLOGIN: Login loop completed!"; };
if (!isNil "_display") then {
if ( isNull _display ) then {
waitUntil { !dialog; };
startLoadingScreen ["","RscDisplayLoadCustom"];
_display = uiNameSpace getVariable "BIS_loadingScreen";
_control1 = _display displayctrl 8400;
_control2 = _display displayctrl 102;
};if ( dayz_loadScreenMsg != "" ) then {
_control1 ctrlSetText dayz_loadScreenMsg;
dayz_loadScreenMsg = "";
};
_control2 ctrlSetText format["%1",round(_timeOut*0.01)];
};_timeOut = _timeOut + 1;
if (_timeOut >= 12000) then {
1 cutText [localize "str_player_login_timeout", "PLAIN DOWN"];
sleep 10;
endLoadingScreen;
endMission "END1";
};
sleep 0.01;
};_____________________
Change it to:
_____________________
while { _timeOut < 12000 } do {
if (dayz_clientPreload && dayz_authed) exitWith {
diag_log "PLOGIN: Login loop completed!";
endLoadingScreen;
}; -
-
On 8/30/2016 at 1:56 PM, juandayz said:
,mmmm @Bricktop take a look on step 5. Youre doing fine this step?
In dayz_server\compile\server_playerSetup.sqf find this block:
if (_randomSpot) then {private["_counter","_position","_isNear","_isZero","_mkr"];if (!isDedicated) then {endLoadingScreen;};//Spawn modify via mission init.sqfif(isnil "spawnArea") then {spawnArea = 1500;};if(isnil "spawnShoremode") then {spawnShoremode = 1;};//_spawnMC = actualSpawnMarkerCount;//spawn into random_findSpot = true;_mkr = "";while {_findSpot} do {_counter = 0;while {_counter < 20 && _findSpot} do {// switched to floor_mkr = "spawn" + str(floor(random _spawnMC));_position = ([(getMarkerPos _mkr),0,spawnArea,10,0,2000,spawnShoremode] call BIS_fnc_findSafePos);_isNear = count (_position nearEntities ["Man",100]) == 0;_isZero = ((_position select 0) == 0) && ((_position select 1) == 0);//Island Check //TeeChange_pos = _position;_isIsland = false; //Can be set to true during the Checkfor [{_w=0},{_w<=150},{_w=_w+2}] do {_pos = [(_pos select 0),((_pos select 1) + _w),(_pos select 2)];if(surfaceisWater _pos) exitWith {_isIsland = true;};};if ((_isNear && !_isZero) || _isIsland) then {_findSpot = false};_counter = _counter + 1;};};_isZero = ((_position select 0) == 0) && ((_position select 1) == 0);_position = [_position select 0,_position select 1,0];if (!_isZero) then {//_playerObj setPosATL _position;_worldspace = [0,_position];};};Delete and replace the whole block with:
if (_randomSpot) then { if (!isDedicated) then {endLoadingScreen;}; _debug = getMarkerpos "respawn_west"; _worldspace = [0,[_debug select 0,_debug select 1,0.3]]; };
Remember repack your pbo
Yes I did this exact and still the error persists ... any other ideas?
-
-
Thanks for the reply raymix - at least I know it's something to do with vectors now :)
-
On 8/29/2016 at 2:55 PM, carl101 said:
Hi guys, iv been away from epoch for sometime but have suddenly got the urge to get back into it, hoping someone could point me to a server thats half decent.
I would like a server with as less scripts on as possible, kinda fed up with the whole easy mode thing.
I dont really want a server thats constantly full, just somehwere around the 10-15 player mark?
let me know of any reccomendations please
Hey man glad to see you coming back - I took a 3 month break myself then when I came back I decided to host my own server -
Here's the info but basically it has the required mods to enjoy the game and a few others that were requested by players.
The server is still new (3 weeks) and the population stays between 5 and 20 depending on the time of day.
I do not use admin - I decided to do it all myself - this eliminated "Admin Abuse" 100% - I'm on the server 12+ hours a day to answer questions or offer help if needed.
The server is prepaid for the next three months and sponsored on Dayz Launcher.
Server Location is in the USA and normal ping is around 60
__________
Come check it out for yourself -
http://steamcommunity.com/groups/survivalgaminginc/discussions/5/352792037323401129/
-
This error still persists and I feel like it could be the root of our player re-spawn issue.
Any other ideas? I've uninstalled and reinstalled - tried different class.hpp files and nothing changed
_____
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1_____
My class.hpp
https://gist.github.com/anonymous/f8ba28ae9959867c53e474ebefc9f935
-
-
Hey guys I have a issue and I can't find the source.
_____
The Example:
right click build on cinder wall and place it
right click build on second cinder wall - scroll and click Snap: Off
press F to snap - second cinder wall snaps crooked to first cinder wall
press Q to fix - wall over rotates
change degree to 15 press Q
change degree to 5 press Q
change degree to 1 press Q
change degree to 0.1 press Q until it lines up even
press space bar ...
_____
Every single time anyone tries to use snap this is the process we must go through to get walls / floors to line up.
Not much fun and extremely time consuming - Any Ideas??
_____
Thanks
-
1 hour ago, juandayz said:
heres my class.hpp i compared with yours and have same numbers of brackets and ; but your rpt says your missing a ; strange.
try with my class.hpp
class ClassDialog
{
idd = -1;
movingenable = 0;
class controlsBackground
{
class ClassBackground: RscText
{
text = "";
x = .31 * safezoneW + safezoneX;
y = .3 * safezoneH + safezoneY;
w = .138504 * safezoneW;
h = .325 * safezoneH;
colorBackground[] = {.3,.3,.3,1};
fixedWidth = 0;
};
};
class Controls
{
class ClassSelect: RscText
{
text = "Class Selection";
x = .31 * safezoneW + safezoneX;
y = .26 * safezoneH + safezoneY;
w = .138504 * safezoneW;
h = .04025 * safezoneH;
colorText[] = {1,1,1,1};
colorBackground[] = {.384,.702,.886,.8};
fixedWidth = 0;
shadow = 1;
sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * .6)";
};
class ClassList
{
idc = 8888;
x = .31 * safezoneW + safezoneX;
y = .303 * safezoneH + safezoneY;
w = .138504 * safezoneW;
h = .25 * safezoneH;
autoScrollDelay = 5;
autoScrollRewind = 0;
autoScrollSpeed = -1;
colorSelect[] = {};
colorSelectBackground[] = {.5,.5,.5,1};
colorText[] = {.88,.88,.88,1};
font = "Zeppelin32";
maxHistoryDelay = 1;
onLBSelChanged = "call classPreview;";
rowHeight = .04;
class ScrollBar
{
arrowEmpty = "\ca\ui\data\arrow_up_ca.paa";
arrowFull = "\ca\ui\data\arrow_up_ca.paa";
border = "\ca\ui\data\ui_border_scroll_ca.paa";
color[] = {.5,.5,.5,.5};
colorActive[] = {.5,.5,.5,.3};
colorDisabled[] = {.5,.5,.5,.1};
shadow = 0;
thumb = "";
};
sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * .6)";
soundSelect[] = {"",.1,1};
style = 16;
type = 5;
};
class ClassButton
{
idc = 8889;
text = "Select Class";
x = .324 * safezoneW + safezoneX;
y = .567 * safezoneH + safezoneY;
w = .109 * safezoneW;
h = .044 * safezoneH;
action = "call classPick;";
borderSize = 0;
colorBackground[] = {.4,.4,.4,1};
colorBackgroundActive[] = {.5,.5,.5,1};
colorBackgroundDisabled[] = {.2,.2,.2,1};
colorBorder[] = {.88,.88,.88,1};
colorDisabled[] = {.2,.2,.2,1};
colorFocused[] = {.4,.4,.4,1};
colorShadow[] = {0,0,0,0};
colorText[] = {1,1,1,1};
font = "Zeppelin32";
offsetPressedX = .002;
offsetPressedY = .002;
offsetX = .003;
offsetY = .003;
sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * .6)";
soundClick[] = {"\ca\ui\data\sound\onclick",.07,1};
soundEnter[] = {"\ca\ui\data\sound\onover",.09,1};
soundEscape[] = {"\ca\ui\data\sound\onescape",.09,1};
soundPush[] = {"\ca\ui\data\sound\new1",0,0};
style = 2;
type = 1;
};
};
};After installing your class.hpp everything still seems to be working - the strange thing is your hpp file is 4kb and my hpp file is 3kb
I cleared the server rpt restarted and still got the error:
____________
8:29:20 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:20 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:20 Error Missing ;
8:29:20 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1
8:29:21 Error in expression <cur_mp.chernarus\spawn\class.hpp"
class ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error position: <ClassDialog
{
idd = -1;
movingenable = 0>
8:29:21 Error Missing ;
8:29:21 File mpmissions\__cur_mp.chernarus\spawn\class.hpp, line 1______________
Thanks as always Juan!
-
17 minutes ago, juandayz said:
heres my class.hpp i compared with yours and have same numbers of brackets and ; but your rpt says your missing a ; strange.
try with my class.hpp
class ClassDialog
{
idd = -1;
movingenable = 0;
class controlsBackground
{
class ClassBackground: RscText
{
text = "";
x = .31 * safezoneW + safezoneX;
y = .3 * safezoneH + safezoneY;
w = .138504 * safezoneW;
h = .325 * safezoneH;
colorBackground[] = {.3,.3,.3,1};
fixedWidth = 0;
};
};
class Controls
{
class ClassSelect: RscText
{
text = "Class Selection";
x = .31 * safezoneW + safezoneX;
y = .26 * safezoneH + safezoneY;
w = .138504 * safezoneW;
h = .04025 * safezoneH;
colorText[] = {1,1,1,1};
colorBackground[] = {.384,.702,.886,.8};
fixedWidth = 0;
shadow = 1;
sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * .6)";
};
class ClassList
{
idc = 8888;
x = .31 * safezoneW + safezoneX;
y = .303 * safezoneH + safezoneY;
w = .138504 * safezoneW;
h = .25 * safezoneH;
autoScrollDelay = 5;
autoScrollRewind = 0;
autoScrollSpeed = -1;
colorSelect[] = {};
colorSelectBackground[] = {.5,.5,.5,1};
colorText[] = {.88,.88,.88,1};
font = "Zeppelin32";
maxHistoryDelay = 1;
onLBSelChanged = "call classPreview;";
rowHeight = .04;
class ScrollBar
{
arrowEmpty = "\ca\ui\data\arrow_up_ca.paa";
arrowFull = "\ca\ui\data\arrow_up_ca.paa";
border = "\ca\ui\data\ui_border_scroll_ca.paa";
color[] = {.5,.5,.5,.5};
colorActive[] = {.5,.5,.5,.3};
colorDisabled[] = {.5,.5,.5,.1};
shadow = 0;
thumb = "";
};
sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * .6)";
soundSelect[] = {"",.1,1};
style = 16;
type = 5;
};
class ClassButton
{
idc = 8889;
text = "Select Class";
x = .324 * safezoneW + safezoneX;
y = .567 * safezoneH + safezoneY;
w = .109 * safezoneW;
h = .044 * safezoneH;
action = "call classPick;";
borderSize = 0;
colorBackground[] = {.4,.4,.4,1};
colorBackgroundActive[] = {.5,.5,.5,1};
colorBackgroundDisabled[] = {.2,.2,.2,1};
colorBorder[] = {.88,.88,.88,1};
colorDisabled[] = {.2,.2,.2,1};
colorFocused[] = {.4,.4,.4,1};
colorShadow[] = {0,0,0,0};
colorText[] = {1,1,1,1};
font = "Zeppelin32";
offsetPressedX = .002;
offsetPressedY = .002;
offsetX = .003;
offsetY = .003;
sizeEx = "(((((safezoneW / safezoneH) min 1.2) / 1.2) / 25) * .6)";
soundClick[] = {"\ca\ui\data\sound\onclick",.07,1};
soundEnter[] = {"\ca\ui\data\sound\onover",.09,1};
soundEscape[] = {"\ca\ui\data\sound\onescape",.09,1};
soundPush[] = {"\ca\ui\data\sound\new1",0,0};
style = 2;
type = 1;
};
};
};Testing now thank you!
-
-
Thanks @ seelenapparat - Does it matter what I name it?
The class.hpp is default from github - I didn't change anything ...
Here's the link: https://github.com/ebaydayz/ESSV2
Still a bit confused - It actually uses class Class in several places - should I change them all?
class ClassDialog
class ClassSelect
class ClassList
class ClassButton
I guess I'll try this and first and give it a push - What's the worst that can happen :)
class Dialog
__________
EDIT: After changing class ClassDialog to class Dialog the result was stuck on class selection without any choices ...
http://steamcommunity.com/sharedfiles/filedetails/?id=752895543
-
The Error:
----------
My class.hpp I don't see the missing ;
https://gist.github.com/anonymous/f8ba28ae9959867c53e474ebefc9f935
----------
Not sure how to fix this and would appreciate any advice.
Thanks -
-
Hey guys I've been reading so many posts about this and honestly I've become more confused than anything. I just want to run two events to take care of my base decay/maintenance/removal.
I already understand the basics :
In my hive I set to -1
=============================================
I currently have this sql to set damage:
UPDATE `object_data` SET `Damage`=0.1 WHERE `ObjectUID` <> 0 AND `CharacterID` <> 0 AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 3 DAY) AND ( (`Inventory` IS NULL) OR (`Inventory` = '[]') )
=============================================
BUT I also found this: Is it better?
UPDATE `object_data`
SET `Damage` = IF( `Damage` = 0.0, 0.1, `Damage` + 0.1 )
WHERE `LastUpdated` <= DATE_SUB(NOW(), INTERVAL 1 DAY)
AND `Classname` REGEXP 'wall|floor|door|ladder|stair'============================================
I found this sql to remove the decayed / abandoned bases:
CREATE EVENT `removeObjectOld` ON SCHEDULE EVERY 1 DAY COMMENT 'Removes old objects and vehicles' DO DELETE FROM `Object_DATA` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 24 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 42 DAY)
============================================
MY GOAL: Set bases to decay daily and require maintenance ALSO to have all abandoned bases completely removed from the server after 7 days untouched.
============================================
Not exactly sure what sql's to run here - Thanks for any assistance sorting this out ...
/////////////////////////////////////\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\\
E D I T ::
This is what I'm trying - Will it work? (RUNNING ON TEST SERVER- NO BASES) Don't want to delete bases on live server by mistake.
(Every 2 hours with restart) Set damage: UPDATE `object_data`SET `Damage` = IF ( `Damage` = 0.0, 0.1, `Damage` + 0.1 ) WHERE `LastUpdated` <= DATE_SUB(NOW(), INTERVAL 1 DAY) AND `Classname` REGEXP 'wall|floor|door|ladder|stair'
(Once a day) Remove old bases: DELETE FROM `object_data` WHERE `LastUpdated` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 7 DAY) AND `Datestamp` < DATE_SUB(CURRENT_TIMESTAMP, INTERVAL 14 DAY)
endmission cheaters - need fix please
in General Discussion.
Posted
Just wanted to share the fix - Thanks Shawn!