[MOD] Tech tree editor of DB (v1.8, v2.0)

noonn · Aug 22nd 2023, 9:35am

Hi friends...

There may be errors in translation.

This MOD is a function to modify, delete, or add tech tree conditions.

It has been perfectly implemented so that anyone can use it, and i made it very easy to use.

A screenshot is attached.
I hope this helps a lot.

Reference!
1. You can delete the row you want or modify the condition.
2. When a new tech tree is saved, it will be sorted and displayed.
3. Displayed by group.
4. Automatically block on further saves with the same row incorrectly.

1. Create a php file.
includes/game/ShowRequriementsPage.class.php

PHP Source Code

<?php
#by noonn
/*
Tech Tree Editor
*/
class ShowRequriementsPage extends AbstractGamePage
{
public static $requireModule = 0;
function __construct()
{
parent::__construct();
}
function show()
{
global $USER, $LNG;
$db = Database::get();
if($USER['authlevel'] != 3){
$this->printMessage("Page not found<br>", array(array(
'label' => "MOVE",
'url' => 'game.php'
)));
}
$sql = "SELECT requireLevel, requireID, elementID FROM %%VARS_REQUIRE%% WHERE elementID IN
(SELECT elementID FROM %%VARS_REQUIRE%% GROUP BY elementID HAVING COUNT(*) >= 1) ORDER BY elementID, requireID ASC;" ;
$Startowne = Database::get()->select($sql, array(
));
$fleet_i = array();
foreach ($Startowne as $Data) {
if(!isset($fleet_i[$Data['elementID']]))
$fleet_i[$Data['elementID']] = array();
$Data['elementID'] = $Data['elementID'];
$Data['requireID'] = $Data['requireID'];
$Data['requireLevel'] = $Data['requireLevel'];
$fleet_i[$Data['elementID']][$Data['requireID']] = $Data;
}
$this->assign(array(
'fleet_i' => $fleet_i,
'requireLv' => $LNG['tech'],
));
$this->display('page.requriements.tpl');
}
function del()
{
global $USER;
if($USER['authlevel'] != 3){
$this->printMessage("Page not found<br>", array(array(
'label' => "MOVE",
'url' => 'game.php'
)));
}
$db = Database::get();
$elemID = HTTP::_GP('elemID', '');
$requireID = HTTP::_GP('requireID', '');
$sql = 'DELETE FROM %%VARS_REQUIRE%% WHERE elementID = :elemID AND requireID = :requireID ;';
$db->delete($sql, array(
':elemID' => $elemID,
':requireID' => $requireID,
));
$this->redirectTo('game.php?page=requriements');
}
function edits()
{
global $USER;
if($USER['authlevel'] != 3){
$this->printMessage("Page not found<br>", array(array(
'label' => "MOVE",
'url' => 'game.php'
)));
}
$db = Database::get();
$elemID = HTTP::_GP('elemID', '');
$requireID = HTTP::_GP('requireID', '');
$newlevel = HTTP::_GP('newlevel', '');
// Check no same elemID and requireID
$sql = "SELECT COUNT(*) as count FROM %%VARS_REQUIRE%% WHERE elementID = :elemID AND requireID = :requireID ;";
$checkID = $db->selectSingle($sql, array(
':elemID' => $elemID,
':requireID' => $requireID,
), 'count');
if(empty($checkID) || $checkID > 1){
$this->printMessage("<span style=font-size:1.3em;color:#EE00E6><br>Error: Item does not exist or an identical row exists. !!<br><br></span>", array(array(
'label' => "MOVE",
'url' => '?page=requriements'
)));
}
$sql = "UPDATE %%VARS_REQUIRE%% SET requireLevel = :requireLevel WHERE elementID = :elemID AND requireID = :requireID ;";
$db->update($sql, array(
':requireLevel' => $newlevel,
':elemID' => $elemID,
':requireID' => $requireID,
));
$this->redirectTo('game.php?page=requriements');
}
function add()
{
global $USER;
if($USER['authlevel'] != 3){
$this->printMessage("Page not found<br>", array(array(
'label' => "MOVE",
'url' => 'game.php'
)));
}
$db = Database::get();
$elemID = HTTP::_GP('elemID', '');
$requireID = HTTP::_GP('requireID', '');
$newlevel = HTTP::_GP('newlevel', '');
// Check same elemID and requireID
$sql = "SELECT COUNT(*) as count FROM %%VARS_REQUIRE%% WHERE elementID = :elemID AND requireID = :requireID ;";
$checkID = $db->selectSingle($sql, array(
':elemID' => $elemID,
':requireID' => $requireID,
), 'count');
if($checkID == 1){
$this->printMessage("<span style=font-size:1.3em;color:#EE00E6><br>ERROR: Same item exists. !!<br><br></span>", array(array(
'label' => "MOVE",
'url' => '?page=requriements'
)));
}
// INSERT data
$sql = 'INSERT INTO %%VARS_REQUIRE%% SET elementID = :elemID, requireID = :requireID, requireLevel = :newlevel ;';
$db->insert($sql, array(
':elemID' => $elemID,
':requireID' => $requireID,
':newlevel' => $newlevel,
));
$this->redirectTo('game.php?page=requriements');
}
function ClearCache()
{
global $USER, $LNG;
if($USER['authlevel'] != 3){
$this->printMessage("Page not found<br>", array(array(
'label' => "MOVE",
'url' => 'game.php'
)));
}
ClearCache();
$this->redirectTo('game.php?page=requriements');
}
}
?>

