Clansphere :: FREE Clan Content Management System

ALTER TABLE {pre}_access ADD access_training int(2) NOT NULL default '0';
REPLACE INTO `{pre}_options` ( `options_id` , `options_mod` , `options_name` , `options_value` ) VALUES ('', 'trains', 'endtime', '-10 hour');

CREATE TABLE `{pre}_trains` (
`trains_id` {serial},
`trains_squad` varchar(5) NOT NULL default '',
`trains_gegner` varchar(35) NOT NULL default '',
`trains_typ` varchar(35) NOT NULL default '',
`trains_address` varchar(35) NOT NULL default '',
`trains_ip` varchar(35) NOT NULL default '',
`trains_pw` varchar(35) NOT NULL default '',
`trains_time` varchar(14) default NULL,
`trains_info` text NOT NULL,
`trains_pub` varchar(1) NOT NULL,
PRIMARY KEY (`trains_id`)
) {engine} ;


CREATE TABLE `{pre}_trainstats` (
`trainstats_id` {serial} ,
`train_id` varchar(5) NOT NULL default '',
`users_id` varchar(5) NOT NULL default '',
`users_status` varchar(20) NOT NULL default '',
`users_info` text NOT NULL,
PRIMARY KEY (`trainstats_id`)
) {engine} ;

|

|

|

SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM cs_users WHERE users_id = '1' LIMIT 0,1
UPDATE cs_users SET users_laston='1218810948' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '91.3.75.177' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1218810948', count_location='clansphere/system' WHERE count_id='10209'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0

Warning: cs_html_vote - Function goes away in next minor release, use themes instead
Warning: cs_html_div - Function goes away in next minor release, use themes instead
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'clansphere'
SELECT users_id, users_nick, users_lang, access_id, users_limit, users_view, users_timezone, users_dstime FROM cs_users WHERE users_id = '1' LIMIT 0,1
UPDATE cs_users SET users_laston='1218811090' WHERE users_id='1'
SELECT * FROM cs_access WHERE access_id = '5' LIMIT 0,1
SELECT count_id, count_time FROM cs_count WHERE count_ip = '91.3.75.177' ORDER BY count_id DESC LIMIT 0,1
UPDATE cs_count SET count_time='1218811090', count_location='news/recent' WHERE count_id='10209'
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'counter'
SELECT * FROM cs_categories WHERE categories_mod = 'news' AND categories_access <= '5' ORDER BY categories_name
SELECT COUNT(DISTINCT news_id) FROM cs_news nws INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public > 0 AND cat.categories_access <= '5'
SELECT nws.news_id AS news_id, nws.news_headline AS news_headline, nws.news_time AS news_time, nws.news_text AS news_text, nws.news_pictures AS news_pictures, nws.users_id AS users_id, usr.users_nick AS users_nick, nws.categories_id AS categories_id, cat.categories_picture AS categories_picture, cat.categories_name AS categories_name FROM cs_news nws INNER JOIN cs_users usr ON nws.users_id = usr.users_id INNER JOIN cs_categories cat ON nws.categories_id = cat.categories_id WHERE nws.news_public > 0 AND cat.categories_access <= '5' ORDER BY news_attached DESC, news_time DESC LIMIT 0,8
SELECT options_name, options_value FROM cs_options WHERE options_mod = 'abcode'
SELECT abcode_func, abcode_pattern, abcode_result, abcode_file FROM cs_abcode
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '58'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '57'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '56'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '55'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '54'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '53'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '51'
SELECT COUNT(*) FROM cs_comments WHERE comments_mod = 'news' AND comments_fid = '50'
SELECT metatags_id, metatags_name, metatags_content FROM cs_metatags WHERE metatags_active = 1 ORDER BY metatags_name
SELECT COUNT(*) FROM cs_messages WHERE users_id_to = '1' AND messages_show_receiver = 1 AND messages_view = 0

|

|

|

|