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

[Gesior.pl]

Where i can edit heal, mana,magic level of my players samples?
In my mysql database only have -
but no sorcer,druid,paladin and kina how can edit this?

Acc. maker create sample chars when you install it (install.php).
You can login on these characters in game (account 1) and edit their 'stats' by GOD (use MC to login 2 chars in same time) with command /attr hereparam param2
or in phpmyadmin in table 'players'

 

[Skonelapper]

why does not work the script. The top 10 players

<?PHP
					$order = 0;
					$number_of_people = 0;
					$skills = $SQL->query('SELECT name,online,level,experience,vocation,promotion FROM players WHERE players.deleted = 0 AND players.group_id < '.$config['site']['players_group_id_block'].' AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;');
						foreach($skills as $skill) {
						  $order++;
							if(is_int($number_of_people / 2))
								$bgcolor = $config['site']['darkborder'];
							else
								$bgcolor = $config['site']['lightborder'];
								$number_of_people++;
								$players_skill .= '<tr BGCOLOR="'.$bgcolor.'"><td align="center">'.$order.'.</td><td align="left"><B><a href="?subtopic=characters&name='.urlencode($skill['name']).'">'.($skill['online']>0 ? "<font color=\"green\">".$skill['name']."</font>" : "".$skill['name']."</font>").'</a></td> <td align="center"><font color="#7073FC"><em>LvL '.$skill['level'].'</em></font></td>';
						}
					echo "$players_skill";
				?>

please help

 

[Gesior.pl]

Part of SQL query with groups blocked is changed in 2012 version:

players.group_id < '.$config['site']['players_group_id_block'].'

is now:

players.group_id NOT IN ('.implode(',', $config['site']['groups_hidden']).')

because now in config.php you can set list of groups blocked:

$config['site']['groups_hidden'] = array(4, 5, 6);

That way group with id 7 or 123 can be for players and they are visible on highscores etc., some OTS use it.

 

[Skonelapper]

thank you, it works now

 

[Niioxce]

hey, im getting a problem when im trying to login on existing account

Fatal error: Call to a member function fetch_object() on a non-object in C:\xampp\htdocs\classes\account.php on line 33

- - - Updated - - -

i ment

Fatal error: Call to a member function fetch() on a non-object in C:\xampp\htdocs\classes\account.php on line 33

 

[Ninja]

Change false to true and paste the errors here or PM.

define('DEBUG_DATABASE', false);

 

[Niioxce]

Change false to true and paste the errors here or PM.

define('DEBUG_DATABASE', false);

where does i find that php code?

 

[Ninja]

Sorry forgot to mention that, index.php ^_^

 

[Niioxce]

thanks, stay here! so i can update you xd

- - - Updated - - -

Sorry forgot to mention that, index.php ^_^

Query: SELECT `id`, `name`, `password`, `salt`, `premdays`, `lastday`, `email`, `email_new_time`, `key`, `group_id`, `create_ip`, `create_date`, `premium_points`, `page_access`, `location`, `rlname`, `email_new`, `email_code`, `next_email`, `last_post`, `flag` FROM `accounts` WHERE `name` = 'frasse'
SQLSTATE: 42S22
Driver code: 1054
Error message: Unknown column 'salt' in 'field list'

 

[Ninja]

Which TFS version are you using if I may ask?

 

[Niioxce]

where can i see that? but i downloaded it here http://otland.net/f18/pheonixia-ot-8-6-new-everything-enjoy-173258/

 

[Ninja]

Seems like it's based on TFS 0.3.6, so you should use this.

 

[Niioxce]

Seems like it's based on TFS 0.3.6, so you should use this.

now i have installed and i get this

Error occured!
Error ID: ObjectData::getCustomField - Field email_new_time does not exist in data / is not loaded.
More info:

File: C:\xampp\htdocs\classes/objectdata.php   Line: 52
File: C:\xampp\htdocs\pages/accountmanagement.php   Line: 42
File: C:\xampp\htdocs\system/load.page.php   Line: 7
File: C:\xampp\htdocs/index.php   Line: 37

- - - Updated - - -

Seems like it's based on TFS 0.3.6, so you should use this.

now it gives me this for some reason

Query: 	SELECT `g`.`id` AS `id`, `g`.`name` AS `name`, COUNT(`g`.`name`) AS `frags` FROM `killers` k LEFT JOIN `player_killers` pk ON `k`.`id` = `pk`.`kill_id` LEFT JOIN `players` p ON `pk`.`player_id` = `p`.`id` LEFT JOIN `guild_ranks` gr ON `p`.`rank_id` = `gr`.`id` LEFT JOIN `guilds` g ON `gr`.`guild_id` = `g`.`id` WHERE `g`.`id` > 0 AND `k`.`unjustified` = 1 AND `k`.`final_hit` = 1 GROUP BY `name` ORDER BY `frags` DESC, `name` ASC LIMIT 4;
SQLSTATE: 	00000
Driver code: 	
Error message: 	
Query: 	SELECT `players`.`name`, `z_forum`.`post_text`, `z_forum`.`post_topic`, `z_forum`.`post_smile`, `z_forum`.`id`, `z_forum`.`replies`, `z_forum`.`post_date` FROM `players`, `z_forum` WHERE `players`.`id` = `z_forum`.`author_guid` AND `z_forum`.`section` = 1 AND `z_forum`.`first_post` = `z_forum`.`id` ORDER BY `z_forum`.`last_post` DESC LIMIT 6
SQLSTATE: 	42S02
Driver code: 	1146
Error message: 	Table 'otserver.z_forum' doesn't exist

 

[Ninja]

It should be adding that table to your database when you're installing Gesior, you got the query for it in install.php though.

 

[Niioxce]

It should be adding that table to your database when you're installing Gesior, you got the query for it in install.php though.

i just removed the database and created a new, it should work with the new one, thanks alot for trying mate!:*

 

[Wavoz]

Admin panel is not available in this version of Gesior acc. maker as there is no option to show

How can i add news to latest news?


Edit:
Found my answer:
forum integrated with news (only admin can create thread on forum on board 'News', threads content is visible on 'latestnews')

 

[kito2]

Why if I try to use $player->getCustomField('onlinetimeall'); it says the following error:

[h=3]Error occured![/h]Error ID: ObjectData::getCustomField - Field onlinetimeall does not exist in data / is not loaded.
More info:

File: /var/www/classes/objectdata.php Line: 52
File: /var/www/pages/characters.php Line: 278
File: /var/www/system/load.page.php Line: 7
File: /var/www/index.php Line: 41

 

[rexgandi]

where is index.php?
How add a new table on menu np. Offline Training? please help me . I use every time old gesior . And i change ...

 

[Acubens]

Why if I try to use $player->getCustomField('onlinetimeall'); it says the following error:

[h=3]Error occured![/h]Error ID: ObjectData::getCustomField - Field onlinetimeall does not exist in data / is not loaded.
More info:

File: /var/www/classes/objectdata.php Line: 52
File: /var/www/pages/characters.php Line: 278
File: /var/www/system/load.page.php Line: 7
File: /var/www/index.php Line: 41

Maybe onlinetimeall is missed in your db

 

[kito2]

No it isn't, already fixed...