FeRkEl

not working

u use the ahbot_new branch?

and have set your config informations in the ahbot.conf file?

else pls more informations....

old config

you need

AuctionHouseBot.ItemsPerCycle.Boost = 1000

AuctionHouseBot.ItemsPerCycle.Normal = 20

After more than 10h the memory usage didn't change with more than 65000 item in auction DB.

I repeat i am waiting for any other feedback from anyone of you When the code will be under_review i will be probably too busy with optimising and making integration succefull to the core.

is there anywhere an overview about the features ? and how it will be handled?

e.g. wiki or github/rep/wiki?

would be nice.

my bad i couldn't follow your changes in last time and first post isn't from you so there i can't find a full feature list.

i remember an feature request about ignore item list or something similar

best regards

will you check if random creature name exists as playername?

otherwise it would be confusing :-)

We can't use uptime table because, with the actual system, it update the row, and remove the last value.

And insert a new row in uptime table at each time is stupid.

It's not "live" data, it's to have a collection of values to make graphs or tables.

jeah i actually know that, but infact you could make a switch, so u can decide if you want just latest /highest data or those of all 5mins

i think fregah meant that you should make an extra field into the uptime table and could change with config setting if you'll insert all X minutes the current count (max count since last ?) or just update as before....

so you don't need another table and more flexible ...

just one tipp use the [ u r l ][ / u r l ] tags :-)

There's I believe already existing code for this that could be improved, not much people know about it - "uptime" table in "realmd" database. It seems to log the maximum number of players each 10 minutes (default), though the column name might be misleading.

You could modify it to log the "current" number of players instead of "max reached so far". I guess that could even be accepted to master.

öhm but it updates the table till server crashs and doesn't insert new rows...

handled in : /game/World.cpp

ty,mangos for your promt reply

I think the problem was that my mangos was 10553 3.3.5 and I was

extracting 3.3.5a dbc and maps so it was not happy with the db

because it was expecting a 3.3.5 db structure.

idk because I need to change my wow to 3.3.5 to test this.

how can I find out the wow version needed from the mangos

core release number.

tree

3.3.5a is right client version,

it seems more that you need to patch your MySQL Database

tha table db_version tells you what was the latest SQL patch applied...

MfG

  case 4:
      player->ADD_GOSSIP_ITEM( 0, player->GetLatestNews()[0], GOSSIP_SENDER_SERVER_MENU, 3);
      player->ADD_GOSSIP_ITEM( 0, player->GetLatestNews()[1], GOSSIP_SENDER_SERVER_MENU, 3);
      player->ADD_GOSSIP_ITEM( 0, player->GetLatestNews()[2], GOSSIP_SENDER_SERVER_MENU, 3);
      break;

what do you want to do here?

you will access element 0 1 and 2 from an array? but you'll return just one const char* (res[3]) in your function?

you execute the function 3 times (don't know if it even works!) , it would better to save return value localy and access the returned array )

const char* GetLatestNews() {
  QueryResult* result = SiteDatabase.PQuery("SELECT user, title, message FROM news ORDER BY date DESC LIMIT 1");
  Field *fields = result->Fetch();
  const char *res[3] =
   {
   fields[0].GetString(), fields[1].GetString(), fields[2].GetString()
   };

  return res[3];
}

WHAT IS THE PROBLEM?

C++ CANT EVEN READ ARRAYS LOL

error LNK2019: unresolved external symbol "public: char const * __thiscall Player::GetLatestNews(void)" (?GetLatestNews@Player@@QAEPBDXZ) referenced in function "void __cdecl SendServerMenu(class Player *,class Creature *,unsigned int)" (?SendServerMenu@@YAXPAVPlayer@@PAVCreature@@I@Z)
1>..\\..\\..\\..\\bin\\win32_release/MaNGOSScript.dll : fatal error LNK1120: 1 unresolved externals

It's a problem of architecture. The OS don't have importance. A processor 32 bits don't support more than 4GB of memory because 2^32 = 4GB.

http://en.wikipedia.org/wiki/Physical_Address_Extension

also not every 32 bit OS supports 4GB of Memory

edit:easiest way would be to upgrade your debian to 64 bit version :-)

