Help with ETNA Userbase

Blitz3D Forums/Blitz3D Beginners Area/Help with ETNA Userbase

Guy Fawkes

(Posted 2012) [#1]

Hi all. Recently, I've been putting together a login system, using the ETNA Plugin... Now I've run into a problem that I cannot solve... Can someone please tell me why ETNA_Receive(), is returning a 0, when it should be returning a 1?

Userlib function in user32.decls for api_messagebox():

.lib "user32.dll"
api_MessageBox% (hwnd%, lpText$, lpCaption$, wType%) : "MessageBoxA"

Function die(msg$) (Returns an API Messagebox of a value or string):

Function die(msg$)
    Return api_messagebox(0, msg$, msg$, 0)
End Function

Function Check_Login(username$, password$):

Function Check_Login$(username$, password$)

;CHECK USER LOGIN!
ETNA_Send(GET_VALUE, "ETNA_Userbase_encrypted.php?option=checklogin", True) ; Set the third parameter to True to have encryption
	
	die("Etna Receive: "+ETNA_Receive(GET_VALUE))
	die("Etna_GetState: "+ETNA_GetState())

	If ETNA_Receive(GET_VALUE) Then
		If ETNA_GetState() = ETNA_OK Then
			LoginCheck = ETNA_GetResult()
			FinalCheck = LoginCheck
		Else
			call_errors()
		EndIf
				
	EndIf
	
	Return FinalCheck

End Function

How I call the username check:

final_check = Check_Login(username$, password$)

Where, username$ & password$ are the input boxes in my Login System

ETNA_encryption.php:

<?php

//////////////////////////////////////////////////////////////////////////
////       ETNA functions needed for the encryption/decryption        ////
////     Use them in your php if you are using with encryption        ////
//// Just do: "include 'ETNA_encryption.php';" at the top of your php ////
//////////////////////////////////////////////////////////////////////////
function ETNA_GetArg($key) 
{
	$ETNA_argEncrypted = array_key_exists("ETNA_argEncrypted",$_GET) ? $_GET["ETNA_argEncrypted"] : "";
	$ETNA_arg = ETNA_Decrypt($ETNA_argEncrypted, $key);
	parse_str($ETNA_arg, $ETNA_arrayArg);
	return $ETNA_arrayArg;
}


// RC4 function to encrypt or decrypt		
function ETNA_Rc4($inp, $key)
{
	for($i = 0; $i <= 255; $i++)
	{
		$S[$i]=$i;
	}
	
	$j=0;
	for($i = 0; $i <= 255; $i++)
	{
		if($j >= strlen($key))
		{
			$j=0;
		}
		$K[$i]=ord(substr($key,$j,1));
		$j=$j+1;
	}
	
	$j=0;
	for($i = 0; $i <= 255; $i++)
	{
		$j=($j + $S[$i]+$K[$i]) & 255;
		$temp = $S[$i];
		$S[$i] = $S[$j];
		$S[$j] = $temp;
	}
	
	$i=0;
	$j=0;
	$len=strlen($inp);
	for($x = 0; $x < $len; $x++)
	{
		$i=($i+1) & 255;
		$j=($j+$S[$i]) & 255;
		$temp = $S[$i];
		$S[$i] = $S[$j];
		$S[$j] = $temp;
		$t = ($S[$i] + ($S[$j] & 255)) & 255;
		$Y = $S[$t];
		$outp=$outp.chr(ord(substr($inp,$x,1))^$Y);
	}
	return $outp;
}


// Function to encrypt a string with a key
function ETNA_Encrypt($inp, $key)
{
  // Add 4 F to specify to ETNA that this php returns an encrypted string (and also convert to hexadecimal)
	return "FFFF".bin2hex(ETNA_Rc4($inp, $key));
}


// Function to decrypt a string with the key
function ETNA_Decrypt($inp, $key)
{
    // Convert it from hexadecimal to string
	$inp = @pack('H*', $inp);
	return ETNA_Rc4($inp, $key);
}
?>

userconnection.php:

<?php
   $host = "localhost";
   $user = "mysqluser";
   $password = "mysqlpassword";
   $base = "Userbase_Encrypted";
   $tbl = "userbase";

   $connection = mysql_connect($host,$user,$password) or die(mysql_error());
   $sel = mysql_select_db($base) or die(mysql_error());
?>

ETNA_Userbase_Encrypted.php:

<?php

    include('ETNA_encryption.php');
	include('userconnection.php');

	$ekey = "ABCDEFG";
	$listArg = ETNA_GetArg($ekey);
	
	$count=array_key_exists("count",$listArg) ? $listArg["count"] : "";
	$option=array_key_exists("option",$listArg) ? $listArg["option"] : "";

	$id=array_key_exists("id",$listArg) ? $listArg["id"] : "";

	$username=array_key_exists("username",$listArg) ? $listArg["username"] : "";
	$password=array_key_exists("password",$listArg) ? $listArg["password"] : "";
		
	if($option == 'getuser'){

		$myquery = "SELECT user FROM userbase";
		$mysql_result = mysql_query($myquery) or die(mysql_error());
		$answer = "";
			
		if ($ligne = mysql_fetch_array($mysql_result))
		{
				
			do
			{
				$answer.=$ligne["user"].",";
			}

				while ($ligne = mysql_fetch_array($mysql_result));
				echo ETNA_Encrypt($answer, $ekey);
					
		}
		
		exit();
	
	}

	if($option == 'getpass'){

		$myquery = "SELECT passw FROM userbase";
		$mysql_result = mysql_query($myquery) or die(mysql_error());
		$answer = "";
			
		if ($ligne = mysql_fetch_array($mysql_result))
		{
				
			do
			{
				$answer.=$ligne["passw"].",";
			}

				while ($ligne = mysql_fetch_array($mysql_result));
				echo ETNA_Encrypt($answer, $ekey);

		}
		
		exit();
	
	}

	if($option == 'checklogin'){

		$mysql_result = mysql_query("SELECT * FROM userbase WHERE user = '$username' AND passw = '$password';");
		$answer = "";
		
		$ligne = mysql_fetch_array($mysql_result) or die(mysql_error());
			
		$answer1.=$ligne["user"];
		$answer2.=$ligne["passw"];

		if(trim($username) == trim($answer1) && trim($password) == trim($answer2)){

			$answer = 1;
					
		}else{
					
			$answer = 0;
					
		}
					
			echo $answer;

	}
		
?>

SQL file for Database:

DROP TABLE IF EXISTS `userbase`;
CREATE TABLE IF NOT EXISTS `userbase` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `user` varchar(20) NOT NULL,
  `passw` varchar(64) NOT NULL,
  `ip` varchar(15) NOT NULL, 
  `hostname` varchar(255) NOT NULL, 
  `perma_banned` boolean NOT NULL, 
  PRIMARY KEY (`id`)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1 AUTO_INCREMENT=2 ;

INSERT INTO `userbase` (`id`, `user`, `passw`, `ip`, `hostname`, `perma_banned`) VALUES
(1, 'Test', '098f6bcd4621d373cade4e832627b4f6', 'blah.blah.blah.blah', ' blah-blah-blah-blah.blah', 0);

Also, just so you know, I KNOW I have a ' ."," ', after the $ligne['user']; and $ligne['passw']; That is because I use a function to split the string by the comma delimiter. So it actually returns $ligne["user"]; and $ligne["passw"]; PLEASE, NO questioning this routine unless you ABSOLUTELY have to.

Any help would be GREATLY appreciated!

Thank You, & have a great day! :)

