The Stig

Di, 16 Nov 2010 02:35:45 -0000

OK...I have the same exact problem as sparrozzoit, unfortunately kingsleys remedy didn't work for me
Help !!!

Dave

Za, 25 Jul 2009 14:41:35 -0000

yea, my litle "TEAM PLUGIN" modification cant compare with XsCCS BUT im guesing that No_Ob is from quake 3 arena community,im sure i saw some1 with such tag in game (im still playing it) i know "that" community for 4 years now and our roster / joining doesnt have to be advanced as it is in XsCCS, only thing u have to do is change some1s rank @ cotonti and site disply him @ roster

more, i was useing it @ my site for about 2 monthsm, mainly match system ... people are simply too lazy, at the begin they did add screenshots of won/lost game but after some time they gave up :s, vist my site: ev.toster.net, ull understand

-Dave

Kingsley

Za, 25 Jul 2009 06:47:04 -0000

@ Dave, sorry, but what it the added value of that? XsCCS got a squad section to..

Kingsley

Vr, 24 Jul 2009 09:02:22 -0000

u are most welcome

SparrozzoIT

Vr, 24 Jul 2009 08:37:40 -0000

tnx Kingsley, now work it.

Kingsley

Vr, 24 Jul 2009 05:13:56 -0000

By default the sql isn't included in the package. Fortunatly for you I save those things:

CREATE TABLE sed_xsccs_cfg (
  cfg_cname varchar(255) NOT NULL,
  cfg_tags varchar(255) NOT NULL,
  cfg_email varchar(255) NOT NULL,
  cfg_sedplus tinyint(1) NOT NULL default '0',
  cfg_nav tinyint(1) NOT NULL default '0',
  cfg_ros_pag tinyint(3) NOT NULL default '0',
  cfg_sig_act tinyint(1) NOT NULL default '0',
  cfg_sig_con tinyint(1) NOT NULL default '0',
  cfg_sig_xf1_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf1_ttl varchar(255) NOT NULL,
  cfg_sig_xf2_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf2_ttl varchar(255) NOT NULL,
  cfg_sig_xf3_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf3_ttl varchar(255) NOT NULL,
  cfg_sig_xf4_mem tinyint(1) NOT NULL default '0',
  cfg_sig_xf4_ttl varchar(255) NOT NULL,
  cfg_sig_xf5_ttl varchar(255) NOT NULL,
  cfg_con_act tinyint(1) NOT NULL default '0',
  cfg_con_txt text NOT NULL,
  cfg_mat_pag tinyint(3) NOT NULL default '0',
  cfg_mat_xf1_ttl varchar(255) NOT NULL,
  cfg_mat_xf2_ttl varchar(255) NOT NULL,
  cfg_mat_xf3_ttl varchar(255) NOT NULL,
  cfg_mat_xf4_ttl varchar(255) NOT NULL,
  cfg_mat_xf5_ttl varchar(255) NOT NULL,
  cfg_cha_pag tinyint(3) NOT NULL default '0',
  cfg_cus_act tinyint(1) NOT NULL default '0',
  cfg_cus_cap tinyint(1) NOT NULL default '0',
  cfg_cus_xf1_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf1_ttl varchar(255) NOT NULL,
  cfg_cus_xf2_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf2_ttl varchar(255) NOT NULL,
  cfg_cus_xf3_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf3_ttl varchar(255) NOT NULL,
  cfg_cus_xf4_mem tinyint(1) NOT NULL default '0',
  cfg_cus_xf4_ttl varchar(255) NOT NULL,
  cfg_cus_xf5_ttl varchar(255) NOT NULL,
  cfg_ran_pag tinyint(3) NOT NULL default '0',
  cfg_sta_pag tinyint(3) NOT NULL default '0',
  cfg_squ_pag tinyint(3) NOT NULL default '0',
  cfg_gam_pag tinyint(3) NOT NULL default '0',
  cfg_gty_pag tinyint(3) NOT NULL default '0'
) ENGINE=MyISAM;

