[REQUEST] Archlord database explanation

[mlukac89]

I will make CMS for Archlord so everyone who will need website for hes private server he just need to install it, so users will be able to register, login, change password, email .... admin panel where admin can controll users, posts, events, etc...

But before all that i need to know is all servers ep1 and ep2 use same database and what type is ?

[al3css]

same oracle 9i db...

[mlukac89]

can i setup it in phpmyadmin on localhost then, because i use mysql on localhost ?

[al3css]

nope...instal oracle 9i or oracle 11g or 10g and you need to use the archlord serverfiles/to make a test serverfiles in order to work with it

[patkica]

If would want to make myself a webpage using xampp I would use mysql database for ID and PW and other stuff like CC and **** for webpage only. Then i would install instantclient 12.1 for oracle. With PHP you are then able to connect to remote computer that host archlord server.

During register process your PHP script can access archlord oracle database on remote computer to create new/edit account. This way you give your users indirect access to gameserver database. Imo this almost eliminates violation of games database as you can check data from mysql before you access and change oracle database and you seperate forums, chantra store and other stuff to another computer decreasing database lag to high populated servers.

This is how i would do it. If you need webpage on same computer as gameserver is then you dont need instantclient 12.1 you only need to connect to oracle and know how to use oracle database queries...

[mlukac89]

Why complicate thing when it can be simple

i think something like this
its counting how many accounts is registered and can be visible only to admin

 
$query = $users->db->prepare("SELECT COUNT(*) FROM AMT_ACCOUNT");
$query->execute();
return $query->fetchColumn();

counts how many guilds is registered

$query = $guilds->db->prepare("SELECT COUNT(*) FROM GUILDMASTER");
$query->execute();
return $query->fetchColumn();

and for user login

$query = $users->db->prepare("SELECT COUNT(*) FROM AMT_ACCOUNT WHERE ACCOUNTID=? AND PASSWORD=?");
$query->bindValue(1, $username);
$query->bindValue(2, $password);
$query->execute();
$data = $query->fetch();
return $data['ACCOUNTID'];

So you can acess database directly with PDO its secure, and dont need other stuff, you get it now :P ?

So i need stuff like this AMT_ACCOUNT and what fields are in, and other stuff i can insert, update or delete data from

[patkica]

Ye thats all fine I supposed if you run webpage on same computer as gameserver is. I would not recomend that but hey tis your project

If you dont intend to have webserver on same computer then to avoid installing oracle you can only install client.I was thinking something like this...
Making database class than connect to database and keep connection open for quick access.

include("constants.php");
class MyDB
{
   /* Class constructor */
   function MyDB(){
      /* Make connection to database */
	/*  oracle database connection defined in contants.php  
	define("OCI_SERVER", "192.168.1.12");
	define("OCI_USER", "alef");
	define("OCI_PASS", "password");
	define("OCI_SERVICE", "account");
        define("SRV_WORLD", "MYworld1");  
	*/
	$this->connection2 = oci_connect(OCI_USER,OCI_PASS,OCI_SERVER ."/". OCI_SERVICE);
	if (!$this->connection2) {
		$e = oci_error();
	        trigger_error(htmlentities($e['message'], ENT_QUOTES), E_USER_ERROR);
	}
    }

	function oci_addNewUser($username, $password, $email){
		$time = date("d/m/y");
		$qstring = array();
		$qstring[0] = "INSERT INTO AMT_ACCOUNT (ACCOUNTID,PASSWORD) VALUES ('$username','$password')";
		$qstring[1] = "INSERT INTO AMT_MASTER VALUES ('$username' ,'$email' ,'18' ,to_timestamp('$time','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('$time','DD/MM/RR HH24:MI:SSXFF'),to_timestamp('$time','DD/MM/RR HH24:MI:SSXFF') ,null ,null ,null ,null ,null ,'N' ,'N' ,'0', null, null, null, null, null, null, null, null)";
		$qstring[2] = "INSERT INTO ACCOUNTWORLD (ACCOUNTID, WORLD, BANKMONEY, BANKSIZE) VALUES ('$username', '".SRV_WORLD."', '0', '0')";
		
		for ($i=0; $i<3; $i++){
				$q = oci_parse($this->connection2, $qstring[$i]);
				oci_execute($q);
		}
	}
};
$database = new MyDB;

Then you can register new players with
$database->oci_addNewUser($arg1, $arg2, $arg3);