• 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!

UNNAMED acc. maker 0.3.2 beta for TFS

Status
Not open for further replies.
Warning: Error parsing C:\Users\Jake\Desktop\cryingdamson-gui\config.lua on line 124 in C:\Users\Jake\Desktop\wamp\www\config-and-functions.php on line 13
Database error. Unknown database type in C:\Users\Jake\Desktop\cryingdamson-gui\config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

:S how come its saying this i am using the new version of TFS
 
Regnier said:
Warning: Error parsing C:\Users\Jake\Desktop\cryingdamson-gui\config.lua on line 124 in C:\Users\Jake\Desktop\wamp\www\config-and-functions.php on line 13
Database error. Unknown database type in C:\Users\Jake\Desktop\cryingdamson-gui\config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""

:S how come its saying this i am using the new version of TFS
Click to expand...

In folder with OTS you have to change config.lua file.

Find line with:
Code: 
sqlType = "sqlite"

Change to:
Code: 
sqlType = "mysql"
 
yea we did change that lol, were not that dumb:p but yeah we also fixed it now thanks to jiddo =)
 
This run in SQLite?

Database error - can't open SQLite database. Possible reasons:
C:/Documents and Settings/Fellipe/Desktop/Orion/ - file isn't valid SQLite database.
C:/Documents and Settings/Fellipe/Desktop/Orion/ - doesn't exist.

And when i change config.lua SQLite to Mysql

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database. Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:/Documents and Settings/Fellipe/Desktop/Orion/config.lua .
3. MySQL user, password, database or host is wrong.


My server is SQLITE no MYSQL Help me ...
 
lipexxx said:
This run in SQLite?

Database error - can't open SQLite database. Possible reasons:
C:/Documents and Settings/Fellipe/Desktop/Orion/ - file isn't valid SQLite database.
C:/Documents and Settings/Fellipe/Desktop/Orion/ - doesn't exist.

And when i change config.lua SQLite to Mysql

Check database connection
If you don't see any errors press link to STEP 3 - Add tables and columns to DB. If you see some errors it mean server has wrong configuration. Check FAQ or ask author of acc. maker.Database error - can't connect to MySQL database. Possible reasons:
1. MySQL server is not running on host.
2. MySQL user, password, database or host isn't configured in: C:/Documents and Settings/Fellipe/Desktop/Orion/config.lua .
3. MySQL user, password, database or host is wrong.


My server is SQLITE no MYSQL Help me ...
Click to expand...


Set up correctly mysql/sqlite in the your config



Yours Illusion Storm.
 
Code: 
Last Deaths
1.
	9.02.2009, 21:33:59	Xeda killed at level 17 by Termica.
2.
	9.02.2009, 21:33:59	Xeda killed at level 17 by Termica.
3.
	9.02.2009, 21:31:08	Nominalek killed at level 36 by a war wolf.
4.
	9.02.2009, 21:31:08	Nominalek killed at level 36 by a war wolf.
any1 got same problem with last deaths ?...
 
Hi im using the version for tfs 0.2 and i have a problem with the guilds it doesn't show me as leader and doesn't give me any options to change things ex, add ppl. heres a screen shot of what i mean
website.jpg
 
STEP 1
Check server configuration

Warning: Error parsing C:/cryingdamson-gui/config.lua on line 126 in C:\Arquivos de programas\VertrigoServ\www\ot\install.php on line 150
File config.lua loaded from C:/cryingdamson-gui/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection


help:confused:
 
Gesior.pl

gratz of yor web..

i update my server for The Forgotten Server, version 0.3.1 (Crying Damson)

and i try use all of yor web and dont work 100%

you has maker web fot this version ?
 
Quickshot said:
Hi im using the version for tfs 0.2 and i have a problem with the guilds it doesn't show me as leader and doesn't give me any options to change things ex, add ppl. heres a screen shot of what i mean
website.jpg
Click to expand...

Set your account at database "pageacces = 3" and then log in, then go to guilds and it will show this:

Code: 
If you have any problem with guilds try:
Cleanup players - can't join guild/be invited? Can't create guild? Try cleanup players.
Cleanup guilds - made guild, you are a leader, but you are not on players list? Cleanup guilds!