any custom patches? revision 1300+ is to unspecific, afaik mangos has revision above 1570 so your mangos is more than 200 revisions old...

DB version + Script revision?

just place an ; after ($result)

yeah that works, now a full php script

<?PHP
require_once ( 'config.php');

mysql_connect ("$host","$user","$pass");
mysql_select_db ("$mangoscharacters");

$result = mysql_query (" insert here the working SQL Query ");

$row = mysql_fetch_array($result)
print_r($row);

?>

you can change the print_r($row) with something like echo "GMs online: ".$row['count'] ; // 'count' is the column name!!!!

i just changed an existing statement and for the old forum it wouldn't interefer :-)

SELECT count(*) FROM characters WHERE online = 1 and account in(select id from realmd.account where gmlevel >0);

whee syntax highlighting again

Though the colors...maybe it's just me, but blue and purple on dark grey is almost unreadable here...

/sign

a brighter red would be better too ( although its almost readable)

hmm would be nice if the login requirement for some subforums come back... so i would see if im still loged in :-)

another nice feature was "who's reading the topic atm" and the XX thanks in YY posts :-)

The way I think it can be done (I'm no script genius), is to add a second filter to this line:-

$result = mysql_query ("SELECT name, race, class, level, map, gender FROM characters WHERE online = 1");

Something like $result = mysql_query ("SELECT name, race, class, level, map, gender FROM characters WHERE online = 1 AND Realmd/Tables/Account GMlevel >0");

Hopefully someone will...um..adjust my attempt

think this should work:

.....

$result = mysql_query ("SELECT name, race, class, level, map, gender FROM characters WHERE online = 1[/b] and accid in([color=blue]select accid from realmd where gmlevel >0)[/color];

not tested

it has nothing todo with PHP just SQL

not working, and the another tips dont work too ( i need only a number, how many gms are online or not )

i'm not sure of the columns/table spelling, so pls verify for using this sql statement in your PHP

.....

$result = mysql_query ("SELECT count(*) FROM characters WHERE online = 1[/b] and account in([color=blue]select id from realmd.account where gmlevel >0)[/color];

maybe QueryHandler.cpp at line 437

               if (pl)

change into

if (!pl)
   continue;
else

but i'm still to unadvanced in reading crashlogs ... maybe its a totaly different problem

level 4 to show all 3 players.. not just on

the problem is you show 1 player not 1 per gm level

you haven't any loop in the script...

Mfg

try this:

                                  <?PHP
require_once ( 'config.php');

mysql_connect ("$host","$user","$pass");
mysql_select_db ("$mangoscharacters");

$result = mysql_query ("SELECT name FROM characters WHERE account IN (SELECT id FROM $mangosrealm.account WHERE gmlevel > 3 ORDER BY NAME)");

while( $row = mysql_fetch_array($result))
{
 $t_name = $row['name'];
   echo "[b]<span style='color: #B00000'>$t_name[/b]</span>";
}

?>   

Heya

who can help me with a GM online check ( online check, if online a gm on my server )

regards

Betaman

The way I think it can be done (I'm no script genius), is to add a second filter to this line:-

$result = mysql_query ("SELECT name, race, class, level, map, gender FROM characters WHERE online = 1");

Something like $result = mysql_query ("SELECT name, race, class, level, map, gender FROM characters WHERE online = 1 AND Realmd/Tables/Account GMlevel >0");

Hopefully someone will...um..adjust my attempt

think this should work:

.....

$result = mysql_query ("SELECT name, race, class, level, map, gender FROM characters WHERE online = 1[/b] and accid in([color=blue]select accid from realmd where gmlevel >0)[/color];

not tested

it has nothing todo with PHP just SQL

client is the BF CLuster?

and Server will later be mangos ( yet its your mangosFX?)

or do you mean client = WoWclient?

where can i track source code changes?

is there an git repo?

sounds interessting, would like to track the progress :-)

Hmm i take the topic with my real nickname because DJNefast doesn't work anymore since forum update' date=' strange thing...[/quote']

u have to resend your PW ( maybe mail will go to spam ordner) i had to "reactivate" my acc ,too

No FeRkEl, it's about instance bindings.

whats than the point with

encounterIndex