Tantra Freelancer
- Joined
- Apr 9, 2014
- Messages
- 541
- Reaction score
- 23
and how can i help you with that error?
can you share some and what have you done so far?
<?php
// Que no se nos olvide incluir nuestro fichero con la conexion a la base de datos.
require_once('connect.php');
$nick=$_REQUEST['nickname'];
$sql="SELECT UserID FROM Account where UserID ='$nick'";
$res=mssql_query($sql);
$total=mssql_num_rows($res);
if($total>0)
{
// El usuario existe en la Base de Datos
echo "Error!";
}
else
{
// Ese nick esta libre
echo "Success!";
}
?>
This is comprobar_nick.php
PHP:<?php // Que no se nos olvide incluir nuestro fichero con la conexion a la base de datos. require_once('connect.php'); $nick=$_REQUEST['nickname']; $sql="SELECT UserID FROM Account where UserID ='$nick'"; $res=mssql_query($sql); $total=mssql_num_rows($res); if($total>0) { // El usuario existe en la Base de Datos echo "Error!"; } else { // Ese nick esta libre echo "Success!"; } ?>
It says Connection Success (@connect.php) but for some reason "Account" is an Invalid Object name. Any workaround on this?
@TantraNewbie
Website data that Sir @Terrified gave is good just call and point your Database to UserLogin similar to Sir @KyleMarvin config.php. However upon using it I came to this error
Fatal error: Allowed memory size of 134217728 bytes exhausted (tried to allocate 24576 bytes) in C:\xampp\htdocs\includes\registro\registro.php on line 37
I know that php.ini's memory_limit is set to 128M but I tried adjusting with the best figures I can think of (e.g. 8M, 16, 32M, 64, 256, etc) still this error persist when I tried to register a new account. If somebody can share a working register.php script or perhaps a solution to this error. I would gladly appreciate it.
glad you guys are on the right track. i can help on the php side. but, really, it has been discussed over and over. try to search first. plenty of posts will resolve your problem.
stuck up in the login is in the HTLauncher.exe, Start Launcher.exe, HTSMessage.txl and ODBC connection. try to check on that.
Just in case I am still keeping my patience up. Also I won't mind posting any updates/progress I may have. For the love of the game I know this will be hard but I think we are on track. Anyways, two minds are better than one and that's true and we can work on this together if you want.
Try to use the website data of Zone Gamers it is posted on Developer Tantra FB the link is still their search the fb page I use google translator i cant understand spanish. just edit the php form I have a hard time enabling the recaptcha it will not show up the the registry page.
Yeah I downloaded those and I find it hard so I decided to just rewrite the registry.php script of Spartan Web its not yet finish though. Will keep you posted if it will work. Btw @TantraNewbie, can I ask if where did you got/downloaded the "s_game" folder?
Lately I was able to explore mandara coz may other char is stuck in shambla with this message in the log
40425 155456 7400a8c0 -system New Connection user:1
140425 155458 7400a8c0 clo err Dismatch Client-Server Version!! account: char:
140425 155635 7400a8c0 -system New Connection user:1
140425 155635 7400a8c0 clo err Dismatch Client-Server Version!! account: char:
140425 155642 7400a8c0 -system New Connection user:1
140425 155642 7400a8c0 clo err Dismatch Client-Server Version!! account: char:
140425 155710 00000000 -system err DB connection close.
140425 155710 00000000 -system err reconnect DB fail.
I wondered if those account got created using the registration script/page? I remembered you have still issues in your registration script/page correct? So I think in theory base on your progress you can still create an account but once your server got offline and becomes online again it won't fetch your previous accounts.
This is just my theory anyways and there must be a correct explanation for this technically. Maybe I can provide more answers if I have the knowledge and I am in the actual situation.
Hence, again in theory you need to fix the registration first (I am doing this right now but still nothing works). I hope successful Tantra server owners can provide us a solution for this matter in the long run.
I manage to create an account using the zone gamers template I edit the registry although there were errors but I created a tad file that is why I able to enter the game. It still save data just like ordinary game look at may level I started it yesteday.
Have you explored your DB? u can enter the game even if you have not created an account..If their is existing account save in thier is purely logic that base on theory..
I see so lets roll-out the registry script now so I think we need to have another client because the one that is provided by @Terrified is not compatible with the server files or the other way around?
Nope its not really the client but whats inside the client...They are compatible..The problem is the one that we put inside the client and server files must be compatible....That is why now I try to load back yesterdays data in server and client.. I can now enter the mandara map gain but not shambla. thats what Im goin to find out ..
@Terrified,
I dont know what else did I missed but just in case here are the screen shot that you might interested in giving insights to shred me some light.
Website Registration
Account successfully forwarded to my MS SQL Server
Website Login (using the newly registered account)
Edited/hexed HTLauncher.exe (version 6.9.0.6)
Client's Serverlist.txt
Server's Serverlist.txt. Also my Admin.txt and LocalIP.txt both have my Local IP address (192.168.254.100)
HTMessage.xml converted to HTMessage.txl (using the link provided in the first post)
Tell me what did I missed and what's lacking please..because at the moment I have this error..
REMOVED
..the worst thing is that I can login any account without even registering it first
Wow your almost there how did you manage to display your recaptcha?? Im will not shoe up I dont know whats wrong with it..
Can you give a screenshot on how the registration page looks like in your part?