Gesior acc. maker for TFS

Last update: 10 May 2008 10:37
Newest version: 0.3.0 (not beta)
Layouts: tibia.com

Quote:

Originally Posted by Credits Acc. scripts: *Gesior *FightingElf - Elf POT 0.1.2 / 0.1.0 (updated!): *Wrzasq Layouts: *Tibia.com - CipSoft Gmbh

Gesior Account Maker 0.3.0 (not beta)
Features:
*Account manager:
-create account (account number random or custom, e-mail, verification image, show server rules from file)
-create character (accept names like RL tibia character names,
diffrent outfit for male/female, COPY character from database and
change name, id, sex, account..., you select character to copy in
"admin panel" like.. vocation: Sorcerer, char to copy: Sorcerer Sample,
work with unlimited number of vocations, work with new vocations
like... ID 94, vocation name: Ninja)
-change password (like on tibia.com)
-change e-mail (like on tibia.com, user must wait before e-mail change, time configurable in "admin panel")
-register account (generate rec-key, will be used in next version in "lost account interface"
-change character "comment" and set character account information "visible" or "hidden" (like on tibia.com)
-change account public information (location, rl name)
*Spells:
-load spells from OTS spells file (in "admin panel", save informations from file in database)
-set spell hidden/visible(admin) on "spells list" in library, also hide all/visible all
-show list of spells with informations, user can sort from 0 or from highest value (name, sentence, mana, soul, level, maglvl)
-user can select spells only for one vocation (and sort them)
*Monsters:
-load monsters from OTS monsters files (in "admin panel", save informations from files in database)
-set monsters hidden/visible(admin) on "monsters list" in "library", also hide all/visible all
-show list of monsters with informations about every monster (hp, mana, summonable, race) and link to page about every monster
-on page about monster user see also monster "voices" and "immunities"
*Character search:
-show informations about searched player: name, vocation, level, magic
level (show yes/no configurable in admin panel), guild, comment,
residence (town), last login
-(if player is NOT HIDDEN)show information about his account: account
status (pacc/facc), location, rl name, date when account has been
created (like tibia.com)
-show list of player deaths (like tibia.com)
-(if player is NOT HIDDEN)show list of other characters from account and "online"/"offline" near every char
*Who is online:
-show list of players online
-user can sort list by name, level or vocation
*Highscores:
-show highscores of players (level, magic level and all skills)
-100 players/page, links to next and previous page
*Last Kills/Last Deaths:
-show list of 25 (number configurable in "admin panel") last deaths from database
-rl tibia "death list" format(in table..):

Quote:

5. Qutor killed at level 25 by a dragon. 6. Teo killed at level 41 by Kent.

*Houses List:
-show list of houses on OTS and informations about: size, rent, city and "owner"
*Guild System:
-change "guild nick" (this showed in game when you look at someone)
-create guild
-show guilds list (like tibia.com)
-change rank of players with lower rank in guild
For "owner" of guild:
-change guild description
-change guild MOTD
-delete guild
-pass leadership to other mamber of guild
-upload new guild image (size limit in "admin panel")
-add rank
-change rank level (member[1], vice-leader[2], leader[3])
-change rank name
-all what players with lower ranks can
For leaders:
-kick player with lower rank from guild
-all what players with lower ranks can
For vice-leaders:
-invite new player to guild
-cancel invitation
-change rank of players with lower rank
*News System:
-show news icon, post date, text and author
-admin can give rights to write news to every player on server (tutor? gm?)
-add, edit, delete news
-if you use MySQL database (95%? ) you can use HTML in news!
-javascript scripts to add news
*Admin panel:
-add,edit,delete news, set limit of news
-edit site configuration (default layout and many options: show yes/no)
-set limits of characters per account, lines and chars in guild description and many other
-reload monsters and spells from OTS files
-reload list of vocations from OTS file and set what vocations will be
available in "create character" and name of character to copy when
player try to create character with selected vocation
-edit maaany other options of acc. maker configuration
*Lost Account Interface:
-player can request e-mail (send only 1 e-mail to one account every XX minutes- config) with link to activate new password
-player can set new e-mail and new password if has recovery key

What is new in this version:
-fixed bugs with: sqlite/mysql, installation errors, shopsystem bugs, TFS 0.3/0.2 - POT
-In this version added (from 0.2.1):
*Lost Account Interface
*E-mail sender work
*Gesior Shop System as a submenu in layout
*Gamemasters list
*Downloads page
*Server Info page
*Only names like RL tibia (a bit better )

Screens:
-account manager
Screen 1

KNOWN BUGS:
-dont copy skills of characters to new characters (all new chars have 10 skill, 0 tries [triggers])

OFFICIAL FAQ FOR GESIOR ACCOUNT MAKER

TODO list for version 0.4:
-ban manager [0%]
-houses auctions like RL tibia (with special banker script) [0%]
-new legal layout? [10%]
-fix all reported bugs, like problem with IE [0%]

LINK TO VERSION 0.3.0:
http://otland.net/attachment.php?attachmentid=601&d=1210409061

well, I don't see the use of making a new thread for the FAQ if there's a link in this thread...

the point is that this forum may block the words otfans and otlands

and i got 1 question is this puplic ot help or only mapping?
i mean only mapping stuff allowed or
puplic but specialy mapping.

it's a forum made for mapping, some small parts of lua/xml scripting will be here too (just to create scripts) and that's all actually

FAG!

Thread with account manager has ~40 pages. Newbies report bugs/problems
already reported. In this thread I post how to fix all problems with
account manager configuration and installation.

1. "SQLite doesn't work!"
Report text:

Quote:

Code: STEP 2 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 open SQLite database. Possible reasons: C:/Documents and Settings/Tommy.HALLDATORN/Skrivbord/Open Tibia_TFS/forgottenserver.s3db - file isn't valid SQLite database. C:/Documents and Settings/Tommy.HALLDATORN/Skrivbord/Open Tibia_TFS/forgottenserver.s3db - doesn't exist. this is what happen to me when i try to install your acc

HOW TO FIX:
In 90% it is problem with your www server configuration.
1. Do not use "WebServ" or other out of date distro. Delete it!
2. Download XAMPP 1.6.5 or new version, install, run "Apache" (and "MySQL" if you use MySQL database)
3. Go to directory: ~/xampp/apache/bin/
and find file php.ini, open this file in text editor and find line:

Code:

;extension=php_pdo_sqlite.dll

change to:

Code:

extension=php_pdo_sqlite.dll

4. Now "Stop" and "Start" Apache in XAMPP and install again "Gesior acc. maker"
OFFICIAL SITE OF XAMPP FOR WINDOWS

2. "MySQL doesn't work!", "Can't connect to database"
Report text:

Quote:

Code: STEP 2 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/admin/Desktop/Mystic Spirit/config.lua . 3. MySQL user, password, database or host is wrong. MySQL IS running, and the rest in config.lua is ok, too! The server can also connect to the database but your AAC not.. Avarins AAC can connect to the database, too....so whats wrong?!

HOW TO FIX:
In 70% it is problem with your www server, in 30% it is problem with
your acc. maker/TFS configuration, remember to don't ignore errors in
"Step 1" of installation (load server configuration).
1. Gesior acc. maker use new PHP functions. Other acc. makers
work on WebServ, but my need new version of PHP to connect to database.
2. Do not use "WebServ" or other out of date distro.
Delete it!
3. Download XAMPP 1.6.5 or new version, install, run "Apache" and "MySQL" if you use MySQL database
OFFICIAL SITE OF XAMPP FOR WINDOWS

3. "Error when I try to login/open highscores"
Report text:

Quote:

MySQL error: Code: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[42S22]: Column not found: 1054 Unknown column 'balance' in 'field list'' in C:\xampp\htdocs\pot\OTS_Player.php:111 Stack trace: #0 C:\xampp\htdocs\pot\OTS_Player.php(111): PDO->query('SELECT `id`, `n...') #1 C:\xampp\htdocs\pot\OTS_Row_DAO.php(53): OTS_Player->load(1) #2 C:\xampp\htdocs\pot\OTS_Base_List.php(224): OTS_Row_DAO->__construct(1) #3 C:\xampp\htdocs\accountmanagement.php(62): OTS_Base_List->current() #4 C:\xampp\htdocs\index.php(134): include('C:\xampp\htdocs...') #5 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 111 SQLite error: Code: Fatal error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000]: General error: Extraneous additional parameters' in C:\Xampp\htdocs\pot\OTS_SQLite_Results.php:75 Stack trace: #0 C:\Xampp\htdocs\pot\OTS_SQLite_Results.php(75): PDOStatement->fetchAll(0, NULL, NULL) #1 C:\Xampp\htdocs\pot\OTS_Base_List.php(234): OTS_SQLite_Results->fetchAll() #2 C:\Xampp\htdocs\accountmanagement.php(62): OTS_Base_List->rewind() #3 C:\Xampp\htdocs\index.php(134): include('C:\Xampp\htdocs...') #4 {main} thrown in C:\Xampp\htdocs\pot\OTS_SQLite_Results.php on line 75

HOW TO FIX:
It's problem with columns/tables in database.
1. In my post are two versions of acc. maker "..for TFS 0.3" and "..for TFS 0.2.x"
2. If you use TFS 0.2.6 - 0.2.12 server/database use version "..for TFS 0.2.x"
3. If you use TFS 0.3 server/database use version "..for TFS 0.3"
Else you get this error. If you actualized your database from 0.2.x to 0.3 and get this error something is wrong in database.

Thanks.

np,
can i post Distro's?
Acc's?
Map's?
Scripts and where if yes

thanks in advanced

and sorry for not understanding the main point at the begging. just delete off topiced threads

Yours,
Clary