Noobish issue...

Syn Rapture

Syn Rapture

Member
Hey guys...

First of all I just want to say how much I enjoy Pwnoz0r's work and how amazing this community and overall project is :)

As you may have guessed by the thread's title, I'm a pretty new (and pretty noob) DayZ server admin, but I just had to open one to play with my friends because there are just 2 decently hosted servers in Argentina and both of them are full of hackers and have awful admins who spawn all kinds of stuff for them and their clans...
So that's why I decided to host a server.

Now the thing is, I have the problem described in this topic: "[1.7.4.4] DayZ Vehicles Not Spawning / Populating DB", (I'm also using v1.7.4.4) but I have no idea where the DB is. I simply installed everything following the instructions in GitHub...


Thanks in advance!




P.S.: The "Player Inventory Config" part in GitHub is missing...
 
Hi Syn,

We were all noobs once. I was a noob that did not give up.

Do you have navicat installed?

Regards,
Luke
 
godheim said:
I started with this video ;)
Click to expand...
Guru's was the first server I set up, but it was a really old version and it had a lot of bugs... Besides, I've seen that video like 1000 times when runing his server and there's nothing there about car spawns U_U
 
Hi Syn,

Most of us still are noobs!

Have you connected your navicat to the database initially?

In order to do this, MySQL has to be running. If it's running there will be a command prompt style window open telling you so - or an easier way is to start the server. If the server is running then your MySQL (almost certainly) is too.

Once mysql is running "Create a new connection" in Navicat. Give it any name you like. The IP address is 127.0.0.1 and your port should be 3316 providing you haven't changed the default settings for it (If you're not sure if you have changed the settings, then you probably have not). Your username and password will both be "root" without the quotation marks.

Once you connect to the MySQL you will see Hivemind appear. That is your database. In that database will be your tables with data stored in them. The functions will also be there. These are the functions you need to edit.


If you get this far, please say so and we can guide you further. If you are still stuck, please screenshot what you are viewing so we can get an idea of where you are up to or what is wrong.
 
Doc said:
Hi Syn,

Most of us still are noobs!

Have you connected your navicat to the database initially?

In order to do this, MySQL has to be running. If it's running there will be a command prompt style window open telling you so - or an easier way is to start the server. If the server is running then your MySQL (almost certainly) is too.

Once mysql is running "Create a new connection" in Navicat. Give it any name you like. The IP address is 127.0.0.1 and your port should be 3316 providing you haven't changed the default settings for it (If you're not sure if you have changed the settings, then you probably have not). Your username and password will both be "root" without the quotation marks.

Once you connect to the MySQL you will see Hivemind appear. That is your database. In that database will be your tables with data stored in them. The functions will also be there. These are the functions you need to edit.


If you get this far, please say so and we can guide you further. If you are still stuck, please screenshot what you are viewing so we can get an idea of where you are up to or what is wrong.
Click to expand...

That was just what I needed!
Vehicles are now spawning... Only 12, but I guess I'll have to check where are the ammounts set.

Thanks a lot, Doc! :)
 
Glad I could help :)

You can find information about setting vehicle spawns in the "Server Admins - Have you configurated your server properly?" in one of pwnzors sub-forums!

I think the DEFAULT number is in pMain or pSpawn but I can't remember which off the top of my head. I'll repost when I have more time :)
 
Just a tip, that trial version of vavicat will expire in 30 days. You might want to uninstall it and do a google search for "navicat100_lite_en". That version will not expire so you won't need to mess around with it again.

Good luck!
 
I also would never advokate torrenting the premium version of Navicat.

To change vehicle numbers it is indeed in pMain (i doubted myself earlier). Change the DEFAULT in line 3 of pMain

Code: 
BEGIN

    DECLARE iSpawnNumVeh SMALLINT(3) DEFAULT 10;

Bare in mind that this number will automatically be decreased if your Maxnum values in object_classes and your spawn locations in object_spawns are not enough. IE if you say 1000 max cars, and you only allow 10 Ikarus's and 0 of everything else, then obviously only 10 Ikarus will spawn. The 10 Ikarus would also be dependent on there being 10 different set spawn points of Ikarus bus in object_spawns. If this needs more elaboration please say so
 
I don't think it is pirated or anything. I just grabbed it off some google search and a site. I think it is just an older version from before they added in the 30day timer. Hell I'd buy a legit copy if they priced it reasonably but $100 is just ridiculous.
 
lol beo, sarcasm doesn't transfer well online. What I am saying is that I would NEVER torrect Navicat Premium.... ;)
 
Doc said:
Glad I could help :)

You can find information about setting vehicle spawns in the "Server Admins - Have you configurated your server properly?" in one of pwnzors sub-forums!

I think the DEFAULT number is in pMain or pSpawn but I can't remember which off the top of my head. I'll repost when I have more time :)
Click to expand...
Yeah, I changed that and the vehicle ammount increased. Thanks again!

beowolfschaefer said:
Just a tip, that trial version of vavicat will expire in 30 days. You might want to uninstall it and do a google search for "navicat100_lite_en". That version will not expire so you won't need to mess around with it again.

Good luck!
Click to expand...
I know, just downloaded the trial version to see if it was the program I needed. Thanks for the heads up :)
 
use heidi sql is open source and a complete tool or mysql workbench community edition from oracle.com or mysql.com
 
mysql workbench is indeed a bit more powerful as it has a lot of functionality that is locked in navicate lite, unlocked. However it can be confusing for beginers.
 
You must log in or register to reply here.
Back
Top