Travel Portal Script
Hotel Reservation + Flight Booking + Package Tours + Car Hire
Time limit Maximum : 25 days
General Features required :
100% opensource without encryption
MVC (using codeigniter )platform with PHP and Mysql +AJAX +Angular JS
SEO friendly +Metatags on each page even search results should have SEO urls +Metatags.
Payment gateway PayU + EBS , Credit Basis (subject to approval by Admin )
Payments either through Payment gateway or Credit basis or offline
Along with book now button, enquire now button also be there which contains phone,name,email and tour details.
Should be very much secured XSS,SQL injection etc attacks proof.
Discount Coupon system which can be controlled and created by Admin , applicable while booking . Admin can enable/disable it anytime.
Every time user booking he will get SMS alerts along with Email Alerts, also 2 days before he will also get sms and email alerts before commencement of the services.
SMTP for emailing and email alerts should be used. Don’t use mail() function.
SMS api integration.
EVERY PART WHIZ BANNERS,ICONS,ITENERARY, CREATION , DELETION ETC. MUST BE CONTROLLED THROUGH BACKEND.
Responsive design should be used so that it can be compatible with mobiles, tablets and laptops.
Search sorting tours, hotels,flights, cars
Ranking of hotels/tour packages can be made up and down.
After payement Invoicing must be generate and can be available .
Points system, everytime user books he will get points, which is controlled by admin. Also these points can be seen on user panel. These points can be claimed by user to get some dicount voucher.
FRONT END DESIGN LAYOUT
Like makemytrip.com or yatra.com
Should have hot deals, special section etc
A) Flights data can be fetched from any affiliate API and guest will book on there website we will get commision.B) Flight data can also be fetched from local database which is uploaded by admin , lets say admin have created data for delhi to mumbai on particular date, so user can see flights if he select local data then he has to pay thru on site payment gateway else he will be redirected to affilaite site where he can book.
4) Hotel search data can be fetched either thru affiliate api or local database which is created by Admin or hotelier. Layout /Icons, amenieties, iteneraties style etc must be same as in makemytrip. If user choose hotel which is uploaded by admin/hotelier he will have to book through onsite payment gateway or he can enquire or he can choose offline payment else he will be redirected to affiliate websited like Expedia/Hotels.com /wego/hotelscombined/ etc.
5) car booking system will be onsite and based on local database, routes etc. all will be created by admin.exactly same as in makemytrip.com
6) Tour Booking system will be onsite and based on local database. All created by admin. Style/ itinerary design ( it must be good and will be same.Refer makemytrip.com
8) search bar . search results must be same as makemytrip.com
8) Discount coupon should be employed
9)after booking user/guest will get SMS alerts along with email alerts. SMI api can be controlled through ADMIN.
Banner + special deals+lastminute deals >> refer as per makemytrip.com
10) Hotelier panel
11) Admin panel and Unlimited subadmin panel with permission based.
12) User panel
13) Agent/reseller panel : admin will create Agent’s special deals for flight/hotel/tour/car/cab with details and price , which will be only avaliable on agents panel. Agents can buy through Payment gateway or Offline payment or credit basis { subject to approval by admin } also agent will get sms/email alert.
Once booking done, relavent hotelier will get SMS alert for there hotel booking.
14) Rest features same as available in Makemytrip.com
--------------------------xxxxxxxxxxxxxxx----------------------x----------------------x----------------
Travel Portal Script
Hotel Reservation + Flight Booking + Package Tours + Car Hire
Time limit Maximum : 25 days
General Features required :
100% opensource without encryption
MVC (using codeigniter )platform with PHP and Mysql +AJAX +Angular JS
SEO friendly +Metatags on each page even search results should have SEO urls +Metatags.
Payment gateway PayU + EBS , Credit Basis (subject to approval by Admin )
Payments either through Payment gateway or Credit basis or offline
Along with book now button, enquire now button also be there which contains phone,name,email and tour details.
Should be very much secured XSS,SQL injection etc attacks proof.
Discount Coupon system which can be controlled and created by Admin , applicable while booking . Admin can enable/disable it anytime.
Every time user booking he will get SMS alerts along with Email Alerts, also 2 days before he will also get sms and email alerts before commencement of the services.
SMTP for emailing and email alerts should be used. Don’t use mail() function.
SMS api integration.
EVERY PART WHIZ BANNERS,ICONS,ITENERARY, CREATION , DELETION ETC. MUST BE CONTROLLED THROUGH BACKEND.
Responsive design should be used so that it can be compatible with mobiles, tablets and laptops.
Search sorting tours, hotels,flights, cars
Ranking of hotels/tour packages can be made up and down.
After payement Invoicing must be generate and can be available .
Points system, everytime user books he will get points, which is controlled by admin. Also these points can be seen on user panel. These points can be claimed by user to get some dicount voucher.
FRONT END DESIGN LAYOUT
Like makemytrip.com or yatra.com
Should have hot deals, special section etc
A) Flights data can be fetched from any affiliate API and guest will book on there website we will get commision.B) Flight data can also be fetched from local database which is uploaded by admin , lets say admin have created data for delhi to mumbai on particular date, so user can see flights if he select local data then he has to pay thru on site payment gateway else he will be redirected to affilaite site where he can book.
4) Hotel search data can be fetched either thru affiliate api or local database which is created by Admin or hotelier. Layout /Icons, amenieties, iteneraties style etc must be same as in makemytrip. If user choose hotel which is uploaded by admin/hotelier he will have to book through onsite payment gateway or he can enquire or he can choose offline payment else he will be redirected to affiliate websited like Expedia/Hotels.com /wego/hotelscombined/ etc.
5) car booking system will be onsite and based on local database, routes etc. all will be created by admin.exactly same as in makemytrip.com
6) Tour Booking system will be onsite and based on local database. All created by admin. Style/ itinerary design ( it must be good and will be same.Refer makemytrip.com
8) search bar . search results must be same as makemytrip.com
8) Discount coupon should be employed
9)after booking user/guest will get SMS alerts along with email alerts. SMI api can be controlled through ADMIN.
Banner + special deals+lastminute deals >> refer as per makemytrip.com
10) Hotelier panel
11) Admin panel and Unlimited subadmin panel with permission based.
12) User panel
13) Agent/reseller panel : admin will create Agent’s special deals for flight/hotel/tour/car/cab with details and price , which will be only avaliable on agents panel. Agents can buy through Payment gateway or Offline payment or credit basis { subject to approval by admin } also agent will get sms/email alert.
Once booking done, relavent hotelier will get SMS alert for there hotel booking.
14) Rest features same as available in Makemytrip.com
--------------------------xxxxxxxxxxxxxxx----------------------x----------------------x----------------
| Match | Count | SQL | Script |
| SELECT * FROM members_ledger WHERE ip = ? AND added>=unix_timestamp(NOW())-86400 | 1 | SELECT querystring, added
FROM members_ledger
WHERE
ip = ? AND added>=unix_timestamp(NOW())-86400 | /opt/clerks-staging/docroot/include/functions/includes/security.php 398 fetchMemberLedger() include_once() |
| SELECT * FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C WHERE A.wantid='29023' AND A.category=B.CATID AND A.USERID=C.USERID | 1 | SELECT A.*, B.name, B.seo, C.username, C.userlevel, C.footer_code, C.rating,
C.ratingcount, C.googleplus_profile, C.total_recommendations, C.USERID, C.profilepicture, C.average_response_time, C.lastlogin, C.addtime
FROM wanttobuy A, categories_wanttobuy B, seoclerks.members C
WHERE A.wantid='29023'
AND A.category=B.CATID AND A.USERID=C.USERID | /opt/clerks-staging/docroot/viewwant.php 163 () () |
| SELECT * FROM seoclerks.members_recommendations WHERE USERID=248232 AND status=1 ORDER BY MRID DESC limit 1 | 1 | SELECT recommendation_text, FROMID, time_added FROM seoclerks.members_recommendations
WHERE USERID=248232 AND status=1
ORDER BY MRID DESC limit 1 | /opt/clerks-staging/docroot/include/functions/main.php 21955 getLastRecommendation() () |
| SELECT * FROM seoclerks.members WHERE USERID='261918' | 1 | SELECT username FROM seoclerks.members WHERE USERID='261918' | /opt/clerks-staging/docroot/include/functions/main.php 1577 insert_get_username_from_userid() () |
| SELECT * FROM ratings_buyer WHERE USERID=248232 | 1 | SELECT sum(good) as thumbup, sum(bad) as thumbdown
FROM ratings_buyer WHERE USERID=248232 | /opt/clerks-staging/docroot/include/functions/main.php 19523 GetRatingsAsBuyerTotal() () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29023 AND A.category=B.CATID AND A.active=1 AND (A.tags like '%Php Ajax Codeigniter%' ) LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A,
categories_wanttobuy B
WHERE A.wantid != 29023
AND A.category=B.CATID
AND A.active=1
AND (A.tags like '%Php Ajax Codeigniter%' ) LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 551 () () |
| SELECT * FROM wanttobuy A, categories_wanttobuy B WHERE A.wantid != 29023 AND A.category=B.CATID AND A.active=1 AND A.USERID=248232 LIMIT 4 | 1 | SELECT A.wantid, A.title, A.p1, A.maxprice, B.name, B.seo
FROM wanttobuy A, categories_wanttobuy B
WHERE A.wantid != 29023
AND A.category=B.CATID
AND A.active=1
AND A.USERID=248232
LIMIT 4 | /opt/clerks-staging/docroot/viewwant.php 568 () () |
| SELECT * FROM wantcomments a, seoclerks.members b WHERE a.PID='29023' AND a.USERID=b.USERID and b.status='1' AND a.status=1 order by a.CID asc | 1 | SELECT a.comment, a.USERID, a.CID, a.time_added, a.istranslated, a.parentid, b.username, b.profilepicture
FROM wantcomments a, seoclerks.members b
WHERE a.PID='29023' AND a.USERID=b.USERID and b.status='1' AND a.status=1
order by a.CID asc | /opt/clerks-staging/docroot/viewwant.php 835 () () |
| UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='29023' | 1 | UPDATE wanttobuy SET viewcount = viewcount + 1 WHERE wantid='29023' | /opt/clerks-staging/docroot/include/functions/main.php 1729 update_wantviewcount() () |
| SELECT * FROM wantbids as w, seoclerks.members AS m WHERE w.active=1 AND m.USERID=w.USERID AND m.status=1 AND w.USERID>0 AND w.wantid='29023' ORDER BY w.bidid ASC | 1 | SELECT w.bidid, w.PID, w.comment, w.title, w.pricepublic, w.USERID, w.adjustedprice, w.ip, m.profilepicture
FROM wantbids as w,
seoclerks.members AS m
WHERE w.active=1
AND m.USERID=w.USERID
AND m.status=1
AND w.USERID>0
AND w.wantid='29023'
ORDER BY w.bidid ASC
| /opt/clerks-staging/docroot/viewwant.php 1192 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=48545 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=48545 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM seoclerks.members as m WHERE m.USERID=201212 | 1 | SELECT m.username, m.skills, m.userlevel, m.ip, m.total_recommendations
FROM seoclerks.members as m
WHERE m.USERID=201212 | /opt/clerks-staging/docroot/viewwant.php 1258 () () |
| SELECT * FROM categories_wanttobuy | 1 | SELECT * FROM categories_wanttobuy | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| SELECT * FROM posts WHERE USERID=248232 | 1 | SELECT sum(positive_ratings) as thumbup,
sum(negative_ratings) as thumbdown
FROM posts
WHERE USERID=248232 | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() GetBuyerRatingsTotal() |
| SELECT * FROM categories | 1 | SELECT * FROM categories | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() parseRedundantQueriesCache() |
| select * from categories_software order by name asc | 1 | select * from categories_software order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_GetSoftwareCategories() |
| select * from categories_wanttobuy order by name asc | 1 | select * from categories_wanttobuy order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_wantcategories() |
| select * from categories_wanttotrade order by name asc | 1 | select * from categories_wanttotrade order by name asc | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() insert_get_tradecategories() |
| SELECT * FROM seoclerks.members WHERE USERID='48545' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='48545' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='201212' | 1 | SELECT profilepicture FROM seoclerks.members WHERE USERID='201212' | /opt/clerks-staging/docroot/libraries/adodb5/adodb.inc.php 1899 CacheExecute() getUserProfileImage() |
| SELECT * FROM seoclerks.members WHERE USERID='248232' | 1 | SELECT profile_data FROM seoclerks.members WHERE USERID='248232' | /opt/clerks-staging/docroot/include/functions/main.php 1927 getUserBackground() include() |
| count(*) | sql1 | error_msg |
|---|
| Load | Count | SQL | Max | Min |
