[WoW Emus] Files/Tools/Sofware/Guides/Tutorials and Support

[RazielDarkheart]

I remember reading this when I first started trying to make my WoW server, but is there a way to emulate the Auction House? If so, how could I use that with a repack (like Triplex or Sectorx)?

~RD

 

[causeless]

sectorx repack is a better Mangos server. i m tryed to make my own. but he's bd is better

and sectorx, i wanna help to u for testing, cuz i have a many free time's on my new job ^^

good works and have a fun

 

[RazielDarkheart]

Not exactly an answer to my question...anyone know the answer I seek?

Also, if I switch to Sectorx's repack, is there a way I can move my characters? I don't want to lose all of the stuff I've done thus far. -.-

~RD

 

[sectorx]

Not exactly an answer to my question...anyone know the answer I seek?

Also, if I switch to Sectorx's repack, is there a way I can move my characters? I don't want to lose all of the stuff I've done thus far. -.-

~RD

Yes... Only if you have rev database equal of X-Repack. To solve this, check what updates from x-repack have u installed, then update your current database with sql modifications equal x-repack rev. For example: your server is running rev 3939 and x-repack update 3 is 3992. You need first update your current database to rev 3992 then use my tool from update 3 called MangosBackup to create backup of your realm database and character database. then restore the database to xrepack db. Make a backup first before do this... =) You need install update1, update2 then update3.

However i recommend wait update 4 because will be a full update with new core and fixes...

Update 4 will be out in few hours...

 

[smartretard247]

i too would like to get the auction house up and running, i had a version of mangos that had the auction house working, if i could find the code maybe sectorx could implement... i will start looking just in case.


also, sectorx, the gryphon master 'Gyll' in Booty Bay does not work, he shows as an enemy, possibly bad npc flag? which reminds me, i have a few small db updates i wrote, if you would like them let me know. i am running your server with 23 people so i get a laundry list of issues that i attempt to fix.

 

[sectorx]

smartretard247 I will fix that.

Good news update 4 is ready. i just need upload. im at work in moment, when i arrive home i will upload.

cya...

 

[causeless]

good sound sectorx. i m here too ~ 5 hours too and waiting you :=)
i want first try this update.
and i do it last repack update's ( reinstalled!), update's asking to mysql login info, but don't write this info to .conf file ? this is my failure ?

good works ..

 

[sectorx]

good sound sectorx. i m here too ~ 5 hours too and waiting you :=)
i want first try this update.
and i do it last repack update's ( reinstalled!), update's asking to mysql login info, but don't write this info to .conf file ? this is my failure ?

good works ..

Thx efsanekan71. Answer your question: maybe, but remember every field must be filled. You can't skip any pass after installation. it`s very important configure your mysql info because the application will configure the applications, website and the server in self...

cya

 

[causeless]

update's can be working, installing mysql db and more. that's correct. i filled to mysql connection info at first update. installed other update's and final time i checked my .conf file's. there is say
127.0.0.1;root;root;xrepackdb ... and etc. may my failure. cuz new pc don't have a video card, need a PCIx video card, then so hurding, many applications is working .. (ftp / mail / web / irc servers, anti-virus ... etc ... ) :=)

i m waiting u

 

[RazielDarkheart]

Yes... Only if you have rev database equal of X-Repack. To solve this, check what updates from x-repack have u installed, then update your current database with sql modifications equal x-repack rev. For example: your server is running rev 3939 and x-repack update 3 is 3992. You need first update your current database to rev 3992 then use my tool from update 3 called MangosBackup to create backup of your realm database and character database. then restore the database to xrepack db. Make a backup first before do this... =) You need install update1, update2 then update3.

However i recommend wait update 4 because will be a full update with new core and fixes...

Update 4 will be out in few hours...

