• There is NO official Otland's Discord server and NO official Otland's server list. The Otland's Staff does not manage any Discord server or server list. Moderators or administrator of any Discord server or server lists have NO connection to the Otland's Staff. Do not get scammed!

GESIOR 2012 - Version 1.0.1 for 0.2.x, 0.3.6 and all 0.4

Hey, how do i make sure that my website keeps the frags on the website even though the players use the frag remover? Im not sure what scripts to post..
Thanks!
 
I can't use salt as an encryption type in my config. I'm using sha1.
Code:
STEP 1
Check server configuration
Error occured!
Error ID: 
More info: ERROR: #C-1 : Class::ConfigLUA - Line 27 of LUA config file is not valid [key: encryptionType]

File: C:\UniServer\www\classes/configlua.php  Line: 59
File: C:\UniServer\www\classes/configlua.php  Line: 20
File: C:\UniServer\www\classes/configlua.php  Line: 12
File: C:\UniServer\www/install.php  Line: 249
 
I keep getting the error: Key encryptionType doesn't exist.
Using 0.4+ and at config.lua just exist passwordType, there is no encryptionType... Also I added this line to config.lua as encryptionType = "plain" and keep giving the same error... Any ideas on how to solve it?

Same problem.
 
I can't use salt as an encryption type in my config. I'm using sha1.
Code:
STEP 1
Check server configuration
Error occured!
Error ID:
More info: ERROR: #C-1 : Class::ConfigLUA - Line 27 of LUA config file is not valid [key: encryptionType]

File: C:\UniServer\www\classes/configlua.php  Line: 59
File: C:\UniServer\www\classes/configlua.php  Line: 20
File: C:\UniServer\www\classes/configlua.php  Line: 12
File: C:\UniServer\www/install.php  Line: 249
Which TFS version?

--------------------------------
If anyone is interested.. this is page wars.php for TFS 1.0:

PHP:
<?php
if(!defined('INITIALIZED'))
    exit;

$main_content = "<h1 align=\"center\">Guild Wars</h1>
To invite guild to war use your guild page.
<br>
<script type=\"text/javascript\"><!--
function show_hide(flip)
{
        var tmp = document.getElementById(flip);
        if(tmp)
                tmp.style.display = tmp.style.display == 'none' ? '' : 'none';
}
--></script>
<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"4\">
<tr>
<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\" width=\"150\"><b>Aggressor</b></td>
<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\"><b>Information</b></td>
<td style=\"background: " . $config['site']['vdarkborder'] . "\" class=\"white\" width=\"150\"><b>Enemy</b></td>
</tr>";
$warFrags = array();
foreach($SQL->query('SELECT * FROM `guildwar_kills` ORDER BY `time` DESC')->fetchAll() as $frag)
{
    $warFrags[$frag['warid']][] = $frag;
}

