18.07.2007, 09:12
lets see if posting is fixed here...
thats what im doing. it causes a server crash as soon as a player connects. as best i can tell, i am doing the exact same thing you are doing.
the database is working, the userid, password, and mysqldb are all set correctly because i use them in a vehicle spawn function (that looks up vehicle id's in a sql table based on their name)...
its only when i am doing the while loop that things break.
for windows, i am using your executables entirely. on linux, i compiled the plugin, and am using a precompiled libmysqlclient from 5.0.41
as for the double post above, i apologize...but this site was having tremendous difficulty in doing anything with large posts earlier
i dont see the point of complaining about double posting on a forum anyway. if you dont do it at times, it completely does away with the intended purpose of "show new replies to your posts". this is my opinion, and thats all it is. i dont make the rules here, nor do i enforce them. i try and follow them as best i can, but with the site doing what it was doing earlier, there was no way around it.
pawn Code:
public billboard(playerid){
new conBillboard;
conBillboard = samp_mysql_connect(mysqlhost, mysqluser, mysqlpassword);
if(conBillboard == 0){
SendClientMessage(playerid,red,"Error connecting to mysql database. Please notify administrator.");
}else{
samp_mysql_select_db(mysqldb);
samp_mysql_query("select entry from billboard order by id");
samp_mysql_store_result();
new string[1024];
while(samp_mysql_fetch_row(string)){
printf("%s\n",string);
}
samp_mysql_close();
}
SetTimer("billboard",120000,0);
return 1;
}
the database is working, the userid, password, and mysqldb are all set correctly because i use them in a vehicle spawn function (that looks up vehicle id's in a sql table based on their name)...
its only when i am doing the while loop that things break.
for windows, i am using your executables entirely. on linux, i compiled the plugin, and am using a precompiled libmysqlclient from 5.0.41
as for the double post above, i apologize...but this site was having tremendous difficulty in doing anything with large posts earlier

i dont see the point of complaining about double posting on a forum anyway. if you dont do it at times, it completely does away with the intended purpose of "show new replies to your posts". this is my opinion, and thats all it is. i dont make the rules here, nor do i enforce them. i try and follow them as best i can, but with the site doing what it was doing earlier, there was no way around it.