Sry for the trouble

[DestinyFate]

if someone dun mind,pls explain to me and teach me how to fix this,i got it when i tried to add in 9999 seller

1062 - Duplicate entry '978854' for key 1
1062 - Duplicate entry '978857' for key 1
1062 - Duplicate entry '978868' for key 1
1062 - Duplicate entry '978875' for key 1
1062 - Duplicate entry '978870' for key 1
1062 - Duplicate entry '978859' for key 1
1062 - Duplicate entry '978877' for key 1
1062 - Duplicate entry '978881' for key 1
1062 - Duplicate entry '978883' for key 1
1062 - Duplicate entry '978885' for key 1
1062 - Duplicate entry '978890' for key 1
1062 - Duplicate entry '99997' for key 1

thx alot ppl^^

[~WARNING~]

you have to run a query to delete those, or delete them manually, and then run the script again

[cyberghoser1]

the easiest i do when it comes to duplicates is like ibeatuall said delete those existing lines or change the INSERT TO to REPLACE and done

[zspider]

Originally Posted by ibeatuall

you have to run a query to delete those, or delete them manually, and then run the script again

Originally Posted by cyberghoser1

the easiest i do when it comes to duplicates is like ibeatuall said delete those existing lines or change the INSERT TO to REPLACE and done

how u guys can know about if this ids is important or not ??

Originally Posted by DestinyFate

if someone dun mind,pls explain to me and teach me how to fix this,i got it when i tried to add in 9999 seller
1062 - Duplicate entry '978854' for key 1
1062 - Duplicate entry '978857' for key 1
1062 - Duplicate entry '978868' for key 1
1062 - Duplicate entry '978875' for key 1
1062 - Duplicate entry '978870' for key 1
1062 - Duplicate entry '978859' for key 1
1062 - Duplicate entry '978877' for key 1
1062 - Duplicate entry '978881' for key 1
1062 - Duplicate entry '978883' for key 1
1062 - Duplicate entry '978885' for key 1
1062 - Duplicate entry '978890' for key 1
1062 - Duplicate entry '99997' for key 1
thx alot ppl^^

just change this ids for new ones

[cyberghoser1]

incorrect zspider, if the ids are duplicate it means they already exist, this does not mean they are correct or incorrect but since its about the 9900 seller he can do that without anything to loose.

[PraDevil[ELITE]]

ya it's mean like this..?
delete from cq_action where id >=978854 and id <=978890;

[King_Arthur]

Originally Posted by PraDevil

ya it's mean like this..?
delete from cq_action where id =978854 and id=978890;

An id can never be both 978854 and 978890 at the same time so that query will not work. Looks like you need to use "or" or use "between" depending on what you are trying to do.

[PraDevil[ELITE]]

and this?
delete from cq_action where id >=978854 and id <=978890;

or this?

delete from cq_action where id =978854;
delete from cq_action where id =978890;
............

[DestinyFate]

thx everyone,its fixed ^^ now another prob lol,i dunno which files ip i have to change to host,non hamachi,now i messed up and my account server is not link with my npc and msg server anymore

[King_Arthur]

Originally Posted by DestinyFate

thx everyone,its fixed ^^ now another prob lol,i dunno which files ip i have to change to host,non hamachi,now i messed up and my account server is not link with my npc and msg server anymore

From the "How to setup a server!" Sticky:
Everything that says [Hamachi IP] just change use your external IP for non-hamachi.

Originally Posted by Drenferalis

You need to edit the following files:


C:\Server\mannequin\Server\GameServer\config.ini

 Spoiler

; ÅäÖÃÎļþ


[System]
SERVERNAME	= [Server Name]
MONSTER_ACTIVE_LIMIT = 4000


[GameServer]
GAMESERVER_IP	= [HAMACHI IP Address]
GAMESERVER_PORT	= 5816
SND_SIZE		= 64000
RCV_SIZE		= 16000


[Database]
DB_IP			= 127.0.0.1
DB_USER			= root
DB_PW			= test
DB_NAME			= my


