Member Login

Remember me

Lost Password?

Student Login

• Home
• Blog!
• Get in touch
• Games
• Join in!

• home
  • Blog
  • The Common Room
  • Manchester Universities
    • University of Manchester
    • Manchester Metropolitan
    • Salford University
  • View Map
• make money
  • Market Place
  • Student Jobs and Careers
  • 10 Quick Earners
  • Forum
• save money
  • Money Saving Tips
  • Student Recipes
    • More Recipes
  • Save on Food
  • Forum
• spend money
  • Manchester Clubs
  • Market Place
  • Get Cash Back!
  • Price Comparison Sites
  • Forum
• your money
  • Best Bank Accounts
  • Best Savings Accounts
  • Get a Budget!
  • Forum
• life
  • Freshers' Board
  • Food & Cooking
  • Social Scene
  • Health & Relationships
  • Halls & Accommodation
  • Academic
• forum

     

Recent Discussions Categories Threaded Welcome, Guest Please Login or Register.    Lost Password? Student Forum Student Life Food & Cooking (1 viewing) (1) Guest 1 Food & Cooking Advice on how to fuel your life as a student.   Forum Topics Replies Last Post Recipes for Students 1 0 Huge Recipe Database! by fred | 08/12/2008 14:11 Page: 1 Threads in Forum : Food & Cooking Forum Tools Post New Topic Show latest posts Replies   Topics Last Post 0Replies Mango Pulp Curry Posted 3 Months, 1 Week ago by Barcroft Views: 104 Last Post by Barcroft 3 Months, 1 Week ago Page: 1 Board Categories Student Money Issues ... Make Money ...... Jobs Board ... Save Money ... Spend Money ... Your Money ... Student Offers Student Life ... Freshers' Life ... Social Scene ...... Recipes for Students ... Health & Relationships ... Halls & Accommodation ... Academic ... Common Room SaveTheStudent.org ... The Website Powered by FireBoard

• student market
• how to save
• clubs & bars
• manchester forum
• site map

© Savethestudent.org. All rights reserved.

1
SET sql_mode = 'MYSQL40'
2
SELECT folder, element, published, params
 FROM jos_mambots
 WHERE published >= 1
 AND access <= 0
 AND folder = 'system'
 ORDER BY ordering
