MrSheen
Php & Lua.
RE: TheForgottenServer v0.2.3!
So how do you just use the normal database?
So how do you just use the normal database?
g++ -I. -I/usr/include/libxml2 -I/usr/include/mysql -I/usr/include/boost/regex -I/usr/include/lua5.1 -D__CONSOLE__ -D__NO_HOMEDIR_CONF__ -D__USE_MYSQL__ -Werror -O2 -c account.cpp
make: g++: Command not found
make: *** [account.o] Error 127
Nexoz said:When i tried to upload forgotten.sql
Mysql error:
#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'IF EXISTS `oncreate_players`' at line 1
Any solution =p=p?
Talaturen said:Can be because you don't have the required level to use the weapon.
Jonte said:Ah okey, can I change this? Levels for weapons.
Jonte said:I have a new problem, when someone tries to buy premium account, it doesnt work.
And in console:
SQL ERROR DBResult::GetDataInt<> warnings
>> MYSQL ERROR mysql_real_query: UPDATE 'accounts set 'premdays' = 5, 'warnings' = 0, 'last day' = 0 WHERE 'id' = 140979 LIMIT 1 Unknown column 'warnings' in 'field list'
Jonte said:also you can sell infinite of items doing this:
put 2 things (same item) in your backpack
say
hi
sell mace
yes
sell mace
yes
sell mace
yes
sell mace
etc
you will get your money, but he wont remove the maces.
im not 100% it works like this, it might be cause the bp is full or something
Talaturen said:Jonte said:Ah okey, can I change this? Levels for weapons.
weapons.xml
Jonte said:I have a new problem, when someone tries to buy premium account, it doesnt work.
And in console:
SQL ERROR DBResult::GetDataInt<> warnings
>> MYSQL ERROR mysql_real_query: UPDATE 'accounts set 'premdays' = 5, 'warnings' = 0, 'last day' = 0 WHERE 'id' = 140979 LIMIT 1 Unknown column 'warnings' in 'field list'
you didn't execute the sql queries from 0.2.1 -> 0.2.2 update that was in changelog.txt
Jonte said:also you can sell infinite of items doing this:
put 2 things (same item) in your backpack
say
hi
sell mace
yes
sell mace
yes
sell mace
yes
sell mace
etc
you will get your money, but he wont remove the maces.
im not 100% it works like this, it might be cause the bp is full or something
i'll take a look at this.
Talaturen said:Yes, but you have to do the same with the things in changelog of 0.2.1 -> 0.2.2,
well here's the query to fix that:
ALTER TABLE `accounts` ADD `warnings` INT NOT NULL DEFAULT 0;
g++ -I. -I/usr/include/libxml2 -I/usr/include/mysql -I/usr/include/boost/regex -I/usr/include/lua5.1 -D__CONSOLE__ -D__NO_HOMEDIR_CONF__ -D__USE_MYSQL__ -Werror -O2 -o ./TheForgottenServer account.o actions.o admin.o allocator.o ban.o baseevents.o creatureevent.o chat.o combat.o commands.o condition.o configmanager.o container.o creature.o cylinder.o database.o databasemysql.o databasesqlite.o depot.o fileloader.o game.o gui.o house.o housetile.o ioguild.o iologindata.o iomap.o iomapserialize.o inputbox.o item.o items.o logger.o luascript.o mailbox.o map.o md5.o monster.o monsters.o movement.o networkmessage.o npc.o otserv.o outfit.o player.o playerbox.o position.o protocol.o protocol80.o quests.o raids.o rsa.o scheduler.o scriptmanager.o spawn.o spells.o status.o talkaction.o tasks.o teleport.o textlogger.o thing.o tile.o tools.o trashholder.o vocation.o waitlist.o weapons.o -L/usr/lib -lxml2 -lpthread -llua5.1 -lboost_thread -lgmp -lmysqlclient -lboost_regex -ldl
/usr/lib/gcc/i586-suse-linux/4.1.2/../../../../i586-suse-linux/bin/ld: cannot find -llua5.1
collect2: ld returned 1 exit status
make: *** [theforgottenserver] Error 1
/home/server # ./TheForgottenServer
./TheForgottenServer: error while loading shared libraries: liblua5.1.so.0: cannot open shared object file: No such file or directory
Talaturen said:It's something wrong in the NPC system, not in the server, so you'll have to contact Jiddo who wrote the NPC System or write the NPC the old way, and I've not had time to look at it yet.