• 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 acc. maker for TFS

Status
Not open for further replies.
When I use Cleanup guilds - made guild, you are a leader, but you are not on players list? Cleanup guilds! I get this error

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1122 Stack trace: #0 C:\xampp\htdocs\guilds.php(2056): OTS_Player->getRank() #1 C:\xampp\htdocs\index.php(128): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1122

GESIOR what I doing wrong? Can you help me
 
When I use Cleanup guilds - made guild, you are a leader, but you are not on players list? Cleanup guilds! I get this error

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1122 Stack trace: #0 C:\xampp\htdocs\guilds.php(2056): OTS_Player->getRank() #1 C:\xampp\htdocs\index.php(128): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1122

GESIOR what I doing wrong? Can you help me
Char of guild leader (his ID) doesn't exist in database. I'll fix it and post in next version better "cleanup guilds" script.
In place of [guilds.php, lines 2030-2079]:
PHP:
if($action == 'cleanup_guilds')
{
	if($logged)
	{
		$guilds_list = new OTS_Guilds_List();
		$guilds_list->init();
		if(count($guilds_list) > 0)
		{
			foreach($guilds_list as $guild)
			{
				$error = 0;
				$leader = $guild->getOwner();
				$leader_rank = $leader->getRank();
				if(!empty($leader_rank))
				{
					if($leader_rank->isLoaded())
					{
						$leader_guild = $leader_rank->getGuild();
						if($leader_guild->isLoaded())
						{
							if($leader_guild->getId() != $guild->getId())
								$error = 1;
						}
						else
							$error = 1;
					}
					else
						$error = 1;
				}
				else
					$error = 1;
				if($error == 1)
				{
					$deleted_guilds[] = $guild->getName();
					$status = delete_guild($guild->getId());
				}
			}
			$main_content .= "<b>Deleted guilds (leaders of this guilds are not members of this guild [fix bugged guilds]):</b>";
			if(!empty($deleted_guilds))
				foreach($deleted_guilds as $guild)
					$main_content .= "<li>".$guild;
		}
		else
			$main_content .= "0 guilds found.";
	}
	else
		$main_content .= "You are not logged in.";
	$main_content .= "<center><h3><a href=\"index.php?subtopic=guilds\">BACK</a></h3></center>";
}]
PUT:
PHP:
if($action == 'cleanup_guilds')
{
	if($logged)
	{
		$guilds_list = new OTS_Guilds_List();
		$guilds_list->init();
		if(count($guilds_list) > 0)
		{
			foreach($guilds_list as $guild)
			{
				$error = 0;
				$leader = $guild->getOwner();
				if($leader->isLoaded())
				{
					$leader_rank = $leader->getRank();
					if(!empty($leader_rank))
					{
						if($leader_rank->isLoaded())
						{
							$leader_guild = $leader_rank->getGuild();
							if($leader_guild->isLoaded())
							{
								if($leader_guild->getId() != $guild->getId())
									$error = 1;
							}
							else
								$error = 1;
						}
						else
							$error = 1;
					}
					else
						$error = 1;
				}
				else
					$error = 1;
				if($error == 1)
				{
					$deleted_guilds[] = $guild->getName();
					$status = delete_guild($guild->getId());
				}
			}
			$main_content .= "<b>Deleted guilds (leaders of this guilds are not members of this guild [fix bugged guilds]):</b>";
			if(!empty($deleted_guilds))
				foreach($deleted_guilds as $guild)
					$main_content .= "<li>".$guild;
		}
		else
			$main_content .= "0 guilds found.";
	}
	else
		$main_content .= "You are not logged in.";
	$main_content .= "<center><h3><a href=\"index.php?subtopic=guilds\">BACK</a></h3></center>";
}
 
Last edited:
Gesior can you add on adm panel - "delete inactive players" ???
 