Display All

2. Create a tpl file.
templates/game/page.requriements.tpl

HTML Source Code

{block name="title" prepend}Tech Tree Settings{/block}
{block name="content"}
<style>
td{
font-size:1.2em;
}
.bgco{
background-color:#003851;
}
</style>
<div class="content_page">
<div class="title" style="font-size:1.2em">
Tech Tree Settings
</div>
<table border='1' width="100%">
<tr>
<th colspan="2"><font color="red" style="font-size:1.3em;color:#9BC800;">
<pre>
Reference!
1. You can delete the row you want or modify the condition.
2. When a new tech tree is saved, it will be sorted and displayed.
3. Displayed by group.
4. Automatically block on further saves with the same row incorrectly.
</pre>
</font>
</th>
</tr>
<tr>
<td><form action="?page=requriements&mode=ClearCache" method="post">
After all operations are complete, please clear the cache.
</td>
<td><input type="submit" value="Clear Cache" style="display:block;float:right;background-color: #00568B;color: white;width:100px;padding: 10px 6px;"></td>
</form>
</tr>
</table>
<table border='1' width="100%">
<tr>
<td class="bgco" height="30px">ITEM</td>
<td class="bgco">Tech requir</td>
<td class="bgco">Level</td>
<td class="bgco">save</td>
</tr>
<form action="?page=requriements&mode=add" method="post">
<tr>
<td>
{html_options name=elemID options=$requireLv style='font-size:1.0em;color:#58FA58'}
</td>
<td>
{html_options name=requireID options=$requireLv style='font-size:1.0em;color:#EE00E6'}
</td>
<td>
<input style="width:60px; color:#FC6;font-size:1.3em" name="newlevel" type="number" min="1" onchange="KeyUpBuy('');" onkeyup="KeyUpBuy('');" value="1">
</td>
<td>
<input style="color:#fff;font-size:1.1em;display:block; margin:0 auto; padding:3px 15px;" type="submit" value="ADD SAVE">
</td>
</tr>
</form>
</table>
<table border='1' width="100%">
<tr>
<td colspan="5" height="30px">Tech tree in Database</td>
</tr>
<tr>
<td class="bgco" height="30px">ITEM</td>
<td class="bgco">Tech requir</td>
<td class="bgco">Level</td>
<td class="bgco">Edit TechTree</td>
<td class="bgco">DELETE</td>
</tr>
{foreach $fleet_i as $elemID => $ids}
<tr>
<td rowspan="{count($ids)}">({$elemID})
<a href="#" style="color:#58FA58;padding-left: 3px;" onclick="return Dialog.info({$elemID})">{$LNG.tech.{$elemID}}</a>
</td>
{foreach $ids as $ID => $id}
<td>({$id.requireID})
<a href="#" style="color:#EE00E6;padding-left: 3px;" onclick="return Dialog.info({$id.requireID})">{$LNG.tech.{$id.requireID}}</a></td>
<td><span style="color:#FC6;">{$id.requireLevel}</span></td>
<td>
<form action="?page=requriements&mode=edits&elemID={$elemID}&requireID={$id.requireID}" method="post">
<input style="font-size:1.3em;width:50px;height:20px" name="newlevel" type="number" min="1" onchange="KeyUpBuy('');" onkeyup="KeyUpBuy('');" value="{$id.requireLevel}">
<input onclick="return confirm('Modify the rows of item {$elemID}, {$id.requireID} ?');" style="font-size:1.0em;background-color: #003A68;color: white;width:50px;padding: 2px 2px;" type="submit" value="Modify">
</form>
</td>
<td>
<form action="?page=requriements&mode=del&elemID={$elemID}&requireID={$id.requireID}" method="post">
<input onclick="return confirm('Delete the rows of item {$elemID}, {$id.requireID} ?');" type="submit" value="DELETE" style="color:red">
</form>
</td>
</tr>{if !$id@last}<tr>{/if}
{/foreach}
{/foreach}
</table>
<br><br><br><br><br><br><br>
</div>
{/block}

