[RELEASE]ShadeCO source

laurytalvi · 01/11/2009, 21:23

Well, is it so hard then?

Firstly download xampp from here

Then goto mysql, import lol.sql

goto
Shade CO SOURCE v1.121\Shade CO SOURCE v1.121\COServerProject1\COServerProject\bin\Debug

open config.ini and change these to

[Server]
ServerIP="the server ip(mostly 127.0.0.1 or hamachi ip"
XPRate= "ur servers experience rate goes here"
ProfXPRate= "servers profiency xp rate goes here"
DBUserName = "ur localhost/phpmyadmin username"
DBUserPass = "ur localhost/phpmyadmin password"
CODirectory = "ur co directory"

goto ur co client folder and open cidserver.dat/server.dat and change the ip whats there to the ip u putted to config.ini server ip

Now go to

Shade CO SOURCE v1.121\Shade CO SOURCE v1.121\COServerProject1\COServerProject\bin\Debug

and run Shade-Co.exe

And woila. Ur done. Was that seriously so hard then?

LegendsReborn · 01/12/2009, 07:44

Server: localhost Database: shadecoproject
Error
SQL query:

--
-- Database: `shadecoproject`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE `accounts` (

`AccountID` varchar( 16 ) NOT NULL DEFAULT '',
`Password` varchar( 64 ) NOT NULL DEFAULT '',
`LogonType` int( 8 ) unsigned NOT NULL DEFAULT '0',
`LogonCount` int( 10 ) unsigned NOT NULL DEFAULT '0',
`Status` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Charr` varchar( 16 ) NOT NULL DEFAULT '',
`AccNr` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`Online` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Email` varchar( 255 ) NOT NULL ,
`SecretQuestion` varchar( 255 ) NOT NULL ,
`Answer` varchar( 255 ) NOT NULL ,
`Identification` varchar( 8 ) NOT NULL ,
`WebPassword` varchar( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `AccNr` ) USING BTREE
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said:

#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

damianpesta · 01/12/2009, 09:21

Quote:

Originally Posted by LegendsReborn

Server: localhost Database: shadecoproject
Error
SQL query:

--
-- Database: `shadecoproject`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE `accounts` (

`AccountID` varchar( 16 ) NOT NULL DEFAULT '',
`Password` varchar( 64 ) NOT NULL DEFAULT '',
`LogonType` int( 8 ) unsigned NOT NULL DEFAULT '0',
`LogonCount` int( 10 ) unsigned NOT NULL DEFAULT '0',
`Status` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Charr` varchar( 16 ) NOT NULL DEFAULT '',
`AccNr` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`Online` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Email` varchar( 255 ) NOT NULL ,
`SecretQuestion` varchar( 255 ) NOT NULL ,
`Answer` varchar( 255 ) NOT NULL ,
`Identification` varchar( 8 ) NOT NULL ,
`WebPassword` varchar( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `AccNr` ) USING BTREE
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said:

#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

DUDE make a database called shadecoproject or w/e it is and import db ... Whats soo hard in it? Do i have to write a book about Importing database?... ***

whoaloser · 01/12/2009, 10:40

the file to download has a password protection

laurytalvi · 01/12/2009, 13:36

Quote:

Originally Posted by whoaloser

the file to download has a password protection

Look at page 2 or 3.

~~Xanrry~~ · 01/12/2009, 21:10

Need downlod link

laurytalvi · 01/12/2009, 22:11

Quote:

Originally Posted by Yasmin*

Need downlod link

WOW, ppl are so stupid that they cant even chck the first page for source? LMAO

LegendsReborn · 01/13/2009, 00:40

Quote:

Originally Posted by damianpesta

DUDE make a database called shadecoproject or w/e it is and import db ... Whats soo hard in it? Do i have to write a book about Importing database?... ***

dude.. i already made the database.. and when i import it it gives me this error

Code:

MySQL said: 

#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

justprownage · 01/13/2009, 01:45

Quote:
Originally Posted by LegendsReborn
dude.. i already made the database.. and when i import it it gives me this error
Code:
MySQL said: 

#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

To use this source, you must have a brain.

LegendsReborn · 01/13/2009, 01:54

Quote:

Originally Posted by justprownage

To use this source, you must have a brain.

i do have one -.-.. so how do i fix that error up there? i have shadecoproject as database.. and when i execute the lol.sql it gives me that error..

justprownage · 01/13/2009, 01:58

Quote:

Originally Posted by LegendsReborn

i do have one -.-.. so how do i fix that error up there? i have shadecoproject as database.. and when i execute the lol.sql it gives me that error..

LegendsReborn · 01/13/2009, 02:43

Quote:

Originally Posted by justprownage

i still get this error.. -.-

Script line: 22 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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

justprownage · 01/13/2009, 03:44

Quote:

Originally Posted by LegendsReborn

i still get this error.. -.-

Script line: 22 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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

Try it with

instead of navicat/SQL gui tool.

LegendsReborn · 01/13/2009, 08:25

Quote:

Originally Posted by justprownage

Try it with instead of navicat/SQL gui tool.

lol...

Server: localhost Database: shadecoproject
Error
SQL query:

--
-- Database: `shadecoproject`
--
-- --------------------------------------------------------
--
-- Table structure for table `accounts`
--
CREATE TABLE `accounts` (

`AccountID` varchar( 16 ) NOT NULL DEFAULT '',
`Password` varchar( 64 ) NOT NULL DEFAULT '',
`LogonType` int( 8 ) unsigned NOT NULL DEFAULT '0',
`LogonCount` int( 10 ) unsigned NOT NULL DEFAULT '0',
`Status` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Charr` varchar( 16 ) NOT NULL DEFAULT '',
`AccNr` int( 10 ) unsigned NOT NULL AUTO_INCREMENT ,
`Online` int( 8 ) unsigned NOT NULL DEFAULT '0',
`Email` varchar( 255 ) NOT NULL ,
`SecretQuestion` varchar( 255 ) NOT NULL ,
`Answer` varchar( 255 ) NOT NULL ,
`Identification` varchar( 8 ) NOT NULL ,
`WebPassword` varchar( 255 ) NOT NULL DEFAULT '',
PRIMARY KEY ( `AccNr` ) USING BTREE
) ENGINE = MYISAM DEFAULT CHARSET = latin1 AUTO_INCREMENT =2;

MySQL said:

#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 'USING BTREE
) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=2' at line 15

[ Back

medooo · 01/13/2009, 08:44

i have the same problem too !!!

when i tried navicat i checked continue on errors
but when its finished it didn't make accounts table

sorry if my english is bad !!!