I've never used your repack before, because of the enormous download. However, I'm downloading it now (started it yesterday, I'm on part 10/11). I'm using Triplex's repack to play currently, would I be able to backup everything from that and then transfer it to your repack?

Also, can you give a small step-by-step to make your server playable via LAN? No internet tricks, as I don't have internet at home, I just want a few buddies to be able to come over and play with me. ^_^

~RD

 

[causeless]

bro, if db name isn't be xrepackdb then u don't need to backup your current server db. cuz, sectorx repack db name is "xrepackdb" and don't need 2 db, allinone :=)))
and he's server install is very simple, only launch to .exe files and have a fun :=) all is one click xD

 

[RazielDarkheart]

bro, if db name isn't be xrepackdb then u don't need to backup your current server db. cuz, sectorx repack db name is "xrepackdb" and don't need 2 db, allinone :=)))
and he's server install is very simple, only launch to .exe files and have a fun :=) all is one click xD

I was asking about backing up characters because I already have a Level 20 Pally, a few Level 12 alts, and a few others at 10 or less. I don't want to lose all of the progress I've made, so I want to be able to transfer my characters over to the Xrepack. =D

~RD

 

[causeless]

you don't lost your current db's :=) and yes, you can be transfer your current char data to this part. in X-Repack Update 3(don't sure maybe update 2) u can be found a account tools. that's can be help you :=)

 

[xgihavoc]

sectorx, the bug was because i was using psm.. it is a core bug, but other database didn't use large guids, they were corrected in a fix and now everything is fine.. but mangos should fix that large guid in creatures table problem. now make that new release! :smile:

 

[sectorx]

X-Repack Update 4 without vmap (test only)

Here is X-Repack Update 4. This is accumulative update... Read below before install...

Of course, some features:

+ Core 4014
+ Scriptdev 64
+ Many bugs fixed
+ SDB fixed
+ Pet Patch
+ BreathPatch
+ Rogue Patch
+ Duel Fix
+ Deepwounds
+ New Mangos Account Cleaner, Version 0.5
+ New Mangos Backup Tool

and more...

Update Notes:

WARNING!!! This update is only for new X-Repack installation.
You don't need apply updates (1, 2 & 3). This accumulative
update. For better experience is strong recommended re-install
the entire repack.

How to apply update 4:

!!!This is only if already have applied any update!!!

1 - Uninstall x-repack

2 - create a backup of your characters and realm with MangosBackup
included update 3. If not have update 3 get mangos backup at forum.ragezone

3 - Drop xrepack database called 'xrepackdb'. This can be done with mysqladmin
ex: mysqladmin -u root drop xrepackdb -p

4 - Install X-Repack.

5 - Do not install any update.

6 - After the installation of x-repack, install update 4 only.

Link:

To view the content, you need to sign in or register

Later will be uploaded the update with vmap support.

cya...

 

[causeless]

downloading sectorx, i wanna do first try :=)

uninstall and reinstall to X-Repac, omG, need a more time for test :=))

i have a some question (not about X-Repack!)
this is new user register style ;
INSERT INTO `account` (`username`,`I`) VALUES ('username', SHA1(CONCAT(UPPER('username'),':',UPPER('password'))));

i do using a simple account Reg Web Page for use at localnetwork, getting this err --> Fatal error: Call to undefined function CONCAT() in C:\MyWeb\man\index.php on line 474

What's "CONCAT" ? i don't know PHP, need help about this ?
someone can help for this ?

mmm, first time runed server for test. Memory usage very recuded, i like this :=) ~ 114mb using on my machine.
but db still need to upgrade.mean this, look at server.log ;
.......
2007-07-04 12:52:11 >> Loaded 4807 quest relations from creature_questrelation
2007-07-04 12:52:11 ERROR:Table creature_involvedrelation: Quest 8184 listed for entry 15042 not exist.
2007-07-04 12:52:11 ERROR:Table creature_involvedrelation: Quest 9599 listed for entry 17509 not exist.
2007-07-04 12:52:11 ERROR:Table creature_involvedrelation: Quest 11048 listed for entry 21359 not exist.
2007-07-04 12:52:11
....
2007-07-04 12:52:24 >> Loaded 722073 loot definitions
2007-07-04 12:52:24 ERROR:Some items can't be succesfully looted: not exist or have in chance field value < 0.000001 with quest chance ==0 in `creature_loot_template` DB table . List:
loot entry = 18805 item = 30324 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30308 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30283 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30449 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 32267 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29950 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29981 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29951 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29976 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30446 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29972 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29962 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29977 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 32944 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30324 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29948 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30282 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30302 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29924 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29947 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30102 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30107 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30111 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30621 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 32515 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30304 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30282 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30306 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30302 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30283 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30323 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 32405 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30283 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29996 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 32896 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29990 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29995 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29991 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29987 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30306 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29998 mincount = 1 maxcount = 1 (not exist)
.....
2007-07-04 12:52:25
2007-07-04 12:52:25 ERROR:>> Loaded 0 Item Enchantment definitions. DB table `item_enchantment_template` is empty.
2007-07-04 12:52:25 Loading Auctions...
.....
2007-07-04 12:52:26 Initializing Scripts...
2007-07-04 12:52:26 DEBUG:: Initialize game time and timers
2007-07-04 12:52:26 ERROR:SQL: insert into `uptime` (`startstring`, `starttime`, `uptime`) VALUES('2007-07-04 12:52:26', 1183542746, 0)
2007-07-04 12:52:26 ERROR:SQL ERROR: Table 'xrepackdb.uptime' doesn't exist
....

