[REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Closed.

No one thinks i can code my self so i wont code anymore.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

verry sexxieeee! 10/10

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

very nice 10/10

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

nice good work 10/10

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

ill make a tut on how to install it

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Thanks for all the feedback, and when the tut is done. Thanks for that too!

In the next release in the Habbo Info it will tell you how many friend requests you have, and your friend list. I'll try to get online friends working at a later date.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

hold on m8 i got one question i get this error "Unknown column 'online' in 'field list'"
after i try and register a account try real quick

http://192.168.2.28/cms/files/register.php

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

One minute. When i register i don't get this error.

EDIT: Alright.. I see the problem replace register.php with this:

PHP Code:

<?php include('core.php'); session_start(); if(!session_is_registered(username)){ include("locale/".$language."/login.php"); if(isset($_GET['refer'])){ $getrefer = addslashes($_GET['refer']); $some_sql = mysql_query("SELECT id FROM users WHERE name = '".$getrefer."'") or die(mysql_error()); $some_num = mysql_num_rows($some_sql); if($some_num < 1){ $error = $locale['error_refer']; $getrefer = "invalid"; } } if(isset($_POST['goregister'])){ // Collect POST variables $name = addslashes($_POST['avatarName']); $password = addslashes($_POST['password']); $retypedpassword = addslashes($_POST['retypedPassword']); $day = $_POST['day']; $month = $_POST['month']; $year = $_POST['year']; $email = addslashes($_POST['email']); $retypedemail = addslashes($_POST['retypedEmail']); $accept_tos = $_POST['accepttos']; $spam_me = $_POST['marketing']; $refer = addslashes($_POST['refer']); // Verify variables $email_check = preg_match("/^[a-z0-9_\.-]+@([a-z0-9]+([\-]+[a-z0-9]+)*\.)+[a-z]{2,7}$/i", $email); $output = preg_replace("/[^a-z\d]/i", "", $name); // Start validating the input if($accept_tos !== "true"){ $error = $locale['error_tos']; } else { if(empty($name) || empty($password) || empty($retypedpassword) || empty($day) || empty($month) || empty($year) || empty($email) || empty($retypedemail)){ $error = $locale['error_blanks']; } else { if($day < 1 || $day > 31 || $month < 1 || $month > 12 || $year < 1900 || $year > 2008){ $error = $locale['error_dob']; // Mhm, looks like this naughty lil' user uses an external form.. Sorry kid, uncle Meth0d can't let you do that. } else { if($password !== $retypedpassword){ $error = $locale['error_pass_match']; } else { if($email !== $retypedemail){ $error = $locale['error_mail_match']; } else { if($email_check !== 1){ $error = $locale['error_invalid_mail']; } else { if(strlen($name) > 25){ $error = $locale['error_name_too_long']; } else { if(strlen($password) < 6){ $error = $locale['error_pass_too_short']; } else { if(strlen($password) > 25){ $error = $locale['error_pass_too_long']; } else { if($name !== $output){ $error = $locale['error_invalid_username']; } else { $sql1 = mysql_query("SELECT id FROM users WHERE name = '".$output."' LIMIT 1") or die(mysql_error()); $num1 = mysql_num_rows($sql1); if($num1 > 0){ $error = "Chosen username (".$output.") is taken"; } else { // Everything is OK; let's register the guy $sql2 = mysql_query("SELECT id FROM users ORDER BY id DESC LIMIT 1"); $row2 = mysql_fetch_assoc($sql2); $num2 = mysql_num_rows($sql2); if($num2 !== 0){ $myid = $row2['id'] + 1; } else { $myid = "1"; } $figure = $_POST['settings-figure']; $sex = $_POST['settings-gender']; if(empty($figure) || empty($sex)){ $error = "An unknown error occured"; } else { if(!empty($refer)){ $refersql = mysql_query("SELECT id FROM users WHERE name = '".$refer."' LIMIT 1") or die(mysql_error()); $refernum = mysql_num_rows($refersql); if($refernum > 0){ mysql_query("UPDATE users SET credits = credits + ".$reward." WHERE name = '".$refer."'") or die(mysql_error()); mysql_query("UPDATE cms_alerts SET alert = 'Someone filled you in as refer during registration, and you recieved ".$reward." credits as reward! Use them wisely.', pending = '1' WHERE username = '".$refer."'") or die(mysql_error()); $sql3 = mysql_query("INSERT INTO users (id,name,password,hash,app_key,ip,rank,email,newsletter,figure,poolFigure,sex,Mission,dob,lastOnline,consoleMission,consoleFriends,consoleRequests,groupID,groupBadge,groupName,groupDesc,credits,tickets,photos,hand,clubDays,clubPeriods,clubExpire,favoriteRooms,badge,badgestatus,badges,totalClubDays) VALUES ('".$myid."','".$output."','".$password."','0','1','".$getrefer."','user','".$email."','0','".$figure."','".$figure."','".$sex."','Marks v20','".$day.".".$month.".".$year."','".$regdate."','Consol Mission',' ','0','0','0',' ',' ','0','0','0',';','0','0','0',' ',' ','0',';','0')") or die(mysql_error()); //$sql4 = mysql_query("UPDATE system SET users = users + 1"); $sql5 = mysql_query("INSERT INTO cms_alerts (username,alert,pending) VALUES ('".$output."','','0')") or die(mysql_error()); $username = $name; $_SESSION['username'] = $username; $_SESSION['password'] = $password; header("location:security_check.php"); } else { $error = $locale['error_refer']; } } else { $sql3 = mysql_query("INSERT INTO users (id,name,password,hash,app_key,ip,rank,email,newsletter,figure,poolFigure,sex,Mission,dob,lastOnline,consoleMission,consoleFriends,consoleRequests,groupID,groupBadge,groupName,groupDesc,credits,tickets,photos,hand,clubDays,clubPeriods,clubExpire,favoriteRooms,badge,badgestatus,badges,totalClubDays) VALUES ('".$myid."','".$output."','".$password."','0','1','".$getrefer."','user','".$email."','0','".$figure."','".$figure."','".$sex."','Marks v20','".$day.".".$month.".".$year."','".$regdate."','Consol Mission',' ','0','0','0',' ',' ','0','0','0',';','0','0','0',' ',' ','0',';','0')") or die(mysql_error()); //$sql4 = mysql_query("UPDATE system SET users = users + 1"); $sql5 = mysql_query("INSERT INTO cms_alerts (username,alert,pending) VALUES ('".$output."','','0')") or die(mysql_error()); $username = $name; $_SESSION['username'] = $username; $_SESSION['password'] = $password; header("location:security_check.php"); } } } } } } } } } } } } } } include('templates/login/register_subheader.php'); include('templates/login/register_header.php'); ?> <div id="process-content"> <div id="column1" class="column"> <div class="habblet-container "> <form method="post" action="register.php" id="registerform" autocomplete="off"> <input type="hidden" name="settings-figure" id="settings-figure" value="<?php if(isset($_POST['settings-figure'])){ echo $_POST['settings-figure']; } ?>" /> <input type="hidden" name="settings-gender" id="settings-gender" value="<?php if(isset($_POST['settings-gender'])){ echo $_POST['settings-gender']; } ?>" /> <input type="hidden" name="editorState" id="register-editor-state" value="" /> <div id="register-column-left"> <div class="action-confirmation flash-message"> <div class="rounded"> <font size="4"><b>1. <?php echo $locale['header1']; ?></b></font> </div> </div> <div id="avatar-error-box"> </div> <div id="register-avatar-editor"> <p><b><?php echo $locale['noflash']; ?></b></p> </div> <script type="text/javascript" language="JavaScript"> var swfobj = new SWFObject("http://www.habbo.co.uk/flash/HabboRegistration.swf", "habboreg", "435", "400", "8"); swfobj.addParam("base", "http://www.habbo.co.uk/flash/"); swfobj.addParam("wmode", "opaque"); swfobj.addParam("AllowScriptAccess", "always"); swfobj.addVariable("figuredata_url", "http://www.habbohotel.co.uk/gamedata/figuredata"); swfobj.addVariable("draworder_url", "http://www.habbohotel.co.uk/gamedata/figurepartconfig/draworder"); swfobj.addVariable("localization_url", "http://www.habbo.co.uk/figure/figure_editor_xml"); swfobj.addVariable("figure", "<?php if(isset($_POST['settings-figure'])){ echo $_POST['settings-figure']; } ?>"); swfobj.addVariable("gender", "<?php if(isset($_POST['settings-gender'])){ echo $_POST['settings-gender']; } ?>"); swfobj.addVariable("showClubSelections", "0"); swfobj.write("register-avatar-editor"); </script> <?php if(!empty($error)){ ?> <div class="action-error flash-message"> <div class="rounded"> <b><?php echo $locale['error_occured']; ?></b><br> <?php echo $error; ?> </div> </div> <?php } ?> </div> <div id="register-column-right"> <div id="register-section-2"> <div class="rounded rounded-blue"> <h2 class="heading"><span class="numbering white">2.</span><?php echo $locale['header2']; ?></h2> <fieldset id="register-fieldset-name"> <div class="register-label white"><?php echo $locale['habboname']; ?></div> <div align="center"><input type="text" name="avatarName" class="register-text" value="<?php echo stripslashes($name); ?>" size="25" /></div> </fieldset> <div id="name-error-box"> </div> </div> </div> <div id="register-section-3"> <div class="cbb clearfix gray"> <h2 class="title heading"><span class="numbering white">3.</span><?php echo $locale['header3']; ?></h2> <div class="box-content"> <fieldset id="register-fieldset-password"> <div class="register-label"><label for="register-password"><?php echo $locale['regpassword']; ?></label></div> <div class="register-label"><input type="password" name="password" id="register-password" class="register-text" size="25" value="" /></div> <div class="register-label"><label for="register-password2"><?php echo $locale['retype_password']; ?></label></div> <div class="register-label"><input type="password" name="retypedPassword" id="register-password2" class="register-text" size="25" value="" /></div> </fieldset> <div id="password-error-box"></div> <fieldset> <div class="register-label"><label><?php echo $locale['mydob']; ?></label></div> <div id="register-birthday"><select name="day" id="bean_day" class="dateselector"><option value=""><?php echo $locale['day']; ?></option><option value="1">1</option><option value="2">2</option><option value="3">3</option><option value="4">4</option><option value="5">5</option><option value="6">6</option><option value="7">7</option><option value="8">8</option><option value="9">9</option><option value="10">10</option><option value="11">11</option><option value="12">12</option><option value="13">13</option><option value="14">14</option><option value="15">15</option><option value="16">16</option><option value="17">17</option><option value="18">18</option><option value="19">19</option><option value="20">20</option><option value="21">21</option><option value="22">22</option><option value="23">23</option><option value="24">24</option><option value="25">25</option><option value="26">26</option><option value="27">27</option><option value="28">28</option><option value="29">29</option><option value="30">30</option><option value="31">31</option></select> <select name="month" id="bean_month" class="dateselector"><option value=""><?php echo $locale['month']; ?></option><option value="1">January</option><option value="2">February</option><option value="3">March</option><option value="4">April</option><option value="5">May</option><option value="6">June</option><option value="7">July</option><option value="8">August</option><option value="9">September</option><option value="10">October</option><option value="11">November</option><option value="12">December</option></select> <select name="year" id="bean_year" class="dateselector"><option value=""><?php echo $locale['year']; ?></option><option value="2008">2008</option><option value="2007">2007</option><option value="2006">2006</option><option value="2005">2005</option><option value="2004">2004</option><option value="2003">2003</option><option value="2002">2002</option><option value="2001">2001</option><option value="2000">2000</option><option value="1999">1999</option><option value="1998">1998</option><option value="1997">1997</option><option value="1996">1996</option><option value="1995">1995</option><option value="1994">1994</option><option value="1993">1993</option><option value="1992">1992</option><option value="1991">1991</option><option value="1990">1990</option><option value="1989">1989</option><option value="1988">1988</option><option value="1987">1987</option><option value="1986">1986</option><option value="1985">1985</option><option value="1984">1984</option><option value="1983">1983</option><option value="1982">1982</option><option value="1981">1981</option><option value="1980">1980</option><option value="1979">1979</option><option value="1978">1978</option><option value="1977">1977</option><option value="1976">1976</option><option value="1975">1975</option><option value="1974">1974</option><option value="1973">1973</option><option value="1972">1972</option><option value="1971">1971</option><option value="1970">1970</option><option value="1969">1969</option><option value="1968">1968</option><option value="1967">1967</option><option value="1966">1966</option><option value="1965">1965</option><option value="1964">1964</option><option value="1963">1963</option><option value="1962">1962</option><option value="1961">1961</option><option value="1960">1960</option><option value="1959">1959</option><option value="1958">1958</option><option value="1957">1957</option><option value="1956">1956</option><option value="1955">1955</option><option value="1954">1954</option><option value="1953">1953</option><option value="1952">1952</option><option value="1951">1951</option><option value="1950">1950</option><option value="1949">1949</option><option value="1948">1948</option><option value="1947">1947</option><option value="1946">1946</option><option value="1945">1945</option><option value="1944">1944</option><option value="1943">1943</option><option value="1942">1942</option><option value="1941">1941</option><option value="1940">1940</option><option value="1939">1939</option><option value="1938">1938</option><option value="1937">1937</option><o tion value="1936">1936</option><option value="1935">1935</option><option value="1934">1934</option><option value="1933">1933</option><option value="1932">1932</option><option value="1931">1931</option><option value="1930">1930</option><option value="1929">1929</option><option value="1928">1928</option><option value="1927">1927</option><option value="1926">1926</option><option value="1925">1925</option><option value="1924">1924</option><option value="1923">1923</option><option value="1922">1922</option><option value="1921">1921</option><option value="1920">1920</option><option value="1919">1919</option><option value="1918">1918</option><option value="1917">1917</option><option value="1916">1916</option><option value="1915">1915</option><option value="1914">1914</option><option value="1913">1913</option><option value="1912">1912</option><option value="1911">1911</option><option value="1910">1910</option><option value="1909">1909</option><option value="1908">1908</option><option value="1907">1907</option><option value="1906">1906</option><option value="1905">1905</option><option value="1904">1904</option><option value="1903">1903</option><option value="1902">1902</option><option value="1901">1901</option><option value="1900">1900</option></select> </div> </fieldset> <div id="email-error-box"> </div> <fieldset> <div class="register-label"><label for="register-captcha"><?php echo $locale['refer']; ?></label></div> <?php if(!empty($getrefer) && $getrefer !== "invalid"){ ?> <div><input type="text" name="refer" id="register-captcha" class="register-text" value="<?php echo stripslashes($getrefer); ?>" size="25" /></div> <?php } else { ?> <div><input type="text" name="refer" id="register-captcha" class="register-text" value="<?php echo stripslashes($_POST['refer']); ?>" size="25" /></div> <?php } ?> </fieldset> <fieldset> <div class="register-label"><label for="register-email"><?php echo $locale['mail']; ?></label></div> <div class="register-label"><input type="text" name="email" id="register-email" class="register-text" value="<?php echo stripslashes($email); ?>" size="25" maxlength="48" /></div> <div class="register-label"><label for="register-email2"><?php echo $locale['mail_retype']; ?></label></div> <div class="register-label"><input type="text" name="retypedEmail" id="register-email2" class="register-text" value="<?php echo stripslashes($retypedemail); ?>" size="25" maxlength="48" /></div> <div id="register-marketing-box"> <input type="checkbox" name="marketing" id="bean_marketing" value="true" <?php if($spam_me == "true"){ echo "checked='checked'"; } ?> /> <label for="bean_marketing"><?php echo $locale['mailing']; ?></label> </div> </fieldset> <div id="terms-error-box"> </div> <fieldset id="register-fieldset-terms"> <div class="rounded rounded-darkgray" id="register-terms"> <div id="register-terms-content"> <p><a href="./disclaimer.php" target="_blank" id="register-terms-link"><?php echo $locale['link_disclaimer']; ?></a></p> <p class="last"> <input type="checkbox" name="accepttos" id="register-terms-check" value="true" <?php if($_POST['accepttos'] == "true"){ echo "checked='checked'"; } ?> /> <label for="register-terms-check"><?php echo $locale['accept_tos']; ?></label> </p> </div> </div> </fieldset> </div> </div> <div id="form-validation-error-box" style="display:none"> <div class="register-error"> <div class="rounded rounded-red"> Sorry, registration failed. Please check the information you gave in the red boxes. </div> </div> </div> </div> </div> <div id="register-buttons"> <input type="submit" name="goregister" value="<?php echo $locale['done']; ?>" class="continue" id="register-button-continue" /> <a href="index.php" class="cancel"><?php echo $locale['exit']; ?></a> </div> </form> </div> <script type="text/javascript">if (!$(document.body).hasClassName('process-template')) { Rounder.init(); }</script> </div> <?php } else { header("location:index.php"); } include('templates/login/footer.php'); ?>

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

ok i fixed it now, now i need to fix HC =/

EDIT: how do i get it so new users get coins?

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

I'll make it so in config you can just set a value and when the user registers they get those credits.

With the HC you can buy HC however you can't use HC clothes... I'm working on that and it will be released in 1.3 or 1.4.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Ok well any way i can help?

also i cant login to the hotel =/ ill try and fix that =p

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

In your MYsql database go to system_config and change game_port and mus_port to your ports.

Make sure however if you set game port to 1232 make your mus port 1233.. That should work, cause SSO works.. I fixed that.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

still not working

http://192.168.2.28/cms/files/index.php

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Quote:

Originally Posted by CujoDaMan

I'll make it so in config you can just set a value and when the user registers they get those credits.

With the HC you can buy HC however you can't use HC clothes... I'm working on that and it will be released in 1.3 or 1.4.

wen i try to start the server it is say runtime error 2147467259 (80004005)': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified HELP!!!!

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Quote:

Originally Posted by Pm Hotel

still not working

http://192.168.2.28/cms/files/index.php

Did you start your server? If so it's probley on port 90 if you didn't change settings.exe.. And did you add your mysql information into settings.exe?

If the servers on port 90 make game_port = 90 and mus_port = 91

Quote:

Originally Posted by Andre23

wen i try to start the server it is say runtime error 2147467259 (80004005)': [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified HELP!!!!

Download the OBDC Connector and MySQL Server
MySQL :: MySQL Connector/ODBC 3.51 Downloads
MySQL :: MySQL 5.0 Downloads

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Aight i see something no one else probably would have. If this is marks why does it say "Enter Holo Hotel" ? in one image thats up there?

Other then that suspicion looks good.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Quote:

Originally Posted by shadowmage121

Aight i see something no one else probably would have. If this is marks why does it say "Enter Holo Hotel" ? in one image thats up there?

Other then that suspicion looks good.

To awnser your question i used the Holo Source, thats why it says that. I'll fix all that in the future.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Quote:

Originally Posted by CujoDaMan

Did you start your server? If so it's probley on port 90 if you didn't change settings.exe.. And did you add your mysql information into settings.exe?

If the servers on port 90 make game_port = 90 and mus_port = 91

Download the OBDC Connector and MySQL Server
MySQL :: MySQL Connector/ODBC 3.51 Downloads
MySQL :: MySQL 5.0 Downloads

download them 2 then after that wat to do

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

You'll have to set up your MySQL Server.

Then on google search "Navicate Lite"

Try finding a Holograph Elemunator Tut, that'll explain it. I have to go.. I'll be back in a bit.

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Multi LiNk MassMirror.com - Download MarkCMS-1.2.zip

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Quote:

Originally Posted by CujoDaMan

You'll have to set up your MySQL Server.

Then on google search "Navicate Lite"

Try finding a Holograph Elemunator Tut, that'll explain it. I have to go.. I'll be back in a bit.

-- ----------------------------
-- Table structure for cms_alerts
-- ----------------------------
CREATE TABLE `cms_alerts` (
`username` varchar(25) collate latin1_general_ci NOT NULL COMMENT 'User to alert',
`alert` mediumtext collate latin1_general_ci NOT NULL COMMENT 'Message',
`pending` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Alerted yet?'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_help
-- ----------------------------
CREATE TABLE `cms_help` (
`id` int(11) NOT NULL auto_increment,
`username` varchar(25) collate latin1_general_ci NOT NULL,
`ip` varchar(50) collate latin1_general_ci NOT NULL,
`message` mediumtext collate latin1_general_ci NOT NULL,
`date` varchar(50) collate latin1_general_ci NOT NULL,
`picked_up` enum('0','1') collate latin1_general_ci NOT NULL,
`subject` varchar(50) collate latin1_general_ci NOT NULL,
`roomid` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_news
-- ----------------------------
CREATE TABLE `cms_news` (
`num` tinyint(4) NOT NULL,
`title` text collate latin1_general_ci NOT NULL,
`category` text collate latin1_general_ci NOT NULL,
`topstory` varchar(100) collate latin1_general_ci NOT NULL,
`short_story` text collate latin1_general_ci NOT NULL,
`story` longtext collate latin1_general_ci NOT NULL,
`date` date NOT NULL,
`author` text collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_posts
-- ----------------------------
CREATE TABLE `cms_posts` (
`id` int(11) NOT NULL auto_increment,
`thread` int(11) NOT NULL,
`poster` varchar(25) NOT NULL,
`date` varchar(25) NOT NULL,
`post` text NOT NULL,
`modified` varchar(50) NOT NULL,
`modified_by` varchar(25) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_system
-- ----------------------------
CREATE TABLE `cms_system` (
`sitename` varchar(30) collate latin1_general_ci NOT NULL,
`shortname` varchar(30) collate latin1_general_ci NOT NULL,
`site_closed` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Maintenance Mode',
`enable_sso` enum('0','1') collate latin1_general_ci NOT NULL,
`language` varchar(2) collate latin1_general_ci NOT NULL,
`ip` varchar(50) collate latin1_general_ci NOT NULL,
`port` varchar(5) collate latin1_general_ci NOT NULL,
`texts` varchar(250) collate latin1_general_ci NOT NULL,
`variables` varchar(250) collate latin1_general_ci NOT NULL,
`dcr` varchar(250) collate latin1_general_ci NOT NULL,
`reload_url` varchar(250) collate latin1_general_ci NOT NULL,
`localhost` enum('0','1') collate latin1_general_ci NOT NULL COMMENT 'Local server?'
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_tags
-- ----------------------------
CREATE TABLE `cms_tags` (
`id` int(255) NOT NULL auto_increment,
`owner` varchar(25) collate latin1_general_ci NOT NULL,
`tag` varchar(25) collate latin1_general_ci NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=9 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for cms_threads
-- ----------------------------
CREATE TABLE `cms_threads` (
`id` int(11) NOT NULL auto_increment,
`title` varchar(20) NOT NULL,
`views` varchar(4) NOT NULL,
`replies` varchar(4) NOT NULL,
`starter` varchar(25) NOT NULL,
`lastposter` varchar(25) NOT NULL,
`lastpostdate` varchar(25) NOT NULL,
`lastposttime` varchar(50) NOT NULL,
`startdate` varchar(25) NOT NULL,
`unix` varchar(50) NOT NULL,
`firstpostid` int(20) NOT NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COMMENT='HoloCMS';
-- ----------------------------
-- Table structure for system
-- ----------------------------
CREATE TABLE `system` (
`onlinecount` int(3) NOT NULL default '0',
`test` text collate latin1_general_ci
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for system_config
-- ----------------------------
CREATE TABLE `system_config` (
`skey` varchar(100) collate latin1_general_ci NOT NULL,
`sval` text collate latin1_general_ci NOT NULL
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for system_stafflog
-- ----------------------------
CREATE TABLE `system_stafflog` (
`id` int(5) NOT NULL auto_increment,
`action` varchar(12) collate latin1_general_ci NOT NULL,
`message` text collate latin1_general_ci,
`note` text collate latin1_general_ci,
`userid` int(11) NOT NULL,
`targetid` int(11) default NULL,
`timestamp` varchar(50) collate latin1_general_ci default NULL,
PRIMARY KEY (`id`)
) ENGINE=MyISAM AUTO_INCREMENT=7 DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;
-- ----------------------------
-- Table structure for system_strings
-- ----------------------------
CREATE TABLE `system_strings` (
`stringid` varchar(100) collate latin1_general_ci NOT NULL default 'null',
`var_en` text collate latin1_general_ci,
`var_de` text collate latin1_general_ci,
PRIMARY KEY (`stringid`)
) ENGINE=MyISAM DEFAULT CHARSET=latin1 COLLATE=latin1_general_ci;

INSERT INTO `cms_news` VALUES ('1', 'Installation Complete', 'HoloCMS', 'http://images.habbohotel.co.uk/c_images/Top_Story_Images/topstory_accessories2.gif', 'HoloCMS was successfully installed!', 'Thank you for choosing HoloCMS! Everything appears to be working just fine..\r\n\r\nYou can edit this article by going into housekeeping and choosing Manage Existing Articles.', '2008-03-22', 'Meth0d');
INSERT INTO `cms_news` VALUES ('1', 'Installation Complete', 'HoloCMS', 'http://images.habbohotel.co.uk/c_images/Top_Story_Images/topstory_accessories2.gif', 'HoloCMS was successfully installed!', 'Thank you for choosing HoloCMS! Everything appears to be working just fine..\r\n\r\nYou can edit this article by going into housekeeping and choosing Manage Existing Articles.', '2008-03-22', 'Meth0d');
INSERT INTO `cms_system` VALUES ('Marks FUSE IT', 'Mark', '0', '1', 'en', '127.0.0.1', '21', 'http://www.habbohotel.co.uk/gamedata/external?id=external_texts', 'http://www.habbohotel.co.uk/gamedata/external?id=external_variables', 'http://images.habbohotel.co.uk/dcr/r21_20080317_0342_4666_5527e6590eba8f3fb66348bdf271b5a2/habbo.dcr', 'http://www.mysite.com/cms/client.php', '0');
INSERT INTO `system` VALUES ('1', '');
INSERT INTO `system_config` VALUES ('game_port', '90');
INSERT INTO `system_config` VALUES ('lang', 'en');
INSERT INTO `system_config` VALUES ('game_maxconnections', '400');
INSERT INTO `system_config` VALUES ('mus_port', '91');
INSERT INTO `system_config` VALUES ('mus_maxconnections', '100');
INSERT INTO `system_config` VALUES ('mus_host', '127.0.0.1'); like is this the sql

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

real nicee mann imm try get this setted up:)

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

Quote:

Originally Posted by CujoDaMan

You'll have to set up your MySQL Server.

Then on google search "Navicate Lite"

Try finding a Holograph Elemunator Tut, that'll explain it. I have to go.. I'll be back in a bit.

do i have to download this installions from hereC:\Documents and Settings\Guest\Desk...l\install.html

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

nice looks cool is this just the cms or cms and server ?

Laters,

Re: [REL/DEV] MarkCMS (Marks FUSE IT Server CMS) [REL/DEV]

The server is included the first link which says Marks FUSE IT Server that's the server.. Then MarkCMS is the CMS just by it self. I can include the server with the CMS in future releses if you wish :)

Also, yes Andre the stuff to download in that guide is the stuff you'll need to use for the CMS.