Ask Lopdo

Talk about anything that comes in your mind and isn't related to Vortex Wars

Re: Ask Lopdo

Postby Ratburntro44 » Thu Aug 29, 2013 6:07 pm

Joshua wrote:
Ratburntro44 wrote:
Joshua wrote:You write it then.

I don't have access to Lopdo's database. Nor do I even want all the names to be capitalized.

So write it without the database, just write it in a post.

Haven't tested it, but this should work:
Code: Select all
$db_host = '';
$db_name = '';
$db_user = '';
$db_pass = '';
$db_port = '';

$table_user = '';

$column_id = '';
$column_username = '';

$connection = new mysqli($db_host,$db_user,$db_pass,$db_name,$db_port);

$names = $connection->query("SELECT $column_username FROM $table_user ORDER BY $column_id ASC");

$names_array = $names->fetch_array(MYSQLI_NUM);

$counter = 0;

while(isset($names_array[$counter])) {
   $names_caps = ucfirst($names_array[$counter]);
   $user_id = $counter+1;
   $connection->query("UPDATE $table_user SET $column_username=$names_caps WHERE $column_id=$user_id")
   $counter++;
}

Obviously a few variables need to be given values, because I don't know what those values are without going into phpbb and Lopdo's database. Other than that, I think it should work.
User avatar
Ratburntro44

 
Posts: 5928
Joined: Tue Jul 12, 2011 1:23 am

Re: Ask Lopdo

Postby Joshua » Thu Aug 29, 2013 6:35 pm

Ratburntro44 wrote:
Joshua wrote:
Ratburntro44 wrote:I don't have access to Lopdo's database. Nor do I even want all the names to be capitalized.

So write it without the database, just write it in a post.

Haven't tested it, but this should work:
Code: Select all
$db_host = '';
$db_name = '';
$db_user = '';
$db_pass = '';
$db_port = '';

$table_user = '';

$column_id = '';
$column_username = '';

$connection = new mysqli($db_host,$db_user,$db_pass,$db_name,$db_port);

$names = $connection->query("SELECT $column_username FROM $table_user ORDER BY $column_id ASC");

$names_array = $names->fetch_array(MYSQLI_NUM);

$counter = 0;

while(isset($names_array[$counter])) {
   $names_caps = ucfirst($names_array[$counter]);
   $user_id = $counter+1;
   $connection->query("UPDATE $table_user SET $column_username=$names_caps WHERE $column_id=$user_id")
   $counter++;
}

Obviously a few variables need to be given values, because I don't know what those values are without going into phpbb and Lopdo's database. Other than that, I think it should work.

How do you know this shit
Xerxes:Let us reason. It would be a waste. It would be madness for you and your troops to perish because of a misunderstanding. There is much our cultures could share.
Leonidas:Haven't you noticed? We've been sharing our culture with you all morning.
User avatar
Joshua

 
Posts: 3652
Joined: Fri Jul 22, 2011 1:34 pm
Location: In a toaster. Long story.

Re: Ask Lopdo

Postby Fangfallen » Fri Aug 30, 2013 6:04 am

Joshua wrote:How do you know this shit


How do you not? It's coding, not too difficult, I'm sure you could find some online courses if you wanted to learn.
VortexWars Rulebook

A Wolf at heart ~ RIP
User avatar
Fangfallen

 
Posts: 6939
Joined: Fri Jul 22, 2011 10:34 pm

Re: Ask Lopdo

Postby Joshua » Fri Aug 30, 2013 11:21 am

Fangfallen wrote:
Joshua wrote:How do you know this shit


How do you not? It's coding, not too difficult, I'm sure you could find some online courses if you wanted to learn.

I don't want to learn. I'm just curious as to how a 14 year old can be asked to.
Xerxes:Let us reason. It would be a waste. It would be madness for you and your troops to perish because of a misunderstanding. There is much our cultures could share.
Leonidas:Haven't you noticed? We've been sharing our culture with you all morning.
User avatar
Joshua

 
Posts: 3652
Joined: Fri Jul 22, 2011 1:34 pm
Location: In a toaster. Long story.

Re: Ask Lopdo

Postby Autumnwolf17 » Fri Sep 06, 2013 9:38 pm

I'm curious, do you think your next game will come out within a few months? Because a lot of us are beginning to leave and we kind of had wanted to follow you to your next game...
~ Wolf
User avatar
Autumnwolf17

 
Posts: 10764
Joined: Thu Aug 23, 2012 1:29 am

Re: Ask Lopdo

Postby Lopdo » Fri Sep 06, 2013 10:04 pm

I am almost certain it will not come out this year :/ I can't get enough time to work on it. But when it's ready it will be on kongregate and armorgames which I think most of you use, so you can follow me there (if it's even possible) and maybe you get info when something happens?
Quis custodiet ipsos custodes?

- Feel free to correct all my grammar mistakes -
User avatar
Lopdo
Site Admin
 
Posts: 2691
Joined: Sat May 28, 2011 3:14 pm

Re: Ask Lopdo

Postby Autumnwolf17 » Fri Sep 06, 2013 10:17 pm

Lopdo wrote:I am almost certain it will not come out this year :/ I can't get enough time to work on it. But when it's ready it will be on kongregate and armorgames which I think most of you use, so you can follow me there (if it's even possible) and maybe you get info when something happens?

Okay, I will see if I can get contact with my clan for everyone leaving before then.
~ Wolf
User avatar
Autumnwolf17

 
Posts: 10764
Joined: Thu Aug 23, 2012 1:29 am

Re: Ask Lopdo

Postby Fangfallen » Fri Sep 06, 2013 11:39 pm

Why "Vortex" Wars? Why not Territory Wars, or something else? Don't get me wrong, I like the name alot, I am just wondering why you named it such.
VortexWars Rulebook

A Wolf at heart ~ RIP
User avatar
Fangfallen

 
Posts: 6939
Joined: Fri Jul 22, 2011 10:34 pm

Re: Ask Lopdo

Postby Lopdo » Fri Sep 06, 2013 11:51 pm

because it sounds sort of cool... I went through lot of names, but all good are already taken so I had to come up with something less common
Quis custodiet ipsos custodes?

- Feel free to correct all my grammar mistakes -
User avatar
Lopdo
Site Admin
 
Posts: 2691
Joined: Sat May 28, 2011 3:14 pm

Re: Ask Lopdo

Postby calleharnemark » Fri Sep 06, 2013 11:54 pm

Lopdo wrote:because it sounds sort of cool... I went through lot of names, but all good are already taken so I had to come up with something less common

Will your next game game be called Otaku cleanup?
The guards gaze at you:"Prepare yourselves" If you get the game that is from you are awesome.
http:/us10.chatzy.com/12517185740288
Crystal Meth before: ( ͡° ͜ʖ ͡°) After: ( ͡O ͜ʖ ͡O)
Attention: the new and improved vortexwars chat!
User avatar
calleharnemark

 
Posts: 4011
Joined: Mon Sep 03, 2012 2:56 pm
Location: Inside your closet watching you undress.

PreviousNext

Return to General discussion

Who is online

Users browsing this forum: No registered users and 14 guests