lexkymbeth
-
Posts
382 -
Joined
-
Last visited
Never
Content Type
Profiles
Forums
Calendar
Posts posted by lexkymbeth
-
-
Yes, this is not meant for something like that. I created it to fix gaps in tables that do not need "Unique ID's"
Its meant for things such as posts where they are deleted, not specific information -
> IDs in a database should never be changed, having gaps is absolutely fine and isn't something you should worry about.
Why should they never be changed? I do not see a problem with changing them.. Everything still works with my program and website after doing this. Although there is another way to get past gaps I found this useful for OCD :S (lol) -
Don't know the real name to this so I guess 'refit' works.
This php function fixes indexes after you remove an item, say you have 5 rows and you delete the 4th you now have (1,2,3,5)
This function will fix that so there are no missing indexes, (1,2,3,4) Its basic and there could be better ways but this is how I did it
Arguments of mysql as mysqli object, and table as string
```
function fixRows($mysqli, $table) {
$result = $mysqli->query("SELECT * FROM `$table` ORDER BY `Index`");
$count = 1;
while($row = mysqli_fetch_array($result)) {
if($row['Index'] != $count) {
$oldIndex = $row['Index'];
if(!$mysqli->query("UPDATE `$table` SET `Index`='$count' WHERE `Index`=$oldIndex")){
die('Error: ' . mysqli_error($mysqli));
}
}
$count++;
if(!$mysqli->query("ALTER TABLE `$table` AUTO_INCREMENT = $count")){
die('Error: ' . mysqli_error($mysqli));
}
}
}
``` -
1\. You send all the files over but the src folder. This will allow the client to connect to the server and have all the graphics
2\. No you have to share it, just don't send the source
3\. Other people cant connect to your local host you have to port forward and use your internet IP, and no it does not send graphics see #1
4\. You can edit the character sprite and draw one, or program it in (Create a shadow image to render under the sprite) -
Reminds me of graal :S Much sharper/modern graal
-
I could offer up my time also, anyone language doesn't mater I know most of the common languages. I have an engine started in C#/.Net (Its not finished though)
-
Few questions, (Sorry if this is all on the facebook, cant reach facebook at school)
What engine are you planing to use? If custom what language?
What type of 2d game? (Side scrolling, tiled, pixel-movement)
Sounds interesting… -
Ive only seen people play it on twitch, it looks very time consuming you have to wait to gain points to do anything big…
-
If I could never get it to work, I can only play for 5 min or so then it BSOD's :S It looks like a really fun game
-
The only thing similar to minecraft is the tiles, although in Wurm you can level tiles so you can build on it, almost has nothing to do with boxes its just how the land works
-
Its created in java, you can create your own textures and models if you would like it downloads a defualt texture and sound pack you can change pretty sure I have to check when I get home
-
**Currently working on Space Wars 2.0 (SWIFT, More FPS, ECT)**
Hello, just posting some of my work on IOS :S The apps showcased here are released
The Space Wars ($0.99) ~ [https://itunes.apple.com/us/app/the-space-wars/id898526245?ls=1&mt=8](https://itunes.apple.com/us/app/the-space-wars/id898526245?ls=1&mt=8)
(Since I'm legaly not old enough to have my own developer account my its in my mothers name)
The Space Wars is an arcade game written in AS3, currently in upgrade for IOS8 with new SWIFT language (Much faster than AS3)
The new version will be free with advertisements you can pay to remove
>!    
The Spartan Post (Free) ~ [https://itunes.apple.com/us/app/spartan-post/id819479501?ls=1&mt=8](https://itunes.apple.com/us/app/spartan-post/id819479501?ls=1&mt=8)
(The account is under my school, they first got me this account.)
This app is going to be under edits for the new language & _IOS8_ but working on 4 apps at a time is hard :S
Its basically an app that brings my school together with news, morning videos, scores (soon) contacts push notifications ect. All data on the app can be edited by a website written in php
>! The screen shots are older than the app sorry XD I should update them…
SOON:
A Game of some sorts dealing with you (the player) being an antivirus and fighting off viruses ~ (Free with advertisements and buying levels / antivirus upgrades)
A app for the high school football ref's to check ruling on plays and penalties ($10.00 ~ could change this was recommended by my computer teacher (He is a ref)) -
Forgot to say you can build ships to sail between servers and wage wars on the other servers kingdom
-
No its not about worms.
[http://www.wurmonline.com/](http://www.wurmonline.com/)
'The Sandbox MMO' Voxelbased Sandbox MMO
Awesome game you can do pretty much anything in midevil time, create a house, a kingdom, a boat/ship, fight giant spiders, dragons wolf bear ect
The game is really immerse you have to cut down trees then sit there and craft logs for hours (This part is boring…) Mine ores (Its voxel based) clear/flatten land
I've only played the game up till creating my own house (took 24 hours) last year, lost my username/password :S
Has anyone played this? I get bored starting over alone D: -
Speak about how OOP is important
-
There is no sub playertarget? If your ripping from another engine you should also get its dependencies the sub you have there just does checks playertarget will do the action
-
Try
```
If bestIndex > 0 And bestIndex <> myTarget Then
call playertarget(bestIndex, TARGET_TYPE_NPC) // I always found it odd how some subs (not all) need to be called :S
End If
```
Looks like playertarget (the sub or function) is missing did you type it exact?if you named the sub, playerTarget then it needs to be playerTarget (case matters) -
Look at how the other editors work they ask for the data than you can edit it and send it back. This just send the data to the client with out asking and everyone has the serials in there memory + Checks on client side :S Easy fix just looks like a few tweaks
-
Are you sure there is no white in the tileset?
-
> Sorry dude, nothing pisses me off more than minecraft…. I used to run servers with lex all the time, we ran some great servers and around the last year and a half the game just filled with kids begging for staff, ranks, trolls, kids attempting to scam and failing... that's all it really is. In the past it was great, you had great communities awesome servers, factions, townies, people playing for the enjoyment of the game. now it's like everyone and their mothers owns a server and kids don't learn to respect rules of a community,
I don't play minecraft anymore I created the topic because mojang is not owned by notch anymore. wanted to see what others though since I spend two years? I think it was two years of my life with crest n' servers
Microsoft bought mojang (I think) because they only appeal to older folk. What kid would buy a windows phone when everyone else has iPhones? xD Now that they have minecraft they can monopolize off of children (Their parents money)
What I really hate is how they changed their eula and then this happens not to far after XD -
What is next O.o wonder what they will do…
-
> …..................................................................................................
>
> Post below or at Skywyre.net to claim your spot! -
Just a heads up its not very safe to do checks on the client, nor sending them hidden data (like all the serials) The client should send a code and then the server checks the code not the other way around. Some one could use a packet editor/reader to find the serials when they are sent to the client
```
If txtCode.Text = Serial(a).Name Then
```
– Client side, should be server side, shouldn't send Serials to the client. Do checks on the server -
> A little heads up for 1.3 daro and myself, have planned a few features not before done by eclipse and thats another reason we're deciding to go closed source.
Next your going to want money and start selling it as eclipse 4.0 :P
*Joke*
(PHP,MYSQL) Function to 'refit' indexes
in Programming
Posted
There is no comments on this, or likes just a feed of news what I created it for, It does not need a static ID because nothing else references it