Tak je konec

[RoXY 0]

Dyspro ty si sa tiez sekol na Navicat patchovani?

Edited October 10, 2006 by RoXY

[Dyspro 0]

nn ja som to neskusal ja som len cital a nasiel som nieco

 

nasiel som nieco o characteroch neviem co vam to pomoze

 

http://wowguilds.be/upload/characters.sql

 

 

mno niekto na nejakom fore napisal toto :

 

CREATE TABLE `characters` (

`guid` bigint(20) unsigned NOT NULL default '0',

`acct` bigint(20) unsigned NOT NULL default '0',

`data` longtext NOT NULL,

`indepData` longtext NOT NULL,

`name` varchar(21) NOT NULL default '',

`level` int(10) unsigned NOT NULL default '0',

`class` int(10) unsigned NOT NULL default '0',

`race` 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',

`mapId` int(10) unsigned NOT NULL default '0',

`zoneId` int(10) unsigned NOT NULL default '0',

`orientation` float NOT NULL default '0',

`taximask` longtext NOT NULL,

`outfit` longtext NOT NULL,

`reputation` float NOT NULL default '0',

`skills` longtext NOT NULL,

`taxiX` float NOT NULL default '0',

`taxiY` float NOT NULL default '0',

`taxiZ` float NOT NULL default '0',

`unlearn_count` int(11) NOT NULL default '0',

`transportGuid` bigint(32) unsigned NOT NULL default '0',

`stableSlots` tinyint(4) unsigned NOT NULL default '0',

`enumFlag` int(10) unsigned NOT NULL default '0',

`resurrectionLoc` text NOT NULL,

`instanceId` int(10) unsigned NOT NULL default '0',

PRIMARY KEY (`guid`)

) ENGINE=MyISAM DEFAULT CHARSET=iso-8859-2;

 

 

Use that, it 100% works.

Edited October 10, 2006 by Dyspro

[RoXY 0]

nasiel som nieco o characteroch neviem co vam to pomoze

 

http://wowguilds.be/upload/characters.sql

 

Mno to je presne ten chybny retazec, s ktorym to nece vytvarat postavy

 

EDIT: mno uz tu mame 3 typy "spravnych" patchov hod sem plz racej link na to forum, mozno tam bude popis ako to patchnut

Edited October 10, 2006 by RoXY

[Dyspro 0]

http://emupedia.com/forums/showthread.php?t=2016

, treba sa tam registrovat preto som tu nedaval odkaz na forum ale len veci napisane tam

Edited October 10, 2006 by Dyspro

[ProDuctiF 0]

invisiblikovi to ide takto