Gesior can you add on adm panel - "delete inactive players" ???
I have this function, but its really destructive if you config it wrong :p
I can add it in next version, but i'll not add button "delete old players/accounts". Advanced admin will find info how to run it in first post. I made it for friend:
PHP:
<?PHP
//if ACCOUNT did not login from $daysago days check character levels
$daysago = 1;
//if any character from account have level $minlevel --> delete account, all characters
$minlevel = 2;
//-------------KONIEC KONFIGA -----------------------
$time_delete = time() - $daysago * 3600 * 24;
$usunietych_kont = 0;
$usunietych_charow = 0;
$lista_kont = $SQL->query("SELECT * FROM accounts WHERE lastday < ".$time_delete);
foreach($lista_kont as $konto_do_zaladowania) {
$account = new OTS_Account;
$account->load($konto_do_zaladowania['id']);
$players = $account->getPlayers();
$to_delete = TRUE;
if(count($players) != 0) {
foreach($players as $player) {
if($player->getLevel() >= $minlevel) {
$to_delete = FALSE;
}
}
}
if($to_delete) {
//kasowanie charow i konta
foreach($players as $player) {
delete_player($player->getName());
$usunietych_charow++;
}
$account->delete();
$usunietych_kont++;
}
}
$main_content .= 'Deleted accounts: '.$usunietych_kont.'<br>Deleted characters: '.$usunietych_charow;
?>
With config:
Code:
$daysago = 1;
$minlevel = 2;
It will delete all accounts made 1 day or more ago and with chars with 1 lvl (accounts created with characters, but never logged any character and gain 2 lvl). You can put this code in place of any .php subpage in accmaker (server rules.php?) and open this page to run.
----------------------------
EDIT
My server acc. maker page :)
(layout "sick vision of gesior") - made in 1 hour
(I'll change all cipsoft buttons to my own buttons, first legal layout :) )
 
Last edited:
Haha work perfectly :D
Thx Gesior

@edit
on Support List, I want to change for zartha (my server) team
and I prefer to put player group name myself... (group name - position)
It will be something like this:
if player group id = 2 then player position = gm
if player group id = 3 then player position = god

Can you tell me how to do this?
 
Last edited:
@Gesior

How do I hide these characters from Highscores?

imagemit6.jpg


Great Work Gesior, I admire your work!
 
@Gesior

How do I hide these characters from Highscores?

imagemit6.jpg


Great Work Gesior, I admire your work!
I think this characters aren't a problem for any server with 100+ characters. Characters with group ID >= 2 are hidden (GMs, gods, tutors).
----------------------------------------------
Now I'm changing allowed names format in acc. maker. Maybe it will work with names like "Gesior'Qwe'Qwe And'Qwe".
- guilds tested, 100% work with names with '
- characters search tested, 100% work with names with ' (fixed also comment and rl info ' and " problems)
- account management tested, 100% work with names with ' (I must fixe create character script to block stupid names like: Gesior'' 'is' 'da' 'b'e's't or G'm Gesior
- shop system work with names with '
- lost account interface work with names with '
- highscores work with names with '
- gamemasters list work with names with '
ALL WORK? :)
 
Last edited:
@Gesior

How do I hide these characters from Highscores?

imagemit6.jpg


Great Work Gesior, I admire your work!

If your Sample character ID's are from 1-5 go to highscores.php and add to each skill this:
PHP:
AND id > 6

so it will look like:
PHP:
$skills = $pdo->query('SELECT name,value FROM players,player_skills WHERE group_id < '.$config_ini['players_group_id_gamemaster'].' AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' AND id > 6 ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);
else, I guess u can use many 'and's there so u can add many 'and's... AND name !=Druid Sample AND name !=Sorcerer Sample etc... :p
 
What in next version (0.3.0, not beta):
- accept names with '
- fixed little bugs in guilds (cleanup function), account management (char comment/rl info)
What in next version (0.3.1):
- ban manager for admins (ban, unban, edit ban) - work with TFS 0.3 only!
 