this is a founded deficiency on db. my idea for this ;

i m tryed to Silvermoon DB Rev. 9 with some mangos core (not sectorx Repack!) that's no have a any deficiencys. mean a this, look at server.log ->

2007-07-03 22;59;28 Realm running as realm ID 1
2007-07-03 22;59;28 Using DataDir ./
2007-07-03 22;59;28 Initialize data stores...
2007-07-03 22;59;28
2007-07-03 22;59;28 >> Loaded 35 data stores
2007-07-03 22;59;28
2007-07-03 22;59;28 DBC Locale Does Not Match Config Locale (0)!!!
2007-07-03 22;59;28 Using Autodetected DBC Locale (3).

2007-07-03 22;59;28 Cleaning up instances...
2007-07-03 22;59;29
2007-07-03 22;59;29 >> Initialized 0 instances, deleted 0 old instances
2007-07-03 22;59;29 Packing instances...
2007-07-03 22;59;29
2007-07-03 22;59;29 >> Instance numbers remapped, next instance id is 1
2007-07-03 22;59;29 Loading Game Object Templates...
2007-07-03 22;59;30 >> Loaded 12149 game object templates
2007-07-03 22;59;30
2007-07-03 22;59;30 Loading Spell Chain Data...
2007-07-03 22;59;30
2007-07-03 22;59;30 >> Loaded 1904 spell chain records
2007-07-03 22;59;30 Loading Spell Learn Skills...
2007-07-03 22;59;30
2007-07-03 22;59;30 >> Loaded 45 spell learn skills + found in DBC 74
2007-07-03 22;59;30 Loading Spell Learn Spells...
2007-07-03 22;59;31
2007-07-03 22;59;31 >> Loaded 40 spell learn spells + found in DBC 6009
2007-07-03 22;59;31 Loading Spell Proc Event conditions...
2007-07-03 22;59;31 >> Loaded 839 spell proc event conditions
2007-07-03 22;59;31
2007-07-03 22;59;31 Loading Aggro Spells Definitions...
2007-07-03 22;59;31 >> Loaded 101 aggro generating spells
2007-07-03 22;59;31
2007-07-03 22;59;31 Loading NPC Texts...
2007-07-03 22;59;31
2007-07-03 22;59;31 >> Loaded 3685 npc texts
2007-07-03 22;59;31 Loading Items...
2007-07-03 22;59;44 >> Loaded 21930 item prototypes
2007-07-03 22;59;44
2007-07-03 22;59;44 Loading Page Texts...
2007-07-03 22;59;44 >> Loaded 1276 page texts
2007-07-03 22;59;44
2007-07-03 22;59;44 Loading Item Texts...
2007-07-03 22;59;44
2007-07-03 22;59;44 >> Loaded 5 item texts
2007-07-03 22;59;44 Loading Creature templates...
2007-07-03 22;59;48 >> Loaded 16885 creature definitions
2007-07-03 22;59;48
2007-07-03 22;59;48 Loading Creature Reputation OnKill Data...
2007-07-03 22;59;49
2007-07-03 22;59;49 >> Loaded 947 creature award reputation definitions
2007-07-03 22;59;49 Loading Creature Data...
2007-07-03 22;59;53 >> Loaded 78944 creatures
2007-07-03 22;59;53
2007-07-03 22;59;53 Loading Creature Addon Data...
2007-07-03 23:01:15 >> Loaded 1305 creature addons
2007-07-03 23:01:15
2007-07-03 23:01:15 Loading Creature Respawn Data...
2007-07-03 23:01:17
2007-07-03 23:01:17 >> Loaded 0 creature respawn times.
2007-07-03 23:01:17 Loading Gameobject Data...
2007-07-03 23:01:37 >> Loaded 25925 gameobjects
2007-07-03 23:01:37
2007-07-03 23:01:37 Loading Gameobject Respawn Data...
2007-07-03 23:01:38
2007-07-03 23:01:38 >> Loaded 0 gameobject respawn times.
2007-07-03 23:01:38 Loading Weather Data...
2007-07-03 23:01:39
2007-07-03 23:01:39 >> Loaded 12 weather definitions
2007-07-03 23:01:39 Loading Quests...
2007-07-03 23:01:42
2007-07-03 23:01:42 >> Loaded 6189 quests definitions
2007-07-03 23:01:42 Loading Quests Relations...
2007-07-03 23:01:42
2007-07-03 23:01:42 >> Loaded 258 quest relations from gameobject_questrelation
2007-07-03 23:01:42
2007-07-03 23:01:42 >> Loaded 203 quest relations from gameobject_involvedrelation
2007-07-03 23:01:43
2007-07-03 23:01:43 >> Loaded 5046 quest relations from creature_questrelation
2007-07-03 23:01:43
2007-07-03 23:01:43 >> Loaded 5303 quest relations from creature_involvedrelation
2007-07-03 23:01:43 Loading AreaTrigger definitions...
2007-07-03 23:01:44
2007-07-03 23:01:44 >> Loaded 488 area trigger definitions
2007-07-03 23:01:44 Loading Quest Area Triggers...
2007-07-03 23:01:44
2007-07-03 23:01:44 >> Loaded 25 quest trigger points
2007-07-03 23:01:44 Loading Tavern Area Triggers...
2007-07-03 23:01:44
2007-07-03 23:01:44 >> Loaded 57 tavern triggers
2007-07-03 23:01:44 Loading SpellAffect definitions...
2007-07-03 23:01:44
2007-07-03 23:01:44 >> Loaded 920 spell affect definitions
2007-07-03 23:01:44 Loading player Create Info & Level Stats...
2007-07-03 23:01:45
2007-07-03 23:01:45 >> Loaded 52 player create definitions
2007-07-03 23:01:45
2007-07-03 23:01:45 >> Loaded 385 player create items
2007-07-03 23:01:45
2007-07-03 23:01:45 >> Loaded 1975 player create spells
2007-07-03 23:01:45
2007-07-03 23:01:45 >> Loaded 188 player create skills
2007-07-03 23:01:46
2007-07-03 23:01:46 >> Loaded 280 player create actions
2007-07-03 23:01:46
2007-07-03 23:01:46 >> Loaded 3640 level stats definitions
2007-07-03 23:01:46 Loading Exploration BaseXP Data...
2007-07-03 23:01:46
2007-07-03 23:01:46 >> Loaded 71 BaseXP definitions
2007-07-03 23:01:46 Loading Pet Name Parts...
2007-07-03 23:01:47
2007-07-03 23:01:47 >> Loaded 354 pet name parts
2007-07-03 23:01:47 Loading pet level stats...
2007-07-03 23:01:47
2007-07-03 23:01:47 >> Loaded 560 level pet stats definitions
2007-07-03 23:01:47 Loading Player Corpses...
2007-07-03 23:01:47
2007-07-03 23:01:47 >> Loaded 0 corpses
2007-07-03 23:01:47 Loading Loot Tables...
2007-07-03 23:01:47 creature_loot_template :
2007-07-03 23:02:06
2007-07-03 23:02:06 >> Loaded 585971 loot definitions
2007-07-03 23:02:06 disenchant_loot_template :
2007-07-03 23:02:08
2007-07-03 23:02:08 >> Loaded 17745 loot definitions
2007-07-03 23:02:08 fishing_loot_template :
2007-07-03 23:02:08
2007-07-03 23:02:08 >> Loaded 595 loot definitions
2007-07-03 23:02:08 gameobject_loot_template :
2007-07-03 23:02:09
2007-07-03 23:02:09 >> Loaded 30138 loot definitions
2007-07-03 23:02:09 item_loot_template :
2007-07-03 23:02:10
2007-07-03 23:02:10 >> Loaded 4454 loot definitions
2007-07-03 23:02:10 pickpocketing_loot_template :
2007-07-03 23:02:11
2007-07-03 23:02:11 >> Loaded 10884 loot definitions
2007-07-03 23:02:11 skinning_loot_template :
2007-07-03 23:02:11
2007-07-03 23:02:11 >> Loaded 3586 loot definitions
2007-07-03 23:02:11 prospecting_loot_template :
2007-07-03 23:02:11
2007-07-03 23:02:11 >> Loaded 63 loot definitions
2007-07-03 23:02:11 Loading Item Random Enchantments Table...
2007-07-03 23:02:12
2007-07-03 23:02:12 >> Loaded 28361 Item Enchantment definitions
2007-07-03 23:02:12 Loading Auctions...
2007-07-03 23:02:12 Loading Guilds...
2007-07-03 23:02:12
2007-07-03 23:02:12 >> Loaded 0 guild definitions
2007-07-03 23:02:12 Loading ArenaTeams...
2007-07-03 23:02:12
2007-07-03 23:02:12 >> Loaded 0 arenateam definitions
2007-07-03 23:02:12 Loading Groups..
2007-07-03 23:02:12
2007-07-03 23:02:12 >> Loaded 0 group definitions
2007-07-03 23:02:13 Returning old mails...
2007-07-03 23:02:13 Returning mails current time: hour: 23, minute: 2, second: 13
2007-07-03 23:02:13 Loading Scripts...
2007-07-03 23:02:13 quest_start_scripts :
2007-07-03 23:02:13
2007-07-03 23:02:13 >> Loaded 0 script definitions
2007-07-03 23:02:13 quest_end_scripts :
2007-07-03 23:02:14
2007-07-03 23:02:14 >> Loaded 26 script definitions
2007-07-03 23:02:14 spell_scripts :
2007-07-03 23:02:14
2007-07-03 23:02:14 >> Loaded 42 script definitions
2007-07-03 23:02:14 Initializing Scripts...
2007-07-03 23:02:17 DEBUG:: Initialize game time and timers
2007-07-03 23:02:18 Mail timer set to: 1140, mail return is called every 1440 minutes
2007-07-03 23:02:18 Starting BattleGround System
2007-07-03 23:02:18
2007-07-03 23:02:18 >> Loaded 4 battlegrounds
2007-07-03 23:02:18 Loading Transports...
2007-07-03 23:02:19
2007-07-03 23:02:19 >> Loaded 9 transports
2007-07-03 23:02:19 Deleting expired bans...
2007-07-03 23:02:19 WORLD: Starting Event System
2007-07-03 23:02:19 WORLD: Starting Corpse Handler
2007-07-03 23:02:19 WORLD: World initialized
2007-07-03 23:02:19 mangosd process priority class set to HIGH