3
SELECT `id`,`link` FROM jos_menu  WHERE ((`name` LIKE '%food cooking%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'food-cooking/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_fireboard&Itemid=93&catid=8&func=showcat&lang=en' AND `oldurl` = 'food-cooking/'
6
SELECT template
 FROM jos_templates_menu
 WHERE client_id = 0
 AND ( menuid = 0  OR menuid = 93 )
 ORDER BY menuid DESC
LIMIT 1
7
DELETE FROM jos_session
 WHERE (
 ( time < '1231331065' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1231331065' )
 AND guest = 1
 AND userid = 0
 )
8
SELECT params
 FROM jos_mambots
 WHERE element = 'rokhead'
 AND folder = 'system'
9
SELECT params
 FROM jos_mambots
 WHERE element = 'rokbox'
 AND folder = 'system'
10
SELECT *
 FROM jos_menu
 WHERE id = 93
11
SELECT * FROM jos_fb_config
12
SELECT id FROM jos_menu WHERE link = 'index.php?option=com_fireboard' AND published = 1
13
SELECT template FROM jos_templates_menu where client_id ='0'
14
DELETE FROM jos_fb_whoisonline WHERE time < '1231330165'
15
SELECT COUNT(*) FROM jos_fb_whoisonline WHERE userip='38.103.63.61' AND userid='0'
16
SELECT name FROM jos_fb_categories WHERE id = 8
17
UPDATE jos_fb_whoisonline SET time='1231331965', what='Food & Cooking', do= '', task= '', link= '/index.php?option=com_fireboard&Itemid=93&catid=8&func=showcat&lang=en', func= 'showcat'
 WHERE userid=0 AND userip='38.103.63.61'
18
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=8
19
SELECT moderator FROM jos_fb_users WHERE userid=0
20
SELECT id FROM jos_fb_categories WHERE pub_access=0 AND published=1
21
SELECT max(posts) from jos_fb_users
22
SELECT parent FROM jos_fb_categories WHERE id=8
23
SELECT count(*) FROM jos_fb_messages WHERE catid=8 and hold=1
24
SELECT `id`,`link` FROM jos_menu where ((`menutype`='mainmenu') AND (`published` > 0) AND (`access` <= '0')) ORDER BY parent, ordering
25
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
26
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
27
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=listcat&lang=en'
28
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
29
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&func=showcat&id=0&lang=en&view=threaded'
30
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
31
SELECT id, name FROM jos_fb_categories
 WHERE id=8
32
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=search&lang=en'
33
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
34
SELECT su.view, u.name, su.moderator,su.avatar FROM jos_fb_users as su
LEFT JOIN jos_users as u on u.id=su.userid WHERE su.userid=0
35
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&do=show&func=myprofile&lang=en'
36
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
37
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&do=show&func=myprofile&lang=en'
38
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
39
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&auth=0&func=showauthor&lang=en&task=showmsg'
40
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
41
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
42
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
43
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_login&Itemid=0&lang=en'
44
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=logout&lang=en'
45
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&Itemid=0&lang=en&task=register'
46
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_registration&Itemid=0&lang=en&task=lostPassword'
47
SELECT id, title, module, position, content, showtitle, params
 FROM jos_modules AS m
 INNER JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
 WHERE m.published = 1
 AND m.access <= 0
 AND m.client_id != 1
 AND ( mm.menuid = 0  )
 ORDER BY ordering
48
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse FROM jos_fb_categories where id='8'
49
Select count(*) FROM jos_fb_messages WHERE parent = '0' AND catid= '8' AND hold = '0'
50
SELECT
    							a.*,
    							t.message AS messagetext,
    							m.mesid AS attachmesid,
    							f.thread AS favthread,
    							u.avatar,
    							MAX(b.time) AS lastpost
    						FROM  jos_fb_messages  AS a
    							JOIN jos_fb_messages_text AS t ON a.thread = t.mesid
    							LEFT  JOIN jos_fb_messages AS b ON b.thread = a.thread
    							LEFT  JOIN jos_fb_attachments AS m ON m.mesid = a.id
    							LEFT  JOIN jos_fb_favorites AS f ON  f.thread = a.id && f.userid = 0
        						LEFT JOIN jos_fb_users AS u ON u.userid = a.userid
    						WHERE a.parent =  '0'
    						AND a.catid = 8
    						AND a.hold = '0'
    						GROUP BY id
    						ORDER BY ordering DESC , lastpost DESC
    						LIMIT 0,20
51
SELECT
        						a.*,
        						u.avatar
        					FROM jos_fb_messages AS a
        						LEFT JOIN jos_fb_users AS u ON u.userid = a.userid
        					WHERE a.thread IN ('41')
        					AND a.id NOT IN ('41')
        					AND a.hold=0
52
select count(*) from jos_fb_messages where catid='8' and hold=1
53
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&lang=en'
54
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
55
select * from jos_fb_categories where id=8 and published=1
56
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&func=showcat&lang=en'
57
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
58
SELECT id, name FROM jos_fb_categories
 WHERE id=8
59
select * from jos_fb_categories where id=1 and published=1
60
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=1&func=showcat&lang=en'
61
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
62
SELECT id, name FROM jos_fb_categories
 WHERE id=1
63
SELECT w.userid, u.username , k.showOnline FROM jos_fb_whoisonline AS w LEFT JOIN jos_users AS u ON u.id=w.userid LEFT JOIN jos_fb_users AS k ON k.userid=w.userid  WHERE w.link like '%/index.php?option=com_fireboard&Itemid=93&catid=8&func=showcat&lang=en%'
64
SELECT * from jos_fb_categories where id = 8
65
SELECT name,id FROM jos_fb_categories WHERE id = 1
66
SELECT id, name, locked,review, pub_access, pub_recurse, admin_access, admin_recurse FROM jos_fb_categories WHERE parent='8'  and published='1' order by ordering
67
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&func=showcat&lang=en'
68
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
69
SELECT id, name FROM jos_fb_categories
 WHERE id=8
70
SELECT id,pub_access,pub_recurse,admin_access,admin_recurse,parent,name,locked,moderated,published,description,review FROM jos_fb_categories WHERE id=20
71
SELECT moderator FROM jos_fb_users WHERE userid=0
72
SELECT id FROM jos_fb_messages WHERE catid='20' and parent='0' and hold='0'
73
SELECT id FROM jos_fb_messages WHERE catid='20' and parent!='0' and hold='0'
74
SELECT MAX(time) from jos_fb_messages WHERE catid='20' and hold='0' AND moved!='1'
75
SELECT description from jos_fb_categories where id='20'
76
SELECT id, name from jos_fb_categories WHERE  parent='20'  AND published =1
77
SELECT userid FROM jos_fb_moderation WHERE catid='20'
78
SELECT id, thread, catid,name, subject, userid from jos_fb_messages WHERE time=1218568308 and hold='0' and moved!='1' LIMIT 1
79
SELECT count(id) from jos_fb_messages WHERE thread=21 AND hold=0
80
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=20&func=listcat&lang=en'
81
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
82
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=20&func=showcat&lang=en'
83
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
84
SELECT id, name FROM jos_fb_categories
 WHERE id=20
85
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=20
86
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=20&func=view&id=21&lang=en'
87
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
88
SELECT id, name FROM jos_fb_categories
 WHERE id=20
89
SELECT id, subject FROM jos_fb_messages
 WHERE id=21
90
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=62'
91
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
92
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=20&func=view&id=21&lang=en'
93
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
94
SELECT id, name FROM jos_fb_categories
 WHERE id=20
95
SELECT id, subject FROM jos_fb_messages
 WHERE id=21
96
SELECT readtopics FROM jos_fb_sessions WHERE userid=0
97
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&do=reply&func=post&lang=en'
98
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
99
SELECT id, name FROM jos_fb_categories
 WHERE id=8
100
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
101
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
102
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&func=view&id=41&lang=en'
103
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
104
SELECT id, name FROM jos_fb_categories
 WHERE id=8
105
SELECT id, subject FROM jos_fb_messages
 WHERE id=41
106
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=64'
107
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
108
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&func=view&id=41&lang=en'
109
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
110
SELECT id, name FROM jos_fb_categories
 WHERE id=8
111
SELECT id, subject FROM jos_fb_messages
 WHERE id=41
112
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=64'
113
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
114
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=8
115
SELECT c.* FROM jos_fb_categories c WHERE c.id IN (1,4,5,6,7,8,9,10,11,12,13,14,15,16,17,18,19,20) ORDER BY ordering, name
116
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=8&func=credits&lang=en'
117
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
118
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fb_rss&lang=en&no_html=1'
119
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
120
SELECT a.*
 FROM jos_components AS a
 WHERE ( a.admin_menu_link = 'option=com_syndicate' OR a.admin_menu_link = 'option=com_syndicate&hidemainmenu=1' )
 AND a.option = 'com_syndicate'
121
SELECT m.*, sum(case when p.published=1 then 1 else 0 end) as cnt
FROM jos_menu AS m
LEFT JOIN jos_menu AS p ON p.parent = m.id
WHERE m.menutype='mainmenu' AND m.published='1' AND m.access <= '0'
GROUP BY m.id ORDER BY m.parent, m.ordering
122
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
123
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
124
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering