Kobold install?

i've updated my thread with a new sql file all in one so u just have to upload that one and nothing more now i'm gonna update again with lift and tramps working as i find the bug source
 
well i don't know, everytime i post a thread with a link or even in pm, it redirects me in main page, i guess it's because of the infraction warn i have...too bad...belgium ? i was living there for 15 years !


to bad then that you can post something

maby you coud do somthing like this

Hxxp:/and than your link that coud work :o)
 
I'm pretty new to SQL so I'm not 100% sure what to edit so that others can use my server.
world_server.conf change the IP to my own...
realm_server.conf same...
login_server.conf ...this is gettin old.
What else? Or should I not edit those. I did search, little vuage besides setting it up for a SP server.
 
I'm pretty new to SQL so I'm not 100% sure what to edit so that others can use my server.
world_server.conf change the IP to my own...
realm_server.conf same...
login_server.conf ...this is gettin old.
What else? Or should I not edit those. I did search, little vuage besides setting it up for a SP server.

Im not sure of this!!! <<

But if im right .. then thats not the correct to do..

Go to realm_server.conf and remove the # in front of "# RealmConnectAddress = xxx"

So it says: "RealmConnectAddress = <YOURIP>"

I haven't tested this, but as far as I would see logic in it , that would be all .. Dont hang me on that one though.. Im sure Kennythekid or some of the devs or other hosters in here will know :P

Peace, Drake :group:
 
Ok dudes' new relese check it out

kenny_repackv2.sql
change log:
- original sql with char. working
- mongos_repack.sql i little bit better (as i check my server logs i so some changes)
- the lift/tramps working debug found it today
- all set up just change ips in realm and worldserver delete accounts
 
Ok dudes' new relese check it out

kenny_repackv2.sql
change log:
- original sql with char. working
- mongos_repack.sql i little bit better (as i check my server logs i so some changes)
- the lift/tramps working debug found it today
- all set up just change ips in realm and worldserver delete accounts

wait , dont you forget something?!

Read the "Pet" thread thingy.. Theres a great WORKING fix to fix pets for hunters there!!

http://forum.ragezone.com/world-warcraft/kobold-collapse-call-pet-181226.html

Open Navicat.
Rename or delete database pet_store.
Open Query.
Copy this string inyo query window.

CREATE TABLE `pet_store` (
`id` int(10) unsigned NOT NULL default '0',
`positionX` float NOT NULL default '0',
`positionY` float NOT NULL default '0',
`positionZ` float NOT NULL default '0',
`orientation` float NOT NULL default '0',
`zoneId` int(11) NOT NULL default '38',
`mapId` int(11) NOT NULL default '0',
`data` longtext NOT NULL,
`indepData` longtext NOT NULL,
`name_id` int(11) NOT NULL default '0',
`moveType` int(11) NOT NULL default '0',
`running` int(11) NOT NULL default '0',
`spawnTime1` smallint(5) unsigned NOT NULL default '10',
`spawnTime2` smallint(5) unsigned NOT NULL default '10',
`spawnDist` float NOT NULL default '5',
`currentWaypoint` int(10) NOT NULL default '0',
`spawnX` float NOT NULL default '0',
`spawnY` float NOT NULL default '0',
`spawnZ` float NOT NULL default '0',
`spawnOrient` float NOT NULL default '0',
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1


run this query.
Call pet working properly now. Tested.

Thanks SvatyPatejl

Its easy to make a little .sql file that deletes the current pet_store and creates that one..
Btw. no offence, I really admire your work Kenny :) Keep it up! Kobold ftw! :D

-Drake
 
Last edited:
i found some info about guilds_ranks
as is something wrong there and i rename that thing
DO THIS:

Code:
CREATE TABLE `guilds_ranks` (
  `guildId` int(6) unsigned NOT NULL default '0',
  `rank` varchar(255) NOT NULL default '',
  `rights` int(3) unsigned NOT NULL default '0'
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

i didn't test it that why i didn't upload it in the sql file
i don't have testers atm just 2 friends :) maybe u could do it and tell me the results
thx
 
Im ready for testing, thats np :) I just need an exact explenation on what the bug WAS, and what I should be able to do :) Ill then check it before I install the fix, and then after :)

Cheers! Drake :group:
 
Back