Sorry, a bit late. You should should have gotten a PM.
C:\WINDOWS\system32>setlocal
C:\WINDOWS\system32>cd /d C:\RUNEWA~1\RASERV~1\
C:\RUNEWA~1\RASERV~1>RAServerController.exe -install
(5) Service Start ServiceCtrlDispatcher
(5) Service Failed to create service, error code = 1073
(5) Service Start ServiceCtrlDispatcher RunService == false
C:\RUNEWA~1\RASERV~1>pause
Press any key to continue . . .
Am I too late to the party for all this latest stuff ?. I've been out of the game for so many years, popped my head back in here cause I got a Dell PowerEgde server with 192gb of Ram at a fair price, and for giggles I tackled the old 6.0.7 setup since I still had those old files.
INSERT into ImportMail (WorldID,GmName,ToName,Title,Content,OrgObjID,Count,Mode,IP,Money,ExValue,Ability,Durable,CreateTime,Serial) VALUES (1,N'GM Lifefire',N'Lifefire',N'Item with Stat',N'Item w/ Guard of Eons',212500,1,-1,N'10.10.10.10',0,681060,cast( 0x5437000000000000000000000000000000000000 as binary(32)),0,1681146648,24001043);
<!DOCTYPE html>
<html lang="en">
<head>
<meta charset="UTF-8">
<meta name="viewport" content="width=device-width, initial-scale=1.0">
<title>Insert Data</title>
</head>
<body>
<h1>Insert Data into ImportMail</h1>
<form action="insert_data.php" method="post">
<label for="worldID">WorldID:</label>
<input type="number" id="worldID" name="worldID" required>
<br><br>
<label for="gmName">GmName:</label>
<input type="text" id="gmName" name="gmName" required>
<br><br>
<label for="toName">ToName:</label>
<input type="text" id="toName" name="toName" required>
<br><br>
<label for="title">Title:</label>
<input type="text" id="title" name="title" required>
<br><br>
<label for="content">Content:</label>
<input type="text" id="content" name="content" required>
<br><br>
<label for="orgObjID">OrgObjID:</label>
<input type="number" id="orgObjID" name="orgObjID" required>
<br><br>
<label for="count">Count:</label>
<input type="number" id="count" name="count" required>
<br><br>
<label for="mode">Mode:</label>
<input type="number" id="mode" name="mode" required>
<br><br>
<label for="ip">IP:</label>
<input type="text" id="ip" name="ip" required>
<br><br>
<label for="money">Money:</label>
<input type="number" id="money" name="money" required>
<br><br>
<label for="exValue">ExValue:</label>
<input type="number" id="exValue" name="exValue" required>
<br><br>
<label for="ability">Ability:</label>
<input type="text" id="ability" name="ability" required>
<br><br>
<label for="durable">Durable:</label>
<input type="number" id="durable" name="durable" required>
<br><br>
<label for="createTime">CreateTime:</label>
<input type="number" id="createTime" name="createTime" required>
<br><br>
<label for="serial">Serial:</label>
<input type="number" id="serial" name="serial" required>
<br><br>
<input type="submit" value="Submit">
</form>
</body>
</html>
<?php
// Database connection variables
$servername = "localhost";
$username = "your_username";
$password = "your_password";
$dbname = "your_database";
// Establish a connection using SQLSRV
$connectionInfo = array("UID" => $username, "PWD" => $password, "Database" => $dbname);
$conn = sqlsrv_connect($servername, $connectionInfo);
// Check connection
if (!$conn) {
die(print_r(sqlsrv_errors(), true));
}
// Get values from the form
$worldID = $_POST['worldID'];
$gmName = $_POST['gmName'];
$toName = $_POST['toName'];
$title = $_POST['title'];
$content = $_POST['content'];
$orgObjID = $_POST['orgObjID'];
$count = $_POST['count'];
$mode = $_POST['mode'];
$ip = $_POST['ip'];
$money = $_POST['money'];
$exValue = $_POST['exValue'];
$ability = $_POST['ability'];
$durable = $_POST['durable'];
$createTime = $_POST['createTime'];
$serial = $_POST['serial'];
// Prepare the SQL query
$sql = "INSERT INTO ImportMail (
WorldID, GmName, ToName, Title, Content, OrgObjID, Count, Mode, IP, Money, ExValue, Ability, Durable, CreateTime, Serial
) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)";
// Bind parameters and execute the query
$params = array($worldID, $gmName, $toName, $title, $content, $orgObjID, $count, $mode, $ip, $money, $exValue, $ability, $durable, $createTime, $serial);
$stmt = sqlsrv_prepare($conn, $sql, $params);
$result = sqlsrv_execute($stmt);
// Check if the insertion was successful
if ($result) {
echo "Data inserted successfully!";
} else {
echo "Error: " . $sql . "<br>" . print_r(sqlsrv_errors(), true);
}
// Close the connection
sqlsrv_free_stmt($stmt);
sqlsrv_close($conn);
?>