Search results
-
[SQL] How to get 2x value (from different storage) and divide it?
Alter your query, and check if the value is 0 in php, set it to either key1value or key2value.SELECT p.name, ps1.value AS key1value, ps2.value AS key2value, ps1.value / ps2.value AS value FROM players AS p JOIN player_storage AS ps1 ON ( ps1.key =8544 AND ps1.player_id = p.id ) JOIN... -
-
[SQL] How to get 2x value (from different storage) and divide it?
You don't need that secondary SQL statement, you can fetch all the required information from the one I provided you with. <?PHP if(file_exists($f) && filemtime($f) > (time() - $cache_sec)) $main_content = file_get_contents($f); else { mysql_pconnect($config['server']['sqlHost']... -
[SQL] How to get 2x value (from different storage) and divide it?
For a specific character:SELECT p.name, (ps1.value / ps2.value) AS value FROM players AS p JOIN player_storage AS ps1 ON (ps1.key = 8544 AND ps1.player_id = p.id) JOIN player_storage AS ps2 ON (ps2.key = 8541 AND ps2.player_id = p.id) WHERE p.name = 'CHARACTER NAME HERE' LIMIT 1; For all of... -
[SQL] How to get 2x value (from different storage) and divide it?
SELECT p.name, ps.key, ps.value FROM players AS p LEFT JOIN player_storage AS ps ON ps.player_id = p.id WHERE ps.key IN(8541, 8544); Edit: Sorry, I did not completely read your thread, was just looking at the queries themselves. Just noticed you wanted to divide your values. -
Programmer Searching a nice mate to work with. (a new AAC)
WibbenZ, I actually gave him permission to use anything from my AAC as it is more or less dead. Even if that wasn't the case, I do tend to help Raggaer out over Skype every now and then when he has issues or just needs advice. He stole nothing from me. -
Multiple gesior acc 2012 questions/problems
As far as the last issue goes, switch out the semi-colon with a regular colon in the first line. case "admin": rather than case "admin"; -
Solved Write server info to file error
I'm not sure what is causing the event to fail, but instead of using a ton of if statements to format the hours, minutes and seconds with a leading zero, something like this should probably do: local lottery = string.format("%02d:%02d:%02d", hours, minutes, second) Another thing you could do... -
Solved Write server info to file error
Send the request to the server, store the response in a file (or database), then compare the modified file timestamp (or last modified database column) with the current timestamp, if X minutes has passed, re-send the request and override the existing file (or database information) with the new... -
[Modern AAC] Signature Injection v3.1.7
I would be able to assist you through TeamViewer if that is something you would like- Chris
- Post #57
- Forum: Website Applications
-
pandaac: The Resurrection
lmao! That made my morning, haha. Unfortunately though, as I explained in another post, I am real busy with work related stuff, I'll try to squeeze in a few hours again tonight though. (:- Chris
- Post #64
- Forum: Discussion
-
pandaac: The Resurrection
Sorry for the lack of updates recently. I have been rather busy with work related stuff, and as far as these past few days goes, I have been lying in my bed with the worst cold. I will however commit a few hours of my time tonight to further the development process of pandaac. (:- Chris
- Post #59
- Forum: Discussion
-
Sunset AAC - another boring aac
While I would never discourage averatec from developing Sunset AAC, he is more than welcome to join us in the pandaac team, whether it be as a main developer or a contributor. That being said though, having competition (healthy ones ;)) is what makes a great product - as we help one another push...- Chris
- Post #25
- Forum: Discussion
-
Solved Website Errors
Did you already solve the issue? or why did you put solved as the title prefix? Either way, to fix it you would place the following at the very top of your header file, just below the opening php tags (<?php): date_default_timezone_set('timezone'); And you would then replace the 'timezone'... -
Solved Modern AAC Guilds issue
If anyone else is having this issue, it was caused by a bunch of columns not having a default value in the guilds table. Also, the checkGuildName method within the Guilds model should, rather than using the 'escape' method on the guild name, use the 'escape_str' method. Otherwise it will display... -
Solved Modern AAC Guilds issue
All right. I have very little information to go on, but if you'd like, I could try and solve it through a teamviewer session. -
Solved Modern AAC Guilds issue
Open up your browser dev console (e.g. right click -> inspect element -> console tab in Chrome). Do you get any error messages there? -
pandaac: The Resurrection
Thank you (: As for your question, I am making the AAC schema-independent. Which means that it should be able to work across any distro of your choice (as long as you have a schema model-package for it (in lack of a better word)). However, by the release I am only planning on having a schema...- Chris
- Post #54
- Forum: Discussion
-
Do you want an video tutorial of basic scripting?
I say go for it (: I always enjoy watching the occasional tutorial- Chris
- Post #2
- Forum: Programming & Scripting
-
pandaac: The Resurrection
I have, in the past few days, decided how I want to organise my schema-related models, controllers and so forth. At the moment, I'm converting my javascript into RequireJS modules for better dependency support. Nothing that really makes a difference graphical wise (which is what most people...- Chris
- Post #52
- Forum: Discussion