Super Simple Shop Editor

[Darquise]

Omg dude

I know what a printer is but not in navicat

But I think I already found it

[Natzn]

Can some one show me all in steps. So sample: Step 1 = Make Shop and add an item, after save it. Step 2 = export SQL file (and from there i need help ^^)

 

Greets Natzn

[BlackSheep]

so @ all the dudes wich are laughing at the ppl who dont know what a printer is:

if u are so intelligent, than tell us how its made.?

[Xidus007]

how to open ??

[Koko]

Double click it?...

[Xidus007]

Make Tutorial PLZ!!

[jey91]

I have a problem when I want to import the file...

 

SQL-Befehl: 

-- Items for NPC : Armor Tester

INSERT INTO t_shopitem( a_keeper_idx, a_item_idx )

VALUES -- Items for NPC : Magical Shopkeeper Coen

 

INSERT INTO t_shopitem( a_keeper_idx, a_item_idx )

VALUES ( 226, 781 ) , ( 226, 579 ) , ( 226, 580 ) , ( 226, 581 ) , ( 226, 582 ) , ( 226, 782 ) , ( 226, 583 ) , ( 226, 584 ) , ( 226, 585 ) , ( 226, 586 ) , ( 226, 783 ) , ( 226, 587 ) , ( 226, 588 ) , ( 226, 589 ) , ( 226, 590 ) , ( 226, 784 ) , ( 226, 591 ) , ( 226, 592 ) , ( 226, 593 ) , ( 226, 594 ) , ( 226, 785 ) , ( 226, 595 ) , ( 226, 596 ) , ( 226, 597 ) , ( 226, 598 ) , ( 226, 1121 ) , ( 226, 1122 ) , ( 226, 1123 ) , ( 226, 1124 ) , ( 226, 1125 ) , ( 226, 667 ) , ( 226, 668 ) , ( 226, 669 ) , ( 226, 677 ) , ( 226, 875 ) ;

 

MySQL meldet: Dokumentation

#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 INSERT INTO t_shopitem (a_keeper_idx,a_item_idx) VALUES

(226,781),

(226,579), at line 5

 

pls help (

[diddyhst]

bei mir kommt immer ein error wenn ich die sql auf der databank (newproject_data) machen will. er sagt mir dann immer unsuccusfully im clienten gehts. nur in db nicht

[Koko]

bei mir kommt immer ein error wenn ich die sql auf der databank (newproject_data) machen will. er sagt mir dann immer unsuccusfully im clienten gehts. nur in db nicht
 

Read the rules.

[diddyhst]

when i put the query.sql in the newproject_data it comes an error (unsucusfully) in the client is the item

who i want in this shop but not in the db = i cant buy it (you have canceled the transaction)