brunogcar

i can assure u, its upper user/pass, just look at mangos source its clear

if u cant figure it out, in a couple of days when i check out forum again, i will provide a working example that u can easily get either from read source or any 3rd party project, from memory try something like

SET sha_pass_hash=SHA1(CONCAT(UPPER('$username'),':',UPPER('$pass'))), v=0, s=0

hint minimanager has got it right, same as dozens of other projects, i cant name now cos im drunk

how hard is it to add some if conditions to as schomoozerd said exp-gains rate in mangos code?

Joubarbe, klyxmaster, darkfr3ak and others

its good to see interest on playerbot but honestly instead of complaining (bug report) all the time, u guys should try to learn and contribute a little bit

most of items on Joubarbe list are actually easy to accomplish, blueboy is just one guys he has his TODO list, try to help him instead of add more to it

b4 you start to bitch me, ive done my share to mangos community, too bad when blueboy started i was losing interest in wow, cos i could have helped way more than i did

not being able to code isnt an excuse, start with small modifications and as you get more comfortable with code mangos/playerbot u will be able to what ever you want, belive me ive done that starting from zero coding skills and finished able to do almost anything i wanted related to core/db/script/webpage

bluebot keep up with the outstanding work you´ve been doing, even thought i dont test it anymore, i regularly check source to see what u do

i wish some mangos dev add playerbot to master as debug feature to reward all the effort u´ve put into it.

i´ve seen ALL mangos 3rd party projects, as i was a member since 2005 and have to say that along with ahbot and mangchat you have brought playerbot to a level that exceed what blizzard have planned to this game, kudos to you

he is asking for slash command /pass to set password for channel as example, not gm command .password

its been long i dont work with mangos source and ive never have seen someone deal with with slash commands per acc access, so not sure and dont know if its possible, but my best guess would be channelhandler.cpp or chathandler.cpp, whatever file is named, good luck restricting client expected behavior

no problems compiling with mandriva 64 and debian 64(mangos zero+sd2 zero), way too diferent distros, so its got to be something on your end dude

there isnt such table spell_disabled in mangos db - https://github.com/mangos/mangos/blob/master/sql/mangos.sql

therefore there wont be any wiki info about it

that is a trinity feature i guess

search around and you might find a patch to port it to mangos

use common sense

if sd2 updates and if is there sql files, update it

if udb or any other db u use, update, apply it

if acid updates, do the same

mangos provide db structure and sql updates are mandatory

everything else is just content, not really NEEDED to run server

indeed buddy

mistake on original conf file and laziness causing that file to be copied to other boxes as i have same same sql user on all boxes, so i wouldnt have to edit conf files multiple times, prevented me to see what was wrong

i knew it had to be someting trivial i had overlooked, silly me after 5 years doing that and few months away i manage to do such noob mistake

thanks a lot for your help

following derex post i got output

[bruno@localhost bin]$ ./gdb-mangosd
terminate called after throwing an instance of 'std::out_of_range'
 what():  basic_string::at