Display All

3. Add link.

HTML Source Code

{if $authlevel == 3} <a href="game.php?page=requriements">Tech tree Editor</a> {/if}

End.....
Thanks.

Danter14 · Aug 22nd 2023, 11:51am

one thing that I don't understand why you don't make these mods directly in the admin panel knowing that it affects the configuration of the game.

noonn · Aug 22nd 2023, 2:20pm

Danter14 wrote:

one thing that I don't understand why you don't make these mods directly in the admin panel knowing that it affects the configuration of the game.

When the time comes, I'll make it run in the admin panel.
Thanks for the advice.

Danter14 · Aug 22nd 2023, 2:48pm

noonn wrote:

Danter14 wrote:

one thing that I don't understand why you don't make these mods directly in the admin panel knowing that it affects the configuration of the game.

When the time comes, I'll make it run in the admin panel.Thanks for the advice.

I find it clearer, knowing that in the game part only what is possible by the player must be in it, the rest for the management part of the universe must be in an admin panel. It's just my point of view for everyone to do what they want

Zeus · Aug 22nd 2023, 3:11pm

thanks can you do it in fleet and buildings? also in addition to this building research fleet defense

Can you make a mod for these base places that we can create ourselves so we can add new buildings so we can add new fleet defense research?

noonn · Aug 22nd 2023, 3:41pm

Zeus wrote:

thanks can you do it in fleet and buildings? also in addition to this building research fleet defense

Can you make a mod for these base places that we can create ourselves so we can add new buildings so we can add new fleet defense research?

Only all buildings, research, fleets, and defense facilities officer that are currently implemented can be modified, del, or added.

Zeus · Aug 22nd 2023, 3:45pm

noonn wrote:

Zeus wrote:

thanks can you do it in fleet and buildings? also in addition to this building research fleet defense

Can you make a mod for these base places that we can create ourselves so we can add new buildings so we can add new fleet defense research?

Only all buildings, research, fleets, and defense facilities officer that are currently implemented can be modified, del, or added.

I added correctly but
i am getting an error the error i get says Page not found ? bro

Danter14 · Aug 22nd 2023, 6:01pm

if you are not an administrator you do not have access to the page

to turn in the condition the

$USER["username"] == "admin" because it will block you if you have another nickname

if($USER['authlevel'] != 3

$USER['username'] != 'admin'){}

Zeus · Aug 22nd 2023, 10:25pm

Danter14 wrote:

if you are not an administrator you do not have access to the page

to turn in the condition the $USER["username"] == "admin" because it will block you if you have another nickname

if($USER['authlevel'] != 3 $USER['username'] != 'admin'){}

sorry what exactly should i do

My account is at level 3, so I have logins with full authorization, which code should I change here?

yamilrh · Aug 22nd 2023, 10:40pm

Zeus wrote:

Danter14 wrote:

if you are not an administrator you do not have access to the page

to turn in the condition the $USER["username"] == "admin" because it will block you if you have another nickname

if($USER['authlevel'] != 3 $USER['username'] != 'admin'){}

sorry what exactly should i do
My account is at level 3, so I have logins with full authorization, which code should I change here?

Remplaza

PHP Source Code

