Reply to thread

Message

<blockquote data-quote="Gajeel" data-source="post: 108810" data-attributes="member: 7688">Hello!&nbsp;I'll be posting common problems and post on how to troubleshoot them. These may be in range from emulator - client, up to CMS problem.&nbsp;1. Phoenix Emulator: Data truncated for column 'stamp' at row 1This is common for those who are having MySQL strict mode. Here is a query you have to run inorder to let the emulator read your server_status properly:[CODE]SET @@global.sql_mode= '';[/CODE]&nbsp;2. Setting spawn room (also known as homeroom) for usersIf you have existing users with different room IDs, we can make them spawn back to the room you want by running this query:[CODE]UPDATE users SET `home_room` = 'ROOMID'[/CODE]&nbsp;This step is only applicable to Navicat.Now we would like new users to be spawned to that room. Go to Navicat, open your database, right-click the 'users' table and select &quot;Design Table&quot;.&nbsp;It should take you a screen similar to this:<img src="http://vineen.in/i/455471135135.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />&nbsp;Click home_room, then on the default field type in the ROOM ID.a. How do I know the ROOMID of the room I want to be the spawning room?Go to the room, click Room info and something similar will appear like this:<img src="http://vineen.in/i/685663726993.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />&nbsp;Or you may go to the database, open 'rooms' table, Ctrl + F then type the room name and the room id will appear, something similar like this:<img src="http://vineen.in/i/15379728047.png" alt="" class="fr-fic fr-dii fr-draggable " style="" />The first column states the room ID.&nbsp;3. Client white screenThere are alot of reasons why users gets a white screen client instead of loading one. Here I'll be stating several good fixes which are effective.&nbsp;a. The SWFs and external_variables are all sat up, but I'm still getting a white screenReplace your client.php with this:[PHP]&lt;!DOCTYPE html&gt;&lt;html lang=&quot;en&quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &lt;head&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;meta http-equiv=&quot;content-type&quot; content=&quot;text/html; charset=utf-8&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;title&gt;{hotelName} - Client&lt;/title&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;link rel=&quot;stylesheet&quot; href=&quot;{url}/app/tpl/skins/Habbo/styles/client.css&quot; type=&quot;text/css&quot;&gt;&nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot; src=&quot;{url}/app/tpl/skins/Habbo/js/swfobject.js&quot;&gt;&lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var BaseUrl = &quot;{swf_folder}&quot;;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var flashvars =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;client.starting&quot; : &quot;{username} is now loading {hotelName}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;client.allow.cross.domain&quot; : &quot;1&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;client.notify.cross.domain&quot; : &quot;0&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;connection.info.host&quot; : &quot;{server_ip}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;connection.info.port&quot; : &quot;30000&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;site.url&quot; : &quot;{url}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;url.prefix&quot; : &quot;{url}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;client.reload.url&quot; : &quot;{url}/client&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;client.fatal.error.url&quot; : &quot;{url}/me&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;client.connection.failed.url&quot; : &quot;{url}/me&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;external.variables.txt&quot; : &quot;{external_vars}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;external.texts.txt&quot; : &quot;{external_texts}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;productdata.load.url&quot; : &quot;{product_data}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;furnidata.load.url&quot; : &quot;{furni_data}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;use.sso.ticket&quot; : &quot;1&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;sso.ticket&quot; : &quot;{sso}&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;processlog.enabled&quot; : &quot;0&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;flash.client.url&quot; : BaseUrl,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;flash.client.origin&quot; : &quot;popup&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; var params =&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;base&quot; : BaseUrl + &quot;/&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;allowScriptAccess&quot; : &quot;always&quot;,&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &quot;menu&quot; : &quot;false&quot;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; };&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; swfobject.embedSWF(BaseUrl + &quot;/Habbo.swf&quot;, &quot;client&quot;, &quot;100%&quot;, &quot;100%&quot;, &quot;10.0.0&quot;, &quot;{swf_folder}/expressInstall.swf&quot;, flashvars, params, null);&nbsp; &nbsp; &nbsp; &nbsp; &lt;/script&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;script src=&quot;https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js&quot;&gt;&lt;/script&gt;&nbsp;&nbsp;&lt;script type=&quot;text/javascript&quot;&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; var id = 48;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; $(document).ready(function(){&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; $.getJSON(&quot;http://*****.com/index.php?page=vote&quot;, { id: id, hasVoted: 'unknown' }, function(data) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; if(data == 2) {&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; window.location.replace(&quot;http://*****.com/index.php?page=vote&amp;id=&quot; + id);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; }&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; });&nbsp; &nbsp; });&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &lt;/script&gt;&nbsp; &nbsp; &lt;/head&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;body&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;div id=&quot;client&quot;&gt;&lt;/div&gt;&nbsp;&nbsp; &nbsp; &nbsp; &lt;/body&gt;&lt;/html&gt;[/PHP]&nbsp;b. I did not modify anything on the SWF pack I hadCheck out your r63 folder and see whether your external_variables.txt points out to your VPS/Hamachi/Personal IP and not to someone else. If it is, see if those directories are actually existing. Also make sure the .SWF files are alright and aren't corrupted.&nbsp;This is not yet the end of the thread.. I'll be adding more later. <img src="/styles/default/xenforo/smilies/emojione/smile.png"&nbsp; class="smilie" loading="lazy" alt=":)" title="Smile&nbsp; &nbsp; :)" data-shortname=":)" /></blockquote>

