Dotaz cislo:1
SELECT Name, Value FROM _config

Dotaz cislo:2
SELECT * FROM _language WHERE Id=1
select properties of object language
Dotaz cislo:3
SELECT * FROM template_page2lang WHERE Domain = 'dev.ai-shop.cz'
select properties of object template_page
Dotaz cislo:4
SELECT * FROM redirects WHERE URLOld='fotogalerie'
select id of inserted redirects from db
Dotaz cislo:5
SELECT * FROM virtual_directory2lang WHERE Name LIKE 'fotogalerie'
select properties of object virtual_directory2lang
Dotaz cislo:6
SELECT * FROM virtual_directory WHERE Id=7302
select properties of object virtual_directory
Dotaz cislo:7
SELECT * FROM virtual_directory2lang WHERE IdDirectory = 7302
select properties of object VirtualDirectory2lang::=Get
Dotaz cislo:8
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7302'
select properties of object virtual_directpry_set
Dotaz cislo:9
SELECT * FROM _language WHERE Id=1
select properties of object language
Dotaz cislo:10
SELECT * FROM virtual_directory WHERE Id=7302
select properties of object virtual_directory
Dotaz cislo:11
SELECT * FROM virtual_directory2lang WHERE IdDirectory=7302 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:12
SELECT s.* FROM virtual_directory_set s WHERE s.IdDirectory = '7302'
select properties of object virtual_directpry_set
Dotaz cislo:13
SELECT * FROM exchange WHERE Id='37';
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsExchange.php on line 186 in method Cexchange::loadById
Dotaz cislo:14
SELECT Id, CONCAT(Name,' ',Surname) as Login,LogPassword,LogPasswordType, LogHash FROM security_user SU WHERE ((LogName='!Annonym') AND Flags&1) OR (LogHash ='' AND Loghash IS NOT NULL AND Loghash <>'' AND LogHashExpire > NOW() )
login user
Dotaz cislo:15
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=2 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:16
SELECT * FROM security_user2group WHERE IdUser=2
select groups of security_user
Dotaz cislo:17
call getRightsForUser(2, 52)
load rights
Dotaz cislo:18
SELECT * FROM company2user WHERE (1=1) AND IdUser = '2'
select properties of object company2user
Dotaz cislo:19
SELECT * FROM company WHERE Id=1
select properties of object company
Dotaz cislo:20
SELECT * FROM company2user WHERE (1=1) AND IdCompany = '1'
select properties of object company2user
Dotaz cislo:21
SELECT su.*, c.IdCostType as CostTypeId, c.Rabat as CompanyDiscount, sct.Discount as CostTypeDiscount, c.Flags & 128=128 as CompanyIndividualPrice, sct.ViewPriceWithVat, a.IdState FROM security_user su LEFT JOIN company2user c2u ON c2u.IdUser = su.Id /*AND c2u.IdType = 1*/ LEFT JOIN company c ON c.Id=c2u.IdCompany LEFT JOIN address a ON a.Id=c.IdPayementAddress LEFT JOIN shop_cost_type sct ON sct.Id=c.IdCostType WHERE su.Id=2 ORDER BY c2u.IdType LIMIT 0, 1
select properties of object security_user
Dotaz cislo:22
SELECT * FROM security_user2group WHERE IdUser=2
select groups of security_user
Dotaz cislo:23
SELECT * FROM template_page
select properties of object template_page
Dotaz cislo:24
SELECT * FROM template_page WHERE Id=29
select properties of object template_page
Dotaz cislo:25
SELECT * FROM template_page2lang WHERE IdPage=29 AND IdLanguage=1
select properties of object template_page
AiShop | Galerie | E-Shop kvalitně

Dotaz cislo:52
SELECT * FROM section WHERE Id=237
select properties of object section
Dotaz cislo:53
SELECT * FROM section_sec2lang WHERE IdSection=237 AND IdLanguage=1
select properties of object section_sec2lang

POZOR, TOTO JE POUZE DEMO ESHOPU, NIC ZDE NEKUPUJTE !
Začínáte podnikat a hledáte kvalitní e-shopové řešení, které se vám přizpůsobí? Podnikáte a hledáte kvalitní e-shop na míru? Pojďme společně vybudovat úspěšný business. www.ai-shop.cz

