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 Social Scene (1 viewing) (1) Guest Student Bars and clubs Page: 1 Threads in Forum : Social Scene Forum Tools Post New Topic Show latest posts Replies   Topics Last Post 0Replies Propaganda Posted 3 Months, 1 Week ago by Barcroft Views: 98 Last Post by Barcroft 3 Months, 1 Week ago 1Replies Halls bars Posted 3 Months, 3 Weeks ago by SarahGirl Views: 182 Last Post by fred 3 Months, 2 Weeks ago Page: 1 Board Categories Student Money Issues ... Make Money ...... Jobs Board ... Save Money ... Spend Money ... Your Money ... Student Offers Student Life ... Freshers' Life ... Food & Cooking ...... 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 '%social scene%') AND (`published` > 0))
4
SELECT oldurl, newurl FROM jos_redirection WHERE oldurl = 'social-scene/' ORDER BY rank ASC LIMIT 1
5
UPDATE jos_redirection SET cpt=(cpt+1) WHERE `newurl` = 'index.php?option=com_fireboard&Itemid=93&catid=4&func=showcat&lang=en' AND `oldurl` = 'social-scene/'
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 < '1231331696' )
 AND guest = 0
 AND gid > 0
 ) OR (
 ( time < '1231331696' )
 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 < '1231330796'
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 = 4
17
UPDATE jos_fb_whoisonline SET time='1231332596', what='Social Scene', do= '', task= '', link= '/index.php?option=com_fireboard&Itemid=93&catid=4&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=4
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=4
23
SELECT count(*) FROM jos_fb_messages WHERE catid=4 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=4&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=4
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='4'
49
Select count(*) FROM jos_fb_messages WHERE parent = '0' AND catid= '4' 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 = 4
    						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 ('40','36')
        					AND a.id NOT IN ('40','36')
        					AND a.hold=0
52
select count(*) from jos_fb_messages where catid='4' 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=4 and published=1
56
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&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=4
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=4&func=showcat&lang=en%'
64
SELECT * from jos_fb_categories where id = 4
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='4'  and published='1' order by ordering
67
SELECT readtopics FROM jos_fb_sessions WHERE userid=0
68
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&do=reply&func=post&lang=en'
69
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
70
SELECT id, name FROM jos_fb_categories
 WHERE id=4
71
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=latest&lang=en'
72
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
73
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=view&id=40&lang=en'
74
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
75
SELECT id, name FROM jos_fb_categories
 WHERE id=4
76
SELECT id, subject FROM jos_fb_messages
 WHERE id=40
77
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=64'
78
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
79
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=view&id=40&lang=en'
80
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
81
SELECT id, name FROM jos_fb_categories
 WHERE id=4
82
SELECT id, subject FROM jos_fb_messages
 WHERE id=40
83
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=64'
84
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
85
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=view&id=36&lang=en'
86
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
87
SELECT id, name FROM jos_fb_categories
 WHERE id=4
88
SELECT id, subject FROM jos_fb_messages
 WHERE id=36
89
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=72'
90
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
91
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=view&id=36&lang=en'
92
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
93
SELECT id, name FROM jos_fb_categories
 WHERE id=4
94
SELECT id, subject FROM jos_fb_messages
 WHERE id=36
95
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fbprofile&lang=en&task=showprf&userid=62'
96
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
97
select * from jos_fb_moderation left join jos_users on jos_users.id=jos_fb_moderation.userid where jos_fb_moderation.catid=4
98
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
99
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&catid=4&func=credits&lang=en'
100
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
101
SELECT oldurl, dateadd FROM jos_redirection WHERE newurl = 'index.php?option=com_fireboard&Itemid=0&func=fb_rss&lang=en&no_html=1'
102
SELECT name, link,id FROM jos_menu WHERE published='1' AND link LIKE 'index.php?option=com_fireboard%'
103
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'
104
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
105
SELECT m.* FROM jos_menu AS m
WHERE menutype='mainmenu' AND m.published='1'
106
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'topmenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering
107
SELECT m.*
 FROM jos_menu AS m
 WHERE menutype = 'othermenu'
 AND published = 1
 AND access <= 0
 AND parent = 0
 ORDER BY ordering