warning: can't find linker symbol for virtual table for `std::basic_string<char, std::char_traits<char>, std::allocator<char> >' value
warning:   found `std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_Rep::_S_empty_rep_storage' instead
warning: can't find linker symbol for virtual table for `std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_Alloc_hider' value
warning:   found `std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_Rep::_S_empty_rep_storage' instead
warning: can't find linker symbol for virtual table for `std::basic_string<char, std::char_traits<char>, std::allocator<char> >' value
warning:   found `std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_Rep::_S_empty_rep_storage' instead
warning: can't find linker symbol for virtual table for `std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_Alloc_hider' value
warning:   found `std::basic_string<char, std::char_traits<char>, std::allocator<char> >::_Rep::_S_empty_rep_storage' instead

and complete backtrace on log http://pastebin.com/6QMMnQmx

im not at home so i just tested with my notebook with mandriva 2010.2 32 bits atm

after a short absence, tried mangos again with 3 different boxes

dual core 32 with mandriva 2010.2

core 2 quad with debian 5.0.8 lenny

i7 930 with debian 6.0 squeeze

all with identical results despite diferent versions of ace, cmake, mysql, gcc, etc of each distro

searched around and havent found any result like my prob, so i guess im doing something wrong

tried with and with out sd2, built in and external ace, full updated udb and plain default mangos db, etc i get exactly same results on all boxes

./realmd runs ok

mangosd.conf has default values besides db settings

am i missing something? any clues?

[bruno@localhost bin]$ ./mangosd
MaNGOS/ (* * Revision 11213 - 9a43b5ec0f4c51e20917b4b9994cb3705240bd83) for Linux_x32 (little-endian) [world-daemon]
<Ctrl-C> to stop.


MM   MM         MM   MM  MMMMM   MMMM   MMMMM
MM   MM         MM   MM MMM MMM MM  MM MMM MMM
MMM MMM         MMM  MM MMM MMM MM  MM MMM
MM M MM         MMMM MM MMM     MM  MM  MMM
MM M MM  MMMMM  MM MMMM MMM     MM  MM   MMM
MM M MM M   MMM MM  MMM MMMMMMM MM  MM    MMM
MM   MM     MMM MM   MM MM  MMM MM  MM     MMM
MM   MM MMMMMMM MM   MM MMM MMM MM  MM MMM MMM
MM   MM MM  MMM MM   MM  MMMMMM  MMMM   MMMMM
       MM  MMM [url]http://getmangos.eu[/url]
       MMMMMM


Using configuration file /home/bruno/wow/compiled/etc/mangosd.conf.
OpenSSL 1.0.0a 1 Jun 2010 (Library: OpenSSL 1.0.0a 1 Jun 2010)
Using ACE: 5.7.2
World Database: 127.0.0.1;3306;***;***;mangos, total connections: 2
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.55
MySQL server ver: 5.1.55 
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.55
MySQL server ver: 5.1.55 
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
[0 ms] SQL: SELECT required_11205_01_mangos_spell_proc_event FROM db_version LIMIT 1
Character Database: 127.0.0.1;3306;***;***;characters, total connections: 2
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.55
MySQL server ver: 5.1.55 
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.55
MySQL server ver: 5.1.55 
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[1 ms] SQL: SET CHARACTER SET `utf8`
[0 ms] SQL: SELECT required_11117_02_characters_world FROM character_db_version LIMIT 1
Login Database: 127.0.0.1;3306;***;***;realmd, total connections: 2
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.55
MySQL server ver: 5.1.55 
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
Connected to MySQL database at 127.0.0.1
MySQL client library: 5.1.55
MySQL server ver: 5.1.55 
AUTOCOMMIT SUCCESSFULLY SET TO 1
[0 ms] SQL: SET NAMES `utf8`
[0 ms] SQL: SET CHARACTER SET `utf8`
[1 ms] SQL: SELECT required_10008_01_realmd_realmd_db_version FROM realmd_db_version LIMIT 1
Realm running as realm ID 1
[1 ms] SQL: UPDATE account SET active_realm_id = 0 WHERE active_realm_id = '1'
[0 ms] SQL: UPDATE characters SET online = 0 WHERE online<>0
[1 ms] SQL: UPDATE character_battleground_data SET instance_id = 0
[0 ms] SQL: SELECT version, creature_ai_version, cache_id FROM db_version LIMIT 1mike
Using World DB: UDB 0.12.1 (398) for MaNGOS 11156 with SD2 SQL for rev. 1976
Using creature EventAI: ACID 3.0.8 - Full Release for Mangos (3.3.5a Client)
[0 ms] SQL: UPDATE realmlist SET allowedSecurityLevel = '0' WHERE id = '1'
terminate called after throwing an instance of 'std::out_of_range'
 what():  basic_string::at
Aborted

playerbot uses its own config file nowadays

http://github.com/blueboy/portal/blob/master/src/game/playerbot/playerbot.conf.dist.in

set on mangosd.conf instead DB just display server option in this case

take a look at smartymangos svn http://svn2.assembla.com/svn/smartymangos

its an old abandoned project, but has phpbb integrated, with functions u guys are implementing and many more like forum acc syncing with existing game acc and vice versa, etc

its possible that u can find some usefull info

indeed what i said isnt true anymore, used to be, just tested to make sure,

i havent been following mangos closely lately, but if nothing changed mangos (if i remember correctly thats how client send username) still expect usernames to be stored in uppercase

Check your inbox

RA isnt just slow, but allows just 1 conenction per time

USERNAME must be UPPERCASE both in db and on your script

Why the sudden decision to move Playerbot to an entirely different forum site?

So now this means I now have to go register at yet another forum?

If it means you feel one of the two best low-pop core mods will have more contributions from other developers and playerbot will actually improve far more, then so be it. However, there's nothing stopping those potential contributors from participating here, either.

It seems Playerbot was doing just fine here and has enjoyed the best possible exposure, something I'm not so sure it will have elsewhere. Since every single MaNGOS server admin/developer comes here first, it makes more sense you'd want Playerbot right up front where it can be easily found instead of surfing all over the place to find it.

Once this thread dies off as the majority of activity shifts over to the new thread, you'll start seeing people posting here asking things like:

• * "Can someone update this for the latest mangos?"
  * "Is this project dead?"
  * "Whatever happened to playerbot?"
  

It is your baby now, blueboy, and you can do as you wish.

I'm not too keen on the idea, but that's just my opinion.

with 1 topic development is too limited, suggestions, bug report, errors, general discussion, etc simultaneously also making really hard to search for specific point and keep track of everything

simple patches can sustain dev like that, but larger projects just cant, imagine if sd2 or udb had just one topic, yea u can say they are not supported by mangos, neither is playerbot

sd2 started small, with basic guard scripts and look how far it got, with organization and contribuitors to support its growth

up to you or anyone to register there, but mangos forums is to discuss mangos and mangos does not support 3rd party projects so if u really want to help and support its recommended to use specific forums

u can say, its my forum so i want to promote it, but truth is i gain nothing from it, i dont advertise my server there, rules there are pretty much the same as here and im just trying to help providing better grounds to continue development of playerbot than it will ever have here, on just one thread

i still think that new thread here with info on first post is more than required, since collinsp is gone and this topic has 49 pages, much of it totally unrelated to what playerbot is nowadays, would just need to add link to playerbot forum, git adresses, instructions and link this old topic for historical reference

unified patch = diff

u dont have to tell to search for and replace/add/remove

files move and split config have been discussed on topic http://mangos.osh.nu/forums/index.php?showtopic=1143

i made some suggestions, but didnt finish it yet and wont have time to complete it today, so if ppl is interested, take a look and help improve it

and yea its time to create new thread to playerbot and include all info on 1st post blueboy as previous playerbot devs are long gone

@EARTHWALKER

read again error

$ git apply Addon/AHBot/ahbot.patch
Addon/AHBot/ahbot.patch:3526: trailing whitespace.

error: README.AHBOT: already exists in working directory
error: sql/characters_auctionhousebot.sql: already exists in working directory
error: sql/characters_auctionhousebot_update.sql: already exists in working dire
ctory
error: src/game/AuctionHouseBot.cpp: already exists in working directory
error: src/game/AuctionHouseBot.h: already exists in working directory

its clear that u didnt apply patch over clean mangos,

for gods sake just use git instead of dealing with patch, as u clearly have problems with it

u can do it either by the way xeross tells in first post

git clone git://github.com/xeross/mangos.git ahbot
cd ahbot
git checkout -b ahbot origin/ahbot

or

git clone git://github.com/mangos/mangos.git
cd mangos
git pull git://github.com/xeross/mangos.git ahbot

try to use UPPERCASE username, mangos expect usernames to be like that on DB as well

$username = 'DARKMESSIAH';

instead of

$username = 'darkmessiah';

git merge conflict algo is way better than svn, making it way less painful to update or mantain a branch or local repo

but in cases like mangchat and ahbot modifying exactly same lines on files, u will get conflicts, thats expected, but its really easy in vast majority of cases to simply edit file and fix it, u dont need any cpp skills to solve that kind of problem, simply ability to read and understand what conflicted

now we get to the point that ppl is expected to at least read and understand basic git functionalities

after editing files u must let git know of what u did, otherwise it will compare files from last hash to newest one that u are trying to checkout

simply execute

git add .

git commit -m 'description of what u did'

xeross over fixed it

there was a typo on ChrRacesEntryfmt[] which was messing with factions, i explained to him in details and what was the fix, but he over did it, reverting ChrClassesEntryfmt[] and changing CharTitlesEntryfmt[]

use this DBCfmt.h - http://filebeam.com/a335f93949fefe6084b207bccb226990 and u will be all set

ofc it does, Mangchat is an integrated IRC client for MaNGOS, i didnt say it was server

client needs to connect to some server, then ppl on irc and on wow will be able to chat

u can use freenode, etc if u dont want to install own irc server

at least check mangchat.conf and u will have a better idea of its features

latest svn revision supports 2.4.3 if im not mistaken

its been over an year mangos uses git, and it has source for 3.2.2a

darky an shot explanation of Mangchat is an integrated IRC client for MaNGOS, irclient inside mangos to be able to have simple chat between wow and irc and connecting the channels of multiple mangos and irc servers in one network having "cross-server chat" and also the possibility to execute simple gm commands

@xeross155 or anyone maintaining mangchat branch

with [8789] Rename several singleton macros to use more consistent names

IRCCmd.cpp and IRCCmde.cpp need to be updated: objmgr -> sObjectMgr