INSERT INTO sed_xsccs_cfg (cfg_cname, cfg_tags, cfg_email, cfg_sedplus, cfg_nav, cfg_ros_pag, cfg_sig_act, cfg_sig_con, cfg_sig_xf1_mem, cfg_sig_xf1_ttl, cfg_sig_xf2_mem, cfg_sig_xf2_ttl, cfg_sig_xf3_mem, cfg_sig_xf3_ttl, cfg_sig_xf4_mem, cfg_sig_xf4_ttl, cfg_sig_xf5_ttl, cfg_con_act, cfg_con_txt, cfg_mat_pag, cfg_cha_pag, cfg_cus_act, cfg_cus_cap, cfg_cus_xf1_mem, cfg_cus_xf1_ttl, cfg_cus_xf2_mem, cfg_cus_xf2_ttl, cfg_cus_xf3_mem, cfg_cus_xf3_ttl, cfg_cus_xf4_mem, cfg_cus_xf4_ttl, cfg_cus_xf5_ttl, cfg_ran_pag, cfg_sta_pag, cfg_squ_pag, cfg_gam_pag, cfg_gty_pag) VALUES 
('Clan Name', '[TAGS]', 'email@domain.com', 0, 1, 10, 1, 1, 0, '', 0, '', 0, '', 0, '', '', 1, 'Our Code of Conduct is coming soon!', 10, 10, 1, 1, 0, '', 0, '', 0, '', 0, '', '', 10, 10, 10, 10, 10);

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_challenge (
  chall_id int(11) unsigned NOT NULL auto_increment,
  chall_yname varchar(255) NOT NULL,
  chall_yemail varchar(255) NOT NULL,
  chall_yip varchar(16) NOT NULL default '',
  chall_tname varchar(255) NOT NULL,
  chall_tsite varchar(255) NOT NULL,
  chall_game int(11) NOT NULL default '0',
  chall_mtype int(11) NOT NULL default '0',
  chall_gtype int(11) NOT NULL default '0',
  chall_tnumb int(11) NOT NULL default '0',
  chall_when int(11) NOT NULL default '0',
  chall_where varchar(255) NOT NULL default '',
  chall_xinfo text NOT NULL,
  chall_xf1 varchar(255) NOT NULL,
  chall_xf2 varchar(255) NOT NULL,
  chall_xf3 varchar(255) NOT NULL,
  chall_xf4 varchar(255) NOT NULL,
  chall_xf5 tinyint(1) NOT NULL default '0',
  chall_status tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (chall_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_game (
  game_id int(11) unsigned NOT NULL auto_increment,
  game_name varchar(255) NOT NULL,
  game_order int(11) NOT NULL default '0',
  game_img varchar(255) NOT NULL,
  game_desc text NOT NULL,
  PRIMARY KEY  (game_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_gamej (
  gaj_id int(11) unsigned NOT NULL auto_increment,
  gaj_memid int(11) NOT NULL default '0',
  gaj_gaid int(11) NOT NULL default '0',
  PRIMARY KEY  (gaj_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_match (
  mat_id int(11) unsigned NOT NULL auto_increment,
  mat_date int(11) NOT NULL default '0',
  mat_game int(11) NOT NULL default '0',
  mat_mtype int(11) NOT NULL default '0',
  mat_gtype int(11) NOT NULL default '0',
  mat_opp varchar(255) NOT NULL,
  mat_opps varchar(255) NOT NULL,
  mat_yscore int(11) NOT NULL default '0',
  mat_oscore int(11) NOT NULL default '0',
  mat_notes text NOT NULL,
  mat_xf1 varchar(255) NOT NULL,
  mat_xf2 varchar(255) NOT NULL,
  mat_xf3 varchar(255) NOT NULL,
  mat_xf4 varchar(255) NOT NULL,
  mat_xf5 tinyint(1) NOT NULL default '0',
  PRIMARY KEY  (mat_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_rank (
  rank_id int(11) unsigned NOT NULL auto_increment,
  rank_name varchar(255) NOT NULL,
  rank_order int(11) NOT NULL default '0',
  rank_img varchar(255) NOT NULL,
  rank_desc text NOT NULL,
  PRIMARY KEY  (rank_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_gtype (
  gtype_id int(11) unsigned NOT NULL auto_increment,
  gtype_name varchar(255) NOT NULL,
  gtype_order int(11) NOT NULL default '0',
  gtype_img varchar(255) NOT NULL,
  gtype_desc text NOT NULL,
  PRIMARY KEY  (gtype_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_roster (
  mem_id int(11) unsigned NOT NULL auto_increment,
  mem_gname varchar(255) NOT NULL,
  mem_rank int(11) NOT NULL default '0',
  mem_games text NOT NULL,
  mem_status int(11) NOT NULL default '0',
  mem_est int(11) NOT NULL,
  mem_rname varchar(255) NOT NULL,
  mem_glength varchar(255) NOT NULL,
  mem_ptime varchar(255) NOT NULL,
  mem_about text NOT NULL,
  mem_skills text NOT NULL,
  mem_cpu varchar(255) NOT NULL,
  mem_mobo varchar(255) NOT NULL,
  mem_vc varchar(255) NOT NULL,
  mem_ram varchar(255) NOT NULL,
  mem_os varchar(255) NOT NULL,
  mem_conn varchar(255) NOT NULL,
  mem_pscore int(3) NOT NULL,
  mem_xf1 varchar(255) NOT NULL,
  mem_xf2 varchar(255) NOT NULL,
  mem_xf3 varchar(255) NOT NULL,
  mem_xf4 varchar(255) NOT NULL,
  mem_xf5 tinyint(1) NOT NULL default '0',
  mem_activated tinyint(1) NOT NULL default '0',
  mem_siteid mediumint(40) unsigned NOT NULL default '0',
  PRIMARY KEY  (mem_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_squad (
  squad_id int(11) unsigned NOT NULL auto_increment,
  squad_name varchar(255) NOT NULL,
  squad_order int(11) NOT NULL default '0',
  squad_img varchar(255) NOT NULL,
  squad_desc text NOT NULL,
  PRIMARY KEY  (squad_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_squadj (
  sqj_id int(11) unsigned NOT NULL auto_increment,
  sqj_memid int(11) NOT NULL default '0',
  sqj_sqid int(11) NOT NULL default '0',
  PRIMARY KEY  (sqj_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_status (
  status_id int(11) unsigned NOT NULL auto_increment,
  status_name varchar(255) NOT NULL,
  status_desc text NOT NULL,
  PRIMARY KEY  (status_id)
) ENGINE=MyISAM;

-- --------------------------------------------------------

CREATE TABLE sed_xsccs_memparj (
  mpj_id int(11) unsigned NOT NULL auto_increment,
  mpj_memid int(11) NOT NULL default '0',
  mpj_mpid int(11) NOT NULL default '0',
  PRIMARY KEY  (mpj_id)
) ENGINE=MyISAM;

run this and you will be ok

SparrozzoIT

Vr, 24 Jul 2009 02:42:06 -0000

harryRag, can you help me ? I have installed the plug in Xcss with textboxe2 without installa but I have thi error:

Simulations Italia
2009-07-23 20:36
Fatal error : SQL error : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'WHERE mem_activated='1' ORDER BY mem_pscore DESC LIMIT 5' at line 1

HarryRag

Ma, 20 Apr 2009 05:58:39 -0000

Told this also in a pm, then it should work.
He got a pm now with the full list that should be added to config.php

[hr]

he needs to learn reading what there has been told, answered you pm for the last time since you don't seem to read what has been writen

Kingsley

Ma, 20 Apr 2009 04:31:55 -0000

Quite simple:

Do everything what Xiode says, plus from the seditio package, copy Textboxer2 (complete plugin map) to your cotonti plugin map, but do not install it. Oh, and do not forget to add the thingy's Xiode mentions to config.php.

thx to Lombi for that tip...

+No_Ob

Ma, 20 Apr 2009 01:42:35 -0000

Could you give me a little "how to" ?

Thanks

HarryRag

Za, 18 Apr 2009 06:48:46 -0000

it works, use search, old textboxer plugin files are needed, not installed

+No_Ob

Za, 18 Apr 2009 06:04:32 -0000

Hi all,

The older seditio version has a plugin named "XsCCSv3.1". Its seems very usefull for clan site's. Unfortunately this one is only useable for the older version and not for Cotonti.

Does someone know if this one is already brought for cotonti ?

Cheers, +No_Ob

cotonti.com : XsCompleteClanSolution

The Stig

Dave

Kingsley

Dave

Kingsley

SparrozzoIT

Kingsley

SparrozzoIT

HarryRag

Kingsley

+No_Ob

HarryRag

+No_Ob