...
this point, what can we do, SectorX ? we can combine SDB Rev 9 with u r db ?
But, your release is very good.


(note : i don't tryed on game, only run to server! need a dinner ^^ after can be try on game client:=) )

 

[sectorx]

i have a some question (not about X-Repack!)
this is new user register style ;
INSERT INTO `account` (`username`,`I`) VALUES ('username', SHA1(CONCAT(UPPER('username'),':',UPPER('password'))));

i do using a simple account Reg Web Page for use at localnetwork, getting this err --> Fatal error: Call to undefined function CONCAT() in C:\MyWeb\man\index.php on line 474

What's "CONCAT" ? i don't know PHP, need help about this ?
someone can help for this ?

Concat is custom function that make concatenation. i.e:
username=test
password=@pass

newc = concat(username, password);
newc will be like = teste@pass

Got ?

Abou the log:

Nice! That`s i want... this is update test only... Keen do not post this update yet, because is in test...

cya...

I forgot to ask:

efsanekan71 have u did the steps?


Update Notes:

WARNING!!! This update is only for new X-Repack installation.
You don't need apply updates (1, 2 & 3). This accumulative
update. For better experience is strong recommended re-install
the entire repack.

How to apply update 4:

!!!This is only if already have applied any update!!!

1 - Uninstall x-repack

2 - create a backup of your characters and realm with MangosBackup
included update 3. If not have update 3 get mangos backup at forum.ragezone

3 - Drop xrepack database called 'xrepackdb'. This can be done with mysqladmin
ex: mysqladmin -u root drop xrepackdb -p

4 - Install X-Repack.

5 - Do not install any update.

6 - After the installation of x-repack, install update 4 only.

Because i can`t see error on my server... But i will test again... I will upload the update with vmap support too. There will be 2 updates. One with vmap and other without... I need OK from you guys before update officially this release.

bye...

 

[causeless]

yes, i do it all steps :=) and geted that's err's on server.log file :=)
maybe, db patch isn't be applied ?

