Jump to content
  • 0

[Help] Provlima me .sql files.Rikste mia matia...UPDATED


Question

Posted

Kalimera se olous!Exw katevasei merika custom gia ton server mou.To provlima einai oti otan kanw Execute Batch File m leei to eksis:

 

[Err] 1136 - Column count doesn't match value count at row 1

[Msg] Finished - Unsuccessfull

 

Edw einai o kwdikos gia na riksete mia matia..Alla to idio mou leei kai se alla .sql files!

 

INSERT INTO `weapon` VALUES ('96016', 'Devil Spear', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '419', '10', 'pole', '8', '-3.00000', '0', '0', '0', '325', '0', '234', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96017', 'Medusa Blade', 'rhand', 'true', '2080', '1', '1', 'fine_steel', 's', '400', '40', 'sword', '8', '0.00000', '0', '0', '0', '379', '0', '185', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96018', 'Hades Dagger', 'rhand', 'true', '2080', '1', '1', 'fine_steel', 's', '398', '5', 'dagger', '12', '-3.00000', '0', '0', '0', '433', '0', '197', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96019', 'Thor Hammer', 'rhand', 'true', '2080', '1', '1', 'fine_steel', 's', '425', '20', 'blunt', '4', '0.00000', '0', '0', '0', '379', '0', '192', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96020', 'Odin Cleaver', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '500', '20', 'bigblunt', '4', '4.00000', '0', '0', '0', '325', '0', '215', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96021', 'Artemis Bow', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '825', '20', 'bow', '4', '0.00000', '0', '0', '0', '293', '0', '304', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96022', 'Zeus Mace', 'rhand', 'true', '2080', '1', '1', 'fine_steel', 's', '387', '20', 'blunt', '4', '0.00000', '0', '0', '0', '379', '0', '298', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96023', 'Ares Fists', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '504', '40', 'dualfist', '8', '0.00000', '0', '0', '0', '433', '0', '246', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96024', 'Aphrodite Staff', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '328', '10', 'pole', '8', '-3.00000', '0', '0', '0', '387', '0', '352', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96025', 'Medusa Blade*Medusa Blade', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '512', '20', 'dual', '8', '-3.00000', '0', '0', '0', '325', '0', '225', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96026', 'Hera\'s Rapier', 'rhand', 'true', '2080', '1', '1', 'fine_steel', 's', '455', '10', 'rapier', '8', '-3.00000', '0', '0', '0', '433', '0', '189', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96027', 'Hephaestus Ancient Sword', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '496', '20', 'bigsword', '4', '4.00000', '0', '0', '0', '325', '0', '189', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');
INSERT INTO `weapon` VALUES ('96028', 'Athena\'s Crossbow', 'lrhand', 'true', '2080', '1', '1', 'fine_steel', 's', '517', '5', 'crossbow', '12', '-3.00000', '0', '0', '0', '293', '0', '218', '-1', '48000000', '2440', 'true', 'true', 'true', 'true', '', '', '', '', '0', '-1', '-1', '-1');

 

Ligo help!!!!!!!!!!!!!!!!!!!!!

 

Mporei kapoios na ta prosarmosei gia pack gracia final?An den mporei kaneis kai exei tin kalosuni as valei ena paradeigma edw gia na mporesw na ta kanw monos m! euxaristw!

3 answers to this question

Recommended Posts

  • 0
Posted

Profanos ... kata proton afta ta sql dn teriazoune sto db s.. kai kata deyteron an dn exeis energopiisei. kapoios extra xaraktires dld na mporoun na xrisimopoii8oun. dn ginete na baleis [/] <-- afto...

 

 

...Lol tora to ida... eisai se la8os meros kanonika afto sto help eprepe na to postaris..

 

  • 0
Posted

Perase ta sugkekrimena weapons xeirokinita stin db sou, alliws den ginetai kati. Apla to sugkekrimeno SQL den to dexetai i DB sou.

 

Moved.

  • 0
Posted

y..k egw piga na to parw auto..k mena m bgazei error..alla anagastika..opws leei o XxRxX ( :D ) ..prepei na t kaneis bima bima :/..alla..tha s parei ligi wra

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now


  • Posts

    • what do u mean i want to change the normal weapons some weapons are working perftect some not getting th effect and the arcana has the effect above the weapons as u see ... i dont what is the probkenm
    • Stop paying for files that are already public and free. Here you can download a fully working Interlude server with C4-like gameplay, including source code so you can compile it yourself and verify everything. People will try to convince you that free releases are “broken”, “full of backdoors”, etc. That’s exactly why I’m also providing the SVN with the full source – so you can: Review the code yourself Remove / modify whatever you don’t like Compile your own binaries What’s included GX-EXT Interlude server (C4-style gameplay) – L2Off Client Interlude tweaked for C4 gameplay Public SVN with source code Downloads: Server GX-EXT: https://www.mediafire.com/file/q5ipkjd36tnhfxv/L2OFF_C4_C4_ACU_GXEXT.rar/file Client Interlude C4 Gameplay: https://www.mediafire.com/file/rdkfc8wwau042oh/Cliente_Interlude_Jugabilidad_C4.rar/file SVN (source code, delayed a couple of months to avoid reselling fresh work): https://svn.l2servers.com.ar/!/#GX-EXT_INTERLUDE User: gx Pass: gx How to compile To compile the source you will need: Visual Studio 2005 (x64 toolset) (Classic L2Off toolchain – yes, it’s old, but that’s what the original server uses.) Use this as you want: learn, test, open your own server, or just audit the code. But please, stop buying the same leaked/resold files over and over when you can get them here for free, with source, and actually know what you’re running.  
    • @GX-Ext Please reupload the pack+web+client because all the links inside that post or in the https://l2servers.com.ar/ are dead
    • Weapon dat is not the same for all, since you have custom things for sure no. You can contact @NevesOma
    • hello guys im facing a problem with the weapons .. i want to add hero glow on s weapons arcana ,dragonic bow etc.. some weapons are work peftect .. some not for example i add the line  LineageEffect.e_u092_h for fists and didnt work didnt even get the hero glow.. and the arcana the glow is on the top of weapon not down side like hero zeus mace any ideas?.. or does anybody has the weapongrp.dat file ready ?
  • Topics

×
×
  • Create New...

AdBlock Extension Detected!

Our website is made possible by displaying online advertisements to our members.

Please disable AdBlock browser extension first, to be able to use our community.

I've Disabled AdBlock