Betaman2k

is the last version better ( faster ) ?

yeah thx mysql 100 % load, wipes my chars, nice ops i see one error what is wrong ERROR 1146 (42S02): Table 'chars.account' doesn't exist i used this sql script on my char DB, is that wrong ?

yeah iam very interesting on a sql script but works for the latest core too ?

i try on console ( telnet ) no effect no delete chars

this comamnd dont work .character deleted old 180 ( ingame ) i check the table from my mysql all ok, very strange this bug or wrong command ? but sql script is the best way, i think regards betaman2k

hmmm accounts delete too ? i try ingame with this command .character deleted old 180 he sayed this command not avaible only list and restore

Heya who can make me a Sql script for this function ( latest mangos core ) I wanna cleanup all accounts & chars & guilds and gabage data files ( spells,bags etc ) from X day example cleaunp start from 15.02.2010 ( all chars + accounts etc are protected after 15.02.2010, from 14.02.2010 - 14.02.2009 are wiped all datas ) i hope u understand me and i hope the great community can help me with the sql script for the latest core regards betaman

yeah but now the problem i wanna get on one realm a GM status, the another realm no gm status and what do u mean with that comment and related realmd DB. ?

Heya who can help me i have 2 cores, 2 World DB´s, 2 Charaters now my problem 1 Realm ( mysql realmd, two realmlist ) with 2 world dbs and 2 charaters dbs works all good, ! Now i wanna get 2 Realms ( accounts on 2 realms different ) with 2 world dbs and 2 charaaters dbs First config mangosd.conf RealmID = 1 DataDir = "/opt/emu/335/" LogsDir = "" LoginDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;realmd1" WorldDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;world1" CharacterDatabaseInfo = "127.0.0.1;3306;mangos;xxxxx;chars1" MaxPingTime = 30 WorldServerPort = 8085 BindIP = "0.0.0.0" ------------------------------------ First config realmd.config LoginDatabaseInfo = "127.0.0.1;3306;mangos;xxxxx;realmd1" LogsDir = "" MaxPingTime = 30 RealmServerPort = 3724 ------------------------------------- -------------------------------------- Second config mangosd.conf RealmID = 2 DataDir = "/opt/emu/335/" LogsDir = "" LoginDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;realmd2" WorldDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;world2" CharacterDatabaseInfo = "127.0.0.1;3306;mangos;xxxxx;chars2" MaxPingTime = 30 WorldServerPort = 8086 BindIP = "0.0.0.0" -------------------------------------- Second config realmd.config LoginDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;realmd2" LogsDir = "" MaxPingTime = 30 RealmServerPort = 3725 Now my problem second realm invisble, but running, nobody can connected on the second realm, only the first if i change this on Second config mangosd.conf RealmID = 2 DataDir = "/opt/emu/335/" LogsDir = "" LoginDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;realmd1" WorldDatabaseInfo = "127.0.0.1;3306;mangos;xxxx;world2" CharacterDatabaseInfo = "127.0.0.1;3306;mangos;xxxxx;chars2" MaxPingTime = 30 WorldServerPort = 8086 BindIP = "0.0.0.0" and kill the Second config realmd.config and start all new without the second config realmd.config ( works all fine, but use ONLY one realmd1, all game account for 2 realms, i wanna get 2 games accounts realms ) i hope u understand me regards betaman

but T10 2P broken

ok now works fine all but i get 20 % on my chars this debug error ERROR [26-11-2010 19:25:10]: Characters::BuildCharacter : player 38434 (XXXX) does not have any data in `armory_character_stats` table (SQL update to Characters DB was not applied? / Character was not saved in game? / Server core was not patched?) any idea what is wrong, 80 % all good with my chars on the arsenal

now works all fine but only this problem i see no items on my chars ( all items are emty ) but tooltip works good on the empty items on the chars ( get all infos from the items ) i see no icons, on talent tree no icons too but tooltips works any idea to fixed ?

oh i need a new rev from the mango core ? or what do u mean ?

iam using the latest armory from u 416 mangos core: 10777 all patches for the core and sql included ( recompiled too ) I can see the arena team,items etc but all my chars away dunno why i can search a char, works fine i see the name, icon,guild etc if i click the char name i get this message The character has been inactive... The character name has been spelled incorrectly... The profile is temporarily unavaible because of faction change or realm change... character has been deleted... i hope u can help me, and i dont know, where is the debug log ( is true in config file )

all buggy m8, is not good buggy source to used why u used this buggy ACE ? http://packages.qa.debian.org/a/ace.html

Linux debian dont support 5.8.2 latest release from debian 5.7.7.4

iam using the branch from rsa ( including the ahbot from u )

not working

Hmmm not working for me dunno why Core: 10632 2010-10-20 14:30:29 Initialize AuctionHouseBot... 2010-10-20 14:30:30 AuctionHouseBot loading progress: 2010-10-20 14:30:30 loaded 9 grey trade goods 2010-10-20 14:30:30 loaded 556 white trade goods 2010-10-20 14:30:30 loaded 87 green trade goods 2010-10-20 14:30:30 loaded 43 blue trade goods 2010-10-20 14:30:30 loaded 10 purple trade goods 2010-10-20 14:30:30 loaded 2 orange trade goods 2010-10-20 14:30:30 loaded 0 yellow trade goods 2010-10-20 14:30:30 loaded 1309 grey items 2010-10-20 14:30:30 loaded 3933 white items 2010-10-20 14:30:30 loaded 8432 green items 2010-10-20 14:30:30 loaded 4888 blue items 2010-10-20 14:30:30 loaded 2702 purple items 2010-10-20 14:30:30 loaded 14 orange items 2010-10-20 14:30:30 loaded 3 yellow items my config AuctionHouseBot.EnableSeller = 1 AuctionHouseBot.EnableBuyer = 0 AuctionHouseBot.Account = 26534 AuctionHouseBot.GUID = 82276 AuctionHouseBot.VendorItems = 1 AuctionHouseBot.LootItems = 1 AuctionHouseBot.OtherItems = 1 AuctionHouseBot.No_Bind = 1 AuctionHouseBot.Bind_When_Picked_Up = 1 AuctionHouseBot.Bind_When_Equipped = 1 AuctionHouseBot.Bind_When_Use = 1 AuctionHouseBot.Bind_Quest_Item = 1 AuctionHouseBot.ItemsPerCycle = 400 AuctionHouseBot.UseBuyPriceForSeller = 1 AuctionHouseBot.UseBuyPriceForBuyer = 0 AuctionHouseBot.MaxItemLevel = 200 i get no items on my AH, dunno why i hope u can help me, what is wrong thx

yeah thx, i love u, big thx m8 and thx 4 the explain, now iam smarter

ok i used now that mysql_select_db($mangoscharacters, $conn) or die('Select DB failed: ' . mysql_error()); $result = mysql_query ("SELECT count(*) FROM characters WHERE online = 1 AND account IN (SELECT id FROM realmd.account WHERE gmlevel >0)"); $row = mysql_fetch_array($result); echo "GMs online: ".$row; now no error nothing but i get only this message on my HP GMs online: Array Array ??

i changed without effect same error Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in line 2 line 2: $row = mysql_fetch_array($result);

nope Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result

yeah thx but not working $result = mysql_query ("SELECT count(*) FROM characters WHERE online = 1 AND account IN(SELECT id FROM realmd.account WHERE gmlevel >0"); $row = mysql_fetch_array($result) echo "GMs online: ".$row; Parse error: syntax error, unexpected T_ECHO

yeah that works, now a full php script