UNNAMED acc. maker 0.3.2 beta for TFS

[Cayzon]

I get this when I'm trying to add the tables to MySQL

SQL-fråga:

ALTER TABLE `z_shop_history_item` CHANGE `offer_id` `offer_id` VARCHAR( 255 ) NOT NULL ;



MySQL sa:

#1146 - Table 'realdeal.z_shop_history_item' doesn't exist

Could someone please help me?

 

[Cayzon]

The link for 0.2x is not working, could you fix it please?

 

[krankthefunk]

When i created character, Everything works fine but i get this error even thought the character Created.

Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1832 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(703): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1832\

 

[richux]

I don't know if this is right thread to post, but ill try ;p I realy want to add command in talkactions "!changesex"(characters can change their gender) but i have no idea how to script it :S I searched all around and couldnt find any script, maybe some1 has the gender change sscript?
Thanks.

 

[krankthefunk]

its not but

function onSay(cid, words, param)
player = getCreaturePosition(cid)
if doPlayerRemoveMoney(cid, 100000) == TRUE then
if getPlayerSex(cid) == 0 then
doPlayerSetSex(cid, 1)
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have changed to a guy.")
else
doPlayerSetSex(cid, 0)
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You have changed to a girl.")
end
else
doPlayerSendTextMessage(cid, MESSAGE_INFO_DESCR, "You need 100,000 gold coins to change your sex.")
doSendMagicEffect(getPlayerPosition(cid), CONST_ME_POFF)
end

end

 

[Hpnotiq]

Im geting this FATAL ERROR when im on step 4. what can it be?:s


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

"Fatal error: Call to a member function query() on a non-object in C:\xampp\htdocs\install.php on line 394"

And here is the code

$check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch();


thx
Hpnotiq

 

[Ask3n]

What is this? can someone help me?

STEP 4
Add samples to DB:

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

and the line is

$check_news_ticker = $SQL->query('SELECT * FROM z_news_tickers WHERE image_id = 1 AND author = 1 AND hide_ticker = 0 LIMIT 1 OFFSET 0')->fetch();

 

[Le Kriss]

Mmm nice, but where is Admin panel i see just News system and Load configuration (load monsters/spells)

 

[Vean]

@up
Now all these functions are configurable in config/config.php file

 

[Le Kriss]

Ok, i will check it.
@edit
now gesior.pl... you destroyed it completle... wtf wrong with you and that config.php ? now i cant change alot of things, witch i can change in older v.???

 

[krankthefunk]

I've try to fix it but i still get this fatal error


Fatal error: Uncaught exception 'E_OTS_NotLoaded' in C:\xampp\htdocs\pot\OTS_Player.php:1832 Stack trace: #0 C:\xampp\htdocs\accountmanagement.php(703): OTS_Player->getSkill(0) #1 C:\xampp\htdocs\index.php(130): include('C:\xampp\htdocs...') #2 {main} thrown in C:\xampp\htdocs\pot\OTS_Player.php on line 1832\

 

[myndgames]

Still looking for help with my errors...

http://otland.net/f118/unnamed-acc-maker-0-3-2-beta-forgotten-server-12954/index46.html#post181247

 

[vakacjus]

Set Admin Account

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

Can some one fix it??. How to pass admin password??

 

[Ask3n]

here is working link to gesior aac to server based on TFS 0.2
Gesior acc. maker 0.3.0 for TFS 0.2.x.rar

 

[Shurtugal]

UNNAMED acc. maker 0.3.2 beta is setting wrong temple position. My true temple is x:459, y:165, z:7. When i'm creating new character, he is on x:455, y:158, z:7. Fix it please. On older version i didn't have this problem.

 

[Deamon]

@UP:
Your bad.
Login into your database and fix this.
In Sorcerer Sample, Druid Sample... change spawn position and town_id.
that's all.

 

[Gesior.pl]

UNNAMED acc. maker 0.3.2 beta is setting wrong temple position. My true temple is x:459, y:165, z:7. When i'm creating new character, he is on x:455, y:158, z:7. Fix it please. On older version i didn't have this problem.

New version don't copy spawn position/town id. Now you can set town_id (1 = auto select, more then 1 = player select) in config/config.php

 

[Rudixx]

About Ban info. In real Tibia Website it looks like that:

Account Information
Name: Gesior
Location: Norway
Banished: until Jan 02 2009, 16:46:15 CET because of account trading or sharing
Created: Jul 18 2005, 22:11:15 CEST

So if you could fix it, will be nice.

    if($player->getCustomField("hide_char") != 1) {
                //account info
                $main_content .= '<br><TABLE BORDER=0><TR><TD></TD></TR></TABLE><TABLE BORDER=0 CELLSPACING=1 CELLPADDING=4 WIDTH=100%><TR BGCOLOR='.$config['site']['vdarkborder'].'><TD COLSPAN=2 CLASS=white><B>Account Information</B></TD></TR><TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%>Real name:</TD><TD>'.$account->getCustomField("rlname").'</TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=20%>Location:</TD><TD>'.$account->getCustomField("location").'</TD></TR>';
                
                

    if($account->isBanned())
        if($account->getBanTime() > 0) {
                //account info
                $main_content .= '<TR BGCOLOR='.$config['site']['lightborder'].'><TD WIDTH=20%><font color="red">Banished:</font></TD><TD><font color="red">until '.date("F j Y, G:i", $account->getBanTime()).' CEST</font></TD></TR><TR BGCOLOR='.$config['site']['darkborder'].'><TD WIDTH=20%>Created:</TD><TD>'.date("j F Y, g:i a", $account->getCustomField("created")).'</TD></TR></TABLE>';
        }

But you could add reason as well.

 

[richux]

Hello guys! My Ot just got hacked! :s The hacker said that ipchanger that i downloaded contained an trojan, but i rescanned it with my antivirus, and my friends scanned it too and we didnt found any viruses :S And i wonder why.... Maybe its because im using gesiors acc manager? Cuz i read that it can be hacked in some way, is that true, or lies?

 

[Hermes]

@up
Maybe you haven't set password for phpMyAdmin?