Dotaz cislo:54
SELECT * FROM section WHERE Id=263
select properties of object section
Dotaz cislo:55
SELECT * FROM section_sec2lang WHERE IdSection=263 AND IdLanguage=1
select properties of object section_sec2lang

Dotaz cislo:56
call getRightsForUser(2, 78)
load rights
Dotaz cislo:57
SELECT s.Id, s.IdParent as IdParent, s2l.Title as Title , '' as TargetTarget , s2l.Link as Name , s2l.Flags FROM menu_items s INNER JOIN menu_items2lang s2l ON s.Id=s2l.IdMenuItem AND s2l.IdLanguage = 1 AND s2l.Flags & 1 /*INNER JOIN virtual_directory vd ON vd.IdSecuritySection=s.IdSecuritySection AND vd.IdItem=s.IdItem INNER JOIN virtual_directory2lang vd2l ON vd.Id = vd2l.IdDirectory AND vd2l.IdLanguage=1*/ WHERE s.IdParent=1 AND s.Id IN (0, 1, 255, 256, 257, 258, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 284, 286, 287, 288, 289, 290, 291, 292, 294, 295, 296, 297, 298, 299, 300) ORDER BY colOrder LIMIT 6

Dotaz cislo:58
SELECT s.Id, s.IdParent as IdParent, s2l.Title as Title , '' as TargetTarget , s2l.Link FROM menu_items s INNER JOIN menu_items2lang s2l ON s.Id=s2l.IdMenuItem AND s2l.IdLanguage = 1 AND s2l.Flags & 1 WHERE s.IdParent=286. AND s.Id IN (0, 1, 255, 256, 257, 258, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 284, 286, 287, 288, 289, 290, 291, 292, 294, 295, 296, 297, 298, 299, 300) ORDER BY colOrder

Dotaz cislo:59
SELECT s.Id, s.IdParent as IdParent, s2l.Title as Title, '' as TargetTarget , s2l.Link FROM menu_items s INNER JOIN menu_items2lang s2l ON s.Id=s2l.IdMenuItem AND s2l.IdLanguage = 1 AND s2l.Flags & 1 WHERE s.IdParent in (272,289,288,290,292) AND s.Id IN (0, 1, 255, 256, 257, 258, 268, 269, 270, 271, 272, 273, 274, 275, 276, 277, 278, 284, 286, 287, 288, 289, 290, 291, 292, 294, 295, 296, 297, 298, 299, 300) ORDER BY colOrder

Dotaz cislo:60
SELECT * FROM section WHERE Id=263
select properties of object section
Dotaz cislo:61
SELECT * FROM section_sec2lang WHERE IdSection=263 AND IdLanguage=1
select properties of object section_sec2lang

Dotaz cislo:62
SELECT * FROM virtual_directory2lang WHERE IdDirectory=6127 AND IdLanguage=1
select properties of object virtual_directory2lang
Dotaz cislo:63
SELECT * FROM virtual_directory2lang WHERE IdDirectory=2163 AND IdLanguage=1
select properties of object virtual_directory2lang
Přihlásit

Přihlášení

E-mail

Heslo
Ztratili jste heslo?

Registrace

Přihlášení Seznam.cz
Dotaz cislo:65
SELECT * FROM _language WHERE (1=1) AND Flags & '1' ORDER BY colOrder ASC
select properties of object language
CZ
- EN
Dotaz cislo:66
SELECT * FROM exchange WHERE (1=1) AND Flags & '1' ORDER BY colOrder ASC
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsExchange.php on line 312 in method Cexchange::get
CZK
- EUR
- USD

Dotaz cislo:67
SELECT * FROM section WHERE Id=119
select properties of object section
Dotaz cislo:68
SELECT * FROM section_sec2lang WHERE IdSection=119 AND IdLanguage=1
select properties of object section_sec2lang

Dotaz cislo:69
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=1 AND v.IdSecuritySection = 33
select id of inserted virtual_directory from db

