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™]

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™]

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™]

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™]

 

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]

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

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

[Andrew™]

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

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

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

[Red-Hair-Shanks]

poio kwdika 8es;; 

[Andrew™]

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®]

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

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