Guild icon
ProjectSkyFire
General / general
Forum https://www.projectskyfire.org/ | Wiki https://wiki.projectskyfire.org/ | Source https://github.com/ProjectSkyfire/SkyFire_548 | Database located in forum. Must make an account to download.
Avatar
First?
Avatar
Second?
Avatar
Discord revamp??
Avatar
Fourth?
Avatar
What the... ? You erased the channel or what happened here? 😄🤔
Avatar
Jalenor Nefzen 12-Sep-21 05:51 PM
Is it possible to move procedures from one db to another in heidi? I solved making a new db, moving tables and re-importing the procedures, but wanted to know if is possible to move procedures directly
Avatar
procedures arent part of the db it self you dont need to import them with the tool if you dont like to have them
18:25
but how i would do it i would generate a procedure creation and then delete a procedure and apply the creation query where i want it to be (edited)
18:27
and if you dont want to import them at all just delete the procs folder in main_db folder
Avatar
Jalenor Nefzen 12-Sep-21 06:57 PM
ok, thank you
Avatar
Jalenor Nefzen 13-Sep-21 12:56 PM
extracting the maps
12:56
gives error for all those maps related to the siege of orgrimmar and related transport
12:56
I'm ignoring and proceeding, assuming this is normal
12:56
as the guide is also up for cataclysm version and not pandaria
12:57
I guess it is possible to intervene on the maps later on
Avatar
yes its normal type 2 maps and transport maps should not be extracted
Avatar
Jalenor Nefzen 13-Sep-21 01:14 PM
ok
13:15
what about this
13:15
Avatar
create a folder vmaps
13:16
and then run the assembler
Avatar
Jalenor Nefzen 13-Sep-21 01:16 PM
vmaps exists and is filled with buildings content (edited)
Avatar
the order is
13:16
mapextractor->vmapextractor which extracts buildings
13:17
then you create vmaps folder and generate vmaps with assembler which merges buildings models and vmaps together
13:17
then you run mmap extractor
Avatar
Jalenor Nefzen 13-Sep-21 01:18 PM
yes
13:18
done it this way
13:18
now the mmaps gives that error
Avatar
nope should not happen
Avatar
Jalenor Nefzen 13-Sep-21 01:19 PM
Avatar
i can allready tell that the guide is wrong and outdated due to use of vmap3assembler
Avatar
Jalenor Nefzen 13-Sep-21 01:20 PM
so I used vmap4
Avatar
delete the vmaps folder
Avatar
Jalenor Nefzen 13-Sep-21 01:20 PM
ok
13:20
done
Avatar
you should get an error cause buildings arent extracted
13:21
so you need to run vmap4extractor.exe (edited)
Avatar
Jalenor Nefzen 13-Sep-21 01:21 PM
Avatar
to generate building files (edited)
13:22
aka model files
13:22
after the buildings are generated
13:22
you create vmaps folder and run vmap4assembler.exe to convert buildings into vmaps (edited)
13:23
after that when its all done you run mmaps_extractor.exe
13:25
like this 😄
Avatar
Jalenor Nefzen 13-Sep-21 01:26 PM
on it
13:31
vmaps steps done now I have: mapextractor.exe mmaps_generator.exe (edited)
Avatar
mapextractor.exe generates dbc and db2 and maps vmap4extractor.exe generates buildings vmap4assembler.exe converts buildings into vmaps mmapextractor.exe generates pathfinding maps aka movement maps
Avatar
Jalenor Nefzen 13-Sep-21 01:33 PM
i miss this
13:33
mmapextractor.exe
Avatar
generator or how ever its called
13:33
XD
Avatar
Jalenor Nefzen 13-Sep-21 01:33 PM
ok
13:33
the generation works now
Avatar
its an extractor for movement maps i have no idea the name from my head sorry
13:33
im on my phone waiting on bus
Avatar
Jalenor Nefzen 13-Sep-21 01:33 PM
what I did before, was moving the content of "builds" to "vmaps"
13:34
this might have broken things
Avatar
Avatar
Arivana
im on my phone waiting on bus
Jalenor Nefzen 13-Sep-21 01:34 PM
thank you for your help 🙂 #commuting (edited)
Avatar
basicaly the extractors extract data from the client
13:34
that will be used on startup of your servers
13:35
after all 4 extractors are run and finished
13:35
you should be able to move buildings maps dbc db2 vmaps mmaps from wow root directory and put them into root where your worldserver and authserver is located (edited)
Avatar
Jalenor Nefzen 13-Sep-21 01:36 PM
ok
13:37
does the server folder need to be into the core or can be elsewhere?
Avatar
can be elsewhere you will need to specify the path in worldserver.conf
13:37
by default its "."
13:37
but you can change the datadir to anything you want
Avatar
Jalenor Nefzen 13-Sep-21 01:38 PM
ok
13:38
so final step will be ensuring worldserver.conf finds everything to run properly (edited)
Avatar
in worldserver conf you just need to remove the .dist extension
Avatar
Jalenor Nefzen 13-Sep-21 01:38 PM
done
Avatar
and add your database information into the config so the server can connect to it
13:39
and set your datadir if you dont put the extracted stuff into root
Avatar
Jalenor Nefzen 13-Sep-21 01:39 PM
I'll put it back into root now
13:40
no improvisation on the first run
13:41
should look like this
Avatar
Jalenor Nefzen 13-Sep-21 01:41 PM
do I still need the db updates folder I used to compile the db and the main branch downloaded? Or can I just keep my root and continue?
13:41
ok, ty, now the maps are generating and... according to the wiki... it will take a while
13:42
ye mmaps can take ages
13:42
;D
13:42
im so glad im on 16 core
13:43
i remember extracting it on 4cores like 24+hours ;D
Avatar
Jalenor Nefzen 13-Sep-21 01:43 PM
this will give you time to get home and grab a drink before I come knocking annoyingly again 🙂
13:43
ehm
13:43
working with lenovo b50-50 here, dignity and professionalism U.U
13:43
it will take the time it needs U.U
Avatar
well ;D
Avatar
Jalenor Nefzen 13-Sep-21 01:44 PM
these pandas are big
Avatar
hi guys
18:57
when im compiling with VS 2019 it gives me 5 compiling errors refered to queryresult.cpp authserver mmaps_generator
Avatar
Jalenor Nefzen 13-Sep-21 07:16 PM
does it prevent you from compiling?
Avatar
yep, only gives me those 5 erros
19:20
shared authserver vmapassembler mapsgenerator and shared(queryresult.cpp
Avatar
Jalenor Nefzen 13-Sep-21 08:11 PM
dunno if that is going to be a problem, I'm new to this myself, but if it went through... well, you can maybe fix it later on
20:12
my maps got extracted in less than 7 hours, yay!
Avatar
Avatar
Arivana
Click to see attachment 🖼️
Jalenor Nefzen 13-Sep-21 08:43 PM
confirmed, just I have few dll more
20:43
and I don't have the copies of authserver and worldsever without extension visible that you have (edited)
20:45
and this is the client
20:45
Avatar
i can run the extractors with the 5.4.8 or i need the 4.0 client?
Avatar
also when i created world db from the database update installer, it created me 2013_02_10 version of db, later on wil update
23:47
or do i need to update it
Avatar
Avatar
irrika
i can run the extractors with the 5.4.8 or i need the 4.0 client?
Jalenor Nefzen 14-Sep-21 01:26 AM
5.4.8 is good, read instructions by arivana above in the convo
Avatar
Avatar
irrika
also when i created world db from the database update installer, it created me 2013_02_10 version of db, later on wil update
Jalenor Nefzen 14-Sep-21 01:27 AM
Should work, but there is also a procedure to update it later on if need be
Avatar
the worldserver i guess it should update it?
Avatar
Avatar
Jalenor Nefzen
Should work, but there is also a procedure to update it later on if need be
okay, where would be that update procedure?
01:32
how can i know if i need to update it ?
Avatar
Avatar
irrika
okay, where would be that update procedure?
Jalenor Nefzen 14-Sep-21 01:33 AM
There is one illustrated on skyfire project wiki, should work I guess (edited)
Avatar
Avatar
irrika
how can i know if i need to update it ?
Jalenor Nefzen 14-Sep-21 01:34 AM
Technically, is your choice, since it is you running it (edited)
Avatar
Avatar
irrika
the worldserver i guess it should update it?
Jalenor Nefzen 14-Sep-21 01:36 AM
No, worldserver files are needed to run it
Avatar
aight, i extracted all maps, i need doing the patch, but at 5.4.8 folder there is no skyfirepatcer
03:06
do i need to patch 5.4.8 or no?
Avatar
the client patcher should be in skyfire community tools repo
Avatar
is it the connect patcher?
Avatar
i drag it ti the wow directory and nothing happens
03:11
to*
Avatar
to use the patcher you drag wow.exe on top of the patcher
Avatar
okay done
03:16
the worldserver gives me this error DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database 127.0.0.1;3306;root;root
Avatar
that can mean 2 things
03:16
your mysql service not running
03:16
or your credentials are wrong
Avatar
could be that the db is outdated? or not updated
03:17
i guess my password its okay
03:17
means mysql not running service or your login information is not correct
03:18
i mean yes if your password is root then it should work
03:18
Cannot connect to world database 127.0.0.1;3306;root;root
03:19
this means the server is trying to connect to localhost on port 3306 with username root and password root
Avatar
my password its other,one but yes it should be okay
03:19
second row its nor root, it was the thing to copy it here
03:19
hehe
Avatar
you need to change the password to the correct one in worldserver.conf and authserver.conf
Avatar
the authserver its perfectly working
03:20
it opens me the realm
03:20
and its the same pass and user than worlserver
Avatar
then your worldserver.conf
03:20
double check it
03:20
maybe you forgot to change the password
03:21
did you apply all the updates required ? even for characters database authdatabase and world database?
03:22
the latest world database can be found on the forums
Avatar
do i need to update it from database_update_installer
03:27
or with the sql its fine?
Avatar
you can use the updater but you can also update it manualy (edited)
Avatar
yea i see
03:34
thank you
03:35
i created new acc and didnt let me enter on
Avatar
why when i change dns it gives me ACE_INET_Addr::ACE_INET_Addr: wowmop.aasda: Authoritive: Host not found
03:47
at authserver
03:48
sys32?
Avatar
ace inetaddr should be the ip address i think
Avatar
where is that valor to change it?
Avatar
what ?
03:51
in auth database in realmlist table (edited)
Avatar
i got the auth now running but whenever i try to enter server, says something about converting battle.net account. i tried to enter with localhost and it log on
03:56
do i need to do create bnet?
03:56
like 6x and 7x
03:56
skyfire uses grunt login instead of bnet login
Avatar
and what would be this new error
Avatar
@Arivana intensivies the view on @Haening.
03:59
it could be that your authserver is not running?
Avatar
its running right now
04:00
even the worldserver got up
Avatar
have you create an account to login ?
04:00
in worldserver console ?
04:01
.acc create irrika irrika irrika
Avatar
Account with this name already exist!
04:01
it let me enter with localhost
04:01
but whenever i switched the dns to the realmlist
04:01
that new error on login came up
04:01
changed it in hosts to at sys32
Avatar
are your ports open ?
Avatar
yep, 8085 and 3724 that are refered to mop
04:02
and 5-6 more xD
Avatar
in the realmlist table
04:02
have you set your external ip address?
04:03
and the dns on the others
Avatar
what happens if you change it back to local
04:03
i mean the worldserver is running on localhost
Avatar
i guess it will let me entering again
04:03
it should
04:04
because your worldserver is on the same machine
Avatar
basicaly if the worldserver is on localhost then let it be on localhost
04:04
there is no need to set it to external ip
Avatar
yep, but if i want a friend entering without hamachi
04:05
this would be the only thing
Avatar
i mean, if i try any user and pass at login
04:06
it says the same message
04:06
something needs to be with putting something thats not local
04:07
i mean the authserver it doesnt give any realm problems and it created it at my external:8085
Avatar
and without dns change you can connect on external ?
Avatar
right now the realmlist of the db its with my ip, but the realmlist of the client, its with my dns
Avatar
set your ip in wtf of the client
04:10
try to connect with remote address instead of dns
Avatar
with my external, without dns, it keeps connecting a bit and then same error with battle.net acc
Avatar
go to some port check website
04:14
and double check if your ports are open
04:15
The port forwarding tester is a utility used to identify your external IP address and detect open ports on your connection. This tool is useful for finding out if your port forwarding is setup correctly or if your server applications are being blocked by a firewall.
04:17
other issue what could happen is if you have multiple wow exes in your client folder (edited)
04:17
if you execute x86 executable the game forces to launch x64 if it can be found in the client root folder (edited)
04:17
so maybe you try to connect with an unpatched x64 exe
04:19
also make sure that you change your wtf config only if wow.exe is closed
04:19
and then reopen the wow.exe
Avatar
with the unpatched same error
Avatar
does the fireadmin addon work?
Avatar
Jalenor Nefzen 14-Sep-21 10:10 AM
ok so, i've done the map thing (edited)
10:11
being a 5.4.8 (and not cata) I did not do this guide step "Keeping the code up to date" (edited)
10:16
I tried to update the client for whatever reason without success "Loading Wow.exe into memory... This Wow.exe version is not supported Loading Mac 'World of Warcraft' binary into memory... Could not load Win 'Wow.exe' or Mac 'World of Warcraft' into memory. Make sure this program is in your WoW directory and that WoW is closed."
10:16
So now I'm skipping all that and trying to set the authserver and worldserver correctly
Avatar
what are you trying to do ?
10:20
and where is this information from ?
Avatar
Jalenor Nefzen 14-Sep-21 10:24 AM
we left at me making the maps and moving them into core, this is done
10:24
next thing I did was getting the client updater and trying to make it work as you describe above
10:24
10:26
so I skipped altogether and went to do the following: - client folder, in config.wtf i set realmlist as 127.0.0.1 - authserver.conf I provided credentials to login MySQL - worldserver.conf I provided credentials to login MySQL (edited)
Avatar
Jalenor Nefzen 14-Sep-21 10:28 AM
ok
Avatar
you need the connection patcher
10:28
not the skyfire patcher
Avatar
Jalenor Nefzen 14-Sep-21 10:29 AM
delete skyfire patcher?
Avatar
A collection of tools and other misc items from the community. - SkyFire-Community-Tools/SkyFire Patcher/548 at master · ProjectSkyfire/SkyFire-Community-Tools
10:29
this one
Avatar
Jalenor Nefzen 14-Sep-21 10:29 AM
i have it now (edited)
10:29
same procedure?
Avatar
no just drag and drop wow.exe on top of the connection patcher
Avatar
Jalenor Nefzen 14-Sep-21 10:30 AM
done
10:30
worked
Avatar
bravo
10:30
step complete
Avatar
Jalenor Nefzen 14-Sep-21 10:31 AM
vďaka
10:31
so... setting the .conf above was ok?
Avatar
basicaly what you need to do with the configs is to remove .dist extension from them authserver.conf.dist -> authserver.conf
Avatar
Jalenor Nefzen 14-Sep-21 10:32 AM
done done
Avatar
after that you need to open up the configs and set your connection information to db
10:33
and thats it then you should be able to start authserver and worldserver
Avatar
Jalenor Nefzen 14-Sep-21 10:33 AM
which I can't
10:33
10:33
so let me check stuff
Avatar
show me your root folder of servers
10:35
Avatar
Jalenor Nefzen 14-Sep-21 10:35 AM
not sure what is that, is it this
10:35
Avatar
this is how it should look like
10:35
you dont need libeay and libssl
10:36
libcrypto
10:36
remove them
Avatar
Jalenor Nefzen 14-Sep-21 10:36 AM
nuked
Avatar
and your mysql lib has a diffrent size
10:36
are you sure you use mysql 8.0 ?
Avatar
Jalenor Nefzen 14-Sep-21 10:36 AM
10:36
pretty much
Avatar
go to programfiles
10:36
sec
10:37
C:\Program Files\MySQL\MySQL Server 8.0\lib
10:37
there you can locate the mysql library and copy paste it to the servers root
Avatar
Jalenor Nefzen 14-Sep-21 10:38 AM
so I copy paste \lib content into server root? or do i copy paste \lib folder to server root?
10:39
just libmysql.dll
Avatar
Jalenor Nefzen 14-Sep-21 10:39 AM
done
Avatar
start up server
Avatar
Jalenor Nefzen 14-Sep-21 10:39 AM
10:40
remove ssleay32
10:40
you dont want that shit
10:40
thats from old openssl no longer in use
Avatar
Jalenor Nefzen 14-Sep-21 10:40 AM
both worked
10:40
auth and world
Avatar
;D im a magician
Avatar
Jalenor Nefzen 14-Sep-21 10:41 AM
you a wiz lev hacker
10:41
gonna call you major from now on
10:41
so... if I set up my files correctly, I should be able to lunch patched wow and enter with standard login credentials
10:42
right major?
Avatar
no you gona need to create an account in worldserver console
10:42
.acc create jalenor jalenor jalenor@jalenor.ja
10:43
.acc create username password email
10:43
then you gona change wtf folders config file in the client root
10:43
and set the realmlist to 127.0.0.1
10:43
SET realmlist "127.0.0.1"
Avatar
Avatar
Arivana
SET realmlist "127.0.0.1"
Jalenor Nefzen 14-Sep-21 10:43 AM
done
Avatar
after that you start up the patched wow.exe and you should be able to login with jaelnor jalenor
Avatar
Jalenor Nefzen 14-Sep-21 10:44 AM
I want to be super powa admin, should I write something like account name makegm 4 -1 etc. etc.?
10:44
actually doesn't matter now, but I'm already here
Avatar
no you gona need to add rbac permission 192 to your account in authdatabase
10:45
then you admin on that account
Avatar
Jalenor Nefzen 14-Sep-21 10:45 AM
mh, so I open up the db, go to auth and edit a table?
Avatar
Jalenor Nefzen 14-Sep-21 10:47 AM
which column I edit for this?
10:47
doesn't matter, I did something and the line disappeared -.-
Avatar
no you create a new row there
Avatar
Jalenor Nefzen 14-Sep-21 10:48 AM
ok ok, I hid it with a filter like an idiot
10:48
it's there
Avatar
rbac_accoutn_permission table
10:49
accid = your account id which should have the permission
10:50
permissionid = 192
10:50
granted = 1
10:50
realmid= -1 aka all realmids
Avatar
Jalenor Nefzen 14-Sep-21 10:50 AM
done
Avatar
restart worldserver
10:51
by closing worldserver console and relaunch it
10:51
after that you can login and have admin rights
Avatar
Jalenor Nefzen 14-Sep-21 10:51 AM
dunno what to do with them but feels right
Avatar
you can use gm commands in game
10:52
liek .gm fly on
10:52
.mod speed
10:52
etc
Avatar
Jalenor Nefzen 14-Sep-21 10:52 AM
ok
10:52
omfg it actually worked
10:52
major, I owe you big time
10:54
for connecting to it from another machine, I guess same client and internet connection/hamachi stuff? or is there another setup to do (edited)
10:54
you would just change the realmlist in wtf to the external ip address
10:55
and open your ports in router
Avatar
Jalenor Nefzen 14-Sep-21 10:55 AM
uh uh
10:55
ok
Avatar
Jalenor Nefzen 14-Sep-21 11:18 AM
if I AllowTwoSide stuff, will the opposite faction players still be at war?
11:19
let's say I guild opposite faction players, or group them, will they still be marked red or green?
Avatar
never tested it
Avatar
Jalenor Nefzen 14-Sep-21 11:33 AM
time to fuck this up
11:33
😇
Avatar
Jalenor Nefzen 14-Sep-21 11:56 AM
now, if I wanted to allow all classes to all races, I should integrate all the "playercrateinfo...", "player_levelstats" and all tables making use of "race" AND "class" columns
Avatar
why would you do that ?
Avatar
Jalenor Nefzen 14-Sep-21 11:59 AM
dunno, an anti-tribu night elf shaman seem cool
11:59
as well as if I wanted to increase the level cap, I should provide values for it to work right
Avatar
its not shamans deserved to be the races they are
12:01
ugly looking race = ugly looking class
Avatar
Jalenor Nefzen 14-Sep-21 12:01 PM
ah ah
12:01
cannot argue with that
12:01
ok let's leave the classes there
12:02
for level cap, is tables integration gonna cut it?
Avatar
the level cap can be changed in worldserver config
12:06
Avatar
Jalenor Nefzen 14-Sep-21 12:06 PM
eh eh
12:07
true, but on a repack I tried before skyfire the sever could not start as the values for higher than cap levels could not be found
Avatar
will be same on skyfire because you need to add the values
12:07
;D
12:08
in pandaria player level is capped at 90
12:08
and stats go till 96
12:08
for creatures
12:08
so if you change player cap to 200 all the values between 200-96 will be missing
12:08
as expected
12:08
;D
Avatar
Jalenor Nefzen 14-Sep-21 12:09 PM
but I can 96 then
Avatar
but whats the reason
Avatar
Jalenor Nefzen 14-Sep-21 12:09 PM
which would be sufficient for all content to be done in groups of 5
Avatar
no you would break formulas
12:10
for combat ratings
Avatar
Jalenor Nefzen 14-Sep-21 12:10 PM
because I'm not planning having tons of people to play this with, so a higher level cap would make possible enjoy more content solo
12:10
I see
12:10
ok relations must be understood before editing occurs
12:11
I should probably focus on testing the server as is and see if I find problems to fix before customizing stuff around
Avatar
i mean the whole point in emulation is to make it as blizzlike as possible (edited)
12:12
there are alot of bugs you could invest time into them instead of customizing stuff around that makes no sense
Avatar
Jalenor Nefzen 14-Sep-21 12:13 PM
point taken
12:13
I do still think that you cannot solo end game instances
12:13
but I'm not sure how many people are requested
12:14
so if I gather enough I shouldn't need editing this stuff
Avatar
lets make it clear there are no mobs spawned in instances anyways
12:14
;D
12:14
cause i didnt spawn them from my sniffs yet
Avatar
Jalenor Nefzen 14-Sep-21 12:14 PM
so, just bosses?
Avatar
nothing its just empty i didnt add anything yet
Avatar
Jalenor Nefzen 14-Sep-21 12:14 PM
ah cool
12:15
well it is a work in progress
12:15
if I wrap my head around it I might be of help some day
Avatar
besides that dungeons are spawned
12:16
but not scripted
12:16
raids arent spawned
12:16
and you can solo it with a game master
12:16
account you just .mod hp 9000000000 and you have it at 900000000
12:17
you could add all players the rbac permissions for some commands
12:17
that way they would have the possibility to test stuff
12:17
etc
Avatar
Jalenor Nefzen 14-Sep-21 12:17 PM
sure
12:17
ty
12:17
is there a roadmap for the work to do?
Avatar
not sure if there even exist a private server where all players are Game masters ;D
12:18
would be speshul
12:18
😄
Avatar
Jalenor Nefzen 14-Sep-21 12:18 PM
lmao, the option is provided in the worldserver.conf
12:18
so not that far off
Avatar
you would just need to disable some rbacs for them
12:20
so they dont spawn shit around like illidan in stormwind ;D
Avatar
Jalenor Nefzen 14-Sep-21 12:20 PM
eh eh
12:20
let me ask that again, is there a way to follow up the work being done except github? slack, google sheet, whatever? it's a cool project, I foresee keeping the server on for several years, I'd like to make it a safe place for some friends (edited)
Avatar
github and discord in git updates
12:21
other option would be if you a mentalist
12:22
or someone who can read minds on longer distances
Avatar
Jalenor Nefzen 14-Sep-21 12:23 PM
it surely seems like I do from time to time to get some work stuff done
12:23
anyway, it's understood
12:24
let's go get "adminator" some killing and checking stuff around
Avatar
have fun 🙂
12:30
@AlterEgo did you wrote the guide for windows installation in the wiki ?
12:31
many people complain about not being able to setup the servers cause of invalid false information in the guides
12:32
besides that there is no x86 version of skyfire
12:32
mysql does not provide x86 services anymore
12:32
so x86 cant be setup at all
12:32
so its allways x64
12:32
no matter what installer you download
12:33
the installer is x86 but the provided services and libs are x64
12:33
the guide says that they can choose... they cant choose due to mysql not providing any x86 libs
12:34
the only way to setup x86 skyfire would be if they compile mysql from source
12:34
thats why all the x86 related garbage in the wiki can be removed aggain
12:35
and the shoxxo steps aswell
12:36
example
12:36
because you not get mysql 32bit you never will be able to compile 32bit version of skyfire
12:37
so there is no reason to have 32bit openssl at all write there to download x64 version and thats it
12:39
default branch is main
12:39
not trunk
12:39
trunk is a development branch
12:39
so even the command for downloading the git repo is wrong
12:39
.net framework is not needed
12:40
to compile or run the servers
12:40
why is it in the requirements
12:41
there is also something about visual studio 2022 not being supported
12:41
it is supported on trunk
12:41
main is setup for visual studio 2019
12:41
trunk is setup for visual studio 2022
12:42
so literaly telling people to download the repo that requires visual studio 2022 but then you write its not supported? (edited)
12:42
12:43
there is no skyfire_548.sln
12:43
the solution is called project_skyfire.sln
12:44
if mysql 5.5.x dude are we in 2010 ? (edited)
12:44
how old is that guide?
12:47
fix your shit
12:47
@AlterEgo
12:48
USE_MYSQL_SOURCES does not exist anymore since 2014 when i removed them from the repo (edited)
12:49
also the option for choosing the std library is missing
12:49
there
12:52
not sure where you got it from or if you just copy pasted it from some other guide but this guide is definitely legacy and obsolete and should never be used except as an april fool's joke (edited)
Avatar
libeay32.dll and ssleay32.dll no longer exist in open ssl got removed at 1.1.0 which translates into they no longer needed/required because they not even loaded. openssl is staticaly build which means if you would dynamicaly build it it would be libcrypto (edited)
13:28
@Jalenor Nefzen i cant delete issues i can just close it
Avatar
Jalenor Nefzen 14-Sep-21 01:29 PM
I see
13:29
then no problem, let's leave it there
13:29
I'll put content back there (edited)
13:33
who is the repo admin then?
Avatar
i am admin in repo why you asking ?
Avatar
Jalenor Nefzen 14-Sep-21 01:36 PM
my bad, the "owner" can delete issues
Avatar
i am owner and alterego is owner
13:37
so you should be able to delete issues
Avatar
nope there is no such option
Avatar
Jalenor Nefzen 14-Sep-21 01:48 PM
understood thanks
13:49
maybe superhero @AlterEgo can save my day here
Avatar
he might for sure after he fix the wiki
Avatar
Jalenor Nefzen 14-Sep-21 01:49 PM
jees, the wiki can wait, it's been there for a while now 😛
Avatar
Jalenor Nefzen 14-Sep-21 06:29 PM
well, the first ride was bumpy, but it is still a massive work
18:30
it will take me years to become able to do even the smallest of fixes XD (edited)
18:31
not sure if flooding the github with issues makes sense
Avatar
I did not rewrite it yet
Avatar
Jalenor Nefzen 15-Sep-21 10:22 PM
This issue from TC git also applies to my local build https://github.com/TrinityCore/TrinityCore/issues/17414 I looked up the solutions like this one https://github.com/TrinityCore/TrinityCore/commit/7b39a05d1e28ec254c3e00e57f2d30750f73c38b and I see three more columns in gossip_menu_option that my table hasn't: OptionBroadcastTextID, BoxBroadcastTextID and VerifiedBuild. Are they needed? Or can I use those values on my build as well (except the positions, I guess they are different in pandaria)? (edited)
Avatar
i dont think they are needed in the options it self but thats just my opinion
03:00
no idea what trinity is using them for in that table
03:07
the broadcasttextids are replacement for textids and should be used in gossip_menu table
03:07
instead of ids from npc_text (edited)
03:11
skyfire still uses the textids and will need a reindex for the new ids at some point
03:18
in other words they have nothing to do with the options it self
Avatar
Jalenor Nefzen 16-Sep-21 03:47 AM
thanks
03:48
I'll apply the values and see how it goes
Avatar
maybe your server wont startup
Avatar
Jalenor Nefzen 16-Sep-21 03:49 AM
maybe my laptop will ignite
Avatar
im just saying if you add collumns the reading of the collumns might be wrong and break something in the core
Avatar
Jalenor Nefzen 16-Sep-21 03:50 AM
ah, no I am not going to do that, reads suicide in my book
03:50
but the values in the other columns should be appropriate
03:51
at least it shouldn't make it worse than not working at all
Avatar
you could reindex the tables (edited)
03:51
in trunk i added the structure for the new table
03:52
for broadcasttext
Avatar
Jalenor Nefzen 16-Sep-21 03:53 AM
lmao, italian translation is funny
Avatar
Jalenor Nefzen 16-Sep-21 03:54 AM
ehm, I'll look this opportunity up in my DEV-noob dictionary and see if I understand what to do once I wake up
03:55
seem important
Avatar
the waking up part?
Avatar
Jalenor Nefzen 16-Sep-21 03:56 AM
it follows the me sending the last work email, going to walk out the dog, take out trash and crash on the bed until 4 hours from now
03:58
dog says "wof"(hi) followed by a long exhalation meaning "it's late, I don't want to go out, go to bed or I can't sleep stupid human"
Avatar
lol you an amazing animal speaker
Avatar
Jalenor Nefzen 16-Sep-21 04:01 AM
the dog has chewed it into my brain, so she is happy and I save my furniture, win win right
Avatar
well i mean you atleast understand what a dog wants from you
04:03
once i was at my sisters home and she went somewhere then her dog came to me started to dance around
04:03
started to wof me alot
04:03
i ignored him and then there was a surprice on the carpet when my sister came home
04:04
and i got all the bitching
04:04
not the dog
Avatar
Jalenor Nefzen 16-Sep-21 04:05 AM
of course
04:06
dogs are perfect, people are flawed
04:07
it's all trial and error (edited)
04:08
the piss is inevitable
04:08
it's not a matter of IF, but WHEN
Avatar
Why do you keep all the localization in one table? is this due to special requests from the client itself to the server? It just looks terrible.
Avatar
Jalenor Nefzen 16-Sep-21 12:10 PM
what would be another option?
Avatar
the reason why it is how it is is because you have an entry and that entry needs to be localized so we forloop all locales ids as collumns to load the texts for that id they are in order. (edited)
Avatar
example: broadcastid=1 text0="ENGLISH text0 here" here we localise text0 in a forloop on dblocaleindex text1="ENGLISH text1 here" here we localise text 1 in a forloop on dblocaleindex (edited)
Avatar
Avatar
Arivana
example: broadcastid=1 text0="ENGLISH text0 here" here we localise text0 in a forloop on dblocaleindex text1="ENGLISH text1 here" here we localise text 1 in a forloop on dblocaleindex (edited)
In other words, the client itself requires such a response structure from the server? If not, then you can change this structure and respond that the client requires from the server. Because in this form, it is poorly scalable, and also does not contribute to the overall performance of the server for the better, because you have to store a lot of empty localization cells in RAM. (edited)
Avatar
this is how we are using it for item names
12:58
same will be used for broadcasts
12:59
// item name std::string name = proto->Name1; if (localeData) ObjectMgr::GetLocaleString(localeData->Name, locale, name); buffer << uint16(name.length()); if (name.length()) buffer << name; for (uint32 i = 0; i < 3; ++i) // other 3 names buffer << uint16(0); std::string desc = proto->Description; if (localeData) ObjectMgr::GetLocaleString(localeData->Description, locale, desc); buffer << uint16(desc.length()); if (desc.length()) buffer << desc;
13:02
if locale is 0 localedata is a nullptr and should not execute the localization at all (edited)
13:03
we only localise if locale is not english
13:04
but i didnt write the function WriteBroadcastTextDbReply yet (edited)
Avatar
the reply string will get changed to the localised one in that reply
Avatar
but if you have a better solution feel free to share your code and we can maybe use it for all the other localisations aswell
Avatar
"Because in this form, it is poorly scalable, and also does not contribute to the overall performance of the server for the better, because you have to store a lot of empty localization cells in RAM." --zdohdds (edited)
13:42
some strings are empty even in db2
13:43
like english version has text 0 empty but has text 1 or vise versa
13:43
and we have 11 locales
13:43
thats 11 empty strings
13:46
but thats not our decision thats how blizz has it in db2
Avatar
In db2 it is logical to use such a structure, because the client can switch between languages, but on the server side it is not necessary to store all the languages immediately in RAM. As you remember, there was a strict restriction on playing on a specific server, then it was necessary to change the language. This means that blizzard had them divided into different servers. Basically, this is a feature of private servers, so that people from different language clients can play with each other, but this requires a lot of computing power. In fact, I don't care how it will be implemented. In my opinion, it is necessary to completely rewrite the emulator so that its individual parts can be offloaded to separate physical servers, as Blizzard has done for a long time.
Avatar
thats not true i can play with english client on german server and have everything in english or vise versa
Avatar
Because in such systems, there is usually always a default language.
Avatar
basicaly how it works is
13:55
when you click a mob you get an gossip id with the broadcastentry
Avatar
en=default but main can be other
Avatar
this entry will be checked if the entry exists in db2 if not client requests an db update
13:56
and thats where we write the localised text and replace the locale 0 text
13:58
you have broadcast template thats where we write the english locale text to the client if it does not exist in db2
13:58
if it is not english we just replace the text to the localised one but the other template data is the same
14:00
so you can choose 11 empty collumns or 11 more rows per entry
14:00
if you know how relational databases work
Avatar
I don't understand why you interfere with broadcasting and storing data in the Database in one heap. The DB structure can be absolutely any, but at the broadcasting stage we can adjust the data to the desired standard.
Avatar
which data? where do you store your data?
Avatar
never mind...
Avatar
yeh thats what i think aswell you need to store the texts somewhere
14:05
else you cant translate it
Avatar
Avatar
zdohdds
In db2 it is logical to use such a structure, because the client can switch between languages, but on the server side it is not necessary to store all the languages immediately in RAM. As you remember, there was a strict restriction on playing on a specific server, then it was necessary to change the language. This means that blizzard had them divided into different servers. Basically, this is a feature of private servers, so that people from different language clients can play with each other, but this requires a lot of computing power. In fact, I don't care how it will be implemented. In my opinion, it is necessary to completely rewrite the emulator so that its individual parts can be offloaded to separate physical servers, as Blizzard has done for a long time.
Jalenor Nefzen 16-Sep-21 02:43 PM
the fact that a local server manages a negligible volume of requests (being basically empty) doesn't make splitting the data a heavier workload on the dev with little benefits for the performance? like, localised serverS would make sense with a normal volume of players (1000+) but for a small scale? trying to understand
Avatar
basicaly the client sends the localeindex to the server at login with which the player is connected and is saved to the memory and depending on the index we should localise the data there are no language specific servers (edited)
Avatar
Jalenor Nefzen 16-Sep-21 02:50 PM
ok, so based on localeindex the correct language text is taken and displayed - would this imply it's possible to fetch the desired language if present, otherwise just pick default (EN)?
Avatar
thats what we are doing
14:51
default is locale 0 which is english
14:51
if its 0 we pass the normal text from broadcasttext template with the data
14:52
if the locale > 0 aka some diffrent language we check locales_broadcast text for the entry and the correct locale index and just replace the string that we pass in the reply with the localised one
Avatar
Jalenor Nefzen 16-Sep-21 02:54 PM
what I mean is that, assume locale > 0, but the corresponding line (i.e Italian) is not there (didn't translated that yet), will then the reply be reverted to 0 and EN provided? or would it just be empty (meaning that a full localisation should be carried out before enabling that localeindex)?
Avatar
itallian locale = 11
14:54
i think
14:54
french 2, german 3
Avatar
Jalenor Nefzen 16-Sep-21 02:55 PM
XD thanks, should I elaborate better my question?
Avatar
"what I mean is that, assume locale > 0" by default we send english text from broadcasttext template
14:56
this text needs to be translated to and replaced in the buffer to the localised text
14:56
if you dont do it it will be english
Avatar
Avatar
Arivana
if you dont do it it will be english
Jalenor Nefzen 16-Sep-21 02:57 PM
thanks! that's what I wanted to know
14:57
so a progressive translation is possible
14:57
maybe I've found a way to contribute that doesn't imply going to university again 😛
Avatar
yes but you still need to store the texts somewhere
14:58
else you wont be able to translate it
Avatar
Jalenor Nefzen 16-Sep-21 03:00 PM
Well, if I identify the tables with text I can edit them with IT where appropriate, then push back
15:01
being text, I should just add/substitute text right?
Avatar
well entry in the locales and entry in the template is the same id
15:01
basicaly we load those tables
15:02
and we send then the text for a specific id
15:02
by default we send the english text
15:02
if locale is not english we translate the text and send the localised text from locale broadcasttext instead the text from the default template
15:03
but both needs to be loaded into memory so we can translate it
15:03
both strings needs to be loaded
Avatar
Jalenor Nefzen 16-Sep-21 03:04 PM
"but both needs to be loaded into memory so we can translate it both strings needs to be loaded" please elaborate more
Avatar
you need to set a string variable
15:05
std::string text_0 = ""; empty string by default saved into stack (edited)
15:06
you need to set the text to the text from db
15:07
which would be done witha function in objectmgr
15:08
then you would check for the localeindex
15:09
and you would set text_0 aggain with the localised text with a diffrent function in objectmgr (edited)
Avatar
Jalenor Nefzen 16-Sep-21 03:10 PM
https://github.com/ProjectSkyfire/SkyFire_548/commit/2bcfa6e1f539ba50755e20d04803f1687727c3c0 here - if I just wanted to do translation, I could just go and edit the ITA text with the correct text right?
Avatar
loc11 should be italian collumn
15:11
you would add the entry for the text and then you could add the translation
15:12
you could also add the other translations
15:12
in case a non italian client connects to your server
15:13
because if a german client connects german client would have empty string in gossips
Avatar
Avatar
Arivana
because if a german client connects german client would have empty string in gossips
Jalenor Nefzen 16-Sep-21 03:14 PM
being empty the german column, shouldn't the reply be reverted to english? (edited)
Avatar
i think it should
15:15
but not sure if it is
Avatar
Jalenor Nefzen 16-Sep-21 03:15 PM
ok, to test I should just set my client to ITA and then see if previous ENG replies are still there or everything is suddenly empty
Avatar
its not implemented at all
15:16
lol
Avatar
Jalenor Nefzen 16-Sep-21 03:16 PM
ah, that's the trunk right
Avatar
i didnt load the database tables i just added the structure for the tables (edited)
Avatar
Jalenor Nefzen 16-Sep-21 03:17 PM
ok so, next step, could you please add me to the right repo so I can fetch and start reading stuff to get a better idea?
Avatar
use main branch
Avatar
Jalenor Nefzen 16-Sep-21 03:18 PM
but that doesn't have the columns with localised text right? (edited)
Avatar
not for broadcasts but it have for other localisations
Avatar
Jalenor Nefzen 16-Sep-21 03:18 PM
alright, let's have a look
Avatar
Jalenor Nefzen 16-Sep-21 03:30 PM
fetched
Avatar
the localisations are in world db
Avatar
Jalenor Nefzen 16-Sep-21 03:32 PM
world
Avatar
the tables start with locales_ (edited)
Avatar
Jalenor Nefzen 16-Sep-21 03:35 PM
so these files here
15:35
15:36
no
Avatar
Jalenor Nefzen 16-Sep-21 03:37 PM
I remember a joke from a film featuring that move
15:37
ok sorry, so I fetched the repo, then opened it from github desktop with explorer, then looked for the files that might have the tables I'd like to edit
Avatar
Jalenor Nefzen 16-Sep-21 03:39 PM
so... I create a new session in Heidi, import world db, edit the table, dump the updated world db overriding old sql files and then commit?
Avatar
and what would be the reason to do so ?
Avatar
Jalenor Nefzen 16-Sep-21 03:40 PM
that's how I've contributed to other github projects: fetch, open, edit, save, commit
15:40
buuut, never done with db tables
15:40
sooo
Avatar
well in sql you want to write the queries
15:41
and then just save the queries into .sql file
15:41
and thats the file you would share
15:46
here is an example how alterego localised creature names for german and russian client
15:47
thats how you would write your italian localisation for the other tables
15:48
or use UPDATE to update the entries that allready exists etc (edited)
15:48
to update specific row/collumn
Avatar
Jalenor Nefzen 16-Sep-21 03:51 PM
can I use an existing query and just add the italian where needed? say I take the above query and add the italian in the correct column
15:51
that would update it with the addition of italian right?
Avatar
Jalenor Nefzen 16-Sep-21 03:52 PM
they call me lazy nefzen
Avatar
well you could also use an update statement (edited)
15:54
UPDATE locales_creature SET name_loc11="Committente Benny <PNG>" WHERE entry=19;
15:54
this update query would add the name for italian npc 19 🙂 (edited)
Avatar
Jalenor Nefzen 16-Sep-21 03:56 PM
that would require me a lot of crt+c/v, to copy IDs, <tag> and avoid spacing errors 😛
15:56
but is good to know ty
15:57
where can I find all the queries for the local_ tables
15:57
?
Avatar
you need to write them your self lol
Avatar
Jalenor Nefzen 16-Sep-21 03:57 PM
nooo, so only locales_creature exist?
15:58
mmh, I can learn from that
Avatar
yes ego shared only that one
Avatar
Jalenor Nefzen 16-Sep-21 03:58 PM
thank ego than, saved my noob ass 😛
Avatar
but the other tables work with the same principle
15:58
you just will need to write it because noone shared the data yet with the community
Avatar
Jalenor Nefzen 16-Sep-21 04:00 PM
well, time to repay the community a bit
Avatar
i mean you can get the data for some of them from some data collector websites like wowhead
16:01
or from WDB/ADB cache
Avatar
Jalenor Nefzen 16-Sep-21 04:02 PM
I wouldn't be able to tell if all columns and values are correct to work as a template, I'd need to understand the query first, so at that point it should be easier to compile it anew from ego's one
Avatar
to get itallian translation you would just add it prefix infront of wowhead.com
16:02
it.wowhead.com
Avatar
Jalenor Nefzen 16-Sep-21 04:02 PM
never, it translation sucks
Avatar
Illidan Grantempesta <Il Traditore> ^^
16:04
All'inizio dello scontro, Illidan impugna le sue Lame da Guerra e infetta i nemici con [Spirito d'Ombra Parassitico].Quando raggiunge il 65% di salute restante, Illidan prende il volo e lancia le sue Lame da Guerra di Azzinoth sul terreno, ognuna delle quali crea una Fiamma di Azzinoth, che dev'essere sconfitta per riportare Illidan a terra.Per ...
16:06
Illidan schwingt zu Beginn der Begegnung seine Kriegsgleven und infiziert seine Feinde mit einem [Schädlichen Schattengeist].Beim Erreichen von 65% Gesundheit steigt Illidan in die Lüfte und schleudert die Kriegsgleven von Azzinoth in den Boden. Jede von ihnen ruft eine Flamme hervor. Beide Flammen von Azzinoth müssen bezwungen werden, damit Ill...
😄 1
16:06
this is the german translation
Avatar
Avatar
Arivana
Illidan Grantempesta <Il Traditore> ^^
Jalenor Nefzen 16-Sep-21 04:09 PM
yeah, I need to use the official names sigh
Avatar
Jalenor Nefzen 17-Sep-21 07:05 PM
several classic, tbc, wotlk and cata dungeons and raids seem to work
19:06
working on the localization, wowhead was a good suggestion
Avatar
What's the point in translation for PC, programs and apps?🤔😄
01:55
English is the language for machines...
01:55
IF... ELSE... EXIT.. RESET...SHUTDOWN. 😄
01:56
sudo apt-get
01:57
writing terminal commands in any other language is like .. OMFG! 😄
Avatar
total offtopic and wrong (edited)
romance_emo_057 1
Avatar
Avatar
L2S
What's the point in translation for PC, programs and apps?🤔😄
Jalenor Nefzen 18-Sep-21 09:39 AM
Is this a serious question?
09:40
I will answer if it is
09:40
Unraveling the countless misteries of Localization for your mind to behold and despair
Avatar
You're kidding, right?
15:52
Are you writing commands in terminals or your text editors other than english? 😄🤔
15:55
Globalization means "Everything is English!" no matter where you are or what sh1t you're using... (edited)
3715_baka 1
15:56
... now the conclusion: Why to translate things? 😄🤔
15:58
..nvm .. do your jobs. 😄
Avatar
Hello Spanish speaking people, at 20 hours (Argentina) is released this video on how to compile SkyFire on Windows server 2019. I still need to do part 2, where I create the databases and extract the maps. I hope it will be useful. https://www.youtube.com/watch?v=gGAU22lUtoM
👌 1
Avatar
Avatar
L2S
English is the language for machines...
In computer programming, machine code is any low-level programming language, consisting of machine language instructions, which is used to control a computer's central processing unit (CPU). Each instruction causes the CPU to perform a very specific task, such as a load, a store, a jump, or an arithmetic logic unit (ALU) operation on one or more...
Avatar
Avatar
L2S
Are you writing commands in terminals or your text editors other than english? 😄🤔
yes you can, it all depends what the developer that wrote the software, expects to be used as an input. (edited)
00:22
you can literaly write what ever aslong as the logic is the same. in any language.
Avatar
Avatar
L2S
Globalization means "Everything is English!" no matter where you are or what sh1t you're using... (edited)
Jalenor Nefzen 19-Sep-21 01:53 AM
Globalization is about economy and policy. Localization is about accessibility to media and learning. You can live with English just fine, yes, but you don't have to. I don't. Be thankful to interpreters and translators, silently they keep humanity together more than you know, and have provided countless with the very words of their thoughts.
👍 1
Avatar
Good afternoon, here is the last part of the tutorial. I hope you found it useful, it is in Spanish, but good. Maybe with subtitles, it can be useful anyway. https://www.youtube.com/watch?v=lsUljMd4ZyY
Avatar
Could it be that a table is missing in the last rev? Because I had to create it, based on a commit from the repository, but maybe I'm making a mistake. Because if it is missing, ultimately, I don't know whether to create an issue or directly a PR.
Avatar
which table you missing ?
Avatar
In the last rev, at least, applying the updates, it tells me that this table is missing: scene_template. But maybe I am making some mistake. https://github.com/ProjectSkyfire/SkyFire_548/blob/08c01d4da2acdcdff63f684e831ee236831b4aca/sql/old/5.4.8/world/SFDB_Release_20.3_to_21.0/2020_09_12_00_world.sql
02:20
SFDB_full_548.21.0_2021_02_07.zip
02:21
I don't know if there is another one a little more recent, but if we use that one, and apply the updates, it asks for that table.
Avatar
that table should be there its used by spell effect when you get the aura it looks for the scene_template
02:23
maybe ego made a mistake or forgot to apply it before he did a release
Avatar
Maybe, or maybe the one who is making a mistake is me.
Avatar
if you run the installer and install the sfdb and you have everything working correctly just reapply the table and feel free to open an issue
02:26
maybe he fix the database after he done with the wiki 😉
Avatar
If it is to add that table, I have no problem creating the PR. Although I'm not too sure about how to name the file, if you then rename it, or if you have some script that automatically generates it.
02:30
I used the latest rev, but I may be making a mistake.
Avatar
yyyy_mm_dd_id_db.sql
02:33
I update my fork, and create the PR then.
Avatar
clone a fresh one
02:33
😉
Avatar
2021_09_19_00_scene_template.sql ?
Avatar
usualy world because an sql update can have multiple tables in it but if you name it after table name its also fine you need just to write more then 5 letters ;D
Avatar
Excellent, the PR is already created then.
Avatar
Marcelo lima 21-Sep-21 05:21 PM
Sorry I do not know how to update in Github But I was able to fix the quest: Fear in Evil The item was not fulfilling the cure according to the quest: It was only to add to Spell in the item. SQL: Update World.Item_Template Set Spellid_1 = '93097' Where Entry` = 65733;
17:21
17:21
17:21
17:22
if it does not work for someone
17:23
Avatar
What was the quest missing, the item? @Marcelo lima (edited)
17:56
A no, I get it. The spell was missing from the item.
Avatar
Marcelo lima 21-Sep-21 06:15 PM
@Stevej Yes The spell was missing in the item.
👍 1
Avatar
You would have to create the PR
18:18
If you need help, let me know. There are a series of steps. But it's always basically the same.
Avatar
its not correct adding the spell to the item, it should be a spell_click_spell from the mob that is on the ground.
Avatar
Marcelo lima 21-Sep-21 07:15 PM
If and correct or not I do not know .. 1 time that I move with server besides 3.3.5 I did and it worked .. ^ .. ^
Avatar
the quest was introduced in cataclysm
19:15
and the soldiers have npc flag spell click spell
19:16
so you need to add the spell to the spell click spell table (edited)
19:16
and when you rightclick the mob it should be cast on them
19:16
and you should get credit aswell
Avatar
Marcelo lima 21-Sep-21 07:17 PM
Do not have the table SPELL_CLICK_SPEL
19:19
How to get this error NPCs only appears with GM on
Avatar
Marcelo lima 22-Sep-21 01:24 AM
I'm not finding the files of Raid Blackwing Descent in Source Can anyone tell me where it stays?
01:24
Avatar
stuff that is missing was probably not scripted yet
😆 1
21:34
or none actualy did work on that content part
Avatar
Marcelo lima 23-Sep-21 06:22 PM
I'm adding the NPCs but the damage is only in 1 and does not have the same skills are with the scripts
Avatar
mindmg maxdmg are in creature_template for melee combat calculation (they can be verified in sniffs from updatefields) and needs to be set for class/level accordingly, dmg multiplier is a wdb field so can be verified there aswell, to let her cast you would need to write a c++ script for the dungeon/boss, then assign it in creature_template for that npc. (edited)
Avatar
Avatar
ElisGrimm
Click to see attachment 🖼️
Promoting a wow private server here in russian or whatever language is ... it's somehow brainless and useless... It's like when you want to sell Hungary products in China without english documentation 😆 (edited)
Avatar
Oh those russians
Avatar
well not sure what translation you need ;D it must be a fishing tournament, the images are clear. server elisgrimm, fishing tournament, legion fishing rules in swamp of sorrows in murloc costumes x30 times to catch extra fish. ;D (edited)
😄 1
12:58
joke
23:06
The whole Facebook family is down... Insta, FB, WhatsApp
23:06
Avatar
lolz
Avatar
Jalenor Nefzen 06-Oct-21 08:20 PM
Milg?
Avatar
Avatar
L2S
Click to see attachment 🖼️
Jalenor Nefzen 06-Oct-21 08:20 PM
In my city we would reply "afammocc"
Avatar
Avatar
Jalenor Nefzen
In my city we would reply "afammocc"
lol, explain please? Wtf is "afammocc" and what's your city? 🤔🤣 (I'm not a telepath or some robot)
22:38
oh, lol. "Afammocc! No translation needed. To cheer at somebody's pain or bad luck / an exclamation after a great achievements is reached."
22:39
Google is still retard 🤣 (No translation needed lol, Google u fckin serious?)
Avatar
Jalenor Nefzen 07-Oct-21 01:03 PM
Well
13:04
Google is not wrong
13:04
But not right
13:05
It roughly translates as "suck it b*tch"
13:05
Where "b*itch" is not gender specific
13:07
It is said with mischievous glee
13:07
Or genuin pleasure
13:08
Reasons to say it vary
Avatar
Shhh. So quiet
Avatar
Does anyone know what the cause of this error could be? server\game\DataStores\DBCStores.cpp:723 in LoadDBCStores ASSERTION FAILED: !sResearchProjectMap.empty() [0x1f311] [0xec65] [0xd94b] [0xdb4e] [0xdbca] [0x92a140] BaseThreadInitThunk()+0x19 [0x0] RtlGetAppContainerNamedObjectPath()+0xed [0x0] RtlGetAppContainerNamedObjectPath()+0xbd [0x0]
Avatar
@The Important People Any idea how I can solve this issue? (edited)
Avatar
looks like an assertion error at loading archeology dbc and writing it to the std::map ? (edited)
22:09
!sResearchProjectMap.empty() means "the map is not empty"
22:44
@Arivana I have a new problem: 0xc000007b I'm on windows 10 and it occurs on a system which runs MaNGOS for 1.12.1 without issue
22:44
Avatar
Microsoft Visual C++ Redistributable Package is a runtime component necessary for running of multiple applications. The files in Microsoft Visual C++ Redistributable Package usually corrupt due to many reasons. And this can cause the 0xc000007b error. In this case you need to reinstall this components.
Avatar
windows 10 installs these through "Apps & features" should I just reinstall them that way?
Avatar
yeh you can
22:49
try
Avatar
Interesting that this is a difference between VManGOS and SkyFire
Avatar
@Arivana I reinstalled all of these, no change:
Avatar
Any ideas for what I could try next?
Avatar
What version are you compiling with?
02:31
Visual studio 2019?
Avatar
No, I'm not compiling; this is a repack.
13:02
Hasn't been supported since November 2017, but I understand that it is based on this project and did work fine back then.
Avatar
i suggest you ask the repack provider how to solve the issue because we dont know what he changed etc.
Avatar
Repacks are never supported
Avatar
I fixed the 0xc000007b issue: In my case these files were wrong, the correct version was the latest 64-Bit for my system W10 64
ssleay32.dll libeay32.dll
Avatar
this 2 dlls no longer exist in openssl since 2014 and are not needed for skyfire anymore since then, so i guess the repack you are using is not based on skyfire
13:59
or the repack is very old like 7+ years
Avatar
According to file modification dates, it's from 29/10/2016
Avatar
those 2 dlls are from 1.0 openssl series
15:38
in 1.0.2 they removed them and added libcrypto dlls which was lts and the lts ended in 2017 i upgraded the ssl to 1.1.0 some years back so it might be that your repack still uses the no longer supported by openssl older 1.0.2 series or earlier. Current skyfire uses 1.1.1 which is 2 series newer then the 1.0.2 series (edited)
Avatar
Ah so my server has the heartbleed vulnerability?
Avatar
“Catastrophic is the right word. On the scale of 1 to 10, this is an 11.” „Katastrophal ist das richtige Wort. Auf einer Skala von 1 bis 10 ist dies eine 11.“ – Bruce Schneier (edited)
😄 1
👍 1
19:30
1.0 series had the heartbleed so 1.0.1 and 1.0.2 got a hotfix where you needed to compile with specific compile tag but still had it in it.
Avatar
Imagine how many addons can DDoS his server... 😄👍 (edited)
09:07
and +++ a lot of vulnerabilities. If you're going LIVE with that repack.. then Hell on Earth. 😄
Avatar
DDoSing a repack server? 🤔
Avatar
Avatar
L2S
Imagine how many addons can DDoS his server... 😄👍 (edited)
Yeah lucky it's for localhost only
16:04
Good to know these things, thanks incase I ever decide to share it I'll need to figure out compiling from source, maybe even host it on a Linux box in that case
Avatar
Avatar
Err0r
DDoSing a repack server? 🤔
Yes, not intentionally... as I said by using wow addons some old server revisions can get denials (mostly DoS)... even Trinity but it is patched/secured. (edited)
17:34
spammed or even crashes... etc. Update your servers every 5-6 months at least...
17:35
if it's localhost only then guess what? 😄... not needed.
Avatar
Do u know what a DoS/DDoS is? Trinity can't patch a (d)dos attack
😄 1
Avatar
There are experts everywhere.. I almost forgot lol.... and that typical and eternal noob question "Do you know what DDoS is?!"🤣👍 (edited)
23:35
Search on their git... and click on the Security tab. 👍 You'll understand. (edited)
23:38
You're getting old... lol.
23:38
Avatar
Yes, it'is bad when there are people who are more familiar with a topic.. e.g. L4 ddos, how should trinitycore (L7) fend off an L4 ddos? inquire about application layer 🙂
00:10
https://github.com/TrinityCore/TrinityCore/security/advisories/GHSA-3gwv-8f5g-c8j5 that protects against brute force, but not a real ddos 🙂
Avatar
Avatar
Err0r
Yes, it'is bad when there are people who are more familiar with a topic.. e.g. L4 ddos, how should trinitycore (L7) fend off an L4 ddos? inquire about application layer 🙂
Of course it's bad when you can't read ... put your eyeglasses... "WorldSocket::HandleAuthSession Denial of Service". 👍😄 You're getting old...
Avatar
Are you a troll or don't you understand what trinity means by HandleAuthSession? This means when you send packets that crash the server. No ddos!
smiley_emo_055 1
🧐 1
11:16
Learn to read and understand don't just read "denial of service" and say it protects against ddos
Avatar
i mean you could add a return in authsession handler if the user is authenticated if he is you just return and send error message to the client. if he is not authenticated you proceed and set account to authenticated.
14:34
if the issue is the authsession handler
14:41
that way if the server is being ddos we ddos back! ;D
14:42
and after lets say 4+ authenticated atempts you can close the connection
Avatar
NotInKansas 23-Oct-21 04:10 PM
In fact DoS means sending packets, especially unwanted packets... logic. (edited)
16:11
Error... You're the only one who's talking about DDoS 😄
16:13
making other people Trolls or using bad words it will not make you smarter than others... but ... 🤦‍♂️👍 Error . you're like a blind man who's telling others "Learn to read".. is like ..🤦‍♂️ (edited)
Avatar
Avatar
NotInKansas
In fact DoS means sending packets, especially unwanted packets... logic. (edited)
DoS means Denial of Service
16:27
DDoS means Distributed Denial of Service
Avatar
Avatar
Arivana
DDoS means Distributed Denial of Service
NotInKansas 23-Oct-21 05:40 PM
Ik
Avatar
Avatar
L2S
Imagine how many addons can DDoS his server... 😄👍 (edited)
.
Avatar
Avatar
NotInKansas
Error... You're the only one who's talking about DDoS 😄
.
01:53
Ok. 🤔
Avatar
Weekend Drama
Avatar
No drama ari
Avatar
Back in my day if you had a rival server you could hack the website and upload dick picks because 90% of the noobs couldn't harden a website 🙂 Most of them I could access the DB is 3 mins. Wipe wipe wipe
Avatar
Avatar
AlterEgo
Back in my day if you had a rival server you could hack the website and upload dick picks because 90% of the noobs couldn't harden a website 🙂 Most of them I could access the DB is 3 mins. Wipe wipe wipe
those days are gone.. now they have WordPress approx. 70% ... 😀 (edited)
11:59
or your hacking skills are not updated lol 😄👍
12:01
anyway... thanks to Imunify360... that's all they need on a web server.
Avatar
Imunify360, can handle all XSS/SQLi vulnerabilities? interesting
03:33
03:33
😄
Avatar
I'm seeking to compile my own MangosFour or Skyfire 5.4.* server, someone in the mangos discord says that MangosFour is "unplayable" but that skyfire is the most complete. What doesn't work on the current version? @The Important People (edited)
Avatar
Compile it yourself and judge for yourself.
Avatar
@AlterEgo do battlepets work at all?
Avatar
Avatar
FourFire
I'm seeking to compile my own MangosFour or Skyfire 5.4.* server, someone in the mangos discord says that MangosFour is "unplayable" but that skyfire is the most complete. What doesn't work on the current version? @The Important People (edited)
NotInKansas 27-Oct-21 04:56 PM
"says that MangosFour is 'unplayable'" 🙂 .. but which is playable? There's nothing playable on SkyFire... no expansion. All cores are full of bugs, empty or missing content... as they said in the beginning The Project Skyfire is for education and programming purposes and not for "playing" 😉 But as always your contribution to the project and the missing content is much appreciated. (edited)
👍 1
Avatar
Avatar
NotInKansas
"says that MangosFour is 'unplayable'" 🙂 .. but which is playable? There's nothing playable on SkyFire... no expansion. All cores are full of bugs, empty or missing content... as they said in the beginning The Project Skyfire is for education and programming purposes and not for "playing" 😉 But as always your contribution to the project and the missing content is much appreciated. (edited)
Trying to setup and compile on linux, can't seem to figure out what is missing from the instructions at Installing ACE: http://wiki.projectskyfire.org/index.php?title=Installation_(Ubuntu_18.04_LTS)#Prerequisites My ACE_wrappers folder looks like this: /SkyFire/ACE_wrappers# ls ACE-INSTALL.html ACE_vs2019.sln AUTHORS MPC VERSION contrib html protocols ACE.mwc ACE_wrappers_vc14.sln COPYING NEWS ace debian include rpmbuild ACEXML ACE_wrappers_vs2017.sln ChangeLogs PROBLEM-REPORT-FORM apps docs lib tests ACE_vc14.sln ACE_wrappers_vs2019.sln GNUmakefile README bin etc netsvcs websvcs ACE_vs2017.sln ASNMP Kokyu THANKS build examples performance-tests The result /SkyFire/ACE_wrappers# make -j4 GNUmakefile:21: /include/makeinclude/macros.GNU: No such file or directory make: *** No rule to make target '/include/makeinclude/macros.GNU'. Stop. (edited)
Avatar
Any idea how to solve this?
Avatar
Avatar
FourFire
Any idea how to solve this?
What Linux you have? Ubuntu, Debian or CentOS?
01:02
Try with latest Ubuntu and/or Debian
01:03
otherwise it will not work...
01:05
Another thing... Linux is for private servers 😄 and SkyFire is for educational purposes... that why I recommend you to use Windows like any other normal "user". Let Linux for machines...
Avatar
Avatar
L2S
What Linux you have? Ubuntu, Debian or CentOS?
Ubuntu 20.04
01:37
I am using linux because something about my windows installation fucked up and wouldn't let me compile
01:37
I'm not sure what host OS has to do with usecase of the software: it's the same code isn't it?
Avatar
Avatar
L2S
Another thing... Linux is for private servers 😄 and SkyFire is for educational purposes... that why I recommend you to use Windows like any other normal "user". Let Linux for machines...
Anyway is there something not contained within 20.04 which is required for compilation to work, why is this the case when the latest release is from February this year?
Avatar
Apply the DB updates from the SQL folder
Avatar
sudo apt-get libace-dev
Avatar
Skyfire has Lua right?
15:43
Available for newest revision?
15:43
🙏
Avatar
no, you better try trinitycore i think they use lua
Avatar
Really? :C
15:54
Damnit
Avatar
Enluna had a patch for it but don't think it's current
Avatar
Avatar
Arivana
sudo apt-get libace-dev
Thanks but I have already installed those
Avatar
well, if you have installed the library why are you trying to compile it aggain then ? (edited)
Avatar
@AlterEgo
11:17
^^
11:20
green capsules are players and can be moved with WASD
11:20
blue capsules are other connected players 🙂
Avatar
time to do some player animations for movement haha
Avatar
Nice
Avatar
❓ What do you call a snail on a ship? 🐌😄
Avatar
CRKT (edited)
Avatar
That's the right answer... "Snailor" 😄
Avatar
Got a mess load of assets. Tons of waifus.
Avatar
cool you modeling them your self or just downloaded from an asset store? 😄
Avatar
Jalenor Nefzen 03-Nov-21 11:33 PM
Wtf
Avatar
connection results in progress lul
Avatar
Jalenor Nefzen 04-Nov-21 12:03 AM
What's that
Avatar
Hello Kitty Emulator 🙂
00:55
😄
Avatar
@Jalenor Nefzen MMORPG VIDIO GAME
Avatar
public float degreesPerSecond = 2.0f; void Update() { transform.Rotate(0, 0, degreesPerSecond * Time.deltaTime); }
Avatar
Jalenor Nefzen 04-Nov-21 09:24 AM
Roflcopter
Avatar
Avatar
Arivana
cool you modeling them your self or just downloaded from an asset store? 😄
Theres a site to grab nesrly all you want/need
16:30
hahaha
Avatar
Jalenor Nefzen 05-Nov-21 01:08 PM
I wish I could draw something that's not a crippled stickman
😄 1
👍 1
Avatar
Avatar
M'Dic
Theres a site to grab nesrly all you want/need
Which site? 🙏
Avatar
Avatar
Jalenor Nefzen
I wish I could draw something that's not a crippled stickman
@Jalenor Nefzen lack of anatomy ?
Avatar
Jalenor Nefzen 05-Nov-21 09:00 PM
@Arivana there's a bug in my programming, I cannot physically describe people let alone draw them, but I do know where to look for organs... guess I should have paid attention during pre-school countless drawing hours
Avatar
its not about organs but about muscle mass
23:58
and kinda connecting those muscles together like lego pieces 😄
00:01
in 3d 😄
00:02
^^
Avatar
Shhhh.
12:59
Sleeping
Avatar
Hi people.
20:04
How %'s done from SF MoP? It is playable approx. 75%? I want to compile it and earn some $$$ with it.. to buy a lambo or a Mercedes CLS, ok? 😅
20:04
I'm thinking about it... I really need a LAMBO 😎😆🤗
Avatar
Jalenor Nefzen 11-Nov-21 12:45 AM
I think you are in the wrong place, better try your luck with a repackage out there
00:46
You have far better chances to buy your lamborghini
👍 1
Avatar
NotInKansas 11-Nov-21 02:28 AM
I was kidding.. but yeah, why not, a Mercedes CLS 400 it will be enough 😉
Avatar
@NotInKansas what about a honda civic?
Avatar
skoda120 > lambo
Avatar
Tesla
14:54
Wait. I already have a Tesla
Avatar
Avatar
AlterEgo
Wait. I already have a Tesla
lol, why you need a Tesla in US? 😂
18:46
where gasoline is everywhere...
18:46
Electric cars are for people who don't have money...
18:46
😄
18:47
sell your Tesla and buy a real car... Mercedes CLS
Avatar
tesla can't drift 🚫
18:50
Tesla is even more expensive than a CLS lol. (That explain why Elon Musk is quadralionaire) 😎🤣 (edited)
Avatar
Jalenor Nefzen 11-Nov-21 08:21 PM
Piaggio Apecar > everything
Avatar
👍 2
3715_baka 1
😆 1
Avatar
bruh he could be her dad 💀
Avatar
Jalenor Nefzen 13-Nov-21 02:56 PM
maybe he is
Avatar
More like West Virginia.
17:33
You know how to circumcise a man from West Virginia? Punch his sister in the jaw.
Avatar
Jalenor Nefzen 13-Nov-21 07:32 PM
not lots of hebrews in wv uh
Avatar
Hillbillies
Avatar
Looking at setting a server up, but was wondering on the completeness of this distro. I don't mean "Are there any bugs" because I know these inherently haver issues, and I expect that, but looking for the overall game. It's just a few of us, and as long as most everything is playable in some form or another, quests, etc. dungeons. OR maybe a better question, what's the point everyone is at with this? I see there are still some updates here and there. I wish I could contribute, but honestly, I don't really know, nor have the time, how to go through the DB and fix things. Sincerely, Me
Avatar
@Koltran its far from playable and if you dont have time to go through anything you will have hard time with skyfire
21:00
better try some repack or try trinitycore project
Avatar
I have a trinity core wotlk running now. but was hoping for an MoP
😆 1
Avatar
its far from 335
Avatar
no worries.
Avatar
basicaly with cataclysm kalimdor and ek got completly deleted
21:03
so you will have outland and northrend playable like it was in 3.3.5
Avatar
aww. yeah. that sucks. well. I was hopeful at least!! 🙂
Avatar
i dont think hope is enough (edited)
Avatar
if I just had the time to invest. I have the time to set it up and run it, but not the time to dig into things
Avatar
aslong as people dont start to work on stuff it will stay like this for ever
21:04
its not possible for 1 developer to do everything that 1000 developers did at retail
Avatar
of course
Avatar
so even if you come next year and ask the same question the progress will probably be the same
21:06
and there are not many people intrested in this expansion
Avatar
I know this was a smaller project to start with. not dissing that state of the project. I know it's a lot of needing more people. as I said. was just hoping.
Avatar
even tho it was the best expansion blizz released
Avatar
right?!
Avatar
it was definitely better then wotlk
21:06
lel
Avatar
we mulled over a lot of the different expacs, and decided on this one to set up next for folks.
21:07
we didn't want to do anything further than MoP.
Avatar
to ne honest if you not going for research and tech
21:07
its kinda pointless to develop anything beyond warlords
21:07
after warlords everything went down
Avatar
even WoD was... well. there were a lot of nice client upgrades, but the expac was nothing we desired.
Avatar
wod was garbage
21:08
and is garbage
21:08
even on retail
21:08
;D
21:09
basicaly classic < tbc < worlk > cata < panda >wod > legion > bfa > shadowlands
21:09
panda was better then wotlk
Avatar
agreed
Avatar
that means panda was best time on retail
21:10
from lore and everything almost
Avatar
it was the last expansion imho that allowed players to expereince all of the content and hit max level. when wod came out, it sort of allowed people to skip too much. but that was the goal. get people into the most recent expansion as quickly as possible.
Avatar
i mean
Avatar
same went for legion and up. and now... well.. now it's just a single expac to max level. pick one.. ding, done
Avatar
every expansion that had a wow token is garbage
21:12
so wod leg bfa shadowlands is garbage
21:12
because you can basicaly pay2win the game
21:12
if talking about high end raiding or pvp
21:13
and it feels bad to lose in arena or bgs due to people bought better gear (edited)
21:13
for reallife moneys
21:13
same for raiding if you didnt had that bought boes you was not even considered to be taken into raids
21:14
and would be benched
21:15
basicaly pandaria had best lore and it was not pay 2 win
21:15
so pvp and pve was very good
21:17
basicaly what wod legion etc bring to the game is better client graphics fucked up classes destroyed ingame community with garrisons and class halls to split the players apart.
21:17
basicaly social distancing in game
Avatar
yeah
Avatar
made the game kinda from a mmo a single player (edited)
21:17
and pay to win and to not lose subscribers implemented a never ending grinding system aka artifact power ;D (edited)
Avatar
sorry. had to step away. daughter vacuuming the office
Avatar
and you can see that even with the latest heartstone expansion or what it is
21:18
that they trying to go into the gacha market now
21:19
so all this wod legion bfa shadowlands were kinda test projects if they should go the p2w route
21:22
they try gacha market with heartstone and expanding into mobile with diablo immortal where the most gacha playerbase is located
Avatar
Yeah. well. it was worth a shot. I'll keep looking around. Thank you!
Avatar
you welcome
Avatar
Jalenor Nefzen 14-Nov-21 01:34 AM
I want pandaria
01:34
Will wait
01:34
And do tiny contributions
01:35
Then one day a big panda guru will show up and make a big push and complete the server
Avatar
Big push coming
👍 1
09:40
when ?
Avatar
Jalenor Nefzen 14-Nov-21 10:00 AM
When you least expect it
Avatar
Avatar
Koltran
I have a trinity core wotlk running now. but was hoping for an MoP
NotInKansas 14-Nov-21 11:30 AM
and when you get MoP you'll want a Legion server and so on... better stay with WotLK for life because that's the last wow private server which you'll see 😄 (edited)
Avatar
Avatar
NotInKansas
and when you get MoP you'll want a Legion server and so on... better stay with WotLK for life because that's the last wow private server which you'll see 😄 (edited)
whats this negative attitude ?
Avatar
NotInKansas 14-Nov-21 11:31 AM
You can't and you'll never find a wow server 80-90% done.
11:31
negative? 🙂 How's that ?
11:31
I said something wrong, omg ? 😛
Avatar
there are many pservers that has alot done
Avatar
NotInKansas 14-Nov-21 11:32 AM
He said that he already have an Wotlk server and he wanted a Mop
Avatar
I did, but MoP is the last expac I liked. so. wouldn't want to go any further than that. if I wanted current, I'd just re-up my retail sub.
Avatar
NotInKansas 14-Nov-21 11:34 AM
yes, compared with SkyFire there's a lot done on other servers.
11:34
especially TC
11:34
but only wotlk from TC is playable.
Avatar
you cant compare trinity and skyfire
11:35
the community difference is massive
Avatar
NotInKansas 14-Nov-21 11:37 AM
because the free internet idea it doesn't exist anymore
11:37
and nobody wants to contribute... at least for free. 🙂
11:38
people's fault in general and their thinking
11:38
people got crazy after 2010... brain crashes
11:38
broken minds, kaput.
11:39
the internet is slowly dying or will get transformed in a commercial spot. (edited)
Avatar
well its theyr fault lol
11:40
many people pay rl money to fix theyr servers if the servers would share they would not need to waste rl money ;D
Avatar
definitely a glass half empty way of thinking. 😄 But you're not really wrong.
Avatar
NotInKansas 14-Nov-21 11:40 AM
^^ see.. it's true. 😄
Avatar
well but it does not affect us
Avatar
NotInKansas 14-Nov-21 11:41 AM
That explain why you'll remain with your wotlk only.
Avatar
that affects just pservers
Avatar
NotInKansas 14-Nov-21 11:41 AM
whatever..
Avatar
Avatar
NotInKansas
That explain why you'll remain with your wotlk only.
and that's okay, but maybe someday. 🙂
Avatar
NotInKansas 14-Nov-21 11:42 AM
When wow will get on 30 expansion.. "maybe" you'll have a playable MoP 😄
Avatar
i mean someday is when pservers realize that they paid moneys for fixes that are so easy to fix that some developers need 30seconds to fix it ;D
Avatar
NotInKansas 14-Nov-21 11:43 AM
@Arivana That will never happen
11:43
for buying and driving a car you don't need to be a mechanic 😄
Avatar
for example sfdb still has old bc/wotlk spell requirements for blacksmith specializations/ leatherworking specs
11:44
;D
11:44
to delete it from database takes less then 30seconds
11:45
and because those spellids no longer exist but warlock havoc has now the spellid to be able to use havoc you need blacksmithing XD
Avatar
ah..mop 548... what a memory when i was working on a pserver and had to redo mostly everything with a bunch of guys, some paid, some free now that work is completly gone :v
Avatar
how come ?
Avatar
talking about freakz
11:47
running on skyfire 548 in that time, in one month or 2 we had a playable core
Avatar
yeh i mean if you invest time into it
Avatar
NotInKansas 14-Nov-21 11:48 AM
Shoker with Freakz and Co.
💯 1
11:48
🙂
Avatar
exactly
Avatar
NotInKansas 14-Nov-21 11:49 AM
they're updating expansions and not more than 1 year on same expansion...
11:49
that's good
Avatar
freakz is not on mop anymore
Avatar
NotInKansas 14-Nov-21 11:50 AM
but hard work to do...
Avatar
and shocker has sold everything already to firestorm
Avatar
NotInKansas 14-Nov-21 11:50 AM
ik
Avatar
but it way bad, they are faking players onto website
11:50
no work into core anymore, just copy pasting from FS
11:50
complet mess from what we've done in the past..
Avatar
NotInKansas 14-Nov-21 11:51 AM
what was the price>?
11:51
😄
11:51
3k $?
Avatar
no idea tbh
11:51
prly couple of tens of thousands
Avatar
NotInKansas 14-Nov-21 11:51 AM
I heard he got a new BMW 🙂
Avatar
:)))
Avatar
didnt he allready had one ?
Avatar
sold that one prly
11:52
and got another
11:53
but yea, no one will do code stuff anymore w/o $
Avatar
NotInKansas 14-Nov-21 11:53 AM
Firestorm are russians, right?
Avatar
definitely not for pservers but for opensource i do 😄
Avatar
no idea, france i guess
11:53
a bit useless if they get bits from there w/o giving credit
Avatar
NotInKansas 14-Nov-21 11:54 AM
Ari, you can do for Skyfire 😄
11:54
it's still open-source 😄
Avatar
isnt firestorm izidors project?
Avatar
think so
Avatar
NotInKansas 14-Nov-21 11:54 AM
they looks like russians to me 🙂
Avatar
not sure
Avatar
NotInKansas 14-Nov-21 11:55 AM
russians have thousand of p.servers and not WoW only
11:55
L2, Aion, Minecraft, WOW...
Avatar
currently freakz is just making $ for shelby
11:55
and nothing more
11:56
they'll realease SL on freakz first just to have it as PTR
11:56
and when SL will officially release on FS, freakz is bye bye
Avatar
NotInKansas 14-Nov-21 11:56 AM
what is shelby and SL 🙂 ?
Avatar
100% confirmed from freakz staff internally, im still keeping in touch with them
11:56
shelby is the owner of firestorm, fs = firestorm
Avatar
NotInKansas 14-Nov-21 11:56 AM
yes
Avatar
they merged awhile ago, by merge i mean shocker sold to shelby freakz
11:57
:))
Avatar
NotInKansas 14-Nov-21 11:58 AM
but Freaks got so many donations or FS? So they can pay few thousands of $$$ for a p. server files lol ?
11:58
I doubt that ppl get some donations for p servers nowadays.
Avatar
freakz and firestorm both have donation systems
11:58
and yes, some guys will pay a lot of cash for code
Avatar
btw what happened to the client from firestorm ?
Avatar
i also sell some private parts of freakz and some cores so..
11:59
which didn't get to public yet
Avatar
firestorm is "5.4.8" but is not compatible with skyfire did they edited the client ?
Avatar
NotInKansas 14-Nov-21 11:59 AM
as far as I know freakz was based on a romanian community even their website and forum are in romanian language...
Avatar
or are they working on ptr client ?
Avatar
they have it patched
Avatar
i see
12:00
;D
Avatar
Avatar
NotInKansas
as far as I know freakz was based on a romanian community even their website and forum are in romanian language...
long ago, yes
Avatar
Avatar
Arivana
i see
rageless is a scammer , everyone please do not buy stuff from him , i can bring proof for my statements , do not trust this guy , i have his full name , bank account and linkedin profile , this guy is scamming people for money , indeed he worked for wowfreakz but he recently got banned from their server
03:11
banned from freakz
Avatar
Why the ban reason is "failure"
09:13
Lol
Avatar
Avatar
Yukki
Why the ban reason is "failure"
because he's a failed wanker , he scams people
👍 1
🤠 1
Avatar
Jalenor Nefzen 16-Nov-21 10:38 AM
well, yo moma told you not to give money and take candies from strangers
👍 1
10:38
most importantly, don't get on the van
Avatar
Avatar
spider
because he's a failed wanker , he scams people
We know that... he can be Shoker also... cause he didn't get money from his crappy wow server not even in 2014.
13:24
There is only scam and spam in the WoW community in general...
13:25
Don't trust romanian people in general... they're scammers.
13:28
Freakz is well known for scamming, rage, and full or romansky ... I can't believe that someone can donaqin that server. lol
Avatar
i am romanian lol
13:28
i actually wanted to work with him
Avatar
Avatar
spider
i am romanian lol
not all romanian people...
Avatar
on a long term project
Avatar
imagine how lame can he be if he scammed me for a mere 100$
13:30
you wanted files or something from him?
Avatar
well i got my own server and i was looking for devs
13:30
and i knew he used to work for freakz
13:31
did not immagine he would be a cunt
Avatar
Rageless: "i also sell some private parts of freakz and some cores so.." 👍😄
13:31
😄
13:31
typical for scammers.. yes.
Avatar
eiherway i got my server on fully working
13:32
now i have to get players on
Avatar
like the 99,5% of Ac-web community 👍😄
13:32
MoP?
13:32
or what server?
Avatar
"fully working" not even TC 335 is fully working after 10 years of development
🧙‍♂️ 1
Avatar
cataclysm
👍 1
13:33
well error u know what i mean
13:33
its playable
Avatar
its in a decent state
👍 1
13:33
lets say
Avatar
fully working... he meant that he made it working.. like compiled and stuff...
13:34
not fully completed
13:34
anyway Cata is more completed than MoP
13:35
at least than SkyFire 😄
Avatar
i got like 380 accounts in 3 months
Avatar
and 0 active players? (edited)
Avatar
but i work and whatever work i do on the server , i do it in free time
13:37
well i have a few players active
👍 1
Avatar
Cata lovers... nostalgic players
Avatar
its quite hard to "compete with apollo" they have a big team and lots of money
Avatar
World of Warcraft will be played even after 100 years from now on...
13:39
they're russians I think..
13:39
Apollo
13:39
retarded russians have hundreds of servers...
13:40
WoW, L2, Minecraft, Metin, Aion, etc.
13:43
Make your servers low-rate (max. 5x rates) and donation free... if you want a successful server and active players. 👍 (edited)
13:44
Where you see more than 1k players online ... there are bots and fake players.
13:44
Especially 335
Avatar
Jalenor Nefzen 16-Nov-21 02:10 PM
rusky have a name for choosing one game to focus on for their entire life
14:11
lots of games out there are still playable and have community just because russians will keep them alive
14:12
anyway, romanians are nice c'mon, douchebags are so common they have their own international flag
Avatar
What about hungarians, how they are?! 😄
15:20
There's a hungarian MoP server out there.. I forgot his name lol... (not so important).
15:21
that hungarian server which is always in DDoS... they added it as a "feature" or "news" on their website homepage lol.
Avatar
WoW$cape
Avatar
where the antrix pservers ;D
20:43
lets do some sethekk halls ;D
Avatar
𝓛𝓞𝓢𝓔𝓡 16-Nov-21 11:35 PM
hello everyone
23:37
I have a problem. Can I ask you for help? About Linux compilation errors ububtu16
😄 1
23:38
ubuntu16
23:39
apt-get install libace-dev apt-get install libncurses5-dev apt-get install build-essential autoconf libtool make cmake git-core patch wget links zip unzip unrar vim apt-get install openssl libssl-dev libmysqlclient-dev libmysql++-dev libreadline6-dev zlib1g-dev libbz2-dev apt-get install aptitude aptitude install -y mariadb-server mariadb-client Is there anything else I need to do?
Avatar
Avatar
𝓛𝓞𝓢𝓔𝓡
ubuntu16
Ubuntu 16, really? 🤣👍 (edited)
01:50
If you understand english... (a little) you'll see that Ubuntu 16 is not supported... not even Ubuntu 18. UPGRADE to Ubuntu 20 if you want SkyFire to work properly!! (edited)
01:52
And change your nickname to a "more readable" one 👍😄 You're not an Alien, right? What if my nickname on Discord was "$@#/@&*&'" is this readable? (edited)
Avatar
it's chinese xD
01:59
But yeah, ubuntu 16 is old af , update it.. (edited)
Avatar
Avatar
L2S
And change your nickname to a "more readable" one 👍😄 You're not an Alien, right? What if my nickname on Discord was "$@#/@&*&'" is this readable? (edited)
𝓛𝓞𝓢𝓔𝓡 17-Nov-21 02:19 AM
This is Chinese, not garbled
Avatar
Of course, but Chinese is not an international language. Can you see how it looks on my phone? 🤣🤨
13:05
13:05
😂
13:06
If you think that's normal.. then ok.. I'm not the one who makes the rules here on this channel anyway... 😏👍
Avatar
Good God, what is with all the racism in this Discord?
😄 1
Avatar
Avatar
Bench
Good God, what is with all the racism in this Discord?
racism...?
14:57
How old are you?
14:57
What do you know about racism?
15:00
I said that "Chinese IS NOT an international language!" Is that racism? the fck is wrong with people nowadays? 🤣🤔
Avatar
Da fuck is any racism? GTFO
23:26
@Bench You some kind of Biden supporter?
👍 1
Avatar
NotInKansas 18-Nov-21 12:33 AM
🙂
Avatar
Jalenor Nefzen 19-Nov-21 12:59 PM
geghegeheh
12:59
kek
Avatar
I have some good news.
14:11
I just saved a bunch of money by switching to Geico. 🙂
17:40
People before 2020 🙂
Avatar
NotInKansas 19-Nov-21 05:50 PM
👍 1
Avatar
Jalenor Nefzen 21-Nov-21 02:10 AM
Right in the feels
Avatar
Hello everyone, does this project support macos?
Avatar
you mean "macros"? (edited)
15:03
or "MAC OS"? 😄🤔
15:04
or "tacos"? 😄
Avatar
Avatar
L2S
or "MAC OS"? 😄🤔
Don't you mean macOS?
Avatar
I like tacos
Avatar
Weather Calabasas
16:59
!weather calabasas
17:00
😅
Avatar
Avatar
L2S
or "MAC OS"? 😄🤔
MacOS
Avatar
Avatar
Dual
MacOS
macOS
Avatar
does this project support it?
00:19
only
00:19
5$
00:19
😂🤣👍
00:20
not only support it (MacOS) but it has developers for free also. 👍😂
Avatar
Avatar
L2S
5$
do we get fries?
Avatar
Time for a beer.
Avatar
Some changes coming for SkyFire. Let you know later. Stay Tuned
👀 1
smiley_emo_005 1
adult_emo_026 1
16:10
Changes?
16:11
You making MoP playable? 🤗🤔🙆‍♀️
16:13
🙆‍♀️
16:14
🎅
Avatar
Where skyfire changes? 🐒
Avatar
Avatar
L2S
You making MoP playable? 🤗🤔🙆‍♀️
I don't think so xD
Avatar
Brutal-Fabian 04-Dec-21 05:40 PM
fala ai
Avatar
SHMEKER1908 04-Dec-21 06:10 PM
hello
18:10
anyone can help me with server creation on mop 5.4.8
😄 1
Avatar
Avatar
SHMEKER1908
anyone can help me with server creation on mop 5.4.8
on Windows or Linux? 🤔
Avatar
Can you even make a mop server on windows?
Avatar
SHMEKER1908 05-Dec-21 09:23 PM
On windows i have Eroor 0xc0000b7
Avatar
So renaming a bunch of shit automatically makes it heavily modified? It's a real old code base mostly full of hacks.
Avatar
Who's trying to sell this?
23:54
No database
Avatar
Is there any backdoor in it?! 😄🙆‍♀️ I want it for my private server ... of course it will be on Linux and that why cause I don't want everyone with full root access on my server 😄
05:17
For best security ever ... I'll change my password and shutdown the server after.. 😄
Avatar
Avatar
AlterEgo
Who's trying to sell this?
I see the markings. Its that thordekk person group. He is pretty well known for resell based on leaks. Ask anyone in tc. His shit lets literally leaks on a monthly.
Avatar
Avatar
AlterEgo
So renaming a bunch of shit automatically makes it heavily modified? It's a real old code base mostly full of hacks.
Old but gold... It's not matter... warmane have players and nobody is asking what type of code they're using, SSD or HDD storage disks or if their server files are fake or retail... what is matter is that "if isn't playable...then nobody cares" 🤗😄
Avatar
Copyrighted 2014...... (edited)
18:47
lol
flirty_emo_030 1
🧐 1
smiley_emo_055 1
Avatar
It has the Warmane battle pet code, I wrote that KEKW
Avatar
Real Pro
07:50
If it's working...
07:50
who cares? 😄
07:50
at least is working...
07:52
Nowadays is like I'm using the most shitty core and things are working as intended and instances, raids are available (at least spawned) .. and guess what? I have players online 😄
07:54
... now tell me if I get the best core which is 2021 coded and there are no instances available not even raids ... or quests are there in the DB but bugged or not finished because of a "," is missing or not added...
07:54
😄
07:54
which one is better?
Avatar
Got an error at 95%
13:12
can't compile...
13:12
torghast
13:13
on Linux
13:13
sht happens
13:13
😄
13:14
Cmake was ok... but when make install I got some error at 95% with zlib or smtgh like that
13:15
I'll stick with Skyfire... 🤗😄
Avatar
the only thing i see thats 2021 coded on that link is just the dates. lol
👌 1
🙌 1
Avatar
that core 5.4.8 gives error
Avatar
NotInKansas 10-Dec-21 11:36 AM
at 95% ... /cmake is OK but when you compile it throws errors at approx. 95%
Avatar
That explain why there's no Mists of Pandaria private servers (except only Warmane with 50 players from years and crappy hungarian Tauri) 🙂
15:49
The MoP community fault in general and MoP was destroyed because of ppl.
Avatar
does Cataclysm have a full and full?
02:21
Cataclysm 4.3.4
😄 1
Avatar
Anything from Skyfire is not more than 30% complete... it is intentionally like this because they want it to be for educational purposes and for code learning...
19:01
At least you can compile it and connect... 😄
19:03
If you want it to make it playable you'll have to work on it at least one year... especially on content.
Avatar
SkyFire was never intended for any kind of private server use. It's mainly a base platform for reverse engineering. I get PM's almost every week asking if I want leaked sources. Not trying to be a dick the answer is no. If you have a leaked source I'm happy for you but don't expect me to merge any of that into SkyFire. We are trying to eliminate hacks not add more.
😄 1
👍 1
🤠 1
🧙‍♂️ 1
Avatar
dead?
😄 2
Avatar
Avatar
core
dead?
yes, almost...
Avatar
Not dead. STFU.
13:21
When the page goes dark and I delete the repository than it's dead
Avatar
they're seeing dark... the 'dark' matter... 🤣
Avatar
just hackfix everything why is everyone a perfectionist
22:19
☹️
Avatar
They wanted to be a long-term project which means that it will be done in few generations 😄😎👨‍💻 (edited)
06:52
He made it very clear... Skyfire is not for private servers (that means people will not get dollars or euros from donations or by selling virtual items in game)... hackfix? There's only devs and they're not using hackfix, they're coding like pros. 😎😄
Avatar
We also have real lives, jobs and family to support. We don't get government benefits from Biden 🙂
👍 1
Avatar
well said
Avatar
Fuck Biden what’s a biden
👍 2
🤠 2
Avatar
Bidenator... democracy... US freedom... American Dream lol... hahaha. 🤣😎
15:07
California... dollars.. YouTube..
Avatar
NotInKansas 23-Dec-21 04:32 AM
HI people
04:32
Question: I want to create a web database for World of Warcraft
04:33
Using PHP, MySQL and PDO.
04:33
my question is: It is possible to decrypt game files to extract the data like NPC, Monsters, Items, Skills, etc?
04:35
or there is all the needed data in the database?
05:50
Thanks for breaking startarea panda
05:50
whoever made this and whoever aggreed the PR .. dumb
05:52
phasing issue detected, in .gm on they are corectly
05:52
So, whoever had broken that, go move your dumb ass and fix your pr shit it was working fine (edited)
Avatar
What pull request?
Avatar
idk ... but it was working
😄 1
12:58
someone fuckt that up with some trash
12:59
however looking into it later wanna go sleep
12:59
tha "schweinepriester" needs sleepin boss ya
Avatar
There is a reason in that... to avoid private server releases... 😄 That why all the fking starting areas are ALWAYS broken... sadly (edited)
Avatar
aha
Avatar
All yall do is complain lol. Go fix it if it's broke
😄 1
👍 1
Avatar
no?
18:32
it was fixxed and someone else broke it
18:32
why should i clean others trash
👍 1
18:33
i am since 2013 member of sf i was admin now mod in forums wiki admin and more and i hqve spend alot of time here and now explain me why should i fix stuff that others have broken?
Avatar
Weather BOT 23-Dec-21 06:41 PM
Temperature
43°F
Feels Like
37°F
Sky
Mostly Cloudy
Humidity
85%
High / Low
43°F / 41°F
Precipitation
60%
18:42
Temperature
48°F
Feels Like
46°F
Sky
Cloudy
Humidity
98%
High / Low
47°F / 44°F
Precipitation
20%
Avatar
Weather BOT 23-Dec-21 09:02 PM
Temperature
25°F
Feels Like
13°F
Sky
Partly Cloudy
Humidity
69%
High / Low
30°F / 26°F
Precipitation
50%
21:03
Temperature
12°F
Feels Like
5°F
Sky
Partly Cloudy
Humidity
67%
High / Low
21°F / 15°F
Precipitation
60%
Avatar
F? not C? we using american retard units now?
😄 1
Avatar
it's the bot not me 😄
Avatar
how it sounds... "american retard" 🤣
23:31
In 2000 was "American Psycho" .. now "American Retard"... the future and world degradation... THE END IS NEAR! 😄
23:32
Just identify that person who uploaded the broken scripts in Panda starting area and ban "the retard" 😄 (edited)
Avatar
📣 Question: Where I can get the "Armory Database PHP" (a working one) for MoP at least or above... thx in advance.
Avatar
male yourself
08:59
items stored in dbc db2 files
Avatar
merry christmas @here
Avatar
@NomexPlayZ Merry Christmas!
Avatar
It's not Christmas yet!
Avatar
it is because we in europe 😄
13:20
time differences
Avatar
May Cthulhu spares us all for 2022!
Avatar
@M'Dic We don't use European Retard units in America 🙂
alert 3
peepoRetard 2
alertblue 3
😜 2
Avatar
retarded
Avatar
Avatar
AlterEgo
@M'Dic We don't use European Retard units in America 🙂
im just messing around obviously. I actually live in america now.
Avatar
Need help if someone knows some SQL querying sh1t.. 😄
04:16
04:17
I started a Database project in PHP, MySQL, PDO, HTML and CSS.
04:18
As you can see the variable "$s1" in the item description (Text)
04:19
dafaq ... 😄 so I need to query and get the stats from another table?
Avatar
no
04:33
did you have template engine?
04:33
pls if so not smarty
04:34
or use mixxed bullshit like html php mix
Avatar
Mixed bullshit like HTML and PHP togheter... it is something made in minutes... (edited)
13:48
that why I asked for "Armory PHP script"
13:51
but I find another way... I downloaded the 9.1.5 TDB from Trinity and I'll try... and I'll post a link when done for public use. Anyways it's faster enough even without template system (ik that smarty is very fast) but trust me it is faster PHP 7.4 and PDO parameterized searches...
23:20
Merry Christmas
Avatar
Merry Christmas!
23:21
Mofo
Avatar
Can someone help me, when I try to install ACE using the ../configure --disable-ssl command I get this error. (edited)
03:53
I get this error: "-bash: ../configure: No such file or directory"
03:59
I am following this guide.
Avatar
It should work
Avatar
I try many times, and I always get the same error.
Avatar
Avatar
Sun
I try many times, and I always get the same error.
Linux or Windoze?
19:11
If is Linux Ubuntu then 20+ ...
19:11
18 is not supported
Avatar
i didnt updated the wiki yet up to 20+
17:12
will done later
Avatar
Yes, but as you can observe people are trying to compile the server with older Ubuntu versions like 16 and 18....
Avatar
Happy New Year to everyone! 😍🤗🍾🍷🥂
Avatar
Happy effing new year. RIP Betty White.
Avatar
:( yeah :(
Avatar
Deleted User 05-Jan-22 03:14 AM
SFDB_full_548.21.0_2021_01_07.sql nut full db
😄 1
03:14
not
03:17
my table so emptu
Avatar
SFDB is not full DB... funny. 😂 When it was?! 😄
03:18
Yes unfortunately, it's empty. Because lack of contributors...
03:19
try DB from Torghast 5.4.8
03:19
or from Trinity 5.4.8
03:19
SF is 10 MB... 😂
03:20
Only 10MB sql in 10 years.. dafaq ... their efforts are still appreciated.
03:22
I think that people wanted to destroy private servers like Warmane and Tauri that why SF was stopped and 0 contributors. (edited)
Avatar
Deleted User 05-Jan-22 03:23 AM
thanks working
Avatar
At least theoretically and practically they killed MoP in a great style. (edited)
03:23
You're welcome.
Avatar
Does anyone know why when im doing a CMake I don't see " USE_MYSQL_SOURCES (If you are NOT updating the MySQL header sources.) "
Avatar
No.
18:47
SkyFire requiers MySQL 8. We no longer include the sources
18:48
You need to have the full development package installed.
Avatar
Trying to do thuis step but I cant confirm my account to access the ifles.
19:23
Avatar
That means. . ... ... SFDB is on forum ... and you can import the world in your MySQL server or MariaDB by importing it using the RUN function directly from HeidiSQL
20:10
Open up your HeidiSQL > Create table "World" > Use run for import (it takes approximately 2 minutes, even faster because SFDB is almost empty) (edited)
Avatar
Wait is this correct?
20:19
Schema for each world characters and auth then I just do that SFDB sql on world database
20:19
@L2S
Avatar
Am I suppose to run every update sql or just the latest?
Avatar
all updates
Avatar
The DB isn't empty ffs
21:53
It's just light 🙂
Avatar
I feel like im doing this wrong :'3
Avatar
Only because camper trolls never contribute anything to the project but always have an entitled opinion.
21:57
Download the world database from the forum
21:59
the base auth and character database from the skyfire repo are already current and don't need updates applied. Once you get the world DB installed you only need to apply the worldupdates
Avatar
Avatar
AlterEgo
Only because camper trolls never contribute anything to the project but always have an entitled opinion.
So do I just take my empty world db and run the SFDB_full_548.21.0_2021_01_07.sql in it, and then apply all the update files?
Avatar
Yeah. Or use the installer
22:04
Windows?
Avatar
Correct
Avatar
Avatar
AlterEgo
Windows?
So I thought I did everything correctly however when I run it I get issues. Using configuration file worldserver.conf. Using SSL version: OpenSSL 1.1.1m 14 Dec 2021 (library: OpenSSL 1.1.1m 14 Dec 2021) Using ACE version: 7.0.3 SkyFire 5.x.x rev. 2bcfa6e1f539 2021-09-05 17:12:54 +0200 (trunk branch) (Win64, Release) (worldserver-daemon) <Ctrl-C> to stop. ______ __ __ __ __ ______ __ ______ ______ /\ ___\/\ \/ / /\ \_\ \/\ ___/\ \/\ == \/\ ___\ \ \___ \ \ _'-\ \____ \ \ __\ \ \ \ __<\ \ __\ \/\_____\ \_\ \_\/\_____\ \_\ \ \_\ \_\ \_\ \_____\ \/_____/\/_/\/_/\/_____/\/_/ \/_/\/_/ /_/\/_____/ Project SkyFireEmu 2011 - 2021(c) Open-sourced Game Emulation <http://www.projectskyfire.org/> DatabasePool world NOT opened. There were errors opening the MySQL connections. Check your SQLDriverLogFile for specific errors. Cannot connect to world database 127.0.0.1;3306;skyfire;skyfire;world
Avatar
what version of MySQL?
Avatar
8.0
Avatar
Did you apply the updates to the world DB?
22:14
I did option 1
22:14
Before I manually ran the sql and then each update file aswell
Avatar
hold on 1 second. I have a solution
22:15
Go to your db installer folder and create a folder called world_updates
22:16
copy the world updates into that folder and It will also apply them
22:17
Later on tonight I will make an updated DB with updates already applied.
Avatar
Sorry do you mean in here?
22:17
22:17
I'm not gonna lie am truly fresh at this.
Avatar
yes
Avatar
Okay then I run option 1 again? I'm going that now/.
Avatar
errors reduced to this
22:29
In mysql_stmt_prepare() id: 184, sql: "SELECT currency, quantity, weekly_quantity, tracked_quantity, flags FROM character_currency WHERE guid = ?" Unknown column 'quantity' in 'field list' In mysql_stmt_prepare() id: 185, sql: "UPDATE character_currency SET quantity = ?, weekly_quantity = ?, tracked_quantity = ?, flags = ? WHERE guid = ? AND currency = ?" Unknown column 'quantity' in 'field list' In mysql_stmt_prepare() id: 186, sql: "REPLACE INTO character_currency (guid, currency, quantity, weekly_quantity, tracked_quantity, flags) VALUES (?, ?, ?, ?, ?, ?)" Unknown column 'quantity' in 'field list'
Avatar
Looking into it.
22:35
you using main or trunk version of the cor?
Avatar
Oh I think Trunk because thats a parameter I had when I pulled from git
Avatar
Use the main. AriDev has Trunk all fucked up.
22:37
The database should be all ok
Avatar
So do I just remove that parameter when pulling?
Avatar
are you using like tortsegit?
Avatar
gitbash
Avatar
just switch to main
22:38
Not sure the command
Avatar
Like switch branches? or
Avatar
yers
Avatar
Alright I'll take some time to redo stuff and hopefully I come back with good news, thank you very much for the help thus far.
Avatar
No Problem
Avatar
Avatar
AlterEgo
No Problem
I believe I've moved past those issues now, moving on to DBC, MAPS, VMAPS, and MMAPS do I need to use a 4.0.6a client for this?
Avatar
5.4.8 18414 maps and dbcs
00:58
406a was discontinued in 2014
Avatar
Avatar
AlterEgo
406a was discontinued in 2014
Any clue where I could get a good torrent for that had some errors when trying it with this Tauri Client?
Avatar
For all those people who find it more convenient to bother you with their question rather than to Google it for themselves.
Avatar
Not to lazy I know how to google, just thankful for your knowledge, if I'm being to bothersome I totally understand that I'll keep trying to find the answers on my own.
Avatar
Because of copyright issues. I am forbidding from supplying links to clients.
Avatar
Yeah that's understandable thank you
Avatar
Finally got to the 4-20 hour part, Thanks alot AlterEgo for the help!
Avatar
420?
Avatar
I feel as if I'm on the verge of seeing the character creation screen
15:36
But another wall to climb
15:37
Never mind im a fucking idiot
15:37
AuthServer not running..
Avatar
Patch your client
Avatar
After two days.. I'm a little slow.
15:43
Actually I'm finally in!
😄 1
👍 1
Avatar
If you got it from a PS you may not need to
Avatar
This took a while hah
Avatar
Congratulations... now you'll need some spawns...
Avatar
naga stole ma bike
16:20
😄
Avatar
How I shot the web GM
Avatar
What happened with @Arivana ? Playing too much, in vacation or no PC access? 😄
Avatar
Jail
😄 1
Avatar
You're serious or kidding with jail? 😄
18:28
He fixed too many bugs on SkyFire and he got jailed by Blizz? 😄🤔
18:29
over 20k commits you have high chances to get in jail... lol.
18:32
WE WANT @Arivana back, I want to install MoP... this time for playing.. 😄
Avatar
SHMEKER1908 13-Jan-22 07:50 PM
хелло
19:50
hello
flirty_emo_030 1
Avatar
You're welcome
21:52
shmeker, shocker... romanski... 🙂
21:54
"de peste Prut", "Timisoara", "La tara","din provincie"...
21:54
Kidding...
21:55
Long-time no see a 5.4.8 private server... .https://stormforge.gg/
21:56
Is that SKyFire or torghast repack 😉 5000+ players online, REALLY? lol
21:57
More than Tauri (approx. 500) and Warmane (approx. 250 online)
Avatar
What an item lol... "Crate of Kidnapped Puppies" 😂
23:48
🤗
Avatar
Hello
22:38
does anyone know how to fix this error?
Avatar
What distro are you using? @Rebekka
Avatar
Avatar
DigiD702
What distro are you using? @Rebekka
Ubuntu 20.10
Avatar
NotInKansas 15-Jan-22 09:21 PM
You compiled on Linux directly?
21:22
HOw much it takes on your disk after compiling?
21:22
few GB?
21:22
8-10 GB of space after compiling on Linux?
21:23
I compiled on Ubuntu both servers SF and TC 335 and every time I get approx. 8-10 GB of disk space...
21:24
on WIndows is approx. 100 MB 😄 lol
Avatar
yes but for server (edited)
21:49
linux is better
Avatar
then you are doing something wrong 8-10GB isn't normal
Avatar
I thought that too
14:58
Everytime when I compile using DTOOLS=0 especially with TC 335 .. on Linux yes. I'll try again with SkyFire 548
02:37
The END is near! 😄
Avatar
Bullshit
Avatar
Why BShit? 😄
14:48
There's an END in everything... the biggest question is WHEN it comes? 😄
14:49
but... the year of 2022 is the perfect moment for it...
14:51
How's the Pandaren area, we can select our faction or not done yet?
14:52
I waited 8 years to leave that Wandering Isle 🤣
14:53
Ragnarok boss is working in Firelands?
Avatar
Avatar
L2S
There's an END in everything... the biggest question is WHEN it comes? 😄
Even if the end comes. What do u want about it?
16:32
All i can ask for in the end is high speed internet working before i face eternity
😄 1
16:32
Watching the best damn porn i can find (edited)
Avatar
They said that there's a "different internet" out there (on the other world, the spirit world) which contains all the memories you've got in your entire life. 😄
18:29
If someone has no memories then NO internet lol...
18:30
All persons with good imagination will have a better connection...
Avatar
Curious
09:21
Where do I find what is supported, since I cannot apparently register with SkyFire 5.4.8?
09:21
>.>
09:21
nevermind
Avatar
You can't register on forum or what?
Avatar
Avatar
L2S
You can't register on forum or what?
fixed. refreshing changed the required information. lol
11:40
the thing didn't refresh after it denied. f5 fixed it. lol
Avatar
Good to know...
Avatar
Avatar
Tycel2004
the thing didn't refresh after it denied. f5 fixed it. lol
What means the year 2004 from your nickname?
12:34
You was born in 2004?
12:35
or you're playing WoW from 2004?
Avatar
That's actually my graduating year.
15:36
lmao
Avatar
ok, just asking.. no probl.
15:39
Has anyone compiled the SkyFire MoP 5.4.8 on Linux Ubuntu recently?! 🤔
15:40
And where is @Arivana ? Long-time no see... 😄🤗
15:40
Mining some crypto or still in jail? 😂
15:41
or maybe he's driving his new Ferrari and no time for SF? ...
Avatar
WW3 is coming... I have a bad feeling 😄
22:40
EU will change its name to USSR ...
22:41
Turkey is changing its name also...
22:41
Erdogan announced it ..
Avatar
Avatar
L2S
Has anyone compiled the SkyFire MoP 5.4.8 on Linux Ubuntu recently?! 🤔
that's what i was going to ask right now
23:25
I have been trying for 2 weeks
23:25
But
23:26
Impossible
23:27
packages that do not exist in the Ubuntu repository or very old versions
23:28
Anyway, if anyone can help me, I'd really appreciate it.
Avatar
Wait a moment pls... 😄
23:37
What version of Ubuntu you have? 16.x, 18.x or 20.x?
23:38
I tried with Ubuntu 18.04 LTS back in 2019-2020 and it was not working (Arivana said that we'll have to UPGRADE to Ubuntu 20.04
23:39
Have you tried with Ubuntu 20.04?
23:40
I still have Ubuntu 18.04 LTS but I want to upgrade to 20 tomorrow... or this weekend.
23:40
Try with Ubuntu 20 and see if it's working...
23:41
16.x and 18.x are not supported by SkyFire from years...
23:42
1. MySQL 8+ 2. Ubuntu 20+ 3. Always have recently libs and programs...
Avatar
I try with ubuntu 20.10
Avatar
Avatar
L2S
Wait a moment pls... 😄
00:14
could that be the problem?
Avatar
Avatar
Rebekka
could that be the problem?
You have two packages which are missing
02:45
install them
02:46
libmysqlclient
02:46
and lib64readline
02:47
try to install them one by one and use terminal
02:47
and compile the server manually
02:47
not from git
02:48
In approx 2-3 days I'll try to upgrade my Ubuntu and I'll try to compile... not on my desk unfortunately
Avatar
Avatar
L2S
libmysqlclient
doesn't work either
Avatar
@AlterEgo Hi boss and sorry for pinging your Ego but we need some help here... 😄 Anyways what they say on Travis? It is compile-friendly or not? Or there's no Travis anymore?
16:47
People trying to compile the SF on Ubuntu 20 and they say that's not working....
Avatar
Hmm
23:12
I will spin up a copy of ucuntu and see what I find. Just been busy with work.
23:14
Don't know why everyone wants to run over to Ubuntu. Debian or CentOS is a much better platform for a server operation. It's way easier to downgrade or upgrade packages.
23:15
I run 52 web servers and all of my hardware runs on CentOS or Cloudlinux. Never an issue with finding the correct packages. Ubuntu just gets retarded.
Avatar
Avatar
AlterEgo
Don't know why everyone wants to run over to Ubuntu. Debian or CentOS is a much better platform for a server operation. It's way easier to downgrade or upgrade packages.
True and +10 on that phrase with Debian but well... there are 80% Ubuntu users (edited)
02:10
🙂
02:11
Also as far as I know CentOS is recommended for web servers and is not so stable as Ubuntu for gaming
02:14
Why me or approx. 80% of Ubuntu users are preferring Ubuntu as a gaming server (and not only) don't ask me 🙂
02:15
We prefer it because it's very easy to use, stable and secure like a fortress 🙂
02:15
If SkyFire is not working with Ubuntu which is the most popular distro ever then .. hell ya 😄
Avatar
Avatar
AlterEgo
I run 52 web servers and all of my hardware runs on CentOS or Cloudlinux. Never an issue with finding the correct packages. Ubuntu just gets retarded.
Do you even have time to human?
02:19
Yeah, sometime I have that feeling too that we're talking with some SKYNET machines... 🙂
Avatar
It's just I personally work 9 to 16 hours a day. I just don't have the time I used to have anymore. I have a major company to run.
Avatar
Great to hear that...
02:35
and my bad that I didn't find the Travis links 🙂
02:35
Travis CI enables your team to test and ship your apps with confidence. Easily sync your projects with Travis CI and you'll be testing your code in minutes.
Avatar
Avatar
Rebekka
doesn't work either
Sorry for pinging... you said that you can't compile on Ubu... on Travis is compiled for Ubu 20 and 21 https://travis-ci.org/github/ProjectSkyfire/SkyFire_548 (edited)
Travis CI enables your team to test and ship your apps with confidence. Easily sync your projects with Travis CI and you'll be testing your code in minutes.
02:39
Ubu 16 and 18 NOT supported .. (18 maybe if you install some programs but I doubt)
Avatar
Wait
Avatar
let's see if i understood
02:41
did you compile skyfire on Ubuntu 20.04
Avatar
Requirements Platform/Architecture: Canonical: Ubuntu 18.04 LTS: x86_32, x86_64 <------ THIS AND UNDER 18 IS NOT SUPPORTED !! Ubuntu 20.04 LTS: x86_32, x86_64 Debian: Debian GNU/Linux 10: x86_32, x86_64 Windows / Windows Server: Windows 10: x86_64 Windows 8.1: x86_64 Windows 2016 Server: x86_64 Windows 2012 Server R2: x86_64 Processor with SSE2 support ACE = 6.4.5 (Linux only) MySQL = 8.0 (Windows / Linux) CMake = 3.20.2/3.16.3 (Windows / Linux) OpenSSL = 1.1.1 (Windows / Linux) GCC = 9.2.1 (Linux only) MS Visual Studio = 16 (2019) (Windows only)
02:42
I observe that SkyFire is compile-friendly on Ubuntu 20+ https://travis-ci.org/github/ProjectSkyfire/SkyFire_548
Avatar
Avatar
Rebekka
did you compile skyfire on Ubuntu 20.04
no, sorry not yet
02:43
I'm still on Ubuntu 18.04
02:44
need some days to backup stuff
02:44
Is not a server or VM
02:44
my personal PC ...
Avatar
Okey np
Avatar
where Ubuntu is installed as primary and the only OS 🙂
Avatar
Me too
Avatar
but I want to upgrade to 20.04
02:45
for testing SkyFire and also playing...
02:48
I also tried MoP Torghast (someone posting it few weeks ago here on SF discord) but it cannot be compiled... (edited)
02:49
and Torghast is on old software like MySQL 5.x (not 8) and for Ubuntu 18
Avatar
I tried SkyFire 5.4.8 in spring 2021 and it was working on Ubuntu 18.04 and compiled but CPU was on IDLE at 8-10% 😛 (edited)
02:50
..and that was the las time when I tried SF (edited)
02:52
but now when I'll upgrade to Ubuntu 20 🙂 guess what... It will be the most happy day in my life cause I'll play MoP again 😄 (edited)
Avatar
Let me know when u compiled skyfire 😅
Avatar
You said that you cannot compile on Ubuntu 20 ?
02:54
yeah.. I bet that I'll have a bad surprise 🙂 lol
02:54
throwing error at 99% like Torghast did
Avatar
I'm not saying don't compile
Avatar
People don't want to accept that Ubuntu is the fastest and most stable OS nowadays ... lol
Avatar
For the guide that I am following it does not work
Avatar
still powerful using OBS Studio which is for recording videos for YouTube
02:58
Linux Ubuntu + WoW + OBS Studio + YouTube = Best solution for streaming and recording.
02:58
OBS Studio is native for Linux
Avatar
OBS is nice
Avatar
but WoW MoP and HeidiSQL needs Lutris and WINE for running on Ubuntu
02:59
yes
03:00
on any Linux distro you have you still need lutris and WINE for running Windows sh1t
Avatar
I never use lutris or wine
Avatar
and how are you playing Wow , ?
03:01
you have separate Windows PC ?
Avatar
oh, that explain... I don't have 😦 lol
Avatar
For work Ubuntu
Avatar
Running everything on Ubuntu ...
Avatar
For game windows
Avatar
I remember that time when I used to play games on my WIndows 7 and I got some warez software and serial numbers from internet and I got tons of trojans and malware... and I DELETED the Windows frm my PC ...forerver and ever. (edited)
Avatar
Loool
Avatar
CHAOS unleashed on my Windows 7 after warez infection 😄 lol
03:04
yeah ...
Avatar
never happened to me
Avatar
Windows 10 is not different but there's still hope with that Essentials from Microsh1t
03:06
it happens when you don't pay attention on Windows and you click OK OK 😄 ENTER / ACCEPT
Avatar
Jajajja
03:07
Or downloads from anywhere
Avatar
When you get malwares, viruses and trojans on your Windows 7 or 10 and you get a window with [X] Close and press on it .. that means ENTER 🙂 (edited)
03:07
I'll never use WIndows in my life lol
Avatar
Trojans 🙂
15:50
😎🤩
15:51
worth seeing...
Avatar
ScarlettCatte 06-Feb-22 04:51 PM
o/
Avatar
ScarlettCatte 06-Feb-22 05:18 PM
oh, nvm. saw your commit messages. yikes
Avatar
wow scarlett? 😄🤔
19:46
there is one server scarlet wow
19:46
i thought it's yours
Avatar
@NomexPlayZ
Avatar
Deleted User 09-Feb-22 12:22 PM
Hello everyone. Can you tell me how well the MOP content is implemented here?