Recent content by kkk111

Use SQL -> INNER JOIN SELECT `p`.`name` AS "Player Name", `h`.`id` AS "House ID", `ha`.`id` AS "Winner ID" from `house_auctions` AS `ha` INNER JOIN `players` AS `p` ON `p`.`id` = `ha`.`winner_id` INNER JOIN `houses` AS `h` ON `h`.`owner_id` = `ha`.`house_id` WHERE `ha`.`winner_id` = 2

"client debugs after 2,147,483,647 exp"

pos = getCreaturePosition(cid) doSendMagicEffect({x=pos.x, y=pos.y, z=pos.z}, CONST_ME_TELEPORT)

Test........ <?PHP $order = 0; $number_of_rows = 0; $Sql_Query = $SQL->query('SELECT level,name,online FROM players WHERE `group_id` < 3 AND players.deleted = 0 AND name != "Account Manager" ORDER BY level DESC, experience DESC LIMIT 10;')...

use sql to update; change on red; UPDATE accounts SET name='myaccount', password = SHA1('mypassword');

post your script isPremium(cid)

I made a simple adjustment that should work, if you want something better inform all fields of guildwinner table, and the way the system works (it updates the existing record?, it inserts new records?, it deletes the old records?) ** This mode will show all records from the table guildwinner...

You do not know to resize a table?

Use rare items...... Warlord Sword Amazon Shield Blessed Shield Solar Axe Amazon Armor Dragon Scale Legs

root/home/otsmanager/otserver/config.lua

are using router? check if your port is open -- port 80 http://www.checkmyports.net/ http://www.yougetsignal.com/tools/open-ports/

because function onLogin(cid), and not function onKill(cid, target)?

check version src/definitions.h and re-compile #define CLIENT_VERSION_MIN 1021 #define CLIENT_VERSION_MAX 1022 #define CLIENT_VERSION_STR "10.22" and addMonster problem open map-spawn.xml with notepad++ find all line <monster name="" and remove full line

localhost work? set firewall off

you not compiled with -D__WAR_SYSTEM__