- Joined
- Oct 1, 2005
- Messages
- 387
- Reaction score
- 0
yes of course, give me pm your msn i will give you the link since i can not post link anymore....
Why can you not post the link any more
yes of course, give me pm your msn i will give you the link since i can not post link anymore....
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 !
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
nope
i will tell later cuz i'm willing to update with a new db well acctualy i updated but i forgot to post the link and i lost itsilly me
))
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.
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
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.
damned u put me on to work again but thx)) and a realy nice "u should say this earlyer"
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;