/*
MySQL Data Transfer
Source Host: 127.0.0.1
Source Database: kobolod
Target Host: 127.0.0.1
Target Database: kobolod
Date: 10/8/2006 11:20:20 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
`guid` bigint(20) unsigned NOT NULL default '0',
`acct` bigint(20) unsigned NOT NULL default '0',
`data` longtext NOT NULL,
`indepData` longtext NOT NULL,
`name` varchar(21) NOT NULL default '',
`level` int(10) unsigned NOT NULL default '0',
`class` int(10) unsigned NOT NULL default '0',
`race` 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',
`mapId` int(10) unsigned NOT NULL default '0',
`zoneId` int(10) unsigned NOT NULL default '0',
`orientation` float NOT NULL default '0',
`taximask` longtext NOT NULL,
`outfit` longtext NOT NULL,
`reputation` bigint(20) unsigned NOT NULL default '0',
`skills` longtext NOT NULL,
`taxiX` float NOT NULL default '0',
`taxiY` float NOT NULL default '0',
`taxiZ` float NOT NULL default '0',
`unlearn_count` int(11) NOT NULL default '0',
`transportGuid` bigint(32) unsigned NOT NULL default '0',
`stableSlots` tinyint(4) unsigned NOT NULL default '0',
`enumFlag` int(10) unsigned NOT NULL default '0',
`resurrectionLoc` text NOT NULL,
`instanceId` int(10) unsigned NOT NULL default '0',
PRIMARY KEY (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

(podla toho co napisal )

[RoXY 0]

Fix for broken character creation:

hxxp://wowguilds.be/upload/characters.sql

 

Just delete your old characters table and replace with that.

 

to "Just delete your old characters table and replace with that." toto si tu mal pastnut

[Dyspro 0]

njn srry

[Maser 0]

Mno to je presne ten chybny retazec, s ktorym to nece vytvarat postavy

 

EDIT: mno uz tu mame 3 typy "spravnych" patchov hod sem plz racej link na to forum, mozno tam bude popis ako to patchnut

 

otevri si notepad, vloz do nej ten spravny retezec, uloz trebas pod jmenem patch.sql ....

 

odevri navicat, smaz v databazi tabulku characters, pote odklepni databazi pravym cudlem a dej "execute BATCH file" a najdi ten patch.sql... to ti vytvori spravnou verzi tybulky characters a postavy pudou normalne vytvaret i ukladat...

 

pro jistotu i ten spravny kod (alespon me to takhle funguje) :

/*
MySQL Data Transfer
Source Host: localhost
Source Database: wow_server
Target Host: localhost
Target Database: wow_server
Date: 10/8/2006 11:20:20 AM
*/

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for characters
-- ----------------------------
CREATE TABLE `characters` (
  `guid` bigint(20) unsigned NOT NULL default '0',
  `acct` bigint(20) unsigned NOT NULL default '0',
  `data` longtext NOT NULL,
  `indepData` longtext NOT NULL,
  `name` varchar(21) NOT NULL default '',
  `level` int(10) unsigned NOT NULL default '0',
  `class` int(10) unsigned NOT NULL default '0',
  `race` 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',
  `mapId` int(10) unsigned NOT NULL default '0',
  `zoneId` int(10) unsigned NOT NULL default '0',
  `orientation` float NOT NULL default '0',
  `taximask` longtext NOT NULL,
  `outfit` longtext NOT NULL,
  `reputation` bigint(20) unsigned NOT NULL default '0',
  `skills` longtext NOT NULL,
  `taxiX` float NOT NULL default '0',
  `taxiY` float NOT NULL default '0',
  `taxiZ` float NOT NULL default '0',
  `unlearn_count` int(11) NOT NULL default '0',
  `transportGuid` bigint(32) unsigned NOT NULL default '0',
  `stableSlots` tinyint(4) unsigned NOT NULL default '0',
  `enumFlag` int(10) unsigned NOT NULL default '0',
  `resurrectionLoc` text NOT NULL,
  `instanceId` int(10) unsigned NOT NULL default '0',
  PRIMARY KEY  (`guid`)
) ENGINE=MyISAM DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records
-- ----------------------------

[RoXY 0]

Mno nahradil som to.. ale teraz ma to nenapoji na realm vzdy DC, a pise ze preto lebo v realme nevie najst Realm selection asi...

Inac aj vas to niekedy Disconnectuje? lebo mna dost casto

 

Uz to nacitalo aj realm cize v poho.. fakt nice emul.. zatial

Si fakt super MASER diq za help

 

Akoze skuste si ROGUA .. fakt brutal.. krasa

Edited October 10, 2006 by RoXY

[Patrik 0]

za chvilku vam sem upnu moji wow_server.sql uz funkcni:) diky PSpad:)

 

 

tak tady heslo je =lotr

 

ZDE

Edited October 10, 2006 by Patrik

[ibanez 0]

helejte a ou vam dobre tvorit ty acc? me ne, i kdybych se pos*al tak nevytvorim novej acc....

[RoXY 0]

Napisal tam navod Maser asi 3 prispevky dozadu.

 

BTW prisiel nekto uz na tie spawny a go?

Edited October 10, 2006 by RoXY

[ibanez 0]

rofl delani postav ve hre mi nedela problemy, jen ty za**** acc....tamto sem opravil uz rano...

[Maser 0]

Problém s accountama je ve špatně udělaný tabulce accounts...

 

Já se mto vyřešil, tak že jsem patchnul databazi timhle :

 

