[RELEASE]ShadeCO source

01/11/2009 21:23 laurytalvi#31
Well, is it so hard then?

Firstly download xampp from here

[Only registered and activated users can see links. Click Here To Register...]

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?
01/12/2009 07:44 LegendsReborn#32
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
01/12/2009 09:21 damianpesta#33
Quote:
Originally Posted by LegendsReborn View Post
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?... god
01/12/2009 10:40 whoaloser#34
the file to download has a password protection :(
01/12/2009 13:36 laurytalvi#35
Quote:
Originally Posted by whoaloser View Post
the file to download has a password protection :(
Look at page 2 or 3.
01/12/2009 21:10 Xanrry#36
Need downlod link
01/12/2009 22:11 laurytalvi#37
Quote:
Originally Posted by Yasmin* View Post
Need downlod link
WOW, ppl are so stupid that they cant even chck the first page for source? LMAO
01/13/2009 00:40 LegendsReborn#38
Quote:
Originally Posted by damianpesta View Post
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?... god

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
01/13/2009 01:45 justprownage#39
Quote:
Originally Posted by LegendsReborn View Post
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.
01/13/2009 01:54 LegendsReborn#40
Quote:
Originally Posted by justprownage View Post
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..
01/13/2009 01:58 justprownage#41
Quote:
Originally Posted by LegendsReborn View Post
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..
[Only registered and activated users can see links. Click Here To Register...]
01/13/2009 02:43 LegendsReborn#42
Quote:
Originally Posted by justprownage View Post
[Only registered and activated users can see links. Click Here To Register...]
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
01/13/2009 03:44 justprownage#43
Quote:
Originally Posted by LegendsReborn View Post
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 [Only registered and activated users can see links. Click Here To Register...] instead of navicat/SQL gui tool.
01/13/2009 08:25 LegendsReborn#44
Quote:
Originally Posted by justprownage View Post
Try it with [Only registered and activated users can see links. Click Here To Register...] 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
01/13/2009 08:44 medooo#45
i have the same problem too !!! :confused:
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 !!!