Search the Community
Showing results for tags 'sql'.
Found 4 results
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. USERNAME PASSWORD ADMINISTRATOR ADMINISTRATOR GAMEMASTER GAMEMASTER MODERATOR MODERATOR PLAYER PLAYER Note : They are not case sensitive when you type them in the game client. > PLEASE... DELETE THESE ACCOUNTS IF THEY ARE NOT NEEDED AFTER YOUR FIRST TESTS ! We recommend that you get rid of these accounts and create your own ones, for obvious security reasons : DELETE FROM `account` WHERE `username` IN ('ADMINISTRATOR', 'GAMEMASTER', 'MODERATOR', 'PLAYER'); If you let them as it is and run a live server... anyone would be able to connect as a GM if you do not change the default passwords.
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, totaltime, leveltime, rest_bonus, logout_time, is_logout_resting, resettalents_cost, resettalents_time, trans_x, trans_y, trans_z, trans_o, transguid, extra_flags, stable_slots, at_login, zone, death_expire_time, taxi_path, arenaPoints, totalHonorPoints, todayHonorPoints, yesterdayHonorPoints, totalKills, todayKills, yesterdayKills, chosenTitle, watchedFaction, drunk, health, power1, power2, power3, power4, power5, exploredZones, equipmentCache, ammoId, knownTitles, actionBars) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ' SQL ERROR: No data supplied for parameters in prepared statement if anyone know how to fix and can comit a fix the core please do so,, thanks for the help,
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 process the information. DBCFilename dbc0_animationdata dbc0_areapoi For the purpose of a demonstration of how to get the field information for a certain table, see the following query. Again we are using the database 'dbc' but this time we are looking for a specific table (dbc0_animationdata) SELECT COLUMN_NAME,ORDINAL_POSITION,DATA_TYPE,COLUMN_TYPE FROM information_schema.columns WHERE table_schema = 'dbc' AND table_name = 'dbc0_animationdata%' This returns the following: "COLUMN_NAME" "ORDINAL_POSITION" "DATA_TYPE" "COLUMN_TYPE" "AnimationDataId" "1" "int" "int(11)" "Name" "2" "text" "text" "WeaponFlags" "3" "int" "int(11)" "Bodyflags" "4" "int" "int(11)" "Flags" "5" "int" "int(11)" "FallbackAnimationDataId" "6" "int" "int(11)" "PreviousAnimationDataId" "7" "int" "int(11)" For the guts of the data we need, this is everything we need... until next time