Spawnlist File Error

[Red-Hair-Shanks]

magkes kalispera...exw ena problima....paw na balw to sql arxeio mesa stin database kai den to dexete bgazi error....

to pack einai to acis to free revi...

 

[Andrew™]

  On 12/10/2013 at 2:08 PM, ourat1995 said:

magkes kalispera...exw ena problima....paw na balw to sql arxeio mesa stin database kai den to dexete bgazi error....

 

to pack einai to acis to free revi...

 

 

τι sql αρχείο πας να περάσεις ακριβώς? armor-weapon-npc? 

[Red-Hair-Shanks]

spawnlist.....den to pernaei...mou bgazi to error pou sou esteila.....pws bazw to primary key ;;;

[Andrew™]

  On 12/11/2013 at 12:18 AM, ourat1995 said:

spawnlist.....den to pernaei...mou bgazi to error pou sou esteila.....pws bazw to primary key ;;;

πέρνα τα χειροποίητα αν δεν είναι πολλά.

[Red-Hair-Shanks]

1000 einai......tou xronou 8a teteleiwso...exei kapoio kolpo mou eipan to arxeio alla den mou lene poio...

[Andrew™]

  On 12/11/2013 at 12:22 AM, ourat1995 said:

1000 einai......tou xronou 8a teteleiwso...exei kapoio kolpo mou eipan to arxeio alla den mou lene poio...

ανοιξε το με notepad και δες τι γραμμη του κώδικα...αν το table που τα περνάει είναι ίδιο με της Database σου.

[Red-Hair-Shanks]

idio einai...
aftos einai o kodikas...
CREATE TABLE `spawnlist` (

  `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',

  `locx` mediumint(6) NOT NULL DEFAULT '0',

  `locy` mediumint(6) NOT NULL DEFAULT '0',

  `locz` mediumint(6) NOT NULL DEFAULT '0',

  `heading` mediumint(6) NOT NULL DEFAULT '0',

  `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',

  `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'

);

 

INSERT INTO `spawnlist` VALUES

('32043','94108','-105820','-3313','8191','60','0'),

[Andrew™]

  On 12/11/2013 at 12:29 AM, ourat1995 said:

 

idio einai...

aftos einai o kodikas...

CREATE TABLE `spawnlist` (

  `npc_templateid` smallint(5) unsigned NOT NULL DEFAULT '0',

  `locx` mediumint(6) NOT NULL DEFAULT '0',

  `locy` mediumint(6) NOT NULL DEFAULT '0',

  `locz` mediumint(6) NOT NULL DEFAULT '0',

  `heading` mediumint(6) NOT NULL DEFAULT '0',

  `respawn_delay` mediumint(5) NOT NULL DEFAULT '0',

  `periodOfDay` tinyint(1) unsigned NOT NULL DEFAULT '0'

);

 

INSERT INTO `spawnlist` VALUES

('32043','94108','-105820','-3313','8191','60','0'),

 

αλλο το create table και άλλο το inster into...

[Red-Hair-Shanks]

  On 12/11/2013 at 12:31 AM, Andrew™ said:

αλλο το create table και άλλο το inster into...

wraia...ti na kanw gia na to ftia3w ??

[Andrew™]

  On 12/11/2013 at 12:36 AM, ourat1995 said:

wraia...ti na kanw gia na to ftia3w ??

κανε Post εδω τον κωδικα του sql...

αν ειναι πολλές γραμμές κανε μονο τις πρώτες 10 Paste εδω.

[Red-Hair-Shanks]

poio kwdika 8es;; 

[Andrew™]

  On 12/11/2013 at 12:47 AM, ourat1995 said:

poio kwdika 8es;; 

δεξι κλικ στο sql file "edit" Και παρε copy και καντο paste εδω.

[Red-Hair-Shanks]

INSERT INTO `spawnlist` VALUES

('32043','94108','-105820','-3313','8191','60','0'),

('32007','140968','-123600','-1904','18000','60','0'),

('35601','141152','-124272','-1864','10000','60','0'),

('35602','140704','-124020','-1904','34000','60','0'),

('35602','140732','-123796','-1904','2000','60','0'),

('35603','152924','-126604','-2304','33000','60','0'),

('35604','143944','-119196','-2136','1000','60','0'),

('35604','143944','-119196','-2136','1000','60','0'),

('35605','140824','-124844','-1864','10000','60','0'),

('35638','56736','-26400','568','49000','60','0'),

('35639','58128','-32000','301','0','60','0'),

('35640','58024','-25744','592','49000','60','0'),

('35641','58080','-29552','568','49000','60','0'),

('35641','58137','-29223','568','16500','60','0'),

('35642','58024','-26456','592','49000','60','0'),

('31034','-40307','34037','-3595','0','60','0'),

('31034','-38317','45945','-3595','0','60','0'),

('31034','-58353','57473','-3694','0','60','0'),

('31845','-44052','35000','-3340','0','60','0'),

('31850','-43951','35178','-3340','0','60','0'),

[Andrew™]

ωραία, πρώτα τσέκαρε αν έχεις table με όνομα "spawnlist" που σίγουρα έχεις..
μετα δες πόσες γραμμές έχει το table σου...μπορεί δηλαδη το sql να έχει παραπάνω απο οτι χρειάζεται.
συνήθως είναι 7 γραμμές "πλαίσια ή πως αλλιώς το λένε" example: ('31850','-43951','35178','-3340','0','60','0'),

[Red-Hair-Shanks]

exw table....7 grammes exei...

[ExCaLiBuR®]

  On 12/11/2013 at 1:04 AM, ourat1995 said:

exw table....7 grammes exei...

anoikse to table spawnlist trava mia screenshot kai anevasetin na tin dw