Dotaz cislo:70
SELECT c.Id as Id, c.IdParent, CASE WHEN c2l.ShortName != '' THEN c2l.ShortName ELSE c2l.Name END AS Name, vd2l.`Name` as VD, i.Filename as Img, /*i2.Filename as Img2,*/ c.Color, c2l.Flags FlagsLang FROM shop_cat_tree c INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.Flags & 1 = 1 AND c2l.IdLanguage = 1 INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND c.Id=vd.IdItem INNER JOIN virtual_directory2lang vd2l ON vd2l.IdDirectory=vd.Id AND vd2l.IdLanguage=1 LEFT JOIN shop_cat2img c2i ON c2i.IdCategory = c.Id AND c2i.Flags & 4 LEFT JOIN images i ON i.Id = c2i.IdImage /*LEFT JOIN shop_cat2img c2i2 ON c2i2.IdCategory = c.Id AND c2i2.Flags & 1 LEFT JOIN images i2 ON i2.Id = c2i2.IdImage*/ WHERE /*c.IdParent<>0 AND ((c.Id in () AND c.IdParent=0) OR (c.IdParent<>0 AND c.IdParent<>0)) AND c.Id in () AND c.Flags & 1 AND*/ c2l.Name<>'' ORDER BY /*c.IdParent,*/ c.colOrder

Dotaz cislo:71
SELECT i2l.* FROM menu_items i INNER JOIN menu_items2lang i2l ON i.Id=i2l.IdMenuItem AND i2l.IdLanguage=1 AND i2l.Flags & 1 WHERE i.IdParent=268 ORDER BY colOrder
nebylo zadano
Dotaz cislo:72
SELECT * FROM images WHERE Id=1299
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load
Dotaz cislo:73
SELECT * FROM images WHERE Id=1287
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsImageUpload.php on line 438 in method CimageUpload::load

Kategorie
Výrobce

Dotaz cislo:74
SELECT c.Id, c2l.Name, vd2l.Name as Url, count(child.IdParent) as cntChild, c.IdParent, parent.IdParent as IdParentParent , img.Filename, c.Color FROM shop_cat_tree c INNER JOIN shop_cat_tree2lang c2l ON c.Id=c2l.IdCat AND c2l.IdLanguage=1 AND (c2l.Flags & 1) INNER JOIN virtual_directory vd ON vd.IdSecuritySection=16 AND vd.IdItem=c.Id INNER JOIN virtual_directory2lang vd2l ON vd.Id=vd2l.IdDirectory AND vd2l.IdLanguage=1 LEFT JOIN shop_cat_tree parent ON c.IdParent=parent.Id LEFT JOIN shop_cat_tree child ON c.Id=child.IdParent LEFT JOIN shop_cat2img c2img ON c.Id=c2img.IdCategory AND (c2img.Flags & 4) LEFT JOIN images img ON c2img.IdImage=img.Id WHERE c.IdParent=0 GROUP BY c.Id ORDER BY c.colOrder

Dotaz cislo:75
SELECT t1.*, t2.* FROM shop_producer t1 INNER JOIN shop_producer2lang t2 ON t2.IdProducer = t1.Id AND t2.IdLanguage = 1 ORDER BY t2.Name
question from /mnt/storage1/vhosts/ai-shop.cz/web/dev/_includes/clsShop.php on line 322 in method CShopProducer::get
Dotaz cislo:76
SELECT * FROM shop_producer2lang WHERE IdProducer = '14'
select properties of object shop_search2art_cat
AiVisionDotaz cislo:78
SELECT * FROM shop_producer2lang WHERE IdProducer = '17'
select properties of object shop_search2art_cat
Dotaz cislo:79
SELECT * FROM shop_producer2lang WHERE IdProducer = '16'
select properties of object shop_search2art_cat
Shenzhen Jumaoyuan Science And Technology Co.,Ltd.

Dotaz cislo:81
SELECT * FROM section WHERE Id=201
select properties of object section
Dotaz cislo:82
SELECT * FROM section_sec2lang WHERE IdSection=201 AND IdLanguage=1
select properties of object section_sec2lang

Dotaz cislo:83
SELECT * FROM section WHERE Id=17
select properties of object section
Dotaz cislo:84
SELECT * FROM section_sec2lang WHERE IdSection=17 AND IdLanguage=1
select properties of object section_sec2lang

Kontakt

AIVision, s.r.o.

