In urmatorul tutorial am sa va arat cum sa bagati Freze si carti la Invatatori(gardieni).
Part I-->>Shop
1.Deschidem Navicat
2.Ne conectam
3.Intram in DataBase Player
4.Intram in tabelul Shop
5.Apasam Ctrl+q si va aparea o fereastra noua
6.Apasam Ctrl+n si va aparea o fereastra noua
7.Punem codu de mai jos acolo
8.Dam pe butonul Run
9.Asteptam pana se gata de incarcat
10. Salvam(apasand pe butonul save si introducem un nume oarecare) si dam Reboot

Cod: Selectaţi tot

INSERT INTO `shop` VALUES (1021, 'Noname', 20300);
INSERT INTO `shop` VALUES (1022, 'Noname', 20301);
INSERT INTO `shop` VALUES (1023, 'Noname', 20302);
INSERT INTO `shop` VALUES (1024, 'Noname', 20303);
INSERT INTO `shop` VALUES (1025, 'Noname', 20304);
INSERT INTO `shop` VALUES (1026, 'Noname', 20305);
INSERT INTO `shop` VALUES (1027, 'Noname', 20306);
INSERT INTO `shop` VALUES (1028, 'Noname', 20307);
INSERT INTO `shop` VALUES (1031, 'Noname', 20320);
INSERT INTO `shop` VALUES (1032, 'Noname', 20321);
INSERT INTO `shop` VALUES (1033, 'Noname', 20322);
INSERT INTO `shop` VALUES (1034, 'Noname', 20323);
INSERT INTO `shop` VALUES (1035, 'Noname', 20324);
INSERT INTO `shop` VALUES (1036, 'Noname', 20325);
INSERT INTO `shop` VALUES (1037, 'Noname', 20326);
INSERT INTO `shop` VALUES (1038, 'Noname', 20327);
INSERT INTO `shop` VALUES (1041, 'Noname', 20340);
INSERT INTO `shop` VALUES (1042, 'Noname', 20341);
INSERT INTO `shop` VALUES (1043, 'Noname', 20342);
INSERT INTO `shop` VALUES (1044, 'Noname', 20343);
INSERT INTO `shop` VALUES (1045, 'Noname', 20344);
INSERT INTO `shop` VALUES (1046, 'Noname', 20345);
INSERT INTO `shop` VALUES (1047, 'Noname', 20346);
INSERT INTO `shop` VALUES (1048, 'Noname', 20347);

Part II-->>Shop_Item
1.Deschidem Navicat
2.Ne conectam
3.Intram in DataBase Player
4.Intram in tabelul Shop_Item
5.Apasam Ctrl+q si va aparea o fereastra noua
6.Apasam Ctrl+n si va aparea o fereastra noua
7.Punem codu de mai jos acolo
8.Dam pe butonul Run
9.Asteptam pana se gata de incarcat
10. Salvam(apasand pe butonul save si introducem un nume oarecare) si dam Reboot

Cod: Selectaţi tot

INSERT INTO `shop_item` VALUES (1021, 50401, 1);
INSERT INTO `shop_item` VALUES (1021, 50402, 1);
INSERT INTO `shop_item` VALUES (1021, 50403, 1);
INSERT INTO `shop_item` VALUES (1021, 50404, 1);
INSERT INTO `shop_item` VALUES (1021, 50405, 1);
INSERT INTO `shop_item` VALUES (1021, 50513, 1);
INSERT INTO `shop_item` VALUES (1021, 71001, 200);
INSERT INTO `shop_item` VALUES (1021, 71094, 200);
INSERT INTO `shop_item` VALUES (1021, 73001, 1);
INSERT INTO `shop_item` VALUES (1021, 73002, 1);
INSERT INTO `shop_item` VALUES (1021, 73003, 1);
INSERT INTO `shop_item` VALUES (1021, 73004, 1);
INSERT INTO `shop_item` VALUES (1021, 73005, 1);