Menu
Forums
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Trending
What's new
New posts
New profile posts
Latest activity
Members
Current visitors
New profile posts
Search profile posts
Upgrades
Log in
Register
What's new
Search
Search
Search titles only
By:
All threads
Latest threads
New posts
Trending threads
New posts
Search forums
Menu
Log in
Register
Navigation
Install the app
Install
More options
Contact us
Close Menu
Forums
Server Development
Habbo Retros
Habbo Tutorials
[Tricks & Tips] Client & Any CMS Guide!
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="Jerry" data-source="post: 274105" data-attributes="member: 35321"><p>Yo DevBest,</p><p>Imma show you how to do stuff.. Let's start..</p><p>1. Want to give all users<strong> F<img src="https://cdn.devbest.com/data/assets/smilies/REE.png" srcset="https://cdn.devbest.com/data/assets/smilies/REE.png 1x, https://cdn.devbest.com/data/assets/smilies/REE-2x.png 2x" class="smilie" loading="lazy" alt="REE" title="REE REE" data-shortname="REE" /> VIP</strong>? You may run this sql below;</p><p>[CODE]UPDATE `users` SET vip = '1'[/CODE]</p><p></p><p>2. Currently using an <u>TCP Proxy</u> but can't get access to the client? Run these sqls then do <strong>:update_settings</strong>.</p><p>[CODE]UPDATE server_settings SET enable_securesessions = '0';</p><p>UPDATE server_settings SET enable_antiddos = '1';</p><p>UPDATE server_settings SET ip_lastforbans = '1';[/CODE]</p><p></p><p>3. Missing a <strong>column</strong>? You can <u>ALWAYS</u> make one!</p><p>[CODE]ALTER TABLE `TABLENAME` ADD `COLUMNNAME` int(100) NOT NULL[/CODE]</p><p></p><p>4. Getting an<strong> MySQL error</strong> like a <u>table doesn't exist</u>? You can get the <u>table</u> from the <strong>SQL file</strong>!</p><p>Example:</p><p>[CODE]CREATE TABLE IF NOT EXISTS `bans` (</p><p> `id` int(11) NOT NULL AUTO_INCREMENT,</p><p> `bantype` enum('user','ip','machine') NOT NULL DEFAULT 'user',</p><p> `value` varchar(50) NOT NULL,</p><p> `reason` text NOT NULL,</p><p> `expire` double NOT NULL DEFAULT '0',</p><p> `added_by` varchar(50) NOT NULL,</p><p> `added_date` varchar(50) NOT NULL,</p><p> `appeal_state` enum('0','1','2') NOT NULL DEFAULT '1',</p><p> PRIMARY KEY (`id`),</p><p> UNIQUE KEY `value` (`value`),</p><p> KEY `bantype` (`bantype`)</p><p>) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;[/CODE]</p><p></p><p>5. Having trouble getting the <u>real ip of a user</u> on the website? <em>Simple</em>! Add this code where it <u>meets all the files</u>.</p><p>[CODE]if (isset($_SERVER["HTTP_CF_CONNECTING_IP"])) {</p><p> $_SERVER["REMOTE_ADDR"] = $_SERVER["HTTP_CF_CONNECTING_IP"];</p><p> }[/CODE]</p><p></p><p>6. Having trouble importing a new catalogue into <strong>Gold Tree Emulator? </strong>Enter these sqls after importing the catalogue.</p><p>[CODE]ALTER TABLE `furniture` CHANGE `interaction_type` `interaction_type` ENUM('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx','firework','wf_act_kick_user','hopper','jukebox','musicdisc','freeze_tile','freeze_counter','freeze_ice_block','freeze_blue_gate','freeze_red_gate','freeze_green_gate','freeze_yellow_gate','freeze_exit','freeze_blue_score','freeze_red_score','freeze_green_score','freeze_yellow_score','wf_act_reset_timers','wf_cnd_match_snapshot','wf_cnd_time_more_than','wf_cnd_time_less_than') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'default';</p><p>ALTER TABLE `furniture` ADD `HeightOverride` ENUM('1', '0') NOT NULL DEFAULT '0';</p><p>ALTER TABLE `catalog_items` ADD `song_id` INT(11) NOT NULL;</p><p>ALTER TABLE `catalog_items` ADD `BadgeID` VARCHAR(100) NOT NULL DEFAULT '';[/CODE]</p><p></p><p>7. <u>Client</u> doesn't work, white screen or not receiving connections to the emulator? DO the following;</p><ul> <li data-xf-list-type="ul">Open your ports</li> <li data-xf-list-type="ul">Edit Client.php</li> <li data-xf-list-type="ul">Check Emulator config</li> <li data-xf-list-type="ul">Check if Habbo.swf is correct</li> <li data-xf-list-type="ul">Edit your external_variables.txt</li> <li data-xf-list-type="ul">Clear your cache after your changes</li> </ul><p></p><p>8. Getting <strong>disconnected when you accept a friend request</strong>? Run this sql below and then you'll be fine [:</p><p>[CODE]ALTER TABLE `users` CHANGE `last_online` `last_online` TIME NOT NULL[/CODE]</p><p></p><p>9. Having troubles with <strong>news</strong>? Sure..</p><p>First Design the Table in Navicat, Find author column in `cms_news` and replace <strong>int</strong> to <strong>varchar</strong>!</p><p></p><p>10. Trying to Save Branding with tinypic or imgur but failed? It's easy! You can allow it by going to crossdomain.xml in your swfs folder. Then put what I put below;</p><p><img src="http://img22.imageshack.us/img22/4251/0cex.png" alt="" class="fr-fic fr-dii fr-draggable " style="" /></p><p>11. Getting an <strong>Field 'position' doesn't have a default value </strong>then trying to register or something like that?</p><p>Here's the solution, First: Go to Navicat, then select a table, then do <strong>CTRL + D</strong> for <u>Design Table</u> then find that column then check on <strong>NULL</strong>!</p><p></p><p>I'll be adding more tips in the future if I can. Thanks for reading this tut.</p><p>Some tips are by JayCustom!</p><p><strong>Like + Rate + Follow</strong><img src="/styles/default/xenforo/smilies/emojione/thumbsup.png" class="smilie" loading="lazy" alt=":up:" title="Thumbs Up :up:" data-shortname=":up:" /></p></blockquote><p></p>
[QUOTE="Jerry, post: 274105, member: 35321"] Yo DevBest, Imma show you how to do stuff.. Let's start.. 1. Want to give all users[B] FREE VIP[/B]? You may run this sql below; [CODE]UPDATE `users` SET vip = '1'[/CODE] 2. Currently using an [U]TCP Proxy[/U] but can't get access to the client? Run these sqls then do [B]:update_settings[/B]. [CODE]UPDATE server_settings SET enable_securesessions = '0'; UPDATE server_settings SET enable_antiddos = '1'; UPDATE server_settings SET ip_lastforbans = '1';[/CODE] 3. Missing a [B]column[/B]? You can [U]ALWAYS[/U] make one! [CODE]ALTER TABLE `TABLENAME` ADD `COLUMNNAME` int(100) NOT NULL[/CODE] 4. Getting an[B] MySQL error[/B] like a [U]table doesn't exist[/U]? You can get the [U]table[/U] from the [B]SQL file[/B]! Example: [CODE]CREATE TABLE IF NOT EXISTS `bans` ( `id` int(11) NOT NULL AUTO_INCREMENT, `bantype` enum('user','ip','machine') NOT NULL DEFAULT 'user', `value` varchar(50) NOT NULL, `reason` text NOT NULL, `expire` double NOT NULL DEFAULT '0', `added_by` varchar(50) NOT NULL, `added_date` varchar(50) NOT NULL, `appeal_state` enum('0','1','2') NOT NULL DEFAULT '1', PRIMARY KEY (`id`), UNIQUE KEY `value` (`value`), KEY `bantype` (`bantype`) ) ENGINE=MyISAM DEFAULT CHARSET=latin1 AUTO_INCREMENT=1 ;[/CODE] 5. Having trouble getting the [U]real ip of a user[/U] on the website? [I]Simple[/I]! Add this code where it [U]meets all the files[/U]. [CODE]if (isset($_SERVER["HTTP_CF_CONNECTING_IP"])) { $_SERVER["REMOTE_ADDR"] = $_SERVER["HTTP_CF_CONNECTING_IP"]; }[/CODE] 6. Having trouble importing a new catalogue into [B]Gold Tree Emulator? [/B]Enter these sqls after importing the catalogue. [CODE]ALTER TABLE `furniture` CHANGE `interaction_type` `interaction_type` ENUM('default','gate','postit','roomeffect','dimmer','trophy','bed','scoreboard','vendingmachine','alert','onewaygate','loveshuffler','habbowheel','dice','bottle','teleport','rentals','pet','roller','water','ball','bb_red_gate','bb_green_gate','bb_yellow_gate','bb_puck','bb_blue_gate','bb_patch','bb_teleport','blue_score','green_score','red_score','yellow_score','fbgate','tagpole','counter','red_goal','blue_goal','yellow_goal','green_goal','wired','wf_trg_onsay','wf_act_saymsg','wf_trg_enterroom','wf_act_moveuser','wf_act_togglefurni','wf_trg_furnistate','wf_trg_onfurni','pressure_pad','wf_trg_offfurni','wf_trg_gameend','wf_trg_gamestart','wf_trg_timer','wf_act_givepoints','wf_trg_attime','wf_trg_atscore','wf_act_moverotate','rollerskate','stickiepole','wf_xtra_random','wf_cnd_trggrer_on_frn','wf_cnd_furnis_hv_avtrs','wf_act_matchfurni','wf_cnd_has_furni_on','puzzlebox','switch','wf_act_give_phx','wf_cnd_phx','firework','wf_act_kick_user','hopper','jukebox','musicdisc','freeze_tile','freeze_counter','freeze_ice_block','freeze_blue_gate','freeze_red_gate','freeze_green_gate','freeze_yellow_gate','freeze_exit','freeze_blue_score','freeze_red_score','freeze_green_score','freeze_yellow_score','wf_act_reset_timers','wf_cnd_match_snapshot','wf_cnd_time_more_than','wf_cnd_time_less_than') CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT 'default'; ALTER TABLE `furniture` ADD `HeightOverride` ENUM('1', '0') NOT NULL DEFAULT '0'; ALTER TABLE `catalog_items` ADD `song_id` INT(11) NOT NULL; ALTER TABLE `catalog_items` ADD `BadgeID` VARCHAR(100) NOT NULL DEFAULT '';[/CODE] 7. [U]Client[/U] doesn't work, white screen or not receiving connections to the emulator? DO the following; [LIST] [*]Open your ports [*]Edit Client.php [*]Check Emulator config [*]Check if Habbo.swf is correct [*]Edit your external_variables.txt [*]Clear your cache after your changes [/LIST] 8. Getting [B]disconnected when you accept a friend request[/B]? Run this sql below and then you'll be fine [: [CODE]ALTER TABLE `users` CHANGE `last_online` `last_online` TIME NOT NULL[/CODE] 9. Having troubles with [B]news[/B]? Sure.. First Design the Table in Navicat, Find author column in `cms_news` and replace [B]int[/B] to [B]varchar[/B]! 10. Trying to Save Branding with tinypic or imgur but failed? It's easy! You can allow it by going to crossdomain.xml in your swfs folder. Then put what I put below; [IMG]http://img22.imageshack.us/img22/4251/0cex.png[/IMG] 11. Getting an [B]Field 'position' doesn't have a default value [/B]then trying to register or something like that? Here's the solution, First: Go to Navicat, then select a table, then do [B]CTRL + D[/B] for [U]Design Table[/U] then find that column then check on [B]NULL[/B]! I'll be adding more tips in the future if I can. Thanks for reading this tut. Some tips are by JayCustom! [B]Like + Rate + Follow[/B]:up: [/QUOTE]
Insert quotes…
Verification
Post reply
Forums
Server Development
Habbo Retros
Habbo Tutorials
[Tricks & Tips] Client & Any CMS Guide!
Top