Re: XNova Redesigned beta12
Quote:
Originally Posted by
wardoguru
Ready! Apache + php + mysql (standalone) works fine! :D
I have another cuestion. I create the database. All work fine, but when i try to register the first user (admin), the application throw me a sql error; "Field 'ip_at_reg' doesn't have a default value" and go on with all the columns that dont appear in the insert statement...
odd, I will try and get this sorted for beta13, did you use the install the game comes with?
Re: XNova Redesigned beta12
Quote:
Originally Posted by
MadnessRed
odd, I will try and get this sorted for beta13, did you use the install the game comes with?
maybe.. its my error, i will try to fix it temporarily. If a get more errors, i will download a previous version to try.
Thanks for the quickly answers (oh god.. i have to go to english classes, this is difficult :ott1:)
Re: XNova Redesigned beta12
Quote:
Originally Posted by
wardoguru
maybe.. its my error, i will try to fix it temporarily. If a get more errors, i will download a previous version to try.
Thanks for the quickly answers (oh god.. i have to go to english classes, this is difficult :ott1:)
you did install it using the install script yh? Not with your own database or something?
Re: XNova Redesigned beta12
Quote:
Originally Posted by
MadnessRed
you did install it using the install script yh? Not with your own database or something?
i create the database and then run: install.php
There are something else to do?
look http://i49.tinypic.com/27wsrut.jpg
i have to put all the columns who as not nullable values and not default values to nullable. But i dont have a planet (¿?).
Re: XNova Redesigned beta12
Quote:
Originally Posted by
wardoguru
i create the database and then run: install.php
There are something else to do?
look
http://i49.tinypic.com/27wsrut.jpg
i have to put all the columns who as not nullable values and not default values to nullable. But i dont have a planet (¿?).
Yuo are not meant to setup the db yourself, running the install, the game will install the database for you.
Re: XNova Redesigned beta12
Quote:
Originally Posted by
MadnessRed
Yuo are not meant to setup the db yourself, running the install, the game will install the database for you.
Nope... i try that (not creating the database before, using the install script), but give me the sames error when i try to registrer a user.
"Field 'forum_id' doesn't have a default value"
hey, do u hv a gtalk account? (its more easy :P )
I have a cuestion:
Code:
$QryInsertUser .= "`referal` = '". mysql_escape_string(strip_tags( $RefeName )) ."', ";
$QryInsertUser .= "`validate` = '". $validation_code ."', ";
$QryInsertUser .= "`email` = '". mysql_escape_string( $UserEmail ) ."', ";
$QryInsertUser .= "`email_2` = '". mysql_escape_string( $UserEmail ) ."', ";
$QryInsertUser .= "`sex` = '". mysql_escape_string( $_POST['sex'] ) ."', ";
$QryInsertUser .= "`lang` = '". mysql_escape_string( $_POST['lang'] ) ."', ";
$QryInsertUser .= "`avatar` = '". mysql_escape_string( $avatar ) ."', ";
$QryInsertUser .= "`sec_qu` = '". mysql_escape_string( $sec_qu ) ."', ";
$QryInsertUser .= "`sec_ans` = '". mysql_escape_string( $sec_ans ) ."', ";
$QryInsertUser .= "`id_planet` = '0', ";
$QryInsertUser .= "`register_time` = '". time() ."', ";
$QryInsertUser .= "`password`='". $shanewpass ."';";
doquery( $QryInsertUser, 'users');
That code only send a few parameters to the insert statement... What happen with those who you dont send and are not nullable and dont have a defalut value?
Re: XNova Redesigned beta12
Quote:
Originally Posted by
wardoguru
Nope... i try that (not creating the database before, using the install script), but give me the sames error when i try to registrer a user.
"Field 'forum_id' doesn't have a default value"
hey, do u hv a gtalk account? (its more easy :P )
I have a cuestion:
Code:
$QryInsertUser .= "`referal` = '". mysql_escape_string(strip_tags( $RefeName )) ."', ";
$QryInsertUser .= "`validate` = '". $validation_code ."', ";
$QryInsertUser .= "`email` = '". mysql_escape_string( $UserEmail ) ."', ";
$QryInsertUser .= "`email_2` = '". mysql_escape_string( $UserEmail ) ."', ";
$QryInsertUser .= "`sex` = '". mysql_escape_string( $_POST['sex'] ) ."', ";
$QryInsertUser .= "`lang` = '". mysql_escape_string( $_POST['lang'] ) ."', ";
$QryInsertUser .= "`avatar` = '". mysql_escape_string( $avatar ) ."', ";
$QryInsertUser .= "`sec_qu` = '". mysql_escape_string( $sec_qu ) ."', ";
$QryInsertUser .= "`sec_ans` = '". mysql_escape_string( $sec_ans ) ."', ";
$QryInsertUser .= "`id_planet` = '0', ";
$QryInsertUser .= "`register_time` = '". time() ."', ";
$QryInsertUser .= "`password`='". $shanewpass ."';";
doquery( $QryInsertUser, 'users');
That code only send a few parameters to the insert statement... What happen with those who you dont send and are not nullable and dont have a defalut value?
usually mysql wont mind, seems like you have it on a strict mode somehow, as they errors only happen on windows servers as far as I can tell.
Re: XNova Redesigned beta12
Quote:
Originally Posted by
MadnessRed
usually mysql wont mind, seems like you have it on a strict mode somehow, as they errors only happen on windows servers as far as I can tell.
i will try to upload it in some linux based server, to see how its work... Stay tunned :D
Thanks again for all the help.
Btw. I do this to upload a xnova server to this spanish gamers community www.antipro.com.uy (gamers, tech, gadgets). Feel free to enter and look.
---------- Post added at 08:28 PM ---------- Previous post was at 07:16 PM ----------
Sry... me again.
this http://forum.ragezone.com/f421/make-...u-want-619465/ work well with this new redesign xnova?
Or i have to transalte to my lenguaje manually?
Re: XNova Redesigned beta12
Re: XNova Redesigned beta12
its ready... works fine in webhost. We are translate it totally to spanish. Thanks for the help. :D
Re: XNova Redesigned beta12
Hi... Do you already have, the date set for the new beta 13?
Greetings :)
Re: XNova Redesigned beta12
Quote:
Originally Posted by
dred87
Hi... Do you already have, the date set for the new beta 13?
Greetings :)
I am targeting March 31st for the release of version 1.
Beta 13 should be Feb or early March.
Re: XNova Redesigned beta12
ah greetings all
well I'm new to this and my question is ...
as do I put ah skin ogame placed in madnes ... nose if I can explain
and another thing when I upload files as miarroba ogame ah host svn files give me error and not the rise
any advice for that?
I say goodbye and apologize for any inconvenience
---------- Post added at 08:01 PM ---------- Previous post was at 07:48 PM ----------
ah greetings all
well I'm new to this and my question is ...
as do I put ah skin ogame placed in madnes ... nose if I can explain
and another thing when I upload files as miarroba ogame ah host svn files give me error and not the rise
any advice for that?
I say goodbye and apologize for any inconvenience
Re: XNova Redesigned beta12
Quote:
Originally Posted by
howltaker
ah greetings all
well I'm new to this and my question is ...
as do I put ah skin ogame placed in madnes ... nose if I can explain
and another thing when I upload files as miarroba ogame ah host svn files give me error and not the rise
any advice for that?
I say goodbye and apologize for any inconvenience
---------- Post added at 08:01 PM ---------- Previous post was at 07:48 PM ----------
ah greetings all
well I'm new to this and my question is ...
as do I put ah skin ogame placed in madnes ... nose if I can explain
and another thing when I upload files as miarroba ogame ah host svn files give me error and not the rise
any advice for that?
I say goodbye and apologize for any inconvenience
put the skin in a folder called skins in the root directory,
so it will look like
> css
> game
> install
> login
> skins
or something like that
Re: XNova Redesigned beta12
Hi,
I've also been working on the beta12 because it is hosted live to play. (if you want to see my fixes pm me)
My problem:
Every 20minutes past an hour (like 11.20,12.20,...) my server (rented at one.com) hangs and gives the following mysql error:
max_user_connections
I emailed to one.com to ask if there was an problem with the server and they say that i have to put mysql_close() in my script.
In my oppinion this is not the right solution because the error would appear at random times, not only at 20past every hour.
Anyway, my question now is, is there a periodically stuff that can eat all the connections in the script???