From 72c0df785d4838d35dc694071c61e3f9a54e7e81 Mon Sep 17 00:00:00 2001
From: wanglizhong <wlz>
Date: 星期二, 22 四月 2025 14:08:26 +0800
Subject: [PATCH] fix: update init
---
.gitignore | 1
API/v1/SendSms.php | 10 +
inc/odbc1.asp | 2
API/v1/sms/SmsSend.php | 152 ++++++++++++++++++++++++++++++
web.config | 22 +---
API/inc/odbc_demo.asp | 2
API/v1/web.config | 26 +++++
API/v1/sms/SmsUtils.php | 31 ++++++
API/v3/inc/odbc.php | 2
API/inc/odbc.php | 2
weixin/JsonPost.gds | 21 +++
API/inc/odbc.asp | 2
inc/odbc.asp | 2
inc/chkadmin.gds | 2
inc/odbc.php | 2
web.config11 | 1
16 files changed, 251 insertions(+), 29 deletions(-)
diff --git a/.gitignore b/.gitignore
new file mode 100644
index 0000000..cd3d225
--- /dev/null
+++ b/.gitignore
@@ -0,0 +1 @@
+logs
\ No newline at end of file
diff --git a/API/inc/odbc.asp b/API/inc/odbc.asp
index 09d9da1..cd4e029 100644
--- a/API/inc/odbc.asp
+++ b/API/inc/odbc.asp
@@ -2,7 +2,7 @@
'杩炴帴鏁版嵁搴�
Set objConn = Server.CreateObject("ADODB.Connection")
'objConn.ConnectionString="Provider=SQLOLEDB.1;Password=1382929319;Persist Security Info=True;User ID=sa;Initial Catalog=CAME;Data Source=120.24.159.70;Connect Timeout=60"
-objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=CAME;Data Source=localhost;Connect Timeout=60"
+objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=CAME;Data Source=120.25.98.119,1432;Connect Timeout=60"
objConn.Open
'闃叉姢XSS锛宻ql娉ㄥ皠锛屼唬鐮佹墽琛岋紝鏂囦欢鍖呭惈绛夊绉嶉珮鍗辨紡娲�
diff --git a/API/inc/odbc.php b/API/inc/odbc.php
index 5d1b7e9..369f482 100644
--- a/API/inc/odbc.php
+++ b/API/inc/odbc.php
@@ -3,7 +3,7 @@
session_start();
//echo phpinfo();
//exit;
-$serverName = "localhost";//鏈嶅姟鍣ㄧ殑鍚嶅瓧锛屾湰鍦發ocalhost
+$serverName = "120.25.98.119,1432";//鏈嶅姟鍣ㄧ殑鍚嶅瓧锛屾湰鍦發ocalhost
$connectionInfo = array( "Database"=>"CAME", "UID"=>"camesa", "PWD"=>"camesa", "CharacterSet"=>"UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
diff --git a/API/inc/odbc_demo.asp b/API/inc/odbc_demo.asp
index ac99b43..00d0e3d 100644
--- a/API/inc/odbc_demo.asp
+++ b/API/inc/odbc_demo.asp
@@ -2,7 +2,7 @@
'杩炴帴鏁版嵁搴�
Set objConn = Server.CreateObject("ADODB.Connection")
'objConn.ConnectionString="Provider=SQLOLEDB.1;Password=1382929319;Persist Security Info=True;User ID=sa;Initial Catalog=CAME;Data Source=120.24.159.70;Connect Timeout=60"
-objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=came_demo;Data Source=localhost;Connect Timeout=60"
+objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=came_demo;Data Source=120.25.98.119,1432;Connect Timeout=60"
objConn.Open
'闃叉姢XSS锛宻ql娉ㄥ皠锛屼唬鐮佹墽琛岋紝鏂囦欢鍖呭惈绛夊绉嶉珮鍗辨紡娲�
diff --git a/API/v1/SendSms.php b/API/v1/SendSms.php
index 1666f2e..ff9c1c0 100644
--- a/API/v1/SendSms.php
+++ b/API/v1/SendSms.php
@@ -99,7 +99,13 @@
}
}
-
+function sendPayUrl($phone,$name,$payurl){
+ $content='銆愬尰鐤楀揩绾裤�戠Щ鍔ㄦ敮浠樻寚寮曪細'.$name.'鎮ㄥソ锛佽鐐瑰嚮浠ヤ笅閾炬帴杩涘叆淇℃伅纭鍜屾敮浠樼晫闈€�傛牳瀵规偍鐨勫嚭杞︿俊鎭棤璇悗锛屽彲閫夋嫨鏀粯瀹濇垨鑰呭井淇℃敮浠橈細' .$payurl;
+ require './sms/SmsSend.php';
+ $sms = new SmsSend('LTAIySpe19H0jIwE', 'eH9JQEZZCgFguaDfcCLUcpK6746tgT');
+ $result = $sms->sendSmsOne([['phone' => $phone, 'content' => $content]], '');
+ return $result;
+}
// 璋冪敤绀轰緥锛�
set_time_limit(0);
header('Content-Type: text/plain; charset=utf-8');
@@ -115,6 +121,8 @@
$name=empty($_REQUEST['name'])!=false ? "" : addslashes($_REQUEST['name']); //鍐呭--濮撳悕
$payurl=empty($_REQUEST['payurl'])!=false ? "" : addslashes($_REQUEST['payurl']); //鍐呭--鐭摼鎺ラ獙璇佺爜
$codejson=json_encode(array("name"=>$name,"payurl"=>$payurl), JSON_UNESCAPED_UNICODE);
+ sendPayUrl($Phone,$name,$payurl);
+ return;
}elseif ($lateCode=="SMS_172011256" or $lateCode=="SMS_219742082") {
//鍑鸿溅鐭俊
$UserName=empty($_REQUEST['UserName'])!=false ? "" : addslashes($_REQUEST['UserName']); //鍐呭--璐熻矗浜�
diff --git a/API/v1/sms/SmsSend.php b/API/v1/sms/SmsSend.php
new file mode 100644
index 0000000..7268c11
--- /dev/null
+++ b/API/v1/sms/SmsSend.php
@@ -0,0 +1,152 @@
+<?php
+require "SmsUtils.php";
+
+class SmsSend{
+ private $userName = "";
+ private $password = "";
+ private $address = "";
+
+ public function __construct($userName, $password, $address="http://sms.izjun.com:8001/sms") {
+ $this->userName = $userName;
+ $this->password = $password;
+ $this->address = $address;
+ }
+
+ public function sendSmsMass($phoneList, $content, $sendTime, $extcode, $callData) {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/sendMessageMass";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "content" => $content,
+ "phoneList" => $phoneList,
+ "timestamp" => $timestamp,
+ "sign" => $sign,
+ "sendTime" => $sendTime,
+ "extCode" => $extcode,
+ "callData" => $callData
+ );
+
+ // 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+ public function sendSmsOne($messageList, $sendTime) {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/sendMessageOne";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "timestamp" => $timestamp,
+ "sign" => $sign,
+ "messageList" => $messageList,
+ "sendTime" => $sendTime,
+ );
+
+ // 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+ public function getReport() {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/getReport";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "timestamp" => $timestamp,
+ "sign" => $sign,
+ );
+
+ // 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+ public function getUpstream() {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/getUpstream";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "timestamp" => $timestamp,
+ "sign" => $sign,
+ );
+
+ // 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+ public function getBalance() {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/getBalance";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "timestamp" => $timestamp,
+ "sign" => $sign,
+ );
+
+ // 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+ public function createTemplate($content) {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/createTemplate";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "timestamp" => $timestamp,
+ "sign" => $sign,
+ "content" => $content
+ );
+
+ // 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+ public function queryTemplate() {
+ // 鑾峰彇鏃堕棿鎴�
+ $timestamp = SmsUtils::getTimestamp();
+ // 鑾峰彇sign
+ $sign = SmsUtils::generateSign($this->userName, $this->password, $timestamp);
+ // 鑾峰彇url
+ $url = "http://" . $this->address . "/sms/api/queryTemplates";
+ // 璇锋眰鏁版嵁
+ $data = array(
+ "userName" => $this->userName,
+ "timestamp" => $timestamp,
+ "sign" => $sign
+ );
+
+ # 鍙戦�佽姹�
+ return SmsUtils::send($url, $data);
+ }
+
+}
+
+
+?>
\ No newline at end of file
diff --git a/API/v1/sms/SmsUtils.php b/API/v1/sms/SmsUtils.php
new file mode 100644
index 0000000..afcebce
--- /dev/null
+++ b/API/v1/sms/SmsUtils.php
@@ -0,0 +1,31 @@
+<?php
+// 鐭俊鍙戦�佸伐鍏风被
+class SmsUtils{
+ // 鑾峰彇鏃堕棿鎴�
+ public static function getTimestamp() {
+ return time() * 1000;
+ }
+
+ // 鐢熸垚sign
+ public static function generateSign($account, $password, $timestamp) {
+ $value = $account . $timestamp . md5($password);
+ return md5($value);
+ }
+
+ // post璇锋眰
+ public static function send($url, $data) {
+ // 瀹氫箟璇锋眰閫夐」
+ $options = [
+ 'http' => [
+ 'header' => "Content-Type: application/json;charset=utf-8\r\nAccept: application/json\r\n",
+ 'method' => 'POST',
+ 'content' => json_encode($data)
+ ]
+ ];
+ // 鍙戦�� HTTP 璇锋眰
+ $context = stream_context_create($options);
+ $result = file_get_contents($url, false, $context);
+ return $result;
+ }
+}
+?>
\ No newline at end of file
diff --git a/API/v1/web.config b/API/v1/web.config
new file mode 100644
index 0000000..b6458c3
--- /dev/null
+++ b/API/v1/web.config
@@ -0,0 +1,26 @@
+<?xml version="1.0" encoding="UTF-8"?>
+<configuration>
+ <system.webServer>
+ <defaultDocument>
+ <files>
+ <remove value="default.aspx" />
+ <remove value="Default.htm" />
+ <remove value="Default.asp" />
+ <remove value="index.htm" />
+ <remove value="index.html" />
+ <remove value="iisstart.htm" />
+ <add value="index.gds" />
+ </files>
+ </defaultDocument>
+ <handlers>
+ <remove name="php" />
+ <remove name="FastCGI" />
+ <add name="gds" path="*.gds" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\System32\inetsrv\asp.dll" resourceType="File" preCondition="bitness64" />
+ <add name="FastCGI" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="D:\project\鎬ユ晳杞繍\code\php\php-cgi.exe" resourceType="File" requireAccess="Script" />
+ <add name="php" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="C:\php\php-cgi.exe" resourceType="File" requireAccess="Script" />
+ </handlers>
+ <httpErrors errorMode="DetailedLocalOnly" />
+
+
+ </system.webServer>
+</configuration>
diff --git a/API/v3/inc/odbc.php b/API/v3/inc/odbc.php
index 0c1bbe4..fa984f8 100644
--- a/API/v3/inc/odbc.php
+++ b/API/v3/inc/odbc.php
@@ -3,7 +3,7 @@
session_start();
//echo phpinfo();
//exit;
-$serverName = "localhost";//鏈嶅姟鍣ㄧ殑鍚嶅瓧锛屾湰鍦發ocalhost
+$serverName = "120.25.98.119,1432";//鏈嶅姟鍣ㄧ殑鍚嶅瓧锛屾湰鍦發ocalhost
$connectionInfo = array( "Database"=>"Welcab", "UID"=>"camesa", "PWD"=>"camesa", "CharacterSet"=>"UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
diff --git a/inc/chkadmin.gds b/inc/chkadmin.gds
index 8158afb..43ed437 100644
--- a/inc/chkadmin.gds
+++ b/inc/chkadmin.gds
@@ -15,7 +15,7 @@
Response.Cookies("CAMEName").Expires=Date+30
Set adminrs = Server.CreateObject("ADODB.Recordset")
If Len(admin)=11 And IsNumeric(admin) Then SqlPhone=" or OA_mobile='"&admin&"'"
- If admin="vicgame" And loginAuthorize="123" Then '娴嬭瘯璐﹀彿
+ If admin="13602220409" or admin="13710299733" And loginAuthorize="123" Then '娴嬭瘯璐﹀彿
sql="select * from OA_User where (OA_User='"&admin&"'"&SqlPhone&") and OA_execLevel>=0"
ElseIf Cookieslogin="YES" Then 'Cookies鐧婚檰
sql="select * from OA_User where (OA_User='"&admin&"') and OA_execLevel>=0"
diff --git a/inc/odbc.asp b/inc/odbc.asp
index b3ca34c..fbd4868 100644
--- a/inc/odbc.asp
+++ b/inc/odbc.asp
@@ -2,7 +2,7 @@
'杩炴帴鏁版嵁搴�
Set objConn = Server.CreateObject("ADODB.Connection")
'objConn.ConnectionString="Provider=SQLOLEDB.1;Password=1382929319;Persist Security Info=True;User ID=sa;Initial Catalog=CAME;Data Source=120.24.159.70;Connect Timeout=60"
-objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=CAME;Data Source=localhost;Connect Timeout=60"
+objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=CAME;Data Source=120.25.98.119,1432;Connect Timeout=60"
objConn.Open
'闃叉姢XSS锛宻ql娉ㄥ皠锛屼唬鐮佹墽琛岋紝鏂囦欢鍖呭惈绛夊绉嶉珮鍗辨紡娲�
diff --git a/inc/odbc.php b/inc/odbc.php
index 1ce86bc..485279c 100644
--- a/inc/odbc.php
+++ b/inc/odbc.php
@@ -3,7 +3,7 @@
session_start();
//echo phpinfo();
//exit;
-$serverName = "localhost";//鏈嶅姟鍣ㄧ殑鍚嶅瓧锛屾湰鍦發ocalhost
+$serverName = "120.25.98.119,1432";//鏈嶅姟鍣ㄧ殑鍚嶅瓧锛屾湰鍦發ocalhost
$connectionInfo = array( "Database"=>"CAME", "UID"=>"camesa", "PWD"=>"camesa", "CharacterSet"=>"UTF-8");
$conn = sqlsrv_connect( $serverName, $connectionInfo);
if( $conn ) {
diff --git a/inc/odbc1.asp b/inc/odbc1.asp
index f98668e..ae23168 100644
--- a/inc/odbc1.asp
+++ b/inc/odbc1.asp
@@ -2,7 +2,7 @@
'杩炴帴鏁版嵁搴�
Set objConn = Server.CreateObject("ADODB.Connection")
'objConn.ConnectionString="Provider=SQLOLEDB.1;Password=1382929319;Persist Security Info=True;User ID=sa;Initial Catalog=CAME;Data Source=120.24.159.70;Connect Timeout=60"
-objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=CAME;Data Source=localhost;Connect Timeout=60"
+objConn.ConnectionString="Provider=SQLOLEDB.1;Password=camesa;Persist Security Info=True;User ID=camesa;Initial Catalog=CAME;Data Source=120.25.98.119,1432;Connect Timeout=60"
objConn.Open
'闃叉姢XSS锛宻ql娉ㄥ皠锛屼唬鐮佹墽琛岋紝鏂囦欢鍖呭惈绛夊绉嶉珮鍗辨紡娲�
diff --git a/web.config b/web.config
index 258b66f..2ee158a 100644
--- a/web.config
+++ b/web.config
@@ -13,24 +13,14 @@
</files>
</defaultDocument>
<handlers>
+ <remove name="php" />
<remove name="FastCGI" />
<add name="gds" path="*.gds" verb="*" modules="IsapiModule" scriptProcessor="C:\Windows\System32\inetsrv\asp.dll" resourceType="File" preCondition="bitness64" />
- <add name="FastCGI" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="C:\php\php-cgi.exe" resourceType="File" requireAccess="Script" />
+ <add name="FastCGI" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="D:\project\鎬ユ晳杞繍\code\php\php-cgi.exe" resourceType="File" requireAccess="Script" />
+ <add name="php" path="*.php" verb="*" modules="FastCgiModule" scriptProcessor="C:\php\php-cgi.exe" resourceType="File" requireAccess="Script" />
</handlers>
- <staticContent>
- <mimeMap fileExtension=".wasm" mimeType="video/x-ms-wmv" />
- </staticContent>
- <rewrite>
- <rules>
- <rule name="sys" stopProcessing="true">
- <match url="(.*)" />
- <conditions>
- <add input="{HTTPS}" pattern="^OFF$" />
- <add input="{HTTPS_HOST}" pattern="^(localhst)" negate="true" />
- </conditions>
- <action type="Redirect" url="https://{HTTP_HOST}/{R:1}" />
- </rule>
- </rules>
- </rewrite>
+ <httpErrors errorMode="DetailedLocalOnly" />
+
+
</system.webServer>
</configuration>
diff --git a/web.config11 b/web.config11
index 7839eba..4e74515 100644
--- a/web.config11
+++ b/web.config11
@@ -19,4 +19,3 @@
<directoryBrowse enabled="false" />
</system.webServer>
</configuration>
-ion>
diff --git a/weixin/JsonPost.gds b/weixin/JsonPost.gds
index 2fa09cd..463c194 100644
--- a/weixin/JsonPost.gds
+++ b/weixin/JsonPost.gds
@@ -1,4 +1,18 @@
<!--#include virtual="/inc/odbc1.asp"-->
+<script language="jscript" runat="server">
+Array.prototype.get = function(i)
+{
+ return this[i];
+};
+function getjson(str){
+ try{
+ eval("var jsonStr = (" + str + ")");
+ }catch(ex){
+ var jsonStr = null;
+ }
+ return jsonStr;
+}
+</script>
<%
'鎺ュ彛淇℃伅
corpid="wx248505bfbab6d0c1"
@@ -61,16 +75,17 @@
'鑾峰彇鏂扮殑access_token
url="https://qyapi.weixin.qq.com/cgi-bin/gettoken" '//瀹氫箟瑕佽幏鍙栨簮浠ｇ爜鐨勭綉鍧�锛屼竴鑸槸閫氳繃鍙橀噺浼犻�掕繃鏉�
Origin="corpid="&corpid&"&corpsecret="&corpsecret
- HTMLCODE= GetBody(url,Origin)
- 'Response.Write url&"?"&Origin
+ HTMLCODE= GetBody(url,Origin)
str="["&HTMLCODE&"]"
+ 'Response.Write url&"?"&Origin
+ Response.write str
set obj = getjson(str)
access_token = obj.get(0).access_token
expires_in = obj.get(0).expires_in
'access_token=replace(replace(HTMLCODE,"{""access_token"":""",""),""",""expires_in"":7200}","")
access_token_time=DateAdd("s",500,now())
'鍐欏叆鏁版嵁搴�
- sql="update dictionary set vtext='"&access_token&"',vMono='"&access_token_time&"' where id="&access_tokenID
+ sql="update dictionary set vtext='"&access_token&"',vMono='"&access_token_time&"' where id="&access_tokenID
objConn.Execute sql
End if
--
Gitblit v1.9.1