[QUOTE="Gajeel, post: 108810, member: 7688"] Hello! I'll be posting common problems and post on how to troubleshoot them. These may be in range from emulator - client, up to CMS problem. [B]1. Phoenix Emulator: Data truncated for column 'stamp' at row 1[/B] This is common for those who are having MySQL strict mode. Here is a query you have to run inorder to let the emulator read your server_status properly: [CODE]SET @@global.sql_mode= '';[/CODE] [B]2. Setting spawn room (also known as homeroom) for users[/B] If you have existing users with different room IDs, we can make them spawn back to the room you want by running this query: [CODE]UPDATE users SET `home_room` = 'ROOMID'[/CODE] [COLOR=#800000]This step is only applicable to Navicat.[/COLOR] Now we would like new users to be spawned to that room. Go to Navicat, open your database, right-click the 'users' table and select "[B]Design Table[/B]". It should take you a screen similar to this: [IMG]http://vineen.in/i/455471135135.png[/IMG] Click home_room, then on the default field type in the ROOM ID. [INDENT=1][B]a. How do I know the ROOMID of the room I want to be the spawning room?[/B][/INDENT] Go to the room, click Room info and something similar will appear like this: [IMG]http://vineen.in/i/685663726993.png[/IMG] Or you may go to the database, open 'rooms' table, Ctrl + F then type the room name and the room id will appear, something similar like this: [IMG]http://vineen.in/i/15379728047.png[/IMG] The first column states the room ID. [B]3. Client white screen[/B] There are alot of reasons why users gets a white screen client instead of loading one. Here I'll be stating several good fixes which are effective. [INDENT=1][B]a. The SWFs and external_variables are all sat up, but I'm still getting a white screen[/B][/INDENT] Replace your client.php with this: [PHP]<!DOCTYPE html> <html lang="en"> <head> <meta http-equiv="content-type" content="text/html; charset=utf-8"> <title>{hotelName} - Client</title> <link rel="stylesheet" href="{url}/app/tpl/skins/Habbo/styles/client.css" type="text/css"> <script type="text/javascript" src="{url}/app/tpl/skins/Habbo/js/swfobject.js"></script> <script type="text/javascript"> var BaseUrl = "{swf_folder}"; var flashvars = { "client.starting" : "{username} is now loading {hotelName}", "client.allow.cross.domain" : "1", "client.notify.cross.domain" : "0", "connection.info.host" : "{server_ip}", "connection.info.port" : "30000", "site.url" : "{url}", "url.prefix" : "{url}", "client.reload.url" : "{url}/client", "client.fatal.error.url" : "{url}/me", "client.connection.failed.url" : "{url}/me", "external.variables.txt" : "{external_vars}", "external.texts.txt" : "{external_texts}", "productdata.load.url" : "{product_data}", "furnidata.load.url" : "{furni_data}", "use.sso.ticket" : "1", "sso.ticket" : "{sso}", "processlog.enabled" : "0", "flash.client.url" : BaseUrl, "flash.client.origin" : "popup" }; var params = { "base" : BaseUrl + "/", "allowScriptAccess" : "always", "menu" : "false" }; swfobject.embedSWF(BaseUrl + "/Habbo.swf", "client", "100%", "100%", "10.0.0", "{swf_folder}/expressInstall.swf", flashvars, params, null); </script> <script src="https://ajax.googleapis.com/ajax/libs/jquery/1.7.1/jquery.min.js"></script> <script type="text/javascript"> var id = 48; $(document).ready(function(){ $.getJSON("http://*****.com/index.php?page=vote", { id: id, hasVoted: 'unknown' }, function(data) { if(data == 2) { window.location.replace("http://*****.com/index.php?page=vote&id=" + id); } }); }); </script> </head> <body> <div id="client"></div> </body> </html>[/PHP] [INDENT=1][B]b. I did not modify anything on the SWF pack I had[/B][/INDENT] Check out your r63 folder and see whether your external_variables.txt points out to your VPS/Hamachi/Personal IP and not to someone else. If it is, see if those directories are actually existing. Also make sure the .SWF files are alright and aren't corrupted. [I]This is not yet the end of the thread.. I'll be adding more later. :)[/I] [/QUOTE]

Verification

Reply to thread

Connect with us

Newest members