Veverkova 731/19
170 00 Praha 7

IČO: 27131955
DIČ: CZ27131955

+420 233 370 498
+420 608 224 380

info@aivision.cz
www.aivision.cz

Dotaz cislo:26
call getRightsForUser(2, 30)
load rights
Dotaz cislo:27
SELECT * FROM gallery_tree g INNER JOIN gallery_tree2lang g2l ON g.Id=g2l.IdCat WHERE g2l.IdCat=8 AND g2l.IdLanguage=1

Dotaz cislo:28
SELECT count(*) as cnt FROM gallery_tree WHERE IdParent = 8
select count of child galleries

Dotaz cislo:29
SELECT kat2.Name as nazev, kat1.IdParent as idParent, kat1.Id as id, 1 as ShowItem FROM gallery_tree kat1 INNER JOIN gallery_tree2lang kat2 ON kat2.IdCat = kat1.Id WHERE kat1.Id = 8 AND IdLanguage = 1 AND kat2.Flags&1 GROUP BY idParent ORDER BY nazev
kategorie_v ceste CWriteTreePath
Dotaz cislo:30
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=8 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db

Galerie

Dotaz cislo:31
SELECT gt.*, gt2lang.`Name`, gt2lang.`Description`, gp.FileName FROM gallery_tree gt INNER JOIN gallery_tree2lang gt2lang ON gt.Id=gt2lang.IdCat AND gt2lang.IdLanguage=1 AND gt2lang.Flags & 1 LEFT JOIN gallery_pictures gp ON gp.Id=gt.IdDefaultPicture WHERE gt.IdParent=8

Dotaz cislo:32
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=9 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:33
SELECT * FROM gallery_pictures WHERE Id=258
select filename of files to delete him
Dotaz cislo:34
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:35
SELECT * FROM gallery_pictures2lang WHERE IdImage=258 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:36
SELECT * FROM gallery_pictures2lang WHERE IdImage=258 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:37
SELECT * FROM gallery_pictures2lang WHERE IdImage=258 AND IdLanguage=5
select properties of object gallery_pictures2lang

Free Gallery

Dotaz cislo:38
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=10 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:39
SELECT * FROM gallery_pictures WHERE Id=274
select filename of files to delete him
Dotaz cislo:40
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:41
SELECT * FROM gallery_pictures2lang WHERE IdImage=274 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:42
SELECT * FROM gallery_pictures2lang WHERE IdImage=274 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:43
SELECT * FROM gallery_pictures2lang WHERE IdImage=274 AND IdLanguage=5
select properties of object gallery_pictures2lang

Reference

VYBRANÉ REFERENCE AiShop (e-shop systém)

Dotaz cislo:44
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=11 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:45
SELECT * FROM gallery_pictures WHERE Id=284
select filename of files to delete him
Dotaz cislo:46
SELECT * FROM _language ORDER BY colOrder ASC
select properties of object language
Dotaz cislo:47
SELECT * FROM gallery_pictures2lang WHERE IdImage=284 AND IdLanguage=1
select properties of object gallery_pictures2lang
Dotaz cislo:48
SELECT * FROM gallery_pictures2lang WHERE IdImage=284 AND IdLanguage=2
select properties of object gallery_pictures2lang
Dotaz cislo:49
SELECT * FROM gallery_pictures2lang WHERE IdImage=284 AND IdLanguage=5
select properties of object gallery_pictures2lang

Výrobky

Dotaz cislo:50
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=12 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db
Dotaz cislo:51
SELECT v2l.Name, v2l.IdTargetType FROM virtual_directory v INNER JOIN virtual_directory2lang v2l ON v.Id=v2l.IdDirectory AND v2l.IdLanguage=1 WHERE v.IdItem=13 AND v.IdSecuritySection = 30
select id of inserted virtual_directory from db

Dotaz cislo:85
call getRightsForUser(2, 34)
load rights

Dotaz cislo:87
SELECT * FROM section WHERE Id=130
select properties of object section
Dotaz cislo:88
SELECT * FROM section_sec2lang WHERE IdSection=130 AND IdLanguage=1
select properties of object section_sec2lang
Dotaz cislo:89
call getRightsForUser(2, 36)
load rights