Okay, bare with me here.

Guest · Post by **Guest** » 03.05.2011, 21:35

Please don't delete this topic without first reviewing the contents fully, i'm not trying to hack you, i'm just going one step further than saying "UGGG, MAKE THIS PLZZZ!" and saving you the time of actually coding it for you as best as i can to the specs of your servers php.

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

I work as a php programmer, so I don't know how capable the current team will be in terms of capabilities, learned languages and of course, crucial time.

Before i start, i have qualifications in German and though i am more used to using English and Dutch would be happy to provide simple translations for the coding team

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

Request one:

Create a javascript (AJAX) Get query for the inbox and contracts pages, running every 3/5 seconds, to inform us dynamically when we have anew message / contract, running some kind of query like this:

In the following queries, i support php 4, the (supposedly) supported version of php used by your servers, if this is incorrect, please feel free to notify me and i will edit the syntax used in these posts.

Used syntax and variables:

`uid` = UniqueIdNumber, the auto incremental number you use to identify posts.
`inbox` = a placeHoldName for whatever you name the repository of messages in the database, this could be: `messages`, `posts` or any variations.
`$query` = a placeHoldName for the mySql query being used in the php 4 program.
`$rows = ` = a placeHoldFunction for servers which are less supportive of complicated functions, this is usable on all php 4.0 + servers, though is not supported by php 5.0 where instead $blah = $_rows['blah']; would be used, rendering `$rows=` a void/null function.
`$uidPost` = the unique id of the players inbox

inboxCheck.php page (to be accessed by AJAX):

$query = mysql_query("SELECT * FROM inbox WHERE uid=uid");
while($rows=mysql_fetch_object($query)){
$newMessages = $rows->newMessages;
if($newMessages > 0){?>
<script>document.getElementById("inbox").innerHTML = '<font color="red"><?= $newMessages; ?></font>';</script>
<? } ?>

and on every page which edits the inbox, i.e. purchase from market / send message, use:

$uid = $_GET['uid'];
$Query = mysql_query("SELECT newMessages FROM inbox WHERE uid=$uid");
while($rows=mysql_fetch_object($Query))
{
$numPosts = $rows->newMessages;
$newInput = $numPosts + 1;
$query = mysql_query("UPDATE inbox SET newMessages=$newInput WHERE uid=uid ");
}

Then an ajax / advanced javascript code will be required to post (unfortunate choice of words there, as the query will use a $_GET function, not an $_POST function) the query.the required coding for this is:

<script>
function ajaxQuery()
{
var xmlhttp;
if (window.XMLHttpRequest)
{// code for IE7+, Firefox, Chrome, Opera, Safari
xmlhttp=new XMLHttpRequest();
}
else
{// code for IE6, IE5
xmlhttp=new ActiveXObject("Microsoft.XMLHTTP");
}
xmlhttp.onreadystatechange=function()
{
if (xmlhttp.readyState==4 && xmlhttp.status==200)
{
document.getElementById('disabledInput').value=xmlhttp.responseText;

Guest · Post by **Guest** » 03.05.2011, 21:49

Also, keep in mind i have to correctly format this all and apply syntax colors to make it readable, so each of these takes bloody ages8|

BRB 15 minutes, having a short break. 00:41 (GMT+1)

pearlbay · Post by **pearlbay** » 04.05.2011, 06:50

Hi UnityGasExchange,

this is quite a bit of work you have done there, I must say.

Being merely a humble supporter, I have no idea whether what you are suggesting there works with the code as it is, and is actually implementable.

So all I can do here is pass your idea on, and have our programmers review it, as they generally do.

Please note, though, I cannot make any promises; as has been mentioned before, the versions running on S1 and S2 are not being developed any further, unless we are talking about bug-fixes and/or minor changes.

Anyway, I will pass on your ideas as well as your solutions, but, as I said, I cannot make any promises as to whether they can/will be implemented.

Best regards,

pearlbay

Guest · Post by **Guest** » 04.05.2011, 19:51

I understand this completely, hence I have done all of the work for them ;D

It just requires minor edits on their parts for variables names etc, though i know as these servers are no longer in development anymore it may not be possible, if they aren't then that is okay, this is what i do, i enjoy it, so at least I will have slightly more experience.

pearlbay · Post by **pearlbay** » 05.05.2011, 06:29

OK, I am glad to hear we understand each other, I just wanted to make sure.

As I said, I'll pass on the ideas, but cannot give any guarantees.

Cheers,

pearlbay