race at registration

Russoll · Feb 20th 2023, 6:22am

hey im trying to have race selection at registration.
i have the race module, also put race in uni1_user just after auth.
then in login folder//////reg.php i add code so far but stuck on what to do next ...thank in advance for the help

$this->assign(array(
'raceSelect'=> $raceSelect,

line :122-$race = HTTP::_GP('race', '');

$sql = "INSERT INTO %%USERS_VALID%% SET
`race` = :race,

$db->insert($sql, array(
':race' => $race,

Danter14 · Feb 20th 2023, 10:32am

Here are the other steps to do in addition to the one you have already done

search

PHP Source Code: ShowVertifyPage.class.php

list($userID, $planetID) = PlayerUtil::createPlayer($userData['universe'], $userData['userName'], $userData['password'], $userData['email'], $userData['language']);

Replace by

PHP Source Code: ShowVertifyPage.class.php

list($userID, $planetID) = PlayerUtil::createPlayer($userData['universe'], $userData['userName'], $userData['password'], $userData['email'], $userData['race'], $userData['language']);

search

PHP Source Code: PlayerUtil.class.php

static public function createPlayer($universe, $userName, $userPassword, $userMail, $userLanguage = NULL, $galaxy = NULL, $system = NULL, $position = NULL, $name = NULL, $authlevel = 0, $userIpAddress = NULL)

replace by

PHP Source Code

static public function createPlayer($universe, $userName, $userPassword, $userMail, $race, $userLanguage = NULL, $galaxy = NULL, $system = NULL, $position = NULL, $name = NULL, $authlevel = 0, $userIpAddress = NULL)

serach

PHP Source Code: PlayerUtil.class.php

$params = array(
':username' => $userName,
':email' => $userMail,
':email2' => $userMail,
':authlevel' => $authlevel,
':universe' => $universe,
':language' => $userLanguage,
':registerAddress' => !empty($userIpAddress) ? $userIpAddress : Session::getClientIp(),
':onlinetime' => TIMESTAMP,
':registerTimestamp' => TIMESTAMP,
':password' => $userPassword,
':dpath' => DEFAULT_THEME,
':timezone' => $config->timezone,
':nameLastChanged' => 0,
':darkmatter_start' => $config->darkmatter_start,
);
$sql = 'INSERT INTO %%USERS%% SET
username = :username,
email = :email,
email_2 = :email2,
authlevel = :authlevel,
universe = :universe,
lang = :language,
ip_at_reg = :registerAddress,
onlinetime = :onlinetime,
register_time = :registerTimestamp,
password = :password,
dpath = :dpath,
timezone = :timezone,
uctime = :nameLastChanged,
darkmatter = :darkmatter_start;';

Display All

replace by

PHP Source Code: PlayerUtil.class.php

$params = array(
':username' => $userName,
':email' => $userMail,
':email2' => $userMail,
':authlevel' => $authlevel,
':universe' => $universe,
':language' => $userLanguage,
':registerAddress' => !empty($userIpAddress) ? $userIpAddress : Session::getClientIp(),
':onlinetime' => TIMESTAMP,
':registerTimestamp' => TIMESTAMP,
':password' => $userPassword,
':dpath' => DEFAULT_THEME,
':timezone' => $config->timezone,
':nameLastChanged' => 0,
':darkmatter_start' => $config->darkmatter_start,
':race' => $race,
);
$sql = 'INSERT INTO %%USERS%% SET
username = :username,
email = :email,
email_2 = :email2,
authlevel = :authlevel,
universe = :universe,
lang = :language,
ip_at_reg = :registerAddress,
onlinetime = :onlinetime,
register_time = :registerTimestamp,
password = :password,
dpath = :dpath,
timezone = :timezone,
uctime = :nameLastChanged,
darkmatter = :darkmatter_start,
race = :race;';

Display All

enjoy

Russoll · Feb 20th 2023, 5:15pm

thank you for the help, the above went without issue, but i get an error in the showreg. when i pull it up
Undefined variable: raceSelect

if i delete the line no errors but i also have no selection

in the tpl i put line

{if count($raceSelect) > 1}<div class="blocks">
<span class="lable">{$LNG.registerRace}</span>
<select name="race" id="race" class="sel_uni">{html_options options=$raceSelect}</select>
{if !empty($error.race)}
<span class="error errorRace"></span>
{/if}

thanks in advance

Danter14 · Feb 20th 2023, 6:04pm

if you want to use <select name="race" id="race" class="sel_uni">{html_options options=$raceSelect}</select>
your $raceSelect variable must return an array.

Russoll · Feb 20th 2023, 6:09pm

it is but i get that error

if i remove that php and tpl and keep what the above i have no selection for race on reg

Russoll · Feb 20th 2023, 6:09pm

$this->assign(array(
'referralData'=> $referralData,
'accountName'=> $accountName,
'externalAuth'=> $externalAuth,
'universeSelect' => $universeSelect,
'rascSelect' => $raceSelect,

Danter14 · Feb 20th 2023, 6:11pm

what does your $raceSelect return to you? it returns a array ?

Russoll · Feb 20th 2023, 6:14pm

thats as far as i got on reg php page

on function show() i havent put anything yet

PHP Source Code

<?php
/**
* 2Moons
* by Jan-Otto Kröpke 2009-2016
*
* For the full copyright and license information, please view the LICENSE
*
* @package 2Moons
* @author Jan-Otto Kröpke <slaver7@gmail.com>
* @copyright 2009 Lucky
* @copyright 2016 Jan-Otto Kröpke <slaver7@gmail.com>
* @licence MIT
* @version 1.8.0
* @link https://github.com/jkroepke/2Moons
*/
class ShowRegisterPage extends AbstractLoginPage
{
function __construct()
{
parent::__construct();
$this->setWindow('light');
}
function show()
{
global $LNG;
$universeSelect = array();
$referralData = array('id' => 0, 'name' => '');
$accountName = "";
$externalAuth = HTTP::_GP('externalAuth', array());
$referralID = HTTP::_GP('referralID', 0);
foreach(Universe::availableUniverses() as $uniId)
{
$config = Config::get($uniId);
$universeSelect[$uniId] = $config->uni_name.($config->game_disable == 0 || $config->reg_closed == 1 ? $LNG['uni_closed'] : '');
}
if(!isset($externalAuth['account'], $externalAuth['method']))
{
$externalAuth['account'] = 0;
$externalAuth['method'] = '';
}
else
{
$externalAuth['method'] = strtolower(str_replace(array('_', '\\', '/', '.', "\0"), '', $externalAuth['method']));
}
if(!empty($externalAuth['account']) && file_exists('includes/extauth/'.$externalAuth['method'].'.class.php'))
{
$path = 'includes/extauth/'.$externalAuth['method'].'.class.php';
require($path);
$methodClass = ucwords($externalAuth['method']).'Auth';
/** @var $authObj externalAuth */
$authObj = new $methodClass;
if(!$authObj->isActiveMode())
{
$this->redirectTo('index.php?code=5');
}
if(!$authObj->isValid())
{
$this->redirectTo('index.php?code=4');
}
$accountData = $authObj->getAccountData();
$accountName = $accountData['name'];
}
$config = Config::get();
if($config->ref_active == 1 && !empty($referralID))
{
$db = Database::get();
$sql = "SELECT username FROM %%USERS%% WHERE id = :referralID AND universe = :universe;";
$referralAccountName = $db->selectSingle($sql, array(
':referralID' => $referralID,
':universe' => Universe::current()
), 'username');
if(!empty($referralAccountName))
{
$referralData = array('id' => $referralID, 'name' => $referralAccountName);
}
}
$this->assign(array(
'referralData' => $referralData,
'accountName' => $accountName,
'externalAuth' => $externalAuth,
'universeSelect' => $universeSelect,
'raceSelect' => $raceSelect,
'registerRulesDesc' => sprintf($LNG['registerRulesDesc'], '<a href="index.php?page=rules">'.$LNG['menu_rules'].'</a>')
));
$this->display('page.register.default.tpl');
}
function send()
{
global $LNG;
$config = Config::get();
if($config->game_disable == 0 || $config->reg_closed == 1)
{
$this->printMessage($LNG['registerErrorUniClosed'], array(array(
'label' => $LNG['registerBack'],
'url' => 'javascript:window.history.back()',
)));
}
$userName = HTTP::_GP('username', '', UTF8_SUPPORT);
$password = HTTP::_GP('password', '', true);
$password2 = HTTP::_GP('passwordReplay', '', true);
$mailAddress = HTTP::_GP('email', '');
$mailAddress2 = HTTP::_GP('emailReplay', '');
$rulesChecked = HTTP::_GP('rules', 0);
$language = HTTP::_GP('lang', '');
$race = HTTP::_GP('race', '');
$referralID = HTTP::_GP('referralID', 0);
$externalAuth = HTTP::_GP('externalAuth', array());
if(!isset($externalAuth['account'], $externalAuth['method']))
{
$externalAuthUID = 0;
$externalAuthMethod = '';
}
else
{
$externalAuthUID = $externalAuth['account'];
$externalAuthMethod = strtolower(str_replace(array('_', '\\', '/', '.', "\0"), '', $externalAuth['method']));
}
$errors = array();
if(empty($userName)) {
$errors[] = $LNG['registerErrorUsernameEmpty'];
}
if(!PlayerUtil::isNameValid($userName)) {
$errors[] = $LNG['registerErrorUsernameChar'];
}
if(strlen($password) < 6) {
$errors[] = $LNG['registerErrorPasswordLength'];
}
if($password != $password2) {
$errors[] = $LNG['registerErrorPasswordSame'];
}
if(!PlayerUtil::isMailValid($mailAddress)) {
$errors[] = $LNG['registerErrorMailInvalid'];
}
if(empty($mailAddress)) {
$errors[] = $LNG['registerErrorMailEmpty'];
}
if($mailAddress != $mailAddress2) {
$errors[] = $LNG['registerErrorMailSame'];
}
if($rulesChecked != 1) {
$errors[] = $LNG['registerErrorRules'];
}
$db = Database::get();
$sql = "SELECT (
SELECT COUNT(*)
FROM %%USERS%%
WHERE universe = :universe
AND username = :userName
) + (
SELECT COUNT(*)
FROM %%USERS_VALID%%
WHERE universe = :universe
AND username = :userName
) as count;";
$countUsername = $db->selectSingle($sql, array(
':universe' => Universe::current(),
':userName' => $userName,
), 'count');
$sql = "SELECT (
SELECT COUNT(*)
FROM %%USERS%%
WHERE universe = :universe
AND (
email = :mailAddress
OR email_2 = :mailAddress
)
) + (
SELECT COUNT(*)
FROM %%USERS_VALID%%
WHERE universe = :universe
AND email = :mailAddress
) as count;";
$countMail = $db->selectSingle($sql, array(
':universe' => Universe::current(),
':mailAddress' => $mailAddress,
), 'count');
if($countUsername!= 0) {
$errors[] = $LNG['registerErrorUsernameExist'];
}
if($countMail != 0) {
$errors[] = $LNG['registerErrorMailExist'];
}
if ($config->capaktiv === '1')
{
require('includes/libs/reCAPTCHA/autoload.php');
$recaptcha = new \ReCaptcha\ReCaptcha($config->capprivate);
$resp = $recaptcha->verify(HTTP::_GP('g-recaptcha-response', ''), Session::getClientIp());
if (!$resp->isSuccess())
{
$errors[] = $LNG['registerErrorCaptcha'];
}
}
if (!empty($errors)) {
$this->printMessage(implode("<br>\r\n", $errors), array(array(
'label' => $LNG['registerBack'],
'url' => 'javascript:window.history.back()',
)));
}
$path = 'includes/extauth/'.$externalAuthMethod.'.class.php';
if(!empty($externalAuth['account']) && file_exists($path))
{
require($path);
$methodClass = ucwords($externalAuthMethod).'Auth';
/** @var $authObj externalAuth */
$authObj = new $methodClass;
$externalAuthUID = 0;
if($authObj->isActiveMode() && $authObj->isValid()) {
$externalAuthUID = $authObj->getAccount();
}
}
if($config->ref_active == 1 && !empty($referralID))
{
$sql = "SELECT COUNT(*) as state FROM %%USERS%% WHERE id = :referralID AND universe = :universe;";
$Count = $db->selectSingle($sql, array(
':referralID' => $referralID,
':universe' => Universe::current()
), 'state');
if($Count == 0)
{
$referralID = 0;
}
}
else
{
$referralID = 0;
}
$validationKey = md5(uniqid('2m'));
$sql = "INSERT INTO %%USERS_VALID%% SET
`userName` = :userName,
`validationKey` = :validationKey,
`password` = :password,
`email` = :mailAddress,
`date` = :timestamp,
`ip` = :remoteAddr,
`language` = :language,
`race` = :race,
`universe` = :universe,
`referralID` = :referralID,
`externalAuthUID` = :externalAuthUID,
`externalAuthMethod` = :externalAuthMethod;";
$db->insert($sql, array(
':userName' => $userName,
':validationKey' => $validationKey,
':password' => PlayerUtil::cryptPassword($password),
':mailAddress' => $mailAddress,
':timestamp' => TIMESTAMP,
':remoteAddr' => Session::getClientIp(),
':language' => $language,
':race' => $race,
':universe' => Universe::current(),
':referralID' => $referralID,
':externalAuthUID' => $externalAuthUID,
':externalAuthMethod' => $externalAuthMethod
));
$validationID = $db->lastInsertId();
$verifyURL = 'index.php?page=vertify&i='.$validationID.'&k='.$validationKey;
if($config->user_valid == 0 || !empty($externalAuthUID))
{
$this->redirectTo($verifyURL);
}
else
{
require 'includes/classes/Mail.class.php';
$MailRAW = $LNG->getTemplate('email_vaild_reg');
$MailContent = str_replace(array(
'{USERNAME}',
'{PASSWORD}',
'{GAMENAME}',
'{VERTIFYURL}',
'{GAMEMAIL}',
), array(
$userName,
$password,
$config->game_name.' - '.$config->uni_name,
HTTP_PATH.$verifyURL,
$config->smtp_sendmail,
), $MailRAW);
$subject = sprintf($LNG['registerMailVertifyTitle'], $config->game_name);
Mail::send($mailAddress, $userName, $subject, $MailContent);
$this->printMessage($LNG['registerSendComplete']);
}
}
}

Display All

Danter14 · Feb 20th 2023, 6:22pm

already it can't work simply because your variable $raceSelect is not defined.
In addition it must return the list of your different races in the form of an array

Russoll · Feb 20th 2023, 6:23pm

i looked in the old version that has this and it has this

while ($raceWhile = $GLOBALS['DATABASE']->FetchArray($raceAllConfig))
{
$raceSelect[$raceWhile['race_id']] = $raceWhile['race_name'];

Danter14 · Feb 20th 2023, 6:25pm

This functionality allows you to precisely make the table.
But it may not appreciate you must convert it to make it work under this v2.0

Russoll · Feb 20th 2023, 6:27pm

ok ty

Russoll · Feb 20th 2023, 7:11pm

i wondering with the solution you gave above how would you call the race selection on the reg pag

Russoll · Feb 20th 2023, 7:30pm

what i am trying to do is after the race is selected, a theme associated to the race will change in the game

that part im ok with

Danter14 · Feb 20th 2023, 7:47pm

you want to put a theme by race?

here is the correct code of course I don't know your SQL

PHP Source Code

$raceSelect = [];
$resultRace = $db->select("Your sql queries");
foreach($resultRace as $raceWhile) {
$raceSelect[$raceWhile['race_id']] = $raceWhile['race_name'];
}

Russoll · Feb 20th 2023, 8:09pm

ty for your help, i really appreciated it, but i get error after error. i guess it was a good idea only i 'll give it up for now as im not able to properly code it, i appaologize for wasting your time... but thank you

Danter14 · Feb 20th 2023, 8:14pm

I will see if I have time to do it I will create it for the choice of race

Russoll · Feb 20th 2023, 9:51pm

k ty

yamilrh · Feb 21st 2023, 3:05am

LO que intentas hacer es algo como el xnova revolution, que según tu raza cambia el diseño no?

Russoll · Feb 21st 2023, 3:09am

yes but first im wanted to have the race selected from registration

PHP Source Code: ShowVertifyPage.class.php

PHP Source Code: ShowVertifyPage.class.php

PHP Source Code: PlayerUtil.class.php

PHP Source Code

PHP Source Code: PlayerUtil.class.php

PHP Source Code: PlayerUtil.class.php

PHP Source Code

PHP Source Code

Share