Ceanup guilds or players, check it and then post.

marcelobblade said:
STEP 1
Check server configuration

Warning: Error parsing C:/cryingdamson-gui/config.lua on line 126 in C:\Arquivos de programas\VertrigoServ\www\ot\install.php on line 150
File config.lua loaded from C:/cryingdamson-gui/config.lua and looks like fine server config file. Now you can check database(mysql) connection: STEP 2 - check database connection


help:confused:
Click to expand...

Is your mysql online? It needs to be online, with the correct user and pass of your phpmyadmin.
 
C:/Users/Jompi/Desktop/0.3b2-gui/ - file isn't valid SQLite database.
C:/Users/Jompi/Desktop/0.3b2-gui/ - doesn't exist.




Check FAQ or ask author of acc. maker.Database error - can't open SQLite database. Possible reasons:


I checked the "FAQ"
And the "author" ignores.


Had this problem for a few weeks now, anyone else wants to be the hero?
 
Okay I fixed that ^


But when I'm gonna make the admin account I get:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampp168\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp168\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp168\htdocs\install.php(459): OTS_Account->load(1) #2 {main} thrown in C:\xampp168\htdocs\pot\OTS_Account.php on line 229
 
Jompi said:
Okay I fixed that ^


But when I'm gonna make the admin account I get:

Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'name' in 'field list'' in C:\xampp168\htdocs\pot\OTS_Account.php:229 Stack trace: #0 C:\xampp168\htdocs\pot\OTS_Account.php(229): PDO->query('SELECT `id`, `n...') #1 C:\xampp168\htdocs\install.php(459): OTS_Account->load(1) #2 {main} thrown in C:\xampp168\htdocs\pot\OTS_Account.php on line 229
Click to expand...
Do you use 0.2 SQLite database (field 'name' to table 'accounts' added in tfs 0.3)? You can't login on 0.3 server/acc. maker with TFS 0.2 database - acc. maker doesn't work.

@Quickshot
in config.lua of TFS set inGameGuildManager = "no" or you will get this error again (guild with no leader) - you can't use in-game guild manager and acc. maker guild manager in same time.
 
Gesior.pl said:
Do you use 0.2 SQLite database (field 'name' to table 'accounts' added in tfs 0.3)? You can't login on 0.3 server/acc. maker with TFS 0.2 database - acc. maker doesn't work.

@Quickshot
in config.lua of TFS set inGameGuildManager = "no" or you will get this error again (guild with no leader) - you can't use in-game guild manager and acc. maker guild manager in same time.
Click to expand...


What? I use 0.3b2-gui

The exact same as this thread says it's for.
 
And I did switch of the ingame guild thing, yes.
 
Where i can set directory of house files?

How to fix this ?
showpict.php
 
i cant edit :/

Gesior.pl said:
New highscores, user select vocation: All, None, Sorcerer, Druid... (load number of vocations and vocation names from config.php, work with custom vocations config)
PHP: 
<?PHP
$list = $_REQUEST['list'];
$page = $_REQUEST['page'];
$vocation = substr($_GET['vocation'], 0, 3);
if(is_numeric($_GET['vocation']))
	$vocation_sql = ' AND `players`.`vocation`='.(int) $vocation;
switch($list)
{
  case "fist":
   $id = 0;
   $list_name = 'Fist Fighting';
   break;
  case "club":
   $id = 1;
   $list_name = 'Club Fighting';
   break;
  case "sword":
   $id = 2;
   $list_name = 'Sword Fighting';
   break;
  case "axe":
   $id = 3;
   $list_name = 'Axe Fighting';
   break;
  case "distance":
   $id = 4;
   $list_name = 'Distance Fighting';
   break;
  case "shield":
   $id = 5;
   $list_name = 'Shielding';
   break;
  case "fishing":
   $id = 6;
   $list_name = 'Fishing';
   break;
}
if(!isset($id))
	if($list == "magic")
		$list_name = "Magic Level";
	else
	{
		$list_name = 'Experience';
		$list = 'experience';
	}
if(count($config['site']['worlds']) > 1)
{
	$worlds .= '<i>Select world:</i> ';
	foreach($config['site']['worlds'] as $idd => $world_n)
	{
		$worlds .= ' <a href="?subtopic=highscores&list='.$list.'&vocation='.$vocation.'&world='.$idd.'">'.$world_n.'</a> , ';
		if($idd == (int) $_GET['world'])
		{
			$world_id = $idd;
			$world_name = $world_n;
		}
	}
	$main_content .= substr($worlds, 0, strlen($worlds)-3);
}
if(!isset($world_id))
{
	$world_id = 0;
	$world_name = $config['server']['serverName'];
}
$offset = $page * 100;
if(isset($id))
	$skills = $SQL->query('SELECT name,online,value,level,vocation,promotion FROM players,player_skills WHERE players.world_id = '.$world_id.' AND players.deleted = 0'.$vocation_sql.' AND players.group_id < '.$config['site']['players_group_id_block'].' AND players.id = player_skills.player_id AND player_skills.skillid = '.$id.' ORDER BY value DESC, count DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "magic")
	$skills = $SQL->query('SELECT name,online,maglevel,level,vocation,promotion FROM players WHERE players.world_id = '.$world_id.' AND players.deleted = 0'.$vocation_sql.' AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY maglevel DESC, manaspent DESC LIMIT 101 OFFSET '.$offset);
elseif($list == "experience")
	$skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.world_id = '.$world_id.' AND players.deleted = 0'.$vocation_sql.' AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 101 OFFSET '.$offset);
//wyswietlanie wszystkiego
$main_content .= '<TABLE BORDER=0 CELLPADDING=0 CELLSPACING=0 WIDTH=100%><TR><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD><TD><CENTER><H2>Ranking for '.$list_name.' on '.$world_name.'</H2></CENTER><BR><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%></TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD WIDTH=10% CLASS=whites><B>Rank</B></TD><TD WIDTH=75% CLASS=whites><B>Name</B></TD><TD WIDTH=15% CLASS=whites><b><center>Level</center></B></TD>';
if($list == "experience")
	$main_content .= '<TD CLASS=whites><b><center>Points</center></B></TD>';
$main_content .= '</TR><TR>';
foreach($skills as $skill)
{
	if($number_of_rows < 100)
	{
		if($list == "magic")
			$skill['value'] = $skill['maglevel'];
		if($list == "experience")
			$skill['value'] = $skill['level'];
		if(!is_int($number_of_rows / 2)) { $bgcolor = $config['site']['darkborder']; } else { $bgcolor = $config['site']['lightborder']; } $number_of_rows++;
		$main_content .= '<tr bgcolor="'.$bgcolor.'"><td>'.($offset + $number_of_rows).'.</td><td><a href="?subtopic=characters&name='.urlencode($skill['name']).'">'.($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "<font color=\"red\">".$skill['name']."</font>").'</a><br><small>'.$skill['level'].' '.$vocation_name[$world_id][$skill['promotion']][$skill['vocation']].'</small></td><td><center>'.$skill['value'].'</center></td>';
		if($list == "experience")
			$main_content .= '<td><center>'.$skill['experience'].'</center></td>';
		$main_content .= '</tr>';
	}
	else
		$show_link_to_next_page = TRUE;
}
$main_content .= '</TABLE><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1 WIDTH=100%>';
if($page > 0)
	$main_content .= '<TR><TD WIDTH=100% ALIGN=right VALIGN=bottom><A HREF="?subtopic=highscores&list='.$list.'&page='.($page - 1).'" CLASS="size_xxs">Previous Page</A></TD></TR>';
if($show_link_to_next_page)
	$main_content .= '<TR><TD WIDTH=100% ALIGN=right VALIGN=bottom><A HREF="?subtopic=highscores&list='.$list.'&page='.($page + 1).'" CLASS="size_xxs">Next Page</A></TD></TR>';
$main_content .= '</TABLE></TD><TD WIDTH=5%><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=1 HEIGHT=1 BORDER=0></TD><TD WIDTH=15% VALIGN=top ALIGN=right><TABLE BORDER=0 CELLPADDING=4 CELLSPACING=1><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=whites><B>Choose a skill</B></TD></TR><TR BGCOLOR="'.$config['site']['lightborder'].'"><TD><A HREF="?subtopic=highscores&list=experience&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Experience</A><BR><A HREF="?subtopic=highscores&list=magic&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Magic</A><BR><A HREF="?subtopic=highscores&list=shield&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Shielding</A><BR><A HREF="?subtopic=highscores&list=distance&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Distance</A><BR><A HREF="?subtopic=highscores&list=club&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Club</A><BR><A HREF="?subtopic=highscores&list=sword&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Sword</A><BR><A HREF="?subtopic=highscores&list=axe&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Axe</A><BR><A HREF="?subtopic=highscores&list=fist&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Fist</A><BR><A HREF="?subtopic=highscores&list=fishing&vocation='.$vocation.'&world='.$world_id.'" CLASS="size_xs">Fishing</A><BR></TD></TR><TR BGCOLOR="'.$config['site']['vdarkborder'].'"><TD CLASS=whites><B>Vocation</B></TD></TR><TR BGCOLOR="'.$config['site']['lightborder'].'"><TD><A HREF="?subtopic=highscores&list='.$list.'&vocation=&world='.$world_id.'" CLASS="size_xs">All</A><BR>';
foreach($vocation_name[$world_id][0] as $voc_id => $voc_name)
	$main_content .= '<A HREF="?subtopic=highscores&list='.$list.'&vocation='.$voc_id.'&world='.$world_id.'" CLASS="size_xs">'.$voc_name.'</A><BR>';
$main_content .= '</TD></TR></TABLE></TD><TD><IMG SRC="'.$layout_name.'/images/general/blank.gif" WIDTH=10 HEIGHT=1 BORDER=0></TD></TR></TABLE>';
?>
Click to expand...

This for me doesnt work
Warning: Invalid argument supplied for foreach() in C:\xampp2\htdocs\highscores.php on line 100
Click to expand...



and my error with houses



 
Warning: parse_ini_file(E:/Documents and Settings/LoL/Pulpit/0.3/config.lua) [function.parse-ini-file]: failed to open stream: No such file or directory in C:\xampp\htdocs\config-and-functions.php on line 13
Database error. Unknown database type in E:/Documents and Settings/LoL/Pulpit/0.3/config.lua . Must be equal to: "mysql" or "sqlite". Now is: ""
Co to ma kurwa byc?
 
@kama

use english here

to fix this go to htdocs/config/config.ini and set directory to your server
 
Status
Not open for further replies.

Similar threads

maxumic
  • Locked
[$50] OTC Advanced Guild Module
Replies
13
Views
2K
Niebieski
Niebieski
nitrox
[NT ACC] Account Manager in NextJs
Replies
13
Views
1K
Fjorda
F
Jpstafe
  • Solved
Erro Rook_Sample created(MYACC)
Replies
2
Views
313
Jpstafe
Jpstafe
Czorcik
  • Question
Highscore reborn system in acc maker
Replies
0
Views
271
Czorcik
Czorcik
Narg
[USA] [Custom / 10.98] NextGen OTServ Season 2 with Attribute Allocation, Custom Map, RPG and Build Versatility, Everyone is welcome!!
2
Replies
32
Views
4K
Narg
Narg
P
Valoria MMO
2
Replies
30
Views
3K
TheMyth
TheMyth
ralke
  • Question
AAC ZnoteAAC show killing assists at characterprofile deathlist
Replies
0
Views
179
ralke
ralke
conman
  • Question
Canary RL 13.21 - Loyalty System (and other) questions - newbie needs experienced users' help
Replies
6
Views
321
conman
conman
Mehra
[SWEDEN][13.30] Mehra Tibia | Unique Hazard Feature | Lots of QoL features | 1 year anniversary
Replies
18
Views
2K
Mehra
Mehra
Rizzor
[USA] [Custom / 6.x] [Slaynville]
2
Replies
37
Views
2K
Caudeus
C
Back
Top