[InternetPort]
MASTER_IP	= [Hamachi IP Address]
MASTER_PORT	= 8653
PORT_SIZE	= 53
LOGIN_KEY	= dfkKO23k'[cvK934
CURRENT_PORTID	= 2


[BusySleep]
LEVEL1		= 20	; > 1000 sleep 20%
LEVEL2		= 30	; > 2000
LEVEL3		= 40	; > 3000
LEVEL4		= 50	; > 4000
LEVEL5		= 60	; > 5000

C:\Server\mannequin\Server\GameServer\shell.ini

 Spoiler

; Íâ¿ÇÅäÖÃÎļþ
; 2002.10.23

[System]
MAPGROUP_SIZE		= 1
ACCEPT_MS = 500

[StreamType]
TYPE		= 0	;0=Õý³£´ÓSOCKET£¬1=SOCKET¼Ç¼µ½Îļþ, 2=´ÓÎļþ¶Á(³ÌÐòµ÷ÊÔÓÃ)

[Database]
DB_IP		= 127.0.0.1
DB_USER		= root
DB_PW		= test
DB_DB		= my


[AccountServer]
ACCOUNT_IP			= [Hamachi IP Address]    
ACCOUNT_PORT			= 9865
SERVERNAME			= [Server Name]
LOGINNAME			= root
PASSWORD			= test
; µÇ¼±í³ß´ç, 10-5000
MAXLOGINTABLESIZE=1500
; µÇ¼±í³¬Ê±ÃëÊý£¬0-86400
LOGINOVERTIMESECS=120




[InternetPort]
MASTER_IP	= [Hamachi IP Address]
MASTER_PORT	= 8653
PORT_SIZE	= 53
LOGIN_KEY	= dfkKO23k'[cvK934
CURRENT_PORTID	= 1

C:\Server\mannequin\Server\ACCServer\config.ini

 Spoiler

[System]
LOGINLISTENPORT	= 9958
POINTLISTENPORT = 9865
SERVER_FULL_DELAY_SECS	= 5000
SERVER_BUSY_DELAY_SECS	= 3000
SERVERNAME = [Server Name]
LOGINNAME = root
PASSWORD = test
SERVERIP = [Hamachi IP Address]
[Database]
DBHOSTNAME=127.0.0.1
DATABASENAME=my
DBUSER=root
DBPASSWORD=test

C:\Server\mannequin\Server\ACCServer\account.ini

 Spoiler

[Account1]
SERVERNAME=[SERVER NAME]
LOGINNAME=root
PASSWORD=test
FREE_DEBUG=3

Then you need to use a HEX EDITOR to edit:
C:\Server\mannequin\Server\GameServer\shell.dat

 Spoiler

...

Now you can edit your OEM.ini and OEM.dat, they are in the same format so if you delete oem.dat and modify oem.ini you can make a copy of that one and make the copy oem.dat

C:\Server\ini\oem.ini

 Spoiler

[Oem]
Id=2010
; maybe something else can be here?

[AccountSetup]
Type=1

[ServerInfo]
URL=http://acme.servegame.com/ ;I leave this alone

[ServerStatus]
Link=http://acme.servegame.com/ ;I leave this alone too

[Header]
GroupAmount=1
Group1=[Your Company or Server Group Name]

[Group1]
ServerAmount=[# of servers]

Server1=[Server Name]
Ip1=[Hamachi IP]
Pic1=Server1
ServerName1=[Server Name]

;if more than one server remove the ";" from the beginning of each line and enter your info
;Server2=[Server Name]
;Ip2=[Hamachi IP]
;Pic2=Server2
;ServerName2=[Server Name]

[DestinyFate]

Originally Posted by King_Arthur

From the "How to setup a server!" Sticky:
Everything that says [Hamachi IP] just change use your external IP for non-hamachi.

thx alot^^,so i change all this on my files or the one i let ppl download?or both?sorry again

[PraDevil[ELITE]]

just for make sure..if u make your server wit hamachi..the people must connect to your hamachi

[King_Arthur]

Both. Also, if you have a router you need to configure it to forward the ports to your host computer.