if($USER['authlevel'] != 3 || $USER['username'] != 'admin'){

por

PHP Source Code

if($USER['authlevel'] != 3){

yamilrh · Aug 22nd 2023, 10:46pm

Aunque comparto con @Danter14 de mantenerlo de parte del panel, creo que seria mucho mas seguro poner esta regla

PHP Source Code

if($USER['id'] != ROOT_USER)

Porque con esta te garantiza que tu solo puedas acceder hacer dicho cambios, ya que son un poco complicado que alguien que no tenga conocimiento manipule estas tablas

Zeus · Aug 22nd 2023, 10:49pm

yamilrh wrote:

Zeus wrote:

Danter14 wrote:

if you are not an administrator you do not have access to the page

to turn in the condition the $USER["username"] == "admin" because it will block you if you have another nickname

if($USER['authlevel'] != 3 $USER['username'] != 'admin'){}

sorry what exactly should i doMy account is at level 3, so I have logins with full authorization, which code should I change here?

Remplaza

PHP Source Code

if($USER['authlevel'] != 3 || $USER['username'] != 'admin'){

por

PHP Source Code

if($USER['authlevel'] != 3){

I changed it as you said but I got a page fault

NOTICE

Message: Undefined offset: 48

yamilrh · Aug 22nd 2023, 10:55pm

Borraste cache?
Verifica que no te falte algún { o )
o tenga alguna coma de mas

Zeus · Aug 22nd 2023, 11:00pm

Source Code

function show()
{
global $USER, $LNG;
$db = Database::get();
if($USER['authlevel'] != 3){
$this->printMessage("Page not found<br>", array(array(
'label' => "MOVE",
'url' => 'game.php'
)));
}

I'm doing it in show, am I doing it wrong? same error because

yamilrh · Aug 22nd 2023, 11:04pm

Zeus wrote:

Source Code

function show()

{

global $USER, $LNG;

$db = Database::get();

if($USER['authlevel'] != 3){

$this->printMessage("Page not found<br>", array(array(

'label' => "MOVE",

'url' => 'game.php'

)));

}

I'm doing it in show, am I doing it wrong? same error because

Probare en una instalación limpia

yamilrh · Aug 22nd 2023, 11:20pm

Zeus wrote:

Source Code

function show()

{

global $USER, $LNG;

$db = Database::get();

if($USER['authlevel'] != 3){

$this->printMessage("Page not found<br>", array(array(

'label' => "MOVE",

'url' => 'game.php'

)));

}

I'm doing it in show, am I doing it wrong? same error because

Algo en tu código, acabo de probar y me funciona bien

Remplaza por el tuyo

Zeus · Aug 22nd 2023, 11:30pm

Source Code

NOTICE
Message: Undefined offset: 48
File: /cache/templates/tr_nsc^2b9768ad6802b4472c11f68028e0219040301a33.page.requriements.tpl.php
Line: 1304
URL: https://xxxxxxx/game.php?page=requriements
PHP-Version: 7.4.33
PHP-API: cgi-fcgi
Version: 2.8.1
Debug Backtrace:
#0 /cache/templates/tr_nsc^2b9768ad6802b4472c11f68028e0219040301a33.page.requriements.tpl.php(1304): errorHandler()
#1 /includes/libs/Smarty/sysplugins/smarty_template_resource_base.php(123): content_64e5270633da35_48897052()
#2 /includes/libs/Smarty/sysplugins/smarty_template_cached.php(137): Smarty_Template_Resource_Base->getRenderedTemplateCode()
#3 /includes/libs/Smarty/sysplugins/smarty_internal_template.php(211): Smarty_Template_Cached->render()
#4 /includes/libs/Smarty/sysplugins/smarty_internal_templatebase.php(232): Smarty_Internal_Template->render()
#5 /includes/libs/Smarty/sysplugins/smarty_internal_templatebase.php(134): Smarty_Internal_TemplateBase->_execute()
#6 /includes/classes/class.template.php(148): Smarty_Internal_TemplateBase->display()
#7 /includes/pages/game/AbstractGamePage.class.php(531): template->display()
#8 /includes/pages/game/ShowRequriementsPage.class.php(50): AbstractGamePage->display()
#9 /game.php(59): ShowRequriementsPage->show()
#10 {main}

Display All

I don't understand, it's giving me an error like this, it's weird :huh:

yamilrh · Aug 22nd 2023, 11:32pm

Muestra

File: /cache/templates/tr_nsc^2b9768ad6802b4472c11f68028e0219040301a33.page.requriements.tpl.php
Line: 1304

yamilrh · Aug 22nd 2023, 11:33pm

creo que el problema esta en el idioma Turco, busca en tech.php si tienes definido el ID 48

Zeus · Aug 22nd 2023, 11:36pm

ok the problem is caused by the language file, it's fixed now @yamilrh Thank you

[MOD] Tech tree editor of DB (v1.8, v2.0)

[MOD] Tech tree editor of DB (v1.8, v2.0)

PHP Source Code

HTML Source Code

HTML Source Code

Danter14 wrote:

noonn wrote:

Danter14 wrote:

Zeus wrote:

noonn wrote:

Zeus wrote:

Danter14 wrote:

Zeus wrote:

Danter14 wrote:

PHP Source Code

PHP Source Code

PHP Source Code

yamilrh wrote:

Zeus wrote:

Danter14 wrote:

PHP Source Code

PHP Source Code

Source Code

Zeus wrote:

Source Code

Zeus wrote:

Source Code

Source Code

Share

Users Online 2