Last edited 2012

Osoko

(Posted 2014) [#2]

I 've tried tested this code but without succes, i can't connect with
ETNA_SetServer("http://www.xxxx")

Event with the original etna version.

What is this Sql File ? Is it an .xlm or other, is it depending of Php version.

I'm not use with Php and MySql but want to use it in my project.

Explaination would be fine !

Guy Fawkes

(Posted 2014) [#3]

Don't use this. It's 2 years old, and I'm much better at coding now. I will upload a new version later as I want to use this for my project too.

Rick Nasher

(Posted 2014) [#4]

Isn't this easier/nicer to use?

http://www.blitzforum.de/forum/viewtopic.php?p=410348#410348

(You may wamt to use google translate)

Osoko

(Posted 2014) [#5]

Like me with the time, coding is improving !

I've just manage to build the data base using the php Admin of my internet provider.

I dont understand the role of gnet_servers.php if it has a role.

Should i use form like this in gnet.php

;$mysqlDatabaseName ='db123456789';
;$mysqlUserName ='dbo123456789';
;$mysqlPassword ='yourPassword';
;$mysqlHostName ='db1234.perfora.net';

Should i Put some strings in index.html ?

My database has the form : db123456789 + Table Name

How to use this table name inside my database ?

Finaly, i've use Etna initialy to retrieve my Wan IP, it's works when connecting to blitzmax.com. Target achieve, maybe should i report this database using for example BlitzSQL ?

Regards.

Guy Fawkes

(Posted 2014) [#6]

LOL! @Rick Nasher, looks like you beat me to it! :D Found that one last night! :D

Guy Fawkes

(Posted 2014) [#7]

Dang it! I can't get this UDP 3.0 thing to work. It's German! ><

Rick Nasher

(Posted 2014) [#8]

Oops, no am missing the point right, etna is for databases? ;-)

Guy Fawkes

(Posted 2014) [#9]

@Rick, is there an english version of UDP 3.0? ><

Rick Nasher

(Posted 2014) [#10]

Don't think so. But https://translate.google.nl/?hl=en is your friend.
I got it to work, at least a year ago or so.
I believe you can use this in the Quake3 LAN party way.

Osoko

(Posted 2014) [#11]

Can't connect to my database : 1&1 Host my FTP : They say : accessing the database is possible only by direct connection, to access database remotly, you've got to have a dedicated server...

Guy Fawkes

(Posted 2014) [#12]

Oh, Osoko.... You've got to turn on a MySQL server and use 127.0.0.1 for testing, and port forward the chosen port(s) for your program / game and use your external IP & use port 3306 to connect to MySQL.

Osoko

(Posted 2014) [#13]

Thank's Guy, but i've got to create this Online.

Do i have to get an internet server to run fully this etna userbase, or is it just my provider (1&1) who doesn't permit acces to database remotly, unless you have a server by them ?

Case of server, does It be on a linux system or is it most windows ?

Guy Fawkes

(Posted 2014) [#14]

You can run it on your own desktop MySQL server. I recommend downloading the program called Xampp. It is a PHP / SQL webserver, and is a GREAT way to start using databases in MySQL! =)

Osoko

(Posted 2014) [#15]

Xampp looks terrfics for a local apps. But i need to be online.It is stipulate in the Enta's notice that etna is windows only. Does this mean that the server has to be powered only by windows ?

Guy Fawkes

(Posted 2014) [#16]

Yes, it will only work with windows.

No, Xampp will work if you know your external IP address, and open ports 80, and 3306 on your router if you have one. To port forward correctly, go to http://portforward.com/ , to get your external IP, go to: http://whatismyip.org/.

I hope this helps! :)

Good luck with your project!

~GF