and, what's client support ? 2. ???

i found this line's in update/changeset_198fix.sql --->

DROP TABLE IF EXISTS `uptime`;
CREATE TABLE `uptime` (
`starttime` bigint(11) unsigned NOT NULL default '0',
`startstring` varchar(64) NOT NULL default '',
`uptime` bigint(11) unsigned NOT NULL default '0',
PRIMARY KEY (`starttime`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC COMMENT='Uptime system';

but, i don't see this action on db ? and i see a ;
2007-07-04 14:25:53 DEBUG:: Initialize game time and timers
2007-07-04 14:25:53 ERROR:SQL: insert into `uptime` (`startstring`, `starttime`, `uptime`) VALUES('2007-07-04 14:25:53', 1183548353, 0)
2007-07-04 14:25:53 ERROR:SQL ERROR: Table 'xrepackdb.uptime' doesn't exist
in server.log file. this update's do applying on update4 ?







.......{ plusing ... }



i do apply to some line's from changeset_198fix.sql file. and
2007-07-04 12:52:26 DEBUG:: Initialize game time and timers
2007-07-04 12:52:26 ERROR:SQL: insert into `uptime` (`startstring`, `starttime`, `uptime`) VALUES('2007-07-04 12:52:26', 1183542746, 0)
2007-07-04 12:52:26 ERROR:SQL ERROR: Table 'xrepackdb.uptime' doesn't exist

and

2007-07-04 12:52:25
2007-07-04 12:52:25 ERROR:>> Loaded 0 Item Enchantment definitions. DB table `item_enchantment_template` is empty.
2007-07-04 12:52:25 Loading Auctions...

is done now :=) correct and working, need some try for ;

2007-07-04 12:52:11 >> Loaded 4807 quest relations from creature_questrelation
2007-07-04 12:52:11 ERROR:Table creature_involvedrelation: Quest 8184 listed for entry 15042 not exist.
2007-07-04 12:52:11 ERROR:Table creature_involvedrelation: Quest 9599 listed for entry 17509 not exist.
2007-07-04 12:52:11 ERROR:Table creature_involvedrelation: Quest 11048 listed for entry 21359 not exist.
2007-07-04 12:52:11
....
2007-07-04 12:52:24 >> Loaded 722073 loot definitions
2007-07-04 12:52:24 ERROR:Some items can't be succesfully looted: not exist or have in chance field value < 0.000001 with quest chance ==0 in `creature_loot_template` DB table . List:
loot entry = 18805 item = 30324 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30308 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30283 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30449 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 32267 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29950 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29981 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29951 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29976 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 30446 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29972 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29962 mincount = 1 maxcount = 1 (not exist)
loot entry = 18805 item = 29977 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 32944 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30324 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29948 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30282 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 30302 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29924 mincount = 1 maxcount = 1 (not exist)
loot entry = 19514 item = 29947 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30102 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30107 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30111 mincount = 1 maxcount = 1 (not exist)
loot entry = 21212 item = 30621 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 32515 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30304 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30321 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30282 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30306 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30302 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30283 mincount = 1 maxcount = 1 (not exist)
loot entry = 19516 item = 30323 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 32405 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30283 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29996 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 32896 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29990 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29995 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29991 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29987 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30307 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 30306 mincount = 1 maxcount = 1 (not exist)
loot entry = 19622 item = 29998 mincount = 1 maxcount = 1 (not exist)
.....





.......{ plusing ... }

can't fix ... waiting to SectorX ... :/

 

[nickoso]

hey , is there a turitorial or guid for how to make and setting up a wow website ??

edit : i think i found it --->

To view the content, you need to sign in or register

<---- is this the one for making a wow - website for my server ???

 

[kennythekid]

strage errors :|