• Unfortunately, we have experienced significant hard drive damage that requires urgent maintenance and rebuilding. The forum will be a state of read only until we install our new drives and rebuild all the configurations needed. Please follow our Facebook page for updates, we will be back up shortly! (The forum could go offline at any given time due to the nature of the failed drives whilst awaiting the upgrades.) When you see an Incapsula error, you know we are in the process of migration.

Database conversion

Status
Not open for further replies.
Newbie Spellweaver
Joined
Mar 28, 2012
Messages
80
Reaction score
44
Hey Folks;

for my travian-projekt i have this problem :

PHP:
function get_user($spalte,$userid) { // Userdaten holen 
$sql ='SELECT '.$spalte.' FROM player_key_users where key_usr_id=\''.$userid.'\'';  
$result = mysql_query($sql) OR die(mysql_error());    
$user = mysql_fetch_assoc($result); 
return $user;
}  

function update_user($updatewerte, $userid) { 
	
$update = 'UPDATE player_key_users SET '.$updatewerte.' WHERE key_usr_id=\''.$userid.'\'';
$updatetrue=mysql_query($update);	

return $updatetrue;

What must i change that it will goes with the databasestructure from travian?
I use google, but i found nothing that helps me and i'm not firm enough in mysql :mellow:

please help as fast as possible :)

best wishes
Ralf
 
Last edited:
Status
Not open for further replies.
Back
Top