What in next version (0.3.0, not beta):
- accept names with '
- fixed little bugs in guilds (cleanup function), account management (char comment/rl info)
What in next version (0.3.1):
- ban manager for admins (ban, unban, edit ban) - work with TFS 0.3 only!

A ban manager sounds interesting, but could you develop it into a criminal record? Complaints, etc.
 
When using an apostrophe, the website adds a "\" in front of it. Any way to fix this issue?

Ab'dendriel shows up as Ab\'Dendriel
 
@Gesior

I found a little bug...

I was testing the site and found the bug. When I do the transaction of a player to another, the name does not appear to whom I received a premium account

Logged in GOD
imagemso4.jpg


BUG

\/

Logged in the player who received a premium account
imagem2wf8.jpg
 
Ab'dendriel shows up as Ab\'Dendriel
Fixed.
EDIT:
-Tested shop again and found another bug with "buy from". Fixed.
-Actualized POT to 0.1.3, now acc. maker work with TFS 0.2.xx and 0.3 :)
EDIT2:
Uff.. fixed totaly bug with names of new chars. NO MORE STUPID NAMES ON YOUR OTS! :D
Names of new chars:
Gesior'hoster - legal
Gesior''hoster - illegal (double ')
Gesior-hoster - legal
Gesior--hoster - illegal (double -)
'gesior - illegal (first ')
-gesior - illegal (first -)
Gesior' Hoster - illegal (" ' " and " - " can't be first or last char of word/name)
Geesior - legal
Gesior-'hoster - illegal (" '- " and " -' " blocked)
Geeesior - illegal (3x same char "eee")
Now names should look "normal".
Edit first post now and add new version.
-----------------------------------------------------------------------------------
VERSION 0.3.0 BETA2 in first post!
All reported bugs fixed, new char names fixed.
 
Last edited:
Mm, ok, nevermind, would only be the messages saved between GM >Player>CS
I think TFS 0.3 save CTRL+R raports and show to GMs/CMs when they login (1 msg from 1 player max.).
 
Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 321

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'key'' in C:\xampp\htdocs\install.php:321 Stack trace: #0 C:\xampp\htdocs\install.php(321): PDO->query('ALTER TABLE `ac...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 321

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'veronia.z_news_tickers' doesn't exist' in C:\xampp\htdocs\install.php:396 Stack trace: #0 C:\xampp\htdocs\install.php(396): PDO->query('SELECT * FROM z...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 396

tons of errors...
 
Last edited:
Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 321

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S21]: Column already exists: 1060 Duplicate column name 'key'' in C:\xampp\htdocs\install.php:321 Stack trace: #0 C:\xampp\htdocs\install.php(321): PDO->query('ALTER TABLE `ac...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 321

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S02]: Base table or view not found: 1146 Table 'veronia.z_news_tickers' doesn't exist' in C:\xampp\htdocs\install.php:396 Stack trace: #0 C:\xampp\htdocs\install.php(396): PDO->query('SELECT * FROM z...') #1 {main} thrown in C:\xampp\htdocs\install.php on line 396

tons of errors...
I'll post tommorow 2 versions (for TFS 0.2.x and 0.3) with fixed installator (no errors if already installed and install again) and POT downgraded to 0.1.2 (0.1.3 show too many errors).
-----------------------------------------------------
If you installed 0.3 beta you dont have to install it again. Open file "config/config.ini" and change:
install = "x"
to:
install = "no"
--------------------------------------
IF YOU USE TFS 0.2.X YOU MUST COPY DIRECTORY "POT" FROM OLDER VERSION OF ACC. MAKER [0.2.1/0.3 BETA USE POT 0.1.0]. ACTUALL VERSION OF POT [0.1.3]/ACC MAKER [0.3.0 BETA2] WORK ONLY WITH TFS 0.3
 
Last edited:
I have a problem.. when i change the name from Forgotten to my server name in thw website, the Houses doesn't work, why is that?
 
Status
Not open for further replies.
Back
Top