-=((Ascent rev 2270 !! / NCDB 640! ))=-

[Patrik 0]

vyresen ten problem s tema postavama?

 

[Gurundix 0]

vyresen ten problem s tema postavama?

to by me zajimalo co s tim mate,,,tohle je struktura charu na 2243 core up ..od core 2272_character_playeritems.sql uprava a tu pak musite pozit pozdeji + dalsi fixy

DROP TABLE IF EXISTS `characters`;

CREATE TABLE `characters` (
  `guid` int(10) unsigned NOT NULL,
  `acct` int(10) unsigned NOT NULL,
  `name` varchar(21) COLLATE utf8_unicode_ci NOT NULL,
  `race` tinyint(3) unsigned NOT NULL,
  `class` tinyint(3) unsigned NOT NULL,
  `gender` tinyint(3) unsigned NOT NULL,
  `custom_faction` int(10) unsigned NOT NULL DEFAULT '0',
  `level` tinyint(3) unsigned NOT NULL,
  `xp` int(10) unsigned NOT NULL,
  `exploration_data` longtext COLLATE utf8_unicode_ci NOT NULL,
  `skills` longtext COLLATE utf8_unicode_ci NOT NULL,
  `watched_faction_index` int(10) unsigned NOT NULL DEFAULT '0',
  `selected_pvp_title` int(10) unsigned NOT NULL DEFAULT '0',
  `available_pvp_titles` int(10) unsigned NOT NULL DEFAULT '0',
  `gold` int(10) unsigned NOT NULL DEFAULT '0',
  `ammo_id` int(10) unsigned NOT NULL DEFAULT '0',
  `available_prof_points` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `available_talent_points` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `current_hp` int(10) unsigned NOT NULL DEFAULT '0',
  `current_power` int(10) unsigned NOT NULL DEFAULT '0',
  `pvprank` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bytes` int(10) unsigned NOT NULL DEFAULT '0',
  `bytes2` int(10) unsigned NOT NULL DEFAULT '0',
  `player_flags` int(10) unsigned NOT NULL DEFAULT '0',
  `player_bytes` int(10) unsigned NOT NULL DEFAULT '0',
  `positionX` float NOT NULL DEFAULT '0',
  `positionY` float NOT NULL DEFAULT '0',
  `positionZ` float NOT NULL DEFAULT '0',
  `orientation` float NOT NULL DEFAULT '0',
  `mapId` int(10) unsigned NOT NULL DEFAULT '0',
  `zoneId` int(10) unsigned NOT NULL DEFAULT '0',
  `taximask` longtext COLLATE utf8_unicode_ci NOT NULL,
  `banned` int(40) NOT NULL,
  `banReason` varchar(50) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `timestamp` int(10) unsigned NOT NULL DEFAULT '0',
  `online` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `bindpositionX` float NOT NULL DEFAULT '0',
  `bindpositionY` float NOT NULL DEFAULT '0',
  `bindpositionZ` float NOT NULL DEFAULT '0',
  `bindmapId` int(10) unsigned NOT NULL DEFAULT '0',
  `bindzoneId` int(10) unsigned NOT NULL DEFAULT '0',
  `isResting` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `restState` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `restTime` int(10) unsigned NOT NULL DEFAULT '0',
  `playedtime` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deathstate` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `TalentResetTimes` int(10) unsigned NOT NULL DEFAULT '0',
  `first_login` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `forced_rename_pending` tinyint(3) unsigned NOT NULL DEFAULT '0',
  `publicNote` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `officerNote` varchar(32) COLLATE utf8_unicode_ci NOT NULL DEFAULT '',
  `guildid` int(10) unsigned NOT NULL DEFAULT '0',
  `guildRank` int(10) unsigned NOT NULL DEFAULT '0',
  `arenaPoints` int(10) unsigned NOT NULL DEFAULT '0',
  `totalstableslots` int(10) unsigned NOT NULL DEFAULT '0',
  `instance_id` int(10) unsigned NOT NULL DEFAULT '0',
  `entrypointmap` int(10) unsigned NOT NULL DEFAULT '0',
  `entrypointx` float NOT NULL DEFAULT '0',
  `entrypointy` float NOT NULL DEFAULT '0',
  `entrypointz` float NOT NULL DEFAULT '0',
  `entrypointo` float NOT NULL DEFAULT '0',
  `entrypointinstance` int(10) unsigned NOT NULL DEFAULT '0',
  `taxi_path` int(10) unsigned NOT NULL DEFAULT '0',
  `taxi_lastnode` int(10) unsigned NOT NULL DEFAULT '0',
  `taxi_mountid` int(10) unsigned NOT NULL DEFAULT '0',
  `transporter` int(10) unsigned NOT NULL DEFAULT '0',
  `transporter_xdiff` float NOT NULL DEFAULT '0',
  `transporter_ydiff` float NOT NULL DEFAULT '0',
  `transporter_zdiff` float NOT NULL DEFAULT '0',
  `spells` longtext COLLATE utf8_unicode_ci NOT NULL,
  `deleted_spells` longtext COLLATE utf8_unicode_ci NOT NULL,
  `reputation` longtext COLLATE utf8_unicode_ci NOT NULL,
  `actions` longtext COLLATE utf8_unicode_ci NOT NULL,
  `auras` longtext COLLATE utf8_unicode_ci NOT NULL,
  `finished_quests` longtext COLLATE utf8_unicode_ci NOT NULL,
  `honorPointsToAdd` int(11) NOT NULL,
  `killsToday` int(10) unsigned NOT NULL DEFAULT '0',
  `killsYesterday` int(10) unsigned NOT NULL DEFAULT '0',
  `killsLifeTime` int(10) unsigned NOT NULL DEFAULT '0',
  `honorToday` int(10) unsigned NOT NULL DEFAULT '0',
  `honorYesterday` int(10) unsigned NOT NULL DEFAULT '0',
  `honorPoints` int(10) unsigned NOT NULL DEFAULT '0',
  `difficulty` int(10) unsigned NOT NULL DEFAULT '0',
  PRIMARY KEY (`guid`),
  KEY `acct` (`acct`),
  KEY `guildid` (`guildid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci COMMENT='Characters';

[zaradas 0]

zdar ldi, mam problem, chci na servr dat patch 2.3 ale hlasi mi to chybu viz obrazek . Prosím odpovědi pište na [email protected]

[Dead F. Angel 21]

nemas aktualizovanu DB , pohladaj si na ascent fore fixy (od Wally)

[sadam 0]

Chtěl bych se zeptat jak je možný to když tu stahnu revizi 2270 a k tomu je tam daný link na contabilni databazi tak kdyz to pak spustim ascent exe tak mi to tam červeně píše že chybí jaké mapy.bin ale slozku maps tam mam. kde to vemu?

[zaradas 0]

Dead F. Angel posledni dotaz, ridil sem se navodem na ktery si me odkazal, uz vim jak si aktualizovat databazi ale ma to svoje ALE, nevim kde mam sehnat souboor .patch nebo .diff, chci si servr aktualizovat z 2.2.3 na 2.3, plz porad/te.

[Dead F. Angel 21]

to neni ono , to su sql sobory , on tam ma oba napisane co sa ma hodit do sql suboru a potom executnut

[miki999 0]

nemusis na ascent fore setjy fixi mas pri mojich reviziach a pojde ti aj 2.3.0

[honibrko 0]

cau pls mohly by jste my poradit já mám rev.2404 a píše my to tuto chybu http://uhonibrka.wgz.cz/screny-gmu já sem neumim dát scren sem tak sem to dal na svojí stránku pls poradte

Edited November 22, 2007 by honibrko

[miki999 0]

nahraj si do DB setky sql updaty co boli pri revizii 2404 okrem dvoch ted nvm ktore su to ked sosnem alsiu reviziu ti poviem

 

EDIT : okrem 1919world_item_randomprop_groups a 1919world_item_randomsuffix_groups

Edited November 22, 2007 by miki999

[honibrko 0]

miki999 to nefachá

 

 

Edited November 22, 2007 by honibrko

[honibrko 0]

nahraj si do DB setky sql updaty co boli pri revizii 2404 okrem dvoch ted nvm ktore su to ked sosnem alsiu reviziu ti poviem

 

EDIT : okrem 1919world_item_randomprop_groups a 1919world_item_randomsuffix_groups

 

 

miki999 me to nejde to nahraju a pořád my to píše

[miki999 0]

no mne to jede v poho http://img215.imageshack.us/my.php?image=2404xi9.jpg nvm skus dat novsiu DB a do nej dat tie updaty

[honibrko 0]

já mám databázi dev_mexis_wow, 2.3.0_enUS_DBC, rev.2406-new tvoje ,ale jako fakt nevim

 

u ostatních uploadu .sql když dávám do navicatu tak tam mám třeba ascent."ten sql"

tak vim že to mám dát v navicatu do ascentu

 

ale u toho co my to píše tak tam nic nemám jen to v tom červenym

Edited November 23, 2007 by honibrko

[honibrko 0]

supr už sem to viřešil, ale ted mám problém zase z postavama mám je nahatý a fakt nevim co stim jesli tam chybí sql nebo do concoly neco napsal fakt nevim pls poradte

[miki999 0]

skus si nahrat daky update

[Gurundix 0]

skus si nahrat daky update

Kdo neni blbej..vi kde ma hledat

 

http://eu.blizzard.com/support/article.xml?articleId=19465&categoryId=