$count = 0;
foreach($SQL->query('SELECT `guild_wars`.`id`, `guild_wars`.`guild1`, `guild_wars`.`guild2`, `guild_wars`.`name1`, `guild_wars`.`name2`, `guild_wars`.`status`, `guild_wars`.`started`, `guild_wars`.`ended`, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild1`) guild1_kills, (SELECT COUNT(1) FROM `guildwar_kills` WHERE `guildwar_kills`.`warid` = `guild_wars`.`id` AND `guildwar_kills`.`killerguild` = `guild_wars`.`guild2`) guild2_kills FROM `guild_wars` ORDER BY `started` DESC') as $war)
{
    $count++;
    $main_content .= "<tr style=\"background: " . (is_int($count / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . ";\">
<td align=\"center\"><a href=\"?subtopic=guilds&action=show&guild=".$war['guild1']."\"><img src=\"guild_image.php?id=" . $war['guild1'] . "\" width=\"64\" height=\"64\" border=\"0\"/><br />".htmlspecialchars($war['name1'])."</a></td>
<td class=\"white\" align=\"center\">";
    switch($war['status'])
    {
        case 0:
        {
            $main_content .= "<font color=black><b>Pending acceptation</b><br />Invited on " . date("M d Y, H:i:s", $war['started']) . " for " . (($war['ended'] - $war['started']) / 86400) . " days.<br /></font>";
            break;
        }
        case 1:
        {
            $main_content .= "<font size=\"12\"><span style=\"color: red;\">" . $war['guild1_kills'] . "</span><font color=black> : </font><span style=\"color: lime;\">" . $war['guild2_kills'] . "</span></font><br /><br /><span style=\"color: darkred; font-weight: bold;\">On a brutal war</span><br /><font color=black>Began on " . date("M d Y, H:i:s", $war['started']) . ", will end up at " . date("M d Y, H:i:s", $war['ended']) . ".<br /></font>";
            break;
        }
        case 2:
        {
            $main_content .= "Rejected invitation<br />Invited on " . date("M d Y, H:i:s", $war['started']) . ", rejected on " . date("M d Y, H:i:s", $war['ended']) . ".";
            break;
        }
        case 3:
        {
            $main_content .= "<s>Canceled invitation</s><br />Sent invite on " . date("M d Y, H:i:s", $war['started']) . ", canceled on " . date("M d Y, H:i:s", $war['ended']) . ".";
            break;
        }
        case 4:
        {
            $main_content .= "<i>Ended</i><br />Began on " . date("M d Y, H:i:s", $war['started']) . ", ended on " . date("M d Y, H:i:s", $war['ended']) . ". Frag statistics: <span style=\"color: red;\">" . $war['guild1_kills'] . "</span> to <span style=\"color: lime;\">" . $war['guild2_kills'] . "</span>.";
            break;
        }
        default:
        {
            $main_content .= "Unknown, please contact with gamemaster.";
            break;
        }
    }
    $main_content .= "<br /><br /><a onclick=\"show_hide('war-details:" . $war['id'] . "'); return false;\" style=\"cursor: pointer;\">&raquo; Details &laquo;</a></td>
<td align=\"center\"><a href=\"?subtopic=guilds&action=show&guild=".$war['guild2']."\"><img src=\"guild_image.php?id=" . $war['guild2'] . "\" width=\"64\" height=\"64\" border=\"0\"/><br />".htmlspecialchars($war['name2'])."</a></td>
</tr>
<tr id=\"war-details:" . $war['id'] . "\" style=\"display: none; background: " . (is_int($count / 2) ? $config['site']['darkborder'] : $config['site']['lightborder']) . ";\">
<td colspan=\"3\">";
    if(in_array($war['status'], array(1,4)))
    {
        if(isset($warFrags[$war['id']]))
        {
            foreach($warFrags[$war['id']] as $frag)
            {
                $main_content .= date("j M Y, H:i", $frag['time']) . " <span style=\"font-weight: bold; color: " . ($frag['killerguild'] == $war['guild1'] ? "red" :"lime") . ";\">+</span><a href=\"?subtopic=characters&name=" . urlencode($frag['killer']) . "\"><b>".htmlspecialchars($frag['killer'])."</b></a> killed <a href=\"?subtopic=characters&name=".urlencode($frag['target'])."\"> " . htmlspecialchars($frag['target']) . "</a>";
            }
        }
        else
            $main_content .= "<center>There were no frags on this war so far.</center>";
    }
    else
        $main_content .= "</td></tr>";
}
if($count == 0)
    $main_content .= "<tr style=\"background:".$config['site']['darkborder'].";\">
<td colspan=\"3\">Currently there are no active wars.</td>
</tr>";
$main_content .= "</table>";

On tuesday I will finish guilds.php for TFS 1.0 with wars information [on each guild page] and buttons to invite to war/accept invitation/reject invitation/cancel invitation.
 
I love you so much right now Geisor. Just got one problem and it's my own fault because before you saved my life just now i was messing around with my database tables and i deleted the two columns name1 and name2. Any idea how i should set it up again?

Code:
ALTER TABLE  `guild_wars` CHANGE  `name1`  `name1` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
 
I love you so much right now Geisor. Just got one problem and it's my own fault because before you saved my life just now i was messing around with my database tables and i deleted the two columns name1 and name2. Any idea how i should set it up again?

Code:
ALTER TABLE  `guild_wars` CHANGE  `name1`  `name1` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL ;
If you don't have any wars in database you can remove that table and add again (when ots is offline!!):
PHP:
CREATE TABLE IF NOT EXISTS `guild_wars` (

  `id` int(11) NOT NULL AUTO_INCREMENT,
  `guild1` int(11) NOT NULL DEFAULT '0',
  `guild2` int(11) NOT NULL DEFAULT '0',
  `name1` varchar(255) NOT NULL,
  `name2` varchar(255) NOT NULL,
  `status` tinyint(2) NOT NULL DEFAULT '0',
  `started` bigint(15) NOT NULL DEFAULT '0',
  `ended` bigint(15) NOT NULL DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `guild1` (`guild1`),
  KEY `guild2` (`guild2`)
) ENGINE=InnoDB  DEFAULT CHARSET=latin1;

If you have to fix your current guild_wars table without closing OTS you can execute in phpmyadmin:
PHP:
ALTER TABLE  `guild_wars` ADD  `name1` VARCHAR( 255 ) NOT NULL;

ALTER TABLE  `guild_wars` ADD  `name2` VARCHAR( 255 ) NOT NULL;
 
What do you think about old 'wars' design? Should I change anything?

SLRqSj.png


- Because of TFS 1.0 limits all wars length must be 7 days.
- Not accepted/canceled/rejected invitations for wars disappear after server restart.
- To use wars script you will have to install 1 globalevent, because there is no script to finish wars in TFS 1.0, so they could stay open foreven if you don't install special script

- You can start war anytime (you must relog after start war on www, if you don't want to get 'unjust' in game)
- You should finish [change status to 'ended'] war when all players are offline (players can abuse some bugs and kill enemies after end of war without unjust frags), that's why my LUA script will finish wars at server restart


UPDATE:
On page guilds.php (on wars.php it's sorted by 'time of action') wars got custom list order, first are 'on brutal war', then 'inviations', then 'ended' and then canceled/rejected. With that order some noob guild can't send your guild 100 invites and cancel them to move your current wars score to boootttooom of page.
 
Last edited:
Gesior, you're doing a great job, I will never use anything else than Gesior, your reputation is way more high than the other, keep it up!
 
Hi Gesior.pl, I wonder if you could post the complete website with updates...
I'm having trouble creating accounts on Rookgaard and configure items beginning.
Another option I'm missing is the shop.
the option that is buggy online player.

I would like my site to be like this!
http://positive-global.com/?subtopic=latestnews

The aac he gives is complete, except war system and house auction if you use 1.0. About starting item, change the sample character, sometimes you need to change a thing in the database, save or savecharacter is the column named, change it to 1, login and give it lvl / eq etc.

Gesior, you're doing a great job, I will never use anything else than Gesior, your reputation is way more high than the other, keep it up!
Could not agree more, the support ive gotten from him is amazing, now when he has created the war system and house auction there is no reason to leave gesior, + a thing that znote dosen't have is years of ppl's layouts and scripts where most of the still work without any changes, (tho queries should be updated.)
 
could you teach me where and which files do I change???
I would put born on Rookgaard, with the initial items there.
I would like to modify the rod online player equal to the. http://positive-global.com.
if you have time to teach me how to do this I will be eternally grateful. :)
 
Back
Top