[OsRose(Evo)] Server Setup Guide

[Zaraki Kenpachi]

wonderful (:

[meruR1]

NPCs are loaded from SQL table list_npc

Did you load that into your database?

if you are talking about navicat lite> mysql> tables> list_npcs or list_npcs_special

i did it but aint working..

what i did: [aint sure if its right thou]
i went to navicat lite> roseon> tables
then copied list_npcs and list_npcs_special
then pasted it at navicat lite> mysql> tables

[Purpleyouko]

if you are talking about navicat lite> mysql> tables> list_npcs or list_npcs_special

i did it but aint working..

what i did: [aint sure if its right thou]
i went to navicat lite> roseon> tables
then copied list_npcs and list_npcs_special
then pasted it at navicat lite> mysql> tables

list_npcs.sql is a QUERY file
A Query is a set of instructions for your database manager (navicat) to create a database table
you can't just paste it into place.
You have to "run" it as a query.

personally I absolutely hate navicat and never use it.
If you use Xampp as you web server then it already contains a database manager called phpmyadmin. All you have to do is copy the phpmyadmin folder into the htdocs folder then use a browser to go to localhost\phpmyadmin and you can import and export sql files so easily.

[mirage99]

Can someone re post the Server Files Ver. 81 please, the link doesn't seem to be working

[GeNyaa]

They are working...
If I click the link it's still up and running...
Just try it again ;)
It works fine.

[mirage99]

for some reason my firefox and my ie is not letting me download from those url links. Can you be kind to post some mirrors up please ?

[GeNyaa]

I will reupload them when I get on my Server PC ;)
That will be in the evening (Dutch Time)

[meruR1]

list_npcs.sql is a QUERY file
A Query is a set of instructions for your database manager (navicat) to create a database table
you can't just paste it into place.
You have to "run" it as a query.

personally I absolutely hate navicat and never use it.
If you use Xampp as you web server then it already contains a database manager called phpmyadmin. All you have to do is copy the phpmyadmin folder into the htdocs folder then use a browser to go to localhost\phpmyadmin and you can import and export sql files so easily.

sorry if im buggin you but i still got some errors..
in phpmyadmin
i tried to run in query list_npcs and list_npcs_special
but when i do an error says

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '`id``name``type``map``dir``x``y``dialogid``eventid``tempdialogid` LIMIT 0, 30' at line 1

before going back here i tried to google search for this prob but none of them helped me ... i also tried to look for something
in mysql folder.. but i didnt have much progress..

now, npcs still arent working..

[GeNyaa]

list_npcs del that in your database.
And do what u did before ;)

[Purpleyouko]

yup
My bet is that the SQl doesn't include the command to delete the table if it already exists.

Try opening the SQL table in a text editor such as notepad++ (you can download this free. just google it)

at the top of the file you will see this

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for list_npcs
-- ----------------------------
CREATE TABLE `list_npcs` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`map` int(11) NOT NULL,
`dir` float NOT NULL,
`x` float NOT NULL,
 `y` float NOT NULL,
 `dialogid` int(11) NOT NULL default '0',
 `eventid` int(11) NOT NULL default '0',
 `tempdialogid` int(11) NOT NULL default '0',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
INSERT INTO `list_npcs` VALUES (0, '[Livestock Farmer] Lampa', 1016, 1, 173.934, 5109.42, 5363.68, 116,0,0);

followed by a couple of hundred lines of text loading the data into the DB table.

What you need is this

SET FOREIGN_KEY_CHECKS=0;
-- ----------------------------
-- Table structure for list_npcs
-- ----------------------------
DROP TABLE IF EXISTS `list_npcs`;
CREATE TABLE IF NOT EXISTS `list_npcs` (
`id` int(11) NOT NULL auto_increment,
`name` varchar(255) NOT NULL,
`type` int(11) NOT NULL,
`map` int(11) NOT NULL,
`dir` float NOT NULL,
`x` float NOT NULL,
 `y` float NOT NULL,
 `dialogid` int(11) NOT NULL default '0',
 `eventid` int(11) NOT NULL default '0',
 `tempdialogid` int(11) NOT NULL default '0',
 PRIMARY KEY  (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=1 DEFAULT CHARSET=latin1;
INSERT INTO `list_npcs` VALUES (0, '[Livestock Farmer] Lampa', 1016, 1, 173.934, 5109.42, 5363.68, 116,0,0);

Making these tiny changes will make the query automatically delete the existing table then create it new.

OR

You can manually delete teh table then run the existing query just as Aukemon0NL suggested

[lmame]

Yeah we never (well there shouldn't be any) drop the mysql table in our .sql file.
We do this because a failure is better than just loosing the table and all the data inside (for example accounts, characters, items and so on) as some people just don't backup their data.

[mirage99]

If you reupload your downloads, i am still unable to download them for some reason

[GeNyaa]

http://www.hode.nl/rose/rev_81_server_files.zip
That's the server files...
If this 1 isn't working.
I will upload them to Rapishare or something like that :)

[mirage99]

http://www.hode.nl/rose/rev_81_server_files.zip
That's the server files...
If this 1 isn't working.
I will upload them to Rapishare or something like that :)

May i request to have this uploaded to rapidshare or megaupload please

that link you posted up, is still not working for me.

[mirage99]

Were you able to upload some of your links to some mirrors. If your busy with other stuff, I can wait.