Search the Community
Showing results for tags 'sql'.
Hi there, I am writing this little article about default accounts in MaNGOS and how to deal with them. > WHAT ARE DEFAULT ACCOUNTS ? Default accounts are accounts created in the account table of the auth DB when you have a fresh install : After a fresh install you will get those 4 default accounts that allow you to connect directly to your realm in order to make quick tests. > HOW CAN YOU USE THEM ? As you can see you have only encrypted password in DB but the scheme is easy : all passwords are equal to the account name. USERNA
hey all i ahve frechly pulled source on mangos one, not costum stuff nothing deleted everything and installed the db 2 times. but when i try to amke a character ingame i get this serror was not there before something it broke. what to do? SQL ERROR: mysql_stmt_bind_param() failed SQL ERROR: Using unsupported buffer type: 436770736 (parameter: 3) SQL: can not execute 'INSERT INTO characters (guid,account,name,race,class,gender,level,xp,money,playerBytes,playerBytes2,playerFlags,map, dungeon_difficulty, position_x, position_y, position_z, orientation, taximask, online, cinematic, to
Hi, I cloned Server repo from github and started to build mangos from scratch. When I run the script 'server/sql/mangos.sql', mysql return the following error: I looked into the script and figured out the insert statement line 1327 for creature_template table. The table has 84 columns but the insert statement provide 85 values.
Now that we have a majority of the data already in the Database, we now need to work out how to get meaningful information back out ! Thankfully MySQL does provide us with a way of doing this. In the following example my main database containing the DBC data and we are going to query for records for MangosZero - so tables beginning dbc0_ SELECT DISTINCT TABLE_NAME AS DBCFilename FROM information_schema.columns WHERE table_schema = 'dbc' AND table_name LIKE 'dbc0_%' This returns a nice list of DBC filenames belonging to Zero, we can easily write a tool to read through that list and