alter table accounts modify s text NOT NULL default '';
alter table accounts modify v text NOT NULL default '';
alter table accounts modify sessionkey text NOT NULL default ''; 

 

tim se odstrani problem s default hodnotama, kvuli kterejm neslo accounty vytvorit... a hle uz to jede :-)

 

a co se týče té poslední části readme :

 

Server is supplied with empty World in MySQL, to import it from world_spawns.txt and world_gameobj.txt
enter the Game through WoW client onto your Server. Being GM, use GM command:

.import wo

to import World creatures, and then:

.import gameobj

to import Gameobjects

For reference to supported GM commands type:

.commands

5) Restart server after World is imported.

6) Have fun !

2006, Kobol Team.

 

udělal sem to takhle :

 

Now to do this here are the steps:
1) go to your tools folder [KoboldServerLite\Tools]

2) copy the WoWEmuSCPtoSQLConverter.exe

3) Use any other emu for instance lets say UWC 1.3.x

4) paste WoWEmuSCPtoSQLConverter.exe in the scripts folder [uwc1.4.3/scripts]

5) then go to the saves folder in the uwc and copy the world.save [uwc1.3.4/saves]

6) paste the world.save in your scripts folder [uwc1.4.3/scripts]

7) execute the WoWEmuSCPtoSQLConverter.exe.
[NOTE: This will create a folder sql with .txt files in it]

8) open the sql folder and copy all the contents [uwc1.4.3/scripts/sql]

9) paste them to your WS folder in the Kobold Repack [KoboldServerLite\WS]
[NOTE: do NOT copy the sql folder itself copy the .txt files inside they need to be directly in the WS folder]

10) ingame run the commands .import wo and .import gameobj
[NOTE: after running the gameobj the server will auto restart most the time so run it last]

11) restart and enjoy a now populated repack

(also their is no guaranty any of this works correctly as I have found even pulling these scripts I got about 70% of my world from my UWC emu server meaning nearly half the mobs are still missing. However most of them and gameobjects got added)

 

mno a hned je ten svet plnejsi... jediny co mi jeste dost citelne chybi sou treneri... a ludmila ma zrejme krapet jinak souradnice, jelikoz vas to obcas portne do textur a nektery objekty/creepy jsou taky spatne umisteny... ale to snad pude opravit :-)

[ProDuctiF 0]

Napisal tam navod Maser asi 3 prispevky dozadu.

 

BTW prisiel nekto uz na tie spawny a go?

par prispevkov dozadu, tam DAL FLASH CELU a FUNKCNU DB, tak si ju stiahnite a skuste. Su TAM AJ SPAWNY, OBJEKTY aj TRAINERY, jednoducho vsetko

 

tu JE

heslo je "lotr"

 

este raz, tuto DB tu dal Patrick (Flash)

Edited October 11, 2006 by ProDuctiF

[RoXY 0]

Neviem ako vam ale mne sa to velmi paci az na tych par buglych equipov, napr stit ktory ma davat +6 all resistance a dava 65 a ale spelly si myslim ze idu dost dobre.. neviem ci je to aj u vas ale mna mage trainer napr uci aj ranky 1 talentovych spellov, to je dost bug velmi s ami paci funkcnost channelingov, dalej super idu druidove premeny aj aquatic a moonklin form ktore funguju fakt super.(az na ten bugly maul, bez cd), dalej funkcnost totemov je fakt super, idu skoro setky okrem 2 asi(aj weapon spelly ako windfury idu super, taktiez water walking sila...) krasne vytvara porty u maga , u rogua je dost blbe ze ked dam stun ako kidney shot taksa po udere zrusi, alebo ked dam gouge tak aj ked sa postavim za NPC nemozem dat backstab, inac dual wield sa naucte pomocou .modify skill 118 a dual ide ako ma s weaponami som dal uz crit cez 1000 .. krasa povolania ako enchanting tiez fachcia date nasea+5 health prida to 5 health, da sa to dat iba na bracers anpr ked to mate napisane v enahnte, honorove veci na ktore nemate skil sa nedaju dat naseba, taksito ani veci pre inu classu...tie nove talenty u maga shamana rogua su tez super... clearcasting z talentov tiez fachci... dalej veci ako Far Sight , kliknete niekde do dialky a akoby ste boli na tom mieste tez shamanove kuzlo.. a co ma prekvapilo najviac bolo to ze ide MIND CONTROL !!!! Setky hunterove Aspecty idu, Eagle eye ide, tame beast + setko s petom funguje !!! Eye of the Beast funguje, prevtelite sa do svojho zvieratka a behate s nim po mapke ! Beast lore ide, da sakrmit zvieratko .. FUNGUJE DOKONCA FEIGN DEATH.. urobite sa na 6 minut mrtvy.... HUNTER FUNGUJE SKORO 100% .. taktiez fear a ine typy.. hrac uteka nestoji na mieste.. sila proste .ked to bude stabilne ako tu uz nekto pisal ze 50 pplz=150 laetncy tak si myslim ze to UWC pochova...

Edited October 11, 2006 by RoXY

[ibanez 0]

mno ta db oukej, le nepridala mi jedinej spawn...le acc uz mam ready....dikes masere...

[pc-maniak 4]

mam takovy mensi problem s tim ,,WoWEmuSCPtoSQLConverter" ,pise mi nejaky error ze nejde pustit .. nemate nekdo nejaky funkcni pls ?

[ProDuctiF 0]

mno ta db oukej, le nepridala mi jedinej spawn...le acc uz mam ready....dikes masere...

 

mohol by si mi tu upnut tabulku accounts? prosim ja mam s tym problem nemozem to patchnut pls daj ju sem

 

btw: na tomto emu sa mi nepaci ze npc vo vode neplavu ale skackaju :D , na mangose to uz je vyriesene

Edited October 12, 2006 by ProDuctiF

[Maser 0]

par prispevkov dozadu, tam DAL FLASH CELU a FUNKCNU DB, tak si ju stiahnite a skuste. Su TAM AJ SPAWNY, OBJEKTY aj TRAINERY, jednoducho vsetko

 

tu JE

heslo je "lotr"

 

este raz, tuto DB tu dal Patrick (Flash)

 

 

je to jen zakladni databaze... bez spawnu, tak jak se kazdymu vytvori, kdyz dodrzi postup.... tak nas tady nepleť

[ProDuctiF 0]

je to jen zakladni databaze... bez spawnu, tak jak se kazdymu vytvori, kdyz dodrzi postup.... tak nas tady nepleť

mam ho na icq a tu databazu mi posielal a spawny tam su

[Maser 0]

mam ho na icq a tu databazu mi posielal a spawny tam su

 

hmmm tak to nevim co sem v tom pirapade stahnul... (neupladnul na ten server neco jinyho nez poslal tobe?)

 

pac ja kdyz sem si ji zkusil soupnout do ludmily, tak sem mel databazi ve stavu jako kdyz sem to cesrstve nainstaloval + mozna par malych uprav... tzn. 99% spawnu se nekonalo... totez co psal ibanez...

Edited October 12, 2006 by Maser

[AchiLLeS 0]

a ja som cel ist na offic

 

idem sa do toho pustit tak ak tak napisem a dufam, ze pomozete

[Maser 0]

mno tak sem si trochu pohral s scp od UWC a ejhle trenery a dalsi chybejici npc uz mam :-) (UWC ma rozhazeny creatures do vicero souboru.... je potreba je spojit do jednoho creatures.scp)

 

jediny co me este dost trapi je nastaveni GO... spousta veci je blbe umistena (cedule, shcranky, atd. se valej po zemi) a nebo se blbe pohybujou (vytahy u Thunder Bluffu - neda se snima vyjet nahoru pac jezdej uplne jinam).... ale snad to pude nak rozumne upravit... pokud jo, tak uz to bude pouzitelny :-)

 

 

[AchiLLeS 0]

ja som si tiez stahol tu db od patrika a spawny